PREVIEW / etf_5min / 2015-08-05
file: by_date/etf_5min/2015/2015-08-05.parquet size: 1.1 MB rows: 47,387
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-08-05 04:00:00 | SPY | ETF | 209.35 | 209.35 | 209.35 | 209.35 | 125.0 |
| 2015-08-05 04:15:00 | SPY | ETF | 209.29 | 209.3 | 209.27 | 209.3 | 1000.0 |
| 2015-08-05 04:30:00 | SPY | ETF | 209.42 | 209.42 | 209.42 | 209.42 | 300.0 |
| 2015-08-05 04:35:00 | SPY | ETF | 209.44 | 209.44 | 209.44 | 209.44 | 200.0 |
| 2015-08-05 04:40:00 | SPY | ETF | 209.44 | 209.52 | 209.44 | 209.47 | 1634.0 |
| 2015-08-05 04:50:00 | SPY | ETF | 209.47 | 209.47 | 209.47 | 209.47 | 900.0 |
| 2015-08-05 04:55:00 | SPY | ETF | 209.52 | 209.54 | 209.52 | 209.54 | 800.0 |
| 2015-08-05 05:00:00 | SPY | ETF | 209.54 | 209.54 | 209.54 | 209.54 | 600.0 |
| 2015-08-05 05:30:00 | SPY | ETF | 209.53 | 209.53 | 209.53 | 209.53 | 100.0 |
| 2015-08-05 05:35:00 | SPY | ETF | 209.51 | 209.51 | 209.51 | 209.51 | 100.0 |
| 2015-08-05 05:40:00 | SPY | ETF | 209.53 | 209.53 | 209.53 | 209.53 | 1600.0 |
| 2015-08-05 05:45:00 | SPY | ETF | 209.57 | 209.57 | 209.57 | 209.57 | 500.0 |
| 2015-08-05 05:55:00 | SPY | ETF | 209.65 | 209.72 | 209.65 | 209.7 | 1684.0 |
| 2015-08-05 06:00:00 | SPY | ETF | 209.7 | 209.77 | 209.7 | 209.74 | 1775.0 |
| 2015-08-05 06:05:00 | SPY | ETF | 209.78 | 209.78 | 209.74 | 209.78 | 1169.0 |
| 2015-08-05 06:10:00 | SPY | ETF | 209.76 | 209.76 | 209.76 | 209.76 | 15100.0 |
| 2015-08-05 06:15:00 | SPY | ETF | 209.77 | 209.83 | 209.77 | 209.79 | 14714.0 |
| 2015-08-05 06:20:00 | SPY | ETF | 209.74 | 209.74 | 209.74 | 209.74 | 5600.0 |
| 2015-08-05 06:30:00 | SPY | ETF | 209.85 | 209.91 | 209.81 | 209.9 | 15650.0 |
| 2015-08-05 06:35:00 | SPY | ETF | 209.87 | 209.93 | 209.87 | 209.93 | 3050.0 |
| 2015-08-05 06:40:00 | SPY | ETF | 209.9 | 209.93 | 209.9 | 209.93 | 33150.0 |
| 2015-08-05 06:45:00 | SPY | ETF | 209.9 | 209.93 | 209.9 | 209.93 | 11900.0 |
| 2015-08-05 06:50:00 | SPY | ETF | 209.98 | 209.98 | 209.85 | 209.91 | 60495.0 |
| 2015-08-05 06:55:00 | SPY | ETF | 209.91 | 209.94 | 209.88 | 209.91 | 12675.0 |
| 2015-08-05 07:00:00 | SPY | ETF | 209.87 | 209.94 | 209.87 | 209.87 | 30300.0 |
| 2015-08-05 07:05:00 | SPY | ETF | 209.87 | 209.91 | 209.86 | 209.89 | 97171.0 |
| 2015-08-05 07:10:00 | SPY | ETF | 209.9 | 209.91 | 209.88 | 209.9 | 13072.0 |
| 2015-08-05 07:15:00 | SPY | ETF | 209.9 | 210.11 | 209.89 | 210.09 | 28962.0 |
| 2015-08-05 07:20:00 | SPY | ETF | 210.09 | 210.18 | 210.04 | 210.16 | 76558.0 |
| 2015-08-05 07:25:00 | SPY | ETF | 210.16 | 210.32 | 210.13 | 210.28 | 117187.0 |
| 2015-08-05 07:30:00 | SPY | ETF | 210.26 | 210.31 | 210.18 | 210.31 | 68524.0 |
| 2015-08-05 07:35:00 | SPY | ETF | 210.31 | 210.31 | 210.25 | 210.28 | 56240.0 |
| 2015-08-05 07:40:00 | SPY | ETF | 210.29 | 210.42 | 210.29 | 210.4 | 75110.0 |
| 2015-08-05 07:45:00 | SPY | ETF | 210.4 | 210.4 | 210.27 | 210.27 | 53354.0 |
| 2015-08-05 07:50:00 | SPY | ETF | 210.28 | 210.29 | 210.23 | 210.25 | 9650.0 |
| 2015-08-05 07:55:00 | SPY | ETF | 210.25 | 210.27 | 210.2 | 210.22 | 10718.0 |
| 2015-08-05 08:00:00 | SPY | ETF | 210.2 | 210.31 | 209.87 | 210.31 | 57933.0 |
| 2015-08-05 08:05:00 | SPY | ETF | 210.31 | 210.41 | 210.31 | 210.34 | 72686.0 |
| 2015-08-05 08:10:00 | SPY | ETF | 210.34 | 210.36 | 210.29 | 210.31 | 115551.0 |
| 2015-08-05 08:15:00 | SPY | ETF | 210.32 | 210.33 | 210.26 | 210.33 | 78775.0 |
| 2015-08-05 08:20:00 | SPY | ETF | 210.33 | 210.75 | 210.32 | 210.73 | 502129.0 |
| 2015-08-05 08:25:00 | SPY | ETF | 210.73 | 210.94 | 210.7 | 210.7 | 399036.0 |
| 2015-08-05 08:30:00 | SPY | ETF | 210.7 | 210.76 | 210.68 | 210.75 | 120024.0 |
| 2015-08-05 08:35:00 | SPY | ETF | 210.75 | 210.76 | 210.72 | 210.74 | 80873.0 |
| 2015-08-05 08:40:00 | SPY | ETF | 210.71 | 210.71 | 210.64 | 210.68 | 120265.0 |
| 2015-08-05 08:45:00 | SPY | ETF | 210.68 | 210.75 | 210.65 | 210.68 | 239616.0 |
| 2015-08-05 08:50:00 | SPY | ETF | 210.68 | 210.74 | 210.68 | 210.68 | 111069.0 |
| 2015-08-05 08:55:00 | SPY | ETF | 210.69 | 210.69 | 210.48 | 210.48 | 159113.0 |
| 2015-08-05 09:00:00 | SPY | ETF | 210.48 | 210.56 | 210.48 | 210.5 | 52110.0 |
| 2015-08-05 09:05:00 | SPY | ETF | 210.48 | 210.54 | 210.46 | 210.47 | 126982.0 |
> showing 50 of 47,387 rows — these rows as CSV