PREVIEW / etf_5min / 2020-11-11
file: by_date/etf_5min/2020/2020-11-11.parquet size: 1.7 MB rows: 76,861
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-11 04:00:00 | SPY | ETF | 356.48 | 356.73 | 356.45 | 356.45 | 14209.0 |
| 2020-11-11 04:05:00 | SPY | ETF | 356.39 | 356.39 | 356.0 | 356.1 | 14863.0 |
| 2020-11-11 04:10:00 | SPY | ETF | 356.0 | 356.04 | 355.98 | 356.04 | 647.0 |
| 2020-11-11 04:15:00 | SPY | ETF | 355.86 | 355.92 | 355.85 | 355.92 | 975.0 |
| 2020-11-11 04:20:00 | SPY | ETF | 356.0 | 356.52 | 356.0 | 356.35 | 7194.0 |
| 2020-11-11 04:25:00 | SPY | ETF | 356.37 | 356.43 | 356.21 | 356.26 | 16508.0 |
| 2020-11-11 04:30:00 | SPY | ETF | 356.1 | 356.1 | 356.0 | 356.0 | 299.0 |
| 2020-11-11 04:35:00 | SPY | ETF | 356.19 | 356.28 | 356.1 | 356.1 | 976.0 |
| 2020-11-11 04:40:00 | SPY | ETF | 356.31 | 356.45 | 356.26 | 356.41 | 18318.0 |
| 2020-11-11 04:45:00 | SPY | ETF | 356.43 | 356.63 | 356.15 | 356.15 | 3434.0 |
| 2020-11-11 04:50:00 | SPY | ETF | 356.24 | 356.44 | 356.23 | 356.28 | 4080.0 |
| 2020-11-11 04:55:00 | SPY | ETF | 356.41 | 356.44 | 356.21 | 356.24 | 4111.0 |
| 2020-11-11 05:00:00 | SPY | ETF | 356.34 | 356.34 | 356.34 | 356.34 | 356.0 |
| 2020-11-11 05:05:00 | SPY | ETF | 356.39 | 356.44 | 356.3 | 356.41 | 1120.0 |
| 2020-11-11 05:10:00 | SPY | ETF | 356.43 | 356.43 | 356.24 | 356.32 | 4634.0 |
| 2020-11-11 05:15:00 | SPY | ETF | 356.49 | 356.6 | 356.49 | 356.6 | 501.0 |
| 2020-11-11 05:20:00 | SPY | ETF | 356.59 | 356.69 | 356.4 | 356.65 | 39056.0 |
| 2020-11-11 05:25:00 | SPY | ETF | 356.6 | 356.7 | 356.58 | 356.7 | 26807.0 |
| 2020-11-11 05:30:00 | SPY | ETF | 356.62 | 356.68 | 356.56 | 356.58 | 6065.0 |
| 2020-11-11 05:35:00 | SPY | ETF | 356.62 | 356.72 | 356.6 | 356.72 | 3849.0 |
| 2020-11-11 05:40:00 | SPY | ETF | 356.68 | 356.68 | 356.41 | 356.56 | 3113.0 |
| 2020-11-11 05:45:00 | SPY | ETF | 356.45 | 356.58 | 356.45 | 356.58 | 300.0 |
| 2020-11-11 05:50:00 | SPY | ETF | 356.6 | 356.61 | 356.6 | 356.61 | 550.0 |
| 2020-11-11 05:55:00 | SPY | ETF | 356.62 | 356.66 | 356.6 | 356.6 | 805.0 |
| 2020-11-11 06:00:00 | SPY | ETF | 356.51 | 357.16 | 356.51 | 356.94 | 13126.0 |
| 2020-11-11 06:05:00 | SPY | ETF | 356.93 | 356.93 | 356.47 | 356.53 | 5054.0 |
| 2020-11-11 06:10:00 | SPY | ETF | 356.68 | 356.76 | 356.56 | 356.58 | 4160.0 |
| 2020-11-11 06:15:00 | SPY | ETF | 356.53 | 357.11 | 356.53 | 357.11 | 5717.0 |
| 2020-11-11 06:20:00 | SPY | ETF | 357.0 | 357.13 | 356.99 | 356.99 | 6816.0 |
| 2020-11-11 06:25:00 | SPY | ETF | 357.02 | 357.12 | 357.02 | 357.12 | 9038.0 |
| 2020-11-11 06:30:00 | SPY | ETF | 357.16 | 357.16 | 357.02 | 357.02 | 25274.0 |
| 2020-11-11 06:35:00 | SPY | ETF | 356.98 | 357.1 | 356.86 | 357.1 | 3543.0 |
| 2020-11-11 06:40:00 | SPY | ETF | 356.94 | 356.94 | 356.78 | 356.78 | 1669.0 |
| 2020-11-11 06:45:00 | SPY | ETF | 356.75 | 356.91 | 356.73 | 356.91 | 1806.0 |
| 2020-11-11 06:50:00 | SPY | ETF | 356.88 | 356.88 | 356.76 | 356.88 | 1325.0 |
| 2020-11-11 06:55:00 | SPY | ETF | 356.89 | 357.0 | 356.89 | 357.0 | 875.0 |
| 2020-11-11 07:00:00 | SPY | ETF | 357.0 | 357.0 | 356.51 | 356.61 | 19969.0 |
| 2020-11-11 07:05:00 | SPY | ETF | 356.65 | 356.66 | 356.5 | 356.5 | 8886.0 |
| 2020-11-11 07:10:00 | SPY | ETF | 356.5 | 356.55 | 356.34 | 356.41 | 6846.0 |
| 2020-11-11 07:15:00 | SPY | ETF | 356.45 | 356.86 | 356.4 | 356.86 | 16981.0 |
| 2020-11-11 07:20:00 | SPY | ETF | 356.88 | 357.11 | 356.88 | 356.97 | 20259.0 |
| 2020-11-11 07:25:00 | SPY | ETF | 357.09 | 357.17 | 356.88 | 356.89 | 12211.0 |
| 2020-11-11 07:30:00 | SPY | ETF | 356.95 | 356.97 | 356.68 | 356.72 | 8975.0 |
| 2020-11-11 07:35:00 | SPY | ETF | 356.8 | 356.92 | 356.64 | 356.64 | 14786.0 |
| 2020-11-11 07:40:00 | SPY | ETF | 356.62 | 356.84 | 356.59 | 356.77 | 7689.0 |
| 2020-11-11 07:45:00 | SPY | ETF | 356.69 | 356.8 | 356.66 | 356.71 | 12698.0 |
| 2020-11-11 07:50:00 | SPY | ETF | 356.8 | 357.0 | 356.79 | 356.86 | 10928.0 |
| 2020-11-11 07:55:00 | SPY | ETF | 356.81 | 356.99 | 356.81 | 356.9 | 9728.0 |
| 2020-11-11 08:00:00 | SPY | ETF | 357.0001 | 357.16 | 354.5 | 357.07 | 333811.0 |
| 2020-11-11 08:05:00 | SPY | ETF | 357.09 | 357.25 | 356.88 | 356.94 | 57249.0 |
> showing 50 of 76,861 rows — these rows as CSV