PREVIEW / etf_5min / 2023-02-06
file: by_date/etf_5min/2023/2023-02-06.parquet size: 2.0 MB rows: 98,898
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-02-06 04:00:00 | SPY | ETF | 410.25 | 410.95 | 409.95 | 410.02 | 13318.0 |
| 2023-02-06 04:05:00 | SPY | ETF | 410.09 | 410.26 | 410.06 | 410.09 | 5681.0 |
| 2023-02-06 04:10:00 | SPY | ETF | 410.01 | 410.1 | 409.65 | 409.68 | 5921.0 |
| 2023-02-06 04:15:00 | SPY | ETF | 409.7 | 409.75 | 409.61 | 409.61 | 5867.0 |
| 2023-02-06 04:20:00 | SPY | ETF | 409.87 | 409.88 | 409.73 | 409.74 | 1258.0 |
| 2023-02-06 04:25:00 | SPY | ETF | 409.81 | 409.93 | 409.79 | 409.91 | 5841.0 |
| 2023-02-06 04:30:00 | SPY | ETF | 409.98 | 410.06 | 409.98 | 410.06 | 4724.0 |
| 2023-02-06 04:35:00 | SPY | ETF | 409.99 | 410.0 | 409.67 | 409.67 | 5113.0 |
| 2023-02-06 04:40:00 | SPY | ETF | 409.71 | 409.71 | 409.33 | 409.33 | 22077.0 |
| 2023-02-06 04:45:00 | SPY | ETF | 409.29 | 409.46 | 409.29 | 409.4 | 5475.0 |
| 2023-02-06 04:50:00 | SPY | ETF | 409.34 | 409.36 | 409.17 | 409.19 | 22550.0 |
| 2023-02-06 04:55:00 | SPY | ETF | 409.15 | 409.15 | 409.04 | 409.08 | 1850.0 |
| 2023-02-06 05:00:00 | SPY | ETF | 409.04 | 409.06 | 408.81 | 408.81 | 13414.0 |
| 2023-02-06 05:05:00 | SPY | ETF | 408.86 | 409.02 | 408.86 | 408.89 | 3781.0 |
| 2023-02-06 05:10:00 | SPY | ETF | 408.96 | 409.07 | 408.94 | 409.07 | 3158.0 |
| 2023-02-06 05:15:00 | SPY | ETF | 409.09 | 409.09 | 408.91 | 408.91 | 1111.0 |
| 2023-02-06 05:20:00 | SPY | ETF | 408.9 | 408.9 | 408.85 | 408.85 | 300.0 |
| 2023-02-06 05:25:00 | SPY | ETF | 408.82 | 408.82 | 408.62 | 408.78 | 6756.0 |
| 2023-02-06 05:30:00 | SPY | ETF | 408.76 | 408.83 | 408.73 | 408.73 | 5800.0 |
| 2023-02-06 05:35:00 | SPY | ETF | 408.76 | 408.76 | 408.56 | 408.56 | 5030.0 |
| 2023-02-06 05:40:00 | SPY | ETF | 408.61 | 408.65 | 408.53 | 408.63 | 3375.0 |
| 2023-02-06 05:45:00 | SPY | ETF | 408.6 | 408.69 | 408.39 | 408.39 | 12699.0 |
| 2023-02-06 05:50:00 | SPY | ETF | 408.4 | 408.74 | 408.39 | 408.74 | 6322.0 |
| 2023-02-06 05:55:00 | SPY | ETF | 408.88 | 408.97 | 408.83 | 408.93 | 6141.0 |
| 2023-02-06 06:00:00 | SPY | ETF | 408.84 | 408.95 | 408.6 | 408.61 | 4291.0 |
| 2023-02-06 06:05:00 | SPY | ETF | 408.66 | 408.67 | 408.61 | 408.61 | 400.0 |
| 2023-02-06 06:10:00 | SPY | ETF | 408.65 | 408.65 | 408.44 | 408.51 | 3200.0 |
| 2023-02-06 06:15:00 | SPY | ETF | 408.65 | 408.87 | 408.65 | 408.8 | 6634.0 |
| 2023-02-06 06:20:00 | SPY | ETF | 408.77 | 408.81 | 408.66 | 408.66 | 1350.0 |
| 2023-02-06 06:25:00 | SPY | ETF | 408.7 | 408.7 | 408.7 | 408.7 | 100.0 |
| 2023-02-06 06:30:00 | SPY | ETF | 408.64 | 408.64 | 408.44 | 408.44 | 2130.0 |
| 2023-02-06 06:35:00 | SPY | ETF | 408.62 | 408.64 | 408.62 | 408.63 | 4980.0 |
| 2023-02-06 06:40:00 | SPY | ETF | 408.7 | 408.81 | 408.7 | 408.77 | 2600.0 |
| 2023-02-06 06:45:00 | SPY | ETF | 408.85 | 409.12 | 408.8 | 409.11 | 25939.0 |
| 2023-02-06 06:50:00 | SPY | ETF | 409.09 | 409.18 | 409.0 | 409.18 | 1300.0 |
| 2023-02-06 06:55:00 | SPY | ETF | 409.18 | 409.31 | 409.15 | 409.29 | 8542.0 |
| 2023-02-06 07:00:00 | SPY | ETF | 409.24 | 409.5 | 409.23 | 409.25 | 16774.0 |
| 2023-02-06 07:05:00 | SPY | ETF | 409.25 | 409.55 | 409.25 | 409.5 | 15084.0 |
| 2023-02-06 07:10:00 | SPY | ETF | 409.54 | 409.65 | 409.54 | 409.58 | 8843.0 |
| 2023-02-06 07:15:00 | SPY | ETF | 409.62 | 409.66 | 409.32 | 409.32 | 24603.0 |
| 2023-02-06 07:20:00 | SPY | ETF | 409.29 | 409.46 | 409.25 | 409.25 | 6828.0 |
| 2023-02-06 07:25:00 | SPY | ETF | 409.22 | 409.41 | 409.22 | 409.41 | 17237.0 |
| 2023-02-06 07:30:00 | SPY | ETF | 409.41 | 409.46 | 409.21 | 409.42 | 5904.0 |
| 2023-02-06 07:35:00 | SPY | ETF | 409.43 | 409.84 | 409.39 | 409.75 | 31471.0 |
| 2023-02-06 07:40:00 | SPY | ETF | 409.81 | 410.05 | 409.8 | 409.92 | 96981.0 |
| 2023-02-06 07:45:00 | SPY | ETF | 409.98 | 410.12 | 409.88 | 410.06 | 17534.0 |
| 2023-02-06 07:50:00 | SPY | ETF | 410.04 | 410.13 | 409.99 | 410.0 | 15609.0 |
| 2023-02-06 07:55:00 | SPY | ETF | 410.0 | 410.05 | 409.9 | 410.01 | 5450.0 |
| 2023-02-06 08:00:00 | SPY | ETF | 409.98 | 411.15 | 408.86 | 409.83 | 62125.0 |
| 2023-02-06 08:05:00 | SPY | ETF | 409.81 | 409.81 | 409.6 | 409.78 | 16392.0 |
> showing 50 of 98,898 rows — these rows as CSV