PREVIEW / etf_5min / 2020-05-14
file: by_date/etf_5min/2020/2020-05-14.parquet size: 1.7 MB rows: 76,595
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-05-14 04:00:00 | SPY | ETF | 281.36 | 281.36 | 280.95 | 281.04 | 16291.0 |
| 2020-05-14 04:05:00 | SPY | ETF | 281.01 | 281.08 | 280.77 | 281.07 | 8967.0 |
| 2020-05-14 04:10:00 | SPY | ETF | 280.9 | 281.26 | 280.9 | 281.23 | 7668.0 |
| 2020-05-14 04:15:00 | SPY | ETF | 281.26 | 281.26 | 280.94 | 280.95 | 3942.0 |
| 2020-05-14 04:20:00 | SPY | ETF | 280.94 | 281.41 | 280.94 | 281.38 | 2455.0 |
| 2020-05-14 04:25:00 | SPY | ETF | 281.48 | 281.55 | 281.34 | 281.36 | 11301.0 |
| 2020-05-14 04:30:00 | SPY | ETF | 281.6 | 281.62 | 281.3 | 281.33 | 6479.0 |
| 2020-05-14 04:35:00 | SPY | ETF | 281.42 | 281.6 | 281.42 | 281.56 | 15226.0 |
| 2020-05-14 04:40:00 | SPY | ETF | 281.45 | 281.65 | 281.02 | 281.07 | 13884.0 |
| 2020-05-14 04:45:00 | SPY | ETF | 281.06 | 281.16 | 280.95 | 281.16 | 1509.0 |
| 2020-05-14 04:50:00 | SPY | ETF | 281.3 | 281.33 | 281.13 | 281.33 | 6500.0 |
| 2020-05-14 04:55:00 | SPY | ETF | 281.51 | 281.51 | 281.22 | 281.22 | 6140.0 |
| 2020-05-14 05:00:00 | SPY | ETF | 281.22 | 281.33 | 281.03 | 281.21 | 9333.0 |
| 2020-05-14 05:05:00 | SPY | ETF | 281.37 | 281.74 | 281.3 | 281.68 | 17054.0 |
| 2020-05-14 05:10:00 | SPY | ETF | 281.69 | 281.71 | 281.53 | 281.71 | 5675.0 |
| 2020-05-14 05:15:00 | SPY | ETF | 281.71 | 281.76 | 281.61 | 281.72 | 8347.0 |
| 2020-05-14 05:20:00 | SPY | ETF | 281.59 | 281.61 | 281.34 | 281.5 | 6200.0 |
| 2020-05-14 05:25:00 | SPY | ETF | 281.55 | 281.64 | 281.39 | 281.64 | 7912.0 |
| 2020-05-14 05:30:00 | SPY | ETF | 281.62 | 281.81 | 281.62 | 281.69 | 6000.0 |
| 2020-05-14 05:35:00 | SPY | ETF | 281.77 | 281.81 | 281.74 | 281.74 | 4600.0 |
| 2020-05-14 05:40:00 | SPY | ETF | 281.73 | 281.77 | 281.54 | 281.54 | 16095.0 |
| 2020-05-14 05:45:00 | SPY | ETF | 281.74 | 281.8 | 281.74 | 281.74 | 6844.0 |
| 2020-05-14 05:50:00 | SPY | ETF | 281.8 | 282.1 | 281.77 | 281.77 | 20351.0 |
| 2020-05-14 05:55:00 | SPY | ETF | 281.65 | 282.1 | 281.65 | 282.1 | 4450.0 |
| 2020-05-14 06:00:00 | SPY | ETF | 281.98 | 281.98 | 281.4 | 281.58 | 4422.0 |
| 2020-05-14 06:05:00 | SPY | ETF | 281.71 | 281.8 | 280.97 | 280.97 | 8580.0 |
| 2020-05-14 06:10:00 | SPY | ETF | 281.01 | 281.02 | 280.74 | 280.9 | 33700.0 |
| 2020-05-14 06:15:00 | SPY | ETF | 280.88 | 281.27 | 280.88 | 281.19 | 3305.0 |
| 2020-05-14 06:20:00 | SPY | ETF | 281.23 | 281.29 | 281.23 | 281.27 | 8808.0 |
| 2020-05-14 06:25:00 | SPY | ETF | 281.25 | 281.25 | 281.15 | 281.23 | 3682.0 |
| 2020-05-14 06:30:00 | SPY | ETF | 281.38 | 281.43 | 281.25 | 281.25 | 1520.0 |
| 2020-05-14 06:35:00 | SPY | ETF | 281.23 | 281.49 | 281.23 | 281.49 | 6695.0 |
| 2020-05-14 06:40:00 | SPY | ETF | 281.5 | 281.73 | 281.38 | 281.41 | 8359.0 |
| 2020-05-14 06:45:00 | SPY | ETF | 281.34 | 281.41 | 281.21 | 281.21 | 1750.0 |
| 2020-05-14 06:50:00 | SPY | ETF | 281.16 | 281.16 | 281.06 | 281.1 | 51681.0 |
| 2020-05-14 06:55:00 | SPY | ETF | 281.05 | 281.46 | 281.0 | 281.46 | 57628.0 |
| 2020-05-14 07:00:00 | SPY | ETF | 281.5 | 281.7 | 281.48 | 281.54 | 67686.0 |
| 2020-05-14 07:05:00 | SPY | ETF | 281.59 | 281.59 | 281.19 | 281.27 | 20874.0 |
| 2020-05-14 07:10:00 | SPY | ETF | 281.27 | 281.35 | 281.0 | 281.0 | 25934.0 |
| 2020-05-14 07:15:00 | SPY | ETF | 280.98 | 280.98 | 280.75 | 280.75 | 37394.0 |
| 2020-05-14 07:20:00 | SPY | ETF | 280.71 | 280.82 | 280.65 | 280.78 | 32035.0 |
| 2020-05-14 07:25:00 | SPY | ETF | 280.8 | 280.8 | 280.46 | 280.46 | 29779.0 |
| 2020-05-14 07:30:00 | SPY | ETF | 280.47 | 280.55 | 280.33 | 280.46 | 48986.0 |
| 2020-05-14 07:35:00 | SPY | ETF | 280.42 | 280.77 | 280.4 | 280.52 | 69066.0 |
| 2020-05-14 07:40:00 | SPY | ETF | 280.6 | 280.6 | 280.07 | 280.07 | 173434.0 |
| 2020-05-14 07:45:00 | SPY | ETF | 280.14 | 280.48 | 280.1 | 280.2 | 215241.0 |
| 2020-05-14 07:50:00 | SPY | ETF | 280.25 | 280.54 | 280.0 | 280.39 | 153165.0 |
| 2020-05-14 07:55:00 | SPY | ETF | 280.39 | 280.5 | 279.81 | 279.99 | 136294.0 |
| 2020-05-14 08:00:00 | SPY | ETF | 279.99 | 282.33 | 279.74 | 280.04 | 213775.0 |
| 2020-05-14 08:05:00 | SPY | ETF | 280.03 | 280.04 | 279.37 | 279.49 | 145141.0 |
> showing 50 of 76,595 rows — these rows as CSV