PREVIEW / etf_30min / 2002-01-30
file: by_date/etf_30min/2002/2002-01-30.parquet size: 18 KB rows: 466
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-30 08:00:00 | SPY | ETF | 110.39 | 110.39 | 110.0365 | 110.3016 | 2330.0 |
| 2002-01-30 08:30:00 | SPY | ETF | 110.39 | 111.044 | 110.39 | 110.4784 | 41580.0 |
| 2002-01-30 09:00:00 | SPY | ETF | 110.6551 | 110.6551 | 110.1425 | 110.39 | 61590.0 |
| 2002-01-30 09:30:00 | SPY | ETF | 110.39 | 110.84 | 109.99 | 110.6 | 4402600.0 |
| 2002-01-30 10:00:00 | SPY | ETF | 110.57 | 110.7 | 109.38 | 109.55 | 3822000.0 |
| 2002-01-30 10:30:00 | SPY | ETF | 109.57 | 110.06 | 109.52 | 109.86 | 2160600.0 |
| 2002-01-30 11:00:00 | SPY | ETF | 109.8 | 110.28 | 109.57 | 109.63 | 1848400.0 |
| 2002-01-30 11:30:00 | SPY | ETF | 109.61 | 109.79 | 108.77 | 108.78 | 2250800.0 |
| 2002-01-30 12:00:00 | SPY | ETF | 108.8 | 109.32 | 108.4 | 109.27 | 3294800.0 |
| 2002-01-30 12:30:00 | SPY | ETF | 109.2 | 109.36 | 108.96 | 109.14 | 1777400.0 |
| 2002-01-30 13:00:00 | SPY | ETF | 109.14 | 109.74 | 109.12 | 109.57 | 1411100.0 |
| 2002-01-30 13:30:00 | SPY | ETF | 109.58 | 110.13 | 109.52 | 110.01 | 1297400.0 |
| 2002-01-30 14:00:00 | SPY | ETF | 110.8579 | 111.7681 | 110.4165 | 111.108 | 1625310.0 |
| 2002-01-30 14:30:00 | SPY | ETF | 111.1351 | 111.258 | 110.2508 | 111.1862 | 1373570.0 |
| 2002-01-30 15:00:00 | SPY | ETF | 111.2671 | 112.0754 | 111.1629 | 111.3158 | 1563530.0 |
| 2002-01-30 15:30:00 | SPY | ETF | 111.3249 | 113.39 | 111.2349 | 113.2818 | 1840250.0 |
| 2002-01-30 16:00:00 | SPY | ETF | 113.2999 | 113.39 | 111.8577 | 113.1737 | 480120.0 |
| 2002-01-30 16:30:00 | SPY | ETF | 113.2999 | 113.408 | 111.8397 | 113.2278 | 64520.0 |
| 2002-01-30 17:00:00 | SPY | ETF | 113.39 | 113.4261 | 113.39 | 113.4261 | 670.0 |
| 2002-01-30 17:30:00 | SPY | ETF | 113.39 | 113.4801 | 113.2999 | 113.4801 | 2770.0 |
| 2002-01-30 18:00:00 | SPY | ETF | 113.4801 | 113.4801 | 113.408 | 113.408 | 890.0 |
| 2002-01-30 09:30:00 | QQQ | ETF | 38.0 | 38.03 | 37.45 | 37.87 | 11011500.0 |
| 2002-01-30 10:00:00 | QQQ | ETF | 37.85 | 37.89 | 37.12 | 37.27 | 10033400.0 |
| 2002-01-30 10:30:00 | QQQ | ETF | 37.26 | 37.58 | 37.2 | 37.38 | 5460600.0 |
| 2002-01-30 11:00:00 | QQQ | ETF | 37.34 | 37.74 | 37.22 | 37.32 | 8317800.0 |
| 2002-01-30 11:30:00 | QQQ | ETF | 37.32 | 37.45 | 36.94 | 37.0 | 6699700.0 |
| 2002-01-30 12:00:00 | QQQ | ETF | 37.0 | 37.28 | 36.85 | 37.2 | 7212000.0 |
| 2002-01-30 12:30:00 | QQQ | ETF | 37.23 | 37.33 | 37.08 | 37.21 | 3038700.0 |
| 2002-01-30 13:00:00 | QQQ | ETF | 37.2 | 37.54 | 37.19 | 37.38 | 4198800.0 |
| 2002-01-30 13:30:00 | QQQ | ETF | 37.4 | 37.65 | 37.37 | 37.54 | 3878900.0 |
| 2002-01-30 14:00:00 | QQQ | ETF | 37.55 | 37.95 | 37.5 | 37.6 | 10112000.0 |
| 2002-01-30 14:30:00 | QQQ | ETF | 37.6 | 37.73 | 37.35 | 37.73 | 8150400.0 |
| 2002-01-30 15:00:00 | QQQ | ETF | 37.73 | 38.07 | 37.68 | 37.76 | 8942200.0 |
| 2002-01-30 15:30:00 | QQQ | ETF | 37.77 | 38.3 | 37.74 | 38.28 | 11699600.0 |
| 2002-01-30 16:00:00 | QQQ | ETF | 38.25 | 38.35 | 37.65 | 38.29 | 2076300.0 |
| 2002-01-30 16:30:00 | QQQ | ETF | 38.28 | 38.39 | 38.25 | 38.39 | 81200.0 |
| 2002-01-30 17:00:00 | QQQ | ETF | 38.39 | 38.47 | 38.33 | 38.4 | 76800.0 |
| 2002-01-30 17:30:00 | QQQ | ETF | 38.4 | 38.45 | 38.37 | 38.38 | 60700.0 |
| 2002-01-30 18:00:00 | QQQ | ETF | 38.39 | 38.46 | 38.38 | 38.46 | 18000.0 |
| 2002-01-30 09:30:00 | IWM | ETF | 47.2 | 47.225 | 46.95 | 46.995 | 379000.0 |
| 2002-01-30 10:00:00 | IWM | ETF | 47.075 | 47.075 | 46.625 | 46.625 | 123600.0 |
| 2002-01-30 10:30:00 | IWM | ETF | 46.705 | 46.85 | 46.595 | 46.745 | 44400.0 |
| 2002-01-30 11:00:00 | IWM | ETF | 46.79 | 46.835 | 46.575 | 46.7 | 22400.0 |
| 2002-01-30 11:30:00 | IWM | ETF | 46.685 | 46.775 | 46.595 | 46.595 | 17400.0 |
| 2002-01-30 12:00:00 | IWM | ETF | 46.54 | 46.63 | 46.5 | 46.62 | 61600.0 |
| 2002-01-30 12:30:00 | IWM | ETF | 46.63 | 46.66 | 46.535 | 46.66 | 41200.0 |
| 2002-01-30 13:00:00 | IWM | ETF | 46.6 | 46.82 | 46.6 | 46.82 | 103400.0 |
| 2002-01-30 13:30:00 | IWM | ETF | 46.82 | 47.0 | 46.8 | 46.98 | 66600.0 |
| 2002-01-30 14:00:00 | IWM | ETF | 46.99 | 47.37 | 46.99 | 47.25 | 131000.0 |
| 2002-01-30 14:30:00 | IWM | ETF | 47.115 | 47.27 | 47.075 | 47.27 | 76800.0 |
> showing 50 of 466 rows — these rows as CSV