PREVIEW / etf_5min / 2022-06-10
file: by_date/etf_5min/2022/2022-06-10.parquet size: 2.0 MB rows: 99,781
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-06-10 04:00:00 | SPY | ETF | 400.9 | 401.75 | 400.9 | 401.71 | 11595.0 |
| 2022-06-10 04:05:00 | SPY | ETF | 401.69 | 402.05 | 401.53 | 401.9 | 2435.0 |
| 2022-06-10 04:10:00 | SPY | ETF | 402.1 | 402.34 | 402.1 | 402.24 | 10972.0 |
| 2022-06-10 04:15:00 | SPY | ETF | 402.22 | 402.35 | 402.18 | 402.35 | 6865.0 |
| 2022-06-10 04:20:00 | SPY | ETF | 402.06 | 402.18 | 402.03 | 402.06 | 2476.0 |
| 2022-06-10 04:25:00 | SPY | ETF | 402.04 | 402.26 | 401.98 | 402.06 | 1536.0 |
| 2022-06-10 04:30:00 | SPY | ETF | 402.05 | 402.13 | 401.89 | 401.92 | 6289.0 |
| 2022-06-10 04:35:00 | SPY | ETF | 401.75 | 401.83 | 401.47 | 401.83 | 2854.0 |
| 2022-06-10 04:40:00 | SPY | ETF | 401.69 | 401.93 | 401.69 | 401.93 | 1824.0 |
| 2022-06-10 04:45:00 | SPY | ETF | 402.13 | 402.18 | 402.06 | 402.18 | 1717.0 |
| 2022-06-10 04:50:00 | SPY | ETF | 402.0 | 402.0 | 401.39 | 401.44 | 10749.0 |
| 2022-06-10 04:55:00 | SPY | ETF | 401.59 | 401.6 | 401.32 | 401.35 | 6240.0 |
| 2022-06-10 05:00:00 | SPY | ETF | 401.3 | 401.74 | 401.29 | 401.59 | 3716.0 |
| 2022-06-10 05:05:00 | SPY | ETF | 401.59 | 401.59 | 401.59 | 401.59 | 400.0 |
| 2022-06-10 05:10:00 | SPY | ETF | 401.5 | 401.83 | 401.5 | 401.79 | 1400.0 |
| 2022-06-10 05:15:00 | SPY | ETF | 401.9 | 401.9 | 401.85 | 401.85 | 590.0 |
| 2022-06-10 05:20:00 | SPY | ETF | 401.64 | 401.64 | 401.44 | 401.44 | 1723.0 |
| 2022-06-10 05:25:00 | SPY | ETF | 401.43 | 401.8 | 401.36 | 401.78 | 2110.0 |
| 2022-06-10 05:30:00 | SPY | ETF | 401.86 | 401.86 | 401.8 | 401.82 | 745.0 |
| 2022-06-10 05:35:00 | SPY | ETF | 401.48 | 401.48 | 401.48 | 401.48 | 100.0 |
| 2022-06-10 05:40:00 | SPY | ETF | 401.55 | 401.99 | 401.55 | 401.99 | 1400.0 |
| 2022-06-10 05:45:00 | SPY | ETF | 402.03 | 402.08 | 401.51 | 401.51 | 1502.0 |
| 2022-06-10 05:50:00 | SPY | ETF | 401.44 | 401.56 | 401.32 | 401.51 | 4031.0 |
| 2022-06-10 05:55:00 | SPY | ETF | 401.29 | 401.34 | 401.22 | 401.28 | 3800.0 |
| 2022-06-10 06:00:00 | SPY | ETF | 401.51 | 401.57 | 401.32 | 401.32 | 1799.0 |
| 2022-06-10 06:05:00 | SPY | ETF | 401.28 | 401.42 | 401.16 | 401.16 | 1900.0 |
| 2022-06-10 06:10:00 | SPY | ETF | 401.29 | 401.33 | 401.13 | 401.21 | 2000.0 |
| 2022-06-10 06:15:00 | SPY | ETF | 401.33 | 401.4 | 401.2 | 401.2 | 3500.0 |
| 2022-06-10 06:20:00 | SPY | ETF | 401.45 | 401.46 | 400.79 | 400.79 | 16403.0 |
| 2022-06-10 06:25:00 | SPY | ETF | 400.87 | 400.9 | 400.66 | 400.75 | 14900.0 |
| 2022-06-10 06:30:00 | SPY | ETF | 400.66 | 401.0 | 400.66 | 400.73 | 6150.0 |
| 2022-06-10 06:35:00 | SPY | ETF | 400.77 | 401.01 | 400.77 | 401.01 | 5860.0 |
| 2022-06-10 06:40:00 | SPY | ETF | 400.92 | 400.96 | 400.75 | 400.79 | 2599.0 |
| 2022-06-10 06:45:00 | SPY | ETF | 400.75 | 400.94 | 400.75 | 400.78 | 4389.0 |
| 2022-06-10 06:50:00 | SPY | ETF | 400.79 | 401.0 | 400.72 | 400.93 | 6290.0 |
| 2022-06-10 06:55:00 | SPY | ETF | 400.9 | 400.97 | 400.6 | 400.97 | 18503.0 |
| 2022-06-10 07:00:00 | SPY | ETF | 401.1 | 401.12 | 400.89 | 400.97 | 7677.0 |
| 2022-06-10 07:05:00 | SPY | ETF | 400.95 | 401.3 | 400.88 | 401.28 | 19710.0 |
| 2022-06-10 07:10:00 | SPY | ETF | 401.4 | 401.43 | 401.02 | 401.39 | 25788.0 |
| 2022-06-10 07:15:00 | SPY | ETF | 401.3 | 401.3 | 400.96 | 401.0 | 20122.0 |
| 2022-06-10 07:20:00 | SPY | ETF | 401.0 | 401.18 | 401.0 | 401.18 | 11008.0 |
| 2022-06-10 07:25:00 | SPY | ETF | 401.07 | 401.2 | 400.97 | 401.2 | 8914.0 |
| 2022-06-10 07:30:00 | SPY | ETF | 401.2 | 401.87 | 401.2 | 401.75 | 37340.0 |
| 2022-06-10 07:35:00 | SPY | ETF | 401.72 | 402.05 | 401.5 | 401.5 | 25700.0 |
| 2022-06-10 07:40:00 | SPY | ETF | 401.48 | 401.68 | 401.42 | 401.6 | 29474.0 |
| 2022-06-10 07:45:00 | SPY | ETF | 401.65 | 401.77 | 401.37 | 401.52 | 11607.0 |
| 2022-06-10 07:50:00 | SPY | ETF | 401.47 | 401.58 | 401.38 | 401.4 | 8789.0 |
| 2022-06-10 07:55:00 | SPY | ETF | 401.42 | 401.62 | 401.25 | 401.3 | 18899.0 |
| 2022-06-10 08:00:00 | SPY | ETF | 401.1 | 402.3 | 400.83 | 401.44 | 81323.0 |
| 2022-06-10 08:05:00 | SPY | ETF | 401.43 | 401.78 | 401.39 | 401.73 | 24304.0 |
> showing 50 of 99,781 rows — these rows as CSV