PREVIEW / etf_30min / 2005-02-07
file: by_date/etf_30min/2005/2005-02-07.parquet size: 42 KB rows: 1,463
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-02-07 08:00:00 | SPY | ETF | 120.32 | 120.32 | 120.25 | 120.25 | 6700.0 |
| 2005-02-07 08:30:00 | SPY | ETF | 120.23 | 120.27 | 120.22 | 120.26 | 20100.0 |
| 2005-02-07 09:00:00 | SPY | ETF | 120.24 | 120.27 | 120.23 | 120.23 | 16000.0 |
| 2005-02-07 09:30:00 | SPY | ETF | 120.22 | 120.44 | 120.15 | 120.44 | 7960100.0 |
| 2005-02-07 10:00:00 | SPY | ETF | 120.44 | 120.52 | 120.31 | 120.43 | 8076100.0 |
| 2005-02-07 10:30:00 | SPY | ETF | 120.43 | 120.48 | 120.25 | 120.44 | 2714700.0 |
| 2005-02-07 11:00:00 | SPY | ETF | 120.45 | 120.52 | 120.38 | 120.42 | 4062500.0 |
| 2005-02-07 11:30:00 | SPY | ETF | 120.42 | 120.43 | 120.28 | 120.28 | 1985300.0 |
| 2005-02-07 12:00:00 | SPY | ETF | 120.28 | 120.38 | 120.12 | 120.26 | 2842000.0 |
| 2005-02-07 12:30:00 | SPY | ETF | 120.26 | 120.35 | 120.22 | 120.32 | 1078800.0 |
| 2005-02-07 13:00:00 | SPY | ETF | 120.34 | 120.42 | 120.1 | 120.17 | 2722600.0 |
| 2005-02-07 13:30:00 | SPY | ETF | 120.18 | 120.19 | 119.98 | 120.0 | 2734600.0 |
| 2005-02-07 14:00:00 | SPY | ETF | 119.98 | 120.17 | 119.96 | 120.15 | 1162900.0 |
| 2005-02-07 14:30:00 | SPY | ETF | 120.15 | 120.31 | 120.14 | 120.24 | 1899100.0 |
| 2005-02-07 15:00:00 | SPY | ETF | 120.24 | 120.345 | 120.17 | 120.3 | 2621100.0 |
| 2005-02-07 15:30:00 | SPY | ETF | 120.31 | 120.33 | 120.16 | 120.23 | 3992000.0 |
| 2005-02-07 16:00:00 | SPY | ETF | 120.25 | 120.35 | 120.05 | 120.13 | 440700.0 |
| 2005-02-07 16:30:00 | SPY | ETF | 120.14 | 120.23 | 120.08 | 120.11 | 207100.0 |
| 2005-02-07 17:00:00 | SPY | ETF | 120.09 | 120.12 | 120.09 | 120.11 | 15100.0 |
| 2005-02-07 17:30:00 | SPY | ETF | 120.1 | 120.1 | 120.1 | 120.1 | 200.0 |
| 2005-02-07 18:00:00 | SPY | ETF | 120.1 | 120.1 | 120.1 | 120.1 | 2200.0 |
| 2005-02-07 18:30:00 | SPY | ETF | 120.14 | 120.14 | 120.14 | 120.14 | 200.0 |
| 2005-02-07 19:30:00 | SPY | ETF | 120.1 | 120.1 | 120.1 | 120.1 | 3100.0 |
| 2005-02-07 09:30:00 | QQQ | ETF | 37.81 | 37.89 | 37.75 | 37.87 | 10835900.0 |
| 2005-02-07 10:00:00 | QQQ | ETF | 37.88 | 37.91 | 37.75 | 37.77 | 6927900.0 |
| 2005-02-07 10:30:00 | QQQ | ETF | 37.78 | 37.8 | 37.63 | 37.76 | 8480500.0 |
| 2005-02-07 11:00:00 | QQQ | ETF | 37.76 | 37.8 | 37.66 | 37.71 | 4484000.0 |
| 2005-02-07 11:30:00 | QQQ | ETF | 37.7 | 37.75 | 37.68 | 37.68 | 2721000.0 |
| 2005-02-07 12:00:00 | QQQ | ETF | 37.68 | 37.68 | 37.6 | 37.67 | 4205500.0 |
| 2005-02-07 12:30:00 | QQQ | ETF | 37.66 | 37.7 | 37.64 | 37.68 | 1728000.0 |
| 2005-02-07 13:00:00 | QQQ | ETF | 37.69 | 37.69 | 37.57 | 37.62 | 3845300.0 |
| 2005-02-07 13:30:00 | QQQ | ETF | 37.61 | 37.63 | 37.52 | 37.52 | 3413600.0 |
| 2005-02-07 14:00:00 | QQQ | ETF | 37.52 | 37.61 | 37.52 | 37.6 | 2536600.0 |
| 2005-02-07 14:30:00 | QQQ | ETF | 37.6 | 37.66 | 37.58 | 37.64 | 2713600.0 |
| 2005-02-07 15:00:00 | QQQ | ETF | 37.64 | 37.7 | 37.6 | 37.68 | 4014900.0 |
| 2005-02-07 15:30:00 | QQQ | ETF | 37.69 | 37.7 | 37.59 | 37.65 | 8482800.0 |
| 2005-02-07 09:30:00 | IWM | ETF | 63.525 | 63.745 | 63.525 | 63.745 | 2105000.0 |
| 2005-02-07 10:00:00 | IWM | ETF | 63.745 | 63.775 | 63.615 | 63.615 | 1330000.0 |
| 2005-02-07 10:30:00 | IWM | ETF | 63.625 | 63.715 | 63.53 | 63.685 | 951800.0 |
| 2005-02-07 11:00:00 | IWM | ETF | 63.695 | 63.75 | 63.645 | 63.68 | 194000.0 |
| 2005-02-07 11:30:00 | IWM | ETF | 63.68 | 63.68 | 63.575 | 63.6 | 231200.0 |
| 2005-02-07 12:00:00 | IWM | ETF | 63.6 | 63.6 | 63.4 | 63.455 | 1464400.0 |
| 2005-02-07 12:30:00 | IWM | ETF | 63.455 | 63.575 | 63.425 | 63.505 | 432400.0 |
| 2005-02-07 13:00:00 | IWM | ETF | 63.5 | 63.53 | 63.405 | 63.46 | 725600.0 |
| 2005-02-07 13:30:00 | IWM | ETF | 63.465 | 63.49 | 63.105 | 63.105 | 1358200.0 |
| 2005-02-07 14:00:00 | IWM | ETF | 63.105 | 63.295 | 63.09 | 63.28 | 509600.0 |
| 2005-02-07 14:30:00 | IWM | ETF | 63.28 | 63.365 | 63.24 | 63.335 | 418400.0 |
| 2005-02-07 15:00:00 | IWM | ETF | 63.33 | 63.45 | 63.3 | 63.43 | 683400.0 |
| 2005-02-07 15:30:00 | IWM | ETF | 63.415 | 63.44 | 63.3 | 63.38 | 1450200.0 |
| 2005-02-07 16:00:00 | IWM | ETF | 63.385 | 63.45 | 63.345 | 63.35 | 254800.0 |
> showing 50 of 1,463 rows — these rows as CSV