PREVIEW / etf_30min / 2005-05-10
file: by_date/etf_30min/2005/2005-05-10.parquet size: 44 KB rows: 1,501
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-10 05:30:00 | SPY | ETF | 117.71 | 117.71 | 117.7 | 117.7 | 10300.0 |
| 2005-05-10 07:00:00 | SPY | ETF | 117.59 | 117.61 | 117.53 | 117.53 | 79000.0 |
| 2005-05-10 07:30:00 | SPY | ETF | 117.6 | 117.62 | 117.58 | 117.58 | 56900.0 |
| 2005-05-10 08:00:00 | SPY | ETF | 117.6 | 117.6 | 117.45 | 117.54 | 94500.0 |
| 2005-05-10 08:30:00 | SPY | ETF | 117.51 | 117.55 | 117.36 | 117.36 | 199900.0 |
| 2005-05-10 09:00:00 | SPY | ETF | 117.38 | 117.41 | 117.31 | 117.38 | 335100.0 |
| 2005-05-10 09:30:00 | SPY | ETF | 117.36 | 117.41 | 117.15 | 117.21 | 5741400.0 |
| 2005-05-10 10:00:00 | SPY | ETF | 117.21 | 117.3 | 116.98 | 117.18 | 5547400.0 |
| 2005-05-10 10:30:00 | SPY | ETF | 117.19 | 117.29 | 116.95 | 117.06 | 4020100.0 |
| 2005-05-10 11:00:00 | SPY | ETF | 117.05 | 117.25 | 117.0 | 117.1 | 2222600.0 |
| 2005-05-10 11:30:00 | SPY | ETF | 117.1 | 117.17 | 116.82 | 116.86 | 5377200.0 |
| 2005-05-10 12:00:00 | SPY | ETF | 116.89 | 117.02 | 116.8 | 116.93 | 2139100.0 |
| 2005-05-10 12:30:00 | SPY | ETF | 116.94 | 117.3 | 116.93 | 117.23 | 5970400.0 |
| 2005-05-10 13:00:00 | SPY | ETF | 117.23 | 117.39 | 117.07 | 117.37 | 3211600.0 |
| 2005-05-10 13:30:00 | SPY | ETF | 117.37 | 117.5 | 117.16 | 117.34 | 3683700.0 |
| 2005-05-10 14:00:00 | SPY | ETF | 117.35 | 117.42 | 117.04 | 117.11 | 3106500.0 |
| 2005-05-10 14:30:00 | SPY | ETF | 117.11 | 117.255 | 116.55 | 116.64 | 10840500.0 |
| 2005-05-10 15:00:00 | SPY | ETF | 116.64 | 116.69 | 116.44 | 116.62 | 6988300.0 |
| 2005-05-10 15:30:00 | SPY | ETF | 116.59 | 116.78 | 116.39 | 116.69 | 7998000.0 |
| 2005-05-10 16:00:00 | SPY | ETF | 116.69 | 117.1793 | 116.59 | 116.62 | 3749100.0 |
| 2005-05-10 16:30:00 | SPY | ETF | 116.63 | 116.73 | 116.62 | 116.7 | 344000.0 |
| 2005-05-10 17:00:00 | SPY | ETF | 116.67 | 116.67 | 116.43 | 116.48 | 56300.0 |
| 2005-05-10 17:30:00 | SPY | ETF | 116.48 | 116.54 | 116.45 | 116.54 | 1400.0 |
| 2005-05-10 18:00:00 | SPY | ETF | 116.53 | 116.64 | 116.53 | 116.6 | 9700.0 |
| 2005-05-10 18:30:00 | SPY | ETF | 116.61 | 116.64 | 116.6 | 116.64 | 7500.0 |
| 2005-05-10 19:00:00 | SPY | ETF | 116.6 | 116.6 | 116.6 | 116.6 | 100.0 |
| 2005-05-10 19:30:00 | SPY | ETF | 116.58 | 116.64 | 116.58 | 116.64 | 700.0 |
| 2005-05-10 09:30:00 | QQQ | ETF | 35.86 | 35.88 | 35.78 | 35.82 | 9908200.0 |
| 2005-05-10 10:00:00 | QQQ | ETF | 35.83 | 35.86 | 35.78 | 35.82 | 6686100.0 |
| 2005-05-10 10:30:00 | QQQ | ETF | 35.83 | 35.84 | 35.74 | 35.79 | 5145300.0 |
| 2005-05-10 11:00:00 | QQQ | ETF | 35.78 | 35.85 | 35.77 | 35.79 | 3487100.0 |
| 2005-05-10 11:30:00 | QQQ | ETF | 35.79 | 35.82 | 35.72 | 35.74 | 4364500.0 |
| 2005-05-10 12:00:00 | QQQ | ETF | 35.74 | 35.83 | 35.73 | 35.8 | 5191300.0 |
| 2005-05-10 12:30:00 | QQQ | ETF | 35.79 | 35.9 | 35.79 | 35.87 | 3757800.0 |
| 2005-05-10 13:00:00 | QQQ | ETF | 35.88 | 35.94 | 35.84 | 35.94 | 4160500.0 |
| 2005-05-10 13:30:00 | QQQ | ETF | 35.94 | 35.96 | 35.87 | 35.92 | 2184000.0 |
| 2005-05-10 14:00:00 | QQQ | ETF | 35.92 | 35.93 | 35.82 | 35.83 | 2848200.0 |
| 2005-05-10 14:30:00 | QQQ | ETF | 35.83 | 35.83 | 35.65 | 35.68 | 8521100.0 |
| 2005-05-10 15:00:00 | QQQ | ETF | 35.67 | 35.73 | 35.62 | 35.69 | 6934000.0 |
| 2005-05-10 15:30:00 | QQQ | ETF | 35.69 | 35.75 | 35.63 | 35.74 | 9107500.0 |
| 2005-05-10 08:00:00 | IWM | ETF | 59.74 | 59.74 | 59.71 | 59.73 | 5800.0 |
| 2005-05-10 08:30:00 | IWM | ETF | 59.69 | 59.69 | 59.54 | 59.54 | 38000.0 |
| 2005-05-10 09:00:00 | IWM | ETF | 59.56 | 59.62 | 59.56 | 59.615 | 13600.0 |
| 2005-05-10 09:30:00 | IWM | ETF | 59.575 | 59.65 | 59.33 | 59.41 | 3127800.0 |
| 2005-05-10 10:00:00 | IWM | ETF | 59.41 | 59.495 | 59.34 | 59.44 | 2052000.0 |
| 2005-05-10 10:30:00 | IWM | ETF | 59.44 | 59.92 | 59.36 | 59.435 | 3612600.0 |
| 2005-05-10 11:00:00 | IWM | ETF | 59.435 | 59.525 | 59.39 | 59.415 | 948200.0 |
| 2005-05-10 11:30:00 | IWM | ETF | 59.415 | 59.47 | 59.17 | 59.245 | 1708800.0 |
| 2005-05-10 12:00:00 | IWM | ETF | 59.25 | 59.3 | 59.21 | 59.285 | 1096800.0 |
| 2005-05-10 12:30:00 | IWM | ETF | 59.285 | 59.435 | 59.25 | 59.39 | 1371600.0 |
> showing 50 of 1,501 rows — these rows as CSV