PREVIEW / etf_30min / 2003-05-28
file: by_date/etf_30min/2003/2003-05-28.parquet size: 23 KB rows: 706
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-28 08:00:00 | SPY | ETF | 95.98 | 96.02 | 95.91 | 95.98 | 51200.0 |
| 2003-05-28 08:30:00 | SPY | ETF | 95.96 | 96.05 | 95.77 | 95.85 | 95500.0 |
| 2003-05-28 09:00:00 | SPY | ETF | 95.85 | 95.91 | 95.8 | 95.8 | 19800.0 |
| 2003-05-28 09:30:00 | SPY | ETF | 95.85 | 96.14 | 95.59 | 96.14 | 4098800.0 |
| 2003-05-28 10:00:00 | SPY | ETF | 96.13 | 96.15 | 95.43 | 95.93 | 5030800.0 |
| 2003-05-28 10:30:00 | SPY | ETF | 95.94 | 96.17 | 95.89 | 96.1 | 2594400.0 |
| 2003-05-28 11:00:00 | SPY | ETF | 96.12 | 96.27 | 96.03 | 96.22 | 2731600.0 |
| 2003-05-28 11:30:00 | SPY | ETF | 96.22 | 96.47 | 96.16 | 96.4 | 2875400.0 |
| 2003-05-28 12:00:00 | SPY | ETF | 96.37 | 96.4 | 96.06 | 96.06 | 1733500.0 |
| 2003-05-28 12:30:00 | SPY | ETF | 96.07 | 96.13 | 95.83 | 95.9 | 1510300.0 |
| 2003-05-28 13:00:00 | SPY | ETF | 95.9 | 96.04 | 95.63 | 95.85 | 1816300.0 |
| 2003-05-28 13:30:00 | SPY | ETF | 95.86 | 95.96 | 95.71 | 95.78 | 1528500.0 |
| 2003-05-28 14:00:00 | SPY | ETF | 95.78 | 96.01 | 95.62 | 95.71 | 1782400.0 |
| 2003-05-28 14:30:00 | SPY | ETF | 95.71 | 95.83 | 95.53 | 95.73 | 2268000.0 |
| 2003-05-28 15:00:00 | SPY | ETF | 95.74 | 96.1 | 95.73 | 96.06 | 1577900.0 |
| 2003-05-28 15:30:00 | SPY | ETF | 96.1 | 96.1 | 95.75 | 95.82 | 1830000.0 |
| 2003-05-28 16:00:00 | SPY | ETF | 95.81 | 95.83 | 95.66 | 95.7 | 1224400.0 |
| 2003-05-28 16:30:00 | SPY | ETF | 95.68 | 95.69 | 95.61 | 95.65 | 193400.0 |
| 2003-05-28 17:00:00 | SPY | ETF | 95.63 | 95.65 | 95.55 | 95.56 | 104400.0 |
| 2003-05-28 17:30:00 | SPY | ETF | 95.56 | 95.59 | 95.55 | 95.59 | 14100.0 |
| 2003-05-28 18:00:00 | SPY | ETF | 95.56 | 95.59 | 95.56 | 95.56 | 2400.0 |
| 2003-05-28 18:30:00 | SPY | ETF | 95.6 | 95.62 | 95.6 | 95.62 | 200.0 |
| 2003-05-28 19:00:00 | SPY | ETF | 95.64 | 95.64 | 95.64 | 95.64 | 300.0 |
| 2003-05-28 19:30:00 | SPY | ETF | 95.65 | 95.65 | 95.58 | 95.58 | 1900.0 |
| 2003-05-28 08:00:00 | QQQ | ETF | 29.34 | 29.38 | 29.32 | 29.38 | 75100.0 |
| 2003-05-28 08:30:00 | QQQ | ETF | 29.36 | 29.39 | 29.27 | 29.31 | 193800.0 |
| 2003-05-28 09:00:00 | QQQ | ETF | 29.29 | 29.32 | 29.17 | 29.17 | 45500.0 |
| 2003-05-28 09:30:00 | QQQ | ETF | 29.16 | 29.32 | 29.11 | 29.27 | 11662300.0 |
| 2003-05-28 10:00:00 | QQQ | ETF | 29.28 | 29.29 | 28.96 | 29.16 | 9190800.0 |
| 2003-05-28 10:30:00 | QQQ | ETF | 29.15 | 29.29 | 29.13 | 29.28 | 5292900.0 |
| 2003-05-28 11:00:00 | QQQ | ETF | 29.28 | 29.37 | 29.24 | 29.31 | 5509900.0 |
| 2003-05-28 11:30:00 | QQQ | ETF | 29.31 | 29.4 | 29.27 | 29.35 | 4348100.0 |
| 2003-05-28 12:00:00 | QQQ | ETF | 29.35 | 29.36 | 29.21 | 29.21 | 3494600.0 |
| 2003-05-28 12:30:00 | QQQ | ETF | 29.21 | 29.25 | 29.11 | 29.16 | 3208900.0 |
| 2003-05-28 13:00:00 | QQQ | ETF | 29.15 | 29.19 | 29.02 | 29.13 | 4893000.0 |
| 2003-05-28 13:30:00 | QQQ | ETF | 29.13 | 29.18 | 29.08 | 29.11 | 2697200.0 |
| 2003-05-28 14:00:00 | QQQ | ETF | 29.1 | 29.21 | 29.06 | 29.13 | 3858600.0 |
| 2003-05-28 14:30:00 | QQQ | ETF | 29.1 | 29.16 | 29.04 | 29.14 | 3726300.0 |
| 2003-05-28 15:00:00 | QQQ | ETF | 29.12 | 29.28 | 29.12 | 29.26 | 4058800.0 |
| 2003-05-28 15:30:00 | QQQ | ETF | 29.26 | 29.29 | 29.14 | 29.17 | 6253100.0 |
| 2003-05-28 16:00:00 | QQQ | ETF | 29.17 | 29.2 | 29.14 | 29.17 | 1306000.0 |
| 2003-05-28 16:30:00 | QQQ | ETF | 29.18 | 29.19 | 29.11 | 29.15 | 378000.0 |
| 2003-05-28 17:00:00 | QQQ | ETF | 29.15 | 29.15 | 29.07 | 29.1 | 246300.0 |
| 2003-05-28 17:30:00 | QQQ | ETF | 29.1 | 29.11 | 29.08 | 29.11 | 60600.0 |
| 2003-05-28 18:00:00 | QQQ | ETF | 29.11 | 29.12 | 29.08 | 29.09 | 57400.0 |
| 2003-05-28 18:30:00 | QQQ | ETF | 29.1 | 29.11 | 29.1 | 29.1 | 8700.0 |
| 2003-05-28 19:00:00 | QQQ | ETF | 29.09 | 29.12 | 29.09 | 29.1 | 2200.0 |
| 2003-05-28 19:30:00 | QQQ | ETF | 29.12 | 29.15 | 29.12 | 29.15 | 13800.0 |
| 2003-05-28 09:30:00 | IWM | ETF | 42.8 | 43.1 | 42.8 | 43.03 | 414600.0 |
| 2003-05-28 10:00:00 | IWM | ETF | 43.025 | 43.025 | 42.805 | 42.925 | 308400.0 |
> showing 50 of 706 rows — these rows as CSV