PREVIEW / etf_30min / 2006-04-05
file: by_date/etf_30min/2006/2006-04-05.parquet size: 60 KB rows: 2,168
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-04-05 06:00:00 | SPY | ETF | 130.54 | 130.57 | 130.54 | 130.57 | 13000.0 |
| 2006-04-05 06:30:00 | SPY | ETF | 130.54 | 130.54 | 130.54 | 130.54 | 300.0 |
| 2006-04-05 07:00:00 | SPY | ETF | 130.6 | 130.6 | 130.56 | 130.6 | 11500.0 |
| 2006-04-05 07:30:00 | SPY | ETF | 130.56 | 130.6 | 130.56 | 130.6 | 4000.0 |
| 2006-04-05 08:00:00 | SPY | ETF | 130.59 | 130.61 | 130.55 | 130.58 | 69800.0 |
| 2006-04-05 08:30:00 | SPY | ETF | 130.58 | 130.62 | 130.53 | 130.62 | 561900.0 |
| 2006-04-05 09:00:00 | SPY | ETF | 130.62 | 130.7 | 129.83 | 130.62 | 381900.0 |
| 2006-04-05 09:30:00 | SPY | ETF | 130.61 | 130.9 | 130.6 | 130.8 | 6029600.0 |
| 2006-04-05 10:00:00 | SPY | ETF | 130.8 | 130.97 | 130.66 | 130.73 | 4203300.0 |
| 2006-04-05 10:30:00 | SPY | ETF | 130.72 | 130.93 | 130.5 | 130.55 | 4891100.0 |
| 2006-04-05 11:00:00 | SPY | ETF | 130.55 | 130.76 | 130.52 | 130.62 | 2972600.0 |
| 2006-04-05 11:30:00 | SPY | ETF | 130.62 | 130.65 | 130.39 | 130.64 | 4828600.0 |
| 2006-04-05 12:00:00 | SPY | ETF | 130.64 | 130.77 | 130.56 | 130.7 | 2052700.0 |
| 2006-04-05 12:30:00 | SPY | ETF | 130.7 | 130.96 | 130.64 | 130.91 | 2863800.0 |
| 2006-04-05 13:00:00 | SPY | ETF | 130.92 | 131.12 | 130.86 | 130.97 | 4260300.0 |
| 2006-04-05 13:30:00 | SPY | ETF | 130.98 | 131.03 | 130.77 | 130.95 | 2634300.0 |
| 2006-04-05 14:00:00 | SPY | ETF | 130.96 | 131.09 | 130.82 | 130.98 | 2155000.0 |
| 2006-04-05 14:30:00 | SPY | ETF | 130.98 | 131.12 | 130.84 | 131.1 | 2305800.0 |
| 2006-04-05 15:00:00 | SPY | ETF | 131.08 | 131.28 | 130.89 | 131.14 | 4228200.0 |
| 2006-04-05 15:30:00 | SPY | ETF | 131.14 | 131.17 | 130.99 | 131.06 | 3130600.0 |
| 2006-04-05 16:00:00 | SPY | ETF | 131.06 | 131.1 | 130.99 | 131.01 | 679100.0 |
| 2006-04-05 16:30:00 | SPY | ETF | 131.03 | 131.08 | 131.02 | 131.08 | 5200.0 |
| 2006-04-05 17:00:00 | SPY | ETF | 131.08 | 131.08 | 131.05 | 131.05 | 300.0 |
| 2006-04-05 17:30:00 | SPY | ETF | 131.03 | 131.05 | 131.01 | 131.05 | 6100.0 |
| 2006-04-05 18:00:00 | SPY | ETF | 131.04 | 131.08 | 131.04 | 131.08 | 600.0 |
| 2006-04-05 18:30:00 | SPY | ETF | 131.04 | 131.06 | 131.04 | 131.06 | 1000.0 |
| 2006-04-05 19:00:00 | SPY | ETF | 131.06 | 131.06 | 131.06 | 131.06 | 100.0 |
| 2006-04-05 19:30:00 | SPY | ETF | 131.06 | 131.06 | 131.06 | 131.06 | 500.0 |
| 2006-04-05 09:30:00 | QQQ | ETF | 42.3 | 42.5 | 42.29 | 42.42 | 14340900.0 |
| 2006-04-05 10:00:00 | QQQ | ETF | 42.42 | 42.48 | 42.35 | 42.39 | 8567500.0 |
| 2006-04-05 10:30:00 | QQQ | ETF | 42.39 | 42.44 | 42.28 | 42.33 | 7119800.0 |
| 2006-04-05 11:00:00 | QQQ | ETF | 42.33 | 42.4 | 42.29 | 42.34 | 5299100.0 |
| 2006-04-05 11:30:00 | QQQ | ETF | 42.33 | 42.34 | 42.21 | 42.29 | 5466000.0 |
| 2006-04-05 12:00:00 | QQQ | ETF | 42.29 | 42.38 | 42.29 | 42.35 | 3897800.0 |
| 2006-04-05 12:30:00 | QQQ | ETF | 42.35 | 42.5 | 42.34 | 42.47 | 6343100.0 |
| 2006-04-05 13:00:00 | QQQ | ETF | 42.47 | 42.59 | 42.46 | 42.53 | 9355600.0 |
| 2006-04-05 13:30:00 | QQQ | ETF | 42.54 | 42.56 | 42.46 | 42.53 | 3450700.0 |
| 2006-04-05 14:00:00 | QQQ | ETF | 42.54 | 42.58 | 42.49 | 42.55 | 5172400.0 |
| 2006-04-05 14:30:00 | QQQ | ETF | 42.55 | 42.6 | 42.51 | 42.6 | 3173800.0 |
| 2006-04-05 15:00:00 | QQQ | ETF | 42.59 | 42.67 | 42.49 | 42.62 | 6919000.0 |
| 2006-04-05 15:30:00 | QQQ | ETF | 42.62 | 42.62 | 42.54 | 42.6 | 7333600.0 |
| 2006-04-05 08:00:00 | IWM | ETF | 75.7 | 75.78 | 75.7 | 75.77 | 32600.0 |
| 2006-04-05 08:30:00 | IWM | ETF | 75.74 | 75.81 | 75.74 | 75.81 | 2500.0 |
| 2006-04-05 09:00:00 | IWM | ETF | 75.83 | 75.92 | 75.83 | 75.86 | 71000.0 |
| 2006-04-05 09:30:00 | IWM | ETF | 75.83 | 76.01 | 75.73 | 75.78 | 2610400.0 |
| 2006-04-05 10:00:00 | IWM | ETF | 75.76 | 75.96 | 75.7 | 75.83 | 1539300.0 |
| 2006-04-05 10:30:00 | IWM | ETF | 75.83 | 75.91 | 75.55 | 75.57 | 3906300.0 |
| 2006-04-05 11:00:00 | IWM | ETF | 75.58 | 75.64 | 75.36 | 75.48 | 3989500.0 |
| 2006-04-05 11:30:00 | IWM | ETF | 75.48 | 75.49 | 75.27 | 75.47 | 1652200.0 |
| 2006-04-05 12:00:00 | IWM | ETF | 75.47 | 75.71 | 75.44 | 75.67 | 2306100.0 |
> showing 50 of 2,168 rows — these rows as CSV