PREVIEW / etf_30min / 2001-02-09
file: by_date/etf_30min/2001/2001-02-09.parquet size: 14 KB rows: 327
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 |
|---|---|---|---|---|---|---|---|
| 2001-02-09 09:30:00 | SPY | ETF | 133.35 | 133.35 | 132.8 | 132.94 | 1541900.0 |
| 2001-02-09 10:00:00 | SPY | ETF | 132.9 | 133.35 | 132.65 | 133.15 | 1041600.0 |
| 2001-02-09 10:30:00 | SPY | ETF | 133.15 | 133.2 | 132.5 | 132.89 | 671800.0 |
| 2001-02-09 11:00:00 | SPY | ETF | 132.74 | 132.89 | 132.3 | 132.35 | 1054800.0 |
| 2001-02-09 11:30:00 | SPY | ETF | 132.32 | 132.6 | 132.32 | 132.54 | 701900.0 |
| 2001-02-09 12:00:00 | SPY | ETF | 132.54 | 132.72 | 132.33 | 132.58 | 829700.0 |
| 2001-02-09 12:30:00 | SPY | ETF | 132.58 | 132.75 | 132.35 | 132.43 | 335600.0 |
| 2001-02-09 13:00:00 | SPY | ETF | 132.5 | 132.77 | 132.45 | 132.74 | 298800.0 |
| 2001-02-09 13:30:00 | SPY | ETF | 132.62 | 132.7 | 132.16 | 132.37 | 178600.0 |
| 2001-02-09 14:00:00 | SPY | ETF | 132.35 | 132.48 | 132.0 | 132.02 | 316800.0 |
| 2001-02-09 14:30:00 | SPY | ETF | 132.02 | 132.37 | 131.85 | 131.88 | 344800.0 |
| 2001-02-09 15:00:00 | SPY | ETF | 131.84 | 131.92 | 131.26 | 131.47 | 1048800.0 |
| 2001-02-09 15:30:00 | SPY | ETF | 131.39 | 132.05 | 131.39 | 131.83 | 917000.0 |
| 2001-02-09 16:00:00 | SPY | ETF | 131.75 | 132.5 | 131.47 | 132.5 | 566200.0 |
| 2001-02-09 09:30:00 | QQQ | ETF | 58.25 | 58.6 | 57.55 | 57.69 | 8468600.0 |
| 2001-02-09 10:00:00 | QQQ | ETF | 57.69 | 58.56 | 57.45 | 58.08 | 4556900.0 |
| 2001-02-09 10:30:00 | QQQ | ETF | 58.1 | 58.18 | 57.25 | 57.52 | 4826300.0 |
| 2001-02-09 11:00:00 | QQQ | ETF | 57.47 | 57.75 | 57.0 | 57.01 | 6809400.0 |
| 2001-02-09 11:30:00 | QQQ | ETF | 57.01 | 57.39 | 56.9 | 57.19 | 3710300.0 |
| 2001-02-09 12:00:00 | QQQ | ETF | 57.15 | 57.72 | 57.12 | 57.21 | 3363000.0 |
| 2001-02-09 12:30:00 | QQQ | ETF | 57.21 | 57.44 | 57.0 | 57.13 | 1831600.0 |
| 2001-02-09 13:00:00 | QQQ | ETF | 57.15 | 57.5 | 57.1 | 57.42 | 1638400.0 |
| 2001-02-09 13:30:00 | QQQ | ETF | 57.41 | 57.43 | 56.72 | 56.96 | 2649200.0 |
| 2001-02-09 14:00:00 | QQQ | ETF | 56.96 | 57.12 | 56.55 | 56.63 | 1900400.0 |
| 2001-02-09 14:30:00 | QQQ | ETF | 56.65 | 56.96 | 56.38 | 56.4 | 3800300.0 |
| 2001-02-09 15:00:00 | QQQ | ETF | 56.4 | 56.65 | 56.01 | 56.2 | 3753800.0 |
| 2001-02-09 15:30:00 | QQQ | ETF | 56.2 | 56.69 | 56.15 | 56.46 | 5703800.0 |
| 2001-02-09 16:00:00 | QQQ | ETF | 56.47 | 58.05 | 56.11 | 56.42 | 1663800.0 |
| 2001-02-09 16:30:00 | QQQ | ETF | 56.4 | 61.04 | 56.3 | 56.7 | 46500.0 |
| 2001-02-09 17:00:00 | QQQ | ETF | 56.47 | 56.68 | 56.4 | 56.51 | 7200.0 |
| 2001-02-09 17:30:00 | QQQ | ETF | 56.6 | 56.6 | 56.41 | 56.5 | 3600.0 |
| 2001-02-09 18:00:00 | QQQ | ETF | 56.45 | 56.6 | 56.4 | 56.48 | 2400.0 |
| 2001-02-09 09:30:00 | IWM | ETF | 49.875 | 49.975 | 49.8 | 49.8 | 36200.0 |
| 2001-02-09 10:00:00 | IWM | ETF | 49.68 | 49.965 | 49.58 | 49.965 | 127600.0 |
| 2001-02-09 10:30:00 | IWM | ETF | 49.65 | 49.85 | 49.54 | 49.54 | 44800.0 |
| 2001-02-09 11:00:00 | IWM | ETF | 49.74 | 49.74 | 49.4 | 49.4 | 44800.0 |
| 2001-02-09 11:30:00 | IWM | ETF | 49.55 | 49.55 | 49.4 | 49.4 | 123800.0 |
| 2001-02-09 12:00:00 | IWM | ETF | 49.57 | 49.575 | 49.465 | 49.575 | 11000.0 |
| 2001-02-09 12:30:00 | IWM | ETF | 49.45 | 49.5 | 49.45 | 49.5 | 4200.0 |
| 2001-02-09 13:00:00 | IWM | ETF | 49.375 | 49.575 | 49.3 | 49.575 | 199400.0 |
| 2001-02-09 13:30:00 | IWM | ETF | 49.675 | 49.675 | 49.375 | 49.4 | 16000.0 |
| 2001-02-09 14:00:00 | IWM | ETF | 49.475 | 49.475 | 49.4 | 49.4 | 6800.0 |
| 2001-02-09 14:30:00 | IWM | ETF | 49.41 | 49.41 | 49.2 | 49.205 | 2600.0 |
| 2001-02-09 15:00:00 | IWM | ETF | 49.2 | 49.325 | 49.145 | 49.22 | 176800.0 |
| 2001-02-09 15:30:00 | IWM | ETF | 49.225 | 49.5 | 49.125 | 49.3 | 191000.0 |
| 2001-02-09 09:30:00 | DIA | ETF | 108.5 | 108.98 | 108.5 | 108.76 | 243700.0 |
| 2001-02-09 10:00:00 | DIA | ETF | 108.86 | 109.0 | 108.55 | 108.75 | 132600.0 |
| 2001-02-09 10:30:00 | DIA | ETF | 108.94 | 108.94 | 108.52 | 108.61 | 72700.0 |
| 2001-02-09 11:00:00 | DIA | ETF | 108.61 | 108.76 | 108.22 | 108.29 | 234300.0 |
| 2001-02-09 11:30:00 | DIA | ETF | 108.26 | 108.49 | 108.23 | 108.41 | 52800.0 |
> showing 50 of 327 rows — these rows as CSV