PREVIEW / etf_5min / 2022-05-13
file: by_date/etf_5min/2022/2022-05-13.parquet size: 2.0 MB rows: 99,602
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-13 04:00:00 | SPY | ETF | 396.25 | 396.79 | 396.0 | 396.73 | 8406.0 |
| 2022-05-13 04:05:00 | SPY | ETF | 396.71 | 397.0 | 396.68 | 396.84 | 4745.0 |
| 2022-05-13 04:10:00 | SPY | ETF | 396.83 | 396.83 | 396.48 | 396.48 | 9142.0 |
| 2022-05-13 04:15:00 | SPY | ETF | 396.45 | 396.96 | 396.45 | 396.92 | 27052.0 |
| 2022-05-13 04:20:00 | SPY | ETF | 396.8 | 397.01 | 396.71 | 397.01 | 3689.0 |
| 2022-05-13 04:25:00 | SPY | ETF | 397.09 | 397.09 | 396.99 | 396.99 | 2029.0 |
| 2022-05-13 04:30:00 | SPY | ETF | 396.99 | 397.07 | 396.71 | 397.07 | 4330.0 |
| 2022-05-13 04:35:00 | SPY | ETF | 396.94 | 396.94 | 396.65 | 396.75 | 4243.0 |
| 2022-05-13 04:40:00 | SPY | ETF | 396.62 | 396.62 | 396.59 | 396.59 | 600.0 |
| 2022-05-13 04:45:00 | SPY | ETF | 396.43 | 396.44 | 396.21 | 396.25 | 1780.0 |
| 2022-05-13 04:50:00 | SPY | ETF | 396.28 | 396.35 | 396.11 | 396.32 | 3200.0 |
| 2022-05-13 04:55:00 | SPY | ETF | 396.49 | 396.61 | 396.4 | 396.51 | 7896.0 |
| 2022-05-13 05:00:00 | SPY | ETF | 396.71 | 396.85 | 396.63 | 396.85 | 4000.0 |
| 2022-05-13 05:05:00 | SPY | ETF | 396.85 | 397.15 | 396.84 | 397.14 | 5652.0 |
| 2022-05-13 05:10:00 | SPY | ETF | 397.1 | 397.1 | 397.0 | 397.02 | 5639.0 |
| 2022-05-13 05:15:00 | SPY | ETF | 397.0 | 397.0 | 396.91 | 397.0 | 1902.0 |
| 2022-05-13 05:20:00 | SPY | ETF | 397.0 | 397.06 | 396.96 | 396.96 | 3544.0 |
| 2022-05-13 05:25:00 | SPY | ETF | 396.91 | 397.3 | 396.71 | 396.79 | 6414.0 |
| 2022-05-13 05:30:00 | SPY | ETF | 396.8 | 396.8 | 396.3 | 396.3 | 3822.0 |
| 2022-05-13 05:35:00 | SPY | ETF | 396.37 | 396.5 | 396.25 | 396.47 | 11601.0 |
| 2022-05-13 05:40:00 | SPY | ETF | 396.35 | 396.54 | 396.3 | 396.54 | 3873.0 |
| 2022-05-13 05:45:00 | SPY | ETF | 396.55 | 396.69 | 396.2 | 396.2 | 4972.0 |
| 2022-05-13 05:50:00 | SPY | ETF | 396.23 | 396.23 | 395.88 | 395.88 | 9548.0 |
| 2022-05-13 05:55:00 | SPY | ETF | 395.83 | 396.2 | 395.83 | 396.18 | 5753.0 |
| 2022-05-13 06:00:00 | SPY | ETF | 396.17 | 396.27 | 396.1 | 396.27 | 2711.0 |
| 2022-05-13 06:05:00 | SPY | ETF | 396.27 | 396.27 | 395.8 | 395.83 | 1932.0 |
| 2022-05-13 06:10:00 | SPY | ETF | 395.92 | 396.5 | 395.75 | 396.5 | 3574.0 |
| 2022-05-13 06:15:00 | SPY | ETF | 396.51 | 396.51 | 396.26 | 396.26 | 2150.0 |
| 2022-05-13 06:20:00 | SPY | ETF | 396.22 | 396.36 | 396.21 | 396.36 | 1600.0 |
| 2022-05-13 06:25:00 | SPY | ETF | 396.37 | 396.48 | 396.3 | 396.35 | 5934.0 |
| 2022-05-13 06:30:00 | SPY | ETF | 396.3 | 396.57 | 396.3 | 396.57 | 2415.0 |
| 2022-05-13 06:35:00 | SPY | ETF | 396.58 | 396.88 | 396.58 | 396.81 | 4000.0 |
| 2022-05-13 06:40:00 | SPY | ETF | 396.89 | 396.89 | 396.54 | 396.54 | 2600.0 |
| 2022-05-13 06:45:00 | SPY | ETF | 396.58 | 396.67 | 396.58 | 396.67 | 3400.0 |
| 2022-05-13 06:50:00 | SPY | ETF | 396.65 | 396.75 | 396.62 | 396.7 | 5205.0 |
| 2022-05-13 06:55:00 | SPY | ETF | 396.66 | 396.99 | 396.66 | 396.71 | 2490.0 |
| 2022-05-13 07:00:00 | SPY | ETF | 396.8 | 396.93 | 396.53 | 396.59 | 15683.0 |
| 2022-05-13 07:05:00 | SPY | ETF | 396.6 | 396.6 | 396.41 | 396.5 | 4317.0 |
| 2022-05-13 07:10:00 | SPY | ETF | 396.5 | 396.64 | 396.48 | 396.48 | 2019.0 |
| 2022-05-13 07:15:00 | SPY | ETF | 396.59 | 396.61 | 396.45 | 396.46 | 3343.0 |
| 2022-05-13 07:20:00 | SPY | ETF | 396.42 | 396.53 | 396.32 | 396.5 | 9992.0 |
| 2022-05-13 07:25:00 | SPY | ETF | 396.49 | 396.69 | 396.46 | 396.59 | 12959.0 |
| 2022-05-13 07:30:00 | SPY | ETF | 396.64 | 397.0 | 396.5 | 397.0 | 19636.0 |
| 2022-05-13 07:35:00 | SPY | ETF | 397.04 | 397.12 | 396.95 | 397.02 | 19934.0 |
| 2022-05-13 07:40:00 | SPY | ETF | 397.0 | 397.19 | 396.9 | 397.19 | 19472.0 |
| 2022-05-13 07:45:00 | SPY | ETF | 397.17 | 397.41 | 396.99 | 397.41 | 17414.0 |
| 2022-05-13 07:50:00 | SPY | ETF | 397.4 | 397.41 | 397.03 | 397.34 | 19965.0 |
| 2022-05-13 07:55:00 | SPY | ETF | 397.41 | 398.36 | 397.41 | 398.12 | 69628.0 |
| 2022-05-13 08:00:00 | SPY | ETF | 398.18 | 398.35 | 395.46 | 397.8 | 152680.0 |
| 2022-05-13 08:05:00 | SPY | ETF | 397.78 | 397.91 | 397.64 | 397.84 | 50407.0 |
> showing 50 of 99,602 rows — these rows as CSV