PREVIEW / etf_5min / 2019-05-14
file: by_date/etf_5min/2019/2019-05-14.parquet size: 1.4 MB rows: 62,603
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-14 04:00:00 | SPY | ETF | 281.77 | 282.0 | 281.77 | 281.78 | 2540.0 |
| 2019-05-14 04:05:00 | SPY | ETF | 281.7 | 281.7 | 281.69 | 281.69 | 288.0 |
| 2019-05-14 04:10:00 | SPY | ETF | 281.48 | 281.48 | 281.44 | 281.45 | 574.0 |
| 2019-05-14 04:15:00 | SPY | ETF | 281.6 | 281.6 | 281.6 | 281.6 | 300.0 |
| 2019-05-14 04:20:00 | SPY | ETF | 281.62 | 281.62 | 281.55 | 281.55 | 1816.0 |
| 2019-05-14 04:25:00 | SPY | ETF | 281.68 | 281.68 | 281.59 | 281.59 | 3839.0 |
| 2019-05-14 04:30:00 | SPY | ETF | 281.53 | 281.53 | 281.44 | 281.44 | 1388.0 |
| 2019-05-14 04:35:00 | SPY | ETF | 281.63 | 281.63 | 281.63 | 281.63 | 400.0 |
| 2019-05-14 04:40:00 | SPY | ETF | 281.63 | 281.63 | 281.63 | 281.63 | 500.0 |
| 2019-05-14 04:45:00 | SPY | ETF | 281.63 | 281.7 | 281.63 | 281.7 | 708.0 |
| 2019-05-14 04:50:00 | SPY | ETF | 281.73 | 281.85 | 281.73 | 281.85 | 7816.0 |
| 2019-05-14 04:55:00 | SPY | ETF | 281.84 | 281.88 | 281.84 | 281.88 | 4616.0 |
| 2019-05-14 05:00:00 | SPY | ETF | 281.85 | 281.85 | 281.75 | 281.8 | 600.0 |
| 2019-05-14 05:15:00 | SPY | ETF | 281.9 | 281.96 | 281.9 | 281.96 | 255.0 |
| 2019-05-14 05:20:00 | SPY | ETF | 281.99 | 282.02 | 281.99 | 282.02 | 1205.0 |
| 2019-05-14 05:25:00 | SPY | ETF | 282.05 | 282.05 | 282.05 | 282.05 | 100.0 |
| 2019-05-14 05:30:00 | SPY | ETF | 282.1 | 282.1 | 282.08 | 282.08 | 1600.0 |
| 2019-05-14 05:35:00 | SPY | ETF | 282.1 | 282.31 | 282.1 | 282.27 | 1603.0 |
| 2019-05-14 05:40:00 | SPY | ETF | 282.32 | 282.37 | 282.32 | 282.35 | 1855.0 |
| 2019-05-14 05:45:00 | SPY | ETF | 282.35 | 282.35 | 282.3 | 282.3 | 3910.0 |
| 2019-05-14 05:50:00 | SPY | ETF | 282.16 | 282.26 | 282.16 | 282.26 | 500.0 |
| 2019-05-14 05:55:00 | SPY | ETF | 282.26 | 282.29 | 282.26 | 282.29 | 2604.0 |
| 2019-05-14 06:00:00 | SPY | ETF | 282.29 | 282.29 | 282.29 | 282.29 | 300.0 |
| 2019-05-14 06:05:00 | SPY | ETF | 282.11 | 282.26 | 282.11 | 282.26 | 1425.0 |
| 2019-05-14 06:10:00 | SPY | ETF | 282.26 | 282.53 | 282.26 | 282.53 | 3797.0 |
| 2019-05-14 06:15:00 | SPY | ETF | 282.54 | 282.55 | 282.41 | 282.54 | 18897.0 |
| 2019-05-14 06:20:00 | SPY | ETF | 282.5 | 282.55 | 282.5 | 282.55 | 17000.0 |
| 2019-05-14 06:25:00 | SPY | ETF | 282.52 | 282.52 | 282.46 | 282.47 | 610.0 |
| 2019-05-14 06:30:00 | SPY | ETF | 282.44 | 282.46 | 282.36 | 282.39 | 15420.0 |
| 2019-05-14 06:35:00 | SPY | ETF | 282.28 | 282.41 | 282.28 | 282.41 | 34601.0 |
| 2019-05-14 06:40:00 | SPY | ETF | 282.41 | 282.5 | 282.41 | 282.5 | 4216.0 |
| 2019-05-14 06:45:00 | SPY | ETF | 282.6 | 282.64 | 282.58 | 282.6 | 10068.0 |
| 2019-05-14 06:50:00 | SPY | ETF | 282.53 | 282.82 | 282.43 | 282.52 | 12570.0 |
| 2019-05-14 06:55:00 | SPY | ETF | 282.47 | 282.47 | 282.2 | 282.34 | 27187.0 |
| 2019-05-14 07:00:00 | SPY | ETF | 282.28 | 282.31 | 282.2 | 282.3 | 168309.0 |
| 2019-05-14 07:05:00 | SPY | ETF | 282.27 | 282.39 | 282.27 | 282.39 | 12827.0 |
| 2019-05-14 07:10:00 | SPY | ETF | 282.4 | 282.46 | 282.36 | 282.46 | 25662.0 |
| 2019-05-14 07:15:00 | SPY | ETF | 282.47 | 282.83 | 282.44 | 282.63 | 67434.0 |
| 2019-05-14 07:20:00 | SPY | ETF | 282.63 | 282.74 | 282.5 | 282.73 | 27324.0 |
| 2019-05-14 07:25:00 | SPY | ETF | 282.76 | 282.85 | 282.62 | 282.62 | 27159.0 |
| 2019-05-14 07:30:00 | SPY | ETF | 282.66 | 282.66 | 282.5 | 282.57 | 50889.0 |
| 2019-05-14 07:35:00 | SPY | ETF | 282.59 | 282.6 | 282.47 | 282.47 | 24458.0 |
| 2019-05-14 07:40:00 | SPY | ETF | 282.46 | 282.65 | 282.46 | 282.57 | 83676.0 |
| 2019-05-14 07:45:00 | SPY | ETF | 282.55 | 282.6 | 282.51 | 282.51 | 33728.0 |
| 2019-05-14 07:50:00 | SPY | ETF | 282.51 | 282.52 | 282.41 | 282.48 | 24888.0 |
| 2019-05-14 07:55:00 | SPY | ETF | 282.5 | 282.6 | 282.43 | 282.56 | 36573.0 |
| 2019-05-14 08:00:00 | SPY | ETF | 282.29 | 282.84 | 281.68 | 282.53 | 88951.0 |
| 2019-05-14 08:05:00 | SPY | ETF | 282.56 | 282.57 | 282.5 | 282.54 | 22805.0 |
| 2019-05-14 08:10:00 | SPY | ETF | 282.54 | 282.72 | 282.54 | 282.69 | 29516.0 |
| 2019-05-14 08:15:00 | SPY | ETF | 282.6699 | 282.68 | 282.51 | 282.68 | 33935.0 |
> showing 50 of 62,603 rows — these rows as CSV