PREVIEW / etf_5min / 2022-08-19
file: by_date/etf_5min/2022/2022-08-19.parquet size: 1.8 MB rows: 88,937
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-08-19 04:00:00 | SPY | ETF | 426.49 | 426.49 | 425.68 | 425.7 | 7656.0 |
| 2022-08-19 04:05:00 | SPY | ETF | 425.57 | 425.61 | 425.39 | 425.41 | 4620.0 |
| 2022-08-19 04:10:00 | SPY | ETF | 425.35 | 425.39 | 425.27 | 425.31 | 2208.0 |
| 2022-08-19 04:15:00 | SPY | ETF | 425.3 | 425.3 | 424.96 | 425.17 | 6002.0 |
| 2022-08-19 04:20:00 | SPY | ETF | 425.17 | 425.17 | 424.6 | 424.7 | 9553.0 |
| 2022-08-19 04:25:00 | SPY | ETF | 424.7 | 424.7 | 424.64 | 424.68 | 8425.0 |
| 2022-08-19 04:30:00 | SPY | ETF | 424.63 | 424.63 | 424.1 | 424.13 | 13093.0 |
| 2022-08-19 04:35:00 | SPY | ETF | 424.13 | 424.3 | 424.13 | 424.27 | 8689.0 |
| 2022-08-19 04:40:00 | SPY | ETF | 424.23 | 424.32 | 424.23 | 424.32 | 443.0 |
| 2022-08-19 04:45:00 | SPY | ETF | 424.34 | 424.51 | 424.31 | 424.31 | 5546.0 |
| 2022-08-19 04:50:00 | SPY | ETF | 424.39 | 424.4 | 424.25 | 424.25 | 10918.0 |
| 2022-08-19 04:55:00 | SPY | ETF | 424.44 | 424.55 | 424.44 | 424.55 | 1549.0 |
| 2022-08-19 05:00:00 | SPY | ETF | 424.48 | 424.53 | 424.35 | 424.35 | 1342.0 |
| 2022-08-19 05:05:00 | SPY | ETF | 424.46 | 424.49 | 424.41 | 424.41 | 1464.0 |
| 2022-08-19 05:10:00 | SPY | ETF | 424.4 | 424.62 | 424.31 | 424.62 | 4698.0 |
| 2022-08-19 05:15:00 | SPY | ETF | 424.62 | 424.75 | 424.62 | 424.68 | 5765.0 |
| 2022-08-19 05:20:00 | SPY | ETF | 424.67 | 424.67 | 424.47 | 424.5 | 5103.0 |
| 2022-08-19 05:25:00 | SPY | ETF | 424.46 | 424.62 | 424.46 | 424.62 | 809.0 |
| 2022-08-19 05:30:00 | SPY | ETF | 424.63 | 424.63 | 424.52 | 424.54 | 3217.0 |
| 2022-08-19 05:35:00 | SPY | ETF | 424.61 | 424.8 | 424.61 | 424.8 | 1563.0 |
| 2022-08-19 05:40:00 | SPY | ETF | 424.86 | 424.94 | 424.86 | 424.9 | 2700.0 |
| 2022-08-19 05:45:00 | SPY | ETF | 424.94 | 424.94 | 424.71 | 424.71 | 3032.0 |
| 2022-08-19 05:50:00 | SPY | ETF | 424.53 | 424.61 | 424.42 | 424.55 | 5227.0 |
| 2022-08-19 05:55:00 | SPY | ETF | 424.49 | 424.59 | 424.4 | 424.4 | 9082.0 |
| 2022-08-19 06:00:00 | SPY | ETF | 424.39 | 424.39 | 424.19 | 424.21 | 8508.0 |
| 2022-08-19 06:05:00 | SPY | ETF | 424.15 | 424.16 | 424.08 | 424.16 | 3617.0 |
| 2022-08-19 06:10:00 | SPY | ETF | 424.2 | 424.31 | 424.15 | 424.15 | 2765.0 |
| 2022-08-19 06:15:00 | SPY | ETF | 424.28 | 424.46 | 424.28 | 424.46 | 1200.0 |
| 2022-08-19 06:20:00 | SPY | ETF | 424.45 | 424.56 | 424.35 | 424.35 | 3575.0 |
| 2022-08-19 06:25:00 | SPY | ETF | 424.39 | 424.39 | 424.29 | 424.29 | 2780.0 |
| 2022-08-19 06:30:00 | SPY | ETF | 424.41 | 424.43 | 424.03 | 424.07 | 13201.0 |
| 2022-08-19 06:35:00 | SPY | ETF | 424.07 | 424.2 | 423.65 | 423.66 | 12654.0 |
| 2022-08-19 06:40:00 | SPY | ETF | 423.79 | 423.8 | 423.3 | 423.35 | 43874.0 |
| 2022-08-19 06:45:00 | SPY | ETF | 423.3 | 423.41 | 423.24 | 423.32 | 15015.0 |
| 2022-08-19 06:50:00 | SPY | ETF | 423.22 | 423.48 | 423.22 | 423.4 | 7807.0 |
| 2022-08-19 06:55:00 | SPY | ETF | 423.39 | 423.44 | 423.3 | 423.44 | 5797.0 |
| 2022-08-19 07:00:00 | SPY | ETF | 423.51 | 423.74 | 423.48 | 423.62 | 21489.0 |
| 2022-08-19 07:05:00 | SPY | ETF | 423.52 | 423.68 | 423.31 | 423.68 | 12028.0 |
| 2022-08-19 07:10:00 | SPY | ETF | 423.7 | 423.7 | 423.56 | 423.58 | 3865.0 |
| 2022-08-19 07:15:00 | SPY | ETF | 423.72 | 423.72 | 423.51 | 423.51 | 4781.0 |
| 2022-08-19 07:20:00 | SPY | ETF | 423.61 | 423.85 | 423.61 | 423.8 | 68166.0 |
| 2022-08-19 07:25:00 | SPY | ETF | 423.8 | 423.81 | 423.61 | 423.65 | 45605.0 |
| 2022-08-19 07:30:00 | SPY | ETF | 423.65 | 423.81 | 423.45 | 423.47 | 33328.0 |
| 2022-08-19 07:35:00 | SPY | ETF | 423.37 | 423.37 | 423.32 | 423.35 | 10096.0 |
| 2022-08-19 07:40:00 | SPY | ETF | 423.52 | 423.8 | 423.36 | 423.8 | 74902.0 |
| 2022-08-19 07:45:00 | SPY | ETF | 423.81 | 423.92 | 423.75 | 423.82 | 79886.0 |
| 2022-08-19 07:50:00 | SPY | ETF | 423.8 | 423.86 | 423.79 | 423.79 | 14280.0 |
| 2022-08-19 07:55:00 | SPY | ETF | 423.75 | 424.06 | 423.67 | 424.06 | 21497.0 |
| 2022-08-19 08:00:00 | SPY | ETF | 423.5501 | 427.15 | 423.2496 | 424.2 | 61792.0 |
| 2022-08-19 08:05:00 | SPY | ETF | 424.23 | 424.24 | 424.06 | 424.09 | 41089.0 |
> showing 50 of 88,937 rows — these rows as CSV