PREVIEW / etf_5min / 2022-10-13
file: by_date/etf_5min/2022/2022-10-13.parquet size: 2.1 MB rows: 102,045
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-10-13 04:00:00 | SPY | ETF | 357.35 | 357.43 | 357.13 | 357.13 | 9144.0 |
| 2022-10-13 04:05:00 | SPY | ETF | 357.24 | 357.28 | 357.08 | 357.08 | 1135.0 |
| 2022-10-13 04:10:00 | SPY | ETF | 356.9 | 357.03 | 356.9 | 357.0 | 3901.0 |
| 2022-10-13 04:15:00 | SPY | ETF | 356.96 | 357.05 | 356.96 | 357.05 | 400.0 |
| 2022-10-13 04:25:00 | SPY | ETF | 357.09 | 357.35 | 357.09 | 357.35 | 1167.0 |
| 2022-10-13 04:30:00 | SPY | ETF | 357.39 | 357.67 | 357.39 | 357.67 | 1325.0 |
| 2022-10-13 04:35:00 | SPY | ETF | 357.57 | 357.75 | 357.54 | 357.71 | 1550.0 |
| 2022-10-13 04:40:00 | SPY | ETF | 357.91 | 357.92 | 357.8 | 357.82 | 1274.0 |
| 2022-10-13 04:45:00 | SPY | ETF | 357.86 | 357.92 | 357.8 | 357.9 | 1198.0 |
| 2022-10-13 04:50:00 | SPY | ETF | 358.0 | 358.11 | 357.95 | 358.09 | 5138.0 |
| 2022-10-13 04:55:00 | SPY | ETF | 358.06 | 358.23 | 358.06 | 358.2 | 3773.0 |
| 2022-10-13 05:00:00 | SPY | ETF | 358.2 | 358.3 | 358.19 | 358.21 | 4000.0 |
| 2022-10-13 05:05:00 | SPY | ETF | 358.3 | 358.53 | 358.26 | 358.52 | 8727.0 |
| 2022-10-13 05:10:00 | SPY | ETF | 358.46 | 358.82 | 358.46 | 358.78 | 5240.0 |
| 2022-10-13 05:15:00 | SPY | ETF | 358.8 | 358.81 | 358.7 | 358.77 | 7550.0 |
| 2022-10-13 05:20:00 | SPY | ETF | 358.82 | 358.9 | 358.6 | 358.65 | 2229.0 |
| 2022-10-13 05:25:00 | SPY | ETF | 358.68 | 358.7 | 358.55 | 358.64 | 3764.0 |
| 2022-10-13 05:30:00 | SPY | ETF | 358.7 | 358.86 | 358.69 | 358.85 | 5725.0 |
| 2022-10-13 05:35:00 | SPY | ETF | 358.59 | 358.62 | 358.48 | 358.62 | 2600.0 |
| 2022-10-13 05:40:00 | SPY | ETF | 358.55 | 358.66 | 358.51 | 358.51 | 2207.0 |
| 2022-10-13 05:45:00 | SPY | ETF | 358.51 | 358.71 | 358.49 | 358.51 | 4142.0 |
| 2022-10-13 05:50:00 | SPY | ETF | 358.46 | 358.46 | 358.44 | 358.44 | 1162.0 |
| 2022-10-13 05:55:00 | SPY | ETF | 358.3 | 358.3 | 358.2 | 358.26 | 2200.0 |
| 2022-10-13 06:00:00 | SPY | ETF | 358.26 | 358.32 | 358.26 | 358.27 | 1400.0 |
| 2022-10-13 06:05:00 | SPY | ETF | 358.15 | 358.15 | 358.06 | 358.14 | 2150.0 |
| 2022-10-13 06:10:00 | SPY | ETF | 358.16 | 358.27 | 358.16 | 358.27 | 1150.0 |
| 2022-10-13 06:15:00 | SPY | ETF | 358.28 | 358.28 | 358.18 | 358.27 | 1461.0 |
| 2022-10-13 06:20:00 | SPY | ETF | 358.21 | 358.4 | 358.19 | 358.3 | 104534.0 |
| 2022-10-13 06:25:00 | SPY | ETF | 358.5 | 358.5 | 358.39 | 358.39 | 560.0 |
| 2022-10-13 06:30:00 | SPY | ETF | 358.39 | 358.45 | 358.3 | 358.37 | 10885.0 |
| 2022-10-13 06:35:00 | SPY | ETF | 358.38 | 358.44 | 358.37 | 358.44 | 1250.0 |
| 2022-10-13 06:40:00 | SPY | ETF | 358.7 | 358.7 | 358.64 | 358.7 | 1400.0 |
| 2022-10-13 06:45:00 | SPY | ETF | 358.69 | 358.86 | 358.64 | 358.86 | 8087.0 |
| 2022-10-13 06:50:00 | SPY | ETF | 358.83 | 358.83 | 358.56 | 358.62 | 7750.0 |
| 2022-10-13 06:55:00 | SPY | ETF | 358.56 | 358.61 | 358.55 | 358.6 | 8770.0 |
| 2022-10-13 07:00:00 | SPY | ETF | 358.6 | 358.65 | 358.5 | 358.54 | 17777.0 |
| 2022-10-13 07:05:00 | SPY | ETF | 358.59 | 358.7 | 358.56 | 358.63 | 26297.0 |
| 2022-10-13 07:10:00 | SPY | ETF | 358.65 | 358.94 | 358.63 | 358.93 | 17445.0 |
| 2022-10-13 07:15:00 | SPY | ETF | 358.95 | 359.11 | 358.8 | 358.961 | 82982.0 |
| 2022-10-13 07:20:00 | SPY | ETF | 358.99 | 359.03 | 358.68 | 358.74 | 60365.0 |
| 2022-10-13 07:25:00 | SPY | ETF | 358.68 | 359.1 | 358.68 | 358.94 | 30724.0 |
| 2022-10-13 07:30:00 | SPY | ETF | 359.0 | 359.53 | 358.87 | 359.23 | 27084.0 |
| 2022-10-13 07:35:00 | SPY | ETF | 359.29 | 361.12 | 359.27 | 360.58 | 254287.0 |
| 2022-10-13 07:40:00 | SPY | ETF | 360.58 | 361.0 | 360.1 | 360.17 | 238597.0 |
| 2022-10-13 07:45:00 | SPY | ETF | 360.25 | 360.32 | 359.86 | 360.13 | 143541.0 |
| 2022-10-13 07:50:00 | SPY | ETF | 360.13 | 360.3 | 359.95 | 360.3 | 69670.0 |
| 2022-10-13 07:55:00 | SPY | ETF | 360.29 | 360.43 | 360.08 | 360.12 | 72235.0 |
| 2022-10-13 08:00:00 | SPY | ETF | 358.59 | 360.8904 | 356.2 | 357.25 | 323542.0 |
| 2022-10-13 08:05:00 | SPY | ETF | 360.6 | 360.78 | 360.24 | 360.32 | 80547.0 |
| 2022-10-13 08:10:00 | SPY | ETF | 360.32 | 360.37 | 357.43 | 360.28 | 459118.0 |
> showing 50 of 102,045 rows — these rows as CSV