PREVIEW / etf_30min / 2005-09-13
file: by_date/etf_30min/2005/2005-09-13.parquet size: 46 KB rows: 1,623
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-13 07:00:00 | SPY | ETF | 124.0 | 124.0 | 123.97 | 123.98 | 11500.0 |
| 2005-09-13 07:30:00 | SPY | ETF | 123.96 | 124.05 | 123.95 | 124.05 | 51900.0 |
| 2005-09-13 08:00:00 | SPY | ETF | 123.95 | 124.08 | 123.95 | 124.0 | 488000.0 |
| 2005-09-13 08:30:00 | SPY | ETF | 124.0 | 124.18 | 123.96 | 124.15 | 1088400.0 |
| 2005-09-13 09:00:00 | SPY | ETF | 124.17 | 124.17 | 124.0 | 124.12 | 833100.0 |
| 2005-09-13 09:30:00 | SPY | ETF | 124.13 | 124.16 | 123.88 | 123.95 | 6411500.0 |
| 2005-09-13 10:00:00 | SPY | ETF | 123.96 | 124.03 | 123.88 | 124.0 | 3024400.0 |
| 2005-09-13 10:30:00 | SPY | ETF | 124.0 | 124.15 | 123.66 | 123.74 | 5248500.0 |
| 2005-09-13 11:00:00 | SPY | ETF | 123.74 | 123.97 | 123.59 | 123.66 | 4480200.0 |
| 2005-09-13 11:30:00 | SPY | ETF | 123.66 | 124.06 | 123.6 | 123.65 | 2205200.0 |
| 2005-09-13 12:00:00 | SPY | ETF | 123.67 | 123.74 | 123.56 | 123.69 | 1990200.0 |
| 2005-09-13 12:30:00 | SPY | ETF | 123.68 | 123.85 | 123.62 | 123.84 | 2095700.0 |
| 2005-09-13 13:00:00 | SPY | ETF | 123.85 | 123.92 | 123.77 | 123.85 | 2398300.0 |
| 2005-09-13 13:30:00 | SPY | ETF | 123.86 | 123.98 | 123.79 | 123.82 | 2160500.0 |
| 2005-09-13 14:00:00 | SPY | ETF | 123.82 | 124.42 | 123.71 | 124.2 | 7687900.0 |
| 2005-09-13 14:30:00 | SPY | ETF | 124.2 | 124.24 | 124.01 | 124.06 | 2770500.0 |
| 2005-09-13 15:00:00 | SPY | ETF | 124.07 | 124.09 | 123.67 | 123.79 | 5656100.0 |
| 2005-09-13 15:30:00 | SPY | ETF | 123.79 | 123.88 | 123.52 | 123.57 | 5752100.0 |
| 2005-09-13 16:00:00 | SPY | ETF | 123.55 | 123.66 | 123.55 | 123.6 | 373900.0 |
| 2005-09-13 16:30:00 | SPY | ETF | 123.64 | 123.67 | 123.61 | 123.67 | 48700.0 |
| 2005-09-13 17:00:00 | SPY | ETF | 123.5151 | 123.68 | 123.5151 | 123.68 | 816700.0 |
| 2005-09-13 17:30:00 | SPY | ETF | 123.65 | 123.65 | 123.63 | 123.63 | 2000.0 |
| 2005-09-13 18:00:00 | SPY | ETF | 123.68 | 123.7 | 123.68 | 123.7 | 51500.0 |
| 2005-09-13 19:30:00 | SPY | ETF | 123.71 | 123.71 | 123.71 | 123.71 | 400.0 |
| 2005-09-13 09:30:00 | QQQ | ETF | 39.68 | 39.73 | 39.6 | 39.66 | 7511200.0 |
| 2005-09-13 10:00:00 | QQQ | ETF | 39.66 | 39.71 | 39.62 | 39.68 | 3783500.0 |
| 2005-09-13 10:30:00 | QQQ | ETF | 39.69 | 39.69 | 39.56 | 39.57 | 5732100.0 |
| 2005-09-13 11:00:00 | QQQ | ETF | 39.58 | 39.61 | 39.54 | 39.59 | 4540200.0 |
| 2005-09-13 11:30:00 | QQQ | ETF | 39.6 | 39.63 | 39.57 | 39.6 | 2205800.0 |
| 2005-09-13 12:00:00 | QQQ | ETF | 39.59 | 39.63 | 39.56 | 39.6 | 2399100.0 |
| 2005-09-13 12:30:00 | QQQ | ETF | 39.61 | 39.68 | 39.59 | 39.68 | 1966600.0 |
| 2005-09-13 13:00:00 | QQQ | ETF | 39.68 | 39.7 | 39.65 | 39.67 | 2635400.0 |
| 2005-09-13 13:30:00 | QQQ | ETF | 39.67 | 39.72 | 39.65 | 39.69 | 2649400.0 |
| 2005-09-13 14:00:00 | QQQ | ETF | 39.69 | 39.91 | 39.66 | 39.84 | 12428900.0 |
| 2005-09-13 14:30:00 | QQQ | ETF | 39.84 | 39.85 | 39.77 | 39.81 | 2888600.0 |
| 2005-09-13 15:00:00 | QQQ | ETF | 39.8 | 39.81 | 39.67 | 39.7 | 5857600.0 |
| 2005-09-13 15:30:00 | QQQ | ETF | 39.7 | 39.75 | 39.61 | 39.63 | 6939300.0 |
| 2005-09-13 08:30:00 | IWM | ETF | 67.58 | 67.59 | 67.49 | 67.49 | 10800.0 |
| 2005-09-13 09:00:00 | IWM | ETF | 67.57 | 67.57 | 67.54 | 67.54 | 4100.0 |
| 2005-09-13 09:30:00 | IWM | ETF | 67.55 | 67.55 | 67.2 | 67.26 | 2921300.0 |
| 2005-09-13 10:00:00 | IWM | ETF | 67.25 | 67.28 | 67.07 | 67.26 | 1632600.0 |
| 2005-09-13 10:30:00 | IWM | ETF | 67.27 | 67.31 | 67.07 | 67.12 | 2341700.0 |
| 2005-09-13 11:00:00 | IWM | ETF | 67.12 | 67.14 | 66.91 | 67.05 | 2253400.0 |
| 2005-09-13 11:30:00 | IWM | ETF | 67.06 | 67.16 | 67.04 | 67.08 | 751900.0 |
| 2005-09-13 12:00:00 | IWM | ETF | 67.08 | 67.18 | 67.01 | 67.16 | 747400.0 |
| 2005-09-13 12:30:00 | IWM | ETF | 67.17 | 67.28 | 67.1 | 67.26 | 1136100.0 |
| 2005-09-13 13:00:00 | IWM | ETF | 67.26 | 67.27 | 67.15 | 67.19 | 353900.0 |
| 2005-09-13 13:30:00 | IWM | ETF | 67.2 | 67.33 | 67.16 | 67.2 | 1770500.0 |
| 2005-09-13 14:00:00 | IWM | ETF | 67.21 | 67.55 | 67.16 | 67.4512 | 2720100.0 |
| 2005-09-13 14:30:00 | IWM | ETF | 67.46 | 67.47 | 67.22 | 67.27 | 824800.0 |
> showing 50 of 1,623 rows — these rows as CSV