PREVIEW / etf_30min / 2010-02-19
file: by_date/etf_30min/2010/2010-02-19.parquet size: 249 KB rows: 8,294
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-02-19 04:00:00 | SPY | ETF | 110.33 | 110.33 | 110.26 | 110.33 | 800.0 |
| 2010-02-19 04:30:00 | SPY | ETF | 110.19 | 110.19 | 110.17 | 110.17 | 200.0 |
| 2010-02-19 05:00:00 | SPY | ETF | 110.15 | 110.15 | 110.09 | 110.09 | 1500.0 |
| 2010-02-19 05:30:00 | SPY | ETF | 110.09 | 110.19 | 110.06 | 110.11 | 3500.0 |
| 2010-02-19 06:00:00 | SPY | ETF | 110.2 | 110.22 | 110.18 | 110.2 | 5250.0 |
| 2010-02-19 06:30:00 | SPY | ETF | 110.2 | 110.25 | 110.15 | 110.2 | 74757.0 |
| 2010-02-19 07:00:00 | SPY | ETF | 110.16 | 110.36 | 110.16 | 110.35 | 894713.0 |
| 2010-02-19 07:30:00 | SPY | ETF | 110.35 | 110.44 | 110.33 | 110.41 | 733585.0 |
| 2010-02-19 08:00:00 | SPY | ETF | 110.42 | 110.43 | 110.23 | 110.35 | 1602518.0 |
| 2010-02-19 08:30:00 | SPY | ETF | 110.36 | 110.83 | 110.36 | 110.76 | 5313668.0 |
| 2010-02-19 09:00:00 | SPY | ETF | 110.76 | 110.79 | 110.58 | 110.62 | 1922854.0 |
| 2010-02-19 09:30:00 | SPY | ETF | 110.62 | 110.92 | 110.41 | 110.44 | 24949127.0 |
| 2010-02-19 10:00:00 | SPY | ETF | 110.43 | 110.93 | 110.36 | 110.83 | 18296280.0 |
| 2010-02-19 10:30:00 | SPY | ETF | 110.83 | 111.0 | 110.73 | 110.86 | 11794972.0 |
| 2010-02-19 11:00:00 | SPY | ETF | 110.86 | 111.38 | 110.5 | 111.36 | 19332394.0 |
| 2010-02-19 11:30:00 | SPY | ETF | 111.36 | 111.44 | 111.2 | 111.41 | 10682205.0 |
| 2010-02-19 12:00:00 | SPY | ETF | 111.41 | 111.57 | 111.355 | 111.47 | 12805317.0 |
| 2010-02-19 12:30:00 | SPY | ETF | 111.47 | 111.52 | 111.37 | 111.51 | 5789370.0 |
| 2010-02-19 13:00:00 | SPY | ETF | 111.5 | 111.52 | 111.27 | 111.31 | 6828607.0 |
| 2010-02-19 13:30:00 | SPY | ETF | 111.31 | 111.425 | 111.18 | 111.2499 | 8153034.0 |
| 2010-02-19 14:00:00 | SPY | ETF | 111.24 | 111.29 | 111.11 | 111.25 | 7207044.0 |
| 2010-02-19 14:30:00 | SPY | ETF | 111.25 | 111.35 | 111.22 | 111.24 | 7750274.0 |
| 2010-02-19 15:00:00 | SPY | ETF | 111.24 | 111.3 | 110.97 | 111.05 | 13767580.0 |
| 2010-02-19 15:30:00 | SPY | ETF | 111.04 | 111.42 | 111.04 | 111.19 | 26337706.0 |
| 2010-02-19 16:00:00 | SPY | ETF | 111.19 | 111.56 | 110.59 | 111.15 | 7414778.0 |
| 2010-02-19 16:30:00 | SPY | ETF | 111.14 | 111.17 | 109.9889 | 111.09 | 13553274.0 |
| 2010-02-19 17:00:00 | SPY | ETF | 111.08 | 111.25 | 110.9889 | 111.21 | 9953074.0 |
| 2010-02-19 17:30:00 | SPY | ETF | 111.21 | 111.31 | 111.17 | 111.2 | 263500.0 |
| 2010-02-19 18:00:00 | SPY | ETF | 111.18 | 111.19 | 111.13 | 111.17 | 38487.0 |
| 2010-02-19 18:30:00 | SPY | ETF | 111.17 | 111.2 | 111.14 | 111.17 | 14904.0 |
| 2010-02-19 19:00:00 | SPY | ETF | 111.18 | 111.25 | 111.16 | 111.23 | 31034.0 |
| 2010-02-19 19:30:00 | SPY | ETF | 110.9889 | 111.3 | 110.9889 | 111.3 | 7033187.0 |
| 2010-02-19 05:30:00 | QQQ | ETF | 44.57 | 44.57 | 44.54 | 44.54 | 8000.0 |
| 2010-02-19 06:00:00 | QQQ | ETF | 44.6 | 44.6 | 44.58 | 44.6 | 10400.0 |
| 2010-02-19 06:30:00 | QQQ | ETF | 44.62 | 44.62 | 44.59 | 44.6 | 5600.0 |
| 2010-02-19 07:00:00 | QQQ | ETF | 44.6 | 44.68 | 44.6 | 44.67 | 506781.0 |
| 2010-02-19 07:30:00 | QQQ | ETF | 44.67 | 44.72 | 44.67 | 44.68 | 148375.0 |
| 2010-02-19 08:00:00 | QQQ | ETF | 44.68 | 44.7 | 44.64 | 44.67 | 305351.0 |
| 2010-02-19 08:30:00 | QQQ | ETF | 44.68 | 44.81 | 44.67 | 44.77 | 1131681.0 |
| 2010-02-19 09:00:00 | QQQ | ETF | 44.78 | 44.78 | 44.7 | 44.76 | 429175.0 |
| 2010-02-19 09:30:00 | QQQ | ETF | 44.76 | 44.82 | 44.64 | 44.645 | 8043547.0 |
| 2010-02-19 10:00:00 | QQQ | ETF | 44.65 | 44.81 | 44.62 | 44.7701 | 6168108.0 |
| 2010-02-19 10:30:00 | QQQ | ETF | 44.78 | 44.83 | 44.71 | 44.77 | 4474668.0 |
| 2010-02-19 11:00:00 | QQQ | ETF | 44.78 | 44.95 | 44.75 | 44.948 | 6373684.0 |
| 2010-02-19 11:30:00 | QQQ | ETF | 44.94 | 45.02 | 44.9 | 44.9995 | 7675967.0 |
| 2010-02-19 12:00:00 | QQQ | ETF | 44.99 | 45.05 | 44.935 | 45.0 | 6042951.0 |
| 2010-02-19 12:30:00 | QQQ | ETF | 45.0 | 45.02 | 44.94 | 45.02 | 2081477.0 |
| 2010-02-19 13:00:00 | QQQ | ETF | 45.02 | 45.05 | 44.93 | 44.94 | 3607778.0 |
| 2010-02-19 13:30:00 | QQQ | ETF | 44.94 | 44.97 | 44.88 | 44.92 | 2789908.0 |
| 2010-02-19 14:00:00 | QQQ | ETF | 44.9201 | 44.93 | 44.7 | 44.89 | 2235025.0 |
> showing 50 of 8,294 rows — these rows as CSV