PREVIEW / etf_5min / 2020-12-10
file: by_date/etf_5min/2020/2020-12-10.parquet size: 1.6 MB rows: 77,524
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-12-10 04:00:00 | SPY | ETF | 367.1 | 367.34 | 367.1 | 367.34 | 3345.0 |
| 2020-12-10 04:05:00 | SPY | ETF | 367.55 | 367.83 | 367.51 | 367.83 | 7758.0 |
| 2020-12-10 04:10:00 | SPY | ETF | 367.8 | 367.8 | 367.73 | 367.73 | 287.0 |
| 2020-12-10 04:15:00 | SPY | ETF | 367.78 | 367.83 | 367.78 | 367.78 | 495.0 |
| 2020-12-10 04:20:00 | SPY | ETF | 367.78 | 367.86 | 367.77 | 367.86 | 1148.0 |
| 2020-12-10 04:25:00 | SPY | ETF | 367.76 | 367.96 | 367.76 | 367.95 | 3700.0 |
| 2020-12-10 04:35:00 | SPY | ETF | 367.96 | 368.09 | 367.77 | 367.77 | 1459.0 |
| 2020-12-10 04:40:00 | SPY | ETF | 367.77 | 367.77 | 367.77 | 367.77 | 700.0 |
| 2020-12-10 04:45:00 | SPY | ETF | 367.72 | 367.83 | 367.71 | 367.76 | 2158.0 |
| 2020-12-10 04:50:00 | SPY | ETF | 367.73 | 367.73 | 367.72 | 367.72 | 5199.0 |
| 2020-12-10 05:00:00 | SPY | ETF | 367.66 | 367.66 | 367.66 | 367.66 | 100.0 |
| 2020-12-10 05:05:00 | SPY | ETF | 367.83 | 367.83 | 367.83 | 367.83 | 1628.0 |
| 2020-12-10 05:10:00 | SPY | ETF | 367.83 | 367.83 | 367.83 | 367.83 | 300.0 |
| 2020-12-10 05:15:00 | SPY | ETF | 367.73 | 367.81 | 367.67 | 367.68 | 600.0 |
| 2020-12-10 05:20:00 | SPY | ETF | 367.67 | 367.71 | 367.64 | 367.71 | 2220.0 |
| 2020-12-10 05:25:00 | SPY | ETF | 367.77 | 367.89 | 367.77 | 367.89 | 6877.0 |
| 2020-12-10 05:30:00 | SPY | ETF | 367.88 | 367.93 | 367.83 | 367.83 | 590.0 |
| 2020-12-10 05:35:00 | SPY | ETF | 367.88 | 367.92 | 367.88 | 367.92 | 900.0 |
| 2020-12-10 05:40:00 | SPY | ETF | 367.9 | 367.9 | 367.78 | 367.78 | 1387.0 |
| 2020-12-10 05:45:00 | SPY | ETF | 367.79 | 367.86 | 367.79 | 367.85 | 1344.0 |
| 2020-12-10 05:50:00 | SPY | ETF | 367.83 | 367.83 | 367.74 | 367.77 | 1137.0 |
| 2020-12-10 05:55:00 | SPY | ETF | 367.76 | 367.76 | 367.71 | 367.71 | 1390.0 |
| 2020-12-10 06:00:00 | SPY | ETF | 367.73 | 367.78 | 367.71 | 367.71 | 536.0 |
| 2020-12-10 06:05:00 | SPY | ETF | 367.7 | 367.73 | 367.64 | 367.67 | 3312.0 |
| 2020-12-10 06:10:00 | SPY | ETF | 367.67 | 367.68 | 367.62 | 367.62 | 1240.0 |
| 2020-12-10 06:15:00 | SPY | ETF | 367.59 | 367.6 | 367.39 | 367.49 | 2094.0 |
| 2020-12-10 06:20:00 | SPY | ETF | 367.47 | 367.56 | 367.45 | 367.52 | 21094.0 |
| 2020-12-10 06:30:00 | SPY | ETF | 367.65 | 367.66 | 367.65 | 367.65 | 10020.0 |
| 2020-12-10 06:35:00 | SPY | ETF | 367.61 | 367.61 | 367.47 | 367.53 | 10765.0 |
| 2020-12-10 06:40:00 | SPY | ETF | 367.56 | 367.6 | 367.56 | 367.58 | 2338.0 |
| 2020-12-10 06:45:00 | SPY | ETF | 367.56 | 367.56 | 367.35 | 367.38 | 2825.0 |
| 2020-12-10 06:50:00 | SPY | ETF | 367.41 | 367.51 | 367.41 | 367.46 | 851.0 |
| 2020-12-10 06:55:00 | SPY | ETF | 367.51 | 367.54 | 367.51 | 367.52 | 8708.0 |
| 2020-12-10 07:00:00 | SPY | ETF | 367.56 | 367.58 | 367.23 | 367.25 | 73283.0 |
| 2020-12-10 07:05:00 | SPY | ETF | 367.25 | 367.3 | 367.15 | 367.15 | 57386.0 |
| 2020-12-10 07:10:00 | SPY | ETF | 367.18 | 367.18 | 366.88 | 366.95 | 65215.0 |
| 2020-12-10 07:15:00 | SPY | ETF | 366.94 | 366.97 | 366.89 | 366.89 | 5224.0 |
| 2020-12-10 07:20:00 | SPY | ETF | 366.8 | 366.86 | 366.47 | 366.62 | 20224.0 |
| 2020-12-10 07:25:00 | SPY | ETF | 366.61 | 366.64 | 366.38 | 366.42 | 22260.0 |
| 2020-12-10 07:30:00 | SPY | ETF | 366.51 | 366.55 | 366.24 | 366.24 | 33222.0 |
| 2020-12-10 07:35:00 | SPY | ETF | 366.3 | 366.3 | 366.18 | 366.25 | 18814.0 |
| 2020-12-10 07:40:00 | SPY | ETF | 366.29 | 366.47 | 366.24 | 366.36 | 21121.0 |
| 2020-12-10 07:45:00 | SPY | ETF | 366.4 | 366.64 | 366.37 | 366.51 | 35109.0 |
| 2020-12-10 07:50:00 | SPY | ETF | 366.58 | 366.62 | 366.4 | 366.6 | 25476.0 |
| 2020-12-10 07:55:00 | SPY | ETF | 366.54 | 366.58 | 366.43 | 366.49 | 6664.0 |
| 2020-12-10 08:00:00 | SPY | ETF | 366.44 | 367.87 | 366.24 | 366.7 | 91460.0 |
| 2020-12-10 08:05:00 | SPY | ETF | 366.74 | 366.74 | 366.59 | 366.66 | 47668.0 |
| 2020-12-10 08:10:00 | SPY | ETF | 366.72 | 366.9 | 366.55 | 366.55 | 23092.0 |
| 2020-12-10 08:15:00 | SPY | ETF | 366.53 | 366.53 | 366.34 | 366.34 | 20848.0 |
| 2020-12-10 08:20:00 | SPY | ETF | 366.41 | 366.58 | 366.41 | 366.48 | 31671.0 |
> showing 50 of 77,524 rows — these rows as CSV