PREVIEW / etf_30min / 2005-01-28
file: by_date/etf_30min/2005/2005-01-28.parquet size: 42 KB rows: 1,431
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-01-28 08:00:00 | SPY | ETF | 117.55 | 117.65 | 117.5 | 117.5 | 145200.0 |
| 2005-01-28 08:30:00 | SPY | ETF | 117.55 | 117.6 | 117.42 | 117.58 | 407100.0 |
| 2005-01-28 09:00:00 | SPY | ETF | 117.57 | 117.59 | 117.49 | 117.51 | 274000.0 |
| 2005-01-28 09:30:00 | SPY | ETF | 117.49 | 117.54 | 117.33 | 117.37 | 5645100.0 |
| 2005-01-28 10:00:00 | SPY | ETF | 117.39 | 117.5 | 117.24 | 117.45 | 3755600.0 |
| 2005-01-28 10:30:00 | SPY | ETF | 117.45 | 117.55 | 117.19 | 117.24 | 5609700.0 |
| 2005-01-28 11:00:00 | SPY | ETF | 117.23 | 117.29 | 116.61 | 116.72 | 9052200.0 |
| 2005-01-28 11:30:00 | SPY | ETF | 116.72 | 117.48 | 116.68 | 116.8 | 4251000.0 |
| 2005-01-28 12:00:00 | SPY | ETF | 116.8 | 116.89 | 116.7 | 116.75 | 1737500.0 |
| 2005-01-28 12:30:00 | SPY | ETF | 116.75 | 116.84 | 116.65 | 116.71 | 2422400.0 |
| 2005-01-28 13:00:00 | SPY | ETF | 116.71 | 116.96 | 116.63 | 116.87 | 3529100.0 |
| 2005-01-28 13:30:00 | SPY | ETF | 116.87 | 116.94 | 116.7 | 116.78 | 2215300.0 |
| 2005-01-28 14:00:00 | SPY | ETF | 116.77 | 116.91 | 116.63 | 116.86 | 2421600.0 |
| 2005-01-28 14:30:00 | SPY | ETF | 116.86 | 116.97 | 116.72 | 116.81 | 2674300.0 |
| 2005-01-28 15:00:00 | SPY | ETF | 116.81 | 116.95 | 116.71 | 116.81 | 2799200.0 |
| 2005-01-28 15:30:00 | SPY | ETF | 116.81 | 117.21 | 116.72 | 117.13 | 8868000.0 |
| 2005-01-28 16:00:00 | SPY | ETF | 117.15 | 117.45 | 117.09 | 117.44 | 1175600.0 |
| 2005-01-28 16:30:00 | SPY | ETF | 117.4 | 117.49 | 117.36 | 117.47 | 75100.0 |
| 2005-01-28 17:00:00 | SPY | ETF | 117.43 | 117.5 | 117.37 | 117.42 | 32300.0 |
| 2005-01-28 17:30:00 | SPY | ETF | 117.47 | 117.5 | 117.45 | 117.5 | 6900.0 |
| 2005-01-28 18:00:00 | SPY | ETF | 117.5 | 117.52 | 117.47 | 117.52 | 2100.0 |
| 2005-01-28 18:30:00 | SPY | ETF | 117.5 | 117.5 | 117.45 | 117.45 | 1500.0 |
| 2005-01-28 19:00:00 | SPY | ETF | 117.45 | 117.5 | 117.45 | 117.5 | 1400.0 |
| 2005-01-28 19:30:00 | SPY | ETF | 117.5 | 117.54 | 117.5 | 117.54 | 900.0 |
| 2005-01-28 09:30:00 | QQQ | ETF | 37.22 | 37.27 | 37.08 | 37.15 | 13129800.0 |
| 2005-01-28 10:00:00 | QQQ | ETF | 37.15 | 37.17 | 37.04 | 37.14 | 8122600.0 |
| 2005-01-28 10:30:00 | QQQ | ETF | 37.14 | 37.19 | 36.95 | 36.96 | 8444000.0 |
| 2005-01-28 11:00:00 | QQQ | ETF | 36.96 | 36.97 | 36.62 | 36.7 | 20266600.0 |
| 2005-01-28 11:30:00 | QQQ | ETF | 36.71 | 36.78 | 36.69 | 36.72 | 6222300.0 |
| 2005-01-28 12:00:00 | QQQ | ETF | 36.72 | 36.78 | 36.7 | 36.71 | 3613600.0 |
| 2005-01-28 12:30:00 | QQQ | ETF | 36.71 | 36.74 | 36.65 | 36.7 | 5178000.0 |
| 2005-01-28 13:00:00 | QQQ | ETF | 36.7 | 36.79 | 36.65 | 36.75 | 3682000.0 |
| 2005-01-28 13:30:00 | QQQ | ETF | 36.75 | 36.79 | 36.68 | 36.71 | 3518000.0 |
| 2005-01-28 14:00:00 | QQQ | ETF | 36.7 | 36.77 | 36.63 | 36.74 | 4475500.0 |
| 2005-01-28 14:30:00 | QQQ | ETF | 36.75 | 36.86 | 36.72 | 36.78 | 5245100.0 |
| 2005-01-28 15:00:00 | QQQ | ETF | 36.78 | 36.82 | 36.74 | 36.76 | 4711900.0 |
| 2005-01-28 15:30:00 | QQQ | ETF | 36.76 | 37.74 | 36.71 | 36.91 | 13606700.0 |
| 2005-01-28 08:00:00 | IWM | ETF | 61.15 | 61.565 | 61.15 | 61.565 | 2400.0 |
| 2005-01-28 09:00:00 | IWM | ETF | 61.56 | 61.56 | 61.56 | 61.56 | 2000.0 |
| 2005-01-28 09:30:00 | IWM | ETF | 61.65 | 61.65 | 61.255 | 61.29 | 2191400.0 |
| 2005-01-28 10:00:00 | IWM | ETF | 61.295 | 61.465 | 61.16 | 61.46 | 1636600.0 |
| 2005-01-28 10:30:00 | IWM | ETF | 61.435 | 61.525 | 61.275 | 61.3 | 2365000.0 |
| 2005-01-28 11:00:00 | IWM | ETF | 61.295 | 61.34 | 60.775 | 60.93 | 3049600.0 |
| 2005-01-28 11:30:00 | IWM | ETF | 60.915 | 61.32 | 60.85 | 60.915 | 1319400.0 |
| 2005-01-28 12:00:00 | IWM | ETF | 60.92 | 61.015 | 60.915 | 61.0 | 409800.0 |
| 2005-01-28 12:30:00 | IWM | ETF | 61.005 | 61.09 | 60.885 | 60.92 | 1031400.0 |
| 2005-01-28 13:00:00 | IWM | ETF | 60.92 | 61.06 | 60.835 | 60.99 | 1029800.0 |
| 2005-01-28 13:30:00 | IWM | ETF | 60.99 | 61.0 | 60.855 | 60.865 | 1340600.0 |
| 2005-01-28 14:00:00 | IWM | ETF | 60.875 | 60.915 | 60.685 | 60.77 | 1328400.0 |
| 2005-01-28 14:30:00 | IWM | ETF | 60.775 | 60.955 | 60.73 | 60.85 | 744600.0 |
> showing 50 of 1,431 rows — these rows as CSV