PREVIEW / etf_5min / 2022-11-04
file: by_date/etf_5min/2022/2022-11-04.parquet size: 2.0 MB rows: 99,412
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-04 04:00:00 | SPY | ETF | 371.76 | 372.23 | 371.5 | 372.21 | 9847.0 |
| 2022-11-04 04:05:00 | SPY | ETF | 372.37 | 372.46 | 372.32 | 372.46 | 6457.0 |
| 2022-11-04 04:10:00 | SPY | ETF | 372.41 | 372.83 | 372.29 | 372.83 | 8592.0 |
| 2022-11-04 04:15:00 | SPY | ETF | 372.83 | 372.83 | 372.49 | 372.55 | 1350.0 |
| 2022-11-04 04:20:00 | SPY | ETF | 372.49 | 372.49 | 372.32 | 372.44 | 3848.0 |
| 2022-11-04 04:25:00 | SPY | ETF | 372.35 | 372.35 | 372.35 | 372.35 | 100.0 |
| 2022-11-04 04:30:00 | SPY | ETF | 372.18 | 372.18 | 372.11 | 372.11 | 600.0 |
| 2022-11-04 04:45:00 | SPY | ETF | 372.31 | 372.31 | 372.31 | 372.31 | 600.0 |
| 2022-11-04 04:50:00 | SPY | ETF | 372.35 | 372.35 | 372.35 | 372.35 | 300.0 |
| 2022-11-04 04:55:00 | SPY | ETF | 372.38 | 372.96 | 372.38 | 372.96 | 12700.0 |
| 2022-11-04 05:00:00 | SPY | ETF | 373.0 | 373.17 | 372.94 | 373.02 | 11905.0 |
| 2022-11-04 05:05:00 | SPY | ETF | 372.89 | 372.97 | 372.81 | 372.85 | 3269.0 |
| 2022-11-04 05:10:00 | SPY | ETF | 372.83 | 373.1 | 372.83 | 373.1 | 700.0 |
| 2022-11-04 05:15:00 | SPY | ETF | 373.21 | 374.1 | 373.21 | 373.84 | 22785.0 |
| 2022-11-04 05:20:00 | SPY | ETF | 373.87 | 373.91 | 373.55 | 373.73 | 12910.0 |
| 2022-11-04 05:25:00 | SPY | ETF | 373.68 | 373.75 | 373.68 | 373.75 | 600.0 |
| 2022-11-04 05:30:00 | SPY | ETF | 373.68 | 373.68 | 373.56 | 373.58 | 1597.0 |
| 2022-11-04 05:35:00 | SPY | ETF | 373.62 | 373.72 | 373.53 | 373.53 | 7273.0 |
| 2022-11-04 05:40:00 | SPY | ETF | 373.61 | 373.85 | 373.6 | 373.85 | 6120.0 |
| 2022-11-04 05:45:00 | SPY | ETF | 373.84 | 373.84 | 373.69 | 373.7 | 1450.0 |
| 2022-11-04 05:50:00 | SPY | ETF | 373.63 | 373.66 | 373.55 | 373.55 | 3158.0 |
| 2022-11-04 05:55:00 | SPY | ETF | 373.71 | 373.78 | 373.63 | 373.63 | 2325.0 |
| 2022-11-04 06:00:00 | SPY | ETF | 373.47 | 373.93 | 373.47 | 373.91 | 2273.0 |
| 2022-11-04 06:05:00 | SPY | ETF | 373.55 | 373.65 | 373.48 | 373.51 | 3445.0 |
| 2022-11-04 06:10:00 | SPY | ETF | 373.37 | 373.37 | 373.27 | 373.35 | 1550.0 |
| 2022-11-04 06:15:00 | SPY | ETF | 373.34 | 373.51 | 373.33 | 373.51 | 3000.0 |
| 2022-11-04 06:20:00 | SPY | ETF | 373.54 | 373.83 | 373.54 | 373.78 | 6324.0 |
| 2022-11-04 06:25:00 | SPY | ETF | 373.65 | 373.81 | 373.65 | 373.81 | 500.0 |
| 2022-11-04 06:30:00 | SPY | ETF | 373.87 | 373.95 | 373.84 | 373.95 | 26425.0 |
| 2022-11-04 06:35:00 | SPY | ETF | 373.91 | 374.15 | 373.9 | 374.14 | 4765.0 |
| 2022-11-04 06:40:00 | SPY | ETF | 374.05 | 374.07 | 374.01 | 374.05 | 1200.0 |
| 2022-11-04 06:45:00 | SPY | ETF | 374.04 | 374.18 | 374.03 | 374.03 | 5780.0 |
| 2022-11-04 06:50:00 | SPY | ETF | 374.12 | 374.44 | 374.09 | 374.32 | 12980.0 |
| 2022-11-04 06:55:00 | SPY | ETF | 374.35 | 374.4 | 374.16 | 374.17 | 4953.0 |
| 2022-11-04 07:00:00 | SPY | ETF | 374.17 | 374.22 | 373.78 | 373.97 | 19762.0 |
| 2022-11-04 07:05:00 | SPY | ETF | 374.0 | 374.95 | 373.88 | 374.26 | 80026.0 |
| 2022-11-04 07:10:00 | SPY | ETF | 374.27 | 374.5 | 374.03 | 374.17 | 71702.0 |
| 2022-11-04 07:15:00 | SPY | ETF | 374.11 | 374.26 | 374.1 | 374.1 | 32235.0 |
| 2022-11-04 07:20:00 | SPY | ETF | 374.12 | 374.25 | 373.9 | 373.95 | 20708.0 |
| 2022-11-04 07:25:00 | SPY | ETF | 373.98 | 374.0 | 373.77 | 373.79 | 19238.0 |
| 2022-11-04 07:30:00 | SPY | ETF | 373.78 | 373.95 | 373.75 | 373.92 | 36897.0 |
| 2022-11-04 07:35:00 | SPY | ETF | 373.85 | 373.86 | 373.69 | 373.75 | 18956.0 |
| 2022-11-04 07:40:00 | SPY | ETF | 373.68 | 373.78 | 373.56 | 373.63 | 16518.0 |
| 2022-11-04 07:45:00 | SPY | ETF | 373.66 | 373.8 | 373.64 | 373.7 | 18037.0 |
| 2022-11-04 07:50:00 | SPY | ETF | 373.7 | 374.25 | 373.65 | 374.22 | 40362.0 |
| 2022-11-04 07:55:00 | SPY | ETF | 374.22 | 374.31 | 374.11 | 374.22 | 19370.0 |
| 2022-11-04 08:00:00 | SPY | ETF | 373.92 | 374.49 | 371.35 | 373.72 | 96726.0 |
| 2022-11-04 08:05:00 | SPY | ETF | 373.67 | 374.09 | 373.5 | 373.69 | 67945.0 |
| 2022-11-04 08:10:00 | SPY | ETF | 373.59 | 373.7 | 373.29 | 373.42 | 46339.0 |
| 2022-11-04 08:15:00 | SPY | ETF | 373.35 | 373.5 | 373.21 | 373.23 | 52221.0 |
> showing 50 of 99,412 rows — these rows as CSV