PREVIEW / etf_5min / 2020-08-12
file: by_date/etf_5min/2020/2020-08-12.parquet size: 1.6 MB rows: 75,497
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-12 04:00:00 | SPY | ETF | 335.4 | 335.63 | 335.3 | 335.3 | 22007.0 |
| 2020-08-12 04:05:00 | SPY | ETF | 335.36 | 335.39 | 335.21 | 335.21 | 5806.0 |
| 2020-08-12 04:10:00 | SPY | ETF | 335.12 | 335.35 | 335.12 | 335.24 | 8492.0 |
| 2020-08-12 04:15:00 | SPY | ETF | 335.22 | 335.43 | 335.2 | 335.43 | 2600.0 |
| 2020-08-12 04:20:00 | SPY | ETF | 335.54 | 335.66 | 335.54 | 335.58 | 1277.0 |
| 2020-08-12 04:25:00 | SPY | ETF | 335.43 | 335.43 | 335.36 | 335.36 | 661.0 |
| 2020-08-12 04:30:00 | SPY | ETF | 335.36 | 335.36 | 335.34 | 335.36 | 1666.0 |
| 2020-08-12 04:35:00 | SPY | ETF | 335.31 | 335.4 | 335.29 | 335.4 | 675.0 |
| 2020-08-12 04:40:00 | SPY | ETF | 335.48 | 335.48 | 335.41 | 335.47 | 1698.0 |
| 2020-08-12 04:45:00 | SPY | ETF | 335.46 | 335.46 | 335.46 | 335.46 | 300.0 |
| 2020-08-12 04:50:00 | SPY | ETF | 335.41 | 335.41 | 335.3 | 335.3 | 1500.0 |
| 2020-08-12 04:55:00 | SPY | ETF | 335.33 | 335.38 | 335.32 | 335.32 | 747.0 |
| 2020-08-12 05:00:00 | SPY | ETF | 335.44 | 335.56 | 335.43 | 335.56 | 735.0 |
| 2020-08-12 05:10:00 | SPY | ETF | 335.46 | 335.52 | 335.46 | 335.52 | 610.0 |
| 2020-08-12 05:15:00 | SPY | ETF | 335.69 | 335.69 | 335.69 | 335.69 | 310.0 |
| 2020-08-12 05:20:00 | SPY | ETF | 335.74 | 335.8 | 335.74 | 335.8 | 815.0 |
| 2020-08-12 05:25:00 | SPY | ETF | 335.71 | 335.75 | 335.71 | 335.75 | 2285.0 |
| 2020-08-12 05:30:00 | SPY | ETF | 335.68 | 335.89 | 335.66 | 335.89 | 1030.0 |
| 2020-08-12 05:35:00 | SPY | ETF | 335.72 | 335.72 | 335.62 | 335.64 | 2350.0 |
| 2020-08-12 05:40:00 | SPY | ETF | 335.57 | 335.6 | 335.51 | 335.51 | 1200.0 |
| 2020-08-12 05:45:00 | SPY | ETF | 335.54 | 335.59 | 335.54 | 335.59 | 690.0 |
| 2020-08-12 05:50:00 | SPY | ETF | 335.56 | 335.58 | 335.56 | 335.58 | 912.0 |
| 2020-08-12 05:55:00 | SPY | ETF | 335.52 | 335.52 | 335.4 | 335.5 | 2558.0 |
| 2020-08-12 06:00:00 | SPY | ETF | 335.42 | 335.5 | 335.42 | 335.5 | 1900.0 |
| 2020-08-12 06:05:00 | SPY | ETF | 335.44 | 335.63 | 335.44 | 335.62 | 3558.0 |
| 2020-08-12 06:10:00 | SPY | ETF | 335.75 | 336.06 | 335.75 | 336.02 | 6680.0 |
| 2020-08-12 06:15:00 | SPY | ETF | 335.94 | 335.99 | 335.94 | 335.99 | 1010.0 |
| 2020-08-12 06:20:00 | SPY | ETF | 335.98 | 336.01 | 335.88 | 335.88 | 16134.0 |
| 2020-08-12 06:25:00 | SPY | ETF | 335.89 | 335.89 | 335.8 | 335.8 | 398.0 |
| 2020-08-12 06:30:00 | SPY | ETF | 335.8 | 335.8 | 335.72 | 335.72 | 5257.0 |
| 2020-08-12 06:35:00 | SPY | ETF | 335.74 | 335.8 | 335.65 | 335.73 | 7613.0 |
| 2020-08-12 06:40:00 | SPY | ETF | 335.66 | 335.66 | 335.64 | 335.64 | 1050.0 |
| 2020-08-12 06:45:00 | SPY | ETF | 335.69 | 335.7 | 335.6 | 335.6 | 1146.0 |
| 2020-08-12 06:50:00 | SPY | ETF | 335.56 | 335.6 | 335.55 | 335.59 | 5416.0 |
| 2020-08-12 06:55:00 | SPY | ETF | 335.56 | 335.63 | 335.55 | 335.6 | 6000.0 |
| 2020-08-12 07:00:00 | SPY | ETF | 335.56 | 335.56 | 335.43 | 335.45 | 8804.0 |
| 2020-08-12 07:05:00 | SPY | ETF | 335.44 | 335.49 | 335.43 | 335.47 | 15681.0 |
| 2020-08-12 07:10:00 | SPY | ETF | 335.48 | 335.49 | 335.34 | 335.41 | 14798.0 |
| 2020-08-12 07:15:00 | SPY | ETF | 335.43 | 335.54 | 335.43 | 335.45 | 39333.0 |
| 2020-08-12 07:20:00 | SPY | ETF | 335.48 | 335.49 | 335.22 | 335.27 | 42257.0 |
| 2020-08-12 07:25:00 | SPY | ETF | 335.25 | 335.41 | 335.15 | 335.36 | 13831.0 |
| 2020-08-12 07:30:00 | SPY | ETF | 335.38 | 335.53 | 335.38 | 335.48 | 13472.0 |
| 2020-08-12 07:35:00 | SPY | ETF | 335.5 | 335.53 | 335.36 | 335.41 | 14568.0 |
| 2020-08-12 07:40:00 | SPY | ETF | 335.42 | 335.44 | 335.22 | 335.29 | 23289.0 |
| 2020-08-12 07:45:00 | SPY | ETF | 335.28 | 335.45 | 335.25 | 335.4 | 37198.0 |
| 2020-08-12 07:50:00 | SPY | ETF | 335.4 | 335.42 | 335.35 | 335.4 | 34859.0 |
| 2020-08-12 07:55:00 | SPY | ETF | 335.37 | 335.46 | 335.22 | 335.37 | 12483.0 |
| 2020-08-12 08:00:00 | SPY | ETF | 335.5 | 335.55 | 333.0 | 335.39 | 33117.0 |
| 2020-08-12 08:05:00 | SPY | ETF | 335.41 | 335.53 | 335.32 | 335.4 | 17068.0 |
| 2020-08-12 08:10:00 | SPY | ETF | 335.38 | 335.44 | 335.38 | 335.41 | 12890.0 |
> showing 50 of 75,497 rows — these rows as CSV