PREVIEW / etf_30min / 2005-09-19
file: by_date/etf_30min/2005/2005-09-19.parquet size: 48 KB rows: 1,695
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-19 07:00:00 | SPY | ETF | 123.37 | 123.38 | 123.33 | 123.38 | 14800.0 |
| 2005-09-19 07:30:00 | SPY | ETF | 123.36 | 123.36 | 123.32 | 123.35 | 7900.0 |
| 2005-09-19 08:00:00 | SPY | ETF | 123.41 | 123.48 | 123.33 | 123.44 | 288600.0 |
| 2005-09-19 08:30:00 | SPY | ETF | 123.45 | 123.55 | 123.45 | 123.53 | 87200.0 |
| 2005-09-19 09:00:00 | SPY | ETF | 123.54 | 123.57 | 123.34 | 123.45 | 864300.0 |
| 2005-09-19 09:30:00 | SPY | ETF | 123.47 | 123.55 | 123.31 | 123.4 | 6165800.0 |
| 2005-09-19 10:00:00 | SPY | ETF | 123.41 | 123.42 | 123.13 | 123.25 | 6698700.0 |
| 2005-09-19 10:30:00 | SPY | ETF | 123.25 | 123.43 | 123.1 | 123.11 | 4107000.0 |
| 2005-09-19 11:00:00 | SPY | ETF | 123.11 | 123.18 | 123.02 | 123.14 | 5842500.0 |
| 2005-09-19 11:30:00 | SPY | ETF | 123.13 | 123.13 | 122.93 | 122.98 | 3660900.0 |
| 2005-09-19 12:00:00 | SPY | ETF | 122.96 | 123.1 | 122.93 | 123.01 | 2394700.0 |
| 2005-09-19 12:30:00 | SPY | ETF | 123.0 | 123.13 | 122.97 | 123.08 | 1269700.0 |
| 2005-09-19 13:00:00 | SPY | ETF | 123.07 | 123.15 | 122.96 | 123.0 | 1271800.0 |
| 2005-09-19 13:30:00 | SPY | ETF | 123.0 | 123.12 | 122.98 | 123.02 | 886500.0 |
| 2005-09-19 14:00:00 | SPY | ETF | 123.05 | 123.09 | 122.73 | 122.82 | 3478600.0 |
| 2005-09-19 14:30:00 | SPY | ETF | 122.82 | 122.89 | 122.7 | 122.82 | 3511800.0 |
| 2005-09-19 15:00:00 | SPY | ETF | 122.82 | 123.39 | 122.64 | 122.71 | 3576700.0 |
| 2005-09-19 15:30:00 | SPY | ETF | 122.73 | 123.05 | 122.7 | 122.96 | 5822100.0 |
| 2005-09-19 16:00:00 | SPY | ETF | 122.95 | 123.12 | 122.93 | 123.1 | 628300.0 |
| 2005-09-19 16:30:00 | SPY | ETF | 123.09 | 123.12 | 123.02 | 123.05 | 194600.0 |
| 2005-09-19 17:00:00 | SPY | ETF | 123.05 | 123.07 | 123.05 | 123.07 | 700.0 |
| 2005-09-19 17:30:00 | SPY | ETF | 123.12 | 123.14 | 123.07 | 123.07 | 8800.0 |
| 2005-09-19 18:00:00 | SPY | ETF | 123.07 | 123.1 | 123.07 | 123.1 | 10600.0 |
| 2005-09-19 19:30:00 | SPY | ETF | 123.12 | 123.12 | 123.11 | 123.11 | 2400.0 |
| 2005-09-19 09:30:00 | QQQ | ETF | 39.33 | 39.38 | 39.26 | 39.29 | 9242300.0 |
| 2005-09-19 10:00:00 | QQQ | ETF | 39.29 | 39.29 | 39.14 | 39.2 | 10573400.0 |
| 2005-09-19 10:30:00 | QQQ | ETF | 39.2 | 39.26 | 39.15 | 39.15 | 3746800.0 |
| 2005-09-19 11:00:00 | QQQ | ETF | 39.15 | 39.16 | 37.3 | 39.1 | 8001900.0 |
| 2005-09-19 11:30:00 | QQQ | ETF | 39.1 | 39.11 | 38.97 | 39.02 | 6623700.0 |
| 2005-09-19 12:00:00 | QQQ | ETF | 39.02 | 39.08 | 39.0 | 39.03 | 2541800.0 |
| 2005-09-19 12:30:00 | QQQ | ETF | 39.03 | 39.09 | 39.02 | 39.06 | 1631300.0 |
| 2005-09-19 13:00:00 | QQQ | ETF | 39.07 | 39.08 | 39.01 | 39.03 | 1444700.0 |
| 2005-09-19 13:30:00 | QQQ | ETF | 39.03 | 39.09 | 39.03 | 39.06 | 1409100.0 |
| 2005-09-19 14:00:00 | QQQ | ETF | 39.05 | 39.07 | 38.91 | 38.93 | 5229500.0 |
| 2005-09-19 14:30:00 | QQQ | ETF | 38.93 | 38.98 | 38.92 | 38.94 | 4940000.0 |
| 2005-09-19 15:00:00 | QQQ | ETF | 38.95 | 39.0 | 38.94 | 38.96 | 3983200.0 |
| 2005-09-19 15:30:00 | QQQ | ETF | 38.97 | 39.1 | 38.96 | 39.1 | 8666100.0 |
| 2005-09-19 08:30:00 | IWM | ETF | 66.91 | 66.91 | 66.91 | 66.91 | 100.0 |
| 2005-09-19 09:00:00 | IWM | ETF | 66.87 | 66.94 | 66.87 | 66.94 | 1267300.0 |
| 2005-09-19 09:30:00 | IWM | ETF | 66.86 | 66.98 | 66.83 | 66.92 | 1485100.0 |
| 2005-09-19 10:00:00 | IWM | ETF | 66.92 | 66.92 | 66.64 | 66.77 | 3861300.0 |
| 2005-09-19 10:30:00 | IWM | ETF | 66.76 | 66.87 | 66.68 | 66.73 | 2291900.0 |
| 2005-09-19 11:00:00 | IWM | ETF | 66.73 | 66.77 | 66.63 | 66.66 | 1415200.0 |
| 2005-09-19 11:30:00 | IWM | ETF | 66.6676 | 66.6676 | 66.55 | 66.62 | 1547700.0 |
| 2005-09-19 12:00:00 | IWM | ETF | 66.62 | 66.68 | 66.59 | 66.63 | 489400.0 |
| 2005-09-19 12:30:00 | IWM | ETF | 66.62 | 66.75 | 66.61 | 66.72 | 671900.0 |
| 2005-09-19 13:00:00 | IWM | ETF | 66.72 | 66.74 | 66.63 | 66.65 | 312700.0 |
| 2005-09-19 13:30:00 | IWM | ETF | 66.65 | 66.76 | 66.65 | 66.67 | 904200.0 |
| 2005-09-19 14:00:00 | IWM | ETF | 66.66 | 66.72 | 66.35 | 66.37 | 1374200.0 |
| 2005-09-19 14:30:00 | IWM | ETF | 66.36 | 66.41 | 66.32 | 66.36 | 895500.0 |
> showing 50 of 1,695 rows — these rows as CSV