PREVIEW / etf_5min / 2022-12-01
file: by_date/etf_5min/2022/2022-12-01.parquet size: 2.1 MB rows: 101,708
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-01 04:00:00 | SPY | ETF | 407.46 | 407.8 | 407.19 | 407.27 | 9211.0 |
| 2022-12-01 04:05:00 | SPY | ETF | 407.25 | 407.31 | 407.0 | 407.09 | 21975.0 |
| 2022-12-01 04:10:00 | SPY | ETF | 407.03 | 407.08 | 406.83 | 406.94 | 13387.0 |
| 2022-12-01 04:15:00 | SPY | ETF | 406.91 | 406.91 | 406.74 | 406.79 | 6903.0 |
| 2022-12-01 04:20:00 | SPY | ETF | 406.92 | 407.05 | 406.86 | 406.94 | 3358.0 |
| 2022-12-01 04:25:00 | SPY | ETF | 407.03 | 407.03 | 406.76 | 407.03 | 4513.0 |
| 2022-12-01 04:30:00 | SPY | ETF | 407.01 | 407.05 | 406.93 | 406.93 | 2670.0 |
| 2022-12-01 04:35:00 | SPY | ETF | 406.91 | 406.91 | 406.58 | 406.58 | 2962.0 |
| 2022-12-01 04:40:00 | SPY | ETF | 406.77 | 406.77 | 406.59 | 406.75 | 7012.0 |
| 2022-12-01 04:45:00 | SPY | ETF | 406.78 | 406.92 | 406.73 | 406.9 | 2940.0 |
| 2022-12-01 04:50:00 | SPY | ETF | 406.88 | 406.88 | 406.82 | 406.83 | 1900.0 |
| 2022-12-01 04:55:00 | SPY | ETF | 406.83 | 407.1 | 406.83 | 407.07 | 9447.0 |
| 2022-12-01 05:00:00 | SPY | ETF | 407.1 | 407.2 | 407.0 | 407.0 | 1304.0 |
| 2022-12-01 05:05:00 | SPY | ETF | 407.16 | 407.16 | 407.01 | 407.01 | 1815.0 |
| 2022-12-01 05:10:00 | SPY | ETF | 407.05 | 407.05 | 407.02 | 407.02 | 1013.0 |
| 2022-12-01 05:15:00 | SPY | ETF | 407.21 | 407.26 | 407.2 | 407.2 | 2996.0 |
| 2022-12-01 05:20:00 | SPY | ETF | 407.12 | 407.14 | 406.97 | 406.97 | 8068.0 |
| 2022-12-01 05:25:00 | SPY | ETF | 407.26 | 407.26 | 407.1 | 407.11 | 875.0 |
| 2022-12-01 05:30:00 | SPY | ETF | 407.17 | 407.23 | 407.15 | 407.23 | 1600.0 |
| 2022-12-01 05:35:00 | SPY | ETF | 407.22 | 407.4 | 407.22 | 407.33 | 1125.0 |
| 2022-12-01 05:40:00 | SPY | ETF | 407.33 | 407.33 | 407.27 | 407.27 | 200.0 |
| 2022-12-01 05:45:00 | SPY | ETF | 407.2 | 407.25 | 407.07 | 407.25 | 1007.0 |
| 2022-12-01 05:50:00 | SPY | ETF | 407.07 | 407.09 | 407.07 | 407.07 | 727.0 |
| 2022-12-01 05:55:00 | SPY | ETF | 407.07 | 407.07 | 406.88 | 406.91 | 20182.0 |
| 2022-12-01 06:00:00 | SPY | ETF | 406.91 | 406.99 | 406.86 | 406.9 | 2838.0 |
| 2022-12-01 06:05:00 | SPY | ETF | 406.8 | 407.3 | 406.8 | 407.16 | 28130.0 |
| 2022-12-01 06:10:00 | SPY | ETF | 407.23 | 407.31 | 407.13 | 407.13 | 7191.0 |
| 2022-12-01 06:15:00 | SPY | ETF | 407.15 | 407.15 | 406.98 | 406.98 | 12266.0 |
| 2022-12-01 06:20:00 | SPY | ETF | 407.01 | 407.1 | 406.95 | 406.95 | 17256.0 |
| 2022-12-01 06:25:00 | SPY | ETF | 406.96 | 407.13 | 406.95 | 407.13 | 2200.0 |
| 2022-12-01 06:30:00 | SPY | ETF | 407.15 | 407.28 | 407.15 | 407.2 | 4345.0 |
| 2022-12-01 06:35:00 | SPY | ETF | 407.07 | 407.09 | 407.07 | 407.08 | 6050.0 |
| 2022-12-01 06:40:00 | SPY | ETF | 407.02 | 407.14 | 407.02 | 407.07 | 4208.0 |
| 2022-12-01 06:45:00 | SPY | ETF | 407.1 | 407.1 | 406.98 | 407.01 | 16905.0 |
| 2022-12-01 06:50:00 | SPY | ETF | 407.06 | 407.36 | 407.03 | 407.27 | 5300.0 |
| 2022-12-01 06:55:00 | SPY | ETF | 407.28 | 407.28 | 407.16 | 407.25 | 4885.0 |
| 2022-12-01 07:00:00 | SPY | ETF | 407.3 | 407.48 | 407.26 | 407.38 | 18991.0 |
| 2022-12-01 07:05:00 | SPY | ETF | 407.4 | 407.42 | 407.26 | 407.28 | 11736.0 |
| 2022-12-01 07:10:00 | SPY | ETF | 407.35 | 407.38 | 407.22 | 407.23 | 9245.0 |
| 2022-12-01 07:15:00 | SPY | ETF | 407.23 | 407.27 | 407.14 | 407.24 | 8426.0 |
| 2022-12-01 07:20:00 | SPY | ETF | 407.18 | 407.34 | 407.17 | 407.23 | 18737.0 |
| 2022-12-01 07:25:00 | SPY | ETF | 407.17 | 407.35 | 407.15 | 407.35 | 24077.0 |
| 2022-12-01 07:30:00 | SPY | ETF | 407.35 | 407.68 | 407.35 | 407.66 | 45295.0 |
| 2022-12-01 07:35:00 | SPY | ETF | 407.71 | 407.75 | 407.62 | 407.67 | 36871.0 |
| 2022-12-01 07:40:00 | SPY | ETF | 407.69 | 407.78 | 407.65 | 407.71 | 53860.0 |
| 2022-12-01 07:45:00 | SPY | ETF | 407.68 | 407.85 | 407.6 | 407.85 | 43364.0 |
| 2022-12-01 07:50:00 | SPY | ETF | 407.82 | 407.9 | 407.81 | 407.84 | 47446.0 |
| 2022-12-01 07:55:00 | SPY | ETF | 407.85 | 407.91 | 407.76 | 407.91 | 41701.0 |
| 2022-12-01 08:00:00 | SPY | ETF | 407.94 | 408.45 | 406.85 | 408.13 | 121201.0 |
| 2022-12-01 08:05:00 | SPY | ETF | 408.15 | 408.4 | 407.643 | 408.38 | 204155.0 |
> showing 50 of 101,708 rows — these rows as CSV