PREVIEW / etf_30min / 2005-07-12
file: by_date/etf_30min/2005/2005-07-12.parquet size: 45 KB rows: 1,588
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-07-12 07:00:00 | SPY | ETF | 122.04 | 122.04 | 122.0 | 122.01 | 8000.0 |
| 2005-07-12 08:00:00 | SPY | ETF | 121.94 | 121.97 | 121.86 | 121.86 | 124800.0 |
| 2005-07-12 08:30:00 | SPY | ETF | 121.87 | 121.91 | 121.81 | 121.87 | 41300.0 |
| 2005-07-12 09:00:00 | SPY | ETF | 121.86 | 121.94 | 121.85 | 121.91 | 208600.0 |
| 2005-07-12 09:30:00 | SPY | ETF | 121.89 | 122.08 | 121.8 | 122.04 | 4896700.0 |
| 2005-07-12 10:00:00 | SPY | ETF | 122.03 | 122.06 | 121.64 | 121.71 | 7870700.0 |
| 2005-07-12 10:30:00 | SPY | ETF | 121.74 | 122.09 | 121.7 | 122.08 | 3164600.0 |
| 2005-07-12 11:00:00 | SPY | ETF | 122.05 | 122.08 | 121.78 | 121.89 | 3597600.0 |
| 2005-07-12 11:30:00 | SPY | ETF | 121.88 | 121.94 | 121.71 | 121.75 | 2656200.0 |
| 2005-07-12 12:00:00 | SPY | ETF | 121.75 | 121.98 | 121.72 | 121.94 | 1599200.0 |
| 2005-07-12 12:30:00 | SPY | ETF | 121.94 | 122.01 | 121.89 | 121.91 | 1312200.0 |
| 2005-07-12 13:00:00 | SPY | ETF | 121.91 | 122.1 | 121.88 | 122.04 | 2094800.0 |
| 2005-07-12 13:30:00 | SPY | ETF | 122.05 | 122.5 | 121.99 | 122.42 | 5386200.0 |
| 2005-07-12 14:00:00 | SPY | ETF | 122.43 | 122.52 | 122.31 | 122.36 | 3214300.0 |
| 2005-07-12 14:30:00 | SPY | ETF | 122.34 | 122.45 | 122.26 | 122.32 | 2219100.0 |
| 2005-07-12 15:00:00 | SPY | ETF | 122.32 | 122.63 | 122.31 | 122.51 | 4877200.0 |
| 2005-07-12 15:30:00 | SPY | ETF | 122.51 | 122.52 | 122.15 | 122.22 | 6005300.0 |
| 2005-07-12 16:00:00 | SPY | ETF | 122.2 | 122.43 | 122.17 | 122.24 | 858400.0 |
| 2005-07-12 16:30:00 | SPY | ETF | 122.24 | 122.25 | 122.21 | 122.22 | 248500.0 |
| 2005-07-12 17:00:00 | SPY | ETF | 122.21 | 122.21 | 122.2 | 122.21 | 18200.0 |
| 2005-07-12 18:00:00 | SPY | ETF | 122.23 | 122.24 | 122.18 | 122.2 | 7800.0 |
| 2005-07-12 18:30:00 | SPY | ETF | 122.18 | 122.2 | 122.18 | 122.2 | 400.0 |
| 2005-07-12 19:30:00 | SPY | ETF | 122.17 | 122.23 | 122.17 | 122.23 | 4800.0 |
| 2005-07-12 09:30:00 | QQQ | ETF | 38.12 | 38.19 | 38.04 | 38.17 | 11113300.0 |
| 2005-07-12 10:00:00 | QQQ | ETF | 38.16 | 38.17 | 38.01 | 38.08 | 7106000.0 |
| 2005-07-12 10:30:00 | QQQ | ETF | 38.08 | 38.2 | 38.06 | 38.19 | 6022500.0 |
| 2005-07-12 11:00:00 | QQQ | ETF | 38.19 | 38.2 | 38.07 | 38.11 | 3881800.0 |
| 2005-07-12 11:30:00 | QQQ | ETF | 38.11 | 38.14 | 38.04 | 38.06 | 2372300.0 |
| 2005-07-12 12:00:00 | QQQ | ETF | 38.06 | 38.13 | 38.04 | 38.12 | 2578200.0 |
| 2005-07-12 12:30:00 | QQQ | ETF | 38.13 | 38.15 | 38.09 | 38.12 | 1377300.0 |
| 2005-07-12 13:00:00 | QQQ | ETF | 38.12 | 38.2 | 38.11 | 38.18 | 1985800.0 |
| 2005-07-12 13:30:00 | QQQ | ETF | 38.18 | 38.38 | 38.17 | 38.35 | 9062400.0 |
| 2005-07-12 14:00:00 | QQQ | ETF | 38.35 | 38.42 | 38.32 | 38.37 | 8328500.0 |
| 2005-07-12 14:30:00 | QQQ | ETF | 38.36 | 38.4 | 38.32 | 38.34 | 5551000.0 |
| 2005-07-12 15:00:00 | QQQ | ETF | 38.35 | 38.46 | 38.34 | 38.42 | 8091800.0 |
| 2005-07-12 15:30:00 | QQQ | ETF | 38.42 | 38.42 | 38.29 | 38.29 | 11675400.0 |
| 2005-07-12 07:00:00 | IWM | ETF | 66.73 | 66.73 | 66.73 | 66.73 | 200.0 |
| 2005-07-12 08:00:00 | IWM | ETF | 66.77 | 66.77 | 66.77 | 66.77 | 100.0 |
| 2005-07-12 08:30:00 | IWM | ETF | 66.68 | 66.72 | 66.68 | 66.72 | 31200.0 |
| 2005-07-12 09:00:00 | IWM | ETF | 66.71 | 66.72 | 66.61 | 66.65 | 64500.0 |
| 2005-07-12 09:30:00 | IWM | ETF | 66.68 | 66.81 | 66.56 | 66.65 | 1639200.0 |
| 2005-07-12 10:00:00 | IWM | ETF | 66.65 | 66.78 | 66.33 | 66.49 | 2413200.0 |
| 2005-07-12 10:30:00 | IWM | ETF | 66.5 | 66.71 | 66.46 | 66.71 | 1247500.0 |
| 2005-07-12 11:00:00 | IWM | ETF | 66.7092 | 66.73 | 66.44 | 66.54 | 1048900.0 |
| 2005-07-12 11:30:00 | IWM | ETF | 66.55 | 66.65 | 66.45 | 66.49 | 675400.0 |
| 2005-07-12 12:00:00 | IWM | ETF | 66.5 | 66.62 | 66.4 | 66.61 | 678000.0 |
| 2005-07-12 12:30:00 | IWM | ETF | 66.6 | 66.64 | 66.54 | 66.55 | 578600.0 |
| 2005-07-12 13:00:00 | IWM | ETF | 66.56 | 66.74 | 66.52 | 66.72 | 252900.0 |
| 2005-07-12 13:30:00 | IWM | ETF | 66.72 | 66.97 | 66.66 | 66.92 | 2059300.0 |
| 2005-07-12 14:00:00 | IWM | ETF | 66.92 | 67.05 | 66.84 | 66.98 | 2743300.0 |
> showing 50 of 1,588 rows — these rows as CSV