PREVIEW / etf_30min / 2002-12-19
file: by_date/etf_30min/2002/2002-12-19.parquet size: 22 KB rows: 640
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-12-19 08:00:00 | SPY | ETF | 89.45 | 89.52 | 89.25 | 89.25 | 5100.0 |
| 2002-12-19 08:30:00 | SPY | ETF | 89.28 | 89.28 | 88.99 | 89.1 | 38200.0 |
| 2002-12-19 09:00:00 | SPY | ETF | 89.08 | 89.3 | 89.08 | 89.3 | 6200.0 |
| 2002-12-19 09:30:00 | SPY | ETF | 89.35 | 90.28 | 89.35 | 90.27 | 4638400.0 |
| 2002-12-19 10:00:00 | SPY | ETF | 90.27 | 90.7 | 90.06 | 90.18 | 3253900.0 |
| 2002-12-19 10:30:00 | SPY | ETF | 90.2 | 90.33 | 89.5 | 89.53 | 3059500.0 |
| 2002-12-19 11:00:00 | SPY | ETF | 89.54 | 89.62 | 89.19 | 89.5 | 3563200.0 |
| 2002-12-19 11:30:00 | SPY | ETF | 89.5 | 89.91 | 89.46 | 89.85 | 2805700.0 |
| 2002-12-19 12:00:00 | SPY | ETF | 89.85 | 90.05 | 89.41 | 89.56 | 2288000.0 |
| 2002-12-19 12:30:00 | SPY | ETF | 89.53 | 89.62 | 89.19 | 89.44 | 1794000.0 |
| 2002-12-19 13:00:00 | SPY | ETF | 89.47 | 89.49 | 88.82 | 88.96 | 2409000.0 |
| 2002-12-19 13:30:00 | SPY | ETF | 88.95 | 89.11 | 88.85 | 89.0 | 1133900.0 |
| 2002-12-19 14:00:00 | SPY | ETF | 88.99 | 89.25 | 88.92 | 89.12 | 890600.0 |
| 2002-12-19 14:30:00 | SPY | ETF | 89.1 | 89.18 | 88.85 | 88.93 | 1867300.0 |
| 2002-12-19 15:00:00 | SPY | ETF | 88.91 | 89.13 | 88.6 | 88.69 | 2656900.0 |
| 2002-12-19 15:30:00 | SPY | ETF | 88.7 | 89.08 | 88.6 | 89.05 | 3083100.0 |
| 2002-12-19 16:00:00 | SPY | ETF | 89.05 | 89.25 | 88.69 | 89.21 | 1585500.0 |
| 2002-12-19 16:30:00 | SPY | ETF | 89.25 | 89.25 | 89.11 | 89.23 | 22200.0 |
| 2002-12-19 17:00:00 | SPY | ETF | 89.18 | 89.22 | 89.15 | 89.16 | 6900.0 |
| 2002-12-19 17:30:00 | SPY | ETF | 89.18 | 89.26 | 89.18 | 89.25 | 20700.0 |
| 2002-12-19 18:00:00 | SPY | ETF | 89.35 | 89.4 | 89.31 | 89.33 | 1200.0 |
| 2002-12-19 18:30:00 | SPY | ETF | 89.35 | 89.35 | 89.35 | 89.35 | 100.0 |
| 2002-12-19 19:00:00 | SPY | ETF | 89.32 | 89.35 | 89.32 | 89.35 | 1000.0 |
| 2002-12-19 19:30:00 | SPY | ETF | 89.32 | 89.32 | 89.22 | 89.22 | 4500.0 |
| 2002-12-19 08:00:00 | QQQ | ETF | 25.31 | 25.31 | 25.17 | 25.2 | 19600.0 |
| 2002-12-19 08:30:00 | QQQ | ETF | 25.2 | 25.22 | 25.03 | 25.07 | 46100.0 |
| 2002-12-19 09:00:00 | QQQ | ETF | 25.07 | 25.16 | 25.07 | 25.15 | 31800.0 |
| 2002-12-19 09:30:00 | QQQ | ETF | 25.17 | 25.77 | 25.14 | 25.63 | 9692200.0 |
| 2002-12-19 10:00:00 | QQQ | ETF | 25.64 | 25.78 | 25.43 | 25.45 | 6824200.0 |
| 2002-12-19 10:30:00 | QQQ | ETF | 25.45 | 25.54 | 24.96 | 24.96 | 12248500.0 |
| 2002-12-19 11:00:00 | QQQ | ETF | 24.96 | 25.12 | 24.87 | 25.1 | 9568500.0 |
| 2002-12-19 11:30:00 | QQQ | ETF | 25.1 | 25.29 | 25.07 | 25.2 | 6084500.0 |
| 2002-12-19 12:00:00 | QQQ | ETF | 25.2 | 25.31 | 25.05 | 25.1 | 4613100.0 |
| 2002-12-19 12:30:00 | QQQ | ETF | 25.11 | 25.17 | 24.96 | 25.14 | 4745800.0 |
| 2002-12-19 13:00:00 | QQQ | ETF | 25.15 | 25.18 | 24.9 | 25.0 | 6092600.0 |
| 2002-12-19 13:30:00 | QQQ | ETF | 25.0 | 25.08 | 24.96 | 25.02 | 3278100.0 |
| 2002-12-19 14:00:00 | QQQ | ETF | 25.02 | 25.16 | 24.99 | 25.1 | 3485100.0 |
| 2002-12-19 14:30:00 | QQQ | ETF | 25.08 | 25.14 | 24.93 | 25.0 | 4641600.0 |
| 2002-12-19 15:00:00 | QQQ | ETF | 25.0 | 25.11 | 24.81 | 24.96 | 6488200.0 |
| 2002-12-19 15:30:00 | QQQ | ETF | 24.95 | 25.08 | 24.93 | 25.03 | 5876500.0 |
| 2002-12-19 16:00:00 | QQQ | ETF | 25.04 | 25.12 | 24.97 | 25.1 | 1802600.0 |
| 2002-12-19 16:30:00 | QQQ | ETF | 25.1 | 25.12 | 25.06 | 25.1 | 112500.0 |
| 2002-12-19 17:00:00 | QQQ | ETF | 25.1 | 25.13 | 25.07 | 25.12 | 103400.0 |
| 2002-12-19 17:30:00 | QQQ | ETF | 25.14 | 25.2 | 25.09 | 25.18 | 183700.0 |
| 2002-12-19 18:00:00 | QQQ | ETF | 25.2 | 25.2 | 25.15 | 25.16 | 23400.0 |
| 2002-12-19 18:30:00 | QQQ | ETF | 25.19 | 25.19 | 25.17 | 25.17 | 2800.0 |
| 2002-12-19 19:00:00 | QQQ | ETF | 25.19 | 25.19 | 25.19 | 25.19 | 1000.0 |
| 2002-12-19 19:30:00 | QQQ | ETF | 25.2 | 25.23 | 25.16 | 25.2 | 6500.0 |
| 2002-12-19 09:30:00 | IWM | ETF | 38.125 | 38.59 | 38.125 | 38.525 | 577400.0 |
| 2002-12-19 10:00:00 | IWM | ETF | 38.52 | 38.65 | 38.39 | 38.39 | 238600.0 |
> showing 50 of 640 rows — these rows as CSV