PREVIEW / etf_30min / 2004-09-23
file: by_date/etf_30min/2004/2004-09-23.parquet size: 34 KB rows: 1,139
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-09-23 08:00:00 | SPY | ETF | 111.53 | 111.53 | 111.45 | 111.48 | 133000.0 |
| 2004-09-23 08:30:00 | SPY | ETF | 111.44 | 111.53 | 111.43 | 111.5 | 10600.0 |
| 2004-09-23 09:00:00 | SPY | ETF | 111.52 | 111.61 | 111.52 | 111.6 | 11100.0 |
| 2004-09-23 09:30:00 | SPY | ETF | 111.6 | 111.7 | 111.3 | 111.34 | 6574000.0 |
| 2004-09-23 10:00:00 | SPY | ETF | 111.32 | 111.62 | 111.2 | 111.53 | 8007800.0 |
| 2004-09-23 10:30:00 | SPY | ETF | 111.52 | 111.58 | 111.19 | 111.56 | 3272200.0 |
| 2004-09-23 11:00:00 | SPY | ETF | 111.55 | 111.59 | 111.4 | 111.48 | 2151800.0 |
| 2004-09-23 11:30:00 | SPY | ETF | 111.48 | 111.51 | 111.31 | 111.35 | 1808900.0 |
| 2004-09-23 12:00:00 | SPY | ETF | 111.35 | 111.49 | 111.26 | 111.3 | 2314800.0 |
| 2004-09-23 12:30:00 | SPY | ETF | 111.3 | 111.33 | 111.04 | 111.1 | 3185100.0 |
| 2004-09-23 13:00:00 | SPY | ETF | 111.1 | 111.29 | 111.07 | 111.24 | 954600.0 |
| 2004-09-23 13:30:00 | SPY | ETF | 111.23 | 111.3 | 111.12 | 111.2 | 1393100.0 |
| 2004-09-23 14:00:00 | SPY | ETF | 111.2 | 111.52 | 111.17 | 111.46 | 3167700.0 |
| 2004-09-23 14:30:00 | SPY | ETF | 111.44 | 111.55 | 111.31 | 111.37 | 1833500.0 |
| 2004-09-23 15:00:00 | SPY | ETF | 111.37 | 111.5 | 111.28 | 111.44 | 1813800.0 |
| 2004-09-23 15:30:00 | SPY | ETF | 111.43 | 111.46 | 111.12 | 111.14 | 2623500.0 |
| 2004-09-23 16:00:00 | SPY | ETF | 111.15 | 111.18 | 110.95 | 110.97 | 2927100.0 |
| 2004-09-23 16:30:00 | SPY | ETF | 110.97 | 111.06 | 110.97 | 111.05 | 110400.0 |
| 2004-09-23 17:00:00 | SPY | ETF | 111.05 | 111.08 | 111.0 | 111.05 | 29000.0 |
| 2004-09-23 17:30:00 | SPY | ETF | 111.02 | 111.02 | 111.0 | 111.0 | 2200.0 |
| 2004-09-23 18:00:00 | SPY | ETF | 111.02 | 111.1 | 111.02 | 111.06 | 13100.0 |
| 2004-09-23 18:30:00 | SPY | ETF | 111.02 | 111.02 | 111.02 | 111.02 | 1000.0 |
| 2004-09-23 19:00:00 | SPY | ETF | 111.11 | 111.11 | 111.11 | 111.11 | 100.0 |
| 2004-09-23 19:30:00 | SPY | ETF | 111.13 | 111.15 | 111.11 | 111.14 | 10500.0 |
| 2004-09-23 08:00:00 | QQQ | ETF | 34.93 | 34.96 | 34.93 | 34.95 | 53100.0 |
| 2004-09-23 08:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.9 | 34.93 | 151600.0 |
| 2004-09-23 09:00:00 | QQQ | ETF | 34.94 | 34.99 | 34.94 | 34.97 | 231400.0 |
| 2004-09-23 09:30:00 | QQQ | ETF | 34.98 | 35.03 | 34.877 | 34.95 | 13502200.0 |
| 2004-09-23 10:00:00 | QQQ | ETF | 34.95 | 35.13 | 34.88 | 35.07 | 12084100.0 |
| 2004-09-23 10:30:00 | QQQ | ETF | 35.06 | 35.13 | 34.9 | 35.11 | 8987000.0 |
| 2004-09-23 11:00:00 | QQQ | ETF | 35.11 | 35.14 | 35.03 | 35.06 | 3578500.0 |
| 2004-09-23 11:30:00 | QQQ | ETF | 35.06 | 35.1 | 34.977 | 35.02 | 3937100.0 |
| 2004-09-23 12:00:00 | QQQ | ETF | 35.02 | 35.096 | 35.0 | 35.01 | 4878400.0 |
| 2004-09-23 12:30:00 | QQQ | ETF | 35.01 | 35.04 | 34.882 | 34.96 | 5360200.0 |
| 2004-09-23 13:00:00 | QQQ | ETF | 34.96 | 35.03 | 34.89 | 35.0 | 3628300.0 |
| 2004-09-23 13:30:00 | QQQ | ETF | 35.008 | 35.05 | 34.95 | 34.97 | 4601300.0 |
| 2004-09-23 14:00:00 | QQQ | ETF | 34.973 | 35.148 | 34.97 | 35.11 | 7103700.0 |
| 2004-09-23 14:30:00 | QQQ | ETF | 35.11 | 35.15 | 35.03 | 35.08 | 6049100.0 |
| 2004-09-23 15:00:00 | QQQ | ETF | 35.08 | 35.15 | 35.05 | 35.12 | 5300700.0 |
| 2004-09-23 15:30:00 | QQQ | ETF | 35.12 | 35.14 | 34.98 | 35.0 | 8029200.0 |
| 2004-09-23 16:00:00 | QQQ | ETF | 34.991 | 35.01 | 34.91 | 34.92 | 2719700.0 |
| 2004-09-23 16:30:00 | QQQ | ETF | 34.912 | 34.96 | 34.9 | 34.93 | 279700.0 |
| 2004-09-23 17:00:00 | QQQ | ETF | 34.95 | 34.95 | 34.925 | 34.94 | 24600.0 |
| 2004-09-23 17:30:00 | QQQ | ETF | 34.94 | 34.94 | 34.92 | 34.92 | 30400.0 |
| 2004-09-23 18:00:00 | QQQ | ETF | 34.93 | 34.94 | 34.92 | 34.92 | 38700.0 |
| 2004-09-23 18:30:00 | QQQ | ETF | 34.92 | 34.92 | 34.9 | 34.9 | 11600.0 |
| 2004-09-23 19:00:00 | QQQ | ETF | 34.93 | 34.95 | 34.93 | 34.95 | 10800.0 |
| 2004-09-23 19:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.95 | 34.95 | 5300.0 |
| 2004-09-23 09:00:00 | IWM | ETF | 56.46 | 56.6 | 56.46 | 56.6 | 7200.0 |
| 2004-09-23 09:30:00 | IWM | ETF | 56.545 | 56.6 | 56.3 | 56.375 | 1213400.0 |
> showing 50 of 1,139 rows — these rows as CSV