PREVIEW / etf_5min / 2022-10-27
file: by_date/etf_5min/2022/2022-10-27.parquet size: 2.0 MB rows: 98,289
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-27 04:00:00 | SPY | ETF | 382.8 | 383.17 | 382.71 | 383.09 | 8020.0 |
| 2022-10-27 04:05:00 | SPY | ETF | 382.87 | 382.92 | 382.55 | 382.58 | 11600.0 |
| 2022-10-27 04:10:00 | SPY | ETF | 382.61 | 383.25 | 382.61 | 383.25 | 2752.0 |
| 2022-10-27 04:15:00 | SPY | ETF | 383.26 | 383.76 | 383.26 | 383.7 | 17055.0 |
| 2022-10-27 04:20:00 | SPY | ETF | 383.5 | 383.5 | 383.24 | 383.24 | 5700.0 |
| 2022-10-27 04:25:00 | SPY | ETF | 383.45 | 383.58 | 383.38 | 383.38 | 1700.0 |
| 2022-10-27 04:30:00 | SPY | ETF | 383.3 | 383.5 | 383.3 | 383.5 | 5775.0 |
| 2022-10-27 04:35:00 | SPY | ETF | 383.5 | 383.5 | 383.43 | 383.5 | 1150.0 |
| 2022-10-27 04:40:00 | SPY | ETF | 383.3 | 383.3 | 383.02 | 383.18 | 4105.0 |
| 2022-10-27 04:45:00 | SPY | ETF | 383.26 | 383.31 | 383.21 | 383.29 | 4375.0 |
| 2022-10-27 04:50:00 | SPY | ETF | 383.41 | 383.58 | 383.25 | 383.29 | 3350.0 |
| 2022-10-27 04:55:00 | SPY | ETF | 383.29 | 383.29 | 383.17 | 383.2 | 2350.0 |
| 2022-10-27 05:00:00 | SPY | ETF | 383.01 | 383.09 | 382.91 | 383.09 | 5455.0 |
| 2022-10-27 05:05:00 | SPY | ETF | 382.92 | 382.92 | 382.53 | 382.55 | 2600.0 |
| 2022-10-27 05:10:00 | SPY | ETF | 382.77 | 382.77 | 382.5 | 382.5 | 1296.0 |
| 2022-10-27 05:15:00 | SPY | ETF | 382.56 | 382.76 | 382.56 | 382.75 | 3450.0 |
| 2022-10-27 05:20:00 | SPY | ETF | 382.83 | 383.05 | 382.83 | 382.86 | 50630.0 |
| 2022-10-27 05:25:00 | SPY | ETF | 382.8 | 382.81 | 382.75 | 382.75 | 20100.0 |
| 2022-10-27 05:30:00 | SPY | ETF | 382.78 | 382.78 | 382.4 | 382.45 | 1800.0 |
| 2022-10-27 05:35:00 | SPY | ETF | 382.61 | 382.68 | 382.33 | 382.37 | 7423.0 |
| 2022-10-27 05:40:00 | SPY | ETF | 382.47 | 382.51 | 382.36 | 382.36 | 3499.0 |
| 2022-10-27 05:45:00 | SPY | ETF | 382.41 | 382.41 | 382.26 | 382.3 | 500.0 |
| 2022-10-27 05:50:00 | SPY | ETF | 382.43 | 382.73 | 382.36 | 382.36 | 1400.0 |
| 2022-10-27 05:55:00 | SPY | ETF | 382.39 | 382.4 | 382.11 | 382.13 | 2700.0 |
| 2022-10-27 06:00:00 | SPY | ETF | 382.11 | 382.2 | 382.01 | 382.2 | 3100.0 |
| 2022-10-27 06:05:00 | SPY | ETF | 382.3 | 382.36 | 382.29 | 382.36 | 4918.0 |
| 2022-10-27 06:10:00 | SPY | ETF | 382.3 | 382.45 | 382.25 | 382.45 | 2550.0 |
| 2022-10-27 06:15:00 | SPY | ETF | 382.39 | 382.4 | 382.39 | 382.4 | 1084.0 |
| 2022-10-27 06:20:00 | SPY | ETF | 382.27 | 382.27 | 382.11 | 382.11 | 1650.0 |
| 2022-10-27 06:25:00 | SPY | ETF | 382.12 | 382.12 | 382.0 | 382.12 | 7725.0 |
| 2022-10-27 06:30:00 | SPY | ETF | 382.08 | 382.48 | 382.08 | 382.32 | 1910.0 |
| 2022-10-27 06:35:00 | SPY | ETF | 382.33 | 382.33 | 381.87 | 382.06 | 3750.0 |
| 2022-10-27 06:40:00 | SPY | ETF | 382.12 | 382.13 | 381.71 | 381.76 | 3833.0 |
| 2022-10-27 06:45:00 | SPY | ETF | 381.84 | 382.03 | 381.7 | 382.03 | 21290.0 |
| 2022-10-27 06:50:00 | SPY | ETF | 381.98 | 382.02 | 381.73 | 381.9 | 26231.0 |
| 2022-10-27 06:55:00 | SPY | ETF | 381.85 | 381.9 | 381.73 | 381.73 | 1600.0 |
| 2022-10-27 07:00:00 | SPY | ETF | 381.83 | 382.33 | 381.79 | 382.21 | 29342.0 |
| 2022-10-27 07:05:00 | SPY | ETF | 382.19 | 382.24 | 381.8 | 382.23 | 15352.0 |
| 2022-10-27 07:10:00 | SPY | ETF | 382.2 | 382.31 | 382.12 | 382.22 | 20914.0 |
| 2022-10-27 07:15:00 | SPY | ETF | 382.17 | 382.58 | 382.09 | 382.53 | 8911.0 |
| 2022-10-27 07:20:00 | SPY | ETF | 382.56 | 382.57 | 382.38 | 382.5 | 21538.0 |
| 2022-10-27 07:25:00 | SPY | ETF | 382.45 | 382.45 | 382.31 | 382.45 | 7073.0 |
| 2022-10-27 07:30:00 | SPY | ETF | 382.38 | 382.44 | 382.15 | 382.44 | 4555.0 |
| 2022-10-27 07:35:00 | SPY | ETF | 382.38 | 382.38 | 382.11 | 382.29 | 11553.0 |
| 2022-10-27 07:40:00 | SPY | ETF | 382.34 | 382.42 | 382.0 | 382.0 | 5817.0 |
| 2022-10-27 07:45:00 | SPY | ETF | 382.05 | 382.05 | 381.81 | 381.81 | 5008.0 |
| 2022-10-27 07:50:00 | SPY | ETF | 381.82 | 381.93 | 381.6 | 381.6 | 24279.0 |
| 2022-10-27 07:55:00 | SPY | ETF | 381.6 | 381.71 | 381.43 | 381.66 | 41578.0 |
| 2022-10-27 08:00:00 | SPY | ETF | 381.83 | 384.12 | 381.43 | 381.69 | 72424.0 |
| 2022-10-27 08:05:00 | SPY | ETF | 381.8 | 381.92 | 381.67 | 381.72 | 16161.0 |
> showing 50 of 98,289 rows — these rows as CSV