PREVIEW / etf_30min / 2000-10-20
file: by_date/etf_30min/2000/2000-10-20.parquet size: 11 KB rows: 281
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-20 09:30:00 | SPY | ETF | 138.375 | 139.4375 | 138.375 | 139.125 | 1072400.0 |
| 2000-10-20 10:00:00 | SPY | ETF | 138.9062 | 139.5 | 138.9062 | 139.375 | 204100.0 |
| 2000-10-20 10:30:00 | SPY | ETF | 139.25 | 139.8438 | 139.1562 | 139.5938 | 340000.0 |
| 2000-10-20 11:00:00 | SPY | ETF | 139.5938 | 140.0938 | 139.375 | 139.875 | 427300.0 |
| 2000-10-20 11:30:00 | SPY | ETF | 139.75 | 140.25 | 139.75 | 140.2188 | 240900.0 |
| 2000-10-20 12:00:00 | SPY | ETF | 140.2188 | 140.5 | 139.9375 | 140.4062 | 1310400.0 |
| 2000-10-20 12:30:00 | SPY | ETF | 140.25 | 140.4688 | 140.0938 | 140.4375 | 173400.0 |
| 2000-10-20 13:00:00 | SPY | ETF | 140.4375 | 140.8125 | 140.3125 | 140.6562 | 135800.0 |
| 2000-10-20 13:30:00 | SPY | ETF | 140.75 | 141.1875 | 140.6875 | 140.875 | 725000.0 |
| 2000-10-20 14:00:00 | SPY | ETF | 140.875 | 140.9375 | 140.375 | 140.5312 | 528600.0 |
| 2000-10-20 14:30:00 | SPY | ETF | 140.625 | 140.8438 | 140.0312 | 140.25 | 377900.0 |
| 2000-10-20 15:00:00 | SPY | ETF | 140.25 | 140.4062 | 139.9375 | 140.25 | 479500.0 |
| 2000-10-20 15:30:00 | SPY | ETF | 140.3125 | 140.3438 | 139.6875 | 139.875 | 496700.0 |
| 2000-10-20 16:00:00 | SPY | ETF | 139.9375 | 140.3438 | 139.8125 | 139.9062 | 469400.0 |
| 2000-10-20 16:30:00 | SPY | ETF | 139.9062 | 139.9062 | 139.9062 | 139.9062 | 500.0 |
| 2000-10-20 09:30:00 | QQQ | ETF | 84.5 | 85.875 | 84.375 | 84.9688 | 9049500.0 |
| 2000-10-20 10:00:00 | QQQ | ETF | 84.75 | 85.6875 | 84.75 | 85.5 | 4456300.0 |
| 2000-10-20 10:30:00 | QQQ | ETF | 85.5312 | 86.4375 | 85.375 | 86.1562 | 3730800.0 |
| 2000-10-20 11:00:00 | QQQ | ETF | 86.1562 | 86.9688 | 86.0 | 86.5625 | 2500500.0 |
| 2000-10-20 11:30:00 | QQQ | ETF | 86.5625 | 87.0625 | 86.5312 | 86.8125 | 2575500.0 |
| 2000-10-20 12:00:00 | QQQ | ETF | 86.8125 | 86.875 | 86.3125 | 86.8438 | 1985000.0 |
| 2000-10-20 12:30:00 | QQQ | ETF | 86.8438 | 86.875 | 86.375 | 86.75 | 1430700.0 |
| 2000-10-20 13:00:00 | QQQ | ETF | 86.75 | 87.25 | 86.5625 | 87.125 | 1522600.0 |
| 2000-10-20 13:30:00 | QQQ | ETF | 87.0938 | 87.75 | 87.0312 | 87.375 | 2552400.0 |
| 2000-10-20 14:00:00 | QQQ | ETF | 87.3438 | 87.5 | 86.625 | 87.0 | 1656700.0 |
| 2000-10-20 14:30:00 | QQQ | ETF | 87.0 | 87.25 | 86.375 | 86.75 | 1757700.0 |
| 2000-10-20 15:00:00 | QQQ | ETF | 86.7188 | 86.75 | 85.9375 | 86.75 | 3032000.0 |
| 2000-10-20 15:30:00 | QQQ | ETF | 86.7188 | 86.75 | 85.75 | 85.9375 | 3121200.0 |
| 2000-10-20 16:00:00 | QQQ | ETF | 86.0625 | 86.375 | 85.8125 | 86.25 | 902600.0 |
| 2000-10-20 16:30:00 | QQQ | ETF | 86.3125 | 86.3125 | 86.0 | 86.3125 | 9000.0 |
| 2000-10-20 17:00:00 | QQQ | ETF | 86.25 | 87.0 | 86.25 | 86.4375 | 9500.0 |
| 2000-10-20 17:30:00 | QQQ | ETF | 86.8125 | 86.8125 | 86.25 | 86.375 | 7200.0 |
| 2000-10-20 18:00:00 | QQQ | ETF | 86.375 | 86.6875 | 86.25 | 86.25 | 1300.0 |
| 2000-10-20 09:30:00 | IWM | ETF | 48.3438 | 48.4062 | 48.3438 | 48.4062 | 1400.0 |
| 2000-10-20 10:00:00 | IWM | ETF | 48.3125 | 48.4062 | 48.3125 | 48.4062 | 52200.0 |
| 2000-10-20 10:30:00 | IWM | ETF | 48.3438 | 48.5938 | 48.3438 | 48.5938 | 44000.0 |
| 2000-10-20 11:00:00 | IWM | ETF | 48.5156 | 48.625 | 48.5156 | 48.625 | 14000.0 |
| 2000-10-20 11:30:00 | IWM | ETF | 48.7188 | 48.7969 | 48.6875 | 48.7969 | 3800.0 |
| 2000-10-20 12:00:00 | IWM | ETF | 48.8125 | 48.8125 | 48.6406 | 48.8125 | 47800.0 |
| 2000-10-20 12:30:00 | IWM | ETF | 48.7188 | 48.7188 | 48.7188 | 48.7188 | 37800.0 |
| 2000-10-20 13:00:00 | IWM | ETF | 48.8438 | 48.875 | 48.8438 | 48.875 | 7200.0 |
| 2000-10-20 13:30:00 | IWM | ETF | 48.9688 | 49.0312 | 48.9062 | 48.9062 | 16800.0 |
| 2000-10-20 14:00:00 | IWM | ETF | 49.0 | 49.0 | 49.0 | 49.0 | 200.0 |
| 2000-10-20 14:30:00 | IWM | ETF | 49.0312 | 49.0312 | 48.75 | 48.9062 | 10200.0 |
| 2000-10-20 15:00:00 | IWM | ETF | 48.7188 | 48.8125 | 48.7188 | 48.7188 | 13600.0 |
| 2000-10-20 15:30:00 | IWM | ETF | 48.7188 | 48.7812 | 48.625 | 48.6875 | 12000.0 |
| 2000-10-20 16:00:00 | IWM | ETF | 48.6875 | 48.6875 | 48.5781 | 48.5781 | 2200.0 |
| 2000-10-20 09:30:00 | DIA | ETF | 100.875 | 101.625 | 100.875 | 101.375 | 118000.0 |
| 2000-10-20 10:00:00 | DIA | ETF | 101.3438 | 101.3438 | 100.875 | 101.0625 | 57300.0 |
| 2000-10-20 10:30:00 | DIA | ETF | 101.2188 | 101.2812 | 100.8125 | 100.9375 | 45100.0 |
> showing 50 of 281 rows — these rows as CSV