PREVIEW / etf_30min / 2005-09-15
file: by_date/etf_30min/2005/2005-09-15.parquet size: 45 KB rows: 1,663
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-15 06:00:00 | SPY | ETF | 123.42 | 123.42 | 123.42 | 123.42 | 5800.0 |
| 2005-09-15 07:00:00 | SPY | ETF | 123.45 | 123.46 | 123.45 | 123.46 | 1900.0 |
| 2005-09-15 07:30:00 | SPY | ETF | 123.42 | 123.44 | 123.4 | 123.44 | 43400.0 |
| 2005-09-15 08:00:00 | SPY | ETF | 123.45 | 123.46 | 123.2 | 123.39 | 142100.0 |
| 2005-09-15 08:30:00 | SPY | ETF | 123.4 | 123.6 | 123.25 | 123.48 | 2280100.0 |
| 2005-09-15 09:00:00 | SPY | ETF | 123.47 | 123.6 | 123.47 | 123.51 | 810000.0 |
| 2005-09-15 09:30:00 | SPY | ETF | 123.51 | 123.65 | 123.43 | 123.54 | 5260700.0 |
| 2005-09-15 10:00:00 | SPY | ETF | 123.53 | 123.54 | 123.26 | 123.33 | 3865900.0 |
| 2005-09-15 10:30:00 | SPY | ETF | 123.34 | 123.43 | 123.09 | 123.32 | 6992500.0 |
| 2005-09-15 11:00:00 | SPY | ETF | 123.32 | 123.37 | 123.17 | 123.34 | 3398400.0 |
| 2005-09-15 11:30:00 | SPY | ETF | 123.33 | 123.5 | 123.2 | 123.22 | 3480800.0 |
| 2005-09-15 12:00:00 | SPY | ETF | 123.21 | 123.23 | 122.9 | 123.06 | 8003900.0 |
| 2005-09-15 12:30:00 | SPY | ETF | 123.06 | 123.15 | 123.01 | 123.04 | 2933100.0 |
| 2005-09-15 13:00:00 | SPY | ETF | 123.04 | 123.35 | 123.03 | 123.1 | 4008300.0 |
| 2005-09-15 13:30:00 | SPY | ETF | 123.06 | 123.26 | 123.06 | 123.09 | 2101800.0 |
| 2005-09-15 14:00:00 | SPY | ETF | 123.11 | 123.15 | 123.0 | 123.13 | 2222700.0 |
| 2005-09-15 14:30:00 | SPY | ETF | 123.14 | 123.29 | 123.1 | 123.18 | 2591600.0 |
| 2005-09-15 15:00:00 | SPY | ETF | 123.18 | 123.28 | 123.06 | 123.1 | 9355600.0 |
| 2005-09-15 15:30:00 | SPY | ETF | 123.1 | 123.27 | 122.94 | 123.22 | 5692000.0 |
| 2005-09-15 16:00:00 | SPY | ETF | 123.2 | 123.24 | 123.11 | 123.18 | 731000.0 |
| 2005-09-15 16:30:00 | SPY | ETF | 123.15 | 123.18 | 123.15 | 123.17 | 1120500.0 |
| 2005-09-15 17:00:00 | SPY | ETF | 123.17 | 123.21 | 123.15 | 123.21 | 80100.0 |
| 2005-09-15 17:30:00 | SPY | ETF | 123.22 | 123.22 | 123.03 | 123.15 | 36700.0 |
| 2005-09-15 18:00:00 | SPY | ETF | 123.17 | 123.2 | 123.13 | 123.18 | 476500.0 |
| 2005-09-15 18:30:00 | SPY | ETF | 123.2 | 123.2 | 123.2 | 123.2 | 500.0 |
| 2005-09-15 19:00:00 | SPY | ETF | 123.21 | 123.21 | 123.21 | 123.21 | 500.0 |
| 2005-09-15 19:30:00 | SPY | ETF | 123.23 | 123.23 | 123.23 | 123.23 | 200.0 |
| 2005-09-15 09:30:00 | QQQ | ETF | 39.26 | 39.34 | 39.19 | 39.25 | 13010700.0 |
| 2005-09-15 10:00:00 | QQQ | ETF | 39.25 | 39.26 | 39.16 | 39.17 | 5397600.0 |
| 2005-09-15 10:30:00 | QQQ | ETF | 39.18 | 39.23 | 39.05 | 39.15 | 11123100.0 |
| 2005-09-15 11:00:00 | QQQ | ETF | 39.15 | 39.19 | 39.11 | 39.17 | 4333900.0 |
| 2005-09-15 11:30:00 | QQQ | ETF | 39.18 | 39.28 | 39.14 | 39.17 | 5170900.0 |
| 2005-09-15 12:00:00 | QQQ | ETF | 39.17 | 39.18 | 39.06 | 39.11 | 7016600.0 |
| 2005-09-15 12:30:00 | QQQ | ETF | 39.11 | 39.16 | 39.09 | 39.14 | 3863800.0 |
| 2005-09-15 13:00:00 | QQQ | ETF | 39.14 | 39.27 | 39.14 | 39.15 | 4423400.0 |
| 2005-09-15 13:30:00 | QQQ | ETF | 39.15 | 39.21 | 39.12 | 39.13 | 2126300.0 |
| 2005-09-15 14:00:00 | QQQ | ETF | 39.13 | 39.16 | 39.11 | 39.14 | 1867300.0 |
| 2005-09-15 14:30:00 | QQQ | ETF | 39.14 | 39.22 | 39.12 | 39.14 | 4199300.0 |
| 2005-09-15 15:00:00 | QQQ | ETF | 39.13 | 39.17 | 39.1 | 39.14 | 3741600.0 |
| 2005-09-15 15:30:00 | QQQ | ETF | 39.15 | 39.2 | 39.1 | 39.17 | 5959100.0 |
| 2005-09-15 08:00:00 | IWM | ETF | 66.47 | 66.47 | 66.47 | 66.47 | 200000.0 |
| 2005-09-15 08:30:00 | IWM | ETF | 66.53 | 66.55 | 66.44 | 66.46 | 416700.0 |
| 2005-09-15 09:00:00 | IWM | ETF | 66.45 | 66.5 | 66.43 | 66.47 | 643800.0 |
| 2005-09-15 09:30:00 | IWM | ETF | 66.49 | 66.64 | 66.36 | 66.46 | 1995300.0 |
| 2005-09-15 10:00:00 | IWM | ETF | 66.45 | 66.46 | 66.23 | 66.24 | 977600.0 |
| 2005-09-15 10:30:00 | IWM | ETF | 66.24 | 66.35 | 66.14 | 66.23 | 2503800.0 |
| 2005-09-15 11:00:00 | IWM | ETF | 66.23 | 66.33 | 66.16 | 66.31 | 827800.0 |
| 2005-09-15 11:30:00 | IWM | ETF | 66.31 | 66.41 | 66.24 | 66.25 | 1793400.0 |
| 2005-09-15 12:00:00 | IWM | ETF | 66.26 | 66.4 | 66.06 | 66.21 | 1856700.0 |
| 2005-09-15 12:30:00 | IWM | ETF | 66.19 | 66.29 | 66.19 | 66.22 | 471400.0 |
> showing 50 of 1,663 rows — these rows as CSV