PREVIEW / etf_30min / 2001-04-12
file: by_date/etf_30min/2001/2001-04-12.parquet size: 15 KB rows: 353
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 |
|---|---|---|---|---|---|---|---|
| 2001-04-12 09:30:00 | SPY | ETF | 116.3 | 117.3 | 116.2 | 116.6 | 1178600.0 |
| 2001-04-12 10:00:00 | SPY | ETF | 116.65 | 116.75 | 116.04 | 116.54 | 572300.0 |
| 2001-04-12 10:30:00 | SPY | ETF | 116.54 | 116.57 | 115.96 | 116.38 | 333600.0 |
| 2001-04-12 11:00:00 | SPY | ETF | 116.34 | 116.82 | 116.03 | 116.82 | 408900.0 |
| 2001-04-12 11:30:00 | SPY | ETF | 116.8 | 117.44 | 116.57 | 117.32 | 699200.0 |
| 2001-04-12 12:00:00 | SPY | ETF | 117.39 | 117.43 | 117.01 | 117.13 | 465500.0 |
| 2001-04-12 12:30:00 | SPY | ETF | 117.1 | 118.1 | 117.02 | 117.84 | 592900.0 |
| 2001-04-12 13:00:00 | SPY | ETF | 117.82 | 118.25 | 117.7 | 118.07 | 725200.0 |
| 2001-04-12 13:30:00 | SPY | ETF | 118.03 | 118.36 | 117.84 | 117.84 | 592600.0 |
| 2001-04-12 14:00:00 | SPY | ETF | 117.86 | 118.05 | 117.57 | 117.63 | 640900.0 |
| 2001-04-12 14:30:00 | SPY | ETF | 117.65 | 118.19 | 117.54 | 118.05 | 521200.0 |
| 2001-04-12 15:00:00 | SPY | ETF | 117.88 | 118.2 | 117.7 | 118.08 | 384800.0 |
| 2001-04-12 15:30:00 | SPY | ETF | 118.04 | 118.63 | 117.96 | 118.55 | 970900.0 |
| 2001-04-12 16:00:00 | SPY | ETF | 118.61 | 118.94 | 118.45 | 118.85 | 978400.0 |
| 2001-04-12 16:30:00 | SPY | ETF | 118.9 | 118.9 | 118.9 | 118.9 | 500.0 |
| 2001-04-12 17:00:00 | SPY | ETF | 118.98 | 118.98 | 118.98 | 118.98 | 1000.0 |
| 2001-04-12 17:30:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 300.0 |
| 2001-04-12 09:30:00 | QQQ | ETF | 40.3 | 41.25 | 40.25 | 40.56 | 14312800.0 |
| 2001-04-12 10:00:00 | QQQ | ETF | 40.56 | 40.75 | 40.0 | 40.4 | 7463300.0 |
| 2001-04-12 10:30:00 | QQQ | ETF | 40.43 | 40.54 | 40.05 | 40.4 | 3330800.0 |
| 2001-04-12 11:00:00 | QQQ | ETF | 40.4 | 40.98 | 40.2 | 40.96 | 5529500.0 |
| 2001-04-12 11:30:00 | QQQ | ETF | 40.96 | 41.4 | 40.68 | 41.39 | 4658500.0 |
| 2001-04-12 12:00:00 | QQQ | ETF | 41.3 | 41.58 | 41.17 | 41.34 | 6001900.0 |
| 2001-04-12 12:30:00 | QQQ | ETF | 41.34 | 42.1 | 41.24 | 41.85 | 5802600.0 |
| 2001-04-12 13:00:00 | QQQ | ETF | 41.85 | 42.32 | 41.8 | 42.1 | 4492200.0 |
| 2001-04-12 13:30:00 | QQQ | ETF | 42.14 | 42.69 | 42.1 | 42.15 | 6141800.0 |
| 2001-04-12 14:00:00 | QQQ | ETF | 42.17 | 42.37 | 41.78 | 41.85 | 4863400.0 |
| 2001-04-12 14:30:00 | QQQ | ETF | 41.81 | 42.47 | 41.71 | 42.35 | 3607100.0 |
| 2001-04-12 15:00:00 | QQQ | ETF | 42.35 | 42.6 | 42.2 | 42.48 | 4380200.0 |
| 2001-04-12 15:30:00 | QQQ | ETF | 42.47 | 42.77 | 42.4 | 42.65 | 6260600.0 |
| 2001-04-12 16:00:00 | QQQ | ETF | 42.7 | 43.05 | 42.64 | 42.75 | 1528500.0 |
| 2001-04-12 16:30:00 | QQQ | ETF | 42.77 | 42.9 | 42.75 | 42.85 | 56200.0 |
| 2001-04-12 17:00:00 | QQQ | ETF | 42.85 | 43.0 | 42.8 | 42.9 | 20300.0 |
| 2001-04-12 17:30:00 | QQQ | ETF | 42.9 | 42.9 | 42.85 | 42.89 | 12700.0 |
| 2001-04-12 18:00:00 | QQQ | ETF | 42.9 | 42.95 | 42.86 | 42.9 | 11700.0 |
| 2001-04-12 09:30:00 | IWM | ETF | 44.625 | 45.0 | 44.525 | 44.915 | 20400.0 |
| 2001-04-12 10:00:00 | IWM | ETF | 44.9 | 44.9 | 44.7 | 44.7 | 8000.0 |
| 2001-04-12 10:30:00 | IWM | ETF | 44.8 | 44.8 | 44.725 | 44.725 | 400.0 |
| 2001-04-12 11:00:00 | IWM | ETF | 44.62 | 44.625 | 44.62 | 44.625 | 44600.0 |
| 2001-04-12 11:30:00 | IWM | ETF | 44.7 | 45.0 | 44.7 | 45.0 | 19200.0 |
| 2001-04-12 12:00:00 | IWM | ETF | 45.0 | 45.0 | 44.8 | 44.8 | 10200.0 |
| 2001-04-12 12:30:00 | IWM | ETF | 44.71 | 45.225 | 44.71 | 45.18 | 16000.0 |
| 2001-04-12 13:00:00 | IWM | ETF | 44.95 | 45.1 | 44.95 | 45.1 | 13200.0 |
| 2001-04-12 13:30:00 | IWM | ETF | 45.15 | 45.275 | 45.11 | 45.11 | 120800.0 |
| 2001-04-12 14:00:00 | IWM | ETF | 45.0 | 45.01 | 44.95 | 44.95 | 2400.0 |
| 2001-04-12 14:30:00 | IWM | ETF | 44.92 | 45.2 | 44.905 | 45.2 | 22800.0 |
| 2001-04-12 15:00:00 | IWM | ETF | 45.225 | 45.325 | 45.05 | 45.055 | 10600.0 |
| 2001-04-12 15:30:00 | IWM | ETF | 45.125 | 45.5 | 45.125 | 45.45 | 193800.0 |
| 2001-04-12 09:30:00 | DIA | ETF | 99.5 | 100.5 | 99.5 | 99.94 | 585800.0 |
| 2001-04-12 10:00:00 | DIA | ETF | 99.87 | 100.11 | 99.35 | 100.0 | 369000.0 |
> showing 50 of 353 rows — these rows as CSV