PREVIEW / etf_30min / 2005-08-16
file: by_date/etf_30min/2005/2005-08-16.parquet size: 47 KB rows: 1,639
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-08-16 07:00:00 | SPY | ETF | 123.61 | 123.65 | 123.6 | 123.65 | 4300.0 |
| 2005-08-16 07:30:00 | SPY | ETF | 123.6 | 123.63 | 123.6 | 123.63 | 259500.0 |
| 2005-08-16 08:00:00 | SPY | ETF | 123.61 | 123.61 | 123.57 | 123.61 | 33300.0 |
| 2005-08-16 08:30:00 | SPY | ETF | 123.68 | 123.74 | 123.49 | 123.51 | 860800.0 |
| 2005-08-16 09:00:00 | SPY | ETF | 123.51 | 123.61 | 123.43 | 123.43 | 765800.0 |
| 2005-08-16 09:30:00 | SPY | ETF | 123.44 | 123.52 | 123.16 | 123.26 | 4899800.0 |
| 2005-08-16 10:00:00 | SPY | ETF | 123.26 | 123.44 | 123.18 | 123.32 | 5620200.0 |
| 2005-08-16 10:30:00 | SPY | ETF | 123.3 | 123.31 | 122.73 | 122.82 | 7624500.0 |
| 2005-08-16 11:00:00 | SPY | ETF | 122.83 | 122.97 | 122.74 | 122.94 | 5246700.0 |
| 2005-08-16 11:30:00 | SPY | ETF | 122.95 | 123.02 | 122.76 | 122.78 | 5001900.0 |
| 2005-08-16 12:00:00 | SPY | ETF | 122.77 | 122.84 | 122.6 | 122.84 | 8341100.0 |
| 2005-08-16 12:30:00 | SPY | ETF | 122.83 | 122.89 | 122.74 | 122.78 | 1609200.0 |
| 2005-08-16 13:00:00 | SPY | ETF | 122.8 | 122.94 | 122.77 | 122.81 | 1320200.0 |
| 2005-08-16 13:30:00 | SPY | ETF | 122.81 | 122.84 | 122.64 | 122.65 | 1396600.0 |
| 2005-08-16 14:00:00 | SPY | ETF | 122.66 | 122.72 | 122.49 | 122.57 | 4632100.0 |
| 2005-08-16 14:30:00 | SPY | ETF | 122.57 | 122.82 | 122.55 | 122.7 | 1684600.0 |
| 2005-08-16 15:00:00 | SPY | ETF | 122.71 | 122.84 | 122.23 | 122.31 | 6698200.0 |
| 2005-08-16 15:30:00 | SPY | ETF | 122.31 | 122.57 | 122.11 | 122.12 | 9327000.0 |
| 2005-08-16 16:00:00 | SPY | ETF | 122.1 | 122.26 | 122.09 | 122.21 | 754200.0 |
| 2005-08-16 16:30:00 | SPY | ETF | 122.22 | 122.25 | 122.16 | 122.25 | 234200.0 |
| 2005-08-16 17:00:00 | SPY | ETF | 122.25 | 122.29 | 122.18 | 122.29 | 135300.0 |
| 2005-08-16 17:30:00 | SPY | ETF | 122.3 | 122.3 | 122.3 | 122.3 | 500.0 |
| 2005-08-16 18:00:00 | SPY | ETF | 122.3 | 122.33 | 122.29 | 122.3 | 26300.0 |
| 2005-08-16 19:00:00 | SPY | ETF | 122.32 | 122.32 | 122.29 | 122.29 | 2000.0 |
| 2005-08-16 19:30:00 | SPY | ETF | 122.29 | 122.29 | 122.27 | 122.28 | 5600.0 |
| 2005-08-16 09:30:00 | QQQ | ETF | 39.3 | 39.33 | 39.2 | 39.27 | 8697800.0 |
| 2005-08-16 10:00:00 | QQQ | ETF | 39.27 | 39.3 | 39.21 | 39.26 | 4367100.0 |
| 2005-08-16 10:30:00 | QQQ | ETF | 39.26 | 39.26 | 38.99 | 39.06 | 13627800.0 |
| 2005-08-16 11:00:00 | QQQ | ETF | 39.05 | 39.14 | 39.01 | 39.12 | 5708500.0 |
| 2005-08-16 11:30:00 | QQQ | ETF | 39.12 | 39.15 | 39.03 | 39.05 | 4517500.0 |
| 2005-08-16 12:00:00 | QQQ | ETF | 39.05 | 39.13 | 39.01 | 39.11 | 3541000.0 |
| 2005-08-16 12:30:00 | QQQ | ETF | 39.11 | 39.14 | 39.06 | 39.09 | 1849500.0 |
| 2005-08-16 13:00:00 | QQQ | ETF | 39.09 | 39.15 | 39.05 | 39.07 | 2425900.0 |
| 2005-08-16 13:30:00 | QQQ | ETF | 39.06 | 39.08 | 38.94 | 38.95 | 6499000.0 |
| 2005-08-16 14:00:00 | QQQ | ETF | 38.95 | 38.98 | 38.87 | 38.92 | 6460100.0 |
| 2005-08-16 14:30:00 | QQQ | ETF | 38.92 | 39.29 | 38.91 | 38.95 | 3229200.0 |
| 2005-08-16 15:00:00 | QQQ | ETF | 38.95 | 38.99 | 38.77 | 38.8 | 8593300.0 |
| 2005-08-16 15:30:00 | QQQ | ETF | 38.8 | 38.84 | 38.74 | 38.82 | 14012100.0 |
| 2005-08-16 08:00:00 | IWM | ETF | 66.12 | 66.12 | 66.12 | 66.12 | 800.0 |
| 2005-08-16 08:30:00 | IWM | ETF | 66.2 | 66.2 | 66.13 | 66.13 | 2400.0 |
| 2005-08-16 09:00:00 | IWM | ETF | 66.13 | 66.13 | 66.07 | 66.07 | 5900.0 |
| 2005-08-16 09:30:00 | IWM | ETF | 66.07 | 66.08 | 65.61 | 65.69 | 2758000.0 |
| 2005-08-16 10:00:00 | IWM | ETF | 65.7 | 65.82 | 65.55 | 65.69 | 949800.0 |
| 2005-08-16 10:30:00 | IWM | ETF | 65.68 | 65.68 | 65.34 | 65.42 | 1867100.0 |
| 2005-08-16 11:00:00 | IWM | ETF | 65.43 | 65.55 | 65.39 | 65.46 | 980400.0 |
| 2005-08-16 11:30:00 | IWM | ETF | 65.45 | 65.59 | 65.4 | 65.4 | 658400.0 |
| 2005-08-16 12:00:00 | IWM | ETF | 65.41 | 65.51 | 65.35 | 65.51 | 1566600.0 |
| 2005-08-16 12:30:00 | IWM | ETF | 65.51 | 65.52 | 65.41 | 65.46 | 520700.0 |
| 2005-08-16 13:00:00 | IWM | ETF | 65.45 | 65.58 | 65.45 | 65.49 | 515900.0 |
| 2005-08-16 13:30:00 | IWM | ETF | 65.48 | 65.54 | 65.42 | 65.47 | 965300.0 |
> showing 50 of 1,639 rows — these rows as CSV