PREVIEW / etf_30min / 2005-09-14
file: by_date/etf_30min/2005/2005-09-14.parquet size: 46 KB rows: 1,627
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-09-14 07:00:00 | SPY | ETF | 123.7 | 123.7 | 123.7 | 123.7 | 2100.0 |
| 2005-09-14 07:30:00 | SPY | ETF | 123.67 | 123.67 | 123.6 | 123.6 | 1100.0 |
| 2005-09-14 08:00:00 | SPY | ETF | 123.64 | 123.73 | 123.58 | 123.71 | 993100.0 |
| 2005-09-14 08:30:00 | SPY | ETF | 123.74 | 123.81 | 123.57 | 123.71 | 1969800.0 |
| 2005-09-14 09:00:00 | SPY | ETF | 123.74 | 123.8 | 123.72 | 123.75 | 1111200.0 |
| 2005-09-14 09:30:00 | SPY | ETF | 123.75 | 123.92 | 123.58 | 123.6 | 5129900.0 |
| 2005-09-14 10:00:00 | SPY | ETF | 123.6 | 123.74 | 123.48 | 123.5 | 3325200.0 |
| 2005-09-14 10:30:00 | SPY | ETF | 123.49 | 123.77 | 123.35 | 123.56 | 5519500.0 |
| 2005-09-14 11:00:00 | SPY | ETF | 123.56 | 123.78 | 123.54 | 123.73 | 2205700.0 |
| 2005-09-14 11:30:00 | SPY | ETF | 123.73 | 123.9 | 123.7 | 123.76 | 2212800.0 |
| 2005-09-14 12:00:00 | SPY | ETF | 123.76 | 123.83 | 123.66 | 123.71 | 1559100.0 |
| 2005-09-14 12:30:00 | SPY | ETF | 123.7 | 123.82 | 123.66 | 123.78 | 1969000.0 |
| 2005-09-14 13:00:00 | SPY | ETF | 123.78 | 123.92 | 123.73 | 123.76 | 1756400.0 |
| 2005-09-14 13:30:00 | SPY | ETF | 123.76 | 123.77 | 123.5 | 123.6 | 2905100.0 |
| 2005-09-14 14:00:00 | SPY | ETF | 123.61 | 123.63 | 123.17 | 123.32 | 4776100.0 |
| 2005-09-14 14:30:00 | SPY | ETF | 123.31 | 123.37 | 123.2 | 123.26 | 2343500.0 |
| 2005-09-14 15:00:00 | SPY | ETF | 123.26 | 123.27 | 123.02 | 123.16 | 6512500.0 |
| 2005-09-14 15:30:00 | SPY | ETF | 123.16 | 123.3 | 123.11 | 123.18 | 4992600.0 |
| 2005-09-14 16:00:00 | SPY | ETF | 123.23 | 123.25 | 123.14 | 123.25 | 751200.0 |
| 2005-09-14 16:30:00 | SPY | ETF | 123.25 | 123.5824 | 123.22 | 123.24 | 277900.0 |
| 2005-09-14 17:00:00 | SPY | ETF | 123.24 | 123.8 | 123.23 | 123.26 | 599000.0 |
| 2005-09-14 17:30:00 | SPY | ETF | 123.18 | 123.25 | 123.18 | 123.25 | 300.0 |
| 2005-09-14 18:00:00 | SPY | ETF | 123.21 | 123.25 | 123.21 | 123.25 | 2500500.0 |
| 2005-09-14 19:30:00 | SPY | ETF | 123.23 | 123.26 | 123.23 | 123.23 | 1300.0 |
| 2005-09-14 09:30:00 | QQQ | ETF | 39.65 | 39.68 | 39.45 | 39.51 | 24986900.0 |
| 2005-09-14 10:00:00 | QQQ | ETF | 39.5 | 39.57 | 39.47 | 39.49 | 7137000.0 |
| 2005-09-14 10:30:00 | QQQ | ETF | 39.49 | 39.56 | 39.45 | 39.5 | 10246400.0 |
| 2005-09-14 11:00:00 | QQQ | ETF | 39.5 | 39.57 | 39.49 | 39.56 | 2935700.0 |
| 2005-09-14 11:30:00 | QQQ | ETF | 39.56 | 39.6 | 39.53 | 39.55 | 3109500.0 |
| 2005-09-14 12:00:00 | QQQ | ETF | 39.55 | 39.6 | 39.53 | 39.56 | 2062100.0 |
| 2005-09-14 12:30:00 | QQQ | ETF | 39.56 | 39.56 | 39.47 | 39.53 | 3134700.0 |
| 2005-09-14 13:00:00 | QQQ | ETF | 39.53 | 39.56 | 39.52 | 39.53 | 2414900.0 |
| 2005-09-14 13:30:00 | QQQ | ETF | 39.53 | 39.53 | 39.38 | 39.42 | 6979800.0 |
| 2005-09-14 14:00:00 | QQQ | ETF | 39.42 | 39.43 | 39.25 | 39.31 | 8471000.0 |
| 2005-09-14 14:30:00 | QQQ | ETF | 39.31 | 39.34 | 39.26 | 39.28 | 4189300.0 |
| 2005-09-14 15:00:00 | QQQ | ETF | 39.28 | 39.28 | 39.15 | 39.21 | 9128900.0 |
| 2005-09-14 15:30:00 | QQQ | ETF | 39.22 | 39.28 | 39.17 | 39.19 | 8587200.0 |
| 2005-09-14 08:00:00 | IWM | ETF | 67.19 | 67.19 | 67.19 | 67.19 | 2000.0 |
| 2005-09-14 08:30:00 | IWM | ETF | 67.12 | 67.22 | 67.12 | 67.22 | 7300.0 |
| 2005-09-14 09:00:00 | IWM | ETF | 67.23 | 67.24 | 67.2 | 67.2 | 111400.0 |
| 2005-09-14 09:30:00 | IWM | ETF | 67.195 | 67.3 | 66.96 | 66.96 | 3740500.0 |
| 2005-09-14 10:00:00 | IWM | ETF | 66.96 | 67.07 | 66.82 | 66.83 | 802600.0 |
| 2005-09-14 10:30:00 | IWM | ETF | 66.84 | 67.01 | 66.79 | 66.89 | 1359900.0 |
| 2005-09-14 11:00:00 | IWM | ETF | 66.9 | 67.03 | 66.89 | 66.93 | 590900.0 |
| 2005-09-14 11:30:00 | IWM | ETF | 66.94 | 67.04 | 66.86 | 66.86 | 690000.0 |
| 2005-09-14 12:00:00 | IWM | ETF | 66.86 | 66.92 | 66.78 | 66.79 | 1332400.0 |
| 2005-09-14 12:30:00 | IWM | ETF | 66.8 | 66.8 | 66.69 | 66.75 | 1243800.0 |
| 2005-09-14 13:00:00 | IWM | ETF | 66.75 | 66.82 | 66.75 | 66.75 | 913100.0 |
| 2005-09-14 13:30:00 | IWM | ETF | 66.76 | 66.76 | 66.55 | 66.62 | 1869200.0 |
| 2005-09-14 14:00:00 | IWM | ETF | 66.61 | 66.65 | 66.43 | 66.53 | 1210700.0 |
> showing 50 of 1,627 rows — these rows as CSV