PREVIEW / etf_30min / 2002-02-05
file: by_date/etf_30min/2002/2002-02-05.parquet size: 18 KB rows: 471
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 |
|---|---|---|---|---|---|---|---|
| 2002-02-05 09:30:00 | SPY | ETF | 109.4 | 109.82 | 109.22 | 109.38 | 2138200.0 |
| 2002-02-05 10:00:00 | SPY | ETF | 109.38 | 109.46 | 108.53 | 109.05 | 5349500.0 |
| 2002-02-05 10:30:00 | SPY | ETF | 109.08 | 110.19 | 109.01 | 109.44 | 4567300.0 |
| 2002-02-05 11:00:00 | SPY | ETF | 109.45 | 109.75 | 109.23 | 109.51 | 1854900.0 |
| 2002-02-05 11:30:00 | SPY | ETF | 109.46 | 109.71 | 109.19 | 109.65 | 1185000.0 |
| 2002-02-05 12:00:00 | SPY | ETF | 109.7 | 109.74 | 109.37 | 109.42 | 1023000.0 |
| 2002-02-05 12:30:00 | SPY | ETF | 109.4 | 109.52 | 109.09 | 109.1 | 544200.0 |
| 2002-02-05 13:00:00 | SPY | ETF | 109.09 | 109.5 | 109.02 | 109.47 | 601700.0 |
| 2002-02-05 13:30:00 | SPY | ETF | 109.47 | 110.09 | 109.46 | 110.05 | 2677100.0 |
| 2002-02-05 14:00:00 | SPY | ETF | 110.02 | 110.19 | 109.68 | 110.19 | 1350600.0 |
| 2002-02-05 14:30:00 | SPY | ETF | 110.17 | 110.49 | 110.01 | 110.07 | 2967600.0 |
| 2002-02-05 15:00:00 | SPY | ETF | 110.06 | 110.19 | 109.26 | 109.37 | 2314200.0 |
| 2002-02-05 15:30:00 | SPY | ETF | 109.37 | 109.44 | 108.8 | 109.27 | 3114000.0 |
| 2002-02-05 16:00:00 | SPY | ETF | 109.25 | 109.32 | 109.04 | 109.17 | 1068600.0 |
| 2002-02-05 16:30:00 | SPY | ETF | 109.17 | 109.25 | 109.1 | 109.21 | 16900.0 |
| 2002-02-05 17:00:00 | SPY | ETF | 109.25 | 109.25 | 108.75 | 108.85 | 2176800.0 |
| 2002-02-05 17:30:00 | SPY | ETF | 108.9 | 108.95 | 108.8 | 108.9 | 35500.0 |
| 2002-02-05 09:30:00 | QQQ | ETF | 36.59 | 36.92 | 36.44 | 36.67 | 10899200.0 |
| 2002-02-05 10:00:00 | QQQ | ETF | 36.66 | 36.73 | 36.19 | 36.59 | 8714200.0 |
| 2002-02-05 10:30:00 | QQQ | ETF | 36.59 | 37.18 | 36.52 | 36.76 | 12933300.0 |
| 2002-02-05 11:00:00 | QQQ | ETF | 36.76 | 36.94 | 36.65 | 36.75 | 4618000.0 |
| 2002-02-05 11:30:00 | QQQ | ETF | 36.75 | 36.94 | 36.6 | 36.89 | 3591500.0 |
| 2002-02-05 12:00:00 | QQQ | ETF | 36.85 | 36.93 | 36.72 | 36.74 | 1922700.0 |
| 2002-02-05 12:30:00 | QQQ | ETF | 36.72 | 36.81 | 36.59 | 36.59 | 1844600.0 |
| 2002-02-05 13:00:00 | QQQ | ETF | 36.6 | 36.8 | 36.55 | 36.75 | 3969400.0 |
| 2002-02-05 13:30:00 | QQQ | ETF | 36.75 | 37.11 | 36.74 | 37.07 | 6248800.0 |
| 2002-02-05 14:00:00 | QQQ | ETF | 37.07 | 37.17 | 36.87 | 37.14 | 4045000.0 |
| 2002-02-05 14:30:00 | QQQ | ETF | 37.14 | 37.33 | 36.96 | 37.05 | 7115500.0 |
| 2002-02-05 15:00:00 | QQQ | ETF | 37.04 | 37.1 | 36.45 | 36.55 | 9083500.0 |
| 2002-02-05 15:30:00 | QQQ | ETF | 36.55 | 36.56 | 36.2 | 36.42 | 8598400.0 |
| 2002-02-05 16:00:00 | QQQ | ETF | 36.42 | 36.42 | 36.28 | 36.3 | 1886900.0 |
| 2002-02-05 16:30:00 | QQQ | ETF | 36.29 | 36.33 | 36.29 | 36.31 | 114300.0 |
| 2002-02-05 17:00:00 | QQQ | ETF | 36.33 | 36.38 | 36.25 | 36.25 | 41600.0 |
| 2002-02-05 17:30:00 | QQQ | ETF | 36.27 | 36.27 | 36.14 | 36.2 | 33600.0 |
| 2002-02-05 18:00:00 | QQQ | ETF | 36.18 | 36.3 | 36.1 | 36.3 | 17800.0 |
| 2002-02-05 09:30:00 | IWM | ETF | 46.575 | 46.72 | 46.4 | 46.5 | 25800.0 |
| 2002-02-05 10:00:00 | IWM | ETF | 46.455 | 46.455 | 46.195 | 46.39 | 46400.0 |
| 2002-02-05 10:30:00 | IWM | ETF | 46.41 | 46.775 | 46.35 | 46.6 | 347400.0 |
| 2002-02-05 11:00:00 | IWM | ETF | 46.555 | 46.65 | 46.55 | 46.6 | 347600.0 |
| 2002-02-05 11:30:00 | IWM | ETF | 46.575 | 46.595 | 46.505 | 46.52 | 8600.0 |
| 2002-02-05 12:00:00 | IWM | ETF | 46.525 | 46.595 | 46.525 | 46.595 | 8400.0 |
| 2002-02-05 12:30:00 | IWM | ETF | 46.595 | 46.595 | 46.5 | 46.555 | 3200.0 |
| 2002-02-05 13:00:00 | IWM | ETF | 46.52 | 46.565 | 46.475 | 46.565 | 8200.0 |
| 2002-02-05 13:30:00 | IWM | ETF | 46.565 | 46.725 | 46.565 | 46.725 | 411600.0 |
| 2002-02-05 14:00:00 | IWM | ETF | 46.65 | 46.7 | 46.63 | 46.7 | 115200.0 |
| 2002-02-05 14:30:00 | IWM | ETF | 46.745 | 46.85 | 46.65 | 46.75 | 136400.0 |
| 2002-02-05 15:00:00 | IWM | ETF | 46.72 | 46.74 | 46.475 | 46.5 | 32800.0 |
| 2002-02-05 15:30:00 | IWM | ETF | 46.495 | 46.575 | 46.315 | 46.575 | 306800.0 |
| 2002-02-05 16:00:00 | IWM | ETF | 46.5 | 46.52 | 46.5 | 46.52 | 6800.0 |
| 2002-02-05 09:30:00 | DIA | ETF | 96.55 | 97.2 | 96.53 | 96.82 | 345900.0 |
> showing 50 of 471 rows — these rows as CSV