PREVIEW / etf_30min / 2000-03-10
file: by_date/etf_30min/2000/2000-03-10.parquet size: 10 KB rows: 227
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-10 09:30:00 | SPY | ETF | 140.1875 | 141.5 | 140.125 | 141.375 | 2172400.0 |
| 2000-03-10 10:00:00 | SPY | ETF | 141.5 | 141.5 | 140.9375 | 141.2188 | 347900.0 |
| 2000-03-10 10:30:00 | SPY | ETF | 141.1875 | 142.0 | 141.0625 | 141.3438 | 518600.0 |
| 2000-03-10 11:00:00 | SPY | ETF | 141.4375 | 141.5938 | 140.75 | 140.9375 | 1328900.0 |
| 2000-03-10 11:30:00 | SPY | ETF | 141.125 | 141.1875 | 140.0 | 140.125 | 773000.0 |
| 2000-03-10 12:00:00 | SPY | ETF | 140.3125 | 140.5625 | 139.8125 | 140.4375 | 174400.0 |
| 2000-03-10 12:30:00 | SPY | ETF | 140.3125 | 140.7188 | 140.125 | 140.4688 | 100300.0 |
| 2000-03-10 13:00:00 | SPY | ETF | 140.5312 | 140.9375 | 140.25 | 140.7188 | 138700.0 |
| 2000-03-10 13:30:00 | SPY | ETF | 140.75 | 141.125 | 140.25 | 141.0 | 158100.0 |
| 2000-03-10 14:00:00 | SPY | ETF | 140.9688 | 141.1562 | 140.5938 | 141.0 | 233800.0 |
| 2000-03-10 14:30:00 | SPY | ETF | 141.0 | 141.1875 | 140.1562 | 140.1562 | 133500.0 |
| 2000-03-10 15:00:00 | SPY | ETF | 140.125 | 141.0312 | 140.125 | 140.6562 | 495600.0 |
| 2000-03-10 15:30:00 | SPY | ETF | 140.75 | 140.75 | 139.5312 | 140.0 | 942000.0 |
| 2000-03-10 16:00:00 | SPY | ETF | 139.8125 | 140.25 | 139.8125 | 140.1875 | 385100.0 |
| 2000-03-10 17:00:00 | SPY | ETF | 140.125 | 140.125 | 140.125 | 140.125 | 100.0 |
| 2000-03-10 09:30:00 | QQQ | ETF | 114.875 | 116.25 | 114.5 | 115.9375 | 5963000.0 |
| 2000-03-10 10:00:00 | QQQ | ETF | 115.9375 | 116.0 | 115.3125 | 115.5625 | 1758000.0 |
| 2000-03-10 10:30:00 | QQQ | ETF | 115.5938 | 116.4062 | 115.5312 | 115.9688 | 1301800.0 |
| 2000-03-10 11:00:00 | QQQ | ETF | 115.9375 | 116.125 | 114.625 | 115.1562 | 3011000.0 |
| 2000-03-10 11:30:00 | QQQ | ETF | 115.1875 | 115.25 | 113.5156 | 114.3438 | 2013800.0 |
| 2000-03-10 12:00:00 | QQQ | ETF | 114.0312 | 114.875 | 113.6875 | 114.875 | 2534600.0 |
| 2000-03-10 12:30:00 | QQQ | ETF | 114.8594 | 115.25 | 114.2656 | 114.9375 | 1280800.0 |
| 2000-03-10 13:00:00 | QQQ | ETF | 114.9688 | 115.3906 | 114.375 | 115.25 | 1315200.0 |
| 2000-03-10 13:30:00 | QQQ | ETF | 115.125 | 115.625 | 114.6094 | 115.5312 | 1441800.0 |
| 2000-03-10 14:00:00 | QQQ | ETF | 115.625 | 115.875 | 115.2188 | 115.875 | 1378200.0 |
| 2000-03-10 14:30:00 | QQQ | ETF | 115.8125 | 116.2812 | 115.1875 | 115.25 | 1623000.0 |
| 2000-03-10 15:00:00 | QQQ | ETF | 115.3125 | 116.4375 | 115.2812 | 115.75 | 1860000.0 |
| 2000-03-10 15:30:00 | QQQ | ETF | 115.75 | 115.875 | 114.1875 | 114.625 | 3474000.0 |
| 2000-03-10 16:00:00 | QQQ | ETF | 114.5 | 114.75 | 114.5 | 114.6875 | 653000.0 |
| 2000-03-10 16:30:00 | QQQ | ETF | 114.6875 | 114.6875 | 114.6875 | 114.6875 | 400.0 |
| 2000-03-10 17:00:00 | QQQ | ETF | 114.5 | 114.5 | 114.5 | 114.5 | 600.0 |
| 2000-03-10 17:30:00 | QQQ | ETF | 114.5312 | 114.5312 | 114.5 | 114.5 | 400.0 |
| 2000-03-10 09:30:00 | DIA | ETF | 99.9062 | 100.5 | 99.6875 | 100.5 | 185900.0 |
| 2000-03-10 10:00:00 | DIA | ETF | 100.4688 | 100.625 | 100.1875 | 100.4688 | 64600.0 |
| 2000-03-10 10:30:00 | DIA | ETF | 100.5 | 101.0625 | 100.375 | 100.6875 | 99600.0 |
| 2000-03-10 11:00:00 | DIA | ETF | 100.625 | 100.9688 | 100.1562 | 100.25 | 144900.0 |
| 2000-03-10 11:30:00 | DIA | ETF | 100.25 | 100.4062 | 99.4375 | 99.8125 | 333700.0 |
| 2000-03-10 12:00:00 | DIA | ETF | 99.875 | 100.0938 | 99.5625 | 99.9375 | 39700.0 |
| 2000-03-10 12:30:00 | DIA | ETF | 99.875 | 100.25 | 99.7188 | 100.125 | 26600.0 |
| 2000-03-10 13:00:00 | DIA | ETF | 100.1875 | 100.5625 | 99.9375 | 100.375 | 49700.0 |
| 2000-03-10 13:30:00 | DIA | ETF | 100.5625 | 100.5938 | 100.0938 | 100.4688 | 34800.0 |
| 2000-03-10 14:00:00 | DIA | ETF | 100.4062 | 100.5938 | 100.125 | 100.375 | 30000.0 |
| 2000-03-10 14:30:00 | DIA | ETF | 100.4062 | 100.5625 | 99.6875 | 99.7188 | 41700.0 |
| 2000-03-10 15:00:00 | DIA | ETF | 99.75 | 100.375 | 99.625 | 100.0625 | 23300.0 |
| 2000-03-10 15:30:00 | DIA | ETF | 100.375 | 100.375 | 98.9688 | 99.375 | 233400.0 |
| 2000-03-10 16:00:00 | DIA | ETF | 99.25 | 99.5625 | 99.2188 | 99.5625 | 44400.0 |
> showing 46 of 227 rows — these rows as CSV