PREVIEW / etf_5min / 2020-10-05
file: by_date/etf_5min/2020/2020-10-05.parquet size: 1.6 MB rows: 73,786
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-10-05 04:00:00 | SPY | ETF | 335.19 | 335.53 | 335.02 | 335.48 | 22589.0 |
| 2020-10-05 04:05:00 | SPY | ETF | 335.46 | 335.5 | 335.36 | 335.5 | 2054.0 |
| 2020-10-05 04:10:00 | SPY | ETF | 335.48 | 335.7 | 335.48 | 335.7 | 5672.0 |
| 2020-10-05 04:15:00 | SPY | ETF | 335.74 | 335.77 | 335.65 | 335.76 | 17907.0 |
| 2020-10-05 04:20:00 | SPY | ETF | 335.7 | 335.7 | 335.5 | 335.5 | 1860.0 |
| 2020-10-05 04:25:00 | SPY | ETF | 335.53 | 335.53 | 335.5 | 335.5 | 300.0 |
| 2020-10-05 04:30:00 | SPY | ETF | 335.53 | 335.53 | 335.53 | 335.53 | 111.0 |
| 2020-10-05 04:35:00 | SPY | ETF | 335.67 | 335.71 | 335.67 | 335.71 | 331.0 |
| 2020-10-05 04:40:00 | SPY | ETF | 335.71 | 335.71 | 335.71 | 335.71 | 101.0 |
| 2020-10-05 04:45:00 | SPY | ETF | 335.75 | 335.75 | 335.75 | 335.75 | 127.0 |
| 2020-10-05 04:50:00 | SPY | ETF | 335.45 | 335.53 | 335.45 | 335.53 | 6161.0 |
| 2020-10-05 04:55:00 | SPY | ETF | 335.53 | 335.69 | 335.5 | 335.68 | 5507.0 |
| 2020-10-05 05:00:00 | SPY | ETF | 335.41 | 335.57 | 335.41 | 335.57 | 202.0 |
| 2020-10-05 05:05:00 | SPY | ETF | 335.76 | 335.83 | 335.76 | 335.77 | 2459.0 |
| 2020-10-05 05:10:00 | SPY | ETF | 335.74 | 335.74 | 335.65 | 335.65 | 700.0 |
| 2020-10-05 05:15:00 | SPY | ETF | 335.43 | 335.43 | 335.43 | 335.43 | 210.0 |
| 2020-10-05 05:25:00 | SPY | ETF | 335.73 | 335.75 | 335.73 | 335.74 | 854.0 |
| 2020-10-05 05:30:00 | SPY | ETF | 335.65 | 335.65 | 335.63 | 335.65 | 10000.0 |
| 2020-10-05 05:35:00 | SPY | ETF | 335.82 | 335.96 | 335.81 | 335.94 | 2564.0 |
| 2020-10-05 05:40:00 | SPY | ETF | 335.98 | 336.1 | 335.98 | 336.0 | 3824.0 |
| 2020-10-05 05:45:00 | SPY | ETF | 335.96 | 336.12 | 335.96 | 336.12 | 2852.0 |
| 2020-10-05 05:50:00 | SPY | ETF | 336.08 | 336.08 | 335.97 | 335.97 | 1245.0 |
| 2020-10-05 05:55:00 | SPY | ETF | 335.97 | 336.13 | 335.97 | 336.13 | 1016.0 |
| 2020-10-05 06:00:00 | SPY | ETF | 336.03 | 336.03 | 336.01 | 336.01 | 600.0 |
| 2020-10-05 06:05:00 | SPY | ETF | 335.86 | 335.86 | 335.76 | 335.76 | 615.0 |
| 2020-10-05 06:10:00 | SPY | ETF | 335.66 | 335.66 | 335.66 | 335.66 | 102.0 |
| 2020-10-05 06:15:00 | SPY | ETF | 335.71 | 335.71 | 335.65 | 335.65 | 702.0 |
| 2020-10-05 06:20:00 | SPY | ETF | 335.71 | 335.81 | 335.71 | 335.8 | 5315.0 |
| 2020-10-05 06:25:00 | SPY | ETF | 335.78 | 335.78 | 335.73 | 335.73 | 441.0 |
| 2020-10-05 06:30:00 | SPY | ETF | 335.8 | 335.82 | 335.8 | 335.82 | 1610.0 |
| 2020-10-05 06:35:00 | SPY | ETF | 335.87 | 335.93 | 335.87 | 335.91 | 1286.0 |
| 2020-10-05 06:40:00 | SPY | ETF | 335.9 | 336.0 | 335.86 | 335.86 | 7451.0 |
| 2020-10-05 06:45:00 | SPY | ETF | 335.89 | 336.06 | 335.89 | 336.06 | 5942.0 |
| 2020-10-05 06:50:00 | SPY | ETF | 336.08 | 336.13 | 336.03 | 336.03 | 6676.0 |
| 2020-10-05 06:55:00 | SPY | ETF | 336.06 | 336.3 | 336.06 | 336.3 | 2503.0 |
| 2020-10-05 07:00:00 | SPY | ETF | 336.31 | 336.47 | 336.2 | 336.42 | 40757.0 |
| 2020-10-05 07:05:00 | SPY | ETF | 336.45 | 336.67 | 336.45 | 336.63 | 27648.0 |
| 2020-10-05 07:10:00 | SPY | ETF | 336.63 | 336.64 | 336.47 | 336.51 | 8624.0 |
| 2020-10-05 07:15:00 | SPY | ETF | 336.54 | 336.55 | 336.24 | 336.25 | 30315.0 |
| 2020-10-05 07:20:00 | SPY | ETF | 336.26 | 336.26 | 336.13 | 336.14 | 8408.0 |
| 2020-10-05 07:25:00 | SPY | ETF | 336.1 | 336.17 | 336.05 | 336.17 | 18083.0 |
| 2020-10-05 07:30:00 | SPY | ETF | 336.18 | 336.36 | 336.14 | 336.31 | 23315.0 |
| 2020-10-05 07:35:00 | SPY | ETF | 336.23 | 336.4 | 336.23 | 336.4 | 2304.0 |
| 2020-10-05 07:40:00 | SPY | ETF | 336.4 | 336.48 | 336.28 | 336.34 | 6077.0 |
| 2020-10-05 07:45:00 | SPY | ETF | 336.35 | 336.44 | 336.34 | 336.4 | 74824.0 |
| 2020-10-05 07:50:00 | SPY | ETF | 336.42 | 336.43 | 336.16 | 336.17 | 12528.0 |
| 2020-10-05 07:55:00 | SPY | ETF | 336.11 | 336.26 | 336.1 | 336.1 | 6045.0 |
| 2020-10-05 08:00:00 | SPY | ETF | 335.9796 | 336.65 | 335.2 | 336.07 | 42819.0 |
| 2020-10-05 08:05:00 | SPY | ETF | 336.09 | 336.19 | 336.09 | 336.13 | 3203.0 |
| 2020-10-05 08:10:00 | SPY | ETF | 336.17 | 336.22 | 336.06 | 336.13 | 7621.0 |
> showing 50 of 73,786 rows — these rows as CSV