PREVIEW / etf_30min / 2005-08-10
file: by_date/etf_30min/2005/2005-08-10.parquet size: 48 KB rows: 1,649
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-10 06:30:00 | SPY | ETF | 123.95 | 123.95 | 123.95 | 123.95 | 1000.0 |
| 2005-08-10 07:00:00 | SPY | ETF | 123.92 | 123.96 | 123.91 | 123.92 | 23600.0 |
| 2005-08-10 07:30:00 | SPY | ETF | 123.88 | 123.93 | 123.87 | 123.87 | 60000.0 |
| 2005-08-10 08:00:00 | SPY | ETF | 123.9 | 123.9 | 123.85 | 123.85 | 36200.0 |
| 2005-08-10 08:30:00 | SPY | ETF | 123.85 | 123.93 | 123.82 | 123.9 | 258100.0 |
| 2005-08-10 09:00:00 | SPY | ETF | 123.89 | 123.92 | 123.83 | 123.83 | 64000.0 |
| 2005-08-10 09:30:00 | SPY | ETF | 123.82 | 124.25 | 123.82 | 124.25 | 6704200.0 |
| 2005-08-10 10:00:00 | SPY | ETF | 124.25 | 124.31 | 123.99 | 124.18 | 5908600.0 |
| 2005-08-10 10:30:00 | SPY | ETF | 124.18 | 124.5 | 123.85 | 124.39 | 6013800.0 |
| 2005-08-10 11:00:00 | SPY | ETF | 124.38 | 124.4 | 124.2 | 124.3 | 2463100.0 |
| 2005-08-10 11:30:00 | SPY | ETF | 124.29 | 124.42 | 124.21 | 124.27 | 2503600.0 |
| 2005-08-10 12:00:00 | SPY | ETF | 124.26 | 124.32 | 124.17 | 124.19 | 1187500.0 |
| 2005-08-10 12:30:00 | SPY | ETF | 124.2 | 124.21 | 123.67 | 123.94 | 9822700.0 |
| 2005-08-10 13:00:00 | SPY | ETF | 123.94 | 124.02 | 123.81 | 123.922 | 2999000.0 |
| 2005-08-10 13:30:00 | SPY | ETF | 123.94 | 124.06 | 123.54 | 123.7 | 3861400.0 |
| 2005-08-10 14:00:00 | SPY | ETF | 123.7 | 123.72 | 123.2 | 123.33 | 8765700.0 |
| 2005-08-10 14:30:00 | SPY | ETF | 123.32 | 123.51 | 123.24 | 123.33 | 6430100.0 |
| 2005-08-10 15:00:00 | SPY | ETF | 123.34 | 123.35 | 122.82 | 122.96 | 7560500.0 |
| 2005-08-10 15:30:00 | SPY | ETF | 122.97 | 123.49 | 122.91 | 123.12 | 5010400.0 |
| 2005-08-10 16:00:00 | SPY | ETF | 123.15 | 123.38 | 123.06 | 123.35 | 801100.0 |
| 2005-08-10 16:30:00 | SPY | ETF | 123.33 | 123.36 | 123.07 | 123.31 | 298600.0 |
| 2005-08-10 17:00:00 | SPY | ETF | 123.33 | 123.36 | 123.33 | 123.36 | 57500.0 |
| 2005-08-10 17:30:00 | SPY | ETF | 123.36 | 123.36 | 123.33 | 123.33 | 4200.0 |
| 2005-08-10 18:00:00 | SPY | ETF | 123.36 | 123.4 | 123.36 | 123.4 | 2300.0 |
| 2005-08-10 18:30:00 | SPY | ETF | 123.38 | 123.38 | 123.35 | 123.35 | 3500.0 |
| 2005-08-10 19:00:00 | SPY | ETF | 123.34 | 123.34 | 123.34 | 123.34 | 1600.0 |
| 2005-08-10 19:30:00 | SPY | ETF | 123.34 | 123.34 | 123.34 | 123.34 | 500.0 |
| 2005-08-10 09:30:00 | QQQ | ETF | 39.54 | 39.67 | 39.53 | 39.67 | 11021100.0 |
| 2005-08-10 10:00:00 | QQQ | ETF | 39.66 | 39.68 | 39.55 | 39.63 | 8156600.0 |
| 2005-08-10 10:30:00 | QQQ | ETF | 39.63 | 39.69 | 39.56 | 39.64 | 8382800.0 |
| 2005-08-10 11:00:00 | QQQ | ETF | 39.65 | 39.65 | 39.59 | 39.64 | 2678200.0 |
| 2005-08-10 11:30:00 | QQQ | ETF | 39.64 | 39.67 | 39.61 | 39.63 | 2200400.0 |
| 2005-08-10 12:00:00 | QQQ | ETF | 39.62 | 39.65 | 39.56 | 39.58 | 1076700.0 |
| 2005-08-10 12:30:00 | QQQ | ETF | 39.58 | 39.58 | 39.38 | 39.45 | 9659600.0 |
| 2005-08-10 13:00:00 | QQQ | ETF | 39.46 | 39.58 | 39.44 | 39.47 | 5061000.0 |
| 2005-08-10 13:30:00 | QQQ | ETF | 39.47 | 39.5 | 38.41 | 39.39 | 3716800.0 |
| 2005-08-10 14:00:00 | QQQ | ETF | 39.39 | 39.39 | 39.2 | 39.24 | 8616900.0 |
| 2005-08-10 14:30:00 | QQQ | ETF | 39.24 | 39.28 | 39.21 | 39.22 | 4143000.0 |
| 2005-08-10 15:00:00 | QQQ | ETF | 39.22 | 39.23 | 38.97 | 39.09 | 20796200.0 |
| 2005-08-10 15:30:00 | QQQ | ETF | 39.09 | 39.13 | 39.05 | 39.11 | 7351800.0 |
| 2005-08-10 07:30:00 | IWM | ETF | 66.21 | 66.21 | 66.21 | 66.21 | 12800.0 |
| 2005-08-10 08:00:00 | IWM | ETF | 66.21 | 66.25 | 66.15 | 66.15 | 23000.0 |
| 2005-08-10 09:00:00 | IWM | ETF | 66.05 | 66.05 | 66.05 | 66.05 | 1000.0 |
| 2005-08-10 09:30:00 | IWM | ETF | 66.04 | 66.34 | 66.0 | 66.33 | 2305300.0 |
| 2005-08-10 10:00:00 | IWM | ETF | 66.33 | 66.51 | 66.3 | 66.37 | 3094700.0 |
| 2005-08-10 10:30:00 | IWM | ETF | 66.37 | 66.5 | 66.34 | 66.402 | 2416700.0 |
| 2005-08-10 11:00:00 | IWM | ETF | 66.4 | 66.44 | 66.3 | 66.39 | 1335300.0 |
| 2005-08-10 11:30:00 | IWM | ETF | 66.39 | 66.6 | 66.39 | 66.49 | 1023900.0 |
| 2005-08-10 12:00:00 | IWM | ETF | 66.49 | 66.552 | 66.35 | 66.35 | 432500.0 |
| 2005-08-10 12:30:00 | IWM | ETF | 66.35 | 66.38 | 64.87 | 66.05 | 2830200.0 |
> showing 50 of 1,649 rows — these rows as CSV