PREVIEW / etf_5min / 2020-02-10
file: by_date/etf_5min/2020/2020-02-10.parquet size: 1.5 MB rows: 65,623
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-02-10 04:00:00 | SPY | ETF | 331.77 | 332.0 | 331.77 | 332.0 | 620.0 |
| 2020-02-10 04:05:00 | SPY | ETF | 332.22 | 332.44 | 332.19 | 332.41 | 7100.0 |
| 2020-02-10 04:10:00 | SPY | ETF | 332.34 | 332.34 | 332.2 | 332.2 | 5750.0 |
| 2020-02-10 04:15:00 | SPY | ETF | 332.29 | 332.3 | 332.19 | 332.19 | 18108.0 |
| 2020-02-10 04:20:00 | SPY | ETF | 332.13 | 332.13 | 332.1 | 332.1 | 5000.0 |
| 2020-02-10 04:25:00 | SPY | ETF | 331.97 | 332.11 | 331.97 | 332.11 | 1197.0 |
| 2020-02-10 04:30:00 | SPY | ETF | 332.04 | 332.1 | 332.04 | 332.1 | 3352.0 |
| 2020-02-10 04:35:00 | SPY | ETF | 332.1 | 332.1 | 331.99 | 332.05 | 1381.0 |
| 2020-02-10 04:40:00 | SPY | ETF | 331.91 | 331.91 | 331.91 | 331.91 | 150.0 |
| 2020-02-10 04:45:00 | SPY | ETF | 331.87 | 331.87 | 331.87 | 331.87 | 122.0 |
| 2020-02-10 04:55:00 | SPY | ETF | 331.95 | 331.95 | 331.75 | 331.82 | 524.0 |
| 2020-02-10 05:00:00 | SPY | ETF | 331.67 | 331.75 | 331.67 | 331.75 | 354.0 |
| 2020-02-10 05:05:00 | SPY | ETF | 331.69 | 331.69 | 331.69 | 331.69 | 103.0 |
| 2020-02-10 05:15:00 | SPY | ETF | 331.64 | 331.67 | 331.64 | 331.67 | 300.0 |
| 2020-02-10 05:20:00 | SPY | ETF | 331.62 | 331.66 | 331.59 | 331.66 | 843.0 |
| 2020-02-10 05:25:00 | SPY | ETF | 331.66 | 331.66 | 331.66 | 331.66 | 500.0 |
| 2020-02-10 05:30:00 | SPY | ETF | 331.75 | 331.76 | 331.61 | 331.61 | 6911.0 |
| 2020-02-10 05:35:00 | SPY | ETF | 331.71 | 331.86 | 331.71 | 331.8 | 879.0 |
| 2020-02-10 05:40:00 | SPY | ETF | 331.82 | 332.5 | 331.82 | 332.34 | 17746.0 |
| 2020-02-10 05:45:00 | SPY | ETF | 332.2 | 332.49 | 332.0 | 332.42 | 35224.0 |
| 2020-02-10 05:50:00 | SPY | ETF | 332.37 | 332.41 | 332.37 | 332.41 | 304.0 |
| 2020-02-10 05:55:00 | SPY | ETF | 332.24 | 332.24 | 332.24 | 332.24 | 670.0 |
| 2020-02-10 06:00:00 | SPY | ETF | 332.23 | 332.29 | 332.23 | 332.29 | 1030.0 |
| 2020-02-10 06:10:00 | SPY | ETF | 332.31 | 332.31 | 332.2 | 332.21 | 338.0 |
| 2020-02-10 06:20:00 | SPY | ETF | 332.25 | 332.26 | 332.25 | 332.26 | 1100.0 |
| 2020-02-10 06:25:00 | SPY | ETF | 332.25 | 332.3 | 332.25 | 332.3 | 2230.0 |
| 2020-02-10 06:30:00 | SPY | ETF | 332.41 | 332.41 | 332.41 | 332.41 | 500.0 |
| 2020-02-10 06:35:00 | SPY | ETF | 332.3 | 332.3 | 332.3 | 332.3 | 133.0 |
| 2020-02-10 06:40:00 | SPY | ETF | 332.41 | 332.41 | 332.41 | 332.41 | 311.0 |
| 2020-02-10 06:55:00 | SPY | ETF | 332.31 | 332.31 | 332.18 | 332.18 | 12375.0 |
| 2020-02-10 07:00:00 | SPY | ETF | 332.23 | 332.4 | 332.06 | 332.06 | 24732.0 |
| 2020-02-10 07:05:00 | SPY | ETF | 332.05 | 332.1 | 331.94 | 332.09 | 19120.0 |
| 2020-02-10 07:10:00 | SPY | ETF | 332.13 | 332.15 | 332.04 | 332.1 | 5248.0 |
| 2020-02-10 07:15:00 | SPY | ETF | 332.11 | 332.11 | 331.98 | 331.98 | 12999.0 |
| 2020-02-10 07:20:00 | SPY | ETF | 331.93 | 332.1 | 331.93 | 332.05 | 13571.0 |
| 2020-02-10 07:25:00 | SPY | ETF | 332.03 | 332.11 | 332.02 | 332.04 | 12601.0 |
| 2020-02-10 07:30:00 | SPY | ETF | 332.04 | 332.04 | 331.9 | 331.95 | 28609.0 |
| 2020-02-10 07:35:00 | SPY | ETF | 331.98 | 332.05 | 331.98 | 332.05 | 32494.0 |
| 2020-02-10 07:40:00 | SPY | ETF | 332.1 | 332.19 | 332.09 | 332.12 | 14182.0 |
| 2020-02-10 07:45:00 | SPY | ETF | 332.18 | 332.18 | 332.06 | 332.15 | 4444.0 |
| 2020-02-10 07:50:00 | SPY | ETF | 332.16 | 332.21 | 332.16 | 332.21 | 1227.0 |
| 2020-02-10 07:55:00 | SPY | ETF | 332.08 | 332.08 | 331.92 | 331.99 | 10614.0 |
| 2020-02-10 08:00:00 | SPY | ETF | 331.98 | 332.44 | 331.6 | 331.89 | 49189.0 |
| 2020-02-10 08:05:00 | SPY | ETF | 331.84 | 331.84 | 331.5 | 331.62 | 49981.0 |
| 2020-02-10 08:10:00 | SPY | ETF | 331.6 | 331.76 | 331.57 | 331.72 | 7425.0 |
| 2020-02-10 08:15:00 | SPY | ETF | 331.71 | 331.88 | 331.71 | 331.85 | 12724.0 |
| 2020-02-10 08:20:00 | SPY | ETF | 331.87 | 332.07 | 331.87 | 332.03 | 29427.0 |
| 2020-02-10 08:25:00 | SPY | ETF | 332.09 | 332.16 | 332.09 | 332.16 | 2341.0 |
| 2020-02-10 08:30:00 | SPY | ETF | 332.13 | 332.17 | 332.08 | 332.1 | 9048.0 |
| 2020-02-10 08:35:00 | SPY | ETF | 332.08 | 332.1 | 331.95 | 331.96 | 62232.0 |
> showing 50 of 65,623 rows — these rows as CSV