PREVIEW / etf_5min / 2020-04-30
file: by_date/etf_5min/2020/2020-04-30.parquet size: 1.8 MB rows: 78,953
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-04-30 04:00:00 | SPY | ETF | 294.4 | 294.52 | 294.2 | 294.42 | 39335.0 |
| 2020-04-30 04:05:00 | SPY | ETF | 294.42 | 294.43 | 294.38 | 294.39 | 4122.0 |
| 2020-04-30 04:10:00 | SPY | ETF | 294.39 | 294.66 | 294.36 | 294.38 | 4135.0 |
| 2020-04-30 04:15:00 | SPY | ETF | 294.38 | 294.66 | 294.38 | 294.51 | 3450.0 |
| 2020-04-30 04:20:00 | SPY | ETF | 294.38 | 294.38 | 294.11 | 294.24 | 5607.0 |
| 2020-04-30 04:25:00 | SPY | ETF | 294.16 | 294.4 | 294.16 | 294.4 | 12651.0 |
| 2020-04-30 04:30:00 | SPY | ETF | 294.58 | 295.42 | 294.58 | 295.06 | 44220.0 |
| 2020-04-30 04:35:00 | SPY | ETF | 295.1 | 295.1 | 294.95 | 295.01 | 13152.0 |
| 2020-04-30 04:40:00 | SPY | ETF | 294.92 | 294.92 | 294.81 | 294.9 | 1009.0 |
| 2020-04-30 04:45:00 | SPY | ETF | 295.07 | 295.07 | 295.07 | 295.07 | 200.0 |
| 2020-04-30 04:50:00 | SPY | ETF | 294.95 | 294.95 | 294.76 | 294.77 | 1636.0 |
| 2020-04-30 04:55:00 | SPY | ETF | 294.7 | 294.7 | 294.38 | 294.38 | 1876.0 |
| 2020-04-30 05:00:00 | SPY | ETF | 294.51 | 294.51 | 294.36 | 294.39 | 5697.0 |
| 2020-04-30 05:05:00 | SPY | ETF | 294.44 | 294.44 | 294.26 | 294.38 | 3156.0 |
| 2020-04-30 05:10:00 | SPY | ETF | 294.53 | 294.59 | 294.51 | 294.57 | 1590.0 |
| 2020-04-30 05:15:00 | SPY | ETF | 294.61 | 294.74 | 294.59 | 294.74 | 1565.0 |
| 2020-04-30 05:20:00 | SPY | ETF | 294.65 | 294.65 | 294.62 | 294.62 | 275.0 |
| 2020-04-30 05:25:00 | SPY | ETF | 294.63 | 294.71 | 294.57 | 294.71 | 1626.0 |
| 2020-04-30 05:30:00 | SPY | ETF | 294.7 | 294.83 | 294.57 | 294.82 | 25054.0 |
| 2020-04-30 05:35:00 | SPY | ETF | 294.82 | 294.89 | 294.67 | 294.72 | 5550.0 |
| 2020-04-30 05:40:00 | SPY | ETF | 294.74 | 294.95 | 294.72 | 294.94 | 15854.0 |
| 2020-04-30 05:45:00 | SPY | ETF | 294.86 | 295.07 | 294.86 | 295.0 | 2336.0 |
| 2020-04-30 05:50:00 | SPY | ETF | 294.97 | 294.98 | 294.8 | 294.8 | 7748.0 |
| 2020-04-30 05:55:00 | SPY | ETF | 294.92 | 294.93 | 294.85 | 294.9 | 2618.0 |
| 2020-04-30 06:00:00 | SPY | ETF | 295.11 | 295.3 | 295.11 | 295.17 | 7133.0 |
| 2020-04-30 06:05:00 | SPY | ETF | 295.0 | 295.01 | 294.83 | 294.83 | 2710.0 |
| 2020-04-30 06:10:00 | SPY | ETF | 294.81 | 294.84 | 294.7 | 294.75 | 6634.0 |
| 2020-04-30 06:15:00 | SPY | ETF | 294.67 | 294.75 | 294.4 | 294.64 | 9017.0 |
| 2020-04-30 06:20:00 | SPY | ETF | 294.64 | 294.85 | 294.46 | 294.85 | 2839.0 |
| 2020-04-30 06:25:00 | SPY | ETF | 294.68 | 294.68 | 294.45 | 294.49 | 4235.0 |
| 2020-04-30 06:30:00 | SPY | ETF | 294.26 | 294.28 | 294.13 | 294.25 | 16737.0 |
| 2020-04-30 06:35:00 | SPY | ETF | 294.15 | 294.32 | 294.12 | 294.22 | 5933.0 |
| 2020-04-30 06:40:00 | SPY | ETF | 294.16 | 294.2 | 293.91 | 293.92 | 59372.0 |
| 2020-04-30 06:45:00 | SPY | ETF | 293.9 | 294.01 | 293.8 | 293.82 | 42820.0 |
| 2020-04-30 06:50:00 | SPY | ETF | 293.84 | 293.84 | 293.08 | 293.38 | 92986.0 |
| 2020-04-30 06:55:00 | SPY | ETF | 293.35 | 293.59 | 293.35 | 293.53 | 15644.0 |
| 2020-04-30 07:00:00 | SPY | ETF | 293.58 | 293.78 | 293.4 | 293.62 | 86694.0 |
| 2020-04-30 07:05:00 | SPY | ETF | 293.63 | 293.7 | 293.4 | 293.4 | 180105.0 |
| 2020-04-30 07:10:00 | SPY | ETF | 293.37 | 293.37 | 293.08 | 293.13 | 108112.0 |
| 2020-04-30 07:15:00 | SPY | ETF | 293.12 | 293.45 | 293.12 | 293.42 | 18680.0 |
| 2020-04-30 07:20:00 | SPY | ETF | 293.32 | 293.37 | 292.93 | 293.0 | 60450.0 |
| 2020-04-30 07:25:00 | SPY | ETF | 293.0 | 293.1 | 292.91 | 292.97 | 59366.0 |
| 2020-04-30 07:30:00 | SPY | ETF | 292.98 | 293.34 | 292.98 | 293.22 | 46730.0 |
| 2020-04-30 07:35:00 | SPY | ETF | 293.15 | 293.35 | 293.02 | 293.35 | 54323.0 |
| 2020-04-30 07:40:00 | SPY | ETF | 293.33 | 293.75 | 293.33 | 293.73 | 174042.0 |
| 2020-04-30 07:45:00 | SPY | ETF | 293.77 | 293.8 | 292.65 | 292.89 | 199468.0 |
| 2020-04-30 07:50:00 | SPY | ETF | 292.99 | 293.19 | 292.75 | 292.91 | 97599.0 |
| 2020-04-30 07:55:00 | SPY | ETF | 292.89 | 292.89 | 292.24 | 292.33 | 106862.0 |
| 2020-04-30 08:00:00 | SPY | ETF | 292.36 | 296.77 | 292.21 | 292.61 | 268104.0 |
| 2020-04-30 08:05:00 | SPY | ETF | 292.56 | 292.92 | 292.56 | 292.89 | 43770.0 |
> showing 50 of 78,953 rows — these rows as CSV