PREVIEW / etf_5min / 2022-11-08
file: by_date/etf_5min/2022/2022-11-08.parquet size: 2.0 MB rows: 100,361
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-11-08 04:00:00 | SPY | ETF | 379.39 | 379.73 | 379.03 | 379.07 | 5349.0 |
| 2022-11-08 04:05:00 | SPY | ETF | 379.07 | 379.2 | 379.07 | 379.17 | 5744.0 |
| 2022-11-08 04:10:00 | SPY | ETF | 379.18 | 379.32 | 379.16 | 379.25 | 2681.0 |
| 2022-11-08 04:15:00 | SPY | ETF | 379.09 | 379.19 | 379.05 | 379.17 | 2217.0 |
| 2022-11-08 04:20:00 | SPY | ETF | 379.23 | 379.58 | 379.23 | 379.58 | 652.0 |
| 2022-11-08 04:25:00 | SPY | ETF | 379.65 | 380.17 | 379.65 | 380.17 | 7465.0 |
| 2022-11-08 04:30:00 | SPY | ETF | 380.1 | 380.44 | 380.1 | 380.44 | 5565.0 |
| 2022-11-08 04:35:00 | SPY | ETF | 380.32 | 380.6 | 380.32 | 380.5 | 9650.0 |
| 2022-11-08 04:40:00 | SPY | ETF | 380.5 | 380.52 | 380.42 | 380.52 | 2380.0 |
| 2022-11-08 04:45:00 | SPY | ETF | 380.51 | 380.53 | 380.49 | 380.49 | 1100.0 |
| 2022-11-08 04:50:00 | SPY | ETF | 380.47 | 380.47 | 380.47 | 380.47 | 4879.0 |
| 2022-11-08 04:55:00 | SPY | ETF | 380.44 | 380.68 | 380.43 | 380.64 | 2515.0 |
| 2022-11-08 05:00:00 | SPY | ETF | 380.64 | 380.7 | 380.54 | 380.7 | 555.0 |
| 2022-11-08 05:05:00 | SPY | ETF | 380.71 | 381.08 | 380.71 | 380.94 | 3598.0 |
| 2022-11-08 05:10:00 | SPY | ETF | 380.87 | 380.91 | 380.79 | 380.79 | 770.0 |
| 2022-11-08 05:15:00 | SPY | ETF | 380.83 | 380.83 | 380.8 | 380.8 | 200.0 |
| 2022-11-08 05:20:00 | SPY | ETF | 380.6 | 380.6 | 380.49 | 380.53 | 2532.0 |
| 2022-11-08 05:25:00 | SPY | ETF | 380.41 | 380.45 | 380.35 | 380.45 | 3659.0 |
| 2022-11-08 05:30:00 | SPY | ETF | 380.45 | 380.5 | 380.45 | 380.5 | 200.0 |
| 2022-11-08 05:35:00 | SPY | ETF | 380.3 | 380.51 | 380.3 | 380.34 | 600.0 |
| 2022-11-08 05:40:00 | SPY | ETF | 380.4 | 380.46 | 380.4 | 380.4 | 2621.0 |
| 2022-11-08 05:50:00 | SPY | ETF | 380.47 | 380.47 | 380.47 | 380.47 | 100.0 |
| 2022-11-08 05:55:00 | SPY | ETF | 380.35 | 380.35 | 380.07 | 380.07 | 1062.0 |
| 2022-11-08 06:00:00 | SPY | ETF | 380.24 | 380.24 | 380.17 | 380.17 | 410.0 |
| 2022-11-08 06:05:00 | SPY | ETF | 380.25 | 380.38 | 380.25 | 380.38 | 3722.0 |
| 2022-11-08 06:10:00 | SPY | ETF | 380.53 | 380.53 | 380.4 | 380.4 | 2000.0 |
| 2022-11-08 06:15:00 | SPY | ETF | 380.46 | 380.51 | 380.44 | 380.44 | 1930.0 |
| 2022-11-08 06:20:00 | SPY | ETF | 380.36 | 380.51 | 380.36 | 380.51 | 300.0 |
| 2022-11-08 06:25:00 | SPY | ETF | 380.63 | 380.81 | 380.61 | 380.61 | 2342.0 |
| 2022-11-08 06:30:00 | SPY | ETF | 380.7 | 380.86 | 380.7 | 380.86 | 1850.0 |
| 2022-11-08 06:35:00 | SPY | ETF | 380.84 | 380.93 | 380.75 | 380.91 | 11668.0 |
| 2022-11-08 06:40:00 | SPY | ETF | 381.0 | 381.15 | 380.91 | 380.94 | 18036.0 |
| 2022-11-08 06:45:00 | SPY | ETF | 381.08 | 381.44 | 381.08 | 381.3 | 5550.0 |
| 2022-11-08 06:50:00 | SPY | ETF | 381.4 | 381.5 | 381.35 | 381.5 | 12532.0 |
| 2022-11-08 06:55:00 | SPY | ETF | 381.43 | 381.54 | 381.43 | 381.54 | 5300.0 |
| 2022-11-08 07:00:00 | SPY | ETF | 381.43 | 381.46 | 381.2 | 381.2 | 18120.0 |
| 2022-11-08 07:05:00 | SPY | ETF | 381.14 | 381.38 | 381.14 | 381.24 | 14480.0 |
| 2022-11-08 07:10:00 | SPY | ETF | 381.27 | 381.27 | 381.03 | 381.09 | 23200.0 |
| 2022-11-08 07:15:00 | SPY | ETF | 381.01 | 381.01 | 380.5 | 380.59 | 24501.0 |
| 2022-11-08 07:20:00 | SPY | ETF | 380.56 | 380.66 | 380.55 | 380.66 | 8994.0 |
| 2022-11-08 07:25:00 | SPY | ETF | 380.69 | 380.7 | 380.5 | 380.6 | 12776.0 |
| 2022-11-08 07:30:00 | SPY | ETF | 380.55 | 380.66 | 380.5 | 380.5 | 8796.0 |
| 2022-11-08 07:35:00 | SPY | ETF | 380.5 | 380.71 | 380.34 | 380.41 | 22951.0 |
| 2022-11-08 07:40:00 | SPY | ETF | 380.42 | 380.45 | 380.29 | 380.39 | 29410.0 |
| 2022-11-08 07:45:00 | SPY | ETF | 380.42 | 380.52 | 380.42 | 380.45 | 5051.0 |
| 2022-11-08 07:50:00 | SPY | ETF | 380.7 | 380.7 | 380.6 | 380.61 | 11751.0 |
| 2022-11-08 07:55:00 | SPY | ETF | 380.6 | 380.96 | 380.6 | 380.88 | 7120.0 |
| 2022-11-08 08:00:00 | SPY | ETF | 381.21 | 381.49 | 378.86 | 380.86 | 45576.0 |
| 2022-11-08 08:05:00 | SPY | ETF | 380.78 | 380.78 | 380.52 | 380.56 | 72924.0 |
| 2022-11-08 08:10:00 | SPY | ETF | 380.5 | 380.66 | 380.36 | 380.64 | 25071.0 |
> showing 50 of 100,361 rows — these rows as CSV