PREVIEW / etf_5min / 2019-03-12
file: by_date/etf_5min/2019/2019-03-12.parquet size: 1.4 MB rows: 61,688
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-03-12 04:00:00 | SPY | ETF | 279.35 | 279.35 | 279.3 | 279.32 | 2503.0 |
| 2019-03-12 04:20:00 | SPY | ETF | 279.13 | 279.13 | 279.05 | 279.07 | 1100.0 |
| 2019-03-12 04:30:00 | SPY | ETF | 279.07 | 279.07 | 279.06 | 279.06 | 2200.0 |
| 2019-03-12 04:35:00 | SPY | ETF | 279.02 | 279.02 | 278.93 | 278.93 | 1519.0 |
| 2019-03-12 04:55:00 | SPY | ETF | 279.0 | 279.0 | 279.0 | 279.0 | 100.0 |
| 2019-03-12 05:00:00 | SPY | ETF | 279.1 | 279.18 | 279.08 | 279.18 | 1204.0 |
| 2019-03-12 05:10:00 | SPY | ETF | 279.26 | 279.26 | 279.24 | 279.24 | 782.0 |
| 2019-03-12 05:15:00 | SPY | ETF | 279.31 | 279.31 | 279.31 | 279.31 | 100.0 |
| 2019-03-12 05:20:00 | SPY | ETF | 279.2 | 279.2 | 279.2 | 279.2 | 250.0 |
| 2019-03-12 05:25:00 | SPY | ETF | 279.23 | 279.23 | 279.23 | 279.23 | 1500.0 |
| 2019-03-12 05:30:00 | SPY | ETF | 279.21 | 279.21 | 279.21 | 279.21 | 800.0 |
| 2019-03-12 05:35:00 | SPY | ETF | 279.16 | 279.16 | 279.16 | 279.16 | 300.0 |
| 2019-03-12 05:40:00 | SPY | ETF | 279.25 | 279.25 | 279.25 | 279.25 | 510.0 |
| 2019-03-12 05:45:00 | SPY | ETF | 279.25 | 279.25 | 279.21 | 279.21 | 1810.0 |
| 2019-03-12 05:50:00 | SPY | ETF | 279.08 | 279.08 | 279.01 | 279.01 | 1703.0 |
| 2019-03-12 05:55:00 | SPY | ETF | 278.99 | 278.99 | 278.92 | 278.92 | 5200.0 |
| 2019-03-12 06:00:00 | SPY | ETF | 278.93 | 278.94 | 278.86 | 278.9 | 2204.0 |
| 2019-03-12 06:05:00 | SPY | ETF | 278.84 | 278.85 | 278.72 | 278.74 | 3978.0 |
| 2019-03-12 06:10:00 | SPY | ETF | 278.75 | 278.8 | 278.75 | 278.78 | 2700.0 |
| 2019-03-12 06:15:00 | SPY | ETF | 278.81 | 278.83 | 278.81 | 278.83 | 305.0 |
| 2019-03-12 06:20:00 | SPY | ETF | 278.78 | 278.8 | 278.78 | 278.8 | 400.0 |
| 2019-03-12 06:25:00 | SPY | ETF | 278.81 | 278.81 | 278.74 | 278.74 | 1215.0 |
| 2019-03-12 06:30:00 | SPY | ETF | 278.71 | 278.78 | 278.71 | 278.78 | 3000.0 |
| 2019-03-12 06:35:00 | SPY | ETF | 278.78 | 278.82 | 278.78 | 278.82 | 400.0 |
| 2019-03-12 06:40:00 | SPY | ETF | 278.82 | 278.82 | 278.78 | 278.82 | 4700.0 |
| 2019-03-12 06:45:00 | SPY | ETF | 278.8 | 278.8 | 278.71 | 278.75 | 3650.0 |
| 2019-03-12 06:50:00 | SPY | ETF | 278.71 | 278.71 | 278.71 | 278.71 | 1000.0 |
| 2019-03-12 06:55:00 | SPY | ETF | 278.74 | 278.74 | 278.74 | 278.74 | 500.0 |
| 2019-03-12 07:00:00 | SPY | ETF | 278.78 | 278.83 | 278.56 | 278.57 | 67383.0 |
| 2019-03-12 07:05:00 | SPY | ETF | 278.56 | 278.58 | 278.3 | 278.4 | 49794.0 |
| 2019-03-12 07:10:00 | SPY | ETF | 278.44 | 278.47 | 278.38 | 278.41 | 42053.0 |
| 2019-03-12 07:15:00 | SPY | ETF | 278.38 | 278.5 | 278.38 | 278.46 | 84933.0 |
| 2019-03-12 07:20:00 | SPY | ETF | 278.46 | 278.56 | 278.29 | 278.35 | 45984.0 |
| 2019-03-12 07:25:00 | SPY | ETF | 278.33 | 278.36 | 278.3 | 278.34 | 29194.0 |
| 2019-03-12 07:30:00 | SPY | ETF | 278.34 | 278.42 | 278.34 | 278.35 | 5560.0 |
| 2019-03-12 07:35:00 | SPY | ETF | 278.39 | 278.49 | 278.39 | 278.46 | 3452.0 |
| 2019-03-12 07:40:00 | SPY | ETF | 278.47 | 278.47 | 278.38 | 278.41 | 6604.0 |
| 2019-03-12 07:45:00 | SPY | ETF | 278.42 | 278.49 | 278.42 | 278.49 | 2648.0 |
| 2019-03-12 07:50:00 | SPY | ETF | 278.48 | 278.49 | 278.46 | 278.46 | 8080.0 |
| 2019-03-12 07:55:00 | SPY | ETF | 278.44 | 278.5 | 278.4 | 278.5 | 6625.0 |
| 2019-03-12 08:00:00 | SPY | ETF | 279.13 | 279.37 | 278.36 | 278.52 | 124871.0 |
| 2019-03-12 08:05:00 | SPY | ETF | 278.55 | 278.56 | 278.5 | 278.53 | 28103.0 |
| 2019-03-12 08:10:00 | SPY | ETF | 278.56 | 278.6 | 278.49 | 278.59 | 39696.0 |
| 2019-03-12 08:15:00 | SPY | ETF | 278.59 | 278.64 | 278.56 | 278.56 | 11060.0 |
| 2019-03-12 08:20:00 | SPY | ETF | 278.57 | 278.66 | 278.57 | 278.64 | 14875.0 |
| 2019-03-12 08:25:00 | SPY | ETF | 278.6 | 278.67 | 278.56 | 278.56 | 36554.0 |
| 2019-03-12 08:30:00 | SPY | ETF | 278.69 | 279.17 | 278.69 | 279.12 | 158345.0 |
| 2019-03-12 08:35:00 | SPY | ETF | 279.13 | 279.13 | 279.0 | 279.08 | 98316.0 |
| 2019-03-12 08:40:00 | SPY | ETF | 279.05 | 279.23 | 279.04 | 279.2 | 56260.0 |
| 2019-03-12 08:45:00 | SPY | ETF | 279.2 | 279.28 | 279.14 | 279.19 | 63614.0 |
> showing 50 of 61,688 rows — these rows as CSV