PREVIEW / etf_5min / 2020-08-11
file: by_date/etf_5min/2020/2020-08-11.parquet size: 1.8 MB rows: 80,603
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-08-11 04:00:00 | SPY | ETF | 336.91 | 337.13 | 336.6 | 336.79 | 17532.0 |
| 2020-08-11 04:05:00 | SPY | ETF | 336.88 | 336.89 | 336.82 | 336.83 | 21541.0 |
| 2020-08-11 04:10:00 | SPY | ETF | 336.91 | 337.0 | 336.82 | 336.88 | 5125.0 |
| 2020-08-11 04:15:00 | SPY | ETF | 336.83 | 336.86 | 336.83 | 336.83 | 3428.0 |
| 2020-08-11 04:20:00 | SPY | ETF | 336.83 | 337.2 | 336.83 | 337.02 | 2841.0 |
| 2020-08-11 04:25:00 | SPY | ETF | 337.17 | 337.17 | 337.17 | 337.17 | 100.0 |
| 2020-08-11 04:30:00 | SPY | ETF | 337.18 | 337.23 | 337.18 | 337.23 | 314.0 |
| 2020-08-11 04:35:00 | SPY | ETF | 337.3 | 337.45 | 337.3 | 337.41 | 1198.0 |
| 2020-08-11 04:40:00 | SPY | ETF | 337.38 | 337.5 | 337.37 | 337.5 | 5930.0 |
| 2020-08-11 04:45:00 | SPY | ETF | 337.53 | 337.56 | 337.49 | 337.54 | 925.0 |
| 2020-08-11 04:50:00 | SPY | ETF | 337.66 | 337.73 | 337.56 | 337.56 | 9286.0 |
| 2020-08-11 04:55:00 | SPY | ETF | 337.61 | 337.84 | 337.61 | 337.84 | 14065.0 |
| 2020-08-11 05:00:00 | SPY | ETF | 337.84 | 337.84 | 337.59 | 337.59 | 4118.0 |
| 2020-08-11 05:05:00 | SPY | ETF | 337.55 | 337.77 | 337.55 | 337.64 | 1552.0 |
| 2020-08-11 05:10:00 | SPY | ETF | 337.72 | 337.86 | 337.65 | 337.86 | 1161.0 |
| 2020-08-11 05:15:00 | SPY | ETF | 337.87 | 337.87 | 337.74 | 337.78 | 1444.0 |
| 2020-08-11 05:20:00 | SPY | ETF | 337.8 | 337.8 | 337.69 | 337.69 | 663.0 |
| 2020-08-11 05:25:00 | SPY | ETF | 337.8 | 337.8 | 337.8 | 337.8 | 1020.0 |
| 2020-08-11 05:30:00 | SPY | ETF | 337.8 | 337.93 | 337.72 | 337.92 | 3145.0 |
| 2020-08-11 05:35:00 | SPY | ETF | 337.86 | 337.86 | 337.71 | 337.71 | 800.0 |
| 2020-08-11 05:40:00 | SPY | ETF | 337.69 | 337.8 | 337.69 | 337.79 | 1305.0 |
| 2020-08-11 05:45:00 | SPY | ETF | 337.82 | 337.9 | 337.8 | 337.87 | 5489.0 |
| 2020-08-11 05:50:00 | SPY | ETF | 337.85 | 337.85 | 337.67 | 337.69 | 2699.0 |
| 2020-08-11 05:55:00 | SPY | ETF | 337.67 | 337.75 | 337.65 | 337.69 | 2577.0 |
| 2020-08-11 06:00:00 | SPY | ETF | 337.68 | 337.68 | 337.6 | 337.6 | 4179.0 |
| 2020-08-11 06:05:00 | SPY | ETF | 337.6 | 337.71 | 337.6 | 337.71 | 1023.0 |
| 2020-08-11 06:10:00 | SPY | ETF | 337.69 | 337.71 | 337.64 | 337.66 | 7735.0 |
| 2020-08-11 06:15:00 | SPY | ETF | 337.68 | 337.69 | 337.64 | 337.64 | 777.0 |
| 2020-08-11 06:20:00 | SPY | ETF | 337.59 | 337.69 | 337.57 | 337.66 | 3338.0 |
| 2020-08-11 06:25:00 | SPY | ETF | 337.69 | 337.73 | 337.69 | 337.73 | 1130.0 |
| 2020-08-11 06:30:00 | SPY | ETF | 337.75 | 337.75 | 337.69 | 337.69 | 2030.0 |
| 2020-08-11 06:35:00 | SPY | ETF | 337.74 | 337.75 | 337.74 | 337.75 | 834.0 |
| 2020-08-11 06:40:00 | SPY | ETF | 337.74 | 337.74 | 337.66 | 337.66 | 300.0 |
| 2020-08-11 06:45:00 | SPY | ETF | 337.65 | 337.67 | 337.55 | 337.57 | 12200.0 |
| 2020-08-11 06:50:00 | SPY | ETF | 337.62 | 337.7 | 337.47 | 337.47 | 7573.0 |
| 2020-08-11 06:55:00 | SPY | ETF | 337.42 | 337.5 | 337.32 | 337.44 | 10999.0 |
| 2020-08-11 07:00:00 | SPY | ETF | 337.36 | 337.47 | 337.26 | 337.41 | 35362.0 |
| 2020-08-11 07:05:00 | SPY | ETF | 337.48 | 337.66 | 337.48 | 337.65 | 9236.0 |
| 2020-08-11 07:10:00 | SPY | ETF | 337.65 | 337.7 | 337.3 | 337.3 | 43757.0 |
| 2020-08-11 07:15:00 | SPY | ETF | 337.33 | 337.36 | 337.29 | 337.34 | 4036.0 |
| 2020-08-11 07:20:00 | SPY | ETF | 337.32 | 337.32 | 337.06 | 337.11 | 13166.0 |
| 2020-08-11 07:25:00 | SPY | ETF | 337.16 | 337.21 | 337.12 | 337.21 | 15506.0 |
| 2020-08-11 07:30:00 | SPY | ETF | 337.2 | 337.3 | 337.2 | 337.3 | 6428.0 |
| 2020-08-11 07:35:00 | SPY | ETF | 337.29 | 337.29 | 337.15 | 337.15 | 4907.0 |
| 2020-08-11 07:40:00 | SPY | ETF | 337.13 | 337.2 | 337.05 | 337.06 | 22225.0 |
| 2020-08-11 07:45:00 | SPY | ETF | 337.05 | 337.22 | 337.03 | 337.18 | 24007.0 |
| 2020-08-11 07:50:00 | SPY | ETF | 337.26 | 337.28 | 337.15 | 337.16 | 7290.0 |
| 2020-08-11 07:55:00 | SPY | ETF | 337.15 | 337.15 | 336.88 | 336.98 | 32872.0 |
| 2020-08-11 08:00:00 | SPY | ETF | 337.17 | 337.85 | 335.98 | 337.19 | 40540.0 |
| 2020-08-11 08:05:00 | SPY | ETF | 337.21 | 337.33 | 337.15 | 337.26 | 26865.0 |
> showing 50 of 80,603 rows — these rows as CSV