PREVIEW / etf_5min / 2022-10-18
file: by_date/etf_5min/2022/2022-10-18.parquet size: 2.0 MB rows: 98,696
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-10-18 04:00:00 | SPY | ETF | 373.05 | 373.19 | 372.54 | 372.83 | 27426.0 |
| 2022-10-18 04:05:00 | SPY | ETF | 372.91 | 373.09 | 372.66 | 372.75 | 7986.0 |
| 2022-10-18 04:10:00 | SPY | ETF | 372.78 | 372.88 | 372.69 | 372.72 | 9802.0 |
| 2022-10-18 04:15:00 | SPY | ETF | 372.75 | 372.82 | 372.66 | 372.72 | 1650.0 |
| 2022-10-18 04:20:00 | SPY | ETF | 372.6 | 372.69 | 372.36 | 372.44 | 8853.0 |
| 2022-10-18 04:25:00 | SPY | ETF | 372.36 | 372.59 | 372.35 | 372.54 | 4949.0 |
| 2022-10-18 04:30:00 | SPY | ETF | 372.64 | 372.75 | 372.45 | 372.46 | 8868.0 |
| 2022-10-18 04:35:00 | SPY | ETF | 372.4 | 372.4 | 372.15 | 372.15 | 8858.0 |
| 2022-10-18 04:40:00 | SPY | ETF | 372.22 | 372.25 | 371.62 | 371.72 | 20030.0 |
| 2022-10-18 04:45:00 | SPY | ETF | 371.67 | 371.96 | 371.54 | 371.9 | 6420.0 |
| 2022-10-18 04:50:00 | SPY | ETF | 371.94 | 371.95 | 371.71 | 371.71 | 9210.0 |
| 2022-10-18 04:55:00 | SPY | ETF | 371.65 | 371.65 | 370.88 | 371.02 | 31587.0 |
| 2022-10-18 05:00:00 | SPY | ETF | 370.83 | 371.18 | 370.4 | 370.99 | 28037.0 |
| 2022-10-18 05:05:00 | SPY | ETF | 370.96 | 370.96 | 370.32 | 370.43 | 22990.0 |
| 2022-10-18 05:10:00 | SPY | ETF | 370.48 | 370.91 | 370.36 | 370.7 | 26249.0 |
| 2022-10-18 05:15:00 | SPY | ETF | 370.85 | 371.11 | 370.82 | 371.0 | 9225.0 |
| 2022-10-18 05:20:00 | SPY | ETF | 370.87 | 370.87 | 370.38 | 370.48 | 6775.0 |
| 2022-10-18 05:25:00 | SPY | ETF | 370.45 | 370.7 | 370.31 | 370.7 | 10135.0 |
| 2022-10-18 05:30:00 | SPY | ETF | 370.75 | 370.97 | 370.18 | 370.26 | 10435.0 |
| 2022-10-18 05:35:00 | SPY | ETF | 370.2 | 370.53 | 370.2 | 370.37 | 6300.0 |
| 2022-10-18 05:40:00 | SPY | ETF | 370.24 | 370.5 | 370.24 | 370.48 | 3098.0 |
| 2022-10-18 05:45:00 | SPY | ETF | 370.66 | 370.84 | 370.65 | 370.83 | 4750.0 |
| 2022-10-18 05:50:00 | SPY | ETF | 370.86 | 371.05 | 370.85 | 371.05 | 14319.0 |
| 2022-10-18 05:55:00 | SPY | ETF | 371.05 | 371.53 | 371.04 | 371.5 | 13654.0 |
| 2022-10-18 06:00:00 | SPY | ETF | 371.44 | 371.76 | 371.44 | 371.76 | 25815.0 |
| 2022-10-18 06:05:00 | SPY | ETF | 371.75 | 371.82 | 371.29 | 371.41 | 22049.0 |
| 2022-10-18 06:10:00 | SPY | ETF | 371.4 | 371.52 | 371.3 | 371.5 | 3588.0 |
| 2022-10-18 06:15:00 | SPY | ETF | 371.72 | 371.83 | 371.71 | 371.8 | 5460.0 |
| 2022-10-18 06:20:00 | SPY | ETF | 371.89 | 372.22 | 371.89 | 372.14 | 16912.0 |
| 2022-10-18 06:25:00 | SPY | ETF | 372.14 | 372.36 | 371.79 | 372.02 | 23375.0 |
| 2022-10-18 06:30:00 | SPY | ETF | 372.0 | 372.02 | 371.69 | 371.91 | 5865.0 |
| 2022-10-18 06:35:00 | SPY | ETF | 371.9 | 372.94 | 371.9 | 372.61 | 38463.0 |
| 2022-10-18 06:40:00 | SPY | ETF | 372.6 | 372.74 | 372.17 | 372.17 | 10975.0 |
| 2022-10-18 06:45:00 | SPY | ETF | 372.1 | 372.3 | 371.99 | 372.07 | 32498.0 |
| 2022-10-18 06:50:00 | SPY | ETF | 372.07 | 372.07 | 371.6 | 371.75 | 40660.0 |
| 2022-10-18 06:55:00 | SPY | ETF | 371.91 | 371.93 | 371.46 | 371.67 | 18517.0 |
| 2022-10-18 07:00:00 | SPY | ETF | 371.71 | 372.44 | 371.59 | 372.2 | 68314.0 |
| 2022-10-18 07:05:00 | SPY | ETF | 372.18 | 372.7 | 372.15 | 372.56 | 51033.0 |
| 2022-10-18 07:10:00 | SPY | ETF | 372.43 | 372.75 | 372.43 | 372.5 | 28956.0 |
| 2022-10-18 07:15:00 | SPY | ETF | 372.45 | 372.55 | 372.3 | 372.3 | 34637.0 |
| 2022-10-18 07:20:00 | SPY | ETF | 372.33 | 372.85 | 372.33 | 372.6 | 34762.0 |
| 2022-10-18 07:25:00 | SPY | ETF | 372.68 | 372.78 | 372.39 | 372.57 | 19919.0 |
| 2022-10-18 07:30:00 | SPY | ETF | 372.66 | 373.11 | 372.66 | 372.98 | 28913.0 |
| 2022-10-18 07:35:00 | SPY | ETF | 372.95 | 373.18 | 372.75 | 373.18 | 30487.0 |
| 2022-10-18 07:40:00 | SPY | ETF | 373.14 | 373.69 | 373.14 | 373.5 | 127208.0 |
| 2022-10-18 07:45:00 | SPY | ETF | 373.43 | 373.86 | 373.27 | 373.78 | 99088.0 |
| 2022-10-18 07:50:00 | SPY | ETF | 373.74 | 373.81 | 373.47 | 373.51 | 32003.0 |
| 2022-10-18 07:55:00 | SPY | ETF | 373.5 | 373.61 | 373.37 | 373.5 | 24656.0 |
| 2022-10-18 08:00:00 | SPY | ETF | 371.72 | 373.87 | 370.3204 | 373.57 | 198645.0 |
| 2022-10-18 08:05:00 | SPY | ETF | 372.03 | 373.81 | 372.03 | 373.8 | 150819.0 |
> showing 50 of 98,696 rows — these rows as CSV