PREVIEW / etf_5min / 2020-06-10
file: by_date/etf_5min/2020/2020-06-10.parquet size: 1.7 MB rows: 77,189
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-10 04:00:00 | SPY | ETF | 322.42 | 322.42 | 322.04 | 322.07 | 8739.0 |
| 2020-06-10 04:05:00 | SPY | ETF | 322.0 | 322.07 | 321.88 | 322.04 | 5181.0 |
| 2020-06-10 04:10:00 | SPY | ETF | 321.93 | 322.07 | 321.92 | 322.03 | 2219.0 |
| 2020-06-10 04:15:00 | SPY | ETF | 322.18 | 322.3 | 322.18 | 322.3 | 3241.0 |
| 2020-06-10 04:20:00 | SPY | ETF | 322.3 | 322.3 | 322.1 | 322.1 | 6921.0 |
| 2020-06-10 04:25:00 | SPY | ETF | 322.14 | 322.36 | 322.14 | 322.36 | 465.0 |
| 2020-06-10 04:30:00 | SPY | ETF | 322.26 | 322.45 | 322.26 | 322.45 | 8355.0 |
| 2020-06-10 04:35:00 | SPY | ETF | 322.4 | 322.47 | 322.36 | 322.37 | 3345.0 |
| 2020-06-10 04:40:00 | SPY | ETF | 322.33 | 322.33 | 322.18 | 322.18 | 2466.0 |
| 2020-06-10 04:45:00 | SPY | ETF | 322.1 | 322.12 | 321.98 | 321.98 | 3281.0 |
| 2020-06-10 04:50:00 | SPY | ETF | 321.88 | 321.88 | 321.83 | 321.83 | 751.0 |
| 2020-06-10 04:55:00 | SPY | ETF | 321.8 | 321.8 | 321.42 | 321.47 | 8786.0 |
| 2020-06-10 05:00:00 | SPY | ETF | 321.36 | 321.36 | 320.2 | 320.2 | 11160.0 |
| 2020-06-10 05:05:00 | SPY | ETF | 320.3 | 320.8 | 320.3 | 320.8 | 15466.0 |
| 2020-06-10 05:10:00 | SPY | ETF | 320.75 | 320.97 | 320.75 | 320.87 | 2318.0 |
| 2020-06-10 05:15:00 | SPY | ETF | 320.81 | 320.95 | 320.42 | 320.42 | 2925.0 |
| 2020-06-10 05:20:00 | SPY | ETF | 320.47 | 320.87 | 320.47 | 320.77 | 4464.0 |
| 2020-06-10 05:25:00 | SPY | ETF | 320.6 | 320.6 | 320.36 | 320.48 | 5934.0 |
| 2020-06-10 05:30:00 | SPY | ETF | 320.6 | 320.79 | 320.6 | 320.77 | 8478.0 |
| 2020-06-10 05:35:00 | SPY | ETF | 320.8 | 320.83 | 320.64 | 320.77 | 4000.0 |
| 2020-06-10 05:40:00 | SPY | ETF | 320.8 | 320.88 | 320.8 | 320.88 | 449.0 |
| 2020-06-10 05:45:00 | SPY | ETF | 320.82 | 320.82 | 320.4 | 320.5 | 1341.0 |
| 2020-06-10 05:50:00 | SPY | ETF | 320.65 | 320.65 | 320.55 | 320.6 | 2184.0 |
| 2020-06-10 05:55:00 | SPY | ETF | 320.62 | 320.72 | 320.52 | 320.7 | 3015.0 |
| 2020-06-10 06:00:00 | SPY | ETF | 320.61 | 320.61 | 320.31 | 320.4 | 4338.0 |
| 2020-06-10 06:05:00 | SPY | ETF | 320.37 | 320.37 | 319.8 | 319.92 | 19089.0 |
| 2020-06-10 06:10:00 | SPY | ETF | 320.0 | 320.05 | 319.75 | 319.83 | 9232.0 |
| 2020-06-10 06:15:00 | SPY | ETF | 319.68 | 320.1 | 319.6 | 319.87 | 14586.0 |
| 2020-06-10 06:20:00 | SPY | ETF | 319.89 | 320.15 | 319.89 | 320.15 | 8199.0 |
| 2020-06-10 06:25:00 | SPY | ETF | 320.08 | 320.25 | 320.0 | 320.1 | 8316.0 |
| 2020-06-10 06:30:00 | SPY | ETF | 320.12 | 320.53 | 320.12 | 320.4 | 34777.0 |
| 2020-06-10 06:35:00 | SPY | ETF | 320.27 | 320.56 | 320.19 | 320.56 | 5048.0 |
| 2020-06-10 06:40:00 | SPY | ETF | 320.57 | 320.66 | 320.56 | 320.56 | 2720.0 |
| 2020-06-10 06:45:00 | SPY | ETF | 320.86 | 320.88 | 320.63 | 320.78 | 3736.0 |
| 2020-06-10 06:50:00 | SPY | ETF | 320.75 | 321.0 | 320.75 | 321.0 | 14013.0 |
| 2020-06-10 06:55:00 | SPY | ETF | 321.0 | 321.0 | 320.88 | 320.94 | 6988.0 |
| 2020-06-10 07:00:00 | SPY | ETF | 320.85 | 321.07 | 320.83 | 320.97 | 23064.0 |
| 2020-06-10 07:05:00 | SPY | ETF | 320.95 | 321.1 | 320.9 | 321.03 | 26935.0 |
| 2020-06-10 07:10:00 | SPY | ETF | 320.99 | 321.11 | 320.82 | 321.11 | 9406.0 |
| 2020-06-10 07:15:00 | SPY | ETF | 321.209 | 321.209 | 320.98 | 321.08 | 16464.0 |
| 2020-06-10 07:20:00 | SPY | ETF | 321.1 | 321.22 | 320.95 | 321.16 | 3911.0 |
| 2020-06-10 07:25:00 | SPY | ETF | 321.2 | 321.28 | 320.65 | 320.77 | 71462.0 |
| 2020-06-10 07:30:00 | SPY | ETF | 320.79 | 320.96 | 320.79 | 320.95 | 37533.0 |
| 2020-06-10 07:35:00 | SPY | ETF | 321.02 | 321.26 | 321.02 | 321.24 | 11427.0 |
| 2020-06-10 07:40:00 | SPY | ETF | 321.26 | 321.26 | 321.0 | 321.0 | 10884.0 |
| 2020-06-10 07:45:00 | SPY | ETF | 320.98 | 321.25 | 320.98 | 321.25 | 19573.0 |
| 2020-06-10 07:50:00 | SPY | ETF | 321.25 | 321.25 | 321.14 | 321.22 | 8643.0 |
| 2020-06-10 07:55:00 | SPY | ETF | 321.3 | 321.82 | 321.3 | 321.75 | 86683.0 |
| 2020-06-10 08:00:00 | SPY | ETF | 321.2299 | 322.71 | 319.9996 | 321.7 | 99987.0 |
| 2020-06-10 08:05:00 | SPY | ETF | 321.77 | 321.97 | 321.67 | 321.73 | 69573.0 |
> showing 50 of 77,189 rows — these rows as CSV