PREVIEW / etf_30min / 2002-11-14
file: by_date/etf_30min/2002/2002-11-14.parquet size: 22 KB rows: 629
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-14 08:00:00 | SPY | ETF | 89.4 | 89.4 | 89.16 | 89.28 | 4000.0 |
| 2002-11-14 08:30:00 | SPY | ETF | 89.39 | 90.2 | 89.39 | 90.2 | 10900.0 |
| 2002-11-14 09:00:00 | SPY | ETF | 90.23 | 90.3 | 90.1 | 90.1 | 8900.0 |
| 2002-11-14 09:30:00 | SPY | ETF | 90.07 | 90.23 | 89.77 | 89.92 | 4455800.0 |
| 2002-11-14 10:00:00 | SPY | ETF | 89.93 | 90.5 | 89.89 | 90.15 | 3351500.0 |
| 2002-11-14 10:30:00 | SPY | ETF | 90.18 | 90.44 | 90.06 | 90.17 | 1566100.0 |
| 2002-11-14 11:00:00 | SPY | ETF | 90.2 | 90.25 | 89.81 | 90.18 | 2441900.0 |
| 2002-11-14 11:30:00 | SPY | ETF | 90.22 | 90.38 | 90.02 | 90.21 | 1403600.0 |
| 2002-11-14 12:00:00 | SPY | ETF | 90.22 | 90.35 | 89.95 | 90.32 | 571000.0 |
| 2002-11-14 12:30:00 | SPY | ETF | 90.34 | 90.73 | 90.26 | 90.55 | 2065000.0 |
| 2002-11-14 13:00:00 | SPY | ETF | 90.56 | 90.8 | 90.54 | 90.72 | 1443000.0 |
| 2002-11-14 13:30:00 | SPY | ETF | 90.7 | 90.85 | 90.41 | 90.48 | 1896300.0 |
| 2002-11-14 14:00:00 | SPY | ETF | 90.47 | 90.65 | 90.35 | 90.65 | 1956700.0 |
| 2002-11-14 14:30:00 | SPY | ETF | 90.63 | 91.0 | 90.52 | 90.89 | 1580700.0 |
| 2002-11-14 15:00:00 | SPY | ETF | 90.93 | 90.94 | 90.41 | 90.65 | 2304700.0 |
| 2002-11-14 15:30:00 | SPY | ETF | 90.65 | 90.91 | 90.63 | 90.87 | 2472700.0 |
| 2002-11-14 16:00:00 | SPY | ETF | 90.9 | 91.03 | 90.59 | 90.73 | 2678200.0 |
| 2002-11-14 16:30:00 | SPY | ETF | 90.73 | 90.73 | 90.62 | 90.62 | 58500.0 |
| 2002-11-14 17:00:00 | SPY | ETF | 90.67 | 90.8 | 90.67 | 90.78 | 51900.0 |
| 2002-11-14 17:30:00 | SPY | ETF | 90.78 | 90.85 | 90.66 | 90.66 | 25800.0 |
| 2002-11-14 18:00:00 | SPY | ETF | 90.73 | 90.92 | 90.7 | 90.92 | 50700.0 |
| 2002-11-14 18:30:00 | SPY | ETF | 90.96 | 90.98 | 90.96 | 90.98 | 300.0 |
| 2002-11-14 08:00:00 | QQQ | ETF | 25.25 | 25.25 | 25.17 | 25.22 | 10800.0 |
| 2002-11-14 08:30:00 | QQQ | ETF | 25.28 | 25.68 | 25.24 | 25.68 | 46300.0 |
| 2002-11-14 09:00:00 | QQQ | ETF | 25.67 | 25.71 | 25.59 | 25.59 | 32100.0 |
| 2002-11-14 09:30:00 | QQQ | ETF | 25.58 | 25.77 | 25.52 | 25.57 | 13316700.0 |
| 2002-11-14 10:00:00 | QQQ | ETF | 25.59 | 25.78 | 25.57 | 25.7 | 6860400.0 |
| 2002-11-14 10:30:00 | QQQ | ETF | 25.68 | 25.85 | 25.66 | 25.74 | 6415900.0 |
| 2002-11-14 11:00:00 | QQQ | ETF | 25.74 | 25.85 | 25.62 | 25.8 | 4939000.0 |
| 2002-11-14 11:30:00 | QQQ | ETF | 25.82 | 25.92 | 25.74 | 25.85 | 3928000.0 |
| 2002-11-14 12:00:00 | QQQ | ETF | 25.85 | 25.89 | 25.77 | 25.87 | 2503400.0 |
| 2002-11-14 12:30:00 | QQQ | ETF | 25.87 | 26.05 | 25.85 | 25.98 | 5661300.0 |
| 2002-11-14 13:00:00 | QQQ | ETF | 25.98 | 26.11 | 25.96 | 26.07 | 5108500.0 |
| 2002-11-14 13:30:00 | QQQ | ETF | 26.07 | 26.14 | 25.92 | 25.95 | 4518400.0 |
| 2002-11-14 14:00:00 | QQQ | ETF | 25.95 | 26.11 | 25.89 | 26.06 | 4280900.0 |
| 2002-11-14 14:30:00 | QQQ | ETF | 26.07 | 26.2 | 26.04 | 26.19 | 3434000.0 |
| 2002-11-14 15:00:00 | QQQ | ETF | 26.19 | 26.22 | 26.0 | 26.13 | 4846500.0 |
| 2002-11-14 15:30:00 | QQQ | ETF | 26.13 | 26.32 | 26.11 | 26.29 | 7767300.0 |
| 2002-11-14 16:00:00 | QQQ | ETF | 26.28 | 26.46 | 26.03 | 26.1 | 7485200.0 |
| 2002-11-14 16:30:00 | QQQ | ETF | 26.09 | 26.18 | 25.95 | 26.0 | 1180600.0 |
| 2002-11-14 17:00:00 | QQQ | ETF | 25.99 | 26.08 | 25.99 | 26.08 | 766100.0 |
| 2002-11-14 17:30:00 | QQQ | ETF | 26.09 | 26.13 | 26.06 | 26.13 | 507400.0 |
| 2002-11-14 18:00:00 | QQQ | ETF | 26.13 | 26.2 | 26.11 | 26.18 | 467400.0 |
| 2002-11-14 19:00:00 | QQQ | ETF | 26.17 | 26.17 | 26.15 | 26.17 | 2700.0 |
| 2002-11-14 19:30:00 | QQQ | ETF | 26.15 | 26.2 | 26.15 | 26.2 | 4600.0 |
| 2002-11-14 09:30:00 | IWM | ETF | 37.9 | 38.025 | 37.855 | 37.92 | 198800.0 |
| 2002-11-14 10:00:00 | IWM | ETF | 37.925 | 38.125 | 37.925 | 38.015 | 303400.0 |
| 2002-11-14 10:30:00 | IWM | ETF | 38.1 | 38.15 | 38.01 | 38.06 | 33400.0 |
| 2002-11-14 11:00:00 | IWM | ETF | 38.05 | 38.18 | 38.0 | 38.18 | 146800.0 |
| 2002-11-14 11:30:00 | IWM | ETF | 38.15 | 38.245 | 38.15 | 38.225 | 138200.0 |
> showing 50 of 629 rows — these rows as CSV