PREVIEW / etf_5min / 2021-01-13
file: by_date/etf_5min/2021/2021-01-13.parquet size: 1.8 MB rows: 83,856
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-13 04:00:00 | SPY | ETF | 379.26 | 379.3 | 379.22 | 379.3 | 715.0 |
| 2021-01-13 04:05:00 | SPY | ETF | 379.35 | 379.37 | 379.35 | 379.37 | 294.0 |
| 2021-01-13 04:10:00 | SPY | ETF | 379.35 | 379.4 | 379.35 | 379.4 | 766.0 |
| 2021-01-13 04:15:00 | SPY | ETF | 379.38 | 379.64 | 379.38 | 379.64 | 1737.0 |
| 2021-01-13 04:20:00 | SPY | ETF | 379.65 | 379.7 | 379.65 | 379.7 | 2590.0 |
| 2021-01-13 04:25:00 | SPY | ETF | 379.6 | 379.6 | 379.58 | 379.58 | 1810.0 |
| 2021-01-13 04:35:00 | SPY | ETF | 379.64 | 379.65 | 379.55 | 379.56 | 2900.0 |
| 2021-01-13 04:40:00 | SPY | ETF | 379.5 | 379.55 | 379.49 | 379.5 | 943.0 |
| 2021-01-13 04:45:00 | SPY | ETF | 379.47 | 379.47 | 379.4 | 379.4 | 310.0 |
| 2021-01-13 04:50:00 | SPY | ETF | 379.5 | 379.5 | 379.5 | 379.5 | 120.0 |
| 2021-01-13 04:55:00 | SPY | ETF | 379.5 | 379.51 | 379.5 | 379.51 | 200.0 |
| 2021-01-13 05:00:00 | SPY | ETF | 379.48 | 379.48 | 379.47 | 379.47 | 200.0 |
| 2021-01-13 05:05:00 | SPY | ETF | 379.4 | 379.4 | 379.4 | 379.4 | 101.0 |
| 2021-01-13 05:10:00 | SPY | ETF | 379.5 | 379.5 | 379.45 | 379.5 | 500.0 |
| 2021-01-13 05:15:00 | SPY | ETF | 379.47 | 379.47 | 379.4 | 379.4 | 205.0 |
| 2021-01-13 05:20:00 | SPY | ETF | 379.36 | 379.37 | 379.36 | 379.37 | 908.0 |
| 2021-01-13 05:25:00 | SPY | ETF | 379.3 | 379.3 | 378.9 | 378.92 | 2384.0 |
| 2021-01-13 05:30:00 | SPY | ETF | 378.85 | 378.85 | 378.33 | 378.49 | 8175.0 |
| 2021-01-13 05:35:00 | SPY | ETF | 378.38 | 378.52 | 378.23 | 378.35 | 10387.0 |
| 2021-01-13 05:40:00 | SPY | ETF | 378.48 | 378.6 | 378.48 | 378.59 | 1186.0 |
| 2021-01-13 05:45:00 | SPY | ETF | 378.55 | 378.66 | 378.5 | 378.66 | 3284.0 |
| 2021-01-13 05:50:00 | SPY | ETF | 378.75 | 378.82 | 378.75 | 378.77 | 1799.0 |
| 2021-01-13 05:55:00 | SPY | ETF | 378.77 | 378.77 | 378.68 | 378.73 | 1321.0 |
| 2021-01-13 06:00:00 | SPY | ETF | 378.75 | 378.8 | 378.7 | 378.7 | 2000.0 |
| 2021-01-13 06:05:00 | SPY | ETF | 378.64 | 378.75 | 378.58 | 378.7 | 2745.0 |
| 2021-01-13 06:10:00 | SPY | ETF | 378.76 | 378.76 | 378.72 | 378.75 | 1360.0 |
| 2021-01-13 06:15:00 | SPY | ETF | 378.74 | 378.83 | 378.74 | 378.83 | 831.0 |
| 2021-01-13 06:20:00 | SPY | ETF | 378.77 | 378.77 | 378.42 | 378.55 | 1822.0 |
| 2021-01-13 06:25:00 | SPY | ETF | 378.53 | 378.53 | 378.22 | 378.22 | 3082.0 |
| 2021-01-13 06:30:00 | SPY | ETF | 378.28 | 378.41 | 377.9 | 378.41 | 9039.0 |
| 2021-01-13 06:35:00 | SPY | ETF | 378.43 | 378.43 | 378.43 | 378.43 | 175.0 |
| 2021-01-13 06:40:00 | SPY | ETF | 378.43 | 378.49 | 378.36 | 378.49 | 2005.0 |
| 2021-01-13 06:45:00 | SPY | ETF | 378.6 | 378.69 | 378.55 | 378.6 | 3162.0 |
| 2021-01-13 06:50:00 | SPY | ETF | 378.6 | 378.6 | 378.58 | 378.6 | 2225.0 |
| 2021-01-13 06:55:00 | SPY | ETF | 378.59 | 378.59 | 378.4 | 378.4 | 300.0 |
| 2021-01-13 07:00:00 | SPY | ETF | 378.46 | 378.51 | 378.42 | 378.48 | 10710.0 |
| 2021-01-13 07:05:00 | SPY | ETF | 378.49 | 378.59 | 378.44 | 378.44 | 23299.0 |
| 2021-01-13 07:10:00 | SPY | ETF | 378.35 | 378.5 | 378.06 | 378.06 | 21666.0 |
| 2021-01-13 07:15:00 | SPY | ETF | 378.05 | 378.18 | 377.92 | 377.95 | 66786.0 |
| 2021-01-13 07:20:00 | SPY | ETF | 377.92 | 378.17 | 377.92 | 378.14 | 24670.0 |
| 2021-01-13 07:25:00 | SPY | ETF | 378.16 | 378.16 | 377.75 | 378.0 | 37552.0 |
| 2021-01-13 07:30:00 | SPY | ETF | 378.07 | 378.07 | 377.42 | 377.75 | 95168.0 |
| 2021-01-13 07:35:00 | SPY | ETF | 377.67 | 377.74 | 377.46 | 377.69 | 51520.0 |
| 2021-01-13 07:40:00 | SPY | ETF | 377.69 | 378.0 | 377.69 | 377.94 | 13782.0 |
| 2021-01-13 07:45:00 | SPY | ETF | 378.03 | 378.11 | 377.95 | 378.02 | 15174.0 |
| 2021-01-13 07:50:00 | SPY | ETF | 378.01 | 378.01 | 377.44 | 377.51 | 47197.0 |
| 2021-01-13 07:55:00 | SPY | ETF | 377.5 | 377.64 | 377.25 | 377.53 | 35286.0 |
| 2021-01-13 08:00:00 | SPY | ETF | 377.56 | 379.45 | 377.38 | 377.59 | 37080.0 |
| 2021-01-13 08:05:00 | SPY | ETF | 377.55 | 377.64 | 377.51 | 377.51 | 13259.0 |
| 2021-01-13 08:10:00 | SPY | ETF | 377.6 | 377.61 | 377.52 | 377.568 | 10177.0 |
> showing 50 of 83,856 rows — these rows as CSV