PREVIEW / etf_30min / 2000-11-14
file: by_date/etf_30min/2000/2000-11-14.parquet size: 12 KB rows: 286
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 |
|---|---|---|---|---|---|---|---|
| 2000-11-14 09:30:00 | SPY | ETF | 137.4688 | 137.9375 | 137.0 | 137.0625 | 1390000.0 |
| 2000-11-14 10:00:00 | SPY | ETF | 137.125 | 137.9688 | 137.0312 | 137.75 | 413700.0 |
| 2000-11-14 10:30:00 | SPY | ETF | 137.6562 | 138.2188 | 137.6562 | 138.0625 | 612200.0 |
| 2000-11-14 11:00:00 | SPY | ETF | 138.0 | 138.0938 | 137.625 | 137.6562 | 345300.0 |
| 2000-11-14 11:30:00 | SPY | ETF | 137.8125 | 138.25 | 137.4062 | 137.8438 | 334400.0 |
| 2000-11-14 12:00:00 | SPY | ETF | 137.9375 | 138.1875 | 137.6875 | 137.75 | 182500.0 |
| 2000-11-14 12:30:00 | SPY | ETF | 137.8438 | 139.625 | 137.6875 | 138.625 | 803000.0 |
| 2000-11-14 13:00:00 | SPY | ETF | 138.625 | 139.0938 | 138.5 | 138.875 | 685200.0 |
| 2000-11-14 13:30:00 | SPY | ETF | 138.8125 | 139.0312 | 138.625 | 139.0 | 213100.0 |
| 2000-11-14 14:00:00 | SPY | ETF | 139.0 | 139.5 | 139.0 | 139.25 | 365600.0 |
| 2000-11-14 14:30:00 | SPY | ETF | 139.3438 | 139.5 | 138.625 | 138.75 | 762200.0 |
| 2000-11-14 15:00:00 | SPY | ETF | 138.8438 | 139.3125 | 138.375 | 139.0938 | 259600.0 |
| 2000-11-14 15:30:00 | SPY | ETF | 139.0625 | 139.125 | 138.1562 | 138.75 | 758400.0 |
| 2000-11-14 16:00:00 | SPY | ETF | 138.8438 | 139.125 | 138.5938 | 139.125 | 286300.0 |
| 2000-11-14 16:30:00 | SPY | ETF | 139.125 | 139.125 | 139.125 | 139.125 | 1200.0 |
| 2000-11-14 09:30:00 | QQQ | ETF | 73.0 | 74.1562 | 72.75 | 73.1875 | 9180300.0 |
| 2000-11-14 10:00:00 | QQQ | ETF | 73.0 | 74.0 | 72.9375 | 73.7188 | 3697000.0 |
| 2000-11-14 10:30:00 | QQQ | ETF | 73.5625 | 74.75 | 73.5312 | 74.375 | 4180200.0 |
| 2000-11-14 11:00:00 | QQQ | ETF | 74.4688 | 74.75 | 73.9375 | 74.0312 | 2027900.0 |
| 2000-11-14 11:30:00 | QQQ | ETF | 74.0625 | 74.25 | 73.5 | 73.8438 | 2905900.0 |
| 2000-11-14 12:00:00 | QQQ | ETF | 73.8438 | 74.125 | 73.75 | 74.0 | 1515300.0 |
| 2000-11-14 12:30:00 | QQQ | ETF | 74.0938 | 75.625 | 73.7812 | 74.6875 | 4092700.0 |
| 2000-11-14 13:00:00 | QQQ | ETF | 74.6875 | 75.25 | 74.5938 | 75.0938 | 2638200.0 |
| 2000-11-14 13:30:00 | QQQ | ETF | 75.125 | 75.25 | 74.6875 | 75.1875 | 1444600.0 |
| 2000-11-14 14:00:00 | QQQ | ETF | 75.0312 | 75.875 | 74.9688 | 75.625 | 1558800.0 |
| 2000-11-14 14:30:00 | QQQ | ETF | 75.625 | 75.9375 | 75.0938 | 75.25 | 2582400.0 |
| 2000-11-14 15:00:00 | QQQ | ETF | 75.25 | 75.8125 | 74.8438 | 75.5312 | 2420900.0 |
| 2000-11-14 15:30:00 | QQQ | ETF | 75.5 | 76.0 | 75.0625 | 75.6875 | 3058400.0 |
| 2000-11-14 16:00:00 | QQQ | ETF | 75.625 | 77.125 | 75.375 | 76.0 | 724700.0 |
| 2000-11-14 16:30:00 | QQQ | ETF | 76.125 | 76.25 | 75.75 | 76.0 | 128000.0 |
| 2000-11-14 17:00:00 | QQQ | ETF | 76.0 | 76.3125 | 75.75 | 76.1875 | 12800.0 |
| 2000-11-14 17:30:00 | QQQ | ETF | 76.25 | 76.25 | 76.0 | 76.0 | 30100.0 |
| 2000-11-14 18:00:00 | QQQ | ETF | 76.0 | 76.1875 | 74.5 | 76.0 | 9100.0 |
| 2000-11-14 09:30:00 | IWM | ETF | 48.4375 | 48.5312 | 48.4375 | 48.5312 | 66000.0 |
| 2000-11-14 10:00:00 | IWM | ETF | 48.5 | 48.5 | 48.5 | 48.5 | 1400.0 |
| 2000-11-14 10:30:00 | IWM | ETF | 48.5625 | 48.5625 | 48.5312 | 48.5625 | 12200.0 |
| 2000-11-14 11:30:00 | IWM | ETF | 48.4375 | 48.4375 | 48.375 | 48.375 | 2200.0 |
| 2000-11-14 12:30:00 | IWM | ETF | 48.5 | 48.6875 | 48.4688 | 48.4688 | 6600.0 |
| 2000-11-14 13:00:00 | IWM | ETF | 48.625 | 48.625 | 48.625 | 48.625 | 200.0 |
| 2000-11-14 13:30:00 | IWM | ETF | 48.6875 | 48.6875 | 48.6875 | 48.6875 | 2000.0 |
| 2000-11-14 14:00:00 | IWM | ETF | 48.6875 | 48.75 | 48.6875 | 48.75 | 4200.0 |
| 2000-11-14 14:30:00 | IWM | ETF | 48.75 | 48.75 | 48.7344 | 48.7344 | 9400.0 |
| 2000-11-14 15:00:00 | IWM | ETF | 48.5 | 48.625 | 48.5 | 48.625 | 12000.0 |
| 2000-11-14 15:30:00 | IWM | ETF | 48.5 | 48.6875 | 48.5 | 48.6875 | 11400.0 |
| 2000-11-14 16:00:00 | IWM | ETF | 48.8125 | 48.8125 | 48.6562 | 48.6562 | 1200.0 |
| 2000-11-14 09:30:00 | DIA | ETF | 106.125 | 106.7188 | 106.0938 | 106.1875 | 442500.0 |
| 2000-11-14 10:00:00 | DIA | ETF | 106.1562 | 106.8125 | 106.1562 | 106.4688 | 273700.0 |
| 2000-11-14 10:30:00 | DIA | ETF | 106.625 | 106.7188 | 106.3125 | 106.5625 | 83100.0 |
| 2000-11-14 11:00:00 | DIA | ETF | 106.5625 | 106.6562 | 106.125 | 106.25 | 142400.0 |
| 2000-11-14 11:30:00 | DIA | ETF | 106.25 | 106.7188 | 106.0 | 106.5 | 176800.0 |
> showing 50 of 286 rows — these rows as CSV