PREVIEW / etf_30min / 2006-02-01
file: by_date/etf_30min/2006/2006-02-01.parquet size: 59 KB rows: 2,130
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-01 04:00:00 | SPY | ETF | 127.68 | 127.68 | 127.68 | 127.68 | 400.0 |
| 2006-02-01 05:00:00 | SPY | ETF | 127.62 | 127.62 | 127.62 | 127.62 | 400.0 |
| 2006-02-01 06:30:00 | SPY | ETF | 127.69 | 127.69 | 127.69 | 127.69 | 20000.0 |
| 2006-02-01 07:00:00 | SPY | ETF | 127.66 | 127.67 | 127.64 | 127.67 | 7800.0 |
| 2006-02-01 07:30:00 | SPY | ETF | 127.69 | 127.87 | 127.69 | 127.83 | 102500.0 |
| 2006-02-01 08:00:00 | SPY | ETF | 127.94 | 127.94 | 127.65 | 127.71 | 301100.0 |
| 2006-02-01 08:30:00 | SPY | ETF | 127.7 | 127.89 | 127.5 | 127.87 | 363600.0 |
| 2006-02-01 09:00:00 | SPY | ETF | 127.87 | 127.91 | 127.78 | 127.83 | 634200.0 |
| 2006-02-01 09:30:00 | SPY | ETF | 127.82 | 128.02 | 127.82 | 127.85 | 8823400.0 |
| 2006-02-01 10:00:00 | SPY | ETF | 127.85 | 128.32 | 127.73 | 128.25 | 6137100.0 |
| 2006-02-01 10:30:00 | SPY | ETF | 128.23 | 128.33 | 128.02 | 128.02 | 3331700.0 |
| 2006-02-01 11:00:00 | SPY | ETF | 128.02 | 128.3 | 127.86 | 127.98 | 4147400.0 |
| 2006-02-01 11:30:00 | SPY | ETF | 127.98 | 128.27 | 127.88 | 128.07 | 3592000.0 |
| 2006-02-01 12:00:00 | SPY | ETF | 128.07 | 128.2 | 127.93 | 128.17 | 4807200.0 |
| 2006-02-01 12:30:00 | SPY | ETF | 128.17 | 128.28 | 128.07 | 128.13 | 2200300.0 |
| 2006-02-01 13:00:00 | SPY | ETF | 128.13 | 128.16 | 127.88 | 128.0001 | 4062100.0 |
| 2006-02-01 13:30:00 | SPY | ETF | 128.0 | 128.0099 | 127.72 | 127.94 | 5518900.0 |
| 2006-02-01 14:00:00 | SPY | ETF | 127.94 | 128.14 | 127.89 | 127.94 | 3484000.0 |
| 2006-02-01 14:30:00 | SPY | ETF | 127.94 | 128.2 | 127.87 | 127.99 | 3113100.0 |
| 2006-02-01 15:00:00 | SPY | ETF | 128.0 | 128.26 | 127.96 | 128.1 | 2749700.0 |
| 2006-02-01 15:30:00 | SPY | ETF | 128.1 | 128.35 | 128.09 | 128.23 | 4502500.0 |
| 2006-02-01 16:00:00 | SPY | ETF | 128.23 | 128.43 | 128.03 | 128.4 | 1335300.0 |
| 2006-02-01 16:30:00 | SPY | ETF | 128.39 | 128.39 | 128.33 | 128.35 | 598000.0 |
| 2006-02-01 17:00:00 | SPY | ETF | 128.36 | 128.39 | 128.34 | 128.38 | 5200.0 |
| 2006-02-01 17:30:00 | SPY | ETF | 128.34 | 128.37 | 128.34 | 128.34 | 25500.0 |
| 2006-02-01 18:30:00 | SPY | ETF | 128.37 | 128.37 | 128.35 | 128.35 | 2100.0 |
| 2006-02-01 19:00:00 | SPY | ETF | 128.33 | 128.33 | 128.33 | 128.33 | 400.0 |
| 2006-02-01 09:30:00 | QQQ | ETF | 41.75 | 41.85 | 41.72 | 41.75 | 9519400.0 |
| 2006-02-01 10:00:00 | QQQ | ETF | 41.75 | 42.12 | 41.7 | 42.05 | 14764300.0 |
| 2006-02-01 10:30:00 | QQQ | ETF | 42.04 | 42.1 | 41.93 | 41.94 | 5979300.0 |
| 2006-02-01 11:00:00 | QQQ | ETF | 41.93 | 42.04 | 41.89 | 41.95 | 6352300.0 |
| 2006-02-01 11:30:00 | QQQ | ETF | 41.94 | 42.0 | 41.89 | 41.91 | 3982300.0 |
| 2006-02-01 12:00:00 | QQQ | ETF | 41.92 | 42.03 | 41.91 | 42.02 | 3237700.0 |
| 2006-02-01 12:30:00 | QQQ | ETF | 42.02 | 42.07 | 41.98 | 41.98 | 3787300.0 |
| 2006-02-01 13:00:00 | QQQ | ETF | 41.99 | 42.0 | 41.87 | 41.92 | 4632300.0 |
| 2006-02-01 13:30:00 | QQQ | ETF | 41.91 | 42.07 | 41.78 | 41.91 | 6659600.0 |
| 2006-02-01 14:00:00 | QQQ | ETF | 41.91 | 42.02 | 41.91 | 41.95 | 4524900.0 |
| 2006-02-01 14:30:00 | QQQ | ETF | 41.96 | 42.06 | 41.93 | 41.94 | 5739300.0 |
| 2006-02-01 15:00:00 | QQQ | ETF | 41.95 | 42.08 | 41.94 | 42.03 | 3826200.0 |
| 2006-02-01 15:30:00 | QQQ | ETF | 42.03 | 42.17 | 42.02 | 42.13 | 7155700.0 |
| 2006-02-01 07:00:00 | IWM | ETF | 72.35 | 72.35 | 72.35 | 72.35 | 3000.0 |
| 2006-02-01 07:30:00 | IWM | ETF | 72.37 | 72.5 | 72.37 | 72.5 | 22800.0 |
| 2006-02-01 08:00:00 | IWM | ETF | 72.38 | 72.71 | 72.35 | 72.5 | 157100.0 |
| 2006-02-01 08:30:00 | IWM | ETF | 72.48 | 72.54 | 72.35 | 72.54 | 218700.0 |
| 2006-02-01 09:00:00 | IWM | ETF | 72.53 | 72.58 | 72.49 | 72.58 | 115400.0 |
| 2006-02-01 09:30:00 | IWM | ETF | 72.59 | 72.7 | 72.53 | 72.59 | 2236600.0 |
| 2006-02-01 10:00:00 | IWM | ETF | 72.58 | 72.9 | 72.47 | 72.77 | 2205600.0 |
| 2006-02-01 10:30:00 | IWM | ETF | 72.77 | 72.9 | 72.71 | 72.82 | 1724100.0 |
| 2006-02-01 11:00:00 | IWM | ETF | 72.82 | 73.04 | 72.8 | 72.88 | 2863200.0 |
| 2006-02-01 11:30:00 | IWM | ETF | 72.89 | 73.11 | 72.83 | 73.01 | 5096700.0 |
> showing 50 of 2,130 rows — these rows as CSV