PREVIEW / etf_30min / 2000-12-12
file: by_date/etf_30min/2000/2000-12-12.parquet size: 12 KB rows: 307
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-12-12 09:30:00 | SPY | ETF | 138.1875 | 138.2812 | 137.7188 | 138.0 | 697200.0 |
| 2000-12-12 10:00:00 | SPY | ETF | 138.0938 | 138.5 | 138.0 | 138.4062 | 250500.0 |
| 2000-12-12 10:30:00 | SPY | ETF | 138.4375 | 138.5938 | 137.8438 | 138.0625 | 242400.0 |
| 2000-12-12 11:00:00 | SPY | ETF | 138.0625 | 138.5 | 137.7812 | 138.3125 | 85900.0 |
| 2000-12-12 11:30:00 | SPY | ETF | 138.3125 | 138.4375 | 138.0625 | 138.3125 | 113200.0 |
| 2000-12-12 12:00:00 | SPY | ETF | 138.3125 | 138.4375 | 138.1875 | 138.25 | 593900.0 |
| 2000-12-12 12:30:00 | SPY | ETF | 138.25 | 138.3438 | 137.875 | 138.0625 | 362100.0 |
| 2000-12-12 13:00:00 | SPY | ETF | 138.125 | 138.2188 | 137.875 | 138.0625 | 284900.0 |
| 2000-12-12 13:30:00 | SPY | ETF | 138.125 | 138.25 | 137.375 | 137.7188 | 277400.0 |
| 2000-12-12 14:00:00 | SPY | ETF | 137.625 | 137.9375 | 137.375 | 137.75 | 159800.0 |
| 2000-12-12 14:30:00 | SPY | ETF | 137.8438 | 137.875 | 137.5 | 137.5312 | 221300.0 |
| 2000-12-12 15:00:00 | SPY | ETF | 137.4062 | 138.375 | 137.4062 | 138.1562 | 349300.0 |
| 2000-12-12 15:30:00 | SPY | ETF | 138.1562 | 138.5 | 137.5 | 137.75 | 519400.0 |
| 2000-12-12 16:00:00 | SPY | ETF | 137.5312 | 138.4375 | 137.5312 | 138.0625 | 481200.0 |
| 2000-12-12 16:30:00 | SPY | ETF | 138.0312 | 138.0312 | 138.0312 | 138.0312 | 200.0 |
| 2000-12-12 09:30:00 | QQQ | ETF | 73.5 | 73.7188 | 72.1875 | 73.125 | 6448900.0 |
| 2000-12-12 10:00:00 | QQQ | ETF | 73.1562 | 73.5 | 72.75 | 73.375 | 3203700.0 |
| 2000-12-12 10:30:00 | QQQ | ETF | 73.375 | 73.875 | 72.875 | 73.125 | 2844300.0 |
| 2000-12-12 11:00:00 | QQQ | ETF | 73.0 | 73.5625 | 72.6875 | 73.25 | 1194600.0 |
| 2000-12-12 11:30:00 | QQQ | ETF | 73.25 | 73.2812 | 72.9062 | 73.0625 | 488400.0 |
| 2000-12-12 12:00:00 | QQQ | ETF | 73.125 | 73.3125 | 72.875 | 73.0 | 863500.0 |
| 2000-12-12 12:30:00 | QQQ | ETF | 73.0312 | 73.2188 | 72.375 | 72.7188 | 1540800.0 |
| 2000-12-12 13:00:00 | QQQ | ETF | 72.6875 | 73.0 | 72.5938 | 72.7812 | 626500.0 |
| 2000-12-12 13:30:00 | QQQ | ETF | 72.875 | 72.9062 | 71.875 | 72.0625 | 1633400.0 |
| 2000-12-12 14:00:00 | QQQ | ETF | 72.0312 | 72.375 | 71.5625 | 72.125 | 2379600.0 |
| 2000-12-12 14:30:00 | QQQ | ETF | 72.0625 | 72.2188 | 71.6875 | 71.875 | 1082000.0 |
| 2000-12-12 15:00:00 | QQQ | ETF | 71.7812 | 72.625 | 71.6562 | 72.25 | 1849800.0 |
| 2000-12-12 15:30:00 | QQQ | ETF | 72.125 | 72.4375 | 71.4375 | 71.5 | 3658200.0 |
| 2000-12-12 16:00:00 | QQQ | ETF | 71.5938 | 72.75 | 71.25 | 72.0 | 1154400.0 |
| 2000-12-12 16:30:00 | QQQ | ETF | 72.0 | 72.8125 | 71.5 | 71.875 | 123500.0 |
| 2000-12-12 17:00:00 | QQQ | ETF | 71.9375 | 72.0 | 71.625 | 71.75 | 12000.0 |
| 2000-12-12 17:30:00 | QQQ | ETF | 71.75 | 72.0 | 71.625 | 71.9375 | 6000.0 |
| 2000-12-12 18:00:00 | QQQ | ETF | 71.9375 | 72.0 | 71.75 | 71.875 | 8200.0 |
| 2000-12-12 09:30:00 | IWM | ETF | 48.7812 | 48.7812 | 48.1562 | 48.2812 | 24600.0 |
| 2000-12-12 10:00:00 | IWM | ETF | 48.375 | 48.375 | 48.375 | 48.375 | 400.0 |
| 2000-12-12 10:30:00 | IWM | ETF | 48.375 | 48.4062 | 48.2188 | 48.3906 | 1800.0 |
| 2000-12-12 11:00:00 | IWM | ETF | 48.3125 | 48.3125 | 48.2188 | 48.2188 | 1400.0 |
| 2000-12-12 11:30:00 | IWM | ETF | 48.4375 | 48.4375 | 48.4375 | 48.4375 | 2200.0 |
| 2000-12-12 12:00:00 | IWM | ETF | 48.25 | 48.4062 | 48.2188 | 48.3906 | 43000.0 |
| 2000-12-12 12:30:00 | IWM | ETF | 48.3906 | 48.3906 | 48.2344 | 48.2344 | 4800.0 |
| 2000-12-12 13:00:00 | IWM | ETF | 48.25 | 48.2812 | 48.0312 | 48.0312 | 57000.0 |
| 2000-12-12 13:30:00 | IWM | ETF | 48.1875 | 48.1875 | 47.9688 | 47.9688 | 40400.0 |
| 2000-12-12 14:00:00 | IWM | ETF | 48.125 | 48.1719 | 48.0938 | 48.0938 | 114400.0 |
| 2000-12-12 14:30:00 | IWM | ETF | 48.125 | 48.125 | 48.0 | 48.0625 | 15000.0 |
| 2000-12-12 15:00:00 | IWM | ETF | 47.9375 | 48.125 | 47.9375 | 48.125 | 2200.0 |
| 2000-12-12 15:30:00 | IWM | ETF | 48.125 | 48.125 | 47.8438 | 47.8438 | 10000.0 |
| 2000-12-12 16:00:00 | IWM | ETF | 47.7188 | 47.7188 | 47.7188 | 47.7188 | 200.0 |
| 2000-12-12 09:30:00 | DIA | ETF | 107.0312 | 107.8438 | 107.0312 | 107.8438 | 94900.0 |
| 2000-12-12 10:00:00 | DIA | ETF | 107.6875 | 108.2188 | 107.6875 | 108.1875 | 136200.0 |
| 2000-12-12 10:30:00 | DIA | ETF | 108.125 | 108.2188 | 107.7188 | 107.7812 | 25100.0 |
> showing 50 of 307 rows — these rows as CSV