PREVIEW / etf_30min / 2000-08-10
file: by_date/etf_30min/2000/2000-08-10.parquet size: 10 KB rows: 257
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-08-10 09:30:00 | SPY | ETF | 147.5312 | 147.8438 | 147.4062 | 147.6875 | 536700.0 |
| 2000-08-10 10:00:00 | SPY | ETF | 147.6875 | 147.6875 | 147.0 | 147.5625 | 401700.0 |
| 2000-08-10 10:30:00 | SPY | ETF | 147.625 | 147.6875 | 147.1875 | 147.625 | 323300.0 |
| 2000-08-10 11:00:00 | SPY | ETF | 147.5625 | 147.5938 | 147.25 | 147.375 | 104100.0 |
| 2000-08-10 11:30:00 | SPY | ETF | 147.4688 | 147.5 | 147.0625 | 147.125 | 145200.0 |
| 2000-08-10 12:00:00 | SPY | ETF | 147.1875 | 147.2188 | 146.875 | 147.1875 | 201900.0 |
| 2000-08-10 12:30:00 | SPY | ETF | 147.2188 | 147.2188 | 146.75 | 146.9688 | 200400.0 |
| 2000-08-10 13:00:00 | SPY | ETF | 146.9688 | 147.125 | 146.8125 | 147.0625 | 279700.0 |
| 2000-08-10 13:30:00 | SPY | ETF | 147.0625 | 147.0625 | 146.8125 | 146.9688 | 72700.0 |
| 2000-08-10 14:00:00 | SPY | ETF | 146.8125 | 146.875 | 146.5 | 146.5625 | 194400.0 |
| 2000-08-10 14:30:00 | SPY | ETF | 146.5625 | 146.9375 | 146.5312 | 146.625 | 330100.0 |
| 2000-08-10 15:00:00 | SPY | ETF | 146.625 | 146.7812 | 146.3125 | 146.75 | 345700.0 |
| 2000-08-10 15:30:00 | SPY | ETF | 146.625 | 146.8125 | 146.2812 | 146.5625 | 751000.0 |
| 2000-08-10 16:00:00 | SPY | ETF | 146.4375 | 146.8125 | 146.4062 | 146.7188 | 205600.0 |
| 2000-08-10 17:00:00 | SPY | ETF | 146.7188 | 146.7188 | 146.7188 | 146.7188 | 600.0 |
| 2000-08-10 09:30:00 | QQQ | ETF | 91.8125 | 92.2188 | 91.0625 | 91.8438 | 2406900.0 |
| 2000-08-10 10:00:00 | QQQ | ETF | 91.9062 | 91.9375 | 91.125 | 91.9375 | 1423700.0 |
| 2000-08-10 10:30:00 | QQQ | ETF | 91.9062 | 91.9688 | 91.2812 | 91.875 | 648800.0 |
| 2000-08-10 11:00:00 | QQQ | ETF | 91.8125 | 91.875 | 91.375 | 91.5625 | 549800.0 |
| 2000-08-10 11:30:00 | QQQ | ETF | 91.5938 | 91.6875 | 90.8125 | 90.875 | 1119100.0 |
| 2000-08-10 12:00:00 | QQQ | ETF | 90.875 | 91.125 | 90.5625 | 90.875 | 1151700.0 |
| 2000-08-10 12:30:00 | QQQ | ETF | 90.875 | 91.0 | 90.25 | 90.6875 | 821600.0 |
| 2000-08-10 13:00:00 | QQQ | ETF | 90.8125 | 91.0938 | 90.5 | 90.9375 | 350600.0 |
| 2000-08-10 13:30:00 | QQQ | ETF | 90.9375 | 91.0312 | 90.5625 | 90.6875 | 548600.0 |
| 2000-08-10 14:00:00 | QQQ | ETF | 90.6875 | 90.6875 | 90.0312 | 90.1875 | 1380200.0 |
| 2000-08-10 14:30:00 | QQQ | ETF | 90.1875 | 90.5312 | 90.0 | 90.1875 | 1091100.0 |
| 2000-08-10 15:00:00 | QQQ | ETF | 90.3125 | 90.5938 | 89.875 | 90.25 | 1506600.0 |
| 2000-08-10 15:30:00 | QQQ | ETF | 90.25 | 90.5625 | 89.6875 | 89.75 | 1962600.0 |
| 2000-08-10 16:00:00 | QQQ | ETF | 89.75 | 90.0625 | 89.6875 | 89.875 | 335300.0 |
| 2000-08-10 16:30:00 | QQQ | ETF | 90.0 | 90.0 | 89.75 | 89.75 | 8700.0 |
| 2000-08-10 17:00:00 | QQQ | ETF | 89.75 | 89.8125 | 89.75 | 89.8125 | 1100.0 |
| 2000-08-10 17:30:00 | QQQ | ETF | 89.8125 | 89.8125 | 89.75 | 89.75 | 1200.0 |
| 2000-08-10 18:00:00 | QQQ | ETF | 89.75 | 90.0 | 89.75 | 89.8125 | 2500.0 |
| 2000-08-10 09:30:00 | IWM | ETF | 50.5469 | 50.5938 | 50.5469 | 50.5781 | 1800.0 |
| 2000-08-10 10:00:00 | IWM | ETF | 50.375 | 50.375 | 50.3281 | 50.3281 | 600.0 |
| 2000-08-10 10:30:00 | IWM | ETF | 50.3438 | 50.3438 | 50.3438 | 50.3438 | 10000.0 |
| 2000-08-10 11:30:00 | IWM | ETF | 50.3125 | 50.3125 | 50.3125 | 50.3125 | 5200.0 |
| 2000-08-10 12:00:00 | IWM | ETF | 50.2812 | 50.2812 | 50.2344 | 50.2812 | 600.0 |
| 2000-08-10 12:30:00 | IWM | ETF | 50.1406 | 50.3125 | 50.1406 | 50.3125 | 600.0 |
| 2000-08-10 13:00:00 | IWM | ETF | 50.3125 | 50.3438 | 50.3125 | 50.3438 | 9800.0 |
| 2000-08-10 13:30:00 | IWM | ETF | 50.4688 | 50.4688 | 50.4688 | 50.4688 | 3000.0 |
| 2000-08-10 14:00:00 | IWM | ETF | 50.3438 | 50.3438 | 50.3438 | 50.3438 | 2600.0 |
| 2000-08-10 14:30:00 | IWM | ETF | 50.1406 | 50.1406 | 50.1406 | 50.1406 | 200.0 |
| 2000-08-10 15:00:00 | IWM | ETF | 50.0938 | 50.0938 | 50.0938 | 50.0938 | 1200.0 |
| 2000-08-10 15:30:00 | IWM | ETF | 50.125 | 50.25 | 50.125 | 50.25 | 7400.0 |
| 2000-08-10 09:30:00 | DIA | ETF | 109.0312 | 109.4688 | 109.0312 | 109.3125 | 40000.0 |
| 2000-08-10 10:00:00 | DIA | ETF | 109.2188 | 109.2812 | 108.8438 | 109.1875 | 85300.0 |
| 2000-08-10 10:30:00 | DIA | ETF | 109.3125 | 109.3438 | 109.0312 | 109.3125 | 8200.0 |
| 2000-08-10 11:00:00 | DIA | ETF | 109.25 | 109.3438 | 109.1875 | 109.25 | 11200.0 |
| 2000-08-10 11:30:00 | DIA | ETF | 109.25 | 109.4375 | 109.125 | 109.1875 | 52700.0 |
> showing 50 of 257 rows — these rows as CSV