PREVIEW / etf_30min / 2000-05-09
file: by_date/etf_30min/2000/2000-05-09.parquet size: 9 KB rows: 197
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-09 09:30:00 | SPY | ETF | 143.0625 | 143.4062 | 142.7812 | 142.9688 | 456300.0 |
| 2000-05-09 10:00:00 | SPY | ETF | 142.9688 | 143.0 | 142.5312 | 143.0 | 465700.0 |
| 2000-05-09 10:30:00 | SPY | ETF | 142.9062 | 142.9375 | 141.5 | 141.7812 | 726400.0 |
| 2000-05-09 11:00:00 | SPY | ETF | 141.875 | 142.3438 | 141.3125 | 141.5625 | 270700.0 |
| 2000-05-09 11:30:00 | SPY | ETF | 141.6875 | 142.1562 | 141.5938 | 141.8438 | 220200.0 |
| 2000-05-09 12:00:00 | SPY | ETF | 141.8125 | 142.0 | 141.1875 | 141.625 | 206900.0 |
| 2000-05-09 12:30:00 | SPY | ETF | 141.625 | 141.75 | 141.0625 | 141.3125 | 374300.0 |
| 2000-05-09 13:00:00 | SPY | ETF | 141.2812 | 141.6562 | 141.1562 | 141.5 | 168800.0 |
| 2000-05-09 13:30:00 | SPY | ETF | 141.5625 | 141.5625 | 140.6562 | 140.7812 | 459400.0 |
| 2000-05-09 14:00:00 | SPY | ETF | 140.8438 | 141.1875 | 140.25 | 141.1875 | 360900.0 |
| 2000-05-09 14:30:00 | SPY | ETF | 141.0312 | 141.625 | 140.75 | 141.3438 | 804900.0 |
| 2000-05-09 15:00:00 | SPY | ETF | 141.5312 | 141.7188 | 140.7812 | 141.5 | 269900.0 |
| 2000-05-09 15:30:00 | SPY | ETF | 141.5312 | 142.375 | 141.5312 | 141.625 | 441000.0 |
| 2000-05-09 16:00:00 | SPY | ETF | 141.8438 | 141.8438 | 141.3125 | 141.3125 | 363400.0 |
| 2000-05-09 16:30:00 | SPY | ETF | 141.3125 | 141.3125 | 141.3125 | 141.3125 | 500.0 |
| 2000-05-09 09:30:00 | QQQ | ETF | 88.5 | 89.125 | 87.75 | 88.0 | 2614000.0 |
| 2000-05-09 10:00:00 | QQQ | ETF | 87.75 | 88.0 | 86.125 | 86.8125 | 2462900.0 |
| 2000-05-09 10:30:00 | QQQ | ETF | 86.8125 | 86.8125 | 85.375 | 86.125 | 2384200.0 |
| 2000-05-09 11:00:00 | QQQ | ETF | 86.1875 | 86.5 | 85.0 | 85.75 | 786600.0 |
| 2000-05-09 11:30:00 | QQQ | ETF | 85.875 | 86.8125 | 85.75 | 86.4062 | 1161300.0 |
| 2000-05-09 12:00:00 | QQQ | ETF | 86.375 | 86.5 | 85.625 | 86.0 | 570700.0 |
| 2000-05-09 12:30:00 | QQQ | ETF | 86.0 | 86.3125 | 85.5625 | 85.8125 | 697600.0 |
| 2000-05-09 13:00:00 | QQQ | ETF | 85.75 | 86.1875 | 85.625 | 86.0 | 456400.0 |
| 2000-05-09 13:30:00 | QQQ | ETF | 85.9375 | 86.0 | 85.125 | 85.25 | 1109700.0 |
| 2000-05-09 14:00:00 | QQQ | ETF | 85.1875 | 85.875 | 84.75 | 85.6875 | 1988900.0 |
| 2000-05-09 14:30:00 | QQQ | ETF | 85.625 | 87.0 | 85.4375 | 86.75 | 1678200.0 |
| 2000-05-09 15:00:00 | QQQ | ETF | 86.625 | 87.0 | 85.875 | 86.75 | 1333400.0 |
| 2000-05-09 15:30:00 | QQQ | ETF | 86.75 | 87.5625 | 86.0 | 86.1562 | 2185400.0 |
| 2000-05-09 16:00:00 | QQQ | ETF | 86.0625 | 86.0625 | 85.375 | 85.625 | 287300.0 |
| 2000-05-09 16:30:00 | QQQ | ETF | 85.5 | 86.0 | 85.5 | 85.5 | 1500.0 |
| 2000-05-09 17:00:00 | QQQ | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 2500.0 |
| 2000-05-09 17:30:00 | QQQ | ETF | 85.75 | 85.75 | 85.75 | 85.75 | 1600.0 |
| 2000-05-09 18:00:00 | QQQ | ETF | 85.5 | 86.0 | 85.5 | 86.0 | 1200.0 |
| 2000-05-09 09:30:00 | DIA | ETF | 106.0625 | 106.6875 | 106.0625 | 106.4375 | 110200.0 |
| 2000-05-09 10:00:00 | DIA | ETF | 106.625 | 106.9375 | 106.3125 | 106.7188 | 99400.0 |
| 2000-05-09 10:30:00 | DIA | ETF | 106.875 | 106.9062 | 105.75 | 106.0938 | 128600.0 |
| 2000-05-09 11:00:00 | DIA | ETF | 105.9375 | 106.5 | 105.5 | 105.7812 | 125000.0 |
| 2000-05-09 11:30:00 | DIA | ETF | 105.8125 | 106.2188 | 105.625 | 105.75 | 76300.0 |
| 2000-05-09 12:00:00 | DIA | ETF | 105.7812 | 105.9375 | 105.375 | 105.5 | 44900.0 |
| 2000-05-09 12:30:00 | DIA | ETF | 105.5 | 105.8438 | 105.375 | 105.4062 | 118900.0 |
| 2000-05-09 13:00:00 | DIA | ETF | 105.5 | 105.8125 | 105.375 | 105.7188 | 182700.0 |
| 2000-05-09 13:30:00 | DIA | ETF | 105.4375 | 105.5938 | 105.125 | 105.25 | 47600.0 |
| 2000-05-09 14:00:00 | DIA | ETF | 105.1875 | 105.4375 | 105.0 | 105.4375 | 47000.0 |
| 2000-05-09 14:30:00 | DIA | ETF | 105.4062 | 105.625 | 105.25 | 105.5938 | 54000.0 |
| 2000-05-09 15:00:00 | DIA | ETF | 105.4375 | 105.625 | 105.0938 | 105.4375 | 77400.0 |
| 2000-05-09 15:30:00 | DIA | ETF | 105.6875 | 105.875 | 105.4062 | 105.5625 | 76400.0 |
| 2000-05-09 16:00:00 | DIA | ETF | 105.3438 | 105.5 | 105.3125 | 105.375 | 6200.0 |
> showing 47 of 197 rows — these rows as CSV