PREVIEW / etf_5min / 2022-07-11
file: by_date/etf_5min/2022/2022-07-11.parquet size: 1.8 MB rows: 89,633
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-07-11 04:00:00 | SPY | ETF | 385.86 | 385.94 | 385.63 | 385.72 | 7205.0 |
| 2022-07-11 04:05:00 | SPY | ETF | 385.7 | 386.07 | 385.7 | 386.0 | 6870.0 |
| 2022-07-11 04:10:00 | SPY | ETF | 386.0 | 386.36 | 386.0 | 386.36 | 6431.0 |
| 2022-07-11 04:15:00 | SPY | ETF | 386.3 | 386.57 | 386.3 | 386.5 | 4795.0 |
| 2022-07-11 04:20:00 | SPY | ETF | 386.38 | 386.42 | 386.2 | 386.42 | 2437.0 |
| 2022-07-11 04:25:00 | SPY | ETF | 386.25 | 386.27 | 386.25 | 386.27 | 11375.0 |
| 2022-07-11 04:30:00 | SPY | ETF | 386.25 | 386.3 | 386.25 | 386.3 | 830.0 |
| 2022-07-11 04:35:00 | SPY | ETF | 386.5 | 386.5 | 386.4 | 386.4 | 900.0 |
| 2022-07-11 04:40:00 | SPY | ETF | 386.45 | 386.45 | 386.26 | 386.33 | 7957.0 |
| 2022-07-11 04:45:00 | SPY | ETF | 386.22 | 386.22 | 386.22 | 386.22 | 100.0 |
| 2022-07-11 04:50:00 | SPY | ETF | 386.25 | 386.3 | 386.25 | 386.29 | 5250.0 |
| 2022-07-11 04:55:00 | SPY | ETF | 386.29 | 386.29 | 386.15 | 386.19 | 809.0 |
| 2022-07-11 05:00:00 | SPY | ETF | 386.05 | 386.55 | 386.05 | 386.55 | 940.0 |
| 2022-07-11 05:05:00 | SPY | ETF | 386.47 | 386.66 | 386.43 | 386.55 | 2050.0 |
| 2022-07-11 05:10:00 | SPY | ETF | 386.75 | 386.77 | 386.75 | 386.77 | 597.0 |
| 2022-07-11 05:15:00 | SPY | ETF | 386.75 | 386.75 | 386.65 | 386.65 | 800.0 |
| 2022-07-11 05:20:00 | SPY | ETF | 386.5 | 386.5 | 386.5 | 386.5 | 100.0 |
| 2022-07-11 05:25:00 | SPY | ETF | 386.72 | 386.75 | 386.5 | 386.5 | 603.0 |
| 2022-07-11 05:30:00 | SPY | ETF | 386.37 | 386.37 | 386.27 | 386.27 | 462.0 |
| 2022-07-11 05:35:00 | SPY | ETF | 386.27 | 386.5 | 386.27 | 386.5 | 1300.0 |
| 2022-07-11 05:40:00 | SPY | ETF | 386.39 | 386.4 | 386.39 | 386.39 | 1200.0 |
| 2022-07-11 05:45:00 | SPY | ETF | 386.31 | 386.31 | 386.31 | 386.31 | 1000.0 |
| 2022-07-11 05:55:00 | SPY | ETF | 386.25 | 386.25 | 386.24 | 386.24 | 500.0 |
| 2022-07-11 06:00:00 | SPY | ETF | 386.27 | 386.27 | 386.07 | 386.21 | 2346.0 |
| 2022-07-11 06:05:00 | SPY | ETF | 386.63 | 386.63 | 386.63 | 386.63 | 247.0 |
| 2022-07-11 06:10:00 | SPY | ETF | 386.5 | 386.68 | 386.5 | 386.66 | 4900.0 |
| 2022-07-11 06:15:00 | SPY | ETF | 386.69 | 386.99 | 386.69 | 386.99 | 2500.0 |
| 2022-07-11 06:20:00 | SPY | ETF | 387.04 | 387.06 | 386.9 | 386.97 | 9238.0 |
| 2022-07-11 06:25:00 | SPY | ETF | 386.96 | 387.02 | 386.77 | 386.78 | 2900.0 |
| 2022-07-11 06:30:00 | SPY | ETF | 386.7 | 386.7 | 386.43 | 386.43 | 998.0 |
| 2022-07-11 06:35:00 | SPY | ETF | 386.57 | 386.59 | 386.57 | 386.59 | 2600.0 |
| 2022-07-11 06:40:00 | SPY | ETF | 386.52 | 386.52 | 386.52 | 386.52 | 100.0 |
| 2022-07-11 06:45:00 | SPY | ETF | 386.81 | 386.82 | 386.79 | 386.81 | 3400.0 |
| 2022-07-11 06:50:00 | SPY | ETF | 386.47 | 386.49 | 386.44 | 386.46 | 4500.0 |
| 2022-07-11 06:55:00 | SPY | ETF | 386.45 | 386.58 | 386.4 | 386.53 | 420.0 |
| 2022-07-11 07:00:00 | SPY | ETF | 386.59 | 386.83 | 386.59 | 386.83 | 6851.0 |
| 2022-07-11 07:05:00 | SPY | ETF | 386.85 | 386.92 | 386.82 | 386.91 | 12273.0 |
| 2022-07-11 07:10:00 | SPY | ETF | 386.86 | 386.98 | 386.81 | 386.91 | 5023.0 |
| 2022-07-11 07:15:00 | SPY | ETF | 386.87 | 386.92 | 386.77 | 386.82 | 5535.0 |
| 2022-07-11 07:20:00 | SPY | ETF | 386.78 | 386.86 | 386.54 | 386.55 | 13080.0 |
| 2022-07-11 07:25:00 | SPY | ETF | 386.6 | 386.63 | 386.23 | 386.35 | 35337.0 |
| 2022-07-11 07:30:00 | SPY | ETF | 386.45 | 386.52 | 386.35 | 386.41 | 10411.0 |
| 2022-07-11 07:35:00 | SPY | ETF | 386.35 | 386.48 | 386.27 | 386.29 | 6782.0 |
| 2022-07-11 07:40:00 | SPY | ETF | 386.26 | 386.26 | 385.99 | 386.041 | 11358.0 |
| 2022-07-11 07:45:00 | SPY | ETF | 386.12 | 386.12 | 385.95 | 386.03 | 12780.0 |
| 2022-07-11 07:50:00 | SPY | ETF | 386.0 | 386.0 | 385.72 | 385.72 | 19809.0 |
| 2022-07-11 07:55:00 | SPY | ETF | 385.71 | 385.85 | 385.67 | 385.83 | 17746.0 |
| 2022-07-11 08:00:00 | SPY | ETF | 386.88 | 386.95 | 385.62 | 385.77 | 39927.0 |
| 2022-07-11 08:05:00 | SPY | ETF | 385.73 | 386.09 | 385.66 | 386.04 | 17736.0 |
| 2022-07-11 08:10:00 | SPY | ETF | 386.05 | 386.15 | 386.0 | 386.06 | 40844.0 |
> showing 50 of 89,633 rows — these rows as CSV