PREVIEW / etf_30min / 2002-02-07
file: by_date/etf_30min/2002/2002-02-07.parquet size: 17 KB rows: 455
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-07 09:30:00 | SPY | ETF | 108.72 | 109.04 | 108.56 | 108.99 | 2742500.0 |
| 2002-02-07 10:00:00 | SPY | ETF | 108.95 | 109.23 | 108.16 | 108.2 | 2202300.0 |
| 2002-02-07 10:30:00 | SPY | ETF | 108.2 | 108.99 | 108.17 | 108.95 | 2916300.0 |
| 2002-02-07 11:00:00 | SPY | ETF | 108.95 | 109.47 | 108.92 | 109.17 | 2999400.0 |
| 2002-02-07 11:30:00 | SPY | ETF | 109.16 | 109.86 | 109.16 | 109.47 | 2008900.0 |
| 2002-02-07 12:00:00 | SPY | ETF | 109.47 | 109.69 | 109.34 | 109.48 | 839800.0 |
| 2002-02-07 12:30:00 | SPY | ETF | 109.43 | 109.52 | 109.1 | 109.34 | 980800.0 |
| 2002-02-07 13:00:00 | SPY | ETF | 109.3 | 109.44 | 109.1 | 109.29 | 828000.0 |
| 2002-02-07 13:30:00 | SPY | ETF | 109.3 | 109.66 | 109.3 | 109.5 | 499300.0 |
| 2002-02-07 14:00:00 | SPY | ETF | 109.6 | 109.6 | 109.04 | 109.04 | 798200.0 |
| 2002-02-07 14:30:00 | SPY | ETF | 109.04 | 109.45 | 109.0 | 109.3 | 963400.0 |
| 2002-02-07 15:00:00 | SPY | ETF | 109.3 | 109.3 | 108.7 | 109.04 | 1328000.0 |
| 2002-02-07 15:30:00 | SPY | ETF | 109.06 | 109.06 | 108.28 | 108.38 | 1863200.0 |
| 2002-02-07 16:00:00 | SPY | ETF | 108.41 | 108.7 | 108.0 | 108.05 | 1387500.0 |
| 2002-02-07 16:30:00 | SPY | ETF | 108.06 | 108.06 | 107.75 | 107.9 | 37900.0 |
| 2002-02-07 17:00:00 | SPY | ETF | 107.97 | 108.03 | 107.91 | 108.0 | 2500.0 |
| 2002-02-07 17:30:00 | SPY | ETF | 108.0 | 108.01 | 108.0 | 108.01 | 3300.0 |
| 2002-02-07 18:00:00 | SPY | ETF | 108.01 | 108.04 | 107.88 | 108.04 | 1500.0 |
| 2002-02-07 09:30:00 | QQQ | ETF | 35.99 | 36.14 | 35.69 | 35.81 | 14173500.0 |
| 2002-02-07 10:00:00 | QQQ | ETF | 35.8 | 35.98 | 35.45 | 35.48 | 11213900.0 |
| 2002-02-07 10:30:00 | QQQ | ETF | 35.49 | 35.98 | 35.44 | 35.9 | 10799100.0 |
| 2002-02-07 11:00:00 | QQQ | ETF | 35.95 | 36.22 | 35.89 | 36.05 | 11287400.0 |
| 2002-02-07 11:30:00 | QQQ | ETF | 36.05 | 36.39 | 36.04 | 36.17 | 6200800.0 |
| 2002-02-07 12:00:00 | QQQ | ETF | 36.17 | 36.29 | 36.0 | 36.07 | 2546300.0 |
| 2002-02-07 12:30:00 | QQQ | ETF | 36.07 | 36.12 | 35.8 | 35.93 | 6408500.0 |
| 2002-02-07 13:00:00 | QQQ | ETF | 35.94 | 36.06 | 35.84 | 35.91 | 4490800.0 |
| 2002-02-07 13:30:00 | QQQ | ETF | 35.9 | 36.26 | 35.88 | 36.25 | 3300400.0 |
| 2002-02-07 14:00:00 | QQQ | ETF | 36.25 | 36.29 | 35.84 | 35.88 | 4137300.0 |
| 2002-02-07 14:30:00 | QQQ | ETF | 35.84 | 36.06 | 35.8 | 35.93 | 3817600.0 |
| 2002-02-07 15:00:00 | QQQ | ETF | 35.93 | 35.94 | 35.61 | 35.76 | 6578900.0 |
| 2002-02-07 15:30:00 | QQQ | ETF | 35.75 | 35.79 | 35.16 | 35.21 | 8969000.0 |
| 2002-02-07 16:00:00 | QQQ | ETF | 35.21 | 35.28 | 35.13 | 35.2 | 2696000.0 |
| 2002-02-07 16:30:00 | QQQ | ETF | 35.2 | 35.35 | 35.12 | 35.17 | 360900.0 |
| 2002-02-07 17:00:00 | QQQ | ETF | 35.17 | 35.21 | 35.13 | 35.13 | 65500.0 |
| 2002-02-07 17:30:00 | QQQ | ETF | 35.12 | 35.3 | 35.07 | 35.12 | 55800.0 |
| 2002-02-07 18:00:00 | QQQ | ETF | 35.13 | 35.2 | 35.1 | 35.15 | 21300.0 |
| 2002-02-07 09:30:00 | IWM | ETF | 45.95 | 46.05 | 45.885 | 45.94 | 112200.0 |
| 2002-02-07 10:00:00 | IWM | ETF | 45.955 | 45.975 | 45.56 | 45.56 | 96400.0 |
| 2002-02-07 10:30:00 | IWM | ETF | 45.55 | 45.74 | 45.475 | 45.685 | 245600.0 |
| 2002-02-07 11:00:00 | IWM | ETF | 45.765 | 45.9 | 45.765 | 45.875 | 55600.0 |
| 2002-02-07 11:30:00 | IWM | ETF | 45.86 | 46.035 | 45.825 | 45.98 | 185600.0 |
| 2002-02-07 12:00:00 | IWM | ETF | 45.965 | 45.995 | 45.94 | 45.97 | 6600.0 |
| 2002-02-07 12:30:00 | IWM | ETF | 45.925 | 45.99 | 45.83 | 45.915 | 119000.0 |
| 2002-02-07 13:00:00 | IWM | ETF | 45.905 | 45.915 | 45.84 | 45.845 | 19600.0 |
| 2002-02-07 13:30:00 | IWM | ETF | 45.85 | 45.94 | 45.8 | 45.94 | 360400.0 |
| 2002-02-07 14:00:00 | IWM | ETF | 45.93 | 45.94 | 45.835 | 45.86 | 57000.0 |
| 2002-02-07 14:30:00 | IWM | ETF | 45.835 | 45.9 | 45.74 | 45.9 | 172000.0 |
| 2002-02-07 15:00:00 | IWM | ETF | 45.885 | 45.895 | 45.675 | 45.735 | 156200.0 |
| 2002-02-07 15:30:00 | IWM | ETF | 45.75 | 45.75 | 45.5 | 45.5 | 201200.0 |
| 2002-02-07 16:00:00 | IWM | ETF | 45.535 | 45.545 | 45.375 | 45.4 | 71600.0 |
> showing 50 of 455 rows — these rows as CSV