PREVIEW / etf_5min / 2020-11-12
file: by_date/etf_5min/2020/2020-11-12.parquet size: 1.7 MB rows: 76,860
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 |
|---|---|---|---|---|---|---|---|
| 2020-11-12 04:00:00 | SPY | ETF | 354.7 | 354.97 | 354.57 | 354.88 | 6946.0 |
| 2020-11-12 04:05:00 | SPY | ETF | 354.93 | 355.02 | 354.72 | 355.01 | 13787.0 |
| 2020-11-12 04:10:00 | SPY | ETF | 355.04 | 355.04 | 354.98 | 354.98 | 1413.0 |
| 2020-11-12 04:15:00 | SPY | ETF | 354.88 | 355.02 | 354.87 | 354.99 | 3215.0 |
| 2020-11-12 04:20:00 | SPY | ETF | 354.97 | 355.06 | 354.97 | 355.04 | 3400.0 |
| 2020-11-12 04:25:00 | SPY | ETF | 355.17 | 355.31 | 355.11 | 355.16 | 5286.0 |
| 2020-11-12 04:30:00 | SPY | ETF | 355.29 | 355.5 | 355.29 | 355.47 | 6647.0 |
| 2020-11-12 04:40:00 | SPY | ETF | 355.51 | 355.51 | 355.41 | 355.5 | 1517.0 |
| 2020-11-12 04:45:00 | SPY | ETF | 355.7 | 356.07 | 355.7 | 356.01 | 5052.0 |
| 2020-11-12 04:50:00 | SPY | ETF | 356.06 | 356.06 | 355.84 | 355.94 | 1426.0 |
| 2020-11-12 04:55:00 | SPY | ETF | 355.95 | 356.26 | 355.95 | 356.06 | 7906.0 |
| 2020-11-12 05:00:00 | SPY | ETF | 356.16 | 356.21 | 356.08 | 356.09 | 1856.0 |
| 2020-11-12 05:05:00 | SPY | ETF | 356.08 | 356.18 | 356.06 | 356.18 | 723.0 |
| 2020-11-12 05:10:00 | SPY | ETF | 356.05 | 356.06 | 356.05 | 356.06 | 471.0 |
| 2020-11-12 05:15:00 | SPY | ETF | 356.23 | 356.41 | 356.19 | 356.41 | 5991.0 |
| 2020-11-12 05:20:00 | SPY | ETF | 356.41 | 356.41 | 356.11 | 356.14 | 4917.0 |
| 2020-11-12 05:25:00 | SPY | ETF | 356.19 | 356.28 | 356.04 | 356.14 | 3410.0 |
| 2020-11-12 05:30:00 | SPY | ETF | 356.16 | 356.16 | 356.16 | 356.16 | 607.0 |
| 2020-11-12 05:35:00 | SPY | ETF | 356.22 | 356.42 | 356.22 | 356.42 | 1801.0 |
| 2020-11-12 05:40:00 | SPY | ETF | 356.47 | 356.86 | 356.47 | 356.67 | 5038.0 |
| 2020-11-12 05:45:00 | SPY | ETF | 356.7 | 356.75 | 356.47 | 356.47 | 1550.0 |
| 2020-11-12 05:50:00 | SPY | ETF | 356.51 | 356.51 | 356.4 | 356.44 | 2301.0 |
| 2020-11-12 05:55:00 | SPY | ETF | 356.44 | 356.51 | 356.44 | 356.44 | 714.0 |
| 2020-11-12 06:00:00 | SPY | ETF | 356.37 | 356.4 | 356.35 | 356.38 | 2288.0 |
| 2020-11-12 06:05:00 | SPY | ETF | 356.43 | 356.54 | 356.43 | 356.51 | 2459.0 |
| 2020-11-12 06:10:00 | SPY | ETF | 356.46 | 356.73 | 356.46 | 356.64 | 2579.0 |
| 2020-11-12 06:15:00 | SPY | ETF | 356.57 | 356.81 | 356.57 | 356.62 | 16042.0 |
| 2020-11-12 06:20:00 | SPY | ETF | 356.6 | 356.63 | 356.3 | 356.3 | 4242.0 |
| 2020-11-12 06:25:00 | SPY | ETF | 356.29 | 356.3 | 356.28 | 356.3 | 17002.0 |
| 2020-11-12 06:30:00 | SPY | ETF | 356.36 | 356.36 | 356.12 | 356.21 | 13598.0 |
| 2020-11-12 06:35:00 | SPY | ETF | 356.22 | 356.26 | 356.21 | 356.21 | 1012.0 |
| 2020-11-12 06:40:00 | SPY | ETF | 356.11 | 356.12 | 356.11 | 356.12 | 466.0 |
| 2020-11-12 06:45:00 | SPY | ETF | 356.14 | 356.27 | 356.14 | 356.2 | 2151.0 |
| 2020-11-12 06:50:00 | SPY | ETF | 356.33 | 356.47 | 356.33 | 356.39 | 5837.0 |
| 2020-11-12 06:55:00 | SPY | ETF | 356.39 | 356.39 | 355.99 | 355.99 | 4270.0 |
| 2020-11-12 07:00:00 | SPY | ETF | 355.99 | 356.1 | 355.8 | 355.82 | 57361.0 |
| 2020-11-12 07:05:00 | SPY | ETF | 355.76 | 355.77 | 354.68 | 355.1 | 54009.0 |
| 2020-11-12 07:10:00 | SPY | ETF | 355.08 | 355.28 | 355.08 | 355.19 | 24468.0 |
| 2020-11-12 07:15:00 | SPY | ETF | 355.23 | 355.46 | 355.2 | 355.39 | 34185.0 |
| 2020-11-12 07:20:00 | SPY | ETF | 355.43 | 355.48 | 355.29 | 355.3 | 11246.0 |
| 2020-11-12 07:25:00 | SPY | ETF | 355.4 | 355.61 | 355.37 | 355.61 | 17805.0 |
| 2020-11-12 07:30:00 | SPY | ETF | 355.57 | 355.61 | 355.43 | 355.46 | 11892.0 |
| 2020-11-12 07:35:00 | SPY | ETF | 355.47 | 355.7 | 355.43 | 355.47 | 13453.0 |
| 2020-11-12 07:40:00 | SPY | ETF | 355.52 | 355.57 | 355.35 | 355.56 | 8501.0 |
| 2020-11-12 07:45:00 | SPY | ETF | 355.66 | 355.67 | 355.34 | 355.37 | 42087.0 |
| 2020-11-12 07:50:00 | SPY | ETF | 355.37 | 355.38 | 354.7 | 354.8 | 51396.0 |
| 2020-11-12 07:55:00 | SPY | ETF | 354.74 | 354.88 | 354.36 | 354.5 | 35257.0 |
| 2020-11-12 08:00:00 | SPY | ETF | 354.8801 | 356.4396 | 354.01 | 354.9 | 91998.0 |
| 2020-11-12 08:05:00 | SPY | ETF | 354.92 | 354.95 | 354.32 | 354.9 | 24337.0 |
| 2020-11-12 08:10:00 | SPY | ETF | 354.86 | 354.97 | 354.66 | 354.71 | 27927.0 |
> showing 50 of 76,860 rows — these rows as CSV