PREVIEW / etf_30min / 2000-12-11
file: by_date/etf_30min/2000/2000-12-11.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-11 09:30:00 | SPY | ETF | 137.375 | 137.8438 | 136.7188 | 137.5 | 1260200.0 |
| 2000-12-11 10:00:00 | SPY | ETF | 137.375 | 138.0938 | 137.2188 | 138.0 | 592500.0 |
| 2000-12-11 10:30:00 | SPY | ETF | 137.875 | 138.75 | 137.875 | 138.625 | 387100.0 |
| 2000-12-11 11:00:00 | SPY | ETF | 138.5 | 139.0938 | 138.5 | 138.875 | 203200.0 |
| 2000-12-11 11:30:00 | SPY | ETF | 138.875 | 139.25 | 138.7812 | 139.0 | 496600.0 |
| 2000-12-11 12:00:00 | SPY | ETF | 138.9688 | 139.0 | 138.5312 | 138.875 | 411000.0 |
| 2000-12-11 12:30:00 | SPY | ETF | 138.875 | 138.875 | 138.5625 | 138.6875 | 227100.0 |
| 2000-12-11 13:00:00 | SPY | ETF | 138.7812 | 138.7812 | 138.375 | 138.625 | 278300.0 |
| 2000-12-11 13:30:00 | SPY | ETF | 138.7188 | 138.7188 | 138.2188 | 138.375 | 108500.0 |
| 2000-12-11 14:00:00 | SPY | ETF | 138.25 | 138.7188 | 138.25 | 138.5 | 438400.0 |
| 2000-12-11 14:30:00 | SPY | ETF | 138.625 | 139.3438 | 138.5312 | 139.2188 | 494700.0 |
| 2000-12-11 15:00:00 | SPY | ETF | 139.125 | 139.5625 | 139.0 | 139.3125 | 197800.0 |
| 2000-12-11 15:30:00 | SPY | ETF | 139.3438 | 139.5 | 138.5312 | 138.625 | 618500.0 |
| 2000-12-11 16:00:00 | SPY | ETF | 138.4375 | 138.75 | 138.25 | 138.625 | 435000.0 |
| 2000-12-11 16:30:00 | SPY | ETF | 138.6875 | 138.875 | 138.625 | 138.875 | 33100.0 |
| 2000-12-11 09:30:00 | QQQ | ETF | 72.0312 | 72.8125 | 70.9375 | 72.5 | 10146600.0 |
| 2000-12-11 10:00:00 | QQQ | ETF | 72.5 | 72.6875 | 71.875 | 72.5625 | 2912300.0 |
| 2000-12-11 10:30:00 | QQQ | ETF | 72.5 | 73.6875 | 72.4375 | 73.1875 | 5447700.0 |
| 2000-12-11 11:00:00 | QQQ | ETF | 73.25 | 74.0938 | 73.1875 | 73.7812 | 4137100.0 |
| 2000-12-11 11:30:00 | QQQ | ETF | 73.6875 | 74.5 | 73.625 | 74.0 | 3574200.0 |
| 2000-12-11 12:00:00 | QQQ | ETF | 74.0 | 74.0 | 73.3438 | 73.9688 | 2655900.0 |
| 2000-12-11 12:30:00 | QQQ | ETF | 73.9062 | 74.1875 | 73.75 | 74.125 | 1945900.0 |
| 2000-12-11 13:00:00 | QQQ | ETF | 74.0938 | 74.1875 | 73.5 | 73.8438 | 1725100.0 |
| 2000-12-11 13:30:00 | QQQ | ETF | 73.8125 | 73.9375 | 73.0 | 73.0312 | 2436800.0 |
| 2000-12-11 14:00:00 | QQQ | ETF | 73.0 | 73.6875 | 72.8438 | 73.3125 | 3058400.0 |
| 2000-12-11 14:30:00 | QQQ | ETF | 73.3125 | 74.5 | 73.1562 | 74.375 | 2813000.0 |
| 2000-12-11 15:00:00 | QQQ | ETF | 74.375 | 74.75 | 74.0312 | 74.5 | 3683900.0 |
| 2000-12-11 15:30:00 | QQQ | ETF | 74.5312 | 74.625 | 73.75 | 74.125 | 3756500.0 |
| 2000-12-11 16:00:00 | QQQ | ETF | 74.125 | 74.5 | 73.875 | 74.375 | 819100.0 |
| 2000-12-11 16:30:00 | QQQ | ETF | 74.375 | 74.4375 | 74.125 | 74.125 | 60700.0 |
| 2000-12-11 17:00:00 | QQQ | ETF | 74.125 | 74.375 | 74.0 | 74.0625 | 97300.0 |
| 2000-12-11 17:30:00 | QQQ | ETF | 74.1875 | 74.1875 | 74.0 | 74.0625 | 7900.0 |
| 2000-12-11 18:00:00 | QQQ | ETF | 74.25 | 74.5 | 74.0 | 74.0 | 10600.0 |
| 2000-12-11 09:30:00 | IWM | ETF | 47.9688 | 48.0938 | 47.7812 | 48.0938 | 16200.0 |
| 2000-12-11 10:00:00 | IWM | ETF | 48.0781 | 48.3125 | 48.0781 | 48.3125 | 25000.0 |
| 2000-12-11 10:30:00 | IWM | ETF | 48.1875 | 48.3438 | 48.125 | 48.3438 | 40800.0 |
| 2000-12-11 11:00:00 | IWM | ETF | 48.3906 | 48.5938 | 48.3906 | 48.5312 | 11800.0 |
| 2000-12-11 11:30:00 | IWM | ETF | 48.5469 | 48.5938 | 48.5469 | 48.5938 | 2400.0 |
| 2000-12-11 12:00:00 | IWM | ETF | 48.5312 | 48.5312 | 48.4062 | 48.5 | 23400.0 |
| 2000-12-11 12:30:00 | IWM | ETF | 48.375 | 48.4688 | 48.25 | 48.4688 | 19200.0 |
| 2000-12-11 13:00:00 | IWM | ETF | 48.4688 | 48.4688 | 48.4375 | 48.4688 | 5400.0 |
| 2000-12-11 13:30:00 | IWM | ETF | 48.2812 | 48.4375 | 48.2812 | 48.4062 | 3200.0 |
| 2000-12-11 14:00:00 | IWM | ETF | 48.4062 | 48.5 | 48.2188 | 48.5 | 10800.0 |
| 2000-12-11 14:30:00 | IWM | ETF | 48.5312 | 48.6562 | 48.5 | 48.6562 | 35200.0 |
| 2000-12-11 15:00:00 | IWM | ETF | 48.6562 | 48.6875 | 48.5 | 48.6875 | 7200.0 |
| 2000-12-11 15:30:00 | IWM | ETF | 48.7188 | 48.7188 | 48.5312 | 48.5938 | 11400.0 |
| 2000-12-11 16:00:00 | IWM | ETF | 48.7812 | 48.7812 | 48.6406 | 48.7812 | 21200.0 |
| 2000-12-11 09:30:00 | DIA | ETF | 106.625 | 107.375 | 106.625 | 106.875 | 255500.0 |
| 2000-12-11 10:00:00 | DIA | ETF | 107.0 | 107.4688 | 106.8125 | 107.4062 | 108700.0 |
| 2000-12-11 10:30:00 | DIA | ETF | 107.25 | 107.875 | 107.25 | 107.75 | 123100.0 |
> showing 50 of 307 rows — these rows as CSV