PREVIEW / etf_5min / 2020-06-03
file: by_date/etf_5min/2020/2020-06-03.parquet size: 1.7 MB rows: 79,636
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-03 04:00:00 | SPY | ETF | 309.25 | 309.35 | 309.12 | 309.32 | 3891.0 |
| 2020-06-03 04:05:00 | SPY | ETF | 309.33 | 309.33 | 309.03 | 309.03 | 2879.0 |
| 2020-06-03 04:10:00 | SPY | ETF | 309.02 | 309.02 | 308.9 | 308.98 | 4066.0 |
| 2020-06-03 04:15:00 | SPY | ETF | 308.86 | 308.86 | 308.84 | 308.84 | 2072.0 |
| 2020-06-03 04:20:00 | SPY | ETF | 309.03 | 309.13 | 309.0 | 309.13 | 2317.0 |
| 2020-06-03 04:30:00 | SPY | ETF | 309.13 | 309.41 | 309.08 | 309.41 | 1912.0 |
| 2020-06-03 04:35:00 | SPY | ETF | 309.36 | 309.36 | 309.06 | 309.08 | 6088.0 |
| 2020-06-03 04:40:00 | SPY | ETF | 309.13 | 309.13 | 309.08 | 309.08 | 600.0 |
| 2020-06-03 04:45:00 | SPY | ETF | 309.16 | 309.22 | 309.03 | 309.06 | 4150.0 |
| 2020-06-03 04:50:00 | SPY | ETF | 309.11 | 309.13 | 309.11 | 309.13 | 1190.0 |
| 2020-06-03 04:55:00 | SPY | ETF | 309.25 | 309.36 | 309.25 | 309.36 | 1000.0 |
| 2020-06-03 05:00:00 | SPY | ETF | 309.17 | 309.17 | 309.17 | 309.17 | 109.0 |
| 2020-06-03 05:05:00 | SPY | ETF | 309.21 | 309.27 | 309.21 | 309.26 | 330.0 |
| 2020-06-03 05:10:00 | SPY | ETF | 309.28 | 309.35 | 309.28 | 309.35 | 2560.0 |
| 2020-06-03 05:15:00 | SPY | ETF | 309.35 | 309.35 | 309.3 | 309.3 | 939.0 |
| 2020-06-03 05:20:00 | SPY | ETF | 309.23 | 309.49 | 309.23 | 309.49 | 4222.0 |
| 2020-06-03 05:25:00 | SPY | ETF | 309.43 | 309.54 | 309.43 | 309.46 | 8575.0 |
| 2020-06-03 05:30:00 | SPY | ETF | 309.74 | 309.8 | 309.63 | 309.63 | 14908.0 |
| 2020-06-03 05:35:00 | SPY | ETF | 309.73 | 309.73 | 309.66 | 309.66 | 1292.0 |
| 2020-06-03 05:40:00 | SPY | ETF | 309.71 | 309.76 | 309.51 | 309.51 | 10845.0 |
| 2020-06-03 05:45:00 | SPY | ETF | 309.63 | 309.66 | 309.56 | 309.61 | 2627.0 |
| 2020-06-03 05:50:00 | SPY | ETF | 309.71 | 309.81 | 309.68 | 309.81 | 1235.0 |
| 2020-06-03 05:55:00 | SPY | ETF | 309.73 | 309.73 | 309.63 | 309.65 | 2616.0 |
| 2020-06-03 06:00:00 | SPY | ETF | 309.65 | 309.65 | 309.29 | 309.3 | 10018.0 |
| 2020-06-03 06:05:00 | SPY | ETF | 309.28 | 309.33 | 309.14 | 309.31 | 7854.0 |
| 2020-06-03 06:10:00 | SPY | ETF | 309.31 | 309.68 | 309.31 | 309.6 | 5032.0 |
| 2020-06-03 06:15:00 | SPY | ETF | 309.5 | 309.5 | 309.44 | 309.44 | 3122.0 |
| 2020-06-03 06:20:00 | SPY | ETF | 309.41 | 309.54 | 309.41 | 309.54 | 906.0 |
| 2020-06-03 06:25:00 | SPY | ETF | 309.42 | 309.53 | 309.41 | 309.5 | 4120.0 |
| 2020-06-03 06:30:00 | SPY | ETF | 309.58 | 309.58 | 309.49 | 309.5 | 2500.0 |
| 2020-06-03 06:35:00 | SPY | ETF | 309.45 | 309.5 | 309.4 | 309.41 | 4481.0 |
| 2020-06-03 06:40:00 | SPY | ETF | 309.44 | 309.48 | 309.42 | 309.44 | 1110.0 |
| 2020-06-03 06:45:00 | SPY | ETF | 309.48 | 309.53 | 309.46 | 309.46 | 600.0 |
| 2020-06-03 06:50:00 | SPY | ETF | 309.4 | 309.41 | 309.29 | 309.29 | 8269.0 |
| 2020-06-03 06:55:00 | SPY | ETF | 309.31 | 309.54 | 309.0 | 309.19 | 14394.0 |
| 2020-06-03 07:00:00 | SPY | ETF | 309.14 | 309.27 | 309.1 | 309.24 | 32013.0 |
| 2020-06-03 07:05:00 | SPY | ETF | 309.2 | 309.27 | 309.16 | 309.25 | 10334.0 |
| 2020-06-03 07:10:00 | SPY | ETF | 309.25 | 309.4 | 309.25 | 309.36 | 20282.0 |
| 2020-06-03 07:15:00 | SPY | ETF | 309.35 | 309.45 | 309.34 | 309.41 | 17902.0 |
| 2020-06-03 07:20:00 | SPY | ETF | 309.4 | 309.4 | 309.08 | 309.24 | 22973.0 |
| 2020-06-03 07:25:00 | SPY | ETF | 309.24 | 309.27 | 309.17 | 309.24 | 16610.0 |
| 2020-06-03 07:30:00 | SPY | ETF | 309.24 | 309.24 | 309.07 | 309.07 | 23817.0 |
| 2020-06-03 07:35:00 | SPY | ETF | 309.1 | 309.25 | 309.02 | 309.21 | 10217.0 |
| 2020-06-03 07:40:00 | SPY | ETF | 309.24 | 309.3 | 309.2 | 309.3 | 8216.0 |
| 2020-06-03 07:45:00 | SPY | ETF | 309.3 | 309.44 | 309.3 | 309.43 | 17428.0 |
| 2020-06-03 07:50:00 | SPY | ETF | 309.44 | 309.59 | 309.44 | 309.59 | 40347.0 |
| 2020-06-03 07:55:00 | SPY | ETF | 309.59 | 309.69 | 309.48 | 309.48 | 26936.0 |
| 2020-06-03 08:00:00 | SPY | ETF | 309.2145 | 309.65 | 308.75 | 309.46 | 62805.0 |
| 2020-06-03 08:05:00 | SPY | ETF | 309.39 | 309.52 | 309.34 | 309.42 | 45253.0 |
| 2020-06-03 08:10:00 | SPY | ETF | 309.4 | 309.65 | 309.4 | 309.61 | 40724.0 |
> showing 50 of 79,636 rows — these rows as CSV