PREVIEW / etf_5min / 2019-04-01
file: by_date/etf_5min/2019/2019-04-01.parquet size: 1.5 MB rows: 66,984
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-04-01 04:00:00 | SPY | ETF | 284.51 | 284.81 | 284.51 | 284.59 | 6014.0 |
| 2019-04-01 04:05:00 | SPY | ETF | 284.6 | 284.6 | 284.6 | 284.6 | 824.0 |
| 2019-04-01 04:15:00 | SPY | ETF | 284.67 | 284.74 | 284.62 | 284.74 | 1500.0 |
| 2019-04-01 04:20:00 | SPY | ETF | 284.78 | 284.78 | 284.7 | 284.77 | 2040.0 |
| 2019-04-01 04:25:00 | SPY | ETF | 284.72 | 284.75 | 284.72 | 284.75 | 612.0 |
| 2019-04-01 04:30:00 | SPY | ETF | 284.75 | 284.82 | 284.74 | 284.8 | 2983.0 |
| 2019-04-01 04:35:00 | SPY | ETF | 284.82 | 284.89 | 284.82 | 284.88 | 1729.0 |
| 2019-04-01 04:40:00 | SPY | ETF | 284.81 | 284.81 | 284.81 | 284.81 | 600.0 |
| 2019-04-01 04:45:00 | SPY | ETF | 284.83 | 284.87 | 284.83 | 284.87 | 1183.0 |
| 2019-04-01 04:50:00 | SPY | ETF | 284.86 | 284.86 | 284.7 | 284.7 | 1502.0 |
| 2019-04-01 04:55:00 | SPY | ETF | 284.7 | 284.71 | 284.69 | 284.71 | 902.0 |
| 2019-04-01 05:00:00 | SPY | ETF | 284.75 | 284.75 | 284.68 | 284.68 | 9613.0 |
| 2019-04-01 05:05:00 | SPY | ETF | 284.7 | 284.77 | 284.7 | 284.77 | 812.0 |
| 2019-04-01 05:10:00 | SPY | ETF | 284.6 | 284.62 | 284.6 | 284.62 | 310.0 |
| 2019-04-01 05:15:00 | SPY | ETF | 284.57 | 284.67 | 284.55 | 284.67 | 5700.0 |
| 2019-04-01 05:20:00 | SPY | ETF | 284.55 | 284.57 | 284.5 | 284.5 | 630.0 |
| 2019-04-01 05:25:00 | SPY | ETF | 284.52 | 284.52 | 284.45 | 284.45 | 953.0 |
| 2019-04-01 05:30:00 | SPY | ETF | 284.49 | 284.49 | 284.47 | 284.49 | 600.0 |
| 2019-04-01 05:35:00 | SPY | ETF | 284.45 | 284.47 | 284.45 | 284.47 | 400.0 |
| 2019-04-01 05:40:00 | SPY | ETF | 284.44 | 284.57 | 284.44 | 284.57 | 1294.0 |
| 2019-04-01 05:45:00 | SPY | ETF | 284.54 | 284.54 | 284.4 | 284.4 | 1250.0 |
| 2019-04-01 05:50:00 | SPY | ETF | 284.42 | 284.45 | 284.4 | 284.45 | 2467.0 |
| 2019-04-01 05:55:00 | SPY | ETF | 284.4 | 284.45 | 284.4 | 284.41 | 788.0 |
| 2019-04-01 06:00:00 | SPY | ETF | 284.42 | 284.42 | 284.34 | 284.38 | 2702.0 |
| 2019-04-01 06:05:00 | SPY | ETF | 284.41 | 284.42 | 284.41 | 284.42 | 369.0 |
| 2019-04-01 06:10:00 | SPY | ETF | 284.43 | 284.48 | 284.43 | 284.48 | 418.0 |
| 2019-04-01 06:15:00 | SPY | ETF | 284.5 | 284.5 | 284.47 | 284.47 | 2900.0 |
| 2019-04-01 06:20:00 | SPY | ETF | 284.4 | 284.4 | 284.26 | 284.32 | 4364.0 |
| 2019-04-01 06:25:00 | SPY | ETF | 284.31 | 284.32 | 284.3 | 284.3 | 600.0 |
| 2019-04-01 06:30:00 | SPY | ETF | 284.32 | 284.35 | 284.32 | 284.35 | 580.0 |
| 2019-04-01 06:35:00 | SPY | ETF | 284.33 | 284.33 | 284.33 | 284.33 | 1200.0 |
| 2019-04-01 06:45:00 | SPY | ETF | 284.32 | 284.4 | 284.32 | 284.37 | 12677.0 |
| 2019-04-01 06:50:00 | SPY | ETF | 284.37 | 284.37 | 284.32 | 284.32 | 7250.0 |
| 2019-04-01 06:55:00 | SPY | ETF | 284.35 | 284.35 | 284.26 | 284.28 | 3325.0 |
| 2019-04-01 07:00:00 | SPY | ETF | 284.24 | 284.43 | 284.23 | 284.43 | 12695.0 |
| 2019-04-01 07:05:00 | SPY | ETF | 284.39 | 284.45 | 284.31 | 284.45 | 4382.0 |
| 2019-04-01 07:10:00 | SPY | ETF | 284.47 | 284.54 | 284.47 | 284.54 | 3631.0 |
| 2019-04-01 07:15:00 | SPY | ETF | 284.52 | 284.6 | 284.49 | 284.6 | 15450.0 |
| 2019-04-01 07:20:00 | SPY | ETF | 284.56 | 284.59 | 284.51 | 284.51 | 11346.0 |
| 2019-04-01 07:25:00 | SPY | ETF | 284.51 | 284.54 | 284.49 | 284.54 | 2770.0 |
| 2019-04-01 07:30:00 | SPY | ETF | 284.54 | 284.61 | 284.5 | 284.5 | 12189.0 |
| 2019-04-01 07:35:00 | SPY | ETF | 284.5 | 284.52 | 284.43 | 284.43 | 5001.0 |
| 2019-04-01 07:40:00 | SPY | ETF | 284.46 | 284.54 | 284.44 | 284.54 | 14175.0 |
| 2019-04-01 07:45:00 | SPY | ETF | 284.56 | 284.57 | 284.43 | 284.43 | 6891.0 |
| 2019-04-01 07:50:00 | SPY | ETF | 284.43 | 284.53 | 284.42 | 284.53 | 42300.0 |
| 2019-04-01 07:55:00 | SPY | ETF | 284.49 | 284.57 | 284.49 | 284.57 | 18412.0 |
| 2019-04-01 08:00:00 | SPY | ETF | 284.6 | 284.74 | 284.285 | 284.73 | 46614.0 |
| 2019-04-01 08:05:00 | SPY | ETF | 284.72 | 284.72 | 284.66 | 284.7 | 10025.0 |
| 2019-04-01 08:10:00 | SPY | ETF | 284.68 | 284.68 | 282.48 | 284.6 | 39826.0 |
| 2019-04-01 08:15:00 | SPY | ETF | 284.6 | 284.65 | 284.56 | 284.57 | 13597.0 |
> showing 50 of 66,984 rows — these rows as CSV