PREVIEW / etf_5min / 2021-06-03
file: by_date/etf_5min/2021/2021-06-03.parquet size: 1.7 MB rows: 81,495
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-03 04:00:00 | SPY | ETF | 419.63 | 419.7 | 419.6 | 419.63 | 3180.0 |
| 2021-06-03 04:05:00 | SPY | ETF | 419.56 | 419.62 | 419.49 | 419.6 | 5500.0 |
| 2021-06-03 04:10:00 | SPY | ETF | 419.63 | 419.74 | 419.63 | 419.69 | 1182.0 |
| 2021-06-03 04:15:00 | SPY | ETF | 419.54 | 419.68 | 419.54 | 419.62 | 800.0 |
| 2021-06-03 04:25:00 | SPY | ETF | 419.7 | 419.76 | 419.7 | 419.76 | 600.0 |
| 2021-06-03 04:30:00 | SPY | ETF | 419.87 | 419.88 | 419.87 | 419.88 | 300.0 |
| 2021-06-03 04:35:00 | SPY | ETF | 419.86 | 419.88 | 419.86 | 419.88 | 1100.0 |
| 2021-06-03 04:40:00 | SPY | ETF | 419.94 | 420.02 | 419.94 | 420.02 | 226.0 |
| 2021-06-03 04:45:00 | SPY | ETF | 419.98 | 419.98 | 419.94 | 419.94 | 200.0 |
| 2021-06-03 04:50:00 | SPY | ETF | 420.02 | 420.02 | 420.02 | 420.02 | 100.0 |
| 2021-06-03 04:55:00 | SPY | ETF | 419.98 | 419.98 | 419.98 | 419.98 | 200.0 |
| 2021-06-03 05:00:00 | SPY | ETF | 419.9 | 419.9 | 419.86 | 419.86 | 300.0 |
| 2021-06-03 05:05:00 | SPY | ETF | 419.9 | 419.9 | 419.86 | 419.86 | 1900.0 |
| 2021-06-03 05:10:00 | SPY | ETF | 419.67 | 419.69 | 419.64 | 419.64 | 1620.0 |
| 2021-06-03 05:15:00 | SPY | ETF | 419.65 | 419.7 | 419.5 | 419.5 | 820.0 |
| 2021-06-03 05:20:00 | SPY | ETF | 419.45 | 419.46 | 419.35 | 419.35 | 1600.0 |
| 2021-06-03 05:25:00 | SPY | ETF | 419.36 | 419.36 | 419.36 | 419.36 | 100.0 |
| 2021-06-03 05:30:00 | SPY | ETF | 419.39 | 419.42 | 419.37 | 419.37 | 1719.0 |
| 2021-06-03 05:35:00 | SPY | ETF | 419.5 | 419.52 | 419.5 | 419.52 | 400.0 |
| 2021-06-03 05:40:00 | SPY | ETF | 419.49 | 419.64 | 419.49 | 419.64 | 1100.0 |
| 2021-06-03 05:45:00 | SPY | ETF | 419.61 | 419.63 | 419.61 | 419.63 | 717.0 |
| 2021-06-03 05:50:00 | SPY | ETF | 419.57 | 419.57 | 419.5 | 419.5 | 720.0 |
| 2021-06-03 05:55:00 | SPY | ETF | 419.48 | 419.53 | 419.44 | 419.52 | 2420.0 |
| 2021-06-03 06:00:00 | SPY | ETF | 419.51 | 419.51 | 419.47 | 419.47 | 3320.0 |
| 2021-06-03 06:05:00 | SPY | ETF | 419.37 | 419.37 | 418.77 | 418.9 | 3405.0 |
| 2021-06-03 06:10:00 | SPY | ETF | 418.83 | 418.87 | 418.8 | 418.87 | 16617.0 |
| 2021-06-03 06:15:00 | SPY | ETF | 418.78 | 419.02 | 418.78 | 419.02 | 1100.0 |
| 2021-06-03 06:20:00 | SPY | ETF | 419.07 | 419.16 | 419.07 | 419.16 | 840.0 |
| 2021-06-03 06:25:00 | SPY | ETF | 419.1 | 419.1 | 419.0 | 419.0 | 3140.0 |
| 2021-06-03 06:30:00 | SPY | ETF | 419.05 | 419.08 | 418.44 | 418.47 | 7699.0 |
| 2021-06-03 06:35:00 | SPY | ETF | 418.63 | 418.63 | 418.33 | 418.33 | 2200.0 |
| 2021-06-03 06:40:00 | SPY | ETF | 418.33 | 418.42 | 418.33 | 418.38 | 13688.0 |
| 2021-06-03 06:45:00 | SPY | ETF | 418.44 | 418.54 | 418.44 | 418.5 | 3982.0 |
| 2021-06-03 06:50:00 | SPY | ETF | 418.33 | 418.42 | 418.28 | 418.41 | 7530.0 |
| 2021-06-03 06:55:00 | SPY | ETF | 418.37 | 418.37 | 417.83 | 418.02 | 76519.0 |
| 2021-06-03 07:00:00 | SPY | ETF | 418.05 | 418.1 | 417.33 | 417.35 | 44513.0 |
| 2021-06-03 07:05:00 | SPY | ETF | 417.53 | 417.74 | 417.39 | 417.47 | 84078.0 |
| 2021-06-03 07:10:00 | SPY | ETF | 417.57 | 417.82 | 417.52 | 417.82 | 13934.0 |
| 2021-06-03 07:15:00 | SPY | ETF | 417.82 | 417.83 | 417.65 | 417.65 | 22582.0 |
| 2021-06-03 07:20:00 | SPY | ETF | 417.6 | 417.73 | 417.5 | 417.71 | 69628.0 |
| 2021-06-03 07:25:00 | SPY | ETF | 417.73 | 417.87 | 417.72 | 417.76 | 17292.0 |
| 2021-06-03 07:30:00 | SPY | ETF | 417.66 | 417.67 | 417.42 | 417.62 | 20542.0 |
| 2021-06-03 07:35:00 | SPY | ETF | 417.62 | 417.84 | 417.51 | 417.73 | 27101.0 |
| 2021-06-03 07:40:00 | SPY | ETF | 417.75 | 417.75 | 417.52 | 417.64 | 7425.0 |
| 2021-06-03 07:45:00 | SPY | ETF | 417.6 | 417.6 | 416.97 | 417.1 | 58448.0 |
| 2021-06-03 07:50:00 | SPY | ETF | 417.1 | 417.25 | 416.97 | 417.25 | 58758.0 |
| 2021-06-03 07:55:00 | SPY | ETF | 417.33 | 417.38 | 417.12 | 417.34 | 27104.0 |
| 2021-06-03 08:00:00 | SPY | ETF | 417.3 | 420.2 | 416.76 | 418.6 | 95824.0 |
| 2021-06-03 08:05:00 | SPY | ETF | 417.04 | 420.98 | 416.9 | 417.01 | 40659.0 |
| 2021-06-03 08:10:00 | SPY | ETF | 417.03 | 417.08 | 416.91 | 417.0217 | 31726.0 |
> showing 50 of 81,495 rows — these rows as CSV