PREVIEW / etf_30min / 2006-08-25
file: by_date/etf_30min/2006/2006-08-25.parquet size: 71 KB rows: 2,666
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-25 07:00:00 | SPY | ETF | 129.77 | 129.85 | 129.77 | 129.8 | 4500.0 |
| 2006-08-25 07:30:00 | SPY | ETF | 129.78 | 129.78 | 129.69 | 129.73 | 141900.0 |
| 2006-08-25 08:00:00 | SPY | ETF | 129.74 | 129.82 | 129.71 | 129.74 | 120900.0 |
| 2006-08-25 08:30:00 | SPY | ETF | 129.74 | 129.8 | 129.73 | 129.76 | 538600.0 |
| 2006-08-25 09:00:00 | SPY | ETF | 129.74 | 129.74 | 129.6 | 129.64 | 198200.0 |
| 2006-08-25 09:30:00 | SPY | ETF | 129.64 | 129.94 | 129.55 | 129.88 | 5882800.0 |
| 2006-08-25 10:00:00 | SPY | ETF | 129.88 | 130.25 | 129.77 | 130.01 | 9537500.0 |
| 2006-08-25 10:30:00 | SPY | ETF | 130.02 | 130.04 | 129.83 | 129.86 | 5117600.0 |
| 2006-08-25 11:00:00 | SPY | ETF | 129.86 | 129.9 | 129.72 | 129.82 | 3176100.0 |
| 2006-08-25 11:30:00 | SPY | ETF | 129.82 | 129.82 | 129.61 | 129.7688 | 2984500.0 |
| 2006-08-25 12:00:00 | SPY | ETF | 129.77 | 129.84 | 129.7 | 129.79 | 1194300.0 |
| 2006-08-25 12:30:00 | SPY | ETF | 129.79 | 129.88 | 129.68 | 129.79 | 743000.0 |
| 2006-08-25 13:00:00 | SPY | ETF | 129.8 | 129.85 | 129.7 | 129.77 | 902100.0 |
| 2006-08-25 13:30:00 | SPY | ETF | 129.77 | 129.87 | 129.75 | 129.85 | 749700.0 |
| 2006-08-25 14:00:00 | SPY | ETF | 129.85 | 129.9 | 129.71 | 129.89 | 1104600.0 |
| 2006-08-25 14:30:00 | SPY | ETF | 129.89 | 130.0 | 129.86 | 129.93 | 2016900.0 |
| 2006-08-25 15:00:00 | SPY | ETF | 129.93 | 130.06 | 129.88 | 129.98 | 1907800.0 |
| 2006-08-25 15:30:00 | SPY | ETF | 129.98 | 130.11 | 129.78 | 129.84 | 3692700.0 |
| 2006-08-25 16:00:00 | SPY | ETF | 129.84 | 129.96 | 129.8 | 129.83 | 566900.0 |
| 2006-08-25 16:30:00 | SPY | ETF | 129.83 | 129.89 | 129.8 | 129.83 | 120900.0 |
| 2006-08-25 17:00:00 | SPY | ETF | 129.81 | 129.82 | 129.76 | 129.76 | 27100.0 |
| 2006-08-25 18:00:00 | SPY | ETF | 129.82 | 129.85 | 129.82 | 129.85 | 1400.0 |
| 2006-08-25 09:30:00 | QQQ | ETF | 38.17 | 38.36 | 38.06 | 38.32 | 11274100.0 |
| 2006-08-25 10:00:00 | QQQ | ETF | 38.32 | 38.64 | 38.26 | 38.46 | 19642400.0 |
| 2006-08-25 10:30:00 | QQQ | ETF | 38.46 | 38.49 | 38.31 | 38.31 | 6402500.0 |
| 2006-08-25 11:00:00 | QQQ | ETF | 38.32 | 38.39 | 38.27 | 38.33 | 4394100.0 |
| 2006-08-25 11:30:00 | QQQ | ETF | 38.33 | 38.34 | 38.24 | 38.32 | 4811100.0 |
| 2006-08-25 12:00:00 | QQQ | ETF | 38.31 | 38.35 | 38.28 | 38.33 | 1725800.0 |
| 2006-08-25 12:30:00 | QQQ | ETF | 38.33 | 38.39 | 38.29 | 38.35 | 2854600.0 |
| 2006-08-25 13:00:00 | QQQ | ETF | 38.35 | 38.36 | 38.29 | 38.33 | 1440500.0 |
| 2006-08-25 13:30:00 | QQQ | ETF | 38.33 | 38.4 | 38.31 | 38.38 | 2143100.0 |
| 2006-08-25 14:00:00 | QQQ | ETF | 38.38 | 38.4 | 38.31 | 38.38 | 2732100.0 |
| 2006-08-25 14:30:00 | QQQ | ETF | 38.38 | 38.43 | 38.35 | 38.39 | 4095300.0 |
| 2006-08-25 15:00:00 | QQQ | ETF | 38.4 | 38.42 | 38.36 | 38.38 | 2351300.0 |
| 2006-08-25 15:30:00 | QQQ | ETF | 38.38 | 38.45 | 38.3 | 38.32 | 7017800.0 |
| 2006-08-25 08:00:00 | IWM | ETF | 69.49 | 69.54 | 69.4 | 69.54 | 68900.0 |
| 2006-08-25 08:30:00 | IWM | ETF | 69.44 | 69.51 | 69.44 | 69.46 | 35600.0 |
| 2006-08-25 09:00:00 | IWM | ETF | 69.46 | 69.47 | 69.34 | 69.34 | 104900.0 |
| 2006-08-25 09:30:00 | IWM | ETF | 69.38 | 69.95 | 69.23 | 69.89 | 3103400.0 |
| 2006-08-25 10:00:00 | IWM | ETF | 69.9 | 70.09 | 69.74 | 69.79 | 6379400.0 |
| 2006-08-25 10:30:00 | IWM | ETF | 69.8 | 69.81 | 69.5 | 69.54 | 1903000.0 |
| 2006-08-25 11:00:00 | IWM | ETF | 69.53 | 69.57 | 69.35 | 69.51 | 904600.0 |
| 2006-08-25 11:30:00 | IWM | ETF | 69.49 | 69.51 | 69.26 | 69.42 | 2085300.0 |
| 2006-08-25 12:00:00 | IWM | ETF | 69.43 | 69.5 | 69.36 | 69.48 | 586400.0 |
| 2006-08-25 12:30:00 | IWM | ETF | 69.47 | 69.55 | 69.3 | 69.4 | 842900.0 |
| 2006-08-25 13:00:00 | IWM | ETF | 69.39 | 69.49 | 69.32 | 69.44 | 544200.0 |
| 2006-08-25 13:30:00 | IWM | ETF | 69.44 | 69.52 | 69.38 | 69.46 | 571500.0 |
| 2006-08-25 14:00:00 | IWM | ETF | 69.46 | 69.53 | 69.35 | 69.52 | 1050700.0 |
| 2006-08-25 14:30:00 | IWM | ETF | 69.52 | 69.64 | 69.49 | 69.59 | 746300.0 |
| 2006-08-25 15:00:00 | IWM | ETF | 69.59 | 69.69 | 69.53 | 69.64 | 916500.0 |
> showing 50 of 2,666 rows — these rows as CSV