PREVIEW / etf_30min / 2003-11-14
file: by_date/etf_30min/2003/2003-11-14.parquet size: 27 KB rows: 840
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-14 08:00:00 | SPY | ETF | 106.38 | 106.53 | 106.36 | 106.47 | 14800.0 |
| 2003-11-14 08:30:00 | SPY | ETF | 106.38 | 106.46 | 106.27 | 106.38 | 320400.0 |
| 2003-11-14 09:00:00 | SPY | ETF | 106.36 | 106.42 | 106.33 | 106.39 | 30100.0 |
| 2003-11-14 09:30:00 | SPY | ETF | 106.4 | 106.95 | 106.3 | 106.82 | 5733800.0 |
| 2003-11-14 10:00:00 | SPY | ETF | 106.82 | 106.84 | 106.07 | 106.18 | 6117700.0 |
| 2003-11-14 10:30:00 | SPY | ETF | 106.17 | 106.26 | 106.0 | 106.12 | 2083900.0 |
| 2003-11-14 11:00:00 | SPY | ETF | 106.11 | 106.33 | 106.08 | 106.24 | 1363800.0 |
| 2003-11-14 11:30:00 | SPY | ETF | 106.24 | 106.38 | 106.2 | 106.33 | 931300.0 |
| 2003-11-14 12:00:00 | SPY | ETF | 106.35 | 106.44 | 106.32 | 106.34 | 660700.0 |
| 2003-11-14 12:30:00 | SPY | ETF | 106.35 | 106.44 | 106.25 | 106.38 | 1221600.0 |
| 2003-11-14 13:00:00 | SPY | ETF | 106.39 | 106.5 | 106.3 | 106.33 | 809000.0 |
| 2003-11-14 13:30:00 | SPY | ETF | 106.31 | 106.41 | 106.18 | 106.25 | 803100.0 |
| 2003-11-14 14:00:00 | SPY | ETF | 106.25 | 106.28 | 105.8755 | 105.89 | 3329500.0 |
| 2003-11-14 14:30:00 | SPY | ETF | 105.9 | 105.94 | 105.47 | 105.6 | 6565300.0 |
| 2003-11-14 15:00:00 | SPY | ETF | 105.62 | 105.64 | 105.29 | 105.54 | 4943700.0 |
| 2003-11-14 15:30:00 | SPY | ETF | 105.53 | 105.75 | 105.46 | 105.55 | 2983200.0 |
| 2003-11-14 16:00:00 | SPY | ETF | 105.54 | 105.64 | 105.4 | 105.4 | 2124800.0 |
| 2003-11-14 16:30:00 | SPY | ETF | 105.36 | 105.5 | 105.36 | 105.46 | 136600.0 |
| 2003-11-14 17:00:00 | SPY | ETF | 105.43 | 105.43 | 105.3 | 105.31 | 5300.0 |
| 2003-11-14 18:00:00 | SPY | ETF | 105.35 | 105.35 | 105.35 | 105.35 | 100.0 |
| 2003-11-14 19:00:00 | SPY | ETF | 105.4 | 105.4 | 105.4 | 105.4 | 200.0 |
| 2003-11-14 19:30:00 | SPY | ETF | 105.4 | 105.4 | 105.4 | 105.4 | 200.0 |
| 2003-11-14 20:00:00 | SPY | ETF | 105.4 | 105.4 | 105.4 | 105.4 | 100.0 |
| 2003-11-14 08:00:00 | QQQ | ETF | 35.79 | 35.86 | 35.77 | 35.82 | 45600.0 |
| 2003-11-14 08:30:00 | QQQ | ETF | 35.82 | 35.82 | 35.7 | 35.74 | 117900.0 |
| 2003-11-14 09:00:00 | QQQ | ETF | 35.78 | 35.82 | 35.75 | 35.81 | 69500.0 |
| 2003-11-14 09:30:00 | QQQ | ETF | 35.811 | 36.02 | 35.78 | 35.95 | 7771800.0 |
| 2003-11-14 10:00:00 | QQQ | ETF | 35.96 | 35.962 | 35.42 | 35.45 | 11825600.0 |
| 2003-11-14 10:30:00 | QQQ | ETF | 35.45 | 35.54 | 35.32 | 35.34 | 7783800.0 |
| 2003-11-14 11:00:00 | QQQ | ETF | 35.34 | 35.47 | 35.32 | 35.45 | 6280600.0 |
| 2003-11-14 11:30:00 | QQQ | ETF | 35.432 | 35.54 | 35.42 | 35.49 | 2754000.0 |
| 2003-11-14 12:00:00 | QQQ | ETF | 35.491 | 35.551 | 35.447 | 35.46 | 1915500.0 |
| 2003-11-14 12:30:00 | QQQ | ETF | 35.47 | 35.52 | 35.43 | 35.5 | 1820900.0 |
| 2003-11-14 13:00:00 | QQQ | ETF | 35.491 | 35.57 | 35.46 | 35.46 | 1898000.0 |
| 2003-11-14 13:30:00 | QQQ | ETF | 35.48 | 35.49 | 35.36 | 35.42 | 3004300.0 |
| 2003-11-14 14:00:00 | QQQ | ETF | 35.42 | 35.43 | 35.2 | 35.26 | 5640800.0 |
| 2003-11-14 14:30:00 | QQQ | ETF | 35.25 | 35.3 | 35.12 | 35.16 | 7014700.0 |
| 2003-11-14 15:00:00 | QQQ | ETF | 35.141 | 35.186 | 35.0 | 35.13 | 8927900.0 |
| 2003-11-14 15:30:00 | QQQ | ETF | 35.14 | 35.194 | 34.99 | 35.01 | 9955900.0 |
| 2003-11-14 16:00:00 | QQQ | ETF | 35.02 | 35.06 | 34.95 | 35.029 | 3932600.0 |
| 2003-11-14 16:30:00 | QQQ | ETF | 35.02 | 35.05 | 34.982 | 35.01 | 102100.0 |
| 2003-11-14 17:00:00 | QQQ | ETF | 35.03 | 35.05 | 35.0 | 35.02 | 36700.0 |
| 2003-11-14 17:30:00 | QQQ | ETF | 35.02 | 35.039 | 34.99 | 35.039 | 90700.0 |
| 2003-11-14 18:00:00 | QQQ | ETF | 35.05 | 35.08 | 35.03 | 35.06 | 19300.0 |
| 2003-11-14 18:30:00 | QQQ | ETF | 35.07 | 35.07 | 35.04 | 35.05 | 4900.0 |
| 2003-11-14 19:00:00 | QQQ | ETF | 35.06 | 35.1 | 35.04 | 35.09 | 9800.0 |
| 2003-11-14 19:30:00 | QQQ | ETF | 35.08 | 35.09 | 35.06 | 35.09 | 2200.0 |
| 2003-11-14 09:30:00 | IWM | ETF | 54.115 | 54.47 | 54.095 | 54.41 | 482600.0 |
| 2003-11-14 10:00:00 | IWM | ETF | 54.435 | 54.44 | 53.75 | 53.765 | 545000.0 |
| 2003-11-14 10:30:00 | IWM | ETF | 53.775 | 53.775 | 53.575 | 53.61 | 496600.0 |
> showing 50 of 840 rows — these rows as CSV