PREVIEW / etf_30min / 2005-02-02
file: by_date/etf_30min/2005/2005-02-02.parquet size: 41 KB rows: 1,442
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-02 08:00:00 | SPY | ETF | 119.13 | 119.18 | 119.13 | 119.17 | 12900.0 |
| 2005-02-02 08:30:00 | SPY | ETF | 119.15 | 119.15 | 119.09 | 119.09 | 4600.0 |
| 2005-02-02 09:00:00 | SPY | ETF | 119.09 | 119.12 | 119.04 | 119.05 | 26700.0 |
| 2005-02-02 09:30:00 | SPY | ETF | 119.06 | 119.1 | 118.92 | 118.93 | 5638000.0 |
| 2005-02-02 10:00:00 | SPY | ETF | 118.94 | 119.07 | 118.9 | 119.02 | 4704300.0 |
| 2005-02-02 10:30:00 | SPY | ETF | 119.02 | 119.2 | 118.99 | 119.18 | 5085200.0 |
| 2005-02-02 11:00:00 | SPY | ETF | 119.19 | 119.31 | 119.14 | 119.27 | 2333200.0 |
| 2005-02-02 11:30:00 | SPY | ETF | 119.27 | 119.33 | 119.19 | 119.33 | 1800900.0 |
| 2005-02-02 12:00:00 | SPY | ETF | 119.3 | 119.33 | 119.12 | 119.13 | 2299900.0 |
| 2005-02-02 12:30:00 | SPY | ETF | 119.14 | 119.18 | 119.06 | 119.18 | 907200.0 |
| 2005-02-02 13:00:00 | SPY | ETF | 119.18 | 119.22 | 119.14 | 119.21 | 754600.0 |
| 2005-02-02 13:30:00 | SPY | ETF | 119.22 | 119.22 | 119.11 | 119.18 | 1357600.0 |
| 2005-02-02 14:00:00 | SPY | ETF | 119.17 | 119.59 | 119.16 | 119.51 | 7895500.0 |
| 2005-02-02 14:30:00 | SPY | ETF | 119.51 | 119.54 | 119.03 | 119.24 | 8171900.0 |
| 2005-02-02 15:00:00 | SPY | ETF | 119.23 | 119.25 | 118.91 | 119.11 | 5330200.0 |
| 2005-02-02 15:30:00 | SPY | ETF | 119.11 | 119.4 | 119.02 | 119.35 | 4417700.0 |
| 2005-02-02 16:00:00 | SPY | ETF | 119.4 | 119.48 | 119.2 | 119.2 | 885300.0 |
| 2005-02-02 16:30:00 | SPY | ETF | 119.25 | 119.27 | 119.23 | 119.24 | 90200.0 |
| 2005-02-02 17:00:00 | SPY | ETF | 119.24 | 119.28 | 119.18 | 119.19 | 24000.0 |
| 2005-02-02 17:30:00 | SPY | ETF | 119.17 | 119.2 | 119.16 | 119.16 | 4500.0 |
| 2005-02-02 18:00:00 | SPY | ETF | 119.16 | 119.18 | 119.14 | 119.18 | 800.0 |
| 2005-02-02 18:30:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 500.0 |
| 2005-02-02 19:30:00 | SPY | ETF | 119.19 | 119.19 | 119.19 | 119.19 | 200.0 |
| 2005-02-02 09:30:00 | QQQ | ETF | 37.65 | 37.66 | 37.49 | 37.49 | 11983600.0 |
| 2005-02-02 10:00:00 | QQQ | ETF | 37.49 | 37.5 | 37.4 | 37.45 | 9102300.0 |
| 2005-02-02 10:30:00 | QQQ | ETF | 37.45 | 37.58 | 37.43 | 37.57 | 6088500.0 |
| 2005-02-02 11:00:00 | QQQ | ETF | 37.56 | 37.59 | 37.54 | 37.56 | 3405500.0 |
| 2005-02-02 11:30:00 | QQQ | ETF | 37.56 | 37.58 | 37.52 | 37.58 | 2388200.0 |
| 2005-02-02 12:00:00 | QQQ | ETF | 37.58 | 37.59 | 37.5 | 37.51 | 1824000.0 |
| 2005-02-02 12:30:00 | QQQ | ETF | 37.51 | 37.53 | 37.48 | 37.53 | 2532600.0 |
| 2005-02-02 13:00:00 | QQQ | ETF | 37.53 | 37.58 | 37.52 | 37.58 | 1590000.0 |
| 2005-02-02 13:30:00 | QQQ | ETF | 37.58 | 37.59 | 37.55 | 37.57 | 2050400.0 |
| 2005-02-02 14:00:00 | QQQ | ETF | 37.57 | 37.73 | 37.55 | 37.65 | 10357300.0 |
| 2005-02-02 14:30:00 | QQQ | ETF | 37.66 | 37.66 | 37.4 | 37.48 | 12494600.0 |
| 2005-02-02 15:00:00 | QQQ | ETF | 37.48 | 37.48 | 37.31 | 37.43 | 13664800.0 |
| 2005-02-02 15:30:00 | QQQ | ETF | 37.43 | 37.61 | 37.37 | 37.57 | 11556000.0 |
| 2005-02-02 08:30:00 | IWM | ETF | 62.575 | 62.58 | 62.575 | 62.58 | 600.0 |
| 2005-02-02 09:00:00 | IWM | ETF | 62.59 | 62.59 | 62.56 | 62.56 | 800.0 |
| 2005-02-02 09:30:00 | IWM | ETF | 62.56 | 62.665 | 62.47 | 62.49 | 1704800.0 |
| 2005-02-02 10:00:00 | IWM | ETF | 62.5 | 62.575 | 62.46 | 62.575 | 1336200.0 |
| 2005-02-02 10:30:00 | IWM | ETF | 62.57 | 62.74 | 62.535 | 62.71 | 1355400.0 |
| 2005-02-02 11:00:00 | IWM | ETF | 62.7 | 62.73 | 62.63 | 62.665 | 455400.0 |
| 2005-02-02 11:30:00 | IWM | ETF | 62.675 | 62.68 | 62.6 | 62.68 | 507400.0 |
| 2005-02-02 12:00:00 | IWM | ETF | 62.66 | 62.68 | 62.55 | 62.55 | 1060200.0 |
| 2005-02-02 12:30:00 | IWM | ETF | 62.56 | 62.62 | 62.53 | 62.6 | 580200.0 |
| 2005-02-02 13:00:00 | IWM | ETF | 62.6 | 62.635 | 62.555 | 62.635 | 525000.0 |
| 2005-02-02 13:30:00 | IWM | ETF | 62.64 | 62.645 | 62.58 | 62.605 | 1436800.0 |
| 2005-02-02 14:00:00 | IWM | ETF | 62.61 | 62.995 | 62.605 | 62.91 | 2050800.0 |
| 2005-02-02 14:30:00 | IWM | ETF | 62.91 | 62.945 | 62.615 | 62.77 | 1104000.0 |
| 2005-02-02 15:00:00 | IWM | ETF | 62.775 | 62.8 | 62.56 | 62.68 | 1767400.0 |
> showing 50 of 1,442 rows — these rows as CSV