PREVIEW / etf_30min / 2002-11-08
file: by_date/etf_30min/2002/2002-11-08.parquet size: 21 KB rows: 620
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-08 08:00:00 | SPY | ETF | 91.02 | 91.04 | 91.02 | 91.04 | 400.0 |
| 2002-11-08 08:30:00 | SPY | ETF | 90.83 | 90.83 | 90.72 | 90.72 | 300.0 |
| 2002-11-08 09:00:00 | SPY | ETF | 90.65 | 90.65 | 90.52 | 90.52 | 3800.0 |
| 2002-11-08 09:30:00 | SPY | ETF | 90.53 | 91.11 | 90.4 | 91.07 | 3836300.0 |
| 2002-11-08 10:00:00 | SPY | ETF | 91.09 | 91.57 | 90.83 | 90.9 | 4044700.0 |
| 2002-11-08 10:30:00 | SPY | ETF | 90.93 | 90.98 | 90.51 | 90.62 | 2621500.0 |
| 2002-11-08 11:00:00 | SPY | ETF | 90.62 | 90.62 | 89.65 | 89.89 | 5401800.0 |
| 2002-11-08 11:30:00 | SPY | ETF | 89.85 | 90.09 | 89.52 | 89.91 | 3118200.0 |
| 2002-11-08 12:00:00 | SPY | ETF | 89.91 | 90.19 | 89.77 | 89.84 | 1315600.0 |
| 2002-11-08 12:30:00 | SPY | ETF | 89.86 | 89.99 | 89.69 | 89.99 | 1077200.0 |
| 2002-11-08 13:00:00 | SPY | ETF | 89.99 | 90.16 | 89.9 | 90.15 | 1118600.0 |
| 2002-11-08 13:30:00 | SPY | ETF | 90.14 | 90.2 | 89.62 | 89.7 | 1367800.0 |
| 2002-11-08 14:00:00 | SPY | ETF | 89.65 | 90.05 | 89.55 | 90.05 | 1872800.0 |
| 2002-11-08 14:30:00 | SPY | ETF | 90.04 | 90.06 | 89.65 | 89.78 | 943300.0 |
| 2002-11-08 15:00:00 | SPY | ETF | 89.77 | 90.16 | 89.58 | 90.16 | 2267800.0 |
| 2002-11-08 15:30:00 | SPY | ETF | 90.13 | 90.2 | 89.81 | 89.87 | 3644600.0 |
| 2002-11-08 16:00:00 | SPY | ETF | 89.87 | 89.93 | 89.5 | 89.77 | 1584100.0 |
| 2002-11-08 16:30:00 | SPY | ETF | 89.77 | 89.89 | 89.55 | 89.55 | 227500.0 |
| 2002-11-08 17:00:00 | SPY | ETF | 89.52 | 89.52 | 89.52 | 89.52 | 100.0 |
| 2002-11-08 17:30:00 | SPY | ETF | 89.52 | 89.52 | 89.46 | 89.46 | 2100.0 |
| 2002-11-08 18:00:00 | SPY | ETF | 89.54 | 89.54 | 89.54 | 89.54 | 100.0 |
| 2002-11-08 19:00:00 | SPY | ETF | 89.55 | 89.55 | 89.55 | 89.55 | 100.0 |
| 2002-11-08 19:30:00 | SPY | ETF | 89.55 | 89.55 | 89.55 | 89.55 | 700.0 |
| 2002-11-08 08:00:00 | QQQ | ETF | 25.54 | 25.56 | 25.54 | 25.56 | 1600.0 |
| 2002-11-08 08:30:00 | QQQ | ETF | 25.55 | 25.55 | 25.53 | 25.53 | 1500.0 |
| 2002-11-08 09:00:00 | QQQ | ETF | 25.45 | 25.49 | 25.44 | 25.48 | 18400.0 |
| 2002-11-08 09:30:00 | QQQ | ETF | 25.49 | 25.71 | 25.46 | 25.7 | 10453500.0 |
| 2002-11-08 10:00:00 | QQQ | ETF | 25.7 | 25.87 | 25.53 | 25.55 | 8674100.0 |
| 2002-11-08 10:30:00 | QQQ | ETF | 25.54 | 25.63 | 25.39 | 25.41 | 4964800.0 |
| 2002-11-08 11:00:00 | QQQ | ETF | 25.41 | 25.43 | 25.05 | 25.09 | 8520100.0 |
| 2002-11-08 11:30:00 | QQQ | ETF | 25.08 | 25.25 | 24.96 | 25.06 | 9726500.0 |
| 2002-11-08 12:00:00 | QQQ | ETF | 25.07 | 25.21 | 25.06 | 25.11 | 2539400.0 |
| 2002-11-08 12:30:00 | QQQ | ETF | 25.12 | 25.14 | 25.0 | 25.13 | 1802800.0 |
| 2002-11-08 13:00:00 | QQQ | ETF | 25.13 | 25.24 | 25.09 | 25.22 | 4411400.0 |
| 2002-11-08 13:30:00 | QQQ | ETF | 25.23 | 25.28 | 25.05 | 25.07 | 3722600.0 |
| 2002-11-08 14:00:00 | QQQ | ETF | 25.05 | 25.25 | 25.01 | 25.22 | 2213000.0 |
| 2002-11-08 14:30:00 | QQQ | ETF | 25.18 | 25.22 | 25.04 | 25.12 | 2387500.0 |
| 2002-11-08 15:00:00 | QQQ | ETF | 25.1 | 25.31 | 25.03 | 25.28 | 2589100.0 |
| 2002-11-08 15:30:00 | QQQ | ETF | 25.3 | 25.31 | 25.06 | 25.11 | 5611200.0 |
| 2002-11-08 16:00:00 | QQQ | ETF | 25.07 | 25.16 | 25.01 | 25.05 | 1662800.0 |
| 2002-11-08 16:30:00 | QQQ | ETF | 25.06 | 25.1 | 25.05 | 25.06 | 54700.0 |
| 2002-11-08 17:00:00 | QQQ | ETF | 25.06 | 25.06 | 25.05 | 25.06 | 29300.0 |
| 2002-11-08 17:30:00 | QQQ | ETF | 25.07 | 25.07 | 24.99 | 24.99 | 74900.0 |
| 2002-11-08 18:00:00 | QQQ | ETF | 24.98 | 25.03 | 24.97 | 25.0 | 14000.0 |
| 2002-11-08 18:30:00 | QQQ | ETF | 25.02 | 25.02 | 25.01 | 25.01 | 500.0 |
| 2002-11-08 19:00:00 | QQQ | ETF | 25.03 | 25.04 | 25.03 | 25.03 | 1400.0 |
| 2002-11-08 19:30:00 | QQQ | ETF | 25.03 | 25.04 | 25.0 | 25.0 | 4500.0 |
| 2002-11-08 09:30:00 | IWM | ETF | 38.325 | 38.415 | 38.115 | 38.275 | 42200.0 |
| 2002-11-08 10:00:00 | IWM | ETF | 38.43 | 38.495 | 38.215 | 38.215 | 193000.0 |
| 2002-11-08 10:30:00 | IWM | ETF | 38.25 | 38.25 | 38.0 | 38.015 | 208400.0 |
> showing 50 of 620 rows — these rows as CSV