PREVIEW / etf_30min / 2003-03-21
file: by_date/etf_30min/2003/2003-03-21.parquet size: 23 KB rows: 702
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 |
|---|---|---|---|---|---|---|---|
| 2003-03-21 08:00:00 | SPY | ETF | 88.7 | 88.75 | 88.55 | 88.65 | 47100.0 |
| 2003-03-21 08:30:00 | SPY | ETF | 88.67 | 88.76 | 88.5 | 88.76 | 60600.0 |
| 2003-03-21 09:00:00 | SPY | ETF | 88.76 | 88.85 | 88.58 | 88.82 | 112600.0 |
| 2003-03-21 09:30:00 | SPY | ETF | 88.8 | 88.8 | 88.21 | 88.25 | 7416100.0 |
| 2003-03-21 10:00:00 | SPY | ETF | 88.27 | 88.58 | 88.13 | 88.22 | 3917800.0 |
| 2003-03-21 10:30:00 | SPY | ETF | 88.16 | 88.68 | 88.16 | 88.35 | 2492400.0 |
| 2003-03-21 11:00:00 | SPY | ETF | 88.35 | 88.39 | 87.93 | 88.28 | 2806600.0 |
| 2003-03-21 11:30:00 | SPY | ETF | 88.31 | 89.04 | 88.2 | 88.63 | 6536100.0 |
| 2003-03-21 12:00:00 | SPY | ETF | 88.64 | 89.0 | 88.5 | 88.93 | 3062100.0 |
| 2003-03-21 12:30:00 | SPY | ETF | 88.94 | 89.64 | 88.9 | 89.45 | 5999300.0 |
| 2003-03-21 13:00:00 | SPY | ETF | 89.44 | 89.54 | 88.98 | 89.35 | 4931200.0 |
| 2003-03-21 13:30:00 | SPY | ETF | 89.29 | 89.34 | 88.87 | 89.0 | 6855600.0 |
| 2003-03-21 14:00:00 | SPY | ETF | 89.0 | 89.2 | 88.7 | 88.9 | 2628000.0 |
| 2003-03-21 14:30:00 | SPY | ETF | 88.9 | 89.38 | 88.9 | 89.16 | 3494800.0 |
| 2003-03-21 15:00:00 | SPY | ETF | 89.18 | 89.6 | 89.16 | 89.57 | 4500300.0 |
| 2003-03-21 15:30:00 | SPY | ETF | 89.6 | 89.88 | 89.45 | 89.74 | 6694100.0 |
| 2003-03-21 16:00:00 | SPY | ETF | 89.77 | 89.86 | 89.62 | 89.83 | 2670900.0 |
| 2003-03-21 16:30:00 | SPY | ETF | 89.67 | 89.86 | 89.39 | 89.82 | 1615100.0 |
| 2003-03-21 17:00:00 | SPY | ETF | 89.8 | 89.85 | 89.78 | 89.84 | 55800.0 |
| 2003-03-21 17:30:00 | SPY | ETF | 89.84 | 89.92 | 89.78 | 89.92 | 33400.0 |
| 2003-03-21 18:00:00 | SPY | ETF | 89.92 | 89.95 | 89.85 | 89.9 | 45200.0 |
| 2003-03-21 18:30:00 | SPY | ETF | 89.85 | 89.87 | 89.85 | 89.86 | 5300.0 |
| 2003-03-21 19:00:00 | SPY | ETF | 89.85 | 89.87 | 89.85 | 89.87 | 1000.0 |
| 2003-03-21 19:30:00 | SPY | ETF | 89.88 | 89.95 | 89.85 | 89.85 | 1200.0 |
| 2003-03-21 08:00:00 | QQQ | ETF | 27.11 | 27.15 | 27.08 | 27.09 | 61900.0 |
| 2003-03-21 08:30:00 | QQQ | ETF | 27.07 | 27.15 | 27.05 | 27.15 | 43600.0 |
| 2003-03-21 09:00:00 | QQQ | ETF | 27.15 | 27.21 | 27.08 | 27.21 | 109400.0 |
| 2003-03-21 09:30:00 | QQQ | ETF | 27.21 | 27.24 | 26.95 | 26.98 | 15301100.0 |
| 2003-03-21 10:00:00 | QQQ | ETF | 26.99 | 27.09 | 26.94 | 26.98 | 5222300.0 |
| 2003-03-21 10:30:00 | QQQ | ETF | 26.97 | 27.09 | 26.95 | 27.0 | 4397300.0 |
| 2003-03-21 11:00:00 | QQQ | ETF | 26.99 | 27.04 | 26.77 | 26.92 | 4746300.0 |
| 2003-03-21 11:30:00 | QQQ | ETF | 26.9 | 27.2 | 26.87 | 27.01 | 7071000.0 |
| 2003-03-21 12:00:00 | QQQ | ETF | 27.04 | 27.17 | 26.95 | 27.13 | 4830800.0 |
| 2003-03-21 12:30:00 | QQQ | ETF | 27.11 | 27.38 | 27.09 | 27.3 | 9019900.0 |
| 2003-03-21 13:00:00 | QQQ | ETF | 27.3 | 27.31 | 27.08 | 27.21 | 6155500.0 |
| 2003-03-21 13:30:00 | QQQ | ETF | 27.19 | 27.23 | 26.98 | 27.05 | 5197600.0 |
| 2003-03-21 14:00:00 | QQQ | ETF | 27.05 | 27.13 | 26.91 | 26.98 | 4664000.0 |
| 2003-03-21 14:30:00 | QQQ | ETF | 26.98 | 27.16 | 26.97 | 27.12 | 4797500.0 |
| 2003-03-21 15:00:00 | QQQ | ETF | 27.1 | 27.17 | 27.06 | 27.15 | 4732400.0 |
| 2003-03-21 15:30:00 | QQQ | ETF | 27.15 | 27.22 | 27.1 | 27.16 | 8029500.0 |
| 2003-03-21 16:00:00 | QQQ | ETF | 27.16 | 27.18 | 27.1 | 27.15 | 3225400.0 |
| 2003-03-21 16:30:00 | QQQ | ETF | 27.15 | 27.2 | 27.13 | 27.18 | 268500.0 |
| 2003-03-21 17:00:00 | QQQ | ETF | 27.18 | 27.28 | 27.15 | 27.27 | 131000.0 |
| 2003-03-21 17:30:00 | QQQ | ETF | 27.27 | 27.27 | 27.15 | 27.21 | 47600.0 |
| 2003-03-21 18:00:00 | QQQ | ETF | 27.21 | 27.24 | 27.2 | 27.23 | 52200.0 |
| 2003-03-21 18:30:00 | QQQ | ETF | 27.24 | 27.24 | 27.2 | 27.22 | 12000.0 |
| 2003-03-21 19:00:00 | QQQ | ETF | 27.21 | 27.24 | 27.21 | 27.22 | 6800.0 |
| 2003-03-21 19:30:00 | QQQ | ETF | 27.23 | 27.26 | 27.23 | 27.24 | 5500.0 |
| 2003-03-21 09:30:00 | IWM | ETF | 37.165 | 37.215 | 36.95 | 37.0 | 240600.0 |
| 2003-03-21 10:00:00 | IWM | ETF | 36.965 | 37.095 | 36.965 | 37.02 | 623400.0 |
> showing 50 of 702 rows — these rows as CSV