PREVIEW / etf_5min / 2022-09-27
file: by_date/etf_5min/2022/2022-09-27.parquet size: 2.1 MB rows: 101,920
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-09-27 04:00:00 | SPY | ETF | 369.22 | 369.42 | 367.85 | 369.21 | 25244.0 |
| 2022-09-27 04:05:00 | SPY | ETF | 369.24 | 369.24 | 368.91 | 369.01 | 8237.0 |
| 2022-09-27 04:10:00 | SPY | ETF | 368.85 | 368.87 | 368.8 | 368.83 | 6651.0 |
| 2022-09-27 04:15:00 | SPY | ETF | 368.81 | 368.81 | 368.7 | 368.7 | 3112.0 |
| 2022-09-27 04:20:00 | SPY | ETF | 368.65 | 369.03 | 368.65 | 369.03 | 4628.0 |
| 2022-09-27 04:25:00 | SPY | ETF | 368.8 | 368.88 | 368.8 | 368.87 | 1308.0 |
| 2022-09-27 04:30:00 | SPY | ETF | 368.8 | 368.9 | 368.8 | 368.87 | 1441.0 |
| 2022-09-27 04:35:00 | SPY | ETF | 368.76 | 368.76 | 368.44 | 368.65 | 6720.0 |
| 2022-09-27 04:40:00 | SPY | ETF | 368.35 | 368.45 | 368.35 | 368.45 | 300.0 |
| 2022-09-27 04:45:00 | SPY | ETF | 368.4 | 368.46 | 368.14 | 368.4 | 4669.0 |
| 2022-09-27 04:50:00 | SPY | ETF | 368.46 | 368.75 | 368.45 | 368.53 | 7090.0 |
| 2022-09-27 05:00:00 | SPY | ETF | 368.17 | 368.18 | 367.9 | 367.9 | 1300.0 |
| 2022-09-27 05:05:00 | SPY | ETF | 367.89 | 367.95 | 367.37 | 367.37 | 5859.0 |
| 2022-09-27 05:10:00 | SPY | ETF | 367.2 | 367.28 | 366.75 | 366.98 | 9710.0 |
| 2022-09-27 05:15:00 | SPY | ETF | 367.09 | 367.5 | 367.08 | 367.41 | 5640.0 |
| 2022-09-27 05:20:00 | SPY | ETF | 367.39 | 367.39 | 367.1 | 367.1 | 985.0 |
| 2022-09-27 05:25:00 | SPY | ETF | 367.08 | 367.08 | 366.88 | 366.88 | 3560.0 |
| 2022-09-27 05:30:00 | SPY | ETF | 366.84 | 366.96 | 366.8 | 366.82 | 1052.0 |
| 2022-09-27 05:35:00 | SPY | ETF | 366.91 | 367.18 | 366.91 | 367.06 | 1900.0 |
| 2022-09-27 05:40:00 | SPY | ETF | 367.07 | 367.31 | 367.07 | 367.27 | 7340.0 |
| 2022-09-27 05:45:00 | SPY | ETF | 367.33 | 367.47 | 367.3 | 367.3 | 10606.0 |
| 2022-09-27 05:50:00 | SPY | ETF | 367.0 | 367.0 | 366.87 | 366.87 | 5430.0 |
| 2022-09-27 05:55:00 | SPY | ETF | 366.79 | 366.87 | 366.75 | 366.79 | 4419.0 |
| 2022-09-27 06:00:00 | SPY | ETF | 366.86 | 367.3 | 366.86 | 367.28 | 3123.0 |
| 2022-09-27 06:05:00 | SPY | ETF | 367.26 | 367.26 | 366.92 | 366.94 | 8024.0 |
| 2022-09-27 06:10:00 | SPY | ETF | 366.94 | 367.62 | 366.87 | 367.62 | 7364.0 |
| 2022-09-27 06:15:00 | SPY | ETF | 367.69 | 367.99 | 367.37 | 367.55 | 9961.0 |
| 2022-09-27 06:20:00 | SPY | ETF | 367.79 | 367.83 | 367.79 | 367.82 | 467.0 |
| 2022-09-27 06:25:00 | SPY | ETF | 367.86 | 368.5 | 367.86 | 368.41 | 23490.0 |
| 2022-09-27 06:30:00 | SPY | ETF | 368.35 | 368.56 | 368.2 | 368.24 | 9111.0 |
| 2022-09-27 06:35:00 | SPY | ETF | 368.25 | 368.67 | 367.95 | 368.4 | 13446.0 |
| 2022-09-27 06:40:00 | SPY | ETF | 368.37 | 368.52 | 368.37 | 368.46 | 23000.0 |
| 2022-09-27 06:45:00 | SPY | ETF | 368.54 | 368.75 | 368.21 | 368.74 | 4510.0 |
| 2022-09-27 06:50:00 | SPY | ETF | 368.8 | 368.87 | 368.4 | 368.52 | 45069.0 |
| 2022-09-27 06:55:00 | SPY | ETF | 368.44 | 368.64 | 368.44 | 368.48 | 9842.0 |
| 2022-09-27 07:00:00 | SPY | ETF | 368.42 | 368.56 | 368.3 | 368.35 | 42039.0 |
| 2022-09-27 07:05:00 | SPY | ETF | 368.34 | 368.7 | 367.01 | 368.51 | 143065.0 |
| 2022-09-27 07:10:00 | SPY | ETF | 368.47 | 368.51 | 368.21 | 368.31 | 45436.0 |
| 2022-09-27 07:15:00 | SPY | ETF | 368.3 | 368.3 | 368.0 | 368.05 | 51248.0 |
| 2022-09-27 07:20:00 | SPY | ETF | 368.04 | 368.69 | 368.03 | 368.69 | 52967.0 |
| 2022-09-27 07:25:00 | SPY | ETF | 368.7 | 368.74 | 368.4 | 368.5 | 13313.0 |
| 2022-09-27 07:30:00 | SPY | ETF | 368.5 | 368.95 | 368.42 | 368.81 | 48433.0 |
| 2022-09-27 07:35:00 | SPY | ETF | 368.76 | 369.07 | 368.7 | 369.05 | 40211.0 |
| 2022-09-27 07:40:00 | SPY | ETF | 369.0 | 369.5 | 368.93 | 369.5 | 128901.0 |
| 2022-09-27 07:45:00 | SPY | ETF | 369.48 | 369.6 | 369.32 | 369.45 | 128218.0 |
| 2022-09-27 07:50:00 | SPY | ETF | 369.45 | 369.52 | 369.25 | 369.35 | 56042.0 |
| 2022-09-27 07:55:00 | SPY | ETF | 369.36 | 369.55 | 369.08 | 369.23 | 29815.0 |
| 2022-09-27 08:00:00 | SPY | ETF | 368.4801 | 369.53 | 366.13 | 368.91 | 263656.0 |
| 2022-09-27 08:05:00 | SPY | ETF | 368.87 | 369.05 | 368.78 | 369.0 | 23574.0 |
| 2022-09-27 08:10:00 | SPY | ETF | 369.01 | 369.28 | 368.87 | 369.18 | 37757.0 |
> showing 50 of 101,920 rows — these rows as CSV