PREVIEW / etf_30min / 2003-05-22
file: by_date/etf_30min/2003/2003-05-22.parquet size: 22 KB rows: 662
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-05-22 08:00:00 | SPY | ETF | 92.9 | 92.98 | 92.9 | 92.94 | 22600.0 |
| 2003-05-22 08:30:00 | SPY | ETF | 92.87 | 93.0 | 92.87 | 92.99 | 47000.0 |
| 2003-05-22 09:00:00 | SPY | ETF | 93.0 | 93.01 | 92.95 | 92.95 | 17900.0 |
| 2003-05-22 09:30:00 | SPY | ETF | 92.95 | 93.12 | 92.68 | 93.03 | 4722900.0 |
| 2003-05-22 10:00:00 | SPY | ETF | 93.04 | 93.45 | 92.93 | 93.43 | 4538400.0 |
| 2003-05-22 10:30:00 | SPY | ETF | 93.43 | 93.79 | 93.35 | 93.51 | 5256100.0 |
| 2003-05-22 11:00:00 | SPY | ETF | 93.49 | 93.64 | 93.26 | 93.45 | 2894000.0 |
| 2003-05-22 11:30:00 | SPY | ETF | 93.43 | 93.6 | 93.23 | 93.4 | 1289800.0 |
| 2003-05-22 12:00:00 | SPY | ETF | 93.39 | 93.67 | 93.31 | 93.67 | 1109200.0 |
| 2003-05-22 12:30:00 | SPY | ETF | 93.66 | 93.75 | 93.55 | 93.57 | 1263900.0 |
| 2003-05-22 13:00:00 | SPY | ETF | 93.57 | 93.61 | 93.44 | 93.59 | 1588800.0 |
| 2003-05-22 13:30:00 | SPY | ETF | 93.6 | 93.74 | 93.56 | 93.68 | 1290000.0 |
| 2003-05-22 14:00:00 | SPY | ETF | 93.68 | 93.77 | 93.38 | 93.4 | 1367100.0 |
| 2003-05-22 14:30:00 | SPY | ETF | 93.38 | 93.77 | 93.36 | 93.7 | 1267300.0 |
| 2003-05-22 15:00:00 | SPY | ETF | 93.7 | 94.0 | 93.66 | 93.96 | 2107800.0 |
| 2003-05-22 15:30:00 | SPY | ETF | 93.97 | 94.04 | 93.58 | 93.68 | 2552800.0 |
| 2003-05-22 16:00:00 | SPY | ETF | 93.68 | 93.72 | 93.5 | 93.57 | 1312300.0 |
| 2003-05-22 16:30:00 | SPY | ETF | 93.57 | 93.6 | 93.5 | 93.55 | 5100.0 |
| 2003-05-22 17:00:00 | SPY | ETF | 93.58 | 93.58 | 93.55 | 93.57 | 3000.0 |
| 2003-05-22 17:30:00 | SPY | ETF | 93.57 | 93.59 | 93.57 | 93.58 | 22000.0 |
| 2003-05-22 18:00:00 | SPY | ETF | 93.59 | 93.59 | 93.54 | 93.56 | 8200.0 |
| 2003-05-22 18:30:00 | SPY | ETF | 93.59 | 93.6 | 93.58 | 93.6 | 1100.0 |
| 2003-05-22 19:00:00 | SPY | ETF | 93.64 | 93.64 | 93.6 | 93.64 | 4200.0 |
| 2003-05-22 19:30:00 | SPY | ETF | 93.63 | 93.65 | 93.62 | 93.62 | 1300.0 |
| 2003-05-22 08:00:00 | QQQ | ETF | 27.73 | 27.75 | 27.72 | 27.75 | 11400.0 |
| 2003-05-22 08:30:00 | QQQ | ETF | 27.75 | 27.78 | 27.73 | 27.77 | 58900.0 |
| 2003-05-22 09:00:00 | QQQ | ETF | 27.77 | 27.77 | 27.74 | 27.76 | 26200.0 |
| 2003-05-22 09:30:00 | QQQ | ETF | 27.76 | 27.88 | 27.62 | 27.82 | 6652200.0 |
| 2003-05-22 10:00:00 | QQQ | ETF | 27.83 | 28.0 | 27.77 | 27.99 | 8289100.0 |
| 2003-05-22 10:30:00 | QQQ | ETF | 27.98 | 28.18 | 27.95 | 28.1 | 8314700.0 |
| 2003-05-22 11:00:00 | QQQ | ETF | 28.1 | 28.14 | 28.02 | 28.1 | 3698000.0 |
| 2003-05-22 11:30:00 | QQQ | ETF | 28.1 | 28.17 | 28.02 | 28.1 | 5049200.0 |
| 2003-05-22 12:00:00 | QQQ | ETF | 28.08 | 28.17 | 28.06 | 28.15 | 1927500.0 |
| 2003-05-22 12:30:00 | QQQ | ETF | 28.16 | 28.24 | 28.13 | 28.18 | 3036800.0 |
| 2003-05-22 13:00:00 | QQQ | ETF | 28.19 | 28.19 | 28.12 | 28.14 | 1090300.0 |
| 2003-05-22 13:30:00 | QQQ | ETF | 28.15 | 28.21 | 28.12 | 28.15 | 1374100.0 |
| 2003-05-22 14:00:00 | QQQ | ETF | 28.17 | 28.2 | 28.07 | 28.08 | 1652200.0 |
| 2003-05-22 14:30:00 | QQQ | ETF | 28.08 | 28.2 | 28.06 | 28.17 | 2405200.0 |
| 2003-05-22 15:00:00 | QQQ | ETF | 28.18 | 28.29 | 28.16 | 28.28 | 3884900.0 |
| 2003-05-22 15:30:00 | QQQ | ETF | 28.28 | 28.32 | 28.07 | 28.13 | 4536200.0 |
| 2003-05-22 16:00:00 | QQQ | ETF | 28.11 | 28.15 | 28.02 | 28.12 | 1681300.0 |
| 2003-05-22 16:30:00 | QQQ | ETF | 28.12 | 28.12 | 28.07 | 28.09 | 108500.0 |
| 2003-05-22 17:00:00 | QQQ | ETF | 28.09 | 28.12 | 28.09 | 28.11 | 75600.0 |
| 2003-05-22 17:30:00 | QQQ | ETF | 28.12 | 28.13 | 28.11 | 28.11 | 25300.0 |
| 2003-05-22 18:00:00 | QQQ | ETF | 28.11 | 28.12 | 28.08 | 28.11 | 38500.0 |
| 2003-05-22 18:30:00 | QQQ | ETF | 28.1 | 28.12 | 28.1 | 28.12 | 1600.0 |
| 2003-05-22 19:00:00 | QQQ | ETF | 28.12 | 28.14 | 28.11 | 28.13 | 9200.0 |
| 2003-05-22 19:30:00 | QQQ | ETF | 28.14 | 28.14 | 28.14 | 28.14 | 1500.0 |
| 2003-05-22 09:30:00 | IWM | ETF | 40.975 | 41.045 | 40.925 | 41.04 | 651600.0 |
| 2003-05-22 10:00:00 | IWM | ETF | 41.01 | 41.19 | 41.0 | 41.19 | 499200.0 |
> showing 50 of 662 rows — these rows as CSV