PREVIEW / etf_30min / 2006-04-03
file: by_date/etf_30min/2006/2006-04-03.parquet size: 61 KB rows: 2,203
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-03 04:00:00 | SPY | ETF | 129.97 | 129.97 | 129.97 | 129.97 | 1000.0 |
| 2006-04-03 04:30:00 | SPY | ETF | 129.97 | 129.97 | 129.97 | 129.97 | 5000.0 |
| 2006-04-03 05:00:00 | SPY | ETF | 129.97 | 129.97 | 129.97 | 129.97 | 1300.0 |
| 2006-04-03 05:30:00 | SPY | ETF | 129.97 | 130.2 | 129.85 | 130.2 | 33200.0 |
| 2006-04-03 06:30:00 | SPY | ETF | 130.18 | 130.24 | 130.18 | 130.24 | 121000.0 |
| 2006-04-03 07:00:00 | SPY | ETF | 130.18 | 130.21 | 130.16 | 130.17 | 196800.0 |
| 2006-04-03 07:30:00 | SPY | ETF | 130.16 | 130.2 | 130.08 | 130.1 | 54500.0 |
| 2006-04-03 08:00:00 | SPY | ETF | 129.83 | 130.21 | 129.83 | 130.1 | 1740400.0 |
| 2006-04-03 08:30:00 | SPY | ETF | 130.08 | 130.175 | 130.02 | 130.05 | 142600.0 |
| 2006-04-03 09:00:00 | SPY | ETF | 130.04 | 130.12 | 129.83 | 130.06 | 163200.0 |
| 2006-04-03 09:30:00 | SPY | ETF | 130.07 | 130.17 | 129.89 | 130.15 | 6171100.0 |
| 2006-04-03 10:00:00 | SPY | ETF | 130.15 | 130.48 | 129.98 | 130.4 | 8540100.0 |
| 2006-04-03 10:30:00 | SPY | ETF | 130.39 | 130.74 | 130.06 | 130.57 | 5895500.0 |
| 2006-04-03 11:00:00 | SPY | ETF | 130.57 | 130.73 | 130.5 | 130.69 | 3140600.0 |
| 2006-04-03 11:30:00 | SPY | ETF | 130.69 | 130.87 | 130.57 | 130.75 | 4845600.0 |
| 2006-04-03 12:00:00 | SPY | ETF | 130.75 | 130.81 | 130.61 | 130.74 | 2959000.0 |
| 2006-04-03 12:30:00 | SPY | ETF | 130.73 | 130.77 | 130.58 | 130.66 | 2540700.0 |
| 2006-04-03 13:00:00 | SPY | ETF | 130.7 | 130.71 | 130.5 | 130.66 | 2461800.0 |
| 2006-04-03 13:30:00 | SPY | ETF | 130.66 | 130.69 | 130.55 | 130.6 | 1593600.0 |
| 2006-04-03 14:00:00 | SPY | ETF | 130.6 | 130.62 | 130.38 | 130.4 | 2929100.0 |
| 2006-04-03 14:30:00 | SPY | ETF | 130.39 | 130.46 | 130.15 | 130.23 | 5114500.0 |
| 2006-04-03 15:00:00 | SPY | ETF | 130.21 | 130.35 | 130.15 | 130.24 | 3079300.0 |
| 2006-04-03 15:30:00 | SPY | ETF | 130.24 | 130.26 | 129.49 | 129.69 | 7866000.0 |
| 2006-04-03 16:00:00 | SPY | ETF | 129.69 | 130.66 | 129.4043 | 129.66 | 899500.0 |
| 2006-04-03 16:30:00 | SPY | ETF | 129.73 | 130.3 | 129.68 | 129.71 | 101100.0 |
| 2006-04-03 17:00:00 | SPY | ETF | 129.73 | 129.73 | 129.71 | 129.72 | 2300.0 |
| 2006-04-03 17:30:00 | SPY | ETF | 129.73 | 129.74 | 129.73 | 129.73 | 1200.0 |
| 2006-04-03 18:00:00 | SPY | ETF | 129.73 | 129.73 | 129.73 | 129.73 | 1500.0 |
| 2006-04-03 18:30:00 | SPY | ETF | 129.76 | 129.76 | 129.74 | 129.76 | 900.0 |
| 2006-04-03 19:00:00 | SPY | ETF | 129.75 | 129.75 | 129.75 | 129.75 | 200.0 |
| 2006-04-03 19:30:00 | SPY | ETF | 129.75 | 129.75 | 129.72 | 129.72 | 3000.0 |
| 2006-04-03 09:30:00 | QQQ | ETF | 42.15 | 42.17 | 42.03 | 42.14 | 9687800.0 |
| 2006-04-03 10:00:00 | QQQ | ETF | 42.14 | 42.27 | 42.08 | 42.25 | 10872100.0 |
| 2006-04-03 10:30:00 | QQQ | ETF | 42.25 | 42.32 | 42.21 | 42.26 | 7630100.0 |
| 2006-04-03 11:00:00 | QQQ | ETF | 42.27 | 42.3 | 42.21 | 42.28 | 3964500.0 |
| 2006-04-03 11:30:00 | QQQ | ETF | 42.28 | 42.37 | 42.25 | 42.32 | 4856500.0 |
| 2006-04-03 12:00:00 | QQQ | ETF | 42.31 | 42.36 | 42.26 | 42.31 | 4881900.0 |
| 2006-04-03 12:30:00 | QQQ | ETF | 42.31 | 42.32 | 42.21 | 42.26 | 3675600.0 |
| 2006-04-03 13:00:00 | QQQ | ETF | 42.26 | 42.27 | 42.17 | 42.24 | 4555800.0 |
| 2006-04-03 13:30:00 | QQQ | ETF | 42.24 | 42.31 | 42.24 | 42.26 | 2065700.0 |
| 2006-04-03 14:00:00 | QQQ | ETF | 42.27 | 42.27 | 42.15 | 42.17 | 3895500.0 |
| 2006-04-03 14:30:00 | QQQ | ETF | 42.17 | 42.2 | 42.06 | 42.09 | 5481800.0 |
| 2006-04-03 15:00:00 | QQQ | ETF | 42.09 | 42.15 | 42.06 | 42.12 | 2926200.0 |
| 2006-04-03 15:30:00 | QQQ | ETF | 42.11 | 42.12 | 41.9 | 41.97 | 9568000.0 |
| 2006-04-03 07:30:00 | IWM | ETF | 76.1 | 76.1 | 76.1 | 76.1 | 300.0 |
| 2006-04-03 08:00:00 | IWM | ETF | 76.0 | 76.24 | 76.0 | 76.2 | 412500.0 |
| 2006-04-03 08:30:00 | IWM | ETF | 76.18 | 76.19 | 75.97 | 76.14 | 38800.0 |
| 2006-04-03 09:00:00 | IWM | ETF | 76.14 | 76.17 | 76.0 | 76.15 | 69000.0 |
| 2006-04-03 09:30:00 | IWM | ETF | 76.12 | 76.17 | 75.73 | 75.87 | 2642200.0 |
| 2006-04-03 10:00:00 | IWM | ETF | 75.87 | 76.33 | 75.75 | 76.27 | 3445200.0 |
> showing 50 of 2,203 rows — these rows as CSV