PREVIEW / etf_30min / 2000-02-24
file: by_date/etf_30min/2000/2000-02-24.parquet size: 10 KB rows: 221
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-02-24 09:30:00 | SPY | ETF | 136.6875 | 137.0312 | 135.7812 | 135.9375 | 1492700.0 |
| 2000-02-24 10:00:00 | SPY | ETF | 136.0 | 136.0625 | 135.0625 | 135.4375 | 1886000.0 |
| 2000-02-24 10:30:00 | SPY | ETF | 135.3125 | 135.7812 | 133.7812 | 133.9062 | 1871500.0 |
| 2000-02-24 11:00:00 | SPY | ETF | 133.9062 | 134.5312 | 133.6875 | 134.0 | 1830400.0 |
| 2000-02-24 11:30:00 | SPY | ETF | 134.0 | 134.625 | 133.5625 | 134.5625 | 1348900.0 |
| 2000-02-24 12:00:00 | SPY | ETF | 134.5 | 134.8125 | 134.25 | 134.25 | 421000.0 |
| 2000-02-24 12:30:00 | SPY | ETF | 134.25 | 134.6875 | 133.875 | 134.0625 | 1162000.0 |
| 2000-02-24 13:00:00 | SPY | ETF | 134.1875 | 134.9062 | 134.0625 | 134.5 | 297700.0 |
| 2000-02-24 13:30:00 | SPY | ETF | 134.4062 | 134.7812 | 134.0 | 134.0 | 256000.0 |
| 2000-02-24 14:00:00 | SPY | ETF | 134.0 | 134.5312 | 133.0938 | 133.9375 | 1206400.0 |
| 2000-02-24 14:30:00 | SPY | ETF | 133.7188 | 134.3438 | 133.125 | 134.2188 | 1001100.0 |
| 2000-02-24 15:00:00 | SPY | ETF | 134.125 | 136.0 | 134.125 | 136.0 | 2124200.0 |
| 2000-02-24 15:30:00 | SPY | ETF | 136.0 | 136.3438 | 135.0938 | 135.625 | 1264600.0 |
| 2000-02-24 16:00:00 | SPY | ETF | 135.6875 | 135.7188 | 135.3125 | 135.375 | 416300.0 |
| 2000-02-24 17:00:00 | SPY | ETF | 133.8125 | 133.8125 | 133.8125 | 133.8125 | 750000.0 |
| 2000-02-24 09:30:00 | QQQ | ETF | 104.875 | 106.25 | 104.5938 | 105.625 | 5542000.0 |
| 2000-02-24 10:00:00 | QQQ | ETF | 105.6875 | 106.0 | 104.5 | 105.25 | 4777600.0 |
| 2000-02-24 10:30:00 | QQQ | ETF | 105.4688 | 105.4688 | 102.5 | 102.5 | 4836000.0 |
| 2000-02-24 11:00:00 | QQQ | ETF | 103.1562 | 103.75 | 102.0 | 102.875 | 3967000.0 |
| 2000-02-24 11:30:00 | QQQ | ETF | 103.2188 | 104.0 | 102.4375 | 103.875 | 2967800.0 |
| 2000-02-24 12:00:00 | QQQ | ETF | 103.9062 | 104.6875 | 103.5625 | 103.5625 | 3587400.0 |
| 2000-02-24 12:30:00 | QQQ | ETF | 103.5625 | 104.4375 | 103.375 | 103.75 | 2345800.0 |
| 2000-02-24 13:00:00 | QQQ | ETF | 103.8125 | 104.9688 | 103.7812 | 104.2812 | 2320200.0 |
| 2000-02-24 13:30:00 | QQQ | ETF | 104.25 | 104.75 | 103.6875 | 103.6875 | 1071400.0 |
| 2000-02-24 14:00:00 | QQQ | ETF | 103.6875 | 104.25 | 102.25 | 102.875 | 4275400.0 |
| 2000-02-24 14:30:00 | QQQ | ETF | 102.8594 | 104.0625 | 102.1562 | 103.9375 | 4702800.0 |
| 2000-02-24 15:00:00 | QQQ | ETF | 103.875 | 105.8125 | 103.875 | 105.8125 | 4382800.0 |
| 2000-02-24 15:30:00 | QQQ | ETF | 105.8594 | 106.4375 | 105.4688 | 106.1406 | 3076800.0 |
| 2000-02-24 16:00:00 | QQQ | ETF | 106.0625 | 106.7969 | 106.0 | 106.375 | 660800.0 |
| 2000-02-24 16:30:00 | QQQ | ETF | 106.0 | 106.125 | 106.0 | 106.125 | 6600.0 |
| 2000-02-24 17:00:00 | QQQ | ETF | 106.625 | 106.75 | 106.5 | 106.5 | 1000.0 |
| 2000-02-24 18:00:00 | QQQ | ETF | 106.5 | 106.5 | 106.5 | 106.5 | 200.0 |
| 2000-02-24 09:30:00 | DIA | ETF | 102.5625 | 102.6875 | 101.25 | 101.4688 | 234300.0 |
| 2000-02-24 10:00:00 | DIA | ETF | 101.5 | 101.5 | 100.7188 | 101.0 | 273300.0 |
| 2000-02-24 10:30:00 | DIA | ETF | 101.0 | 101.0 | 100.2188 | 100.3125 | 382400.0 |
| 2000-02-24 11:00:00 | DIA | ETF | 100.25 | 100.9062 | 100.0625 | 100.4375 | 883800.0 |
| 2000-02-24 11:30:00 | DIA | ETF | 100.4688 | 100.875 | 100.0938 | 100.75 | 118700.0 |
| 2000-02-24 12:00:00 | DIA | ETF | 100.75 | 100.8125 | 100.25 | 100.3438 | 125100.0 |
| 2000-02-24 12:30:00 | DIA | ETF | 100.375 | 100.6875 | 100.0625 | 100.25 | 251300.0 |
| 2000-02-24 13:00:00 | DIA | ETF | 100.3438 | 100.7812 | 100.1875 | 100.375 | 134200.0 |
| 2000-02-24 13:30:00 | DIA | ETF | 100.4062 | 100.5625 | 100.0625 | 100.125 | 180000.0 |
| 2000-02-24 14:00:00 | DIA | ETF | 100.125 | 100.4688 | 99.5625 | 99.9688 | 614200.0 |
| 2000-02-24 14:30:00 | DIA | ETF | 99.9688 | 100.5 | 99.625 | 100.4062 | 447300.0 |
| 2000-02-24 15:00:00 | DIA | ETF | 100.4375 | 101.5 | 100.2812 | 101.3438 | 547300.0 |
| 2000-02-24 15:30:00 | DIA | ETF | 101.5 | 101.7188 | 100.75 | 100.9375 | 284200.0 |
| 2000-02-24 16:00:00 | DIA | ETF | 100.9375 | 101.125 | 100.7812 | 101.125 | 20400.0 |
| 2000-02-24 16:30:00 | DIA | ETF | 101.125 | 101.125 | 101.125 | 101.125 | 700.0 |
| 2000-02-24 17:30:00 | DIA | ETF | 102.0 | 102.0 | 102.0 | 102.0 | 100.0 |
> showing 48 of 221 rows — these rows as CSV