PREVIEW / etf_5min / 2022-07-05
file: by_date/etf_5min/2022/2022-07-05.parquet size: 2.0 MB rows: 98,076
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-05 04:00:00 | SPY | ETF | 381.44 | 382.01 | 381.44 | 381.75 | 7122.0 |
| 2022-07-05 04:05:00 | SPY | ETF | 381.86 | 381.96 | 381.0 | 381.0 | 7000.0 |
| 2022-07-05 04:10:00 | SPY | ETF | 381.1 | 381.1 | 380.8 | 380.95 | 6959.0 |
| 2022-07-05 04:15:00 | SPY | ETF | 380.75 | 380.75 | 380.65 | 380.66 | 1900.0 |
| 2022-07-05 04:20:00 | SPY | ETF | 380.64 | 380.73 | 380.24 | 380.36 | 5730.0 |
| 2022-07-05 04:25:00 | SPY | ETF | 380.31 | 380.31 | 379.81 | 379.98 | 1450.0 |
| 2022-07-05 04:30:00 | SPY | ETF | 379.9 | 380.23 | 379.72 | 380.0 | 11566.0 |
| 2022-07-05 04:35:00 | SPY | ETF | 379.9 | 379.9 | 379.61 | 379.61 | 1264.0 |
| 2022-07-05 04:40:00 | SPY | ETF | 379.71 | 379.71 | 379.31 | 379.65 | 10740.0 |
| 2022-07-05 04:45:00 | SPY | ETF | 379.28 | 379.29 | 379.0 | 379.0 | 2768.0 |
| 2022-07-05 04:50:00 | SPY | ETF | 378.9 | 379.24 | 378.9 | 378.97 | 8234.0 |
| 2022-07-05 04:55:00 | SPY | ETF | 378.93 | 379.13 | 378.85 | 379.0 | 20731.0 |
| 2022-07-05 05:00:00 | SPY | ETF | 379.03 | 379.17 | 378.86 | 379.1 | 11097.0 |
| 2022-07-05 05:05:00 | SPY | ETF | 379.17 | 379.17 | 378.71 | 378.71 | 7499.0 |
| 2022-07-05 05:10:00 | SPY | ETF | 378.66 | 379.16 | 378.62 | 379.14 | 950.0 |
| 2022-07-05 05:15:00 | SPY | ETF | 379.25 | 379.37 | 379.11 | 379.11 | 9980.0 |
| 2022-07-05 05:20:00 | SPY | ETF | 379.0 | 379.13 | 379.0 | 379.0 | 950.0 |
| 2022-07-05 05:25:00 | SPY | ETF | 379.0 | 379.02 | 378.76 | 378.76 | 2850.0 |
| 2022-07-05 05:30:00 | SPY | ETF | 378.76 | 378.78 | 378.47 | 378.5 | 3598.0 |
| 2022-07-05 05:35:00 | SPY | ETF | 378.81 | 379.15 | 378.7 | 379.15 | 5200.0 |
| 2022-07-05 05:40:00 | SPY | ETF | 379.15 | 379.26 | 379.12 | 379.26 | 930.0 |
| 2022-07-05 05:50:00 | SPY | ETF | 379.07 | 379.07 | 378.93 | 379.05 | 1829.0 |
| 2022-07-05 05:55:00 | SPY | ETF | 379.14 | 379.39 | 379.14 | 379.33 | 1632.0 |
| 2022-07-05 06:00:00 | SPY | ETF | 379.25 | 379.3 | 379.24 | 379.3 | 5710.0 |
| 2022-07-05 06:05:00 | SPY | ETF | 379.31 | 379.73 | 379.31 | 379.66 | 9731.0 |
| 2022-07-05 06:10:00 | SPY | ETF | 379.79 | 379.84 | 379.71 | 379.81 | 10697.0 |
| 2022-07-05 06:15:00 | SPY | ETF | 379.69 | 379.69 | 379.45 | 379.58 | 5293.0 |
| 2022-07-05 06:20:00 | SPY | ETF | 379.39 | 379.58 | 379.33 | 379.49 | 6826.0 |
| 2022-07-05 06:25:00 | SPY | ETF | 379.39 | 379.41 | 379.31 | 379.31 | 1698.0 |
| 2022-07-05 06:30:00 | SPY | ETF | 379.43 | 379.43 | 379.37 | 379.42 | 1774.0 |
| 2022-07-05 06:35:00 | SPY | ETF | 379.5 | 379.63 | 379.41 | 379.6 | 7760.0 |
| 2022-07-05 06:40:00 | SPY | ETF | 379.55 | 379.55 | 379.37 | 379.37 | 5000.0 |
| 2022-07-05 06:45:00 | SPY | ETF | 379.66 | 379.66 | 379.66 | 379.66 | 100.0 |
| 2022-07-05 06:50:00 | SPY | ETF | 379.71 | 379.87 | 379.71 | 379.85 | 1010.0 |
| 2022-07-05 06:55:00 | SPY | ETF | 379.85 | 379.85 | 379.23 | 379.45 | 4800.0 |
| 2022-07-05 07:00:00 | SPY | ETF | 379.51 | 379.63 | 379.3 | 379.52 | 11434.0 |
| 2022-07-05 07:05:00 | SPY | ETF | 379.5 | 379.51 | 379.37 | 379.4 | 42536.0 |
| 2022-07-05 07:10:00 | SPY | ETF | 379.5 | 379.51 | 379.33 | 379.43 | 27877.0 |
| 2022-07-05 07:15:00 | SPY | ETF | 379.3 | 379.37 | 378.81 | 378.91 | 14446.0 |
| 2022-07-05 07:20:00 | SPY | ETF | 379.0 | 379.16 | 379.0 | 379.07 | 15694.0 |
| 2022-07-05 07:25:00 | SPY | ETF | 379.13 | 379.22 | 379.1 | 379.2 | 7790.0 |
| 2022-07-05 07:30:00 | SPY | ETF | 379.2 | 379.2 | 378.85 | 378.87 | 12445.0 |
| 2022-07-05 07:35:00 | SPY | ETF | 378.87 | 379.05 | 378.86 | 378.95 | 11754.0 |
| 2022-07-05 07:40:00 | SPY | ETF | 379.05 | 379.17 | 378.6 | 378.63 | 14988.0 |
| 2022-07-05 07:45:00 | SPY | ETF | 378.67 | 378.74 | 378.23 | 378.25 | 21932.0 |
| 2022-07-05 07:50:00 | SPY | ETF | 378.21 | 378.37 | 377.9 | 377.9 | 61230.0 |
| 2022-07-05 07:55:00 | SPY | ETF | 377.92 | 378.11 | 377.81 | 377.91 | 56735.0 |
| 2022-07-05 08:00:00 | SPY | ETF | 377.9 | 383.3 | 377.44 | 377.46 | 90467.0 |
| 2022-07-05 08:05:00 | SPY | ETF | 377.49 | 377.56 | 376.86 | 377.04 | 112368.0 |
| 2022-07-05 08:10:00 | SPY | ETF | 377.05 | 377.23 | 376.59 | 377.0 | 67619.0 |
> showing 50 of 98,076 rows — these rows as CSV