PREVIEW / etf_30min / 2002-11-15
file: by_date/etf_30min/2002/2002-11-15.parquet size: 21 KB rows: 621
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-11-15 08:00:00 | SPY | ETF | 90.84 | 91.17 | 90.84 | 91.17 | 8500.0 |
| 2002-11-15 08:30:00 | SPY | ETF | 91.0 | 91.01 | 90.35 | 90.35 | 15800.0 |
| 2002-11-15 09:00:00 | SPY | ETF | 90.23 | 90.33 | 90.01 | 90.01 | 22600.0 |
| 2002-11-15 09:30:00 | SPY | ETF | 90.0 | 91.15 | 89.97 | 90.75 | 9559200.0 |
| 2002-11-15 10:00:00 | SPY | ETF | 90.82 | 90.84 | 90.21 | 90.4 | 2885900.0 |
| 2002-11-15 10:30:00 | SPY | ETF | 90.39 | 90.46 | 90.09 | 90.39 | 1673000.0 |
| 2002-11-15 11:00:00 | SPY | ETF | 90.31 | 90.38 | 90.09 | 90.27 | 1851300.0 |
| 2002-11-15 11:30:00 | SPY | ETF | 90.29 | 90.45 | 89.95 | 90.2 | 1126600.0 |
| 2002-11-15 12:00:00 | SPY | ETF | 90.17 | 90.45 | 90.0 | 90.38 | 1215100.0 |
| 2002-11-15 12:30:00 | SPY | ETF | 90.38 | 90.46 | 90.2 | 90.25 | 676000.0 |
| 2002-11-15 13:00:00 | SPY | ETF | 90.26 | 90.7 | 90.15 | 90.68 | 1474300.0 |
| 2002-11-15 13:30:00 | SPY | ETF | 90.69 | 90.83 | 90.58 | 90.67 | 1032600.0 |
| 2002-11-15 14:00:00 | SPY | ETF | 90.67 | 91.2 | 90.55 | 91.13 | 2082100.0 |
| 2002-11-15 14:30:00 | SPY | ETF | 91.15 | 91.46 | 91.02 | 91.11 | 3608100.0 |
| 2002-11-15 15:00:00 | SPY | ETF | 91.1 | 91.34 | 91.01 | 91.32 | 1464500.0 |
| 2002-11-15 15:30:00 | SPY | ETF | 91.32 | 91.55 | 91.06 | 91.38 | 3243500.0 |
| 2002-11-15 16:00:00 | SPY | ETF | 91.45 | 91.5 | 91.3 | 91.4 | 4883600.0 |
| 2002-11-15 16:30:00 | SPY | ETF | 91.49 | 91.49 | 91.32 | 91.32 | 35000.0 |
| 2002-11-15 17:00:00 | SPY | ETF | 91.31 | 91.32 | 91.27 | 91.31 | 3900.0 |
| 2002-11-15 17:30:00 | SPY | ETF | 91.33 | 91.41 | 91.3 | 91.3 | 14100.0 |
| 2002-11-15 18:00:00 | SPY | ETF | 91.3 | 91.3 | 91.3 | 91.3 | 600.0 |
| 2002-11-15 08:00:00 | QQQ | ETF | 26.1 | 26.19 | 26.07 | 26.18 | 78700.0 |
| 2002-11-15 08:30:00 | QQQ | ETF | 26.18 | 26.18 | 25.86 | 25.87 | 82200.0 |
| 2002-11-15 09:00:00 | QQQ | ETF | 25.88 | 25.98 | 25.87 | 25.91 | 63400.0 |
| 2002-11-15 09:30:00 | QQQ | ETF | 25.9 | 26.29 | 25.81 | 26.12 | 14831800.0 |
| 2002-11-15 10:00:00 | QQQ | ETF | 26.13 | 26.17 | 25.77 | 25.83 | 10280700.0 |
| 2002-11-15 10:30:00 | QQQ | ETF | 25.81 | 25.95 | 25.75 | 25.86 | 5348100.0 |
| 2002-11-15 11:00:00 | QQQ | ETF | 25.86 | 25.92 | 25.75 | 25.87 | 2366500.0 |
| 2002-11-15 11:30:00 | QQQ | ETF | 25.86 | 25.97 | 25.77 | 25.87 | 2490300.0 |
| 2002-11-15 12:00:00 | QQQ | ETF | 25.86 | 25.96 | 25.8 | 25.93 | 1453700.0 |
| 2002-11-15 12:30:00 | QQQ | ETF | 25.93 | 25.99 | 25.88 | 25.9 | 1536800.0 |
| 2002-11-15 13:00:00 | QQQ | ETF | 25.9 | 26.11 | 25.85 | 26.09 | 2853100.0 |
| 2002-11-15 13:30:00 | QQQ | ETF | 26.09 | 26.16 | 26.0 | 26.08 | 2449900.0 |
| 2002-11-15 14:00:00 | QQQ | ETF | 26.09 | 26.32 | 26.03 | 26.29 | 4068600.0 |
| 2002-11-15 14:30:00 | QQQ | ETF | 26.29 | 26.43 | 26.23 | 26.28 | 4757700.0 |
| 2002-11-15 15:00:00 | QQQ | ETF | 26.31 | 26.37 | 26.21 | 26.35 | 3434300.0 |
| 2002-11-15 15:30:00 | QQQ | ETF | 26.36 | 26.45 | 26.26 | 26.38 | 6724900.0 |
| 2002-11-15 16:00:00 | QQQ | ETF | 26.39 | 26.47 | 26.32 | 26.44 | 3624300.0 |
| 2002-11-15 16:30:00 | QQQ | ETF | 26.45 | 26.47 | 26.38 | 26.4 | 155000.0 |
| 2002-11-15 17:00:00 | QQQ | ETF | 26.39 | 26.4 | 26.35 | 26.38 | 42000.0 |
| 2002-11-15 17:30:00 | QQQ | ETF | 26.39 | 26.43 | 26.36 | 26.4 | 38600.0 |
| 2002-11-15 18:00:00 | QQQ | ETF | 26.42 | 26.43 | 26.37 | 26.38 | 16300.0 |
| 2002-11-15 18:30:00 | QQQ | ETF | 26.4 | 26.41 | 26.4 | 26.41 | 800.0 |
| 2002-11-15 19:00:00 | QQQ | ETF | 26.42 | 26.42 | 26.42 | 26.42 | 600.0 |
| 2002-11-15 19:30:00 | QQQ | ETF | 26.42 | 26.43 | 26.42 | 26.43 | 600.0 |
| 2002-11-15 09:30:00 | IWM | ETF | 38.175 | 38.55 | 38.175 | 38.5 | 258000.0 |
| 2002-11-15 10:00:00 | IWM | ETF | 38.51 | 38.51 | 38.33 | 38.375 | 111000.0 |
| 2002-11-15 10:30:00 | IWM | ETF | 38.395 | 38.45 | 38.3 | 38.375 | 301600.0 |
| 2002-11-15 11:00:00 | IWM | ETF | 38.365 | 38.37 | 38.26 | 38.345 | 81400.0 |
| 2002-11-15 11:30:00 | IWM | ETF | 38.36 | 38.38 | 38.255 | 38.285 | 49600.0 |
> showing 50 of 621 rows — these rows as CSV