PREVIEW / etf_30min / 2002-04-08
file: by_date/etf_30min/2002/2002-04-08.parquet size: 18 KB rows: 483
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2002-04-08 09:30:00 | SPY | ETF | 111.32 | 111.85 | 111.23 | 111.79 | 2465800.0 |
| 2002-04-08 10:00:00 | SPY | ETF | 111.84 | 111.98 | 111.58 | 111.78 | 2027600.0 |
| 2002-04-08 10:30:00 | SPY | ETF | 111.79 | 112.14 | 111.74 | 111.8 | 1297800.0 |
| 2002-04-08 11:00:00 | SPY | ETF | 111.81 | 111.98 | 111.64 | 111.88 | 975300.0 |
| 2002-04-08 11:30:00 | SPY | ETF | 111.92 | 112.09 | 111.83 | 111.97 | 542100.0 |
| 2002-04-08 12:00:00 | SPY | ETF | 111.94 | 112.07 | 111.81 | 112.02 | 718700.0 |
| 2002-04-08 12:30:00 | SPY | ETF | 111.98 | 112.2 | 111.95 | 112.11 | 491000.0 |
| 2002-04-08 13:00:00 | SPY | ETF | 112.11 | 112.45 | 112.1 | 112.44 | 618200.0 |
| 2002-04-08 13:30:00 | SPY | ETF | 112.42 | 112.49 | 112.23 | 112.28 | 887900.0 |
| 2002-04-08 14:00:00 | SPY | ETF | 112.29 | 112.85 | 112.29 | 112.75 | 1841000.0 |
| 2002-04-08 14:30:00 | SPY | ETF | 112.74 | 112.78 | 112.52 | 112.65 | 573000.0 |
| 2002-04-08 15:00:00 | SPY | ETF | 112.66 | 112.82 | 112.45 | 112.82 | 734400.0 |
| 2002-04-08 15:30:00 | SPY | ETF | 112.85 | 112.88 | 112.44 | 112.8 | 957400.0 |
| 2002-04-08 16:00:00 | SPY | ETF | 112.81 | 113.03 | 112.76 | 112.84 | 1074400.0 |
| 2002-04-08 16:30:00 | SPY | ETF | 112.89 | 113.13 | 112.89 | 113.13 | 412600.0 |
| 2002-04-08 17:00:00 | SPY | ETF | 113.12 | 113.19 | 113.08 | 113.1 | 44000.0 |
| 2002-04-08 17:30:00 | SPY | ETF | 113.18 | 113.18 | 113.18 | 113.18 | 500.0 |
| 2002-04-08 18:00:00 | SPY | ETF | 113.18 | 113.19 | 113.05 | 113.19 | 6100.0 |
| 2002-04-08 09:30:00 | QQQ | ETF | 33.47 | 33.76 | 33.46 | 33.67 | 9805200.0 |
| 2002-04-08 10:00:00 | QQQ | ETF | 33.67 | 33.71 | 33.42 | 33.52 | 7111100.0 |
| 2002-04-08 10:30:00 | QQQ | ETF | 33.53 | 33.71 | 33.5 | 33.59 | 6122000.0 |
| 2002-04-08 11:00:00 | QQQ | ETF | 33.6 | 33.8 | 33.52 | 33.72 | 3917800.0 |
| 2002-04-08 11:30:00 | QQQ | ETF | 33.72 | 33.85 | 33.68 | 33.79 | 4174500.0 |
| 2002-04-08 12:00:00 | QQQ | ETF | 33.79 | 33.84 | 33.7 | 33.82 | 2001400.0 |
| 2002-04-08 12:30:00 | QQQ | ETF | 33.82 | 33.94 | 33.78 | 33.9 | 2543800.0 |
| 2002-04-08 13:00:00 | QQQ | ETF | 33.91 | 34.34 | 33.89 | 34.32 | 5178500.0 |
| 2002-04-08 13:30:00 | QQQ | ETF | 34.32 | 34.37 | 34.16 | 34.25 | 4628400.0 |
| 2002-04-08 14:00:00 | QQQ | ETF | 34.25 | 34.75 | 34.22 | 34.63 | 8645200.0 |
| 2002-04-08 14:30:00 | QQQ | ETF | 34.62 | 34.64 | 34.4 | 34.5 | 6240500.0 |
| 2002-04-08 15:00:00 | QQQ | ETF | 34.53 | 34.62 | 34.33 | 34.59 | 3625200.0 |
| 2002-04-08 15:30:00 | QQQ | ETF | 34.59 | 34.7 | 34.35 | 34.7 | 4806000.0 |
| 2002-04-08 16:00:00 | QQQ | ETF | 34.67 | 34.9 | 34.44 | 34.83 | 1802400.0 |
| 2002-04-08 16:30:00 | QQQ | ETF | 34.84 | 35.0 | 34.76 | 34.96 | 489000.0 |
| 2002-04-08 17:00:00 | QQQ | ETF | 34.97 | 35.06 | 34.91 | 34.92 | 106100.0 |
| 2002-04-08 17:30:00 | QQQ | ETF | 34.94 | 34.95 | 34.92 | 34.94 | 21600.0 |
| 2002-04-08 18:00:00 | QQQ | ETF | 34.93 | 34.97 | 34.92 | 34.97 | 27000.0 |
| 2002-04-08 09:30:00 | IWM | ETF | 49.005 | 49.24 | 49.0 | 49.2 | 61400.0 |
| 2002-04-08 10:00:00 | IWM | ETF | 49.16 | 49.18 | 49.13 | 49.13 | 17400.0 |
| 2002-04-08 10:30:00 | IWM | ETF | 49.17 | 49.25 | 49.13 | 49.23 | 67600.0 |
| 2002-04-08 11:00:00 | IWM | ETF | 49.23 | 49.23 | 49.14 | 49.225 | 116400.0 |
| 2002-04-08 11:30:00 | IWM | ETF | 49.23 | 49.31 | 49.225 | 49.23 | 13000.0 |
| 2002-04-08 12:00:00 | IWM | ETF | 49.24 | 49.38 | 49.24 | 49.38 | 519600.0 |
| 2002-04-08 12:30:00 | IWM | ETF | 49.42 | 49.51 | 49.41 | 49.48 | 34200.0 |
| 2002-04-08 13:00:00 | IWM | ETF | 49.52 | 49.745 | 49.52 | 49.685 | 27600.0 |
| 2002-04-08 13:30:00 | IWM | ETF | 49.75 | 49.785 | 49.7 | 49.77 | 57400.0 |
| 2002-04-08 14:00:00 | IWM | ETF | 49.77 | 50.045 | 49.77 | 50.045 | 37800.0 |
| 2002-04-08 14:30:00 | IWM | ETF | 50.02 | 50.02 | 49.925 | 49.925 | 18200.0 |
| 2002-04-08 15:00:00 | IWM | ETF | 49.905 | 49.995 | 49.9 | 49.915 | 22200.0 |
| 2002-04-08 15:30:00 | IWM | ETF | 49.925 | 50.07 | 49.925 | 50.07 | 104800.0 |
| 2002-04-08 16:00:00 | IWM | ETF | 50.07 | 50.17 | 50.065 | 50.17 | 46000.0 |
> showing 50 of 483 rows — these rows as CSV