PREVIEW / etf_30min / 2004-02-02
file: by_date/etf_30min/2004/2004-02-02.parquet size: 37 KB rows: 1,202
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-02-02 08:00:00 | SPY | ETF | 113.67 | 113.72 | 113.65 | 113.66 | 14600.0 |
| 2004-02-02 08:30:00 | SPY | ETF | 113.68 | 113.72 | 113.67 | 113.69 | 11700.0 |
| 2004-02-02 09:00:00 | SPY | ETF | 113.64 | 113.65 | 113.56 | 113.64 | 39700.0 |
| 2004-02-02 09:30:00 | SPY | ETF | 113.7 | 113.89 | 113.59 | 113.82 | 2919400.0 |
| 2004-02-02 10:00:00 | SPY | ETF | 113.81 | 113.82 | 113.28 | 113.5 | 4601400.0 |
| 2004-02-02 10:30:00 | SPY | ETF | 113.49 | 113.55 | 113.13 | 113.16 | 3457000.0 |
| 2004-02-02 11:00:00 | SPY | ETF | 113.22 | 113.43 | 113.12 | 113.42 | 1301800.0 |
| 2004-02-02 11:30:00 | SPY | ETF | 113.43 | 114.11 | 113.4 | 114.08 | 3174800.0 |
| 2004-02-02 12:00:00 | SPY | ETF | 114.07 | 114.31 | 114.03 | 114.25 | 2617400.0 |
| 2004-02-02 12:30:00 | SPY | ETF | 114.26 | 114.68 | 114.13 | 114.53 | 2293000.0 |
| 2004-02-02 13:00:00 | SPY | ETF | 114.52 | 114.62 | 114.39 | 114.61 | 1260700.0 |
| 2004-02-02 13:30:00 | SPY | ETF | 114.6 | 114.64 | 114.38 | 114.5 | 1329700.0 |
| 2004-02-02 14:00:00 | SPY | ETF | 114.5 | 114.57 | 114.35 | 114.54 | 946500.0 |
| 2004-02-02 14:30:00 | SPY | ETF | 114.55 | 114.57 | 114.32 | 114.49 | 1679000.0 |
| 2004-02-02 15:00:00 | SPY | ETF | 114.5 | 114.54 | 114.12 | 114.25 | 1865200.0 |
| 2004-02-02 15:30:00 | SPY | ETF | 114.26 | 114.27 | 113.35 | 113.83 | 7032500.0 |
| 2004-02-02 16:00:00 | SPY | ETF | 113.84 | 113.97 | 113.8 | 113.91 | 1353000.0 |
| 2004-02-02 16:30:00 | SPY | ETF | 113.9 | 113.92 | 113.86 | 113.92 | 31800.0 |
| 2004-02-02 17:00:00 | SPY | ETF | 113.91 | 113.92 | 113.89 | 113.89 | 5600.0 |
| 2004-02-02 17:30:00 | SPY | ETF | 113.9 | 113.9 | 113.9 | 113.9 | 300.0 |
| 2004-02-02 18:00:00 | SPY | ETF | 113.92 | 113.92 | 113.89 | 113.9 | 16400.0 |
| 2004-02-02 18:30:00 | SPY | ETF | 113.89 | 113.9 | 113.89 | 113.9 | 1400.0 |
| 2004-02-02 19:00:00 | SPY | ETF | 113.88 | 113.88 | 113.88 | 113.88 | 200.0 |
| 2004-02-02 19:30:00 | SPY | ETF | 113.88 | 113.89 | 113.85 | 113.85 | 1200.0 |
| 2004-02-02 08:00:00 | QQQ | ETF | 37.2 | 37.24 | 37.2 | 37.22 | 25000.0 |
| 2004-02-02 08:30:00 | QQQ | ETF | 37.2 | 37.24 | 37.17 | 37.19 | 45500.0 |
| 2004-02-02 09:00:00 | QQQ | ETF | 37.19 | 37.19 | 37.14 | 37.19 | 50900.0 |
| 2004-02-02 09:30:00 | QQQ | ETF | 37.2 | 37.335 | 37.18 | 37.228 | 7189200.0 |
| 2004-02-02 10:00:00 | QQQ | ETF | 37.22 | 37.25 | 36.86 | 37.002 | 11140700.0 |
| 2004-02-02 10:30:00 | QQQ | ETF | 37.001 | 37.06 | 36.82 | 36.89 | 6590200.0 |
| 2004-02-02 11:00:00 | QQQ | ETF | 36.89 | 36.97 | 36.83 | 36.95 | 4173800.0 |
| 2004-02-02 11:30:00 | QQQ | ETF | 36.95 | 37.39 | 36.946 | 37.299 | 9614900.0 |
| 2004-02-02 12:00:00 | QQQ | ETF | 37.3 | 37.38 | 37.28 | 37.345 | 5803800.0 |
| 2004-02-02 12:30:00 | QQQ | ETF | 37.345 | 37.48 | 37.27 | 37.43 | 6805400.0 |
| 2004-02-02 13:00:00 | QQQ | ETF | 37.42 | 37.474 | 37.36 | 37.46 | 3209500.0 |
| 2004-02-02 13:30:00 | QQQ | ETF | 37.45 | 37.47 | 37.37 | 37.414 | 3353900.0 |
| 2004-02-02 14:00:00 | QQQ | ETF | 37.41 | 37.43 | 37.3 | 37.38 | 5045900.0 |
| 2004-02-02 14:30:00 | QQQ | ETF | 37.376 | 37.401 | 37.26 | 37.34 | 4319500.0 |
| 2004-02-02 15:00:00 | QQQ | ETF | 37.348 | 37.36 | 37.11 | 37.18 | 5624600.0 |
| 2004-02-02 15:30:00 | QQQ | ETF | 37.18 | 37.18 | 36.83 | 36.95 | 11129900.0 |
| 2004-02-02 16:00:00 | QQQ | ETF | 36.95 | 37.03 | 36.92 | 36.95 | 3228400.0 |
| 2004-02-02 16:30:00 | QQQ | ETF | 36.96 | 36.97 | 36.93 | 36.97 | 764400.0 |
| 2004-02-02 17:00:00 | QQQ | ETF | 36.97 | 36.99 | 36.954 | 36.98 | 102600.0 |
| 2004-02-02 17:30:00 | QQQ | ETF | 36.98 | 36.99 | 36.97 | 36.97 | 9600.0 |
| 2004-02-02 18:00:00 | QQQ | ETF | 36.97 | 36.997 | 36.97 | 36.989 | 16100.0 |
| 2004-02-02 18:30:00 | QQQ | ETF | 36.98 | 36.99 | 36.97 | 36.99 | 2900.0 |
| 2004-02-02 19:00:00 | QQQ | ETF | 36.98 | 36.98 | 36.97 | 36.97 | 2400.0 |
| 2004-02-02 19:30:00 | QQQ | ETF | 36.99 | 36.99 | 36.97 | 36.99 | 7100.0 |
| 2004-02-02 09:00:00 | IWM | ETF | 57.93 | 57.93 | 57.93 | 57.93 | 200.0 |
| 2004-02-02 09:30:00 | IWM | ETF | 57.92 | 58.155 | 57.89 | 58.13 | 873200.0 |
> showing 50 of 1,202 rows — these rows as CSV