PREVIEW / etf_5min / 2023-06-12
file: by_date/etf_5min/2023/2023-06-12.parquet size: 2.0 MB rows: 95,911
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 |
|---|---|---|---|---|---|---|---|
| 2023-06-12 04:00:00 | SPY | ETF | 431.34 | 431.68 | 431.01 | 431.59 | 15281.0 |
| 2023-06-12 04:05:00 | SPY | ETF | 431.54 | 431.59 | 431.43 | 431.43 | 1939.0 |
| 2023-06-12 04:10:00 | SPY | ETF | 431.43 | 431.43 | 431.26 | 431.32 | 10669.0 |
| 2023-06-12 04:15:00 | SPY | ETF | 431.36 | 431.4 | 431.27 | 431.32 | 958.0 |
| 2023-06-12 04:20:00 | SPY | ETF | 431.37 | 431.42 | 431.29 | 431.39 | 3844.0 |
| 2023-06-12 04:25:00 | SPY | ETF | 431.38 | 431.48 | 431.37 | 431.48 | 897.0 |
| 2023-06-12 04:30:00 | SPY | ETF | 431.54 | 431.54 | 431.53 | 431.53 | 636.0 |
| 2023-06-12 04:35:00 | SPY | ETF | 431.44 | 431.44 | 431.3 | 431.39 | 2100.0 |
| 2023-06-12 04:40:00 | SPY | ETF | 431.35 | 431.39 | 431.33 | 431.36 | 1643.0 |
| 2023-06-12 04:45:00 | SPY | ETF | 431.39 | 431.41 | 431.39 | 431.39 | 1748.0 |
| 2023-06-12 04:55:00 | SPY | ETF | 431.6 | 431.64 | 431.6 | 431.64 | 268.0 |
| 2023-06-12 05:00:00 | SPY | ETF | 431.57 | 431.73 | 431.57 | 431.73 | 1158.0 |
| 2023-06-12 05:05:00 | SPY | ETF | 431.72 | 431.72 | 431.6 | 431.68 | 1623.0 |
| 2023-06-12 05:10:00 | SPY | ETF | 431.72 | 431.72 | 431.7 | 431.7 | 2200.0 |
| 2023-06-12 05:15:00 | SPY | ETF | 431.69 | 431.69 | 431.69 | 431.69 | 100.0 |
| 2023-06-12 05:20:00 | SPY | ETF | 431.59 | 431.63 | 431.56 | 431.59 | 2804.0 |
| 2023-06-12 05:25:00 | SPY | ETF | 431.58 | 431.59 | 431.55 | 431.55 | 1553.0 |
| 2023-06-12 05:30:00 | SPY | ETF | 431.5 | 431.5 | 431.48 | 431.5 | 1942.0 |
| 2023-06-12 05:35:00 | SPY | ETF | 431.48 | 431.51 | 431.48 | 431.51 | 200.0 |
| 2023-06-12 05:40:00 | SPY | ETF | 431.45 | 431.45 | 431.14 | 431.15 | 4465.0 |
| 2023-06-12 05:45:00 | SPY | ETF | 431.07 | 431.14 | 431.06 | 431.06 | 1000.0 |
| 2023-06-12 05:50:00 | SPY | ETF | 431.11 | 431.11 | 430.93 | 430.93 | 1200.0 |
| 2023-06-12 05:55:00 | SPY | ETF | 430.92 | 431.08 | 430.92 | 431.08 | 3470.0 |
| 2023-06-12 06:00:00 | SPY | ETF | 431.05 | 431.05 | 430.86 | 430.95 | 4849.0 |
| 2023-06-12 06:05:00 | SPY | ETF | 430.9 | 430.92 | 430.87 | 430.87 | 1700.0 |
| 2023-06-12 06:10:00 | SPY | ETF | 430.86 | 430.86 | 430.75 | 430.75 | 300.0 |
| 2023-06-12 06:15:00 | SPY | ETF | 430.87 | 430.98 | 430.73 | 430.75 | 1867.0 |
| 2023-06-12 06:20:00 | SPY | ETF | 430.71 | 430.71 | 430.43 | 430.55 | 3900.0 |
| 2023-06-12 06:25:00 | SPY | ETF | 430.56 | 430.63 | 430.51 | 430.6 | 2966.0 |
| 2023-06-12 06:30:00 | SPY | ETF | 430.61 | 430.76 | 430.61 | 430.75 | 1800.0 |
| 2023-06-12 06:35:00 | SPY | ETF | 430.7 | 430.7 | 430.48 | 430.48 | 3451.0 |
| 2023-06-12 06:40:00 | SPY | ETF | 430.53 | 430.7 | 430.53 | 430.55 | 10869.0 |
| 2023-06-12 06:45:00 | SPY | ETF | 430.55 | 430.56 | 430.5 | 430.5 | 400.0 |
| 2023-06-12 06:50:00 | SPY | ETF | 430.63 | 430.63 | 430.63 | 430.63 | 300.0 |
| 2023-06-12 06:55:00 | SPY | ETF | 430.73 | 430.8 | 430.72 | 430.8 | 6837.0 |
| 2023-06-12 07:00:00 | SPY | ETF | 430.7 | 430.89 | 430.61 | 430.87 | 4768.0 |
| 2023-06-12 07:05:00 | SPY | ETF | 430.91 | 430.98 | 430.91 | 430.98 | 8045.0 |
| 2023-06-12 07:10:00 | SPY | ETF | 430.97 | 430.99 | 430.88 | 430.96 | 13232.0 |
| 2023-06-12 07:15:00 | SPY | ETF | 430.97 | 431.05 | 430.97 | 430.97 | 7532.0 |
| 2023-06-12 07:20:00 | SPY | ETF | 430.95 | 431.04 | 430.95 | 430.99 | 4877.0 |
| 2023-06-12 07:25:00 | SPY | ETF | 431.02 | 431.14 | 431.02 | 431.11 | 6008.0 |
| 2023-06-12 07:30:00 | SPY | ETF | 431.09 | 431.26 | 431.09 | 431.18 | 15529.0 |
| 2023-06-12 07:35:00 | SPY | ETF | 431.15 | 431.21 | 431.12 | 431.15 | 4708.0 |
| 2023-06-12 07:40:00 | SPY | ETF | 431.179 | 431.179 | 431.12 | 431.15 | 10186.0 |
| 2023-06-12 07:45:00 | SPY | ETF | 431.179 | 431.19 | 430.99 | 431.16 | 22959.0 |
| 2023-06-12 07:50:00 | SPY | ETF | 431.12 | 431.21 | 431.11 | 431.12 | 3850.0 |
| 2023-06-12 07:55:00 | SPY | ETF | 431.11 | 431.14 | 431.09 | 431.13 | 1866.0 |
| 2023-06-12 08:00:00 | SPY | ETF | 431.03 | 431.7096 | 430.36 | 431.13 | 57979.0 |
| 2023-06-12 08:05:00 | SPY | ETF | 431.14 | 431.14 | 430.89 | 430.92 | 12754.0 |
| 2023-06-12 08:10:00 | SPY | ETF | 430.96 | 431.09 | 430.96 | 431.09 | 3800.0 |
> showing 50 of 95,911 rows — these rows as CSV