PREVIEW / etf_30min / 2003-01-17
file: by_date/etf_30min/2003/2003-01-17.parquet size: 21 KB rows: 622
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-01-17 08:00:00 | SPY | ETF | 91.24 | 91.3 | 91.2 | 91.28 | 19200.0 |
| 2003-01-17 08:30:00 | SPY | ETF | 91.28 | 91.28 | 91.1 | 91.12 | 22300.0 |
| 2003-01-17 09:00:00 | SPY | ETF | 91.17 | 91.17 | 90.95 | 91.01 | 33400.0 |
| 2003-01-17 09:30:00 | SPY | ETF | 90.99 | 91.29 | 90.77 | 91.07 | 8026600.0 |
| 2003-01-17 10:00:00 | SPY | ETF | 91.07 | 91.34 | 90.96 | 91.1 | 3135400.0 |
| 2003-01-17 10:30:00 | SPY | ETF | 91.08 | 91.22 | 90.72 | 90.76 | 2004900.0 |
| 2003-01-17 11:00:00 | SPY | ETF | 90.78 | 90.81 | 90.4 | 90.52 | 3327200.0 |
| 2003-01-17 11:30:00 | SPY | ETF | 90.5 | 90.62 | 90.35 | 90.47 | 2684000.0 |
| 2003-01-17 12:00:00 | SPY | ETF | 90.49 | 90.68 | 90.46 | 90.62 | 1091500.0 |
| 2003-01-17 12:30:00 | SPY | ETF | 90.61 | 90.65 | 90.5 | 90.58 | 689800.0 |
| 2003-01-17 13:00:00 | SPY | ETF | 90.61 | 90.62 | 90.42 | 90.47 | 1317700.0 |
| 2003-01-17 13:30:00 | SPY | ETF | 90.5 | 90.52 | 90.21 | 90.29 | 1966000.0 |
| 2003-01-17 14:00:00 | SPY | ETF | 90.29 | 90.34 | 90.15 | 90.32 | 1718700.0 |
| 2003-01-17 14:30:00 | SPY | ETF | 90.33 | 90.57 | 90.27 | 90.52 | 1969700.0 |
| 2003-01-17 15:00:00 | SPY | ETF | 90.52 | 90.57 | 90.22 | 90.41 | 1642300.0 |
| 2003-01-17 15:30:00 | SPY | ETF | 90.43 | 90.64 | 90.35 | 90.49 | 2585300.0 |
| 2003-01-17 16:00:00 | SPY | ETF | 90.48 | 90.71 | 90.42 | 90.62 | 1290700.0 |
| 2003-01-17 16:30:00 | SPY | ETF | 90.61 | 90.73 | 90.57 | 90.69 | 213100.0 |
| 2003-01-17 17:00:00 | SPY | ETF | 90.58 | 90.65 | 90.58 | 90.64 | 4000.0 |
| 2003-01-17 17:30:00 | SPY | ETF | 90.65 | 90.65 | 90.6 | 90.63 | 1000.0 |
| 2003-01-17 18:00:00 | SPY | ETF | 90.64 | 90.64 | 90.64 | 90.64 | 500.0 |
| 2003-01-17 18:30:00 | SPY | ETF | 90.65 | 90.65 | 90.6 | 90.6 | 1600.0 |
| 2003-01-17 19:00:00 | SPY | ETF | 90.66 | 90.66 | 90.66 | 90.66 | 100.0 |
| 2003-01-17 08:00:00 | QQQ | ETF | 26.03 | 26.03 | 25.9 | 25.95 | 72800.0 |
| 2003-01-17 08:30:00 | QQQ | ETF | 25.92 | 25.92 | 25.86 | 25.9 | 121500.0 |
| 2003-01-17 09:00:00 | QQQ | ETF | 25.91 | 25.92 | 25.85 | 25.9 | 33600.0 |
| 2003-01-17 09:30:00 | QQQ | ETF | 25.9 | 25.94 | 25.58 | 25.69 | 18922600.0 |
| 2003-01-17 10:00:00 | QQQ | ETF | 25.69 | 25.82 | 25.63 | 25.72 | 8938200.0 |
| 2003-01-17 10:30:00 | QQQ | ETF | 25.72 | 25.78 | 25.6 | 25.62 | 4631100.0 |
| 2003-01-17 11:00:00 | QQQ | ETF | 25.64 | 25.65 | 25.46 | 25.5 | 6446400.0 |
| 2003-01-17 11:30:00 | QQQ | ETF | 25.5 | 25.6 | 25.45 | 25.49 | 3756000.0 |
| 2003-01-17 12:00:00 | QQQ | ETF | 25.5 | 25.61 | 25.49 | 25.57 | 1795100.0 |
| 2003-01-17 12:30:00 | QQQ | ETF | 25.57 | 25.59 | 25.51 | 25.58 | 1588800.0 |
| 2003-01-17 13:00:00 | QQQ | ETF | 25.57 | 25.59 | 25.44 | 25.5 | 1807500.0 |
| 2003-01-17 13:30:00 | QQQ | ETF | 25.48 | 25.5 | 25.38 | 25.42 | 3294100.0 |
| 2003-01-17 14:00:00 | QQQ | ETF | 25.41 | 25.43 | 25.32 | 25.41 | 3169200.0 |
| 2003-01-17 14:30:00 | QQQ | ETF | 25.41 | 25.54 | 25.39 | 25.51 | 3363700.0 |
| 2003-01-17 15:00:00 | QQQ | ETF | 25.52 | 25.53 | 25.35 | 25.4 | 4080100.0 |
| 2003-01-17 15:30:00 | QQQ | ETF | 25.42 | 25.47 | 25.29 | 25.32 | 6158500.0 |
| 2003-01-17 16:00:00 | QQQ | ETF | 25.35 | 25.45 | 25.27 | 25.31 | 2955900.0 |
| 2003-01-17 16:30:00 | QQQ | ETF | 25.3 | 25.33 | 25.28 | 25.31 | 61700.0 |
| 2003-01-17 17:00:00 | QQQ | ETF | 25.3 | 25.33 | 25.28 | 25.32 | 128900.0 |
| 2003-01-17 17:30:00 | QQQ | ETF | 25.31 | 25.35 | 25.28 | 25.28 | 27200.0 |
| 2003-01-17 18:00:00 | QQQ | ETF | 25.28 | 25.32 | 25.26 | 25.28 | 22600.0 |
| 2003-01-17 18:30:00 | QQQ | ETF | 25.26 | 25.35 | 25.26 | 25.35 | 10200.0 |
| 2003-01-17 19:00:00 | QQQ | ETF | 25.36 | 25.36 | 25.36 | 25.36 | 3000.0 |
| 2003-01-17 19:30:00 | QQQ | ETF | 25.36 | 25.39 | 25.34 | 25.39 | 2300.0 |
| 2003-01-17 09:00:00 | IWM | ETF | 39.03 | 39.03 | 39.03 | 39.03 | 2000.0 |
| 2003-01-17 09:30:00 | IWM | ETF | 38.94 | 39.12 | 38.82 | 38.89 | 261000.0 |
| 2003-01-17 10:00:00 | IWM | ETF | 38.895 | 39.0 | 38.865 | 38.885 | 109400.0 |
> showing 50 of 622 rows — these rows as CSV