PREVIEW / etf_5min / 2018-10-11
file: by_date/etf_5min/2018/2018-10-11.parquet size: 1.7 MB rows: 71,901
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 |
|---|---|---|---|---|---|---|---|
| 2018-10-11 04:00:00 | SPY | ETF | 275.29 | 275.29 | 274.85 | 275.14 | 19685.0 |
| 2018-10-11 04:05:00 | SPY | ETF | 275.17 | 275.24 | 275.06 | 275.06 | 9905.0 |
| 2018-10-11 04:10:00 | SPY | ETF | 275.1 | 275.1 | 274.81 | 274.85 | 25424.0 |
| 2018-10-11 04:15:00 | SPY | ETF | 274.89 | 274.95 | 274.5 | 274.74 | 52978.0 |
| 2018-10-11 04:20:00 | SPY | ETF | 274.85 | 275.2 | 274.85 | 275.2 | 16775.0 |
| 2018-10-11 04:25:00 | SPY | ETF | 275.05 | 275.35 | 275.05 | 275.3 | 7116.0 |
| 2018-10-11 04:30:00 | SPY | ETF | 275.27 | 275.27 | 275.15 | 275.15 | 1520.0 |
| 2018-10-11 04:35:00 | SPY | ETF | 275.13 | 275.36 | 275.13 | 275.36 | 7684.0 |
| 2018-10-11 04:40:00 | SPY | ETF | 275.3 | 275.3 | 275.18 | 275.18 | 11380.0 |
| 2018-10-11 04:45:00 | SPY | ETF | 275.11 | 275.15 | 274.75 | 274.75 | 23170.0 |
| 2018-10-11 04:50:00 | SPY | ETF | 274.76 | 274.82 | 274.57 | 274.57 | 13439.0 |
| 2018-10-11 04:55:00 | SPY | ETF | 274.7 | 274.7 | 274.45 | 274.65 | 51123.0 |
| 2018-10-11 05:00:00 | SPY | ETF | 274.57 | 274.62 | 274.35 | 274.35 | 29790.0 |
| 2018-10-11 05:05:00 | SPY | ETF | 274.36 | 274.36 | 274.01 | 274.01 | 44904.0 |
| 2018-10-11 05:10:00 | SPY | ETF | 274.0 | 274.35 | 273.82 | 274.18 | 71795.0 |
| 2018-10-11 05:15:00 | SPY | ETF | 274.26 | 274.49 | 274.07 | 274.33 | 33801.0 |
| 2018-10-11 05:20:00 | SPY | ETF | 274.46 | 274.56 | 274.37 | 274.56 | 22682.0 |
| 2018-10-11 05:25:00 | SPY | ETF | 274.57 | 274.85 | 274.53 | 274.8 | 57100.0 |
| 2018-10-11 05:30:00 | SPY | ETF | 274.73 | 274.76 | 274.55 | 274.76 | 8900.0 |
| 2018-10-11 05:35:00 | SPY | ETF | 274.55 | 274.55 | 274.34 | 274.51 | 4550.0 |
| 2018-10-11 05:40:00 | SPY | ETF | 274.51 | 274.98 | 274.51 | 274.8 | 29593.0 |
| 2018-10-11 05:45:00 | SPY | ETF | 274.93 | 275.03 | 274.85 | 274.95 | 12849.0 |
| 2018-10-11 05:50:00 | SPY | ETF | 274.9 | 275.22 | 274.9 | 275.18 | 21615.0 |
| 2018-10-11 05:55:00 | SPY | ETF | 275.18 | 275.18 | 274.8 | 275.0 | 29562.0 |
| 2018-10-11 06:00:00 | SPY | ETF | 274.93 | 275.39 | 274.93 | 275.21 | 14547.0 |
| 2018-10-11 06:05:00 | SPY | ETF | 275.21 | 275.33 | 275.09 | 275.09 | 8030.0 |
| 2018-10-11 06:10:00 | SPY | ETF | 275.16 | 275.16 | 274.87 | 274.91 | 14199.0 |
| 2018-10-11 06:15:00 | SPY | ETF | 274.85 | 275.02 | 274.75 | 274.89 | 17101.0 |
| 2018-10-11 06:20:00 | SPY | ETF | 274.83 | 275.0 | 274.8 | 274.91 | 26201.0 |
| 2018-10-11 06:25:00 | SPY | ETF | 274.82 | 274.91 | 274.66 | 274.86 | 24814.0 |
| 2018-10-11 06:30:00 | SPY | ETF | 274.87 | 274.92 | 274.71 | 274.73 | 8117.0 |
| 2018-10-11 06:35:00 | SPY | ETF | 274.7 | 274.83 | 274.64 | 274.7 | 18783.0 |
| 2018-10-11 06:40:00 | SPY | ETF | 274.68 | 274.68 | 274.5 | 274.53 | 42217.0 |
| 2018-10-11 06:45:00 | SPY | ETF | 274.52 | 274.95 | 274.5 | 274.95 | 18854.0 |
| 2018-10-11 06:50:00 | SPY | ETF | 274.89 | 275.06 | 274.89 | 274.91 | 40150.0 |
| 2018-10-11 06:55:00 | SPY | ETF | 275.04 | 275.16 | 275.0 | 275.08 | 15192.0 |
| 2018-10-11 07:00:00 | SPY | ETF | 275.08 | 275.21 | 275.01 | 275.09 | 170947.0 |
| 2018-10-11 07:05:00 | SPY | ETF | 275.15 | 275.17 | 274.98 | 275.05 | 156928.0 |
| 2018-10-11 07:10:00 | SPY | ETF | 275.04 | 275.26 | 274.92 | 275.0 | 61021.0 |
| 2018-10-11 07:15:00 | SPY | ETF | 275.01 | 275.3 | 274.99 | 275.21 | 107323.0 |
| 2018-10-11 07:20:00 | SPY | ETF | 275.23 | 275.43 | 275.12 | 275.37 | 161273.0 |
| 2018-10-11 07:25:00 | SPY | ETF | 275.38 | 275.43 | 275.14 | 275.21 | 103627.0 |
| 2018-10-11 07:30:00 | SPY | ETF | 275.21 | 275.28 | 274.73 | 274.86 | 132566.0 |
| 2018-10-11 07:35:00 | SPY | ETF | 274.9 | 274.93 | 274.72 | 274.85 | 73152.0 |
| 2018-10-11 07:40:00 | SPY | ETF | 274.88 | 275.2 | 274.88 | 275.18 | 104382.0 |
| 2018-10-11 07:45:00 | SPY | ETF | 275.22 | 275.64 | 275.22 | 275.64 | 108491.0 |
| 2018-10-11 07:50:00 | SPY | ETF | 275.63 | 276.06 | 275.57 | 275.94 | 293637.0 |
| 2018-10-11 07:55:00 | SPY | ETF | 275.94 | 275.97 | 275.68 | 275.77 | 89911.0 |
| 2018-10-11 08:00:00 | SPY | ETF | 275.0 | 277.97 | 274.01 | 275.77 | 700010.0 |
| 2018-10-11 08:05:00 | SPY | ETF | 275.74 | 276.08 | 275.71 | 276.08 | 144217.0 |
> showing 50 of 71,901 rows — these rows as CSV