PREVIEW / etf_5min / 2020-05-13
file: by_date/etf_5min/2020/2020-05-13.parquet size: 1.7 MB rows: 79,520
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-05-13 04:00:00 | SPY | ETF | 285.68 | 285.7 | 285.24 | 285.28 | 21819.0 |
| 2020-05-13 04:05:00 | SPY | ETF | 285.48 | 285.74 | 285.46 | 285.74 | 7434.0 |
| 2020-05-13 04:10:00 | SPY | ETF | 285.79 | 286.0 | 285.79 | 286.0 | 9707.0 |
| 2020-05-13 04:15:00 | SPY | ETF | 286.17 | 286.18 | 286.0 | 286.0 | 12006.0 |
| 2020-05-13 04:20:00 | SPY | ETF | 286.16 | 286.36 | 286.14 | 286.14 | 6998.0 |
| 2020-05-13 04:25:00 | SPY | ETF | 286.15 | 286.2 | 285.98 | 286.2 | 6739.0 |
| 2020-05-13 04:30:00 | SPY | ETF | 286.26 | 286.45 | 286.19 | 286.44 | 14467.0 |
| 2020-05-13 04:35:00 | SPY | ETF | 286.46 | 286.59 | 286.32 | 286.46 | 13119.0 |
| 2020-05-13 04:40:00 | SPY | ETF | 286.38 | 286.38 | 286.15 | 286.22 | 9651.0 |
| 2020-05-13 04:45:00 | SPY | ETF | 286.19 | 286.19 | 285.95 | 285.98 | 3110.0 |
| 2020-05-13 04:50:00 | SPY | ETF | 286.01 | 286.01 | 285.58 | 285.62 | 12969.0 |
| 2020-05-13 04:55:00 | SPY | ETF | 285.65 | 285.76 | 285.46 | 285.55 | 6664.0 |
| 2020-05-13 05:00:00 | SPY | ETF | 285.39 | 285.51 | 285.26 | 285.32 | 4085.0 |
| 2020-05-13 05:05:00 | SPY | ETF | 285.47 | 285.93 | 285.46 | 285.93 | 4577.0 |
| 2020-05-13 05:10:00 | SPY | ETF | 286.05 | 286.05 | 285.78 | 285.84 | 10385.0 |
| 2020-05-13 05:15:00 | SPY | ETF | 285.74 | 286.3 | 285.7 | 286.2 | 14807.0 |
| 2020-05-13 05:20:00 | SPY | ETF | 286.21 | 286.41 | 286.18 | 286.3 | 4085.0 |
| 2020-05-13 05:25:00 | SPY | ETF | 286.2 | 286.3 | 285.99 | 285.99 | 8086.0 |
| 2020-05-13 05:30:00 | SPY | ETF | 285.96 | 286.14 | 285.82 | 286.14 | 22012.0 |
| 2020-05-13 05:35:00 | SPY | ETF | 286.23 | 286.47 | 286.23 | 286.39 | 12385.0 |
| 2020-05-13 05:40:00 | SPY | ETF | 286.48 | 286.5 | 286.32 | 286.4 | 4540.0 |
| 2020-05-13 05:45:00 | SPY | ETF | 286.43 | 286.75 | 286.43 | 286.74 | 15258.0 |
| 2020-05-13 05:50:00 | SPY | ETF | 286.77 | 287.24 | 286.72 | 287.2 | 20138.0 |
| 2020-05-13 05:55:00 | SPY | ETF | 287.19 | 287.19 | 286.93 | 286.98 | 15663.0 |
| 2020-05-13 06:00:00 | SPY | ETF | 286.9 | 287.66 | 286.89 | 287.52 | 38019.0 |
| 2020-05-13 06:05:00 | SPY | ETF | 287.48 | 287.48 | 287.26 | 287.32 | 11007.0 |
| 2020-05-13 06:10:00 | SPY | ETF | 287.42 | 287.48 | 287.29 | 287.35 | 9935.0 |
| 2020-05-13 06:15:00 | SPY | ETF | 287.36 | 287.36 | 287.14 | 287.2 | 12581.0 |
| 2020-05-13 06:20:00 | SPY | ETF | 287.33 | 287.5 | 287.33 | 287.41 | 41793.0 |
| 2020-05-13 06:25:00 | SPY | ETF | 287.4 | 287.49 | 287.4 | 287.43 | 27945.0 |
| 2020-05-13 06:30:00 | SPY | ETF | 287.38 | 287.42 | 287.13 | 287.13 | 59362.0 |
| 2020-05-13 06:35:00 | SPY | ETF | 287.13 | 287.22 | 287.08 | 287.2 | 8620.0 |
| 2020-05-13 06:40:00 | SPY | ETF | 287.18 | 287.2 | 287.1 | 287.16 | 41830.0 |
| 2020-05-13 06:45:00 | SPY | ETF | 287.1 | 287.1 | 286.92 | 286.96 | 26622.0 |
| 2020-05-13 06:50:00 | SPY | ETF | 287.02 | 287.05 | 287.02 | 287.04 | 6400.0 |
| 2020-05-13 06:55:00 | SPY | ETF | 287.04 | 287.21 | 287.04 | 287.21 | 13942.0 |
| 2020-05-13 07:00:00 | SPY | ETF | 287.3 | 287.34 | 287.05 | 287.07 | 103764.0 |
| 2020-05-13 07:05:00 | SPY | ETF | 287.15 | 287.16 | 286.85 | 286.9 | 21970.0 |
| 2020-05-13 07:10:00 | SPY | ETF | 286.89 | 287.0 | 286.85 | 287.0 | 21762.0 |
| 2020-05-13 07:15:00 | SPY | ETF | 286.99 | 287.05 | 286.93 | 286.99 | 37393.0 |
| 2020-05-13 07:20:00 | SPY | ETF | 286.99 | 287.16 | 286.98 | 287.13 | 23763.0 |
| 2020-05-13 07:25:00 | SPY | ETF | 287.12 | 287.31 | 287.11 | 287.21 | 37247.0 |
| 2020-05-13 07:30:00 | SPY | ETF | 287.25 | 287.44 | 287.25 | 287.4 | 58631.0 |
| 2020-05-13 07:35:00 | SPY | ETF | 287.4 | 287.41 | 287.13 | 287.22 | 40014.0 |
| 2020-05-13 07:40:00 | SPY | ETF | 287.24 | 287.37 | 287.18 | 287.37 | 26374.0 |
| 2020-05-13 07:45:00 | SPY | ETF | 287.37 | 287.71 | 287.37 | 287.63 | 105157.0 |
| 2020-05-13 07:50:00 | SPY | ETF | 287.71 | 287.79 | 287.6 | 287.6 | 44423.0 |
| 2020-05-13 07:55:00 | SPY | ETF | 287.65 | 287.94 | 287.63 | 287.64 | 89573.0 |
| 2020-05-13 08:00:00 | SPY | ETF | 287.62 | 287.92 | 285.0 | 285.3 | 148954.0 |
| 2020-05-13 08:05:00 | SPY | ETF | 287.61 | 287.62 | 287.3 | 287.36 | 48854.0 |
> showing 50 of 79,520 rows — these rows as CSV