PREVIEW / etf_5min / 2021-10-07
file: by_date/etf_5min/2021/2021-10-07.parquet size: 1.8 MB rows: 83,395
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-07 04:00:00 | SPY | ETF | 437.01 | 437.57 | 437.01 | 437.3 | 13055.0 |
| 2021-10-07 04:05:00 | SPY | ETF | 437.33 | 437.56 | 437.33 | 437.44 | 8225.0 |
| 2021-10-07 04:10:00 | SPY | ETF | 437.41 | 437.41 | 437.25 | 437.26 | 16691.0 |
| 2021-10-07 04:15:00 | SPY | ETF | 437.21 | 437.25 | 437.05 | 437.05 | 7761.0 |
| 2021-10-07 04:20:00 | SPY | ETF | 437.1 | 437.15 | 437.1 | 437.11 | 1222.0 |
| 2021-10-07 04:25:00 | SPY | ETF | 436.99 | 437.05 | 436.99 | 437.05 | 2759.0 |
| 2021-10-07 04:30:00 | SPY | ETF | 437.27 | 437.53 | 437.24 | 437.46 | 5048.0 |
| 2021-10-07 04:35:00 | SPY | ETF | 437.55 | 437.74 | 437.53 | 437.61 | 2964.0 |
| 2021-10-07 04:40:00 | SPY | ETF | 437.6 | 437.74 | 437.6 | 437.65 | 8575.0 |
| 2021-10-07 04:45:00 | SPY | ETF | 437.6 | 437.89 | 437.6 | 437.89 | 7189.0 |
| 2021-10-07 04:50:00 | SPY | ETF | 437.87 | 437.94 | 437.87 | 437.92 | 3975.0 |
| 2021-10-07 04:55:00 | SPY | ETF | 437.76 | 437.76 | 437.6 | 437.6 | 725.0 |
| 2021-10-07 05:00:00 | SPY | ETF | 437.49 | 437.59 | 437.49 | 437.55 | 625.0 |
| 2021-10-07 05:05:00 | SPY | ETF | 437.58 | 437.61 | 437.58 | 437.6 | 1400.0 |
| 2021-10-07 05:10:00 | SPY | ETF | 437.59 | 437.59 | 437.56 | 437.59 | 875.0 |
| 2021-10-07 05:15:00 | SPY | ETF | 437.47 | 437.47 | 437.47 | 437.47 | 100.0 |
| 2021-10-07 05:20:00 | SPY | ETF | 437.39 | 437.4 | 437.39 | 437.4 | 800.0 |
| 2021-10-07 05:25:00 | SPY | ETF | 437.4 | 437.4 | 437.32 | 437.34 | 2229.0 |
| 2021-10-07 05:30:00 | SPY | ETF | 437.37 | 437.41 | 437.37 | 437.4 | 400.0 |
| 2021-10-07 05:35:00 | SPY | ETF | 437.53 | 437.57 | 437.53 | 437.57 | 300.0 |
| 2021-10-07 05:45:00 | SPY | ETF | 437.46 | 437.46 | 437.46 | 437.46 | 625.0 |
| 2021-10-07 05:50:00 | SPY | ETF | 437.46 | 437.66 | 437.43 | 437.66 | 1200.0 |
| 2021-10-07 06:00:00 | SPY | ETF | 437.73 | 438.06 | 437.73 | 437.97 | 4299.0 |
| 2021-10-07 06:05:00 | SPY | ETF | 437.95 | 438.04 | 437.95 | 438.0 | 3744.0 |
| 2021-10-07 06:10:00 | SPY | ETF | 438.02 | 438.06 | 437.92 | 437.92 | 1275.0 |
| 2021-10-07 06:15:00 | SPY | ETF | 437.85 | 437.89 | 437.85 | 437.89 | 711.0 |
| 2021-10-07 06:20:00 | SPY | ETF | 437.86 | 437.86 | 437.79 | 437.79 | 400.0 |
| 2021-10-07 06:25:00 | SPY | ETF | 437.8 | 437.8 | 437.7 | 437.72 | 4514.0 |
| 2021-10-07 06:30:00 | SPY | ETF | 437.7 | 437.72 | 437.65 | 437.69 | 12149.0 |
| 2021-10-07 06:35:00 | SPY | ETF | 437.74 | 437.9 | 437.74 | 437.81 | 10025.0 |
| 2021-10-07 06:40:00 | SPY | ETF | 437.84 | 437.98 | 437.84 | 437.9 | 27399.0 |
| 2021-10-07 06:45:00 | SPY | ETF | 437.95 | 438.05 | 437.95 | 438.05 | 613.0 |
| 2021-10-07 06:50:00 | SPY | ETF | 438.07 | 438.2 | 438.07 | 438.16 | 55030.0 |
| 2021-10-07 06:55:00 | SPY | ETF | 438.16 | 438.59 | 438.12 | 438.59 | 33858.0 |
| 2021-10-07 07:00:00 | SPY | ETF | 438.55 | 438.92 | 438.43 | 438.54 | 53441.0 |
| 2021-10-07 07:05:00 | SPY | ETF | 438.54 | 438.82 | 438.54 | 438.75 | 29794.0 |
| 2021-10-07 07:10:00 | SPY | ETF | 438.77 | 438.97 | 438.75 | 438.87 | 34303.0 |
| 2021-10-07 07:15:00 | SPY | ETF | 438.87 | 439.16 | 438.87 | 439.06 | 18579.0 |
| 2021-10-07 07:20:00 | SPY | ETF | 439.09 | 439.16 | 439.04 | 439.13 | 13818.0 |
| 2021-10-07 07:25:00 | SPY | ETF | 439.15 | 439.2 | 439.09 | 439.1 | 18796.0 |
| 2021-10-07 07:30:00 | SPY | ETF | 439.09 | 439.12 | 438.88 | 438.95 | 62025.0 |
| 2021-10-07 07:35:00 | SPY | ETF | 438.95 | 439.3 | 438.95 | 439.17 | 86858.0 |
| 2021-10-07 07:40:00 | SPY | ETF | 439.15 | 439.15 | 439.01 | 439.08 | 14999.0 |
| 2021-10-07 07:45:00 | SPY | ETF | 439.11 | 439.23 | 439.07 | 439.09 | 19808.0 |
| 2021-10-07 07:50:00 | SPY | ETF | 439.14 | 439.17 | 438.97 | 439.0 | 11492.0 |
| 2021-10-07 07:55:00 | SPY | ETF | 439.0 | 439.03 | 438.86 | 438.9 | 63025.0 |
| 2021-10-07 08:00:00 | SPY | ETF | 438.6201 | 439.27 | 436.55 | 439.08 | 108622.0 |
| 2021-10-07 08:05:00 | SPY | ETF | 439.06 | 439.1 | 438.94 | 438.94 | 28340.0 |
| 2021-10-07 08:10:00 | SPY | ETF | 438.93 | 438.95 | 438.78 | 438.85 | 54080.0 |
| 2021-10-07 08:15:00 | SPY | ETF | 438.86 | 438.93 | 438.82 | 438.89 | 12885.0 |
> showing 50 of 83,395 rows — these rows as CSV