PREVIEW / etf_5min / 2020-07-10
file: by_date/etf_5min/2020/2020-07-10.parquet size: 1.6 MB rows: 73,232
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-07-10 04:00:00 | SPY | ETF | 312.64 | 313.32 | 312.64 | 313.25 | 9069.0 |
| 2020-07-10 04:05:00 | SPY | ETF | 313.15 | 313.35 | 313.05 | 313.28 | 2432.0 |
| 2020-07-10 04:10:00 | SPY | ETF | 313.28 | 313.4 | 313.11 | 313.18 | 11061.0 |
| 2020-07-10 04:15:00 | SPY | ETF | 313.43 | 313.54 | 313.41 | 313.41 | 4200.0 |
| 2020-07-10 04:20:00 | SPY | ETF | 313.26 | 313.26 | 313.26 | 313.26 | 200.0 |
| 2020-07-10 04:25:00 | SPY | ETF | 313.45 | 313.45 | 313.45 | 313.45 | 335.0 |
| 2020-07-10 04:30:00 | SPY | ETF | 313.2 | 313.2 | 312.93 | 312.93 | 2433.0 |
| 2020-07-10 04:35:00 | SPY | ETF | 313.01 | 313.01 | 312.82 | 312.86 | 2422.0 |
| 2020-07-10 04:40:00 | SPY | ETF | 312.95 | 312.95 | 312.95 | 312.95 | 121.0 |
| 2020-07-10 04:45:00 | SPY | ETF | 313.14 | 313.14 | 312.61 | 312.62 | 1732.0 |
| 2020-07-10 04:50:00 | SPY | ETF | 312.66 | 312.66 | 312.45 | 312.48 | 10877.0 |
| 2020-07-10 04:55:00 | SPY | ETF | 312.5 | 312.5 | 312.49 | 312.49 | 1200.0 |
| 2020-07-10 05:00:00 | SPY | ETF | 312.6 | 312.75 | 312.43 | 312.55 | 4815.0 |
| 2020-07-10 05:05:00 | SPY | ETF | 312.78 | 312.78 | 312.25 | 312.25 | 2429.0 |
| 2020-07-10 05:10:00 | SPY | ETF | 312.21 | 312.21 | 312.02 | 312.16 | 4712.0 |
| 2020-07-10 05:15:00 | SPY | ETF | 312.27 | 312.32 | 312.27 | 312.32 | 381.0 |
| 2020-07-10 05:20:00 | SPY | ETF | 312.25 | 312.49 | 312.25 | 312.49 | 4075.0 |
| 2020-07-10 05:25:00 | SPY | ETF | 312.57 | 312.59 | 312.48 | 312.59 | 1434.0 |
| 2020-07-10 05:30:00 | SPY | ETF | 312.56 | 312.81 | 312.56 | 312.72 | 5132.0 |
| 2020-07-10 05:35:00 | SPY | ETF | 312.8 | 312.8 | 312.74 | 312.74 | 1744.0 |
| 2020-07-10 05:40:00 | SPY | ETF | 312.86 | 312.89 | 312.86 | 312.89 | 2001.0 |
| 2020-07-10 05:45:00 | SPY | ETF | 312.79 | 312.79 | 312.7 | 312.7 | 1016.0 |
| 2020-07-10 05:50:00 | SPY | ETF | 312.89 | 312.97 | 312.89 | 312.97 | 737.0 |
| 2020-07-10 05:55:00 | SPY | ETF | 312.99 | 312.99 | 312.92 | 312.92 | 3953.0 |
| 2020-07-10 06:00:00 | SPY | ETF | 312.94 | 313.08 | 312.9 | 313.03 | 3764.0 |
| 2020-07-10 06:05:00 | SPY | ETF | 313.0 | 313.07 | 312.97 | 313.0 | 2351.0 |
| 2020-07-10 06:10:00 | SPY | ETF | 313.05 | 313.12 | 312.86 | 312.86 | 6638.0 |
| 2020-07-10 06:15:00 | SPY | ETF | 312.97 | 312.97 | 312.73 | 312.73 | 12592.0 |
| 2020-07-10 06:20:00 | SPY | ETF | 312.71 | 312.76 | 312.6 | 312.65 | 106114.0 |
| 2020-07-10 06:25:00 | SPY | ETF | 312.77 | 312.77 | 312.63 | 312.66 | 1813.0 |
| 2020-07-10 06:30:00 | SPY | ETF | 312.73 | 312.93 | 312.73 | 312.88 | 6287.0 |
| 2020-07-10 06:35:00 | SPY | ETF | 313.0 | 313.1 | 312.98 | 313.1 | 7091.0 |
| 2020-07-10 06:40:00 | SPY | ETF | 313.11 | 313.23 | 313.1 | 313.16 | 6591.0 |
| 2020-07-10 06:45:00 | SPY | ETF | 313.18 | 313.21 | 313.11 | 313.16 | 3180.0 |
| 2020-07-10 06:50:00 | SPY | ETF | 313.13 | 313.25 | 313.13 | 313.21 | 4180.0 |
| 2020-07-10 06:55:00 | SPY | ETF | 313.21 | 313.21 | 313.21 | 313.21 | 226.0 |
| 2020-07-10 07:00:00 | SPY | ETF | 313.28 | 313.47 | 313.28 | 313.47 | 10823.0 |
| 2020-07-10 07:05:00 | SPY | ETF | 313.46 | 313.66 | 313.41 | 313.59 | 15639.0 |
| 2020-07-10 07:10:00 | SPY | ETF | 313.61 | 313.73 | 313.58 | 313.65 | 4929.0 |
| 2020-07-10 07:15:00 | SPY | ETF | 313.61 | 313.61 | 313.4 | 313.4 | 4062.0 |
| 2020-07-10 07:20:00 | SPY | ETF | 313.47 | 313.62 | 313.41 | 313.58 | 10343.0 |
| 2020-07-10 07:25:00 | SPY | ETF | 313.53 | 313.53 | 313.24 | 313.25 | 32573.0 |
| 2020-07-10 07:30:00 | SPY | ETF | 313.27 | 313.3 | 313.25 | 313.27 | 3977.0 |
| 2020-07-10 07:35:00 | SPY | ETF | 313.28 | 313.32 | 313.21 | 313.3 | 6784.0 |
| 2020-07-10 07:40:00 | SPY | ETF | 313.29 | 313.32 | 313.24 | 313.29 | 8624.0 |
| 2020-07-10 07:45:00 | SPY | ETF | 313.29 | 313.3 | 312.8 | 312.91 | 54919.0 |
| 2020-07-10 07:50:00 | SPY | ETF | 312.93 | 313.01 | 312.76 | 312.8 | 25350.0 |
| 2020-07-10 07:55:00 | SPY | ETF | 312.85 | 312.91 | 312.72 | 312.75 | 33455.0 |
| 2020-07-10 08:00:00 | SPY | ETF | 312.83 | 314.03 | 312.3901 | 312.4899 | 101784.0 |
| 2020-07-10 08:05:00 | SPY | ETF | 312.46 | 312.56 | 311.39 | 312.4 | 20045.0 |
> showing 50 of 73,232 rows — these rows as CSV