PREVIEW / etf_30min / 2010-11-04
file: by_date/etf_30min/2010/2010-11-04.parquet size: 283 KB rows: 9,484
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 |
|---|---|---|---|---|---|---|---|
| 2010-11-04 04:00:00 | SPY | ETF | 120.32 | 120.76 | 120.32 | 120.76 | 33700.0 |
| 2010-11-04 04:30:00 | SPY | ETF | 120.78 | 120.8 | 120.75 | 120.8 | 8250.0 |
| 2010-11-04 05:00:00 | SPY | ETF | 120.81 | 120.95 | 120.81 | 120.95 | 48900.0 |
| 2010-11-04 05:30:00 | SPY | ETF | 120.91 | 120.94 | 120.88 | 120.91 | 24900.0 |
| 2010-11-04 06:00:00 | SPY | ETF | 120.89 | 121.05 | 120.89 | 120.99 | 39890.0 |
| 2010-11-04 06:30:00 | SPY | ETF | 121.0 | 121.0 | 120.95 | 120.95 | 26500.0 |
| 2010-11-04 07:00:00 | SPY | ETF | 120.95 | 121.0 | 120.86 | 121.0 | 291775.0 |
| 2010-11-04 07:30:00 | SPY | ETF | 120.97 | 121.03 | 120.88 | 121.03 | 828227.0 |
| 2010-11-04 08:00:00 | SPY | ETF | 121.02 | 121.27 | 120.94 | 121.23 | 2659076.0 |
| 2010-11-04 08:30:00 | SPY | ETF | 121.09 | 121.4 | 120.98 | 121.3 | 3248782.0 |
| 2010-11-04 09:00:00 | SPY | ETF | 121.31 | 121.36 | 121.19 | 121.27 | 1723000.0 |
| 2010-11-04 09:30:00 | SPY | ETF | 121.28 | 121.52 | 121.13 | 121.42 | 24006466.0 |
| 2010-11-04 10:00:00 | SPY | ETF | 121.41 | 121.64 | 121.16 | 121.59 | 20018073.0 |
| 2010-11-04 10:30:00 | SPY | ETF | 121.59 | 121.83 | 121.48 | 121.78 | 16073731.0 |
| 2010-11-04 11:00:00 | SPY | ETF | 121.79 | 121.96 | 121.66 | 121.71 | 14825196.0 |
| 2010-11-04 11:30:00 | SPY | ETF | 121.72 | 121.8 | 121.63 | 121.67 | 7273070.0 |
| 2010-11-04 12:00:00 | SPY | ETF | 121.66 | 121.81 | 121.57 | 121.73 | 10636171.0 |
| 2010-11-04 12:30:00 | SPY | ETF | 121.72 | 121.86 | 121.7 | 121.82 | 8429401.0 |
| 2010-11-04 13:00:00 | SPY | ETF | 121.82 | 121.9 | 121.78 | 121.88 | 6128092.0 |
| 2010-11-04 13:30:00 | SPY | ETF | 121.88 | 121.93 | 121.68 | 121.71 | 8368288.0 |
| 2010-11-04 14:00:00 | SPY | ETF | 121.72 | 121.89 | 121.63 | 121.81 | 9683302.0 |
| 2010-11-04 14:30:00 | SPY | ETF | 121.82 | 122.01 | 121.81 | 121.84 | 12557366.0 |
| 2010-11-04 15:00:00 | SPY | ETF | 121.84 | 122.19 | 121.83 | 122.18 | 18131488.0 |
| 2010-11-04 15:30:00 | SPY | ETF | 122.185 | 122.32 | 121.995 | 122.24 | 36251527.0 |
| 2010-11-04 16:00:00 | SPY | ETF | 122.23 | 122.35 | 121.175 | 122.27 | 10122790.0 |
| 2010-11-04 16:30:00 | SPY | ETF | 122.28 | 122.32 | 121.6424 | 122.22 | 426540.0 |
| 2010-11-04 17:00:00 | SPY | ETF | 122.23 | 122.26 | 122.18 | 122.19 | 327422.0 |
| 2010-11-04 17:30:00 | SPY | ETF | 122.25 | 122.29 | 122.22 | 122.24 | 104745.0 |
| 2010-11-04 18:00:00 | SPY | ETF | 122.24 | 122.29 | 122.2 | 122.26 | 113880.0 |
| 2010-11-04 18:30:00 | SPY | ETF | 122.24 | 122.28 | 122.2 | 122.22 | 149936.0 |
| 2010-11-04 19:00:00 | SPY | ETF | 122.2 | 122.28 | 122.2 | 122.22 | 59409.0 |
| 2010-11-04 19:30:00 | SPY | ETF | 122.22 | 122.29 | 122.22 | 122.28 | 144223.0 |
| 2010-11-04 04:00:00 | QQQ | ETF | 53.34 | 53.34 | 53.34 | 53.34 | 100.0 |
| 2010-11-04 04:30:00 | QQQ | ETF | 53.42 | 53.45 | 53.42 | 53.45 | 1350.0 |
| 2010-11-04 05:00:00 | QQQ | ETF | 53.44 | 53.51 | 53.44 | 53.51 | 5900.0 |
| 2010-11-04 05:30:00 | QQQ | ETF | 53.5 | 53.5 | 53.5 | 53.5 | 6000.0 |
| 2010-11-04 06:00:00 | QQQ | ETF | 53.5 | 53.5 | 53.5 | 53.5 | 2500.0 |
| 2010-11-04 06:30:00 | QQQ | ETF | 53.52 | 53.53 | 53.52 | 53.53 | 4500.0 |
| 2010-11-04 07:00:00 | QQQ | ETF | 53.49 | 53.53 | 53.49 | 53.53 | 40900.0 |
| 2010-11-04 07:30:00 | QQQ | ETF | 53.51 | 53.58 | 53.49 | 53.56 | 50278.0 |
| 2010-11-04 08:00:00 | QQQ | ETF | 53.57 | 53.65 | 53.54 | 53.61 | 355380.0 |
| 2010-11-04 08:30:00 | QQQ | ETF | 53.61 | 53.69 | 53.56 | 53.68 | 815383.0 |
| 2010-11-04 09:00:00 | QQQ | ETF | 53.68 | 53.69 | 53.61 | 53.63 | 713155.0 |
| 2010-11-04 09:30:00 | QQQ | ETF | 53.63 | 53.78 | 53.6 | 53.65 | 12645728.0 |
| 2010-11-04 10:00:00 | QQQ | ETF | 53.65 | 53.7 | 53.5 | 53.67 | 6294528.0 |
| 2010-11-04 10:30:00 | QQQ | ETF | 53.67 | 53.82 | 53.62 | 53.8 | 4168211.0 |
| 2010-11-04 11:00:00 | QQQ | ETF | 53.805 | 53.8614 | 53.68 | 53.71 | 3444622.0 |
| 2010-11-04 11:30:00 | QQQ | ETF | 53.71 | 53.76 | 53.66 | 53.67 | 2485819.0 |
| 2010-11-04 12:00:00 | QQQ | ETF | 53.67 | 53.735 | 53.64 | 53.69 | 2176583.0 |
| 2010-11-04 12:30:00 | QQQ | ETF | 53.69 | 53.75 | 53.65 | 53.71 | 1577781.0 |
> showing 50 of 9,484 rows — these rows as CSV