PREVIEW / etf_30min / 2000-05-23
file: by_date/etf_30min/2000/2000-05-23.parquet size: 9 KB rows: 190
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-23 09:30:00 | SPY | ETF | 140.4375 | 140.8125 | 139.5625 | 139.5625 | 1377800.0 |
| 2000-05-23 10:00:00 | SPY | ETF | 139.5625 | 139.75 | 138.7812 | 139.3125 | 709700.0 |
| 2000-05-23 10:30:00 | SPY | ETF | 139.3125 | 139.9375 | 139.0625 | 139.75 | 495700.0 |
| 2000-05-23 11:00:00 | SPY | ETF | 139.6875 | 140.5 | 139.5312 | 140.5 | 510800.0 |
| 2000-05-23 11:30:00 | SPY | ETF | 140.4688 | 140.5625 | 140.0 | 140.3125 | 463700.0 |
| 2000-05-23 12:00:00 | SPY | ETF | 140.4375 | 140.4375 | 139.4688 | 139.7812 | 147400.0 |
| 2000-05-23 12:30:00 | SPY | ETF | 139.6875 | 139.6875 | 139.2188 | 139.4375 | 265400.0 |
| 2000-05-23 13:00:00 | SPY | ETF | 139.5 | 139.7812 | 139.0625 | 139.625 | 430800.0 |
| 2000-05-23 13:30:00 | SPY | ETF | 139.625 | 140.0938 | 139.4062 | 140.0938 | 140400.0 |
| 2000-05-23 14:00:00 | SPY | ETF | 140.0 | 140.2188 | 139.625 | 139.625 | 652600.0 |
| 2000-05-23 14:30:00 | SPY | ETF | 139.875 | 140.0 | 138.8125 | 138.8125 | 157800.0 |
| 2000-05-23 15:00:00 | SPY | ETF | 138.8125 | 139.1875 | 138.0312 | 138.25 | 690300.0 |
| 2000-05-23 15:30:00 | SPY | ETF | 138.3438 | 139.0625 | 137.5625 | 137.5625 | 1021000.0 |
| 2000-05-23 16:00:00 | SPY | ETF | 137.75 | 138.1562 | 137.5625 | 138.0 | 607300.0 |
| 2000-05-23 09:30:00 | QQQ | ETF | 81.375 | 82.625 | 80.1562 | 80.1562 | 4551100.0 |
| 2000-05-23 10:00:00 | QQQ | ETF | 80.1562 | 80.5 | 78.5 | 79.0 | 3276300.0 |
| 2000-05-23 10:30:00 | QQQ | ETF | 79.3125 | 80.75 | 79.0 | 80.5 | 1830800.0 |
| 2000-05-23 11:00:00 | QQQ | ETF | 80.625 | 81.625 | 80.25 | 81.5 | 1652900.0 |
| 2000-05-23 11:30:00 | QQQ | ETF | 81.5625 | 81.6875 | 80.625 | 81.1562 | 1208800.0 |
| 2000-05-23 12:00:00 | QQQ | ETF | 81.25 | 81.25 | 79.75 | 80.2188 | 830900.0 |
| 2000-05-23 12:30:00 | QQQ | ETF | 80.125 | 80.25 | 79.25 | 79.8438 | 1010100.0 |
| 2000-05-23 13:00:00 | QQQ | ETF | 79.8125 | 80.4375 | 79.375 | 80.25 | 1127400.0 |
| 2000-05-23 13:30:00 | QQQ | ETF | 80.0625 | 80.8125 | 79.5 | 80.75 | 1247000.0 |
| 2000-05-23 14:00:00 | QQQ | ETF | 80.8125 | 81.0 | 80.0938 | 80.3438 | 1461800.0 |
| 2000-05-23 14:30:00 | QQQ | ETF | 80.3125 | 80.375 | 78.125 | 78.1875 | 2861900.0 |
| 2000-05-23 15:00:00 | QQQ | ETF | 78.125 | 78.75 | 76.875 | 77.4375 | 3432900.0 |
| 2000-05-23 15:30:00 | QQQ | ETF | 77.5 | 78.5 | 75.3125 | 75.75 | 5689300.0 |
| 2000-05-23 16:00:00 | QQQ | ETF | 75.5 | 76.25 | 74.625 | 75.0 | 1537400.0 |
| 2000-05-23 16:30:00 | QQQ | ETF | 75.0625 | 75.125 | 74.625 | 74.75 | 10500.0 |
| 2000-05-23 17:00:00 | QQQ | ETF | 74.875 | 75.25 | 74.75 | 75.0 | 7000.0 |
| 2000-05-23 17:30:00 | QQQ | ETF | 74.9375 | 75.125 | 74.75 | 74.8125 | 7100.0 |
| 2000-05-23 18:00:00 | QQQ | ETF | 74.8125 | 74.8125 | 74.5 | 74.8125 | 3500.0 |
| 2000-05-23 09:30:00 | DIA | ETF | 105.5938 | 105.6562 | 105.0312 | 105.0312 | 56700.0 |
| 2000-05-23 10:00:00 | DIA | ETF | 105.1562 | 105.25 | 104.8125 | 104.8125 | 20300.0 |
| 2000-05-23 10:30:00 | DIA | ETF | 105.25 | 105.3125 | 105.0 | 105.3125 | 95400.0 |
| 2000-05-23 11:00:00 | DIA | ETF | 105.3125 | 105.6875 | 105.0312 | 105.5938 | 66000.0 |
| 2000-05-23 11:30:00 | DIA | ETF | 105.5 | 105.6562 | 105.375 | 105.5 | 34300.0 |
| 2000-05-23 12:00:00 | DIA | ETF | 105.625 | 105.625 | 105.1875 | 105.1875 | 5800.0 |
| 2000-05-23 12:30:00 | DIA | ETF | 105.2188 | 105.2188 | 105.0 | 105.2188 | 5300.0 |
| 2000-05-23 13:00:00 | DIA | ETF | 105.1875 | 105.1875 | 104.625 | 105.125 | 54500.0 |
| 2000-05-23 13:30:00 | DIA | ETF | 105.0 | 105.25 | 105.0 | 105.25 | 1200.0 |
| 2000-05-23 14:00:00 | DIA | ETF | 105.375 | 105.4688 | 105.125 | 105.3125 | 5700.0 |
| 2000-05-23 14:30:00 | DIA | ETF | 105.125 | 105.3438 | 104.5625 | 104.6875 | 6600.0 |
| 2000-05-23 15:00:00 | DIA | ETF | 104.6875 | 104.9375 | 104.0625 | 104.0625 | 123100.0 |
| 2000-05-23 15:30:00 | DIA | ETF | 104.1562 | 104.7812 | 104.0312 | 104.0625 | 207000.0 |
| 2000-05-23 16:00:00 | DIA | ETF | 104.25 | 104.5 | 104.25 | 104.4375 | 33400.0 |
> showing 46 of 190 rows — these rows as CSV