PREVIEW / etf_30min / 2000-10-18
file: by_date/etf_30min/2000/2000-10-18.parquet size: 12 KB rows: 311
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-10-18 09:30:00 | SPY | ETF | 132.625 | 133.1562 | 130.1562 | 132.2188 | 2767800.0 |
| 2000-10-18 10:00:00 | SPY | ETF | 132.125 | 133.1875 | 132.0 | 132.6562 | 1412000.0 |
| 2000-10-18 10:30:00 | SPY | ETF | 132.6562 | 134.4062 | 132.3438 | 133.9062 | 797600.0 |
| 2000-10-18 11:00:00 | SPY | ETF | 134.0625 | 135.5 | 133.9375 | 134.2188 | 630300.0 |
| 2000-10-18 11:30:00 | SPY | ETF | 134.125 | 135.125 | 133.75 | 134.6875 | 545400.0 |
| 2000-10-18 12:00:00 | SPY | ETF | 134.6875 | 134.7188 | 133.625 | 133.625 | 384500.0 |
| 2000-10-18 12:30:00 | SPY | ETF | 133.6562 | 135.2188 | 133.625 | 135.0 | 344200.0 |
| 2000-10-18 13:00:00 | SPY | ETF | 135.0625 | 135.125 | 134.125 | 134.625 | 353400.0 |
| 2000-10-18 13:30:00 | SPY | ETF | 134.5625 | 134.9062 | 133.9062 | 134.75 | 266500.0 |
| 2000-10-18 14:00:00 | SPY | ETF | 134.8125 | 135.5312 | 134.5625 | 135.375 | 363900.0 |
| 2000-10-18 14:30:00 | SPY | ETF | 135.375 | 136.125 | 135.2188 | 135.7812 | 568900.0 |
| 2000-10-18 15:00:00 | SPY | ETF | 135.8125 | 135.9375 | 135.25 | 135.25 | 365500.0 |
| 2000-10-18 15:30:00 | SPY | ETF | 135.25 | 135.3125 | 134.1875 | 134.4062 | 942200.0 |
| 2000-10-18 16:00:00 | SPY | ETF | 134.3125 | 134.625 | 134.125 | 134.25 | 1018600.0 |
| 2000-10-18 16:30:00 | SPY | ETF | 135.0 | 135.0 | 134.0625 | 134.0625 | 1100.0 |
| 2000-10-18 17:00:00 | SPY | ETF | 135.0625 | 135.25 | 135.0625 | 135.25 | 5000.0 |
| 2000-10-18 17:30:00 | SPY | ETF | 134.875 | 134.875 | 134.875 | 134.875 | 100.0 |
| 2000-10-18 09:30:00 | QQQ | ETF | 76.75 | 76.875 | 74.5625 | 75.9375 | 12614100.0 |
| 2000-10-18 10:00:00 | QQQ | ETF | 75.9375 | 77.5 | 75.75 | 76.7188 | 6160300.0 |
| 2000-10-18 10:30:00 | QQQ | ETF | 76.7188 | 79.6875 | 76.4062 | 78.75 | 5578000.0 |
| 2000-10-18 11:00:00 | QQQ | ETF | 78.7812 | 80.7188 | 78.75 | 78.9062 | 6552200.0 |
| 2000-10-18 11:30:00 | QQQ | ETF | 78.75 | 80.5 | 78.3125 | 79.5625 | 5184200.0 |
| 2000-10-18 12:00:00 | QQQ | ETF | 79.7188 | 79.75 | 78.5625 | 78.75 | 2602700.0 |
| 2000-10-18 12:30:00 | QQQ | ETF | 78.625 | 81.0 | 78.625 | 80.4375 | 2217800.0 |
| 2000-10-18 13:00:00 | QQQ | ETF | 80.4688 | 80.625 | 79.0 | 79.6875 | 4743300.0 |
| 2000-10-18 13:30:00 | QQQ | ETF | 79.7188 | 79.8125 | 79.0 | 79.75 | 1613000.0 |
| 2000-10-18 14:00:00 | QQQ | ETF | 79.6875 | 80.75 | 79.3125 | 80.5938 | 2712200.0 |
| 2000-10-18 14:30:00 | QQQ | ETF | 80.5625 | 81.1875 | 80.25 | 80.4375 | 3898000.0 |
| 2000-10-18 15:00:00 | QQQ | ETF | 80.4375 | 80.6875 | 79.5 | 79.875 | 2475200.0 |
| 2000-10-18 15:30:00 | QQQ | ETF | 79.75 | 80.0 | 78.1875 | 78.4062 | 4778500.0 |
| 2000-10-18 16:00:00 | QQQ | ETF | 78.25 | 79.7188 | 77.875 | 78.875 | 1145700.0 |
| 2000-10-18 16:30:00 | QQQ | ETF | 79.0 | 80.8438 | 75.375 | 78.75 | 85400.0 |
| 2000-10-18 17:00:00 | QQQ | ETF | 79.0 | 79.1875 | 78.25 | 79.0 | 34400.0 |
| 2000-10-18 17:30:00 | QQQ | ETF | 79.125 | 79.5625 | 78.5 | 79.125 | 64300.0 |
| 2000-10-18 18:00:00 | QQQ | ETF | 79.125 | 80.0 | 78.5 | 79.625 | 48600.0 |
| 2000-10-18 09:30:00 | IWM | ETF | 45.8125 | 45.8125 | 45.6875 | 45.7188 | 75000.0 |
| 2000-10-18 10:00:00 | IWM | ETF | 45.875 | 46.0781 | 45.875 | 45.9688 | 15600.0 |
| 2000-10-18 10:30:00 | IWM | ETF | 46.0 | 46.5938 | 46.0 | 46.4688 | 26200.0 |
| 2000-10-18 11:00:00 | IWM | ETF | 46.5312 | 46.75 | 46.5312 | 46.6875 | 10000.0 |
| 2000-10-18 11:30:00 | IWM | ETF | 46.2812 | 46.375 | 46.2812 | 46.375 | 7000.0 |
| 2000-10-18 12:00:00 | IWM | ETF | 46.4062 | 46.4062 | 46.375 | 46.375 | 8000.0 |
| 2000-10-18 12:30:00 | IWM | ETF | 46.4375 | 46.5625 | 46.4375 | 46.5625 | 21000.0 |
| 2000-10-18 13:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.4688 | 46.4688 | 31400.0 |
| 2000-10-18 13:30:00 | IWM | ETF | 46.5469 | 46.5469 | 46.4375 | 46.4375 | 5800.0 |
| 2000-10-18 14:30:00 | IWM | ETF | 46.5 | 46.8125 | 46.5 | 46.8125 | 15400.0 |
| 2000-10-18 15:00:00 | IWM | ETF | 46.5625 | 46.5625 | 46.5 | 46.5 | 85800.0 |
| 2000-10-18 15:30:00 | IWM | ETF | 46.3906 | 46.625 | 46.3906 | 46.625 | 32000.0 |
| 2000-10-18 16:00:00 | IWM | ETF | 46.5312 | 46.5312 | 46.5312 | 46.5312 | 200.0 |
| 2000-10-18 09:30:00 | DIA | ETF | 99.0 | 99.0 | 96.75 | 98.1875 | 1118600.0 |
| 2000-10-18 10:00:00 | DIA | ETF | 98.1875 | 98.625 | 97.875 | 98.25 | 263700.0 |
> showing 50 of 311 rows — these rows as CSV