PREVIEW / etf_30min / 2006-03-10
file: by_date/etf_30min/2006/2006-03-10.parquet size: 59 KB rows: 2,117
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-03-10 05:30:00 | SPY | ETF | 126.99 | 126.99 | 126.99 | 126.99 | 100.0 |
| 2006-03-10 07:00:00 | SPY | ETF | 127.54 | 127.59 | 127.54 | 127.59 | 1800.0 |
| 2006-03-10 07:30:00 | SPY | ETF | 127.59 | 127.67 | 127.51 | 127.67 | 139100.0 |
| 2006-03-10 08:00:00 | SPY | ETF | 127.63 | 127.67 | 127.53 | 127.56 | 297900.0 |
| 2006-03-10 08:30:00 | SPY | ETF | 127.59 | 127.98 | 127.45 | 127.83 | 2932300.0 |
| 2006-03-10 09:00:00 | SPY | ETF | 127.84 | 127.98 | 127.53 | 127.76 | 961900.0 |
| 2006-03-10 09:30:00 | SPY | ETF | 127.72 | 127.91 | 127.44 | 127.83 | 8519300.0 |
| 2006-03-10 10:00:00 | SPY | ETF | 127.82 | 128.19 | 127.61 | 128.1 | 5846000.0 |
| 2006-03-10 10:30:00 | SPY | ETF | 128.1 | 128.62 | 128.04 | 128.57 | 6753700.0 |
| 2006-03-10 11:00:00 | SPY | ETF | 128.56 | 128.57 | 128.33 | 128.57 | 3058500.0 |
| 2006-03-10 11:30:00 | SPY | ETF | 128.57 | 128.69 | 128.48 | 128.59 | 3107500.0 |
| 2006-03-10 12:00:00 | SPY | ETF | 128.6 | 128.84 | 128.45 | 128.54 | 3200900.0 |
| 2006-03-10 12:30:00 | SPY | ETF | 128.53 | 128.74 | 128.49 | 128.55 | 1953300.0 |
| 2006-03-10 13:00:00 | SPY | ETF | 128.55 | 128.64 | 128.47 | 128.56 | 1234200.0 |
| 2006-03-10 13:30:00 | SPY | ETF | 128.55 | 128.6 | 128.38 | 128.55 | 2499000.0 |
| 2006-03-10 14:00:00 | SPY | ETF | 128.56 | 128.68 | 128.48 | 128.48 | 1925000.0 |
| 2006-03-10 14:30:00 | SPY | ETF | 128.51 | 128.57 | 128.11 | 128.14 | 4410100.0 |
| 2006-03-10 15:00:00 | SPY | ETF | 128.16 | 128.37 | 128.01 | 128.34 | 4574700.0 |
| 2006-03-10 15:30:00 | SPY | ETF | 128.34 | 128.59 | 128.33 | 128.53 | 4686500.0 |
| 2006-03-10 16:00:00 | SPY | ETF | 128.53 | 128.59 | 128.45 | 128.54 | 2935600.0 |
| 2006-03-10 16:30:00 | SPY | ETF | 128.51 | 128.55 | 128.5 | 128.5 | 2100.0 |
| 2006-03-10 17:00:00 | SPY | ETF | 128.54 | 128.55 | 128.54 | 128.55 | 1600.0 |
| 2006-03-10 17:30:00 | SPY | ETF | 128.51 | 128.52 | 128.51 | 128.52 | 1500.0 |
| 2006-03-10 18:00:00 | SPY | ETF | 128.54 | 128.54 | 128.54 | 128.54 | 100.0 |
| 2006-03-10 18:30:00 | SPY | ETF | 128.48 | 128.48 | 128.43 | 128.43 | 600.0 |
| 2006-03-10 19:00:00 | SPY | ETF | 128.44 | 128.5 | 128.43 | 128.5 | 800.0 |
| 2006-03-10 19:30:00 | SPY | ETF | 128.49 | 128.49 | 128.49 | 128.49 | 1500.0 |
| 2006-03-10 09:30:00 | QQQ | ETF | 40.49 | 40.5 | 40.2 | 40.34 | 12769600.0 |
| 2006-03-10 10:00:00 | QQQ | ETF | 40.35 | 40.64 | 40.19 | 40.57 | 14964200.0 |
| 2006-03-10 10:30:00 | QQQ | ETF | 40.57 | 40.76 | 40.55 | 40.73 | 10761200.0 |
| 2006-03-10 11:00:00 | QQQ | ETF | 40.72 | 40.72 | 40.61 | 40.69 | 4812000.0 |
| 2006-03-10 11:30:00 | QQQ | ETF | 40.69 | 40.72 | 40.61 | 40.66 | 4297100.0 |
| 2006-03-10 12:00:00 | QQQ | ETF | 40.66 | 40.78 | 40.64 | 40.66 | 5977600.0 |
| 2006-03-10 12:30:00 | QQQ | ETF | 40.66 | 40.79 | 40.66 | 40.7 | 4312200.0 |
| 2006-03-10 13:00:00 | QQQ | ETF | 40.7 | 40.73 | 40.66 | 40.68 | 1828100.0 |
| 2006-03-10 13:30:00 | QQQ | ETF | 40.68 | 40.7 | 40.6 | 40.67 | 4103700.0 |
| 2006-03-10 14:00:00 | QQQ | ETF | 40.68 | 40.75 | 40.6 | 40.66 | 2709800.0 |
| 2006-03-10 14:30:00 | QQQ | ETF | 40.65 | 40.67 | 40.46 | 40.47 | 6160400.0 |
| 2006-03-10 15:00:00 | QQQ | ETF | 40.47 | 40.56 | 40.39 | 40.55 | 6373000.0 |
| 2006-03-10 15:30:00 | QQQ | ETF | 40.55 | 40.66 | 40.52 | 40.54 | 8293200.0 |
| 2006-03-10 08:00:00 | IWM | ETF | 71.31 | 71.32 | 71.28 | 71.28 | 5000.0 |
| 2006-03-10 08:30:00 | IWM | ETF | 71.31 | 71.53 | 71.27 | 71.42 | 192800.0 |
| 2006-03-10 09:00:00 | IWM | ETF | 71.5 | 71.55 | 71.35 | 71.41 | 197800.0 |
| 2006-03-10 09:30:00 | IWM | ETF | 71.4 | 71.52 | 70.98 | 71.44 | 5574200.0 |
| 2006-03-10 10:00:00 | IWM | ETF | 71.45 | 71.87 | 71.34 | 71.81 | 4387300.0 |
| 2006-03-10 10:30:00 | IWM | ETF | 71.81 | 72.16 | 71.78 | 72.12 | 3955900.0 |
| 2006-03-10 11:00:00 | IWM | ETF | 72.11 | 72.12 | 71.93 | 72.07 | 2004200.0 |
| 2006-03-10 11:30:00 | IWM | ETF | 72.08 | 72.1 | 71.98 | 72.04 | 889900.0 |
| 2006-03-10 12:00:00 | IWM | ETF | 72.05 | 72.19 | 72.04 | 72.11 | 1794600.0 |
| 2006-03-10 12:30:00 | IWM | ETF | 72.1 | 72.35 | 72.08 | 72.13 | 1250400.0 |
> showing 50 of 2,117 rows — these rows as CSV