PREVIEW / etf_30min / 2000-10-13
file: by_date/etf_30min/2000/2000-10-13.parquet size: 12 KB rows: 301
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-13 09:30:00 | SPY | ETF | 132.9375 | 134.9375 | 132.875 | 134.75 | 1668800.0 |
| 2000-10-13 10:00:00 | SPY | ETF | 134.7812 | 135.5 | 134.5 | 135.0938 | 2234100.0 |
| 2000-10-13 10:30:00 | SPY | ETF | 135.0 | 135.4375 | 134.5 | 135.2188 | 811400.0 |
| 2000-10-13 11:00:00 | SPY | ETF | 135.2188 | 135.5625 | 134.6875 | 135.25 | 674900.0 |
| 2000-10-13 11:30:00 | SPY | ETF | 135.1562 | 136.0 | 135.1562 | 136.0 | 290500.0 |
| 2000-10-13 12:00:00 | SPY | ETF | 136.0 | 136.6875 | 136.0 | 136.25 | 445400.0 |
| 2000-10-13 12:30:00 | SPY | ETF | 136.25 | 136.375 | 135.9062 | 136.1875 | 230300.0 |
| 2000-10-13 13:00:00 | SPY | ETF | 136.25 | 136.5 | 136.1562 | 136.3125 | 550800.0 |
| 2000-10-13 13:30:00 | SPY | ETF | 136.2188 | 136.9062 | 136.125 | 136.7812 | 352500.0 |
| 2000-10-13 14:00:00 | SPY | ETF | 136.875 | 137.0625 | 136.5 | 136.75 | 606700.0 |
| 2000-10-13 14:30:00 | SPY | ETF | 136.75 | 137.1875 | 136.6875 | 137.0 | 614300.0 |
| 2000-10-13 15:00:00 | SPY | ETF | 137.125 | 137.4375 | 136.5312 | 137.2812 | 441100.0 |
| 2000-10-13 15:30:00 | SPY | ETF | 137.3125 | 137.6562 | 137.125 | 137.5938 | 1640500.0 |
| 2000-10-13 16:00:00 | SPY | ETF | 137.5625 | 137.5625 | 137.1562 | 137.5625 | 1152900.0 |
| 2000-10-13 18:00:00 | SPY | ETF | 137.0625 | 137.0625 | 137.0625 | 137.0625 | 2000.0 |
| 2000-10-13 09:30:00 | QQQ | ETF | 74.6875 | 77.0 | 74.625 | 76.875 | 5793200.0 |
| 2000-10-13 10:00:00 | QQQ | ETF | 76.8438 | 77.4062 | 76.25 | 76.625 | 4133500.0 |
| 2000-10-13 10:30:00 | QQQ | ETF | 76.6562 | 77.125 | 76.3125 | 77.0312 | 2193400.0 |
| 2000-10-13 11:00:00 | QQQ | ETF | 77.0625 | 77.6875 | 76.6875 | 77.1875 | 1934300.0 |
| 2000-10-13 11:30:00 | QQQ | ETF | 77.125 | 78.25 | 77.125 | 78.25 | 3471100.0 |
| 2000-10-13 12:00:00 | QQQ | ETF | 78.0938 | 78.875 | 78.0 | 78.5625 | 3728600.0 |
| 2000-10-13 12:30:00 | QQQ | ETF | 78.5 | 78.6875 | 78.0938 | 78.5625 | 1260200.0 |
| 2000-10-13 13:00:00 | QQQ | ETF | 78.5625 | 79.2188 | 78.5 | 78.9375 | 2321900.0 |
| 2000-10-13 13:30:00 | QQQ | ETF | 78.9375 | 79.8125 | 78.5625 | 79.5 | 2292400.0 |
| 2000-10-13 14:00:00 | QQQ | ETF | 79.6875 | 79.75 | 79.1875 | 79.6875 | 2068400.0 |
| 2000-10-13 14:30:00 | QQQ | ETF | 79.6875 | 80.5625 | 79.5 | 80.375 | 2328200.0 |
| 2000-10-13 15:00:00 | QQQ | ETF | 80.25 | 80.75 | 79.6875 | 80.6875 | 2862400.0 |
| 2000-10-13 15:30:00 | QQQ | ETF | 80.7188 | 81.5 | 80.375 | 81.4375 | 5880600.0 |
| 2000-10-13 16:00:00 | QQQ | ETF | 81.4688 | 81.9375 | 80.75 | 80.75 | 1750900.0 |
| 2000-10-13 16:30:00 | QQQ | ETF | 81.0 | 81.25 | 80.0 | 80.875 | 188200.0 |
| 2000-10-13 17:00:00 | QQQ | ETF | 80.875 | 81.125 | 80.8125 | 80.8125 | 5900.0 |
| 2000-10-13 17:30:00 | QQQ | ETF | 80.8125 | 80.875 | 80.8125 | 80.875 | 3000.0 |
| 2000-10-13 18:00:00 | QQQ | ETF | 80.8125 | 80.8125 | 80.8125 | 80.8125 | 100.0 |
| 2000-10-13 09:30:00 | IWM | ETF | 46.0938 | 46.3438 | 46.0625 | 46.3438 | 7600.0 |
| 2000-10-13 10:00:00 | IWM | ETF | 46.3594 | 46.5781 | 46.3594 | 46.5312 | 5400.0 |
| 2000-10-13 10:30:00 | IWM | ETF | 46.4375 | 46.4375 | 46.3438 | 46.3438 | 10200.0 |
| 2000-10-13 11:00:00 | IWM | ETF | 46.5312 | 46.5781 | 46.5312 | 46.5781 | 1400.0 |
| 2000-10-13 11:30:00 | IWM | ETF | 46.625 | 46.875 | 46.625 | 46.75 | 21000.0 |
| 2000-10-13 12:00:00 | IWM | ETF | 46.9062 | 47.125 | 46.75 | 47.125 | 43000.0 |
| 2000-10-13 12:30:00 | IWM | ETF | 47.125 | 47.125 | 47.0469 | 47.0469 | 3800.0 |
| 2000-10-13 13:00:00 | IWM | ETF | 47.0938 | 47.3125 | 47.0938 | 47.25 | 22200.0 |
| 2000-10-13 13:30:00 | IWM | ETF | 47.3125 | 47.3125 | 47.3125 | 47.3125 | 200.0 |
| 2000-10-13 14:00:00 | IWM | ETF | 47.3906 | 47.3906 | 47.3125 | 47.3438 | 20800.0 |
| 2000-10-13 14:30:00 | IWM | ETF | 47.4375 | 47.5625 | 47.4375 | 47.5312 | 26000.0 |
| 2000-10-13 15:00:00 | IWM | ETF | 47.125 | 47.6875 | 47.125 | 47.6875 | 24400.0 |
| 2000-10-13 15:30:00 | IWM | ETF | 47.7812 | 48.1406 | 47.7812 | 48.1406 | 170000.0 |
| 2000-10-13 16:00:00 | IWM | ETF | 47.9688 | 47.9688 | 47.75 | 47.75 | 22800.0 |
| 2000-10-13 09:30:00 | DIA | ETF | 100.0625 | 101.4375 | 100.0625 | 101.2188 | 397200.0 |
| 2000-10-13 10:00:00 | DIA | ETF | 101.375 | 101.7188 | 100.9375 | 101.5625 | 145900.0 |
| 2000-10-13 10:30:00 | DIA | ETF | 101.4375 | 101.7188 | 101.0312 | 101.5625 | 142200.0 |
> showing 50 of 301 rows — these rows as CSV