PREVIEW / etf_30min / 2001-12-17
file: by_date/etf_30min/2001/2001-12-17.parquet size: 17 KB rows: 455
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-17 09:30:00 | SPY | ETF | 112.99 | 113.36 | 112.9 | 113.21 | 2748000.0 |
| 2001-12-17 10:00:00 | SPY | ETF | 113.21 | 113.76 | 113.16 | 113.68 | 2027300.0 |
| 2001-12-17 10:30:00 | SPY | ETF | 113.68 | 113.91 | 113.57 | 113.84 | 1343600.0 |
| 2001-12-17 11:00:00 | SPY | ETF | 113.81 | 114.19 | 113.81 | 113.93 | 1182000.0 |
| 2001-12-17 11:30:00 | SPY | ETF | 113.94 | 114.17 | 113.88 | 113.97 | 676100.0 |
| 2001-12-17 12:00:00 | SPY | ETF | 113.99 | 114.27 | 113.99 | 114.06 | 588800.0 |
| 2001-12-17 12:30:00 | SPY | ETF | 114.06 | 114.09 | 113.83 | 113.93 | 699000.0 |
| 2001-12-17 13:00:00 | SPY | ETF | 113.93 | 114.18 | 113.91 | 114.1 | 266100.0 |
| 2001-12-17 13:30:00 | SPY | ETF | 114.04 | 114.31 | 114.01 | 114.28 | 495500.0 |
| 2001-12-17 14:00:00 | SPY | ETF | 114.31 | 114.36 | 114.09 | 114.2 | 392000.0 |
| 2001-12-17 14:30:00 | SPY | ETF | 114.19 | 114.21 | 113.9 | 114.03 | 518000.0 |
| 2001-12-17 15:00:00 | SPY | ETF | 114.05 | 114.11 | 113.83 | 114.07 | 861500.0 |
| 2001-12-17 15:30:00 | SPY | ETF | 114.08 | 114.26 | 113.71 | 113.99 | 1139600.0 |
| 2001-12-17 16:00:00 | SPY | ETF | 113.97 | 114.3 | 113.76 | 114.3 | 562900.0 |
| 2001-12-17 16:30:00 | SPY | ETF | 114.31 | 114.31 | 114.29 | 114.29 | 2100.0 |
| 2001-12-17 17:00:00 | SPY | ETF | 114.24 | 114.26 | 114.24 | 114.26 | 500.0 |
| 2001-12-17 09:30:00 | QQQ | ETF | 40.02 | 40.6 | 40.02 | 40.5 | 8387500.0 |
| 2001-12-17 10:00:00 | QQQ | ETF | 40.49 | 40.94 | 40.43 | 40.77 | 8049900.0 |
| 2001-12-17 10:30:00 | QQQ | ETF | 40.77 | 40.89 | 40.65 | 40.77 | 5294100.0 |
| 2001-12-17 11:00:00 | QQQ | ETF | 40.78 | 40.94 | 40.58 | 40.61 | 4487100.0 |
| 2001-12-17 11:30:00 | QQQ | ETF | 40.62 | 40.78 | 40.57 | 40.7 | 3270300.0 |
| 2001-12-17 12:00:00 | QQQ | ETF | 40.7 | 40.89 | 40.66 | 40.73 | 3066200.0 |
| 2001-12-17 12:30:00 | QQQ | ETF | 40.73 | 40.78 | 40.6 | 40.68 | 1782400.0 |
| 2001-12-17 13:00:00 | QQQ | ETF | 40.68 | 40.89 | 40.65 | 40.81 | 1918300.0 |
| 2001-12-17 13:30:00 | QQQ | ETF | 40.81 | 41.12 | 40.8 | 41.1 | 5686700.0 |
| 2001-12-17 14:00:00 | QQQ | ETF | 41.13 | 41.24 | 41.04 | 41.19 | 5126400.0 |
| 2001-12-17 14:30:00 | QQQ | ETF | 41.19 | 41.19 | 40.97 | 40.98 | 3362800.0 |
| 2001-12-17 15:00:00 | QQQ | ETF | 41.0 | 41.06 | 40.81 | 40.95 | 3672000.0 |
| 2001-12-17 15:30:00 | QQQ | ETF | 40.97 | 41.09 | 40.7 | 40.82 | 5474400.0 |
| 2001-12-17 16:00:00 | QQQ | ETF | 40.84 | 41.04 | 40.74 | 40.85 | 1520700.0 |
| 2001-12-17 16:30:00 | QQQ | ETF | 40.88 | 40.91 | 40.85 | 40.85 | 4100.0 |
| 2001-12-17 17:00:00 | QQQ | ETF | 40.85 | 40.87 | 40.83 | 40.83 | 8900.0 |
| 2001-12-17 17:30:00 | QQQ | ETF | 40.85 | 40.86 | 40.82 | 40.83 | 6300.0 |
| 2001-12-17 18:00:00 | QQQ | ETF | 40.83 | 40.86 | 40.82 | 40.86 | 6000.0 |
| 2001-12-17 09:30:00 | IWM | ETF | 46.83 | 47.19 | 46.83 | 47.165 | 20200.0 |
| 2001-12-17 10:00:00 | IWM | ETF | 47.165 | 47.57 | 47.13 | 47.55 | 73600.0 |
| 2001-12-17 10:30:00 | IWM | ETF | 47.425 | 47.595 | 47.35 | 47.535 | 53600.0 |
| 2001-12-17 11:00:00 | IWM | ETF | 47.525 | 47.54 | 47.295 | 47.305 | 64600.0 |
| 2001-12-17 11:30:00 | IWM | ETF | 47.36 | 47.39 | 47.305 | 47.315 | 83600.0 |
| 2001-12-17 12:00:00 | IWM | ETF | 47.38 | 47.4 | 47.2 | 47.21 | 16200.0 |
| 2001-12-17 12:30:00 | IWM | ETF | 47.205 | 47.25 | 47.03 | 47.16 | 49400.0 |
| 2001-12-17 13:00:00 | IWM | ETF | 47.16 | 47.335 | 47.1 | 47.335 | 51200.0 |
| 2001-12-17 13:30:00 | IWM | ETF | 47.305 | 47.35 | 47.125 | 47.2 | 57600.0 |
| 2001-12-17 14:00:00 | IWM | ETF | 47.315 | 47.4 | 47.15 | 47.255 | 75000.0 |
| 2001-12-17 14:30:00 | IWM | ETF | 47.3 | 47.4 | 47.215 | 47.325 | 33200.0 |
| 2001-12-17 15:00:00 | IWM | ETF | 47.35 | 47.375 | 47.175 | 47.335 | 62200.0 |
| 2001-12-17 15:30:00 | IWM | ETF | 47.26 | 47.57 | 47.26 | 47.57 | 57200.0 |
| 2001-12-17 16:00:00 | IWM | ETF | 47.07 | 47.85 | 47.07 | 47.85 | 48200.0 |
| 2001-12-17 09:30:00 | DIA | ETF | 98.35 | 98.75 | 98.34 | 98.67 | 488300.0 |
| 2001-12-17 10:00:00 | DIA | ETF | 98.67 | 99.09 | 98.6 | 99.02 | 596000.0 |
> showing 50 of 455 rows — these rows as CSV