PREVIEW / etf_30min / 2000-04-12
file: by_date/etf_30min/2000/2000-04-12.parquet size: 10 KB rows: 215
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-12 09:30:00 | SPY | ETF | 150.375 | 151.1562 | 150.2812 | 150.5938 | 1582700.0 |
| 2000-04-12 10:00:00 | SPY | ETF | 150.5 | 150.6875 | 149.6875 | 150.4688 | 1570600.0 |
| 2000-04-12 10:30:00 | SPY | ETF | 150.4688 | 150.6875 | 149.1875 | 149.25 | 667800.0 |
| 2000-04-12 11:00:00 | SPY | ETF | 149.1875 | 149.5 | 148.4375 | 149.3125 | 742000.0 |
| 2000-04-12 11:30:00 | SPY | ETF | 149.4688 | 149.7188 | 149.0 | 149.2812 | 472800.0 |
| 2000-04-12 12:00:00 | SPY | ETF | 149.1875 | 149.7188 | 148.625 | 149.7188 | 257100.0 |
| 2000-04-12 12:30:00 | SPY | ETF | 149.5312 | 150.1875 | 149.3125 | 150.125 | 357100.0 |
| 2000-04-12 13:00:00 | SPY | ETF | 150.125 | 150.6562 | 150.0 | 150.1875 | 978300.0 |
| 2000-04-12 13:30:00 | SPY | ETF | 150.2188 | 150.5938 | 149.8125 | 150.25 | 195200.0 |
| 2000-04-12 14:00:00 | SPY | ETF | 150.2188 | 150.3125 | 149.5 | 150.0 | 240500.0 |
| 2000-04-12 14:30:00 | SPY | ETF | 149.875 | 150.2188 | 149.375 | 149.9062 | 149000.0 |
| 2000-04-12 15:00:00 | SPY | ETF | 149.9688 | 149.9688 | 148.4375 | 148.5 | 500800.0 |
| 2000-04-12 15:30:00 | SPY | ETF | 148.4375 | 148.5312 | 146.5625 | 146.625 | 2046700.0 |
| 2000-04-12 16:00:00 | SPY | ETF | 146.625 | 146.8125 | 146.1562 | 146.2812 | 797900.0 |
| 2000-04-12 09:30:00 | QQQ | ETF | 97.625 | 98.75 | 95.625 | 96.125 | 4360900.0 |
| 2000-04-12 10:00:00 | QQQ | ETF | 96.125 | 96.25 | 94.25 | 95.5 | 3165300.0 |
| 2000-04-12 10:30:00 | QQQ | ETF | 95.6875 | 96.0 | 93.5 | 93.5625 | 2583900.0 |
| 2000-04-12 11:00:00 | QQQ | ETF | 93.5625 | 94.4688 | 92.5 | 94.375 | 3655800.0 |
| 2000-04-12 11:30:00 | QQQ | ETF | 94.4375 | 94.9375 | 93.3125 | 93.375 | 1841800.0 |
| 2000-04-12 12:00:00 | QQQ | ETF | 93.5625 | 94.4375 | 92.5625 | 94.25 | 1747600.0 |
| 2000-04-12 12:30:00 | QQQ | ETF | 94.1875 | 95.0 | 93.75 | 94.6875 | 2479100.0 |
| 2000-04-12 13:00:00 | QQQ | ETF | 94.6875 | 95.4375 | 94.0312 | 94.1875 | 1372100.0 |
| 2000-04-12 13:30:00 | QQQ | ETF | 94.375 | 94.875 | 93.5625 | 94.7188 | 1383800.0 |
| 2000-04-12 14:00:00 | QQQ | ETF | 94.375 | 94.7188 | 93.0 | 93.6875 | 1711500.0 |
| 2000-04-12 14:30:00 | QQQ | ETF | 93.6875 | 94.1875 | 93.0 | 93.5 | 1776800.0 |
| 2000-04-12 15:00:00 | QQQ | ETF | 93.75 | 93.875 | 92.0 | 92.0 | 2876800.0 |
| 2000-04-12 15:30:00 | QQQ | ETF | 92.0 | 92.4688 | 90.5 | 90.75 | 4161200.0 |
| 2000-04-12 16:00:00 | QQQ | ETF | 90.75 | 91.5 | 90.25 | 91.5 | 1383100.0 |
| 2000-04-12 16:30:00 | QQQ | ETF | 92.75 | 93.0 | 91.0 | 91.5 | 3500.0 |
| 2000-04-12 17:00:00 | QQQ | ETF | 91.5 | 92.5 | 91.25 | 91.875 | 1900.0 |
| 2000-04-12 17:30:00 | QQQ | ETF | 91.1875 | 92.5 | 91.1875 | 92.0 | 600.0 |
| 2000-04-12 18:00:00 | QQQ | ETF | 92.25 | 93.0 | 91.5 | 92.375 | 5800.0 |
| 2000-04-12 09:30:00 | DIA | ETF | 113.875 | 114.1562 | 113.2812 | 114.1562 | 176900.0 |
| 2000-04-12 10:00:00 | DIA | ETF | 114.0 | 114.0 | 113.5 | 113.875 | 175400.0 |
| 2000-04-12 10:30:00 | DIA | ETF | 113.875 | 114.3125 | 113.1875 | 113.1875 | 263600.0 |
| 2000-04-12 11:00:00 | DIA | ETF | 113.1562 | 113.6562 | 112.6562 | 113.4062 | 302300.0 |
| 2000-04-12 11:30:00 | DIA | ETF | 113.4375 | 113.6875 | 113.125 | 113.3125 | 216800.0 |
| 2000-04-12 12:00:00 | DIA | ETF | 113.4375 | 113.75 | 112.875 | 113.7188 | 223500.0 |
| 2000-04-12 12:30:00 | DIA | ETF | 113.75 | 114.0 | 113.3125 | 114.0 | 215200.0 |
| 2000-04-12 13:00:00 | DIA | ETF | 114.0 | 114.5312 | 113.8438 | 114.0 | 224100.0 |
| 2000-04-12 13:30:00 | DIA | ETF | 114.0 | 114.375 | 113.75 | 114.25 | 126300.0 |
| 2000-04-12 14:00:00 | DIA | ETF | 114.2188 | 114.2188 | 113.6875 | 114.125 | 112600.0 |
| 2000-04-12 14:30:00 | DIA | ETF | 114.0938 | 114.1875 | 113.625 | 113.75 | 74200.0 |
| 2000-04-12 15:00:00 | DIA | ETF | 113.8125 | 113.875 | 112.8125 | 112.8125 | 354900.0 |
| 2000-04-12 15:30:00 | DIA | ETF | 112.75 | 112.75 | 111.0 | 111.0 | 839200.0 |
| 2000-04-12 16:00:00 | DIA | ETF | 111.0 | 111.125 | 110.5 | 110.5 | 308700.0 |
> showing 46 of 215 rows — these rows as CSV