PREVIEW / etf_5min / 2021-12-13
file: by_date/etf_5min/2021/2021-12-13.parquet size: 1.8 MB rows: 87,133
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-12-13 04:00:00 | SPY | ETF | 471.53 | 472.05 | 471.53 | 472.03 | 4766.0 |
| 2021-12-13 04:05:00 | SPY | ETF | 472.11 | 472.11 | 471.9 | 471.96 | 1808.0 |
| 2021-12-13 04:10:00 | SPY | ETF | 471.96 | 472.3 | 471.96 | 472.3 | 4009.0 |
| 2021-12-13 04:15:00 | SPY | ETF | 472.3 | 472.4 | 472.3 | 472.36 | 1716.0 |
| 2021-12-13 04:20:00 | SPY | ETF | 472.35 | 472.38 | 472.35 | 472.38 | 1157.0 |
| 2021-12-13 04:25:00 | SPY | ETF | 472.33 | 472.36 | 472.27 | 472.33 | 494.0 |
| 2021-12-13 04:30:00 | SPY | ETF | 472.4 | 472.53 | 472.4 | 472.53 | 300.0 |
| 2021-12-13 04:35:00 | SPY | ETF | 472.46 | 472.46 | 472.31 | 472.31 | 2248.0 |
| 2021-12-13 04:40:00 | SPY | ETF | 472.34 | 472.34 | 472.3 | 472.3 | 420.0 |
| 2021-12-13 04:45:00 | SPY | ETF | 472.27 | 472.33 | 472.27 | 472.33 | 500.0 |
| 2021-12-13 04:50:00 | SPY | ETF | 472.33 | 472.33 | 472.2 | 472.21 | 1256.0 |
| 2021-12-13 04:55:00 | SPY | ETF | 472.2 | 472.2 | 472.2 | 472.2 | 100.0 |
| 2021-12-13 05:00:00 | SPY | ETF | 472.29 | 472.4 | 472.25 | 472.35 | 2895.0 |
| 2021-12-13 05:05:00 | SPY | ETF | 472.36 | 472.36 | 472.23 | 472.25 | 840.0 |
| 2021-12-13 05:10:00 | SPY | ETF | 472.23 | 472.23 | 472.15 | 472.15 | 1320.0 |
| 2021-12-13 05:15:00 | SPY | ETF | 472.03 | 472.03 | 471.9 | 471.93 | 2419.0 |
| 2021-12-13 05:20:00 | SPY | ETF | 471.96 | 472.09 | 471.96 | 472.0 | 5913.0 |
| 2021-12-13 05:25:00 | SPY | ETF | 471.82 | 471.93 | 471.82 | 471.93 | 532.0 |
| 2021-12-13 05:30:00 | SPY | ETF | 472.03 | 472.03 | 471.96 | 471.96 | 300.0 |
| 2021-12-13 05:35:00 | SPY | ETF | 471.94 | 472.13 | 471.94 | 472.13 | 4973.0 |
| 2021-12-13 05:40:00 | SPY | ETF | 472.13 | 472.13 | 472.13 | 472.13 | 500.0 |
| 2021-12-13 05:45:00 | SPY | ETF | 472.23 | 472.23 | 472.23 | 472.23 | 1325.0 |
| 2021-12-13 05:50:00 | SPY | ETF | 472.21 | 472.21 | 472.1 | 472.1 | 315.0 |
| 2021-12-13 05:55:00 | SPY | ETF | 472.03 | 472.1 | 472.03 | 472.08 | 453.0 |
| 2021-12-13 06:00:00 | SPY | ETF | 472.16 | 472.3 | 472.16 | 472.3 | 1979.0 |
| 2021-12-13 06:05:00 | SPY | ETF | 472.31 | 472.36 | 472.31 | 472.36 | 700.0 |
| 2021-12-13 06:10:00 | SPY | ETF | 472.31 | 472.54 | 472.31 | 472.54 | 1858.0 |
| 2021-12-13 06:15:00 | SPY | ETF | 472.47 | 472.47 | 472.45 | 472.46 | 477.0 |
| 2021-12-13 06:20:00 | SPY | ETF | 472.38 | 472.38 | 472.38 | 472.38 | 100.0 |
| 2021-12-13 06:25:00 | SPY | ETF | 472.31 | 472.33 | 472.28 | 472.29 | 598.0 |
| 2021-12-13 06:30:00 | SPY | ETF | 472.28 | 472.28 | 472.21 | 472.21 | 1599.0 |
| 2021-12-13 06:35:00 | SPY | ETF | 472.2 | 472.24 | 471.7 | 472.18 | 6483.0 |
| 2021-12-13 06:40:00 | SPY | ETF | 472.23 | 472.28 | 472.18 | 472.28 | 1910.0 |
| 2021-12-13 06:45:00 | SPY | ETF | 472.0 | 472.01 | 471.79 | 471.9 | 17393.0 |
| 2021-12-13 06:50:00 | SPY | ETF | 471.96 | 472.06 | 471.95 | 471.95 | 3131.0 |
| 2021-12-13 06:55:00 | SPY | ETF | 472.02 | 472.06 | 471.99 | 472.05 | 3458.0 |
| 2021-12-13 07:00:00 | SPY | ETF | 472.08 | 472.1 | 471.64 | 471.73 | 16047.0 |
| 2021-12-13 07:05:00 | SPY | ETF | 471.78 | 471.83 | 471.73 | 471.81 | 10127.0 |
| 2021-12-13 07:10:00 | SPY | ETF | 471.83 | 471.84 | 471.73 | 471.74 | 5565.0 |
| 2021-12-13 07:15:00 | SPY | ETF | 471.79 | 471.8 | 471.5 | 471.59 | 21995.0 |
| 2021-12-13 07:20:00 | SPY | ETF | 471.58 | 471.95 | 471.57 | 471.9 | 21154.0 |
| 2021-12-13 07:25:00 | SPY | ETF | 471.94 | 471.94 | 471.7 | 471.75 | 12518.0 |
| 2021-12-13 07:30:00 | SPY | ETF | 471.74 | 471.78 | 471.68 | 471.74 | 6285.0 |
| 2021-12-13 07:35:00 | SPY | ETF | 471.74 | 471.82 | 471.73 | 471.81 | 6727.0 |
| 2021-12-13 07:40:00 | SPY | ETF | 471.8 | 471.86 | 471.71 | 471.85 | 11298.0 |
| 2021-12-13 07:45:00 | SPY | ETF | 471.86 | 471.86 | 471.57 | 471.64 | 12398.0 |
| 2021-12-13 07:50:00 | SPY | ETF | 471.64 | 471.72 | 471.54 | 471.55 | 10337.0 |
| 2021-12-13 07:55:00 | SPY | ETF | 471.53 | 471.59 | 471.48 | 471.55 | 10298.0 |
| 2021-12-13 08:00:00 | SPY | ETF | 471.8101 | 472.3 | 471.49 | 471.63 | 45216.0 |
| 2021-12-13 08:05:00 | SPY | ETF | 471.47 | 471.55 | 471.45 | 471.55 | 6179.0 |
> showing 50 of 87,133 rows — these rows as CSV