PREVIEW / etf_5min / 2020-08-06
file: by_date/etf_5min/2020/2020-08-06.parquet size: 1.6 MB rows: 73,926
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-06 04:00:00 | SPY | ETF | 332.25 | 332.26 | 332.08 | 332.09 | 1703.0 |
| 2020-08-06 04:05:00 | SPY | ETF | 332.08 | 332.1 | 332.05 | 332.07 | 941.0 |
| 2020-08-06 04:15:00 | SPY | ETF | 331.83 | 331.85 | 331.83 | 331.85 | 286.0 |
| 2020-08-06 04:20:00 | SPY | ETF | 331.9 | 331.93 | 331.9 | 331.93 | 1278.0 |
| 2020-08-06 04:25:00 | SPY | ETF | 332.06 | 332.06 | 332.06 | 332.06 | 150.0 |
| 2020-08-06 04:30:00 | SPY | ETF | 331.97 | 332.08 | 331.89 | 331.89 | 753.0 |
| 2020-08-06 04:35:00 | SPY | ETF | 331.91 | 331.91 | 331.66 | 331.66 | 699.0 |
| 2020-08-06 04:40:00 | SPY | ETF | 331.65 | 331.71 | 331.65 | 331.71 | 530.0 |
| 2020-08-06 04:45:00 | SPY | ETF | 331.73 | 331.73 | 331.73 | 331.73 | 130.0 |
| 2020-08-06 04:50:00 | SPY | ETF | 331.83 | 331.91 | 331.83 | 331.91 | 210.0 |
| 2020-08-06 04:55:00 | SPY | ETF | 331.83 | 331.83 | 331.83 | 331.83 | 700.0 |
| 2020-08-06 05:00:00 | SPY | ETF | 331.73 | 331.93 | 331.73 | 331.93 | 3400.0 |
| 2020-08-06 05:10:00 | SPY | ETF | 332.01 | 332.02 | 332.01 | 332.02 | 5010.0 |
| 2020-08-06 05:15:00 | SPY | ETF | 331.96 | 331.96 | 331.8 | 331.8 | 725.0 |
| 2020-08-06 05:25:00 | SPY | ETF | 332.01 | 332.01 | 331.9 | 331.9 | 523.0 |
| 2020-08-06 05:30:00 | SPY | ETF | 331.9 | 331.9 | 331.9 | 331.9 | 300.0 |
| 2020-08-06 05:40:00 | SPY | ETF | 332.01 | 332.01 | 331.93 | 331.93 | 1282.0 |
| 2020-08-06 05:45:00 | SPY | ETF | 331.99 | 331.99 | 331.99 | 331.99 | 180.0 |
| 2020-08-06 05:50:00 | SPY | ETF | 331.96 | 331.98 | 331.93 | 331.94 | 1710.0 |
| 2020-08-06 05:55:00 | SPY | ETF | 332.01 | 332.08 | 332.0 | 332.06 | 5605.0 |
| 2020-08-06 06:00:00 | SPY | ETF | 332.04 | 332.05 | 332.01 | 332.05 | 1025.0 |
| 2020-08-06 06:10:00 | SPY | ETF | 331.96 | 331.96 | 331.95 | 331.95 | 200.0 |
| 2020-08-06 06:15:00 | SPY | ETF | 331.92 | 331.92 | 331.88 | 331.88 | 5200.0 |
| 2020-08-06 06:20:00 | SPY | ETF | 331.86 | 331.87 | 331.86 | 331.87 | 220.0 |
| 2020-08-06 06:25:00 | SPY | ETF | 331.86 | 331.86 | 331.73 | 331.73 | 623.0 |
| 2020-08-06 06:30:00 | SPY | ETF | 331.71 | 331.71 | 331.58 | 331.63 | 2795.0 |
| 2020-08-06 06:35:00 | SPY | ETF | 331.54 | 331.54 | 331.5 | 331.5 | 3080.0 |
| 2020-08-06 06:40:00 | SPY | ETF | 331.35 | 331.35 | 331.28 | 331.34 | 2796.0 |
| 2020-08-06 06:45:00 | SPY | ETF | 331.42 | 331.42 | 331.19 | 331.22 | 7081.0 |
| 2020-08-06 06:50:00 | SPY | ETF | 331.23 | 331.24 | 330.69 | 330.71 | 10504.0 |
| 2020-08-06 06:55:00 | SPY | ETF | 330.67 | 330.85 | 330.67 | 330.85 | 20841.0 |
| 2020-08-06 07:00:00 | SPY | ETF | 330.85 | 330.87 | 330.75 | 330.75 | 18082.0 |
| 2020-08-06 07:05:00 | SPY | ETF | 330.68 | 330.93 | 330.61 | 330.85 | 9440.0 |
| 2020-08-06 07:10:00 | SPY | ETF | 330.85 | 331.05 | 330.85 | 331.05 | 3295.0 |
| 2020-08-06 07:15:00 | SPY | ETF | 330.96 | 331.11 | 330.95 | 331.1 | 9881.0 |
| 2020-08-06 07:20:00 | SPY | ETF | 331.08 | 331.08 | 331.0 | 331.02 | 4229.0 |
| 2020-08-06 07:25:00 | SPY | ETF | 330.94 | 331.1 | 330.86 | 331.1 | 8277.0 |
| 2020-08-06 07:30:00 | SPY | ETF | 331.1 | 331.24 | 331.08 | 331.16 | 13462.0 |
| 2020-08-06 07:35:00 | SPY | ETF | 331.2 | 331.2 | 331.01 | 331.12 | 6287.0 |
| 2020-08-06 07:40:00 | SPY | ETF | 331.14 | 331.18 | 330.85 | 330.85 | 12596.0 |
| 2020-08-06 07:45:00 | SPY | ETF | 330.83 | 330.83 | 330.15 | 330.15 | 57146.0 |
| 2020-08-06 07:50:00 | SPY | ETF | 330.21 | 330.4 | 330.18 | 330.4 | 60551.0 |
| 2020-08-06 07:55:00 | SPY | ETF | 330.39 | 330.76 | 330.39 | 330.49 | 62555.0 |
| 2020-08-06 08:00:00 | SPY | ETF | 330.6699 | 331.9504 | 330.13 | 330.35 | 165543.0 |
| 2020-08-06 08:05:00 | SPY | ETF | 330.34 | 330.58 | 330.21 | 330.58 | 62254.0 |
| 2020-08-06 08:10:00 | SPY | ETF | 330.57 | 330.7 | 330.54 | 330.69 | 7690.0 |
| 2020-08-06 08:15:00 | SPY | ETF | 330.68 | 330.72 | 330.51 | 330.72 | 26829.0 |
| 2020-08-06 08:20:00 | SPY | ETF | 330.75 | 330.78 | 330.67 | 330.6701 | 11648.0 |
| 2020-08-06 08:25:00 | SPY | ETF | 330.63 | 330.81 | 330.58 | 330.75 | 42059.0 |
| 2020-08-06 08:30:00 | SPY | ETF | 330.81 | 331.55 | 330.77 | 331.47 | 206576.0 |
> showing 50 of 73,926 rows — these rows as CSV