PREVIEW / etf_30min / 2015-12-21
file: by_date/etf_30min/2015/2015-12-21.parquet size: 394 KB rows: 13,366
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-21 04:00:00 | SPY | ETF | 201.5 | 201.75 | 201.38 | 201.41 | 26564.0 |
| 2015-12-21 04:30:00 | SPY | ETF | 201.38 | 201.54 | 201.38 | 201.48 | 11560.0 |
| 2015-12-21 05:00:00 | SPY | ETF | 201.5 | 201.8 | 201.5 | 201.75 | 12590.0 |
| 2015-12-21 05:30:00 | SPY | ETF | 201.79 | 201.83 | 201.52 | 201.59 | 28665.0 |
| 2015-12-21 06:00:00 | SPY | ETF | 201.54 | 201.59 | 201.39 | 201.39 | 64830.0 |
| 2015-12-21 06:30:00 | SPY | ETF | 201.37 | 201.66 | 201.36 | 201.41 | 197697.0 |
| 2015-12-21 07:00:00 | SPY | ETF | 201.43 | 201.47 | 201.33 | 201.46 | 182385.0 |
| 2015-12-21 07:30:00 | SPY | ETF | 201.42 | 201.42 | 201.09 | 201.27 | 252387.0 |
| 2015-12-21 08:00:00 | SPY | ETF | 201.25 | 201.45 | 201.08 | 201.17 | 803693.0 |
| 2015-12-21 08:30:00 | SPY | ETF | 201.15 | 201.35 | 201.11 | 201.28 | 384183.0 |
| 2015-12-21 09:00:00 | SPY | ETF | 201.3 | 201.54 | 201.18 | 201.4 | 658675.0 |
| 2015-12-21 09:30:00 | SPY | ETF | 201.41 | 201.88 | 201.045 | 201.17 | 14796716.0 |
| 2015-12-21 10:00:00 | SPY | ETF | 201.17 | 201.75 | 201.165 | 201.55 | 8026564.0 |
| 2015-12-21 10:30:00 | SPY | ETF | 201.56 | 201.83 | 201.065 | 201.26 | 6430494.0 |
| 2015-12-21 11:00:00 | SPY | ETF | 201.26 | 201.38 | 200.61 | 200.8 | 6150938.0 |
| 2015-12-21 11:30:00 | SPY | ETF | 200.795 | 200.81 | 200.09 | 200.55 | 7083648.0 |
| 2015-12-21 12:00:00 | SPY | ETF | 200.55 | 200.65 | 200.265 | 200.38 | 3393751.0 |
| 2015-12-21 12:30:00 | SPY | ETF | 200.37 | 200.93 | 200.35 | 200.83 | 3607155.0 |
| 2015-12-21 13:00:00 | SPY | ETF | 200.83 | 201.15 | 200.825 | 201.03 | 3294813.0 |
| 2015-12-21 13:30:00 | SPY | ETF | 201.04 | 201.32 | 201.01 | 201.03 | 3350496.0 |
| 2015-12-21 14:00:00 | SPY | ETF | 201.04 | 201.16 | 200.65 | 200.73 | 4241664.0 |
| 2015-12-21 14:30:00 | SPY | ETF | 200.72 | 200.8 | 200.51 | 200.67 | 3992314.0 |
| 2015-12-21 15:00:00 | SPY | ETF | 200.66 | 200.86 | 200.25 | 200.4601 | 6218324.0 |
| 2015-12-21 15:30:00 | SPY | ETF | 200.46 | 201.69 | 200.42 | 201.65 | 16696395.0 |
| 2015-12-21 16:00:00 | SPY | ETF | 201.65 | 202.07 | 201.45 | 202.03 | 6842016.0 |
| 2015-12-21 16:30:00 | SPY | ETF | 202.01 | 202.38 | 201.67 | 202.27 | 647513.0 |
| 2015-12-21 17:00:00 | SPY | ETF | 202.27 | 202.29 | 202.21 | 202.23 | 43651.0 |
| 2015-12-21 17:30:00 | SPY | ETF | 202.23 | 202.25 | 202.17 | 202.19 | 52083.0 |
| 2015-12-21 18:00:00 | SPY | ETF | 202.2 | 202.23 | 202.12 | 202.2 | 29336.0 |
| 2015-12-21 18:30:00 | SPY | ETF | 202.17 | 202.24 | 202.16 | 202.24 | 34479.0 |
| 2015-12-21 19:00:00 | SPY | ETF | 202.24 | 202.44 | 202.18 | 202.2 | 97332.0 |
| 2015-12-21 19:30:00 | SPY | ETF | 202.2 | 202.43 | 202.09 | 202.43 | 133907.0 |
| 2015-12-21 04:00:00 | QQQ | ETF | 110.75 | 111.02 | 110.75 | 110.86 | 4654.0 |
| 2015-12-21 04:30:00 | QQQ | ETF | 110.91 | 110.91 | 110.91 | 110.91 | 300.0 |
| 2015-12-21 05:00:00 | QQQ | ETF | 110.95 | 111.01 | 110.95 | 111.01 | 500.0 |
| 2015-12-21 05:30:00 | QQQ | ETF | 111.07 | 111.07 | 111.0 | 111.0 | 2700.0 |
| 2015-12-21 06:00:00 | QQQ | ETF | 110.93 | 110.93 | 110.88 | 110.9 | 10085.0 |
| 2015-12-21 06:30:00 | QQQ | ETF | 110.87 | 110.93 | 110.87 | 110.87 | 10600.0 |
| 2015-12-21 07:00:00 | QQQ | ETF | 110.85 | 110.85 | 110.78 | 110.81 | 259710.0 |
| 2015-12-21 07:30:00 | QQQ | ETF | 110.78 | 110.78 | 110.65 | 110.69 | 8000.0 |
| 2015-12-21 08:00:00 | QQQ | ETF | 110.73 | 110.85 | 110.67 | 110.7 | 276175.0 |
| 2015-12-21 08:30:00 | QQQ | ETF | 110.7 | 110.83 | 110.7 | 110.7899 | 84748.0 |
| 2015-12-21 09:00:00 | QQQ | ETF | 110.78 | 110.94 | 110.75 | 110.86 | 133189.0 |
| 2015-12-21 09:30:00 | QQQ | ETF | 110.86 | 111.04 | 110.5 | 110.54 | 5322798.0 |
| 2015-12-21 10:00:00 | QQQ | ETF | 110.55 | 110.965 | 110.55 | 110.82 | 1769475.0 |
| 2015-12-21 10:30:00 | QQQ | ETF | 110.82 | 111.0 | 110.53 | 110.68 | 1682922.0 |
| 2015-12-21 11:00:00 | QQQ | ETF | 110.67 | 110.7369 | 110.43 | 110.53 | 1432809.0 |
| 2015-12-21 11:30:00 | QQQ | ETF | 110.52 | 110.525 | 110.05 | 110.39 | 2365307.0 |
| 2015-12-21 12:00:00 | QQQ | ETF | 110.38 | 110.52 | 110.35 | 110.37 | 834323.0 |
| 2015-12-21 12:30:00 | QQQ | ETF | 110.36 | 110.71 | 110.35 | 110.66 | 925404.0 |
> showing 50 of 13,366 rows — these rows as CSV