PREVIEW / etf_30min / 2000-03-29
file: by_date/etf_30min/2000/2000-03-29.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-03-29 09:30:00 | SPY | ETF | 151.5625 | 152.0312 | 150.9375 | 151.0 | 642500.0 |
| 2000-03-29 10:00:00 | SPY | ETF | 151.0312 | 152.0938 | 151.0312 | 152.0938 | 342900.0 |
| 2000-03-29 10:30:00 | SPY | ETF | 152.0 | 152.2188 | 151.3125 | 151.375 | 408500.0 |
| 2000-03-29 11:00:00 | SPY | ETF | 151.25 | 151.4062 | 150.125 | 150.5625 | 1023800.0 |
| 2000-03-29 11:30:00 | SPY | ETF | 150.375 | 150.7188 | 149.6562 | 150.4062 | 715700.0 |
| 2000-03-29 12:00:00 | SPY | ETF | 150.4062 | 151.0 | 150.3125 | 150.75 | 225900.0 |
| 2000-03-29 12:30:00 | SPY | ETF | 150.6562 | 150.6875 | 149.75 | 150.125 | 378100.0 |
| 2000-03-29 13:00:00 | SPY | ETF | 150.0938 | 150.7188 | 149.8125 | 150.375 | 167000.0 |
| 2000-03-29 13:30:00 | SPY | ETF | 150.375 | 150.75 | 150.1562 | 150.1562 | 90000.0 |
| 2000-03-29 14:00:00 | SPY | ETF | 150.1562 | 151.0 | 150.0 | 151.0 | 122500.0 |
| 2000-03-29 14:30:00 | SPY | ETF | 151.0 | 151.7812 | 151.0 | 151.125 | 408300.0 |
| 2000-03-29 15:00:00 | SPY | ETF | 150.9062 | 152.4688 | 150.9062 | 151.9688 | 1003100.0 |
| 2000-03-29 15:30:00 | SPY | ETF | 152.0312 | 152.0938 | 150.8125 | 151.0312 | 798200.0 |
| 2000-03-29 16:00:00 | SPY | ETF | 151.2188 | 151.4688 | 151.0312 | 151.2188 | 295600.0 |
| 2000-03-29 09:30:00 | QQQ | ETF | 115.375 | 115.4375 | 113.1875 | 113.4375 | 2396700.0 |
| 2000-03-29 10:00:00 | QQQ | ETF | 113.4375 | 114.0 | 112.75 | 113.9375 | 2363300.0 |
| 2000-03-29 10:30:00 | QQQ | ETF | 113.875 | 114.0 | 112.25 | 112.625 | 1280600.0 |
| 2000-03-29 11:00:00 | QQQ | ETF | 112.625 | 112.75 | 110.375 | 111.2812 | 3504400.0 |
| 2000-03-29 11:30:00 | QQQ | ETF | 111.1875 | 112.0 | 110.25 | 111.625 | 2305400.0 |
| 2000-03-29 12:00:00 | QQQ | ETF | 111.6875 | 112.0 | 111.125 | 111.5 | 898100.0 |
| 2000-03-29 12:30:00 | QQQ | ETF | 111.5 | 111.5625 | 110.0312 | 110.5 | 1493100.0 |
| 2000-03-29 13:00:00 | QQQ | ETF | 110.25 | 111.875 | 110.25 | 111.4062 | 1577900.0 |
| 2000-03-29 13:30:00 | QQQ | ETF | 111.5 | 111.7188 | 110.5 | 110.5 | 949800.0 |
| 2000-03-29 14:00:00 | QQQ | ETF | 110.75 | 111.625 | 110.0 | 111.5625 | 2519700.0 |
| 2000-03-29 14:30:00 | QQQ | ETF | 111.6875 | 112.625 | 111.25 | 111.375 | 2021100.0 |
| 2000-03-29 15:00:00 | QQQ | ETF | 111.25 | 113.25 | 110.9688 | 112.125 | 2211200.0 |
| 2000-03-29 15:30:00 | QQQ | ETF | 112.375 | 112.375 | 110.0 | 110.0312 | 2831800.0 |
| 2000-03-29 16:00:00 | QQQ | ETF | 110.25 | 110.375 | 110.0312 | 110.1875 | 746800.0 |
| 2000-03-29 16:30:00 | QQQ | ETF | 110.25 | 110.625 | 110.25 | 110.625 | 800.0 |
| 2000-03-29 17:00:00 | QQQ | ETF | 110.5 | 110.5 | 110.375 | 110.375 | 300.0 |
| 2000-03-29 17:30:00 | QQQ | ETF | 110.25 | 110.25 | 110.25 | 110.25 | 1100.0 |
| 2000-03-29 18:00:00 | QQQ | ETF | 110.25 | 110.25 | 110.0 | 110.0 | 300.0 |
| 2000-03-29 09:30:00 | DIA | ETF | 109.8438 | 110.0625 | 109.4062 | 109.625 | 106700.0 |
| 2000-03-29 10:00:00 | DIA | ETF | 109.5625 | 110.375 | 109.5625 | 110.375 | 122300.0 |
| 2000-03-29 10:30:00 | DIA | ETF | 110.3438 | 110.4062 | 109.9688 | 110.0 | 92400.0 |
| 2000-03-29 11:00:00 | DIA | ETF | 109.875 | 109.9688 | 109.5 | 109.6562 | 180800.0 |
| 2000-03-29 11:30:00 | DIA | ETF | 109.5 | 109.6562 | 108.9375 | 109.5625 | 134000.0 |
| 2000-03-29 12:00:00 | DIA | ETF | 109.375 | 109.6562 | 109.25 | 109.5 | 36200.0 |
| 2000-03-29 12:30:00 | DIA | ETF | 109.5 | 109.5625 | 109.0 | 109.1875 | 38700.0 |
| 2000-03-29 13:00:00 | DIA | ETF | 109.2188 | 109.5625 | 109.125 | 109.4062 | 20600.0 |
| 2000-03-29 13:30:00 | DIA | ETF | 109.375 | 109.625 | 109.1562 | 109.3438 | 41800.0 |
| 2000-03-29 14:00:00 | DIA | ETF | 109.25 | 109.875 | 109.125 | 109.8438 | 45700.0 |
| 2000-03-29 14:30:00 | DIA | ETF | 109.9688 | 110.25 | 109.4688 | 109.9375 | 52800.0 |
| 2000-03-29 15:00:00 | DIA | ETF | 110.125 | 111.2188 | 110.0625 | 110.9375 | 368400.0 |
| 2000-03-29 15:30:00 | DIA | ETF | 110.9062 | 111.0625 | 110.1562 | 110.4375 | 158300.0 |
| 2000-03-29 16:00:00 | DIA | ETF | 110.4375 | 110.7188 | 110.4375 | 110.7188 | 22100.0 |
| 2000-03-29 18:00:00 | DIA | ETF | 110.75 | 110.75 | 110.75 | 110.75 | 500.0 |
> showing 47 of 211 rows — these rows as CSV