PREVIEW / etf_5min / 2023-10-03
file: by_date/etf_5min/2023/2023-10-03.parquet size: 2.1 MB rows: 104,363
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-10-03 04:00:00 | SPY | ETF | 427.46 | 427.99 | 427.45 | 427.98 | 12164.0 |
| 2023-10-03 04:05:00 | SPY | ETF | 427.98 | 428.21 | 427.98 | 428.21 | 7490.0 |
| 2023-10-03 04:10:00 | SPY | ETF | 428.25 | 428.28 | 428.12 | 428.18 | 4004.0 |
| 2023-10-03 04:15:00 | SPY | ETF | 428.19 | 428.45 | 428.19 | 428.45 | 3484.0 |
| 2023-10-03 04:20:00 | SPY | ETF | 428.46 | 428.46 | 428.1 | 428.17 | 2836.0 |
| 2023-10-03 04:25:00 | SPY | ETF | 428.23 | 428.37 | 428.23 | 428.37 | 2380.0 |
| 2023-10-03 04:30:00 | SPY | ETF | 428.34 | 428.4 | 428.17 | 428.19 | 1416.0 |
| 2023-10-03 04:35:00 | SPY | ETF | 428.2 | 428.21 | 428.04 | 428.04 | 900.0 |
| 2023-10-03 04:40:00 | SPY | ETF | 428.07 | 428.07 | 428.03 | 428.06 | 496.0 |
| 2023-10-03 04:45:00 | SPY | ETF | 428.05 | 428.21 | 428.05 | 428.19 | 1250.0 |
| 2023-10-03 04:50:00 | SPY | ETF | 428.19 | 428.25 | 428.17 | 428.25 | 475.0 |
| 2023-10-03 04:55:00 | SPY | ETF | 428.24 | 428.24 | 428.05 | 428.05 | 4392.0 |
| 2023-10-03 05:00:00 | SPY | ETF | 428.05 | 428.05 | 427.74 | 427.9 | 1751.0 |
| 2023-10-03 05:05:00 | SPY | ETF | 427.9 | 427.9 | 427.68 | 427.77 | 4950.0 |
| 2023-10-03 05:10:00 | SPY | ETF | 427.71 | 427.71 | 427.6 | 427.71 | 2800.0 |
| 2023-10-03 05:15:00 | SPY | ETF | 427.73 | 428.03 | 427.73 | 428.03 | 1100.0 |
| 2023-10-03 05:20:00 | SPY | ETF | 427.89 | 427.89 | 427.73 | 427.73 | 800.0 |
| 2023-10-03 05:25:00 | SPY | ETF | 427.79 | 427.86 | 427.79 | 427.86 | 1515.0 |
| 2023-10-03 05:30:00 | SPY | ETF | 427.77 | 427.78 | 427.6 | 427.6 | 709.0 |
| 2023-10-03 05:35:00 | SPY | ETF | 427.6 | 427.61 | 427.6 | 427.61 | 900.0 |
| 2023-10-03 05:40:00 | SPY | ETF | 427.57 | 427.63 | 427.48 | 427.63 | 693.0 |
| 2023-10-03 05:45:00 | SPY | ETF | 427.66 | 427.68 | 427.48 | 427.54 | 526.0 |
| 2023-10-03 05:50:00 | SPY | ETF | 427.81 | 427.9 | 427.81 | 427.9 | 700.0 |
| 2023-10-03 05:55:00 | SPY | ETF | 427.81 | 427.81 | 427.71 | 427.71 | 600.0 |
| 2023-10-03 06:00:00 | SPY | ETF | 427.67 | 427.87 | 427.62 | 427.87 | 600.0 |
| 2023-10-03 06:05:00 | SPY | ETF | 427.93 | 427.93 | 427.83 | 427.83 | 713.0 |
| 2023-10-03 06:10:00 | SPY | ETF | 427.9 | 427.9 | 427.65 | 427.66 | 1795.0 |
| 2023-10-03 06:15:00 | SPY | ETF | 427.51 | 427.53 | 427.44 | 427.49 | 1400.0 |
| 2023-10-03 06:20:00 | SPY | ETF | 427.57 | 427.68 | 427.57 | 427.63 | 700.0 |
| 2023-10-03 06:25:00 | SPY | ETF | 427.72 | 427.88 | 427.72 | 427.88 | 1292.0 |
| 2023-10-03 06:30:00 | SPY | ETF | 428.0 | 428.12 | 427.9 | 428.03 | 3526.0 |
| 2023-10-03 06:35:00 | SPY | ETF | 427.77 | 427.77 | 427.77 | 427.77 | 400.0 |
| 2023-10-03 06:40:00 | SPY | ETF | 427.69 | 427.72 | 427.41 | 427.41 | 6315.0 |
| 2023-10-03 06:45:00 | SPY | ETF | 427.47 | 427.48 | 427.38 | 427.38 | 6106.0 |
| 2023-10-03 06:50:00 | SPY | ETF | 427.39 | 427.39 | 427.35 | 427.36 | 2330.0 |
| 2023-10-03 06:55:00 | SPY | ETF | 427.26 | 427.26 | 427.26 | 427.26 | 100.0 |
| 2023-10-03 07:00:00 | SPY | ETF | 427.13 | 427.22 | 426.95 | 427.01 | 135309.0 |
| 2023-10-03 07:05:00 | SPY | ETF | 427.03 | 427.03 | 426.8 | 426.8 | 13477.0 |
| 2023-10-03 07:10:00 | SPY | ETF | 426.73 | 426.73 | 426.3 | 426.39 | 31990.0 |
| 2023-10-03 07:15:00 | SPY | ETF | 426.36 | 426.41 | 426.07 | 426.16 | 18585.0 |
| 2023-10-03 07:20:00 | SPY | ETF | 426.11 | 426.3 | 425.4 | 425.81 | 169785.0 |
| 2023-10-03 07:25:00 | SPY | ETF | 425.81 | 425.88 | 425.68 | 425.84 | 83008.0 |
| 2023-10-03 07:30:00 | SPY | ETF | 425.86 | 426.07 | 425.86 | 425.88 | 36831.0 |
| 2023-10-03 07:35:00 | SPY | ETF | 425.88 | 425.95 | 425.59 | 425.69 | 133077.0 |
| 2023-10-03 07:40:00 | SPY | ETF | 425.67 | 425.77 | 425.48 | 425.48 | 19305.0 |
| 2023-10-03 07:45:00 | SPY | ETF | 425.479 | 425.52 | 425.25 | 425.25 | 78362.0 |
| 2023-10-03 07:50:00 | SPY | ETF | 425.19 | 425.29 | 425.08 | 425.28 | 106024.0 |
| 2023-10-03 07:55:00 | SPY | ETF | 425.28 | 425.45 | 425.28 | 425.39 | 36174.0 |
| 2023-10-03 08:00:00 | SPY | ETF | 425.89 | 428.2896 | 425.02 | 425.15 | 115671.0 |
| 2023-10-03 08:05:00 | SPY | ETF | 425.17 | 425.19 | 424.94 | 424.94 | 58153.0 |
> showing 50 of 104,363 rows — these rows as CSV