PREVIEW / etf_5min / 2021-09-29
file: by_date/etf_5min/2021/2021-09-29.parquet size: 1.8 MB rows: 83,112
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-09-29 04:00:00 | SPY | ETF | 436.7 | 437.06 | 436.01 | 436.91 | 7257.0 |
| 2021-09-29 04:05:00 | SPY | ETF | 436.79 | 436.79 | 436.6 | 436.67 | 3272.0 |
| 2021-09-29 04:10:00 | SPY | ETF | 436.73 | 436.86 | 436.71 | 436.81 | 1300.0 |
| 2021-09-29 04:15:00 | SPY | ETF | 436.57 | 436.57 | 436.28 | 436.28 | 6700.0 |
| 2021-09-29 04:20:00 | SPY | ETF | 436.28 | 436.3 | 436.14 | 436.29 | 21080.0 |
| 2021-09-29 04:25:00 | SPY | ETF | 436.35 | 436.47 | 436.28 | 436.42 | 21446.0 |
| 2021-09-29 04:30:00 | SPY | ETF | 436.48 | 436.65 | 436.48 | 436.55 | 1500.0 |
| 2021-09-29 04:35:00 | SPY | ETF | 436.34 | 436.41 | 436.34 | 436.41 | 3000.0 |
| 2021-09-29 04:40:00 | SPY | ETF | 436.55 | 436.62 | 436.52 | 436.52 | 1700.0 |
| 2021-09-29 04:45:00 | SPY | ETF | 436.54 | 436.67 | 436.49 | 436.67 | 3100.0 |
| 2021-09-29 04:50:00 | SPY | ETF | 436.71 | 436.71 | 436.68 | 436.7 | 2434.0 |
| 2021-09-29 04:55:00 | SPY | ETF | 436.72 | 436.81 | 436.65 | 436.8 | 4300.0 |
| 2021-09-29 05:00:00 | SPY | ETF | 436.84 | 436.92 | 436.82 | 436.92 | 11514.0 |
| 2021-09-29 05:05:00 | SPY | ETF | 436.91 | 437.06 | 436.89 | 436.99 | 6178.0 |
| 2021-09-29 05:10:00 | SPY | ETF | 436.98 | 437.02 | 436.94 | 437.02 | 15007.0 |
| 2021-09-29 05:15:00 | SPY | ETF | 437.07 | 437.07 | 436.74 | 436.74 | 4400.0 |
| 2021-09-29 05:20:00 | SPY | ETF | 436.76 | 436.81 | 436.42 | 436.42 | 3288.0 |
| 2021-09-29 05:25:00 | SPY | ETF | 436.44 | 436.65 | 436.44 | 436.63 | 44150.0 |
| 2021-09-29 05:30:00 | SPY | ETF | 436.64 | 436.65 | 436.45 | 436.53 | 6156.0 |
| 2021-09-29 05:35:00 | SPY | ETF | 436.57 | 436.58 | 436.37 | 436.47 | 9128.0 |
| 2021-09-29 05:40:00 | SPY | ETF | 436.53 | 436.56 | 436.53 | 436.56 | 20534.0 |
| 2021-09-29 05:45:00 | SPY | ETF | 436.6 | 436.67 | 436.6 | 436.67 | 400.0 |
| 2021-09-29 05:50:00 | SPY | ETF | 436.72 | 436.8 | 436.7 | 436.76 | 2900.0 |
| 2021-09-29 05:55:00 | SPY | ETF | 436.8 | 436.94 | 436.8 | 436.94 | 28599.0 |
| 2021-09-29 06:00:00 | SPY | ETF | 436.94 | 437.14 | 436.94 | 437.12 | 14241.0 |
| 2021-09-29 06:05:00 | SPY | ETF | 437.0 | 437.02 | 436.94 | 436.94 | 1981.0 |
| 2021-09-29 06:10:00 | SPY | ETF | 436.93 | 437.0 | 436.9 | 436.9 | 3348.0 |
| 2021-09-29 06:15:00 | SPY | ETF | 437.12 | 437.12 | 437.04 | 437.07 | 25697.0 |
| 2021-09-29 06:20:00 | SPY | ETF | 437.02 | 437.04 | 436.9 | 436.9 | 3200.0 |
| 2021-09-29 06:25:00 | SPY | ETF | 436.9 | 436.96 | 436.9 | 436.96 | 600.0 |
| 2021-09-29 06:30:00 | SPY | ETF | 436.91 | 436.91 | 436.91 | 436.91 | 200.0 |
| 2021-09-29 06:35:00 | SPY | ETF | 436.92 | 436.92 | 436.87 | 436.89 | 1200.0 |
| 2021-09-29 06:40:00 | SPY | ETF | 436.86 | 436.87 | 436.8 | 436.81 | 14379.0 |
| 2021-09-29 06:45:00 | SPY | ETF | 436.76 | 436.79 | 436.66 | 436.66 | 7400.0 |
| 2021-09-29 06:50:00 | SPY | ETF | 436.74 | 436.74 | 436.6 | 436.6 | 23474.0 |
| 2021-09-29 06:55:00 | SPY | ETF | 436.6 | 436.6 | 436.35 | 436.49 | 14444.0 |
| 2021-09-29 07:00:00 | SPY | ETF | 436.41 | 436.6 | 436.39 | 436.44 | 15550.0 |
| 2021-09-29 07:05:00 | SPY | ETF | 436.47 | 436.52 | 435.98 | 436.09 | 16980.0 |
| 2021-09-29 07:10:00 | SPY | ETF | 436.1 | 436.21 | 436.08 | 436.08 | 14769.0 |
| 2021-09-29 07:15:00 | SPY | ETF | 436.19 | 436.19 | 435.8 | 435.94 | 9432.0 |
| 2021-09-29 07:20:00 | SPY | ETF | 435.93 | 436.11 | 435.88 | 436.01 | 9772.0 |
| 2021-09-29 07:25:00 | SPY | ETF | 435.91 | 436.1 | 435.91 | 436.09 | 119444.0 |
| 2021-09-29 07:30:00 | SPY | ETF | 436.06 | 436.35 | 436.03 | 436.34 | 37737.0 |
| 2021-09-29 07:35:00 | SPY | ETF | 436.34 | 436.34 | 435.49 | 435.57 | 18722.0 |
| 2021-09-29 07:40:00 | SPY | ETF | 435.6 | 435.93 | 435.55 | 435.91 | 46000.0 |
| 2021-09-29 07:45:00 | SPY | ETF | 435.89 | 436.05 | 435.88 | 435.98 | 33472.0 |
| 2021-09-29 07:50:00 | SPY | ETF | 436.0 | 436.19 | 436.0 | 436.13 | 21283.0 |
| 2021-09-29 07:55:00 | SPY | ETF | 436.13 | 436.31 | 436.04 | 436.1 | 31456.0 |
| 2021-09-29 08:00:00 | SPY | ETF | 436.11 | 437.1104 | 435.48 | 436.29 | 73324.0 |
| 2021-09-29 08:05:00 | SPY | ETF | 436.22 | 436.37 | 436.21 | 436.26 | 8981.0 |
> showing 50 of 83,112 rows — these rows as CSV