PREVIEW / etf_30min / 2003-05-06
file: by_date/etf_30min/2003/2003-05-06.parquet size: 24 KB rows: 701
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-05-06 08:00:00 | SPY | ETF | 93.32 | 93.37 | 93.23 | 93.23 | 20700.0 |
| 2003-05-06 08:30:00 | SPY | ETF | 93.25 | 93.25 | 93.1 | 93.13 | 21400.0 |
| 2003-05-06 09:00:00 | SPY | ETF | 93.12 | 93.15 | 93.02 | 93.07 | 34600.0 |
| 2003-05-06 09:30:00 | SPY | ETF | 93.04 | 93.61 | 93.0 | 93.39 | 4100700.0 |
| 2003-05-06 10:00:00 | SPY | ETF | 93.42 | 93.75 | 93.36 | 93.6 | 2230800.0 |
| 2003-05-06 10:30:00 | SPY | ETF | 93.6 | 93.63 | 93.28 | 93.48 | 1712400.0 |
| 2003-05-06 11:00:00 | SPY | ETF | 93.47 | 93.62 | 93.41 | 93.56 | 1439800.0 |
| 2003-05-06 11:30:00 | SPY | ETF | 93.56 | 93.88 | 93.53 | 93.86 | 2300900.0 |
| 2003-05-06 12:00:00 | SPY | ETF | 93.85 | 93.99 | 93.78 | 93.88 | 2086900.0 |
| 2003-05-06 12:30:00 | SPY | ETF | 93.89 | 94.07 | 93.83 | 94.05 | 1369000.0 |
| 2003-05-06 13:00:00 | SPY | ETF | 94.02 | 94.15 | 93.94 | 94.14 | 1561800.0 |
| 2003-05-06 13:30:00 | SPY | ETF | 94.1 | 94.16 | 93.92 | 93.97 | 1074400.0 |
| 2003-05-06 14:00:00 | SPY | ETF | 93.97 | 94.23 | 93.63 | 94.01 | 4976500.0 |
| 2003-05-06 14:30:00 | SPY | ETF | 93.99 | 94.38 | 93.62 | 93.65 | 5831200.0 |
| 2003-05-06 15:00:00 | SPY | ETF | 93.63 | 93.73 | 93.17 | 93.52 | 5072500.0 |
| 2003-05-06 15:30:00 | SPY | ETF | 93.52 | 93.88 | 93.45 | 93.8 | 2839800.0 |
| 2003-05-06 16:00:00 | SPY | ETF | 93.79 | 93.97 | 93.77 | 93.95 | 1703800.0 |
| 2003-05-06 16:30:00 | SPY | ETF | 93.95 | 93.95 | 93.79 | 93.79 | 34100.0 |
| 2003-05-06 17:00:00 | SPY | ETF | 93.84 | 93.89 | 93.7 | 93.76 | 88600.0 |
| 2003-05-06 17:30:00 | SPY | ETF | 93.78 | 93.84 | 93.75 | 93.84 | 40700.0 |
| 2003-05-06 18:00:00 | SPY | ETF | 93.83 | 93.84 | 93.76 | 93.8 | 84600.0 |
| 2003-05-06 18:30:00 | SPY | ETF | 93.78 | 93.82 | 93.7 | 93.77 | 8900.0 |
| 2003-05-06 19:00:00 | SPY | ETF | 93.7 | 93.7 | 93.68 | 93.68 | 700.0 |
| 2003-05-06 19:30:00 | SPY | ETF | 93.68 | 93.75 | 93.65 | 93.65 | 900.0 |
| 2003-05-06 08:00:00 | QQQ | ETF | 28.33 | 28.36 | 28.31 | 28.33 | 39500.0 |
| 2003-05-06 08:30:00 | QQQ | ETF | 28.33 | 28.33 | 28.27 | 28.27 | 44700.0 |
| 2003-05-06 09:00:00 | QQQ | ETF | 28.28 | 28.28 | 28.25 | 28.25 | 13700.0 |
| 2003-05-06 09:30:00 | QQQ | ETF | 28.22 | 28.54 | 28.21 | 28.45 | 7658300.0 |
| 2003-05-06 10:00:00 | QQQ | ETF | 28.45 | 28.58 | 28.41 | 28.51 | 3907300.0 |
| 2003-05-06 10:30:00 | QQQ | ETF | 28.51 | 28.54 | 28.37 | 28.46 | 2862300.0 |
| 2003-05-06 11:00:00 | QQQ | ETF | 28.46 | 28.53 | 28.43 | 28.51 | 2682700.0 |
| 2003-05-06 11:30:00 | QQQ | ETF | 28.51 | 28.65 | 28.51 | 28.65 | 4338300.0 |
| 2003-05-06 12:00:00 | QQQ | ETF | 28.65 | 28.72 | 28.61 | 28.66 | 6717100.0 |
| 2003-05-06 12:30:00 | QQQ | ETF | 28.65 | 28.78 | 28.63 | 28.72 | 2791200.0 |
| 2003-05-06 13:00:00 | QQQ | ETF | 28.74 | 28.83 | 28.69 | 28.8 | 3290600.0 |
| 2003-05-06 13:30:00 | QQQ | ETF | 28.81 | 28.82 | 28.7 | 28.73 | 3001200.0 |
| 2003-05-06 14:00:00 | QQQ | ETF | 28.76 | 28.86 | 28.61 | 28.82 | 6582900.0 |
| 2003-05-06 14:30:00 | QQQ | ETF | 28.78 | 28.9 | 28.57 | 28.58 | 6040400.0 |
| 2003-05-06 15:00:00 | QQQ | ETF | 28.59 | 28.65 | 28.39 | 28.53 | 7975900.0 |
| 2003-05-06 15:30:00 | QQQ | ETF | 28.53 | 28.67 | 28.5 | 28.63 | 5737800.0 |
| 2003-05-06 16:00:00 | QQQ | ETF | 28.66 | 28.7 | 28.5 | 28.64 | 2061400.0 |
| 2003-05-06 16:30:00 | QQQ | ETF | 28.64 | 28.66 | 28.59 | 28.61 | 195200.0 |
| 2003-05-06 17:00:00 | QQQ | ETF | 28.61 | 28.69 | 28.5 | 28.56 | 761500.0 |
| 2003-05-06 17:30:00 | QQQ | ETF | 28.58 | 28.61 | 28.57 | 28.6 | 139500.0 |
| 2003-05-06 18:00:00 | QQQ | ETF | 28.59 | 28.59 | 28.56 | 28.57 | 93100.0 |
| 2003-05-06 18:30:00 | QQQ | ETF | 28.59 | 28.61 | 28.57 | 28.59 | 13500.0 |
| 2003-05-06 19:00:00 | QQQ | ETF | 28.57 | 28.58 | 28.57 | 28.58 | 400.0 |
| 2003-05-06 19:30:00 | QQQ | ETF | 28.58 | 28.58 | 28.54 | 28.56 | 16000.0 |
| 2003-05-06 09:30:00 | IWM | ETF | 40.93 | 41.145 | 40.895 | 41.095 | 230200.0 |
| 2003-05-06 10:00:00 | IWM | ETF | 41.085 | 41.145 | 41.0 | 41.035 | 284000.0 |
> showing 50 of 701 rows — these rows as CSV