PREVIEW / etf_30min / 2000-07-12
file: by_date/etf_30min/2000/2000-07-12.parquet size: 10 KB rows: 256
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-07-12 09:30:00 | SPY | ETF | 149.2812 | 149.4688 | 148.7812 | 148.875 | 1058900.0 |
| 2000-07-12 10:00:00 | SPY | ETF | 148.75 | 149.5625 | 148.75 | 149.4062 | 763000.0 |
| 2000-07-12 10:30:00 | SPY | ETF | 149.25 | 149.5 | 148.6875 | 148.9688 | 231400.0 |
| 2000-07-12 11:00:00 | SPY | ETF | 149.0 | 149.3438 | 148.75 | 149.125 | 489700.0 |
| 2000-07-12 11:30:00 | SPY | ETF | 149.2812 | 149.375 | 148.9062 | 149.0312 | 198700.0 |
| 2000-07-12 12:00:00 | SPY | ETF | 149.0625 | 149.2188 | 148.75 | 148.9688 | 107000.0 |
| 2000-07-12 12:30:00 | SPY | ETF | 148.9062 | 149.2188 | 148.8438 | 149.125 | 441700.0 |
| 2000-07-12 13:00:00 | SPY | ETF | 149.1875 | 149.375 | 149.0938 | 149.25 | 252800.0 |
| 2000-07-12 13:30:00 | SPY | ETF | 149.1875 | 149.5625 | 149.0312 | 149.5 | 287700.0 |
| 2000-07-12 14:00:00 | SPY | ETF | 149.4375 | 150.0 | 149.4062 | 149.875 | 450900.0 |
| 2000-07-12 14:30:00 | SPY | ETF | 149.9688 | 150.125 | 149.625 | 149.625 | 368400.0 |
| 2000-07-12 15:00:00 | SPY | ETF | 149.75 | 150.0 | 149.625 | 149.8438 | 445900.0 |
| 2000-07-12 15:30:00 | SPY | ETF | 149.9375 | 149.9375 | 149.4062 | 149.5938 | 369800.0 |
| 2000-07-12 16:00:00 | SPY | ETF | 149.5 | 149.5938 | 149.125 | 149.125 | 396700.0 |
| 2000-07-12 09:30:00 | QQQ | ETF | 95.4375 | 95.5 | 94.625 | 94.75 | 3295300.0 |
| 2000-07-12 10:00:00 | QQQ | ETF | 94.625 | 95.875 | 94.625 | 95.5 | 1463000.0 |
| 2000-07-12 10:30:00 | QQQ | ETF | 95.5625 | 95.875 | 95.0312 | 95.4375 | 889000.0 |
| 2000-07-12 11:00:00 | QQQ | ETF | 95.375 | 96.25 | 95.3125 | 96.0625 | 1142500.0 |
| 2000-07-12 11:30:00 | QQQ | ETF | 96.0625 | 96.4375 | 95.9375 | 96.0938 | 1340800.0 |
| 2000-07-12 12:00:00 | QQQ | ETF | 96.125 | 96.3125 | 95.875 | 95.9375 | 759400.0 |
| 2000-07-12 12:30:00 | QQQ | ETF | 95.9375 | 96.5 | 95.875 | 96.4375 | 370800.0 |
| 2000-07-12 13:00:00 | QQQ | ETF | 96.375 | 96.7812 | 96.3125 | 96.4375 | 753000.0 |
| 2000-07-12 13:30:00 | QQQ | ETF | 96.5312 | 96.875 | 96.3125 | 96.8125 | 434600.0 |
| 2000-07-12 14:00:00 | QQQ | ETF | 96.75 | 97.4375 | 96.625 | 97.3125 | 1783400.0 |
| 2000-07-12 14:30:00 | QQQ | ETF | 97.3125 | 97.75 | 97.1875 | 97.25 | 1816200.0 |
| 2000-07-12 15:00:00 | QQQ | ETF | 97.25 | 97.5 | 96.8125 | 97.25 | 1632000.0 |
| 2000-07-12 15:30:00 | QQQ | ETF | 97.25 | 97.375 | 96.75 | 97.125 | 1734400.0 |
| 2000-07-12 16:00:00 | QQQ | ETF | 97.1875 | 97.375 | 96.875 | 97.0 | 890400.0 |
| 2000-07-12 16:30:00 | QQQ | ETF | 97.0 | 97.625 | 97.0 | 97.625 | 800.0 |
| 2000-07-12 17:00:00 | QQQ | ETF | 97.5 | 97.5625 | 97.25 | 97.5 | 4300.0 |
| 2000-07-12 17:30:00 | QQQ | ETF | 97.625 | 97.625 | 96.875 | 96.875 | 3300.0 |
| 2000-07-12 18:00:00 | QQQ | ETF | 97.0 | 97.375 | 96.875 | 97.25 | 1500.0 |
| 2000-07-12 09:30:00 | IWM | ETF | 53.3125 | 53.375 | 53.3125 | 53.375 | 11600.0 |
| 2000-07-12 10:00:00 | IWM | ETF | 53.25 | 53.5 | 53.25 | 53.5 | 8600.0 |
| 2000-07-12 10:30:00 | IWM | ETF | 53.4844 | 53.5625 | 53.4688 | 53.5625 | 1000.0 |
| 2000-07-12 11:00:00 | IWM | ETF | 53.5312 | 53.5938 | 53.5312 | 53.5938 | 1000.0 |
| 2000-07-12 11:30:00 | IWM | ETF | 53.6875 | 53.6875 | 53.6719 | 53.6719 | 3000.0 |
| 2000-07-12 12:30:00 | IWM | ETF | 53.6875 | 53.6875 | 53.6875 | 53.6875 | 800.0 |
| 2000-07-12 13:00:00 | IWM | ETF | 53.7031 | 53.7188 | 53.7031 | 53.7188 | 3800.0 |
| 2000-07-12 13:30:00 | IWM | ETF | 53.7031 | 53.7031 | 53.7031 | 53.7031 | 200.0 |
| 2000-07-12 14:00:00 | IWM | ETF | 53.7188 | 53.875 | 53.7188 | 53.875 | 1800.0 |
| 2000-07-12 14:30:00 | IWM | ETF | 53.9375 | 53.9375 | 53.875 | 53.875 | 800.0 |
| 2000-07-12 15:00:00 | IWM | ETF | 53.875 | 53.875 | 53.875 | 53.875 | 400.0 |
| 2000-07-12 15:30:00 | IWM | ETF | 53.8281 | 53.9062 | 53.8281 | 53.9062 | 1600.0 |
| 2000-07-12 16:00:00 | IWM | ETF | 54.0938 | 54.0938 | 54.0938 | 54.0938 | 10600.0 |
| 2000-07-12 09:30:00 | DIA | ETF | 108.1562 | 108.1875 | 107.625 | 107.625 | 170100.0 |
| 2000-07-12 10:00:00 | DIA | ETF | 107.5625 | 108.2188 | 107.5625 | 108.125 | 68200.0 |
| 2000-07-12 10:30:00 | DIA | ETF | 107.9375 | 108.0625 | 107.5312 | 107.75 | 28400.0 |
| 2000-07-12 11:00:00 | DIA | ETF | 107.875 | 107.9688 | 107.5625 | 107.875 | 58900.0 |
| 2000-07-12 11:30:00 | DIA | ETF | 107.875 | 107.9375 | 107.5625 | 107.6875 | 10400.0 |
> showing 50 of 256 rows — these rows as CSV