PREVIEW / etf_30min / 2000-05-10
file: by_date/etf_30min/2000/2000-05-10.parquet size: 10 KB rows: 211
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-05-10 09:30:00 | SPY | ETF | 140.5 | 140.9688 | 140.0625 | 140.5 | 697800.0 |
| 2000-05-10 10:00:00 | SPY | ETF | 140.5 | 140.625 | 139.1562 | 139.8125 | 1085800.0 |
| 2000-05-10 10:30:00 | SPY | ETF | 139.7812 | 140.0 | 138.875 | 139.375 | 483800.0 |
| 2000-05-10 11:00:00 | SPY | ETF | 139.25 | 139.5625 | 138.875 | 139.5625 | 590400.0 |
| 2000-05-10 11:30:00 | SPY | ETF | 139.5938 | 139.5938 | 138.625 | 139.0625 | 469700.0 |
| 2000-05-10 12:00:00 | SPY | ETF | 138.9688 | 139.375 | 138.625 | 139.375 | 700700.0 |
| 2000-05-10 12:30:00 | SPY | ETF | 139.3125 | 139.3125 | 138.875 | 138.9688 | 190000.0 |
| 2000-05-10 13:00:00 | SPY | ETF | 138.875 | 138.9688 | 137.8125 | 137.9375 | 467000.0 |
| 2000-05-10 13:30:00 | SPY | ETF | 138.0312 | 138.7812 | 137.75 | 138.625 | 565700.0 |
| 2000-05-10 14:00:00 | SPY | ETF | 138.6875 | 139.0938 | 138.375 | 139.0 | 699200.0 |
| 2000-05-10 14:30:00 | SPY | ETF | 139.125 | 139.9375 | 138.9375 | 139.875 | 790500.0 |
| 2000-05-10 15:00:00 | SPY | ETF | 139.9062 | 140.625 | 139.4062 | 139.4062 | 1551700.0 |
| 2000-05-10 15:30:00 | SPY | ETF | 139.375 | 139.4688 | 138.25 | 138.5938 | 1419500.0 |
| 2000-05-10 16:00:00 | SPY | ETF | 138.625 | 138.7812 | 138.125 | 138.125 | 519200.0 |
| 2000-05-10 16:30:00 | SPY | ETF | 138.125 | 138.125 | 138.125 | 138.125 | 200.0 |
| 2000-05-10 09:30:00 | QQQ | ETF | 84.375 | 84.9688 | 83.875 | 84.125 | 3431300.0 |
| 2000-05-10 10:00:00 | QQQ | ETF | 84.125 | 84.4375 | 82.1562 | 83.0 | 3592300.0 |
| 2000-05-10 10:30:00 | QQQ | ETF | 83.2188 | 83.375 | 82.0 | 82.1875 | 2612500.0 |
| 2000-05-10 11:00:00 | QQQ | ETF | 82.125 | 82.75 | 81.8125 | 82.25 | 1717800.0 |
| 2000-05-10 11:30:00 | QQQ | ETF | 82.4375 | 82.4375 | 81.5 | 81.625 | 2151300.0 |
| 2000-05-10 12:00:00 | QQQ | ETF | 81.625 | 82.1875 | 81.0625 | 82.125 | 1644600.0 |
| 2000-05-10 12:30:00 | QQQ | ETF | 82.125 | 82.5 | 81.5 | 81.625 | 2420500.0 |
| 2000-05-10 13:00:00 | QQQ | ETF | 81.625 | 81.9062 | 81.0312 | 81.0312 | 1159900.0 |
| 2000-05-10 13:30:00 | QQQ | ETF | 81.0312 | 82.3438 | 80.8125 | 82.1875 | 2206200.0 |
| 2000-05-10 14:00:00 | QQQ | ETF | 82.25 | 82.5 | 81.6875 | 82.25 | 2587300.0 |
| 2000-05-10 14:30:00 | QQQ | ETF | 82.25 | 83.25 | 82.1875 | 83.25 | 3326500.0 |
| 2000-05-10 15:00:00 | QQQ | ETF | 83.25 | 84.375 | 82.5 | 82.8438 | 2706200.0 |
| 2000-05-10 15:30:00 | QQQ | ETF | 82.5 | 82.9688 | 80.75 | 80.9688 | 3333900.0 |
| 2000-05-10 16:00:00 | QQQ | ETF | 81.0 | 81.375 | 80.0 | 80.5 | 1762600.0 |
| 2000-05-10 16:30:00 | QQQ | ETF | 80.0 | 80.4375 | 79.5 | 79.75 | 45100.0 |
| 2000-05-10 17:00:00 | QQQ | ETF | 80.0 | 80.0 | 79.625 | 79.75 | 19000.0 |
| 2000-05-10 17:30:00 | QQQ | ETF | 79.75 | 79.9375 | 79.6875 | 79.75 | 13000.0 |
| 2000-05-10 18:00:00 | QQQ | ETF | 79.875 | 79.875 | 79.75 | 79.75 | 8200.0 |
| 2000-05-10 09:30:00 | DIA | ETF | 104.5312 | 105.0938 | 104.5312 | 104.8125 | 110700.0 |
| 2000-05-10 10:00:00 | DIA | ETF | 105.0 | 105.0 | 104.0 | 104.3438 | 216300.0 |
| 2000-05-10 10:30:00 | DIA | ETF | 104.25 | 104.5 | 103.6875 | 104.0 | 104800.0 |
| 2000-05-10 11:00:00 | DIA | ETF | 104.125 | 104.125 | 103.5312 | 103.875 | 22700.0 |
| 2000-05-10 11:30:00 | DIA | ETF | 103.875 | 104.0938 | 103.6875 | 103.75 | 24900.0 |
| 2000-05-10 12:00:00 | DIA | ETF | 103.9062 | 104.2188 | 103.75 | 104.2188 | 30700.0 |
| 2000-05-10 12:30:00 | DIA | ETF | 104.0938 | 104.1875 | 103.75 | 103.75 | 116600.0 |
| 2000-05-10 13:00:00 | DIA | ETF | 103.875 | 103.9375 | 103.0625 | 103.1562 | 28300.0 |
| 2000-05-10 13:30:00 | DIA | ETF | 103.0312 | 103.5938 | 102.625 | 103.5 | 378300.0 |
| 2000-05-10 14:00:00 | DIA | ETF | 103.375 | 103.75 | 103.2812 | 103.7188 | 93600.0 |
| 2000-05-10 14:30:00 | DIA | ETF | 103.75 | 104.4375 | 103.5 | 104.3438 | 57400.0 |
| 2000-05-10 15:00:00 | DIA | ETF | 104.3438 | 104.7188 | 103.8125 | 103.875 | 254300.0 |
| 2000-05-10 15:30:00 | DIA | ETF | 103.875 | 104.0625 | 103.2812 | 103.625 | 289600.0 |
| 2000-05-10 16:00:00 | DIA | ETF | 103.4375 | 103.5 | 103.25 | 103.3125 | 103200.0 |
> showing 47 of 211 rows — these rows as CSV