PREVIEW / etf_5min / 2020-09-24
file: by_date/etf_5min/2020/2020-09-24.parquet size: 1.6 MB rows: 74,959
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-09-24 04:00:00 | SPY | ETF | 323.0 | 323.17 | 322.66 | 322.72 | 9182.0 |
| 2020-09-24 04:05:00 | SPY | ETF | 322.6 | 322.6 | 322.52 | 322.59 | 1325.0 |
| 2020-09-24 04:10:00 | SPY | ETF | 322.64 | 322.75 | 322.21 | 322.23 | 2419.0 |
| 2020-09-24 04:15:00 | SPY | ETF | 322.0 | 322.11 | 322.0 | 322.11 | 2755.0 |
| 2020-09-24 04:20:00 | SPY | ETF | 322.19 | 322.27 | 321.95 | 321.99 | 1614.0 |
| 2020-09-24 04:25:00 | SPY | ETF | 322.34 | 322.34 | 322.3 | 322.3 | 2100.0 |
| 2020-09-24 04:30:00 | SPY | ETF | 322.49 | 322.49 | 322.42 | 322.42 | 500.0 |
| 2020-09-24 04:35:00 | SPY | ETF | 322.72 | 322.87 | 322.67 | 322.67 | 8156.0 |
| 2020-09-24 04:40:00 | SPY | ETF | 322.6 | 322.7 | 322.53 | 322.53 | 1378.0 |
| 2020-09-24 04:45:00 | SPY | ETF | 322.42 | 322.47 | 322.31 | 322.31 | 2466.0 |
| 2020-09-24 04:50:00 | SPY | ETF | 322.22 | 322.22 | 322.12 | 322.12 | 600.0 |
| 2020-09-24 04:55:00 | SPY | ETF | 322.37 | 322.37 | 322.37 | 322.37 | 210.0 |
| 2020-09-24 05:05:00 | SPY | ETF | 322.2 | 322.2 | 321.87 | 321.87 | 3421.0 |
| 2020-09-24 05:15:00 | SPY | ETF | 322.45 | 322.58 | 322.4 | 322.4 | 10201.0 |
| 2020-09-24 05:25:00 | SPY | ETF | 322.52 | 322.52 | 322.39 | 322.48 | 7847.0 |
| 2020-09-24 05:30:00 | SPY | ETF | 322.77 | 322.77 | 322.49 | 322.53 | 4691.0 |
| 2020-09-24 05:35:00 | SPY | ETF | 322.52 | 322.52 | 322.52 | 322.52 | 1002.0 |
| 2020-09-24 05:40:00 | SPY | ETF | 322.45 | 322.7 | 322.45 | 322.67 | 2988.0 |
| 2020-09-24 05:45:00 | SPY | ETF | 322.55 | 322.62 | 322.4 | 322.4 | 7440.0 |
| 2020-09-24 05:50:00 | SPY | ETF | 322.65 | 322.65 | 322.32 | 322.32 | 2575.0 |
| 2020-09-24 05:55:00 | SPY | ETF | 322.22 | 322.48 | 322.22 | 322.48 | 881.0 |
| 2020-09-24 06:00:00 | SPY | ETF | 322.64 | 323.18 | 322.64 | 323.18 | 11483.0 |
| 2020-09-24 06:05:00 | SPY | ETF | 323.26 | 323.42 | 323.16 | 323.42 | 8840.0 |
| 2020-09-24 06:10:00 | SPY | ETF | 323.4 | 323.45 | 323.26 | 323.29 | 5698.0 |
| 2020-09-24 06:15:00 | SPY | ETF | 323.4 | 323.53 | 323.3 | 323.4 | 8435.0 |
| 2020-09-24 06:20:00 | SPY | ETF | 323.45 | 323.45 | 323.3 | 323.32 | 5840.0 |
| 2020-09-24 06:25:00 | SPY | ETF | 323.47 | 323.47 | 323.37 | 323.37 | 1634.0 |
| 2020-09-24 06:30:00 | SPY | ETF | 323.3 | 323.34 | 323.28 | 323.28 | 7590.0 |
| 2020-09-24 06:35:00 | SPY | ETF | 323.28 | 323.53 | 323.28 | 323.53 | 12992.0 |
| 2020-09-24 06:40:00 | SPY | ETF | 323.48 | 323.49 | 323.33 | 323.33 | 1436.0 |
| 2020-09-24 06:45:00 | SPY | ETF | 323.38 | 323.45 | 323.28 | 323.45 | 4166.0 |
| 2020-09-24 06:50:00 | SPY | ETF | 323.45 | 323.62 | 323.45 | 323.62 | 19877.0 |
| 2020-09-24 06:55:00 | SPY | ETF | 323.46 | 323.51 | 323.28 | 323.32 | 4987.0 |
| 2020-09-24 07:00:00 | SPY | ETF | 323.26 | 323.35 | 323.2 | 323.2 | 15839.0 |
| 2020-09-24 07:05:00 | SPY | ETF | 323.22 | 323.22 | 322.99 | 323.04 | 12668.0 |
| 2020-09-24 07:10:00 | SPY | ETF | 323.07 | 323.09 | 322.96 | 323.02 | 16492.0 |
| 2020-09-24 07:15:00 | SPY | ETF | 322.95 | 323.02 | 322.92 | 322.92 | 26426.0 |
| 2020-09-24 07:20:00 | SPY | ETF | 322.92 | 322.92 | 322.59 | 322.75 | 22732.0 |
| 2020-09-24 07:25:00 | SPY | ETF | 322.77 | 322.86 | 322.67 | 322.86 | 30271.0 |
| 2020-09-24 07:30:00 | SPY | ETF | 322.86 | 322.98 | 322.7 | 322.77 | 27369.0 |
| 2020-09-24 07:35:00 | SPY | ETF | 322.74 | 322.99 | 322.74 | 322.86 | 11118.0 |
| 2020-09-24 07:40:00 | SPY | ETF | 322.82 | 322.83 | 322.56 | 322.59 | 31728.0 |
| 2020-09-24 07:45:00 | SPY | ETF | 322.62 | 322.68 | 322.44 | 322.5 | 15141.0 |
| 2020-09-24 07:50:00 | SPY | ETF | 322.45 | 322.5 | 321.91 | 321.91 | 82055.0 |
| 2020-09-24 07:55:00 | SPY | ETF | 321.9 | 322.13 | 321.88 | 321.96 | 244675.0 |
| 2020-09-24 08:00:00 | SPY | ETF | 321.99 | 323.4304 | 321.25 | 321.53 | 108364.0 |
| 2020-09-24 08:05:00 | SPY | ETF | 321.5 | 321.76 | 321.25 | 321.69 | 162352.0 |
| 2020-09-24 08:10:00 | SPY | ETF | 321.77 | 321.96 | 321.77 | 321.85 | 111408.0 |
| 2020-09-24 08:15:00 | SPY | ETF | 321.85 | 322.25 | 321.82 | 322.18 | 225776.0 |
| 2020-09-24 08:20:00 | SPY | ETF | 322.2027 | 322.2501 | 321.75 | 321.7601 | 23622.0 |
> showing 50 of 74,959 rows — these rows as CSV