PREVIEW / etf_30min / 2002-01-03
file: by_date/etf_30min/2002/2002-01-03.parquet size: 17 KB rows: 462
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-01-03 09:30:00 | SPY | ETF | 115.65 | 116.3 | 115.54 | 116.25 | 2700800.0 |
| 2002-01-03 10:00:00 | SPY | ETF | 116.2 | 116.38 | 115.98 | 116.0 | 2900300.0 |
| 2002-01-03 10:30:00 | SPY | ETF | 116.05 | 116.31 | 115.9 | 116.31 | 1050200.0 |
| 2002-01-03 11:00:00 | SPY | ETF | 116.25 | 116.49 | 116.17 | 116.28 | 613500.0 |
| 2002-01-03 11:30:00 | SPY | ETF | 116.34 | 116.34 | 116.06 | 116.18 | 704900.0 |
| 2002-01-03 12:00:00 | SPY | ETF | 116.19 | 116.24 | 115.94 | 116.07 | 390800.0 |
| 2002-01-03 12:30:00 | SPY | ETF | 116.07 | 116.23 | 115.8 | 116.18 | 752500.0 |
| 2002-01-03 13:00:00 | SPY | ETF | 116.21 | 116.31 | 116.08 | 116.11 | 515400.0 |
| 2002-01-03 13:30:00 | SPY | ETF | 116.09 | 116.35 | 116.03 | 116.14 | 523500.0 |
| 2002-01-03 14:00:00 | SPY | ETF | 116.16 | 116.28 | 115.92 | 116.02 | 664100.0 |
| 2002-01-03 14:30:00 | SPY | ETF | 116.02 | 116.3 | 115.99 | 116.29 | 557500.0 |
| 2002-01-03 15:00:00 | SPY | ETF | 116.25 | 116.58 | 116.11 | 116.49 | 1267800.0 |
| 2002-01-03 15:30:00 | SPY | ETF | 116.55 | 116.83 | 116.41 | 116.76 | 1775400.0 |
| 2002-01-03 16:00:00 | SPY | ETF | 116.82 | 116.95 | 116.72 | 116.8 | 1282800.0 |
| 2002-01-03 16:30:00 | SPY | ETF | 116.85 | 116.85 | 116.78 | 116.8 | 11600.0 |
| 2002-01-03 17:00:00 | SPY | ETF | 116.78 | 116.8 | 116.78 | 116.8 | 1300.0 |
| 2002-01-03 17:30:00 | SPY | ETF | 116.84 | 116.84 | 116.77 | 116.77 | 1300.0 |
| 2002-01-03 18:00:00 | SPY | ETF | 116.8 | 116.94 | 116.73 | 116.78 | 11300.0 |
| 2002-01-03 09:30:00 | QQQ | ETF | 40.31 | 40.95 | 40.26 | 40.9 | 11200200.0 |
| 2002-01-03 10:00:00 | QQQ | ETF | 40.92 | 41.06 | 40.83 | 40.87 | 9661500.0 |
| 2002-01-03 10:30:00 | QQQ | ETF | 40.9 | 41.21 | 40.87 | 41.2 | 8354500.0 |
| 2002-01-03 11:00:00 | QQQ | ETF | 41.18 | 41.34 | 41.15 | 41.23 | 6503300.0 |
| 2002-01-03 11:30:00 | QQQ | ETF | 41.22 | 41.25 | 41.07 | 41.2 | 4891800.0 |
| 2002-01-03 12:00:00 | QQQ | ETF | 41.2 | 41.22 | 41.08 | 41.18 | 3173900.0 |
| 2002-01-03 12:30:00 | QQQ | ETF | 41.18 | 41.31 | 40.95 | 41.27 | 3770000.0 |
| 2002-01-03 13:00:00 | QQQ | ETF | 41.28 | 41.3 | 41.09 | 41.1 | 2103200.0 |
| 2002-01-03 13:30:00 | QQQ | ETF | 41.1 | 41.3 | 41.07 | 41.22 | 3793800.0 |
| 2002-01-03 14:00:00 | QQQ | ETF | 41.27 | 41.34 | 41.02 | 41.08 | 5842200.0 |
| 2002-01-03 14:30:00 | QQQ | ETF | 41.07 | 41.3 | 41.06 | 41.27 | 3698300.0 |
| 2002-01-03 15:00:00 | QQQ | ETF | 41.27 | 41.5 | 41.15 | 41.47 | 7650700.0 |
| 2002-01-03 15:30:00 | QQQ | ETF | 41.46 | 41.54 | 41.32 | 41.44 | 8679300.0 |
| 2002-01-03 16:00:00 | QQQ | ETF | 41.45 | 41.55 | 41.35 | 41.46 | 4120900.0 |
| 2002-01-03 16:30:00 | QQQ | ETF | 41.47 | 41.51 | 40.9 | 41.49 | 568000.0 |
| 2002-01-03 17:00:00 | QQQ | ETF | 41.49 | 41.53 | 41.44 | 41.49 | 57900.0 |
| 2002-01-03 17:30:00 | QQQ | ETF | 41.46 | 41.5 | 41.45 | 41.48 | 10500.0 |
| 2002-01-03 18:00:00 | QQQ | ETF | 41.5 | 41.5 | 41.46 | 41.5 | 14800.0 |
| 2002-01-03 09:30:00 | IWM | ETF | 48.5 | 49.0 | 48.5 | 49.0 | 162600.0 |
| 2002-01-03 10:00:00 | IWM | ETF | 49.1 | 49.165 | 48.95 | 48.975 | 64000.0 |
| 2002-01-03 10:30:00 | IWM | ETF | 48.875 | 49.135 | 48.875 | 49.075 | 93800.0 |
| 2002-01-03 11:00:00 | IWM | ETF | 49.075 | 49.135 | 48.95 | 48.95 | 145800.0 |
| 2002-01-03 11:30:00 | IWM | ETF | 48.95 | 49.02 | 48.87 | 48.965 | 83200.0 |
| 2002-01-03 12:00:00 | IWM | ETF | 48.89 | 48.965 | 48.735 | 48.85 | 31800.0 |
| 2002-01-03 12:30:00 | IWM | ETF | 48.865 | 48.895 | 48.745 | 48.8 | 27200.0 |
| 2002-01-03 13:00:00 | IWM | ETF | 48.895 | 48.9 | 48.795 | 48.875 | 36600.0 |
| 2002-01-03 13:30:00 | IWM | ETF | 48.85 | 48.915 | 48.77 | 48.885 | 42400.0 |
| 2002-01-03 14:00:00 | IWM | ETF | 48.865 | 48.895 | 48.775 | 48.775 | 42600.0 |
| 2002-01-03 14:30:00 | IWM | ETF | 48.775 | 48.925 | 48.765 | 48.805 | 24400.0 |
| 2002-01-03 15:00:00 | IWM | ETF | 48.87 | 49.105 | 48.81 | 49.095 | 194800.0 |
| 2002-01-03 15:30:00 | IWM | ETF | 49.125 | 49.275 | 49.1 | 49.275 | 49200.0 |
| 2002-01-03 16:00:00 | IWM | ETF | 49.25 | 49.295 | 49.25 | 49.295 | 8000.0 |
> showing 50 of 462 rows — these rows as CSV