PREVIEW / etf_30min / 2005-11-09
file: by_date/etf_30min/2005/2005-11-09.parquet size: 51 KB rows: 1,782
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-11-09 07:00:00 | SPY | ETF | 122.3 | 122.3 | 122.1 | 122.13 | 68900.0 |
| 2005-11-09 07:30:00 | SPY | ETF | 122.1 | 122.1 | 122.1 | 122.1 | 18100.0 |
| 2005-11-09 08:00:00 | SPY | ETF | 122.11 | 122.25 | 122.06 | 122.07 | 1320600.0 |
| 2005-11-09 08:30:00 | SPY | ETF | 122.14 | 122.14 | 122.01 | 122.13 | 229000.0 |
| 2005-11-09 09:00:00 | SPY | ETF | 122.13 | 122.13 | 122.07 | 122.08 | 330000.0 |
| 2005-11-09 09:30:00 | SPY | ETF | 122.08 | 122.18 | 121.86 | 121.94 | 5727200.0 |
| 2005-11-09 10:00:00 | SPY | ETF | 121.94 | 122.08 | 121.86 | 122.05 | 2589900.0 |
| 2005-11-09 10:30:00 | SPY | ETF | 122.05 | 122.38 | 122.05 | 122.1 | 5279600.0 |
| 2005-11-09 11:00:00 | SPY | ETF | 122.1 | 122.1 | 121.92 | 121.94 | 2865300.0 |
| 2005-11-09 11:30:00 | SPY | ETF | 121.97 | 122.2 | 121.92 | 122.16 | 2129200.0 |
| 2005-11-09 12:00:00 | SPY | ETF | 122.15 | 122.84 | 122.08 | 122.78 | 8566200.0 |
| 2005-11-09 12:30:00 | SPY | ETF | 122.77 | 122.95 | 122.56 | 122.8 | 4766600.0 |
| 2005-11-09 13:00:00 | SPY | ETF | 122.8 | 122.82 | 122.71 | 122.73 | 2488000.0 |
| 2005-11-09 13:30:00 | SPY | ETF | 122.72 | 122.76 | 122.47 | 122.57 | 2228100.0 |
| 2005-11-09 14:00:00 | SPY | ETF | 122.58 | 122.64 | 122.4 | 122.5 | 3794500.0 |
| 2005-11-09 14:30:00 | SPY | ETF | 122.5 | 122.72 | 122.27 | 122.38 | 4521700.0 |
| 2005-11-09 15:00:00 | SPY | ETF | 122.39 | 122.65 | 122.35 | 122.61 | 2890500.0 |
| 2005-11-09 15:30:00 | SPY | ETF | 122.61 | 122.68 | 122.19 | 122.25 | 5872500.0 |
| 2005-11-09 16:00:00 | SPY | ETF | 122.26 | 122.39 | 122.2 | 122.35 | 640600.0 |
| 2005-11-09 16:30:00 | SPY | ETF | 122.35 | 122.36 | 122.32 | 122.34 | 109800.0 |
| 2005-11-09 17:00:00 | SPY | ETF | 122.34 | 122.34 | 122.2 | 122.2 | 571600.0 |
| 2005-11-09 17:30:00 | SPY | ETF | 122.25 | 122.29 | 122.21 | 122.29 | 14300.0 |
| 2005-11-09 18:00:00 | SPY | ETF | 122.29 | 122.29 | 122.29 | 122.29 | 200.0 |
| 2005-11-09 18:30:00 | SPY | ETF | 122.3 | 122.3 | 122.27 | 122.29 | 2400.0 |
| 2005-11-09 19:00:00 | SPY | ETF | 122.35 | 122.39 | 122.35 | 122.39 | 5300.0 |
| 2005-11-09 19:30:00 | SPY | ETF | 122.35 | 122.35 | 122.3 | 122.3 | 1400.0 |
| 2005-11-09 09:30:00 | QQQ | ETF | 40.13 | 40.17 | 40.06 | 40.06 | 6608500.0 |
| 2005-11-09 10:00:00 | QQQ | ETF | 40.07 | 40.09 | 40.03 | 40.06 | 3751900.0 |
| 2005-11-09 10:30:00 | QQQ | ETF | 40.06 | 40.21 | 40.06 | 40.11 | 6369900.0 |
| 2005-11-09 11:00:00 | QQQ | ETF | 40.11 | 40.12 | 40.04 | 40.08 | 4173600.0 |
| 2005-11-09 11:30:00 | QQQ | ETF | 40.08 | 40.15 | 40.04 | 40.12 | 2985600.0 |
| 2005-11-09 12:00:00 | QQQ | ETF | 40.12 | 40.33 | 40.07 | 40.29 | 9378800.0 |
| 2005-11-09 12:30:00 | QQQ | ETF | 40.29 | 40.33 | 40.25 | 40.28 | 7122800.0 |
| 2005-11-09 13:00:00 | QQQ | ETF | 40.28 | 40.33 | 40.26 | 40.26 | 2385700.0 |
| 2005-11-09 13:30:00 | QQQ | ETF | 40.26 | 40.28 | 40.17 | 40.22 | 3010800.0 |
| 2005-11-09 14:00:00 | QQQ | ETF | 40.22 | 40.24 | 40.17 | 40.2 | 3296700.0 |
| 2005-11-09 14:30:00 | QQQ | ETF | 40.19 | 40.27 | 40.09 | 40.15 | 5955600.0 |
| 2005-11-09 15:00:00 | QQQ | ETF | 40.15 | 40.24 | 40.13 | 40.21 | 3781100.0 |
| 2005-11-09 15:30:00 | QQQ | ETF | 40.2 | 40.24 | 40.13 | 40.16 | 6137200.0 |
| 2005-11-09 07:00:00 | IWM | ETF | 65.61 | 65.62 | 65.61 | 65.62 | 2900.0 |
| 2005-11-09 07:30:00 | IWM | ETF | 65.48 | 65.48 | 65.48 | 65.48 | 1000.0 |
| 2005-11-09 08:00:00 | IWM | ETF | 65.48 | 65.61 | 65.44 | 65.46 | 106700.0 |
| 2005-11-09 08:30:00 | IWM | ETF | 65.44 | 65.48 | 65.44 | 65.48 | 4000100.0 |
| 2005-11-09 09:00:00 | IWM | ETF | 65.46 | 65.47 | 65.39 | 65.39 | 44600.0 |
| 2005-11-09 09:30:00 | IWM | ETF | 65.415 | 65.49 | 65.11 | 65.18 | 1647400.0 |
| 2005-11-09 10:00:00 | IWM | ETF | 65.19 | 65.3 | 65.12 | 65.24 | 1010800.0 |
| 2005-11-09 10:30:00 | IWM | ETF | 65.23 | 65.44 | 65.22 | 65.26 | 1087000.0 |
| 2005-11-09 11:00:00 | IWM | ETF | 65.25 | 65.26 | 65.13 | 65.17 | 711900.0 |
| 2005-11-09 11:30:00 | IWM | ETF | 65.18 | 65.41 | 65.15 | 65.391 | 1031300.0 |
| 2005-11-09 12:00:00 | IWM | ETF | 65.4 | 65.89 | 65.3 | 65.86 | 5765500.0 |
> showing 50 of 1,782 rows — these rows as CSV