PREVIEW / etf_30min / 2000-06-29
file: by_date/etf_30min/2000/2000-06-29.parquet size: 11 KB rows: 240
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-06-29 09:30:00 | SPY | ETF | 144.75 | 144.875 | 144.0625 | 144.8438 | 438500.0 |
| 2000-06-29 10:00:00 | SPY | ETF | 144.6562 | 144.875 | 144.3125 | 144.6562 | 646700.0 |
| 2000-06-29 10:30:00 | SPY | ETF | 144.5 | 144.5 | 143.75 | 144.1562 | 433000.0 |
| 2000-06-29 11:00:00 | SPY | ETF | 144.1875 | 144.1875 | 143.5 | 143.6875 | 178400.0 |
| 2000-06-29 11:30:00 | SPY | ETF | 143.7812 | 144.2188 | 143.7188 | 144.125 | 113000.0 |
| 2000-06-29 12:00:00 | SPY | ETF | 144.2188 | 144.3125 | 143.875 | 144.0938 | 145700.0 |
| 2000-06-29 12:30:00 | SPY | ETF | 144.1875 | 144.625 | 144.0625 | 144.5625 | 272500.0 |
| 2000-06-29 13:00:00 | SPY | ETF | 144.4375 | 144.5625 | 144.2188 | 144.4062 | 61500.0 |
| 2000-06-29 13:30:00 | SPY | ETF | 144.375 | 144.9688 | 144.1875 | 144.8125 | 503000.0 |
| 2000-06-29 14:00:00 | SPY | ETF | 144.75 | 145.75 | 144.75 | 145.3438 | 775400.0 |
| 2000-06-29 14:30:00 | SPY | ETF | 145.375 | 145.5625 | 144.5938 | 144.5938 | 617900.0 |
| 2000-06-29 15:00:00 | SPY | ETF | 144.6875 | 145.375 | 144.5312 | 145.0625 | 291100.0 |
| 2000-06-29 15:30:00 | SPY | ETF | 145.0312 | 145.25 | 144.3125 | 144.4375 | 331800.0 |
| 2000-06-29 16:00:00 | SPY | ETF | 144.25 | 144.4688 | 144.125 | 144.1875 | 479500.0 |
| 2000-06-29 16:30:00 | SPY | ETF | 144.125 | 144.125 | 144.125 | 144.125 | 900.0 |
| 2000-06-29 17:00:00 | SPY | ETF | 144.1875 | 144.1875 | 144.1875 | 144.1875 | 300.0 |
| 2000-06-29 09:30:00 | QQQ | ETF | 92.9375 | 92.9375 | 91.875 | 92.5938 | 4726700.0 |
| 2000-06-29 10:00:00 | QQQ | ETF | 92.5625 | 92.75 | 91.4375 | 91.7188 | 2023600.0 |
| 2000-06-29 10:30:00 | QQQ | ETF | 91.625 | 91.7188 | 91.0625 | 91.5625 | 1807400.0 |
| 2000-06-29 11:00:00 | QQQ | ETF | 91.5312 | 91.625 | 90.625 | 90.875 | 1603900.0 |
| 2000-06-29 11:30:00 | QQQ | ETF | 90.75 | 91.625 | 90.75 | 91.625 | 767300.0 |
| 2000-06-29 12:00:00 | QQQ | ETF | 91.5938 | 91.875 | 90.625 | 91.625 | 536600.0 |
| 2000-06-29 12:30:00 | QQQ | ETF | 91.625 | 92.3438 | 91.3125 | 92.0625 | 936100.0 |
| 2000-06-29 13:00:00 | QQQ | ETF | 92.125 | 92.125 | 91.625 | 91.875 | 604300.0 |
| 2000-06-29 13:30:00 | QQQ | ETF | 91.9375 | 92.4375 | 91.75 | 92.375 | 641300.0 |
| 2000-06-29 14:00:00 | QQQ | ETF | 92.3125 | 93.375 | 92.3125 | 93.125 | 2053800.0 |
| 2000-06-29 14:30:00 | QQQ | ETF | 93.125 | 93.125 | 92.125 | 92.25 | 1542400.0 |
| 2000-06-29 15:00:00 | QQQ | ETF | 92.25 | 93.1562 | 92.0 | 92.75 | 1529700.0 |
| 2000-06-29 15:30:00 | QQQ | ETF | 93.0625 | 93.0625 | 91.5 | 91.625 | 2059100.0 |
| 2000-06-29 16:00:00 | QQQ | ETF | 91.8125 | 92.0 | 91.5 | 92.0 | 462500.0 |
| 2000-06-29 16:30:00 | QQQ | ETF | 91.625 | 91.625 | 91.625 | 91.625 | 2400.0 |
| 2000-06-29 09:30:00 | IWM | ETF | 51.75 | 51.8438 | 51.5 | 51.5938 | 6800.0 |
| 2000-06-29 10:00:00 | IWM | ETF | 51.75 | 51.75 | 51.5469 | 51.5469 | 17600.0 |
| 2000-06-29 10:30:00 | IWM | ETF | 51.3906 | 51.3906 | 51.2188 | 51.2812 | 5400.0 |
| 2000-06-29 11:00:00 | IWM | ETF | 51.4219 | 51.4219 | 51.0312 | 51.1406 | 5000.0 |
| 2000-06-29 11:30:00 | IWM | ETF | 51.125 | 51.2344 | 51.125 | 51.2344 | 1400.0 |
| 2000-06-29 12:00:00 | IWM | ETF | 51.25 | 51.25 | 51.25 | 51.25 | 1000.0 |
| 2000-06-29 12:30:00 | IWM | ETF | 51.25 | 51.375 | 51.25 | 51.375 | 9800.0 |
| 2000-06-29 13:00:00 | IWM | ETF | 51.4688 | 51.5 | 51.3438 | 51.5 | 8600.0 |
| 2000-06-29 13:30:00 | IWM | ETF | 51.5 | 51.5 | 51.375 | 51.4688 | 10000.0 |
| 2000-06-29 14:00:00 | IWM | ETF | 51.625 | 51.7188 | 51.5312 | 51.7188 | 5000.0 |
| 2000-06-29 14:30:00 | IWM | ETF | 51.5625 | 51.5625 | 51.3438 | 51.3438 | 4000.0 |
| 2000-06-29 15:00:00 | IWM | ETF | 51.4219 | 51.5312 | 51.3125 | 51.5312 | 9000.0 |
| 2000-06-29 15:30:00 | IWM | ETF | 51.375 | 51.4688 | 51.2969 | 51.3438 | 111000.0 |
| 2000-06-29 16:00:00 | IWM | ETF | 51.1875 | 51.1875 | 51.1875 | 51.1875 | 17200.0 |
| 2000-06-29 09:30:00 | DIA | ETF | 104.5938 | 104.5938 | 103.9062 | 104.375 | 71000.0 |
| 2000-06-29 10:00:00 | DIA | ETF | 104.3438 | 104.4375 | 104.0312 | 104.125 | 44400.0 |
| 2000-06-29 10:30:00 | DIA | ETF | 104.0312 | 104.125 | 103.6562 | 104.125 | 29700.0 |
| 2000-06-29 11:00:00 | DIA | ETF | 104.0 | 104.0312 | 103.625 | 103.9375 | 40300.0 |
| 2000-06-29 11:30:00 | DIA | ETF | 103.875 | 104.3438 | 103.8125 | 104.3438 | 32400.0 |
> showing 50 of 240 rows — these rows as CSV