PREVIEW / etf_30min / 2006-08-22
file: by_date/etf_30min/2006/2006-08-22.parquet size: 76 KB rows: 2,727
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-08-22 04:00:00 | SPY | ETF | 130.42 | 130.42 | 130.38 | 130.38 | 3900.0 |
| 2006-08-22 04:30:00 | SPY | ETF | 130.35 | 130.35 | 130.35 | 130.35 | 900.0 |
| 2006-08-22 05:00:00 | SPY | ETF | 130.25 | 130.28 | 130.25 | 130.28 | 2000.0 |
| 2006-08-22 05:30:00 | SPY | ETF | 130.29 | 130.29 | 130.21 | 130.21 | 2000.0 |
| 2006-08-22 06:00:00 | SPY | ETF | 130.09 | 130.09 | 129.96 | 129.96 | 5000.0 |
| 2006-08-22 06:30:00 | SPY | ETF | 130.03 | 130.03 | 130.03 | 130.03 | 1000.0 |
| 2006-08-22 07:00:00 | SPY | ETF | 130.02 | 130.05 | 129.94 | 130.0 | 26700.0 |
| 2006-08-22 07:30:00 | SPY | ETF | 130.0 | 130.12 | 129.91 | 129.91 | 69900.0 |
| 2006-08-22 08:00:00 | SPY | ETF | 129.9 | 130.13 | 129.85 | 129.96 | 1157100.0 |
| 2006-08-22 08:30:00 | SPY | ETF | 129.94 | 130.14 | 129.93 | 130.01 | 179300.0 |
| 2006-08-22 09:00:00 | SPY | ETF | 130.04 | 130.07 | 129.93 | 129.95 | 408800.0 |
| 2006-08-22 09:30:00 | SPY | ETF | 129.94 | 130.35 | 129.9 | 130.23 | 6784200.0 |
| 2006-08-22 10:00:00 | SPY | ETF | 130.24 | 130.44 | 130.1 | 130.33 | 4384200.0 |
| 2006-08-22 10:30:00 | SPY | ETF | 130.34 | 130.44 | 130.3 | 130.38 | 2045900.0 |
| 2006-08-22 11:00:00 | SPY | ETF | 130.39 | 130.49 | 130.28 | 130.44 | 2654400.0 |
| 2006-08-22 11:30:00 | SPY | ETF | 130.44 | 130.52 | 130.35 | 130.36 | 2969200.0 |
| 2006-08-22 12:00:00 | SPY | ETF | 130.36 | 130.41 | 130.27 | 130.32 | 1555300.0 |
| 2006-08-22 12:30:00 | SPY | ETF | 130.33 | 130.38 | 130.27 | 130.37 | 2149900.0 |
| 2006-08-22 13:00:00 | SPY | ETF | 130.36 | 130.36 | 129.89 | 130.0295 | 5602800.0 |
| 2006-08-22 13:30:00 | SPY | ETF | 130.02 | 130.08 | 129.75 | 129.92 | 7188200.0 |
| 2006-08-22 14:00:00 | SPY | ETF | 129.94 | 129.95 | 129.68 | 129.88 | 4990600.0 |
| 2006-08-22 14:30:00 | SPY | ETF | 129.87 | 130.08 | 129.82 | 130.06 | 3505000.0 |
| 2006-08-22 15:00:00 | SPY | ETF | 130.06 | 130.27 | 130.06 | 130.11 | 4705800.0 |
| 2006-08-22 15:30:00 | SPY | ETF | 130.12 | 130.23 | 130.08 | 130.13 | 5687500.0 |
| 2006-08-22 16:00:00 | SPY | ETF | 130.14 | 130.25 | 130.08 | 130.13 | 950400.0 |
| 2006-08-22 16:30:00 | SPY | ETF | 130.12 | 130.14 | 130.1 | 130.1 | 59700.0 |
| 2006-08-22 17:00:00 | SPY | ETF | 130.12 | 130.12 | 130.12 | 130.12 | 300.0 |
| 2006-08-22 17:30:00 | SPY | ETF | 130.15 | 130.16 | 130.15 | 130.15 | 1400.0 |
| 2006-08-22 18:00:00 | SPY | ETF | 130.13 | 130.13 | 130.13 | 130.13 | 500.0 |
| 2006-08-22 19:00:00 | SPY | ETF | 130.14 | 130.14 | 130.14 | 130.14 | 10000.0 |
| 2006-08-22 09:30:00 | QQQ | ETF | 38.36 | 38.64 | 38.35 | 38.6 | 10864300.0 |
| 2006-08-22 10:00:00 | QQQ | ETF | 38.6 | 38.72 | 38.55 | 38.67 | 11639900.0 |
| 2006-08-22 10:30:00 | QQQ | ETF | 38.67 | 38.71 | 38.63 | 38.67 | 5667300.0 |
| 2006-08-22 11:00:00 | QQQ | ETF | 38.67 | 38.77 | 38.6 | 38.76 | 6943300.0 |
| 2006-08-22 11:30:00 | QQQ | ETF | 38.76 | 38.81 | 38.72 | 38.72 | 6438500.0 |
| 2006-08-22 12:00:00 | QQQ | ETF | 38.72 | 38.73 | 38.64 | 38.66 | 5362800.0 |
| 2006-08-22 12:30:00 | QQQ | ETF | 38.66 | 38.66 | 38.6 | 38.65 | 4179500.0 |
| 2006-08-22 13:00:00 | QQQ | ETF | 38.65 | 38.65 | 38.38 | 38.41 | 9872900.0 |
| 2006-08-22 13:30:00 | QQQ | ETF | 38.41 | 38.42 | 38.26 | 38.39 | 9140500.0 |
| 2006-08-22 14:00:00 | QQQ | ETF | 38.39 | 38.39 | 38.2 | 38.33 | 8672700.0 |
| 2006-08-22 14:30:00 | QQQ | ETF | 38.34 | 38.47 | 38.33 | 38.47 | 4545700.0 |
| 2006-08-22 15:00:00 | QQQ | ETF | 38.47 | 38.52 | 38.42 | 38.43 | 6324300.0 |
| 2006-08-22 15:30:00 | QQQ | ETF | 38.43 | 38.5 | 38.41 | 38.42 | 5269500.0 |
| 2006-08-22 07:00:00 | IWM | ETF | 69.82 | 69.82 | 69.82 | 69.82 | 100.0 |
| 2006-08-22 07:30:00 | IWM | ETF | 70.1 | 70.1 | 70.1 | 70.1 | 100.0 |
| 2006-08-22 08:00:00 | IWM | ETF | 69.97 | 70.06 | 69.97 | 70.04 | 23800.0 |
| 2006-08-22 08:30:00 | IWM | ETF | 70.08 | 70.26 | 70.06 | 70.2 | 127100.0 |
| 2006-08-22 09:00:00 | IWM | ETF | 70.18 | 70.21 | 70.1 | 70.12 | 120600.0 |
| 2006-08-22 09:30:00 | IWM | ETF | 70.1 | 70.35 | 69.97 | 70.28 | 2564000.0 |
| 2006-08-22 10:00:00 | IWM | ETF | 70.28 | 70.43 | 70.11 | 70.34 | 2296000.0 |
> showing 50 of 2,727 rows — these rows as CSV