PREVIEW / etf_30min / 2004-01-30
file: by_date/etf_30min/2004/2004-01-30.parquet size: 35 KB rows: 1,209
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-30 08:00:00 | SPY | ETF | 113.68 | 113.69 | 113.57 | 113.57 | 158100.0 |
| 2004-01-30 08:30:00 | SPY | ETF | 113.55 | 113.66 | 113.18 | 113.65 | 493700.0 |
| 2004-01-30 09:00:00 | SPY | ETF | 113.63 | 113.63 | 113.44 | 113.5 | 19300.0 |
| 2004-01-30 09:30:00 | SPY | ETF | 113.52 | 113.53 | 113.17 | 113.42 | 3532700.0 |
| 2004-01-30 10:00:00 | SPY | ETF | 113.45 | 113.72 | 113.19 | 113.35 | 4819200.0 |
| 2004-01-30 10:30:00 | SPY | ETF | 113.35 | 113.45 | 113.15 | 113.4 | 2593900.0 |
| 2004-01-30 11:00:00 | SPY | ETF | 113.38 | 113.46 | 113.1 | 113.25 | 1445300.0 |
| 2004-01-30 11:30:00 | SPY | ETF | 113.24 | 113.39 | 113.16 | 113.35 | 1003400.0 |
| 2004-01-30 12:00:00 | SPY | ETF | 113.35 | 113.41 | 113.22 | 113.37 | 559000.0 |
| 2004-01-30 12:30:00 | SPY | ETF | 113.34 | 113.56 | 113.29 | 113.45 | 983600.0 |
| 2004-01-30 13:00:00 | SPY | ETF | 113.45 | 113.6 | 113.4 | 113.52 | 1669200.0 |
| 2004-01-30 13:30:00 | SPY | ETF | 113.52 | 113.55 | 113.41 | 113.47 | 954300.0 |
| 2004-01-30 14:00:00 | SPY | ETF | 113.45 | 113.47 | 113.15 | 113.23 | 1426200.0 |
| 2004-01-30 14:30:00 | SPY | ETF | 113.22 | 113.5 | 113.09 | 113.42 | 2254500.0 |
| 2004-01-30 15:00:00 | SPY | ETF | 113.39 | 113.58 | 113.32 | 113.39 | 1289800.0 |
| 2004-01-30 15:30:00 | SPY | ETF | 113.38 | 113.64 | 113.37 | 113.44 | 3680700.0 |
| 2004-01-30 16:00:00 | SPY | ETF | 113.44 | 113.55 | 113.36 | 113.46 | 1855700.0 |
| 2004-01-30 16:30:00 | SPY | ETF | 113.47 | 113.53 | 113.47 | 113.52 | 12400.0 |
| 2004-01-30 17:00:00 | SPY | ETF | 113.52 | 113.53 | 113.45 | 113.51 | 14800.0 |
| 2004-01-30 17:30:00 | SPY | ETF | 113.51 | 113.54 | 113.51 | 113.54 | 2400.0 |
| 2004-01-30 18:00:00 | SPY | ETF | 113.54 | 113.54 | 113.54 | 113.54 | 900.0 |
| 2004-01-30 19:30:00 | SPY | ETF | 113.49 | 113.49 | 113.48 | 113.48 | 1000.0 |
| 2004-01-30 08:00:00 | QQQ | ETF | 37.32 | 37.35 | 37.3 | 37.32 | 71200.0 |
| 2004-01-30 08:30:00 | QQQ | ETF | 37.31 | 37.35 | 37.18 | 37.31 | 385500.0 |
| 2004-01-30 09:00:00 | QQQ | ETF | 37.3 | 37.3 | 37.19 | 37.2 | 134400.0 |
| 2004-01-30 09:30:00 | QQQ | ETF | 37.2 | 37.36 | 37.04 | 37.31 | 16580100.0 |
| 2004-01-30 10:00:00 | QQQ | ETF | 37.315 | 37.44 | 37.24 | 37.278 | 11964500.0 |
| 2004-01-30 10:30:00 | QQQ | ETF | 37.275 | 37.34 | 37.17 | 37.26 | 5975700.0 |
| 2004-01-30 11:00:00 | QQQ | ETF | 37.26 | 37.29 | 37.07 | 37.14 | 5235800.0 |
| 2004-01-30 11:30:00 | QQQ | ETF | 37.13 | 37.25 | 37.1 | 37.22 | 3837000.0 |
| 2004-01-30 12:00:00 | QQQ | ETF | 37.23 | 37.254 | 37.09 | 37.14 | 4219000.0 |
| 2004-01-30 12:30:00 | QQQ | ETF | 37.15 | 37.24 | 37.13 | 37.188 | 1838600.0 |
| 2004-01-30 13:00:00 | QQQ | ETF | 37.186 | 37.24 | 37.14 | 37.18 | 1942600.0 |
| 2004-01-30 13:30:00 | QQQ | ETF | 37.18 | 37.19 | 37.11 | 37.152 | 2002700.0 |
| 2004-01-30 14:00:00 | QQQ | ETF | 37.15 | 37.18 | 36.97 | 37.04 | 5508600.0 |
| 2004-01-30 14:30:00 | QQQ | ETF | 37.04 | 37.17 | 37.0 | 37.11 | 4401400.0 |
| 2004-01-30 15:00:00 | QQQ | ETF | 37.14 | 37.22 | 37.08 | 37.11 | 4757100.0 |
| 2004-01-30 15:30:00 | QQQ | ETF | 37.114 | 37.2 | 37.08 | 37.089 | 7316100.0 |
| 2004-01-30 16:00:00 | QQQ | ETF | 37.089 | 37.187 | 37.04 | 37.04 | 3593400.0 |
| 2004-01-30 16:30:00 | QQQ | ETF | 37.05 | 37.078 | 37.008 | 37.03 | 121800.0 |
| 2004-01-30 17:00:00 | QQQ | ETF | 37.022 | 37.03 | 36.93 | 36.98 | 106900.0 |
| 2004-01-30 17:30:00 | QQQ | ETF | 36.98 | 37.03 | 36.98 | 37.03 | 19700.0 |
| 2004-01-30 18:00:00 | QQQ | ETF | 37.04 | 37.07 | 37.0 | 37.05 | 20000.0 |
| 2004-01-30 18:30:00 | QQQ | ETF | 37.07 | 37.1 | 37.03 | 37.03 | 1400.0 |
| 2004-01-30 19:30:00 | QQQ | ETF | 37.02 | 37.04 | 37.01 | 37.01 | 3100.0 |
| 2004-01-30 20:00:00 | QQQ | ETF | 37.05 | 37.05 | 37.05 | 37.05 | 300.0 |
| 2004-01-30 08:30:00 | IWM | ETF | 57.85 | 57.85 | 57.85 | 57.85 | 200.0 |
| 2004-01-30 09:00:00 | IWM | ETF | 57.7 | 57.705 | 57.7 | 57.705 | 1400.0 |
| 2004-01-30 09:30:00 | IWM | ETF | 57.8045 | 57.965 | 57.45 | 57.925 | 1126400.0 |
| 2004-01-30 10:00:00 | IWM | ETF | 57.93 | 58.19 | 57.825 | 58.025 | 1709200.0 |
> showing 50 of 1,209 rows — these rows as CSV