PREVIEW / etf_30min / 2003-05-07
file: by_date/etf_30min/2003/2003-05-07.parquet size: 22 KB rows: 671
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-07 08:00:00 | SPY | ETF | 93.97 | 93.98 | 93.65 | 93.66 | 21500.0 |
| 2003-05-07 08:30:00 | SPY | ETF | 93.55 | 93.64 | 93.52 | 93.6 | 28500.0 |
| 2003-05-07 09:00:00 | SPY | ETF | 93.6 | 93.6 | 93.33 | 93.45 | 33600.0 |
| 2003-05-07 09:30:00 | SPY | ETF | 93.42 | 93.56 | 93.07 | 93.24 | 6324900.0 |
| 2003-05-07 10:00:00 | SPY | ETF | 93.23 | 93.38 | 92.97 | 93.19 | 3378500.0 |
| 2003-05-07 10:30:00 | SPY | ETF | 93.18 | 93.79 | 93.02 | 93.64 | 3049300.0 |
| 2003-05-07 11:00:00 | SPY | ETF | 93.64 | 93.85 | 93.49 | 93.58 | 3087400.0 |
| 2003-05-07 11:30:00 | SPY | ETF | 93.59 | 94.14 | 93.51 | 94.0 | 2578700.0 |
| 2003-05-07 12:00:00 | SPY | ETF | 94.0 | 94.03 | 93.69 | 93.77 | 1412600.0 |
| 2003-05-07 12:30:00 | SPY | ETF | 93.76 | 94.03 | 93.62 | 93.79 | 1155000.0 |
| 2003-05-07 13:00:00 | SPY | ETF | 93.82 | 93.83 | 93.26 | 93.31 | 1542700.0 |
| 2003-05-07 13:30:00 | SPY | ETF | 93.32 | 93.6 | 93.2 | 93.22 | 1394600.0 |
| 2003-05-07 14:00:00 | SPY | ETF | 93.22 | 93.44 | 93.13 | 93.2 | 1600700.0 |
| 2003-05-07 14:30:00 | SPY | ETF | 93.2 | 93.41 | 93.12 | 93.24 | 1348600.0 |
| 2003-05-07 15:00:00 | SPY | ETF | 93.28 | 93.38 | 93.04 | 93.33 | 1953800.0 |
| 2003-05-07 15:30:00 | SPY | ETF | 93.33 | 93.54 | 93.17 | 93.31 | 2463800.0 |
| 2003-05-07 16:00:00 | SPY | ETF | 93.32 | 93.46 | 93.26 | 93.3 | 1832700.0 |
| 2003-05-07 16:30:00 | SPY | ETF | 93.33 | 93.35 | 93.24 | 93.33 | 132500.0 |
| 2003-05-07 17:00:00 | SPY | ETF | 93.33 | 93.33 | 93.26 | 93.26 | 1100.0 |
| 2003-05-07 17:30:00 | SPY | ETF | 93.28 | 93.28 | 93.24 | 93.25 | 10000.0 |
| 2003-05-07 18:00:00 | SPY | ETF | 93.21 | 93.21 | 93.15 | 93.15 | 15400.0 |
| 2003-05-07 18:30:00 | SPY | ETF | 93.15 | 93.15 | 93.15 | 93.15 | 100.0 |
| 2003-05-07 19:00:00 | SPY | ETF | 93.24 | 93.24 | 93.24 | 93.24 | 500.0 |
| 2003-05-07 19:30:00 | SPY | ETF | 93.21 | 93.21 | 93.21 | 93.21 | 400.0 |
| 2003-05-07 08:00:00 | QQQ | ETF | 28.7 | 28.7 | 28.54 | 28.54 | 24400.0 |
| 2003-05-07 08:30:00 | QQQ | ETF | 28.51 | 28.54 | 28.45 | 28.5 | 74100.0 |
| 2003-05-07 09:00:00 | QQQ | ETF | 28.49 | 28.5 | 28.4 | 28.43 | 116000.0 |
| 2003-05-07 09:30:00 | QQQ | ETF | 28.41 | 28.49 | 28.29 | 28.34 | 11540700.0 |
| 2003-05-07 10:00:00 | QQQ | ETF | 28.36 | 28.4 | 28.24 | 28.3 | 5437700.0 |
| 2003-05-07 10:30:00 | QQQ | ETF | 28.31 | 28.53 | 28.22 | 28.48 | 5576900.0 |
| 2003-05-07 11:00:00 | QQQ | ETF | 28.48 | 28.57 | 28.4 | 28.45 | 3273300.0 |
| 2003-05-07 11:30:00 | QQQ | ETF | 28.45 | 28.69 | 28.41 | 28.61 | 5779200.0 |
| 2003-05-07 12:00:00 | QQQ | ETF | 28.61 | 28.61 | 28.45 | 28.51 | 2827200.0 |
| 2003-05-07 12:30:00 | QQQ | ETF | 28.51 | 28.57 | 28.43 | 28.48 | 1689700.0 |
| 2003-05-07 13:00:00 | QQQ | ETF | 28.5 | 28.5 | 28.29 | 28.34 | 3286200.0 |
| 2003-05-07 13:30:00 | QQQ | ETF | 28.34 | 28.46 | 28.26 | 28.27 | 2766400.0 |
| 2003-05-07 14:00:00 | QQQ | ETF | 28.28 | 28.33 | 28.15 | 28.21 | 5102900.0 |
| 2003-05-07 14:30:00 | QQQ | ETF | 28.21 | 28.3 | 28.16 | 28.2 | 3670700.0 |
| 2003-05-07 15:00:00 | QQQ | ETF | 28.2 | 28.27 | 28.12 | 28.24 | 3189900.0 |
| 2003-05-07 15:30:00 | QQQ | ETF | 28.24 | 28.38 | 28.18 | 28.27 | 5115200.0 |
| 2003-05-07 16:00:00 | QQQ | ETF | 28.28 | 28.33 | 28.24 | 28.31 | 1008600.0 |
| 2003-05-07 16:30:00 | QQQ | ETF | 28.3 | 28.3 | 28.25 | 28.25 | 79000.0 |
| 2003-05-07 17:00:00 | QQQ | ETF | 28.26 | 28.27 | 28.25 | 28.26 | 9000.0 |
| 2003-05-07 17:30:00 | QQQ | ETF | 28.25 | 28.26 | 28.22 | 28.22 | 24700.0 |
| 2003-05-07 18:00:00 | QQQ | ETF | 28.23 | 28.23 | 28.21 | 28.21 | 13800.0 |
| 2003-05-07 19:00:00 | QQQ | ETF | 28.25 | 28.27 | 28.25 | 28.26 | 2000.0 |
| 2003-05-07 19:30:00 | QQQ | ETF | 28.27 | 28.27 | 28.24 | 28.26 | 3600.0 |
| 2003-05-07 20:00:00 | QQQ | ETF | 28.24 | 28.24 | 28.24 | 28.24 | 2100.0 |
| 2003-05-07 09:00:00 | IWM | ETF | 41.01 | 41.01 | 41.01 | 41.01 | 1000.0 |
| 2003-05-07 09:30:00 | IWM | ETF | 41.04 | 41.1 | 40.875 | 40.965 | 182200.0 |
> showing 50 of 671 rows — these rows as CSV