PREVIEW / etf_30min / 2000-04-11
file: by_date/etf_30min/2000/2000-04-11.parquet size: 10 KB rows: 213
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-04-11 09:30:00 | SPY | ETF | 148.5938 | 150.0625 | 148.375 | 149.875 | 247800.0 |
| 2000-04-11 10:00:00 | SPY | ETF | 150.0938 | 150.3125 | 149.25 | 149.9688 | 505800.0 |
| 2000-04-11 10:30:00 | SPY | ETF | 150.0 | 150.0938 | 149.0 | 149.8125 | 864600.0 |
| 2000-04-11 11:00:00 | SPY | ETF | 149.9375 | 150.4375 | 149.5625 | 149.8438 | 190200.0 |
| 2000-04-11 11:30:00 | SPY | ETF | 149.7812 | 151.125 | 149.7812 | 151.0625 | 553300.0 |
| 2000-04-11 12:00:00 | SPY | ETF | 151.0938 | 151.0938 | 150.4688 | 150.625 | 1118000.0 |
| 2000-04-11 12:30:00 | SPY | ETF | 150.75 | 150.8125 | 150.3125 | 150.7812 | 619000.0 |
| 2000-04-11 13:00:00 | SPY | ETF | 150.9062 | 151.625 | 150.8125 | 151.1875 | 1697100.0 |
| 2000-04-11 13:30:00 | SPY | ETF | 151.1562 | 151.625 | 150.8125 | 150.8125 | 153400.0 |
| 2000-04-11 14:00:00 | SPY | ETF | 150.75 | 151.0938 | 150.375 | 150.4375 | 92700.0 |
| 2000-04-11 14:30:00 | SPY | ETF | 150.625 | 150.875 | 149.9375 | 150.875 | 306700.0 |
| 2000-04-11 15:00:00 | SPY | ETF | 150.75 | 150.7812 | 149.4688 | 150.0 | 476900.0 |
| 2000-04-11 15:30:00 | SPY | ETF | 150.0 | 150.7188 | 149.75 | 150.0625 | 571200.0 |
| 2000-04-11 16:00:00 | SPY | ETF | 150.25 | 150.6562 | 150.25 | 150.4062 | 298400.0 |
| 2000-04-11 09:30:00 | QQQ | ETF | 96.25 | 99.0 | 95.75 | 98.625 | 5064800.0 |
| 2000-04-11 10:00:00 | QQQ | ETF | 98.6875 | 98.9375 | 97.0 | 98.0 | 4284800.0 |
| 2000-04-11 10:30:00 | QQQ | ETF | 98.0 | 98.0625 | 95.875 | 97.0 | 2417000.0 |
| 2000-04-11 11:00:00 | QQQ | ETF | 97.0625 | 98.0 | 96.25 | 96.5 | 1616400.0 |
| 2000-04-11 11:30:00 | QQQ | ETF | 96.5 | 100.0625 | 96.5 | 99.5 | 3166800.0 |
| 2000-04-11 12:00:00 | QQQ | ETF | 99.75 | 99.75 | 98.1875 | 98.625 | 1859100.0 |
| 2000-04-11 12:30:00 | QQQ | ETF | 98.5625 | 99.625 | 98.1562 | 99.625 | 1178600.0 |
| 2000-04-11 13:00:00 | QQQ | ETF | 99.5 | 101.4375 | 99.5 | 100.4688 | 1780400.0 |
| 2000-04-11 13:30:00 | QQQ | ETF | 100.625 | 101.5 | 99.5 | 99.875 | 1381200.0 |
| 2000-04-11 14:00:00 | QQQ | ETF | 99.875 | 100.125 | 98.375 | 98.75 | 1327800.0 |
| 2000-04-11 14:30:00 | QQQ | ETF | 98.75 | 99.5 | 97.0312 | 99.0 | 1576200.0 |
| 2000-04-11 15:00:00 | QQQ | ETF | 98.75 | 99.25 | 96.1562 | 97.0 | 1711700.0 |
| 2000-04-11 15:30:00 | QQQ | ETF | 97.5 | 98.8125 | 96.9375 | 97.5 | 2364500.0 |
| 2000-04-11 16:00:00 | QQQ | ETF | 97.5 | 97.9375 | 97.1875 | 97.7188 | 812200.0 |
| 2000-04-11 16:30:00 | QQQ | ETF | 97.8125 | 97.8125 | 97.7188 | 97.7188 | 900.0 |
| 2000-04-11 17:30:00 | QQQ | ETF | 97.6875 | 97.75 | 97.6875 | 97.75 | 500.0 |
| 2000-04-11 18:00:00 | QQQ | ETF | 97.75 | 97.75 | 97.75 | 97.75 | 1100.0 |
| 2000-04-11 09:30:00 | DIA | ETF | 112.25 | 112.4062 | 110.8438 | 112.1562 | 230100.0 |
| 2000-04-11 10:00:00 | DIA | ETF | 112.0 | 112.375 | 111.6562 | 112.2812 | 390700.0 |
| 2000-04-11 10:30:00 | DIA | ETF | 112.3438 | 112.75 | 111.75 | 112.6562 | 352300.0 |
| 2000-04-11 11:00:00 | DIA | ETF | 112.6875 | 112.9688 | 112.25 | 112.5938 | 239300.0 |
| 2000-04-11 11:30:00 | DIA | ETF | 112.8125 | 113.3438 | 112.5938 | 113.0 | 145200.0 |
| 2000-04-11 12:00:00 | DIA | ETF | 112.9375 | 113.25 | 112.5938 | 112.9688 | 241800.0 |
| 2000-04-11 12:30:00 | DIA | ETF | 113.0 | 113.2188 | 112.6562 | 113.125 | 191500.0 |
| 2000-04-11 13:00:00 | DIA | ETF | 113.25 | 113.7188 | 113.2188 | 113.4062 | 215400.0 |
| 2000-04-11 13:30:00 | DIA | ETF | 113.25 | 113.625 | 113.0312 | 113.25 | 405400.0 |
| 2000-04-11 14:00:00 | DIA | ETF | 113.3125 | 113.4375 | 112.9375 | 113.25 | 143500.0 |
| 2000-04-11 14:30:00 | DIA | ETF | 113.1562 | 113.4062 | 112.75 | 113.4062 | 232600.0 |
| 2000-04-11 15:00:00 | DIA | ETF | 113.25 | 113.3438 | 112.625 | 112.8438 | 408500.0 |
| 2000-04-11 15:30:00 | DIA | ETF | 112.8438 | 113.2812 | 112.7812 | 112.9062 | 344200.0 |
| 2000-04-11 16:00:00 | DIA | ETF | 112.7188 | 113.2812 | 112.7188 | 113.25 | 29300.0 |
> showing 45 of 213 rows — these rows as CSV