PREVIEW / etf_30min / 2006-04-10
file: by_date/etf_30min/2006/2006-04-10.parquet size: 60 KB rows: 2,190
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-10 04:00:00 | SPY | ETF | 129.6 | 129.6 | 129.6 | 129.6 | 5000.0 |
| 2006-04-10 05:00:00 | SPY | ETF | 129.65 | 129.65 | 129.65 | 129.65 | 100.0 |
| 2006-04-10 05:30:00 | SPY | ETF | 129.6 | 129.62 | 129.6 | 129.62 | 200.0 |
| 2006-04-10 07:00:00 | SPY | ETF | 129.57 | 129.57 | 129.57 | 129.57 | 100.0 |
| 2006-04-10 07:30:00 | SPY | ETF | 129.57 | 129.63 | 129.55 | 129.63 | 56200.0 |
| 2006-04-10 08:00:00 | SPY | ETF | 129.63 | 129.76 | 129.55 | 129.76 | 290900.0 |
| 2006-04-10 08:30:00 | SPY | ETF | 129.76 | 129.79 | 129.51 | 129.75 | 212300.0 |
| 2006-04-10 09:00:00 | SPY | ETF | 129.74 | 129.74 | 129.69 | 129.74 | 88400.0 |
| 2006-04-10 09:30:00 | SPY | ETF | 129.71 | 129.77 | 129.53 | 129.61 | 4794800.0 |
| 2006-04-10 10:00:00 | SPY | ETF | 129.64 | 129.91 | 129.55 | 129.58 | 5213600.0 |
| 2006-04-10 10:30:00 | SPY | ETF | 129.57 | 129.73 | 129.53 | 129.58 | 2046100.0 |
| 2006-04-10 11:00:00 | SPY | ETF | 129.58 | 130.08 | 129.56 | 129.96 | 3669900.0 |
| 2006-04-10 11:30:00 | SPY | ETF | 129.96 | 130.08 | 129.88 | 130.03 | 2292500.0 |
| 2006-04-10 12:00:00 | SPY | ETF | 130.03 | 130.08 | 129.92 | 129.98 | 2169200.0 |
| 2006-04-10 12:30:00 | SPY | ETF | 129.98 | 129.98 | 129.77 | 129.82 | 1085900.0 |
| 2006-04-10 13:00:00 | SPY | ETF | 129.84 | 129.87 | 129.67 | 129.73 | 1435800.0 |
| 2006-04-10 13:30:00 | SPY | ETF | 129.72 | 129.73 | 129.43 | 129.5 | 3641800.0 |
| 2006-04-10 14:00:00 | SPY | ETF | 129.51 | 129.65 | 129.39 | 129.43 | 3321100.0 |
| 2006-04-10 14:30:00 | SPY | ETF | 129.44 | 129.55 | 129.27 | 129.41 | 4091900.0 |
| 2006-04-10 15:00:00 | SPY | ETF | 129.41 | 129.68 | 129.39 | 129.57 | 3140600.0 |
| 2006-04-10 15:30:00 | SPY | ETF | 129.57 | 129.72 | 129.49 | 129.6 | 2513800.0 |
| 2006-04-10 16:00:00 | SPY | ETF | 129.61 | 129.83 | 129.6 | 129.83 | 410400.0 |
| 2006-04-10 16:30:00 | SPY | ETF | 129.8 | 129.8 | 129.74 | 129.79 | 301400.0 |
| 2006-04-10 17:00:00 | SPY | ETF | 129.79 | 129.84 | 129.64 | 129.78 | 40400.0 |
| 2006-04-10 17:30:00 | SPY | ETF | 129.77 | 129.77 | 129.74 | 129.75 | 33000.0 |
| 2006-04-10 18:00:00 | SPY | ETF | 129.75 | 129.75 | 129.72 | 129.75 | 26400.0 |
| 2006-04-10 18:30:00 | SPY | ETF | 129.75 | 129.75 | 129.74 | 129.75 | 3700.0 |
| 2006-04-10 19:00:00 | SPY | ETF | 129.73 | 129.74 | 129.72 | 129.74 | 3000.0 |
| 2006-04-10 19:30:00 | SPY | ETF | 129.77 | 129.77 | 129.77 | 129.77 | 500.0 |
| 2006-04-10 09:30:00 | QQQ | ETF | 42.4 | 42.43 | 42.28 | 42.31 | 10696300.0 |
| 2006-04-10 10:00:00 | QQQ | ETF | 42.32 | 42.5 | 42.31 | 42.31 | 8146000.0 |
| 2006-04-10 10:30:00 | QQQ | ETF | 42.32 | 42.36 | 42.28 | 42.29 | 3017700.0 |
| 2006-04-10 11:00:00 | QQQ | ETF | 42.29 | 42.42 | 42.27 | 42.4 | 4446900.0 |
| 2006-04-10 11:30:00 | QQQ | ETF | 42.41 | 42.42 | 42.34 | 42.38 | 1967700.0 |
| 2006-04-10 12:00:00 | QQQ | ETF | 42.39 | 42.45 | 42.35 | 42.41 | 3081900.0 |
| 2006-04-10 12:30:00 | QQQ | ETF | 42.42 | 42.42 | 42.31 | 42.35 | 1496300.0 |
| 2006-04-10 13:00:00 | QQQ | ETF | 42.35 | 42.36 | 42.27 | 42.32 | 2206500.0 |
| 2006-04-10 13:30:00 | QQQ | ETF | 42.32 | 42.33 | 42.15 | 42.18 | 5711000.0 |
| 2006-04-10 14:00:00 | QQQ | ETF | 42.18 | 42.23 | 42.14 | 42.14 | 3492800.0 |
| 2006-04-10 14:30:00 | QQQ | ETF | 42.15 | 42.18 | 42.09 | 42.15 | 4543800.0 |
| 2006-04-10 15:00:00 | QQQ | ETF | 42.15 | 42.24 | 42.14 | 42.19 | 4000700.0 |
| 2006-04-10 15:30:00 | QQQ | ETF | 42.2 | 42.3 | 42.16 | 42.26 | 4680800.0 |
| 2006-04-10 08:00:00 | IWM | ETF | 75.1 | 75.1 | 75.0 | 75.0 | 15100.0 |
| 2006-04-10 08:30:00 | IWM | ETF | 75.09 | 75.09 | 75.09 | 75.09 | 1100.0 |
| 2006-04-10 09:00:00 | IWM | ETF | 75.05 | 75.07 | 75.02 | 75.02 | 76200.0 |
| 2006-04-10 09:30:00 | IWM | ETF | 75.03 | 75.17 | 74.8 | 74.96 | 5287100.0 |
| 2006-04-10 10:00:00 | IWM | ETF | 74.97 | 75.22 | 74.95 | 75.0 | 2390600.0 |
| 2006-04-10 10:30:00 | IWM | ETF | 75.0 | 75.0 | 74.85 | 74.88 | 3376100.0 |
| 2006-04-10 11:00:00 | IWM | ETF | 74.88 | 75.13 | 74.8 | 75.12 | 923700.0 |
| 2006-04-10 11:30:00 | IWM | ETF | 75.12 | 75.28 | 75.07 | 75.28 | 1420700.0 |
> showing 50 of 2,190 rows — these rows as CSV