PREVIEW / etf_5min / 2022-05-12
file: by_date/etf_5min/2022/2022-05-12.parquet size: 2.2 MB rows: 106,825
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-05-12 04:00:00 | SPY | ETF | 392.49 | 392.49 | 390.6 | 390.76 | 15993.0 |
| 2022-05-12 04:05:00 | SPY | ETF | 391.02 | 391.29 | 390.58 | 391.06 | 2436.0 |
| 2022-05-12 04:10:00 | SPY | ETF | 391.11 | 391.38 | 391.0 | 391.0 | 10780.0 |
| 2022-05-12 04:15:00 | SPY | ETF | 391.45 | 391.45 | 390.77 | 390.77 | 3015.0 |
| 2022-05-12 04:20:00 | SPY | ETF | 390.72 | 391.0 | 390.43 | 390.58 | 9449.0 |
| 2022-05-12 04:25:00 | SPY | ETF | 390.8 | 391.06 | 390.55 | 390.96 | 3832.0 |
| 2022-05-12 04:30:00 | SPY | ETF | 390.93 | 391.51 | 390.55 | 390.61 | 25728.0 |
| 2022-05-12 04:35:00 | SPY | ETF | 390.59 | 390.59 | 390.19 | 390.42 | 2507.0 |
| 2022-05-12 04:40:00 | SPY | ETF | 390.42 | 390.43 | 389.9 | 390.14 | 8293.0 |
| 2022-05-12 04:45:00 | SPY | ETF | 390.0 | 390.0 | 389.35 | 389.52 | 10368.0 |
| 2022-05-12 04:50:00 | SPY | ETF | 389.84 | 390.07 | 389.77 | 390.02 | 10864.0 |
| 2022-05-12 04:55:00 | SPY | ETF | 390.27 | 390.28 | 389.9 | 390.05 | 8880.0 |
| 2022-05-12 05:00:00 | SPY | ETF | 390.1 | 390.19 | 389.48 | 389.48 | 3559.0 |
| 2022-05-12 05:05:00 | SPY | ETF | 389.5 | 390.0 | 389.5 | 389.89 | 4722.0 |
| 2022-05-12 05:10:00 | SPY | ETF | 389.88 | 390.08 | 389.55 | 390.07 | 3969.0 |
| 2022-05-12 05:15:00 | SPY | ETF | 389.8 | 390.35 | 389.62 | 390.35 | 16152.0 |
| 2022-05-12 05:20:00 | SPY | ETF | 390.34 | 390.35 | 389.78 | 389.87 | 6814.0 |
| 2022-05-12 05:25:00 | SPY | ETF | 389.86 | 390.04 | 389.5 | 389.86 | 9709.0 |
| 2022-05-12 05:30:00 | SPY | ETF | 389.64 | 389.7 | 388.81 | 388.97 | 12895.0 |
| 2022-05-12 05:35:00 | SPY | ETF | 389.2 | 389.85 | 389.2 | 389.85 | 9289.0 |
| 2022-05-12 05:40:00 | SPY | ETF | 389.86 | 390.0 | 389.59 | 389.88 | 7179.0 |
| 2022-05-12 05:45:00 | SPY | ETF | 389.92 | 390.47 | 389.88 | 390.45 | 12981.0 |
| 2022-05-12 05:50:00 | SPY | ETF | 390.27 | 390.27 | 389.95 | 389.96 | 885.0 |
| 2022-05-12 05:55:00 | SPY | ETF | 390.0 | 390.11 | 389.62 | 389.8 | 11343.0 |
| 2022-05-12 06:00:00 | SPY | ETF | 389.73 | 390.05 | 389.53 | 389.95 | 9485.0 |
| 2022-05-12 06:05:00 | SPY | ETF | 389.9 | 390.24 | 389.9 | 390.03 | 10699.0 |
| 2022-05-12 06:10:00 | SPY | ETF | 390.01 | 390.16 | 389.65 | 389.69 | 12788.0 |
| 2022-05-12 06:15:00 | SPY | ETF | 389.74 | 389.78 | 389.58 | 389.74 | 4155.0 |
| 2022-05-12 06:20:00 | SPY | ETF | 389.66 | 389.85 | 389.66 | 389.82 | 3900.0 |
| 2022-05-12 06:25:00 | SPY | ETF | 389.81 | 390.89 | 389.81 | 390.8 | 15939.0 |
| 2022-05-12 06:30:00 | SPY | ETF | 390.89 | 390.89 | 390.46 | 390.46 | 1100.0 |
| 2022-05-12 06:35:00 | SPY | ETF | 390.65 | 390.74 | 390.08 | 390.08 | 5040.0 |
| 2022-05-12 06:40:00 | SPY | ETF | 390.17 | 390.21 | 389.88 | 390.01 | 11224.0 |
| 2022-05-12 06:45:00 | SPY | ETF | 389.98 | 390.01 | 389.76 | 389.76 | 6121.0 |
| 2022-05-12 06:50:00 | SPY | ETF | 389.84 | 390.55 | 389.84 | 390.44 | 3100.0 |
| 2022-05-12 06:55:00 | SPY | ETF | 390.5 | 391.19 | 390.5 | 390.93 | 5544.0 |
| 2022-05-12 07:00:00 | SPY | ETF | 390.91 | 391.24 | 390.65 | 390.71 | 29442.0 |
| 2022-05-12 07:05:00 | SPY | ETF | 390.65 | 390.81 | 390.44 | 390.51 | 8652.0 |
| 2022-05-12 07:10:00 | SPY | ETF | 390.51 | 391.15 | 390.42 | 391.15 | 17953.0 |
| 2022-05-12 07:15:00 | SPY | ETF | 391.2 | 391.37 | 391.12 | 391.14 | 16767.0 |
| 2022-05-12 07:20:00 | SPY | ETF | 391.2 | 392.09 | 391.19 | 391.76 | 57853.0 |
| 2022-05-12 07:25:00 | SPY | ETF | 391.73 | 391.97 | 391.27 | 391.32 | 189360.0 |
| 2022-05-12 07:30:00 | SPY | ETF | 391.28 | 391.32 | 390.6 | 390.61 | 54998.0 |
| 2022-05-12 07:35:00 | SPY | ETF | 390.68 | 390.84 | 390.25 | 390.39 | 54685.0 |
| 2022-05-12 07:40:00 | SPY | ETF | 390.33 | 390.58 | 389.85 | 390.12 | 69571.0 |
| 2022-05-12 07:45:00 | SPY | ETF | 390.14 | 390.14 | 389.21 | 389.36 | 49290.0 |
| 2022-05-12 07:50:00 | SPY | ETF | 389.44 | 389.54 | 388.81 | 388.95 | 65196.0 |
| 2022-05-12 07:55:00 | SPY | ETF | 389.0 | 389.45 | 388.14 | 388.57 | 91463.0 |
| 2022-05-12 08:00:00 | SPY | ETF | 388.47 | 392.85 | 388.21 | 388.78 | 132640.0 |
| 2022-05-12 08:05:00 | SPY | ETF | 388.78 | 389.45 | 388.7 | 389.15 | 73004.0 |
> showing 50 of 106,825 rows — these rows as CSV