PREVIEW / etf_5min / 2020-02-07
file: by_date/etf_5min/2020/2020-02-07.parquet size: 1.5 MB rows: 66,615
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-07 04:00:00 | SPY | ETF | 333.78 | 333.8 | 333.74 | 333.8 | 7704.0 |
| 2020-02-07 04:05:00 | SPY | ETF | 333.8 | 333.8 | 333.74 | 333.74 | 900.0 |
| 2020-02-07 04:10:00 | SPY | ETF | 333.74 | 333.74 | 333.7 | 333.7 | 19600.0 |
| 2020-02-07 04:15:00 | SPY | ETF | 333.72 | 333.73 | 333.72 | 333.73 | 2200.0 |
| 2020-02-07 04:20:00 | SPY | ETF | 333.74 | 333.74 | 333.74 | 333.74 | 100.0 |
| 2020-02-07 04:25:00 | SPY | ETF | 333.81 | 333.81 | 333.57 | 333.57 | 1037.0 |
| 2020-02-07 04:30:00 | SPY | ETF | 333.4 | 333.49 | 333.4 | 333.49 | 550.0 |
| 2020-02-07 04:35:00 | SPY | ETF | 333.51 | 333.64 | 333.51 | 333.64 | 1053.0 |
| 2020-02-07 04:40:00 | SPY | ETF | 333.5 | 333.5 | 333.47 | 333.47 | 200.0 |
| 2020-02-07 04:45:00 | SPY | ETF | 333.36 | 333.36 | 333.16 | 333.22 | 2651.0 |
| 2020-02-07 04:50:00 | SPY | ETF | 333.14 | 333.21 | 333.12 | 333.21 | 6070.0 |
| 2020-02-07 04:55:00 | SPY | ETF | 333.21 | 333.21 | 333.08 | 333.08 | 1147.0 |
| 2020-02-07 05:05:00 | SPY | ETF | 333.15 | 333.15 | 333.15 | 333.15 | 100.0 |
| 2020-02-07 05:10:00 | SPY | ETF | 333.0 | 333.0 | 332.76 | 332.84 | 2892.0 |
| 2020-02-07 05:15:00 | SPY | ETF | 332.79 | 332.79 | 332.79 | 332.79 | 805.0 |
| 2020-02-07 05:20:00 | SPY | ETF | 332.75 | 332.77 | 332.71 | 332.74 | 3580.0 |
| 2020-02-07 05:25:00 | SPY | ETF | 332.9 | 332.94 | 332.9 | 332.94 | 1577.0 |
| 2020-02-07 05:30:00 | SPY | ETF | 332.9 | 332.91 | 332.7 | 332.7 | 1760.0 |
| 2020-02-07 05:35:00 | SPY | ETF | 332.66 | 332.85 | 332.66 | 332.85 | 2408.0 |
| 2020-02-07 05:40:00 | SPY | ETF | 332.84 | 332.84 | 332.7 | 332.79 | 1758.0 |
| 2020-02-07 05:45:00 | SPY | ETF | 332.83 | 332.83 | 332.6 | 332.76 | 3152.0 |
| 2020-02-07 05:50:00 | SPY | ETF | 332.69 | 332.69 | 332.61 | 332.61 | 914.0 |
| 2020-02-07 05:55:00 | SPY | ETF | 332.66 | 332.66 | 332.56 | 332.56 | 1244.0 |
| 2020-02-07 06:00:00 | SPY | ETF | 332.5 | 332.5 | 332.34 | 332.35 | 1505.0 |
| 2020-02-07 06:05:00 | SPY | ETF | 332.41 | 332.55 | 332.41 | 332.54 | 1483.0 |
| 2020-02-07 06:10:00 | SPY | ETF | 332.52 | 332.73 | 332.51 | 332.73 | 3665.0 |
| 2020-02-07 06:15:00 | SPY | ETF | 332.83 | 332.97 | 332.82 | 332.82 | 3952.0 |
| 2020-02-07 06:20:00 | SPY | ETF | 332.84 | 332.94 | 332.81 | 332.94 | 3140.0 |
| 2020-02-07 06:25:00 | SPY | ETF | 332.8 | 332.85 | 332.8 | 332.85 | 522.0 |
| 2020-02-07 06:30:00 | SPY | ETF | 332.82 | 332.82 | 332.73 | 332.76 | 1675.0 |
| 2020-02-07 06:35:00 | SPY | ETF | 332.74 | 332.82 | 332.74 | 332.82 | 697.0 |
| 2020-02-07 06:40:00 | SPY | ETF | 332.83 | 332.83 | 332.72 | 332.72 | 2457.0 |
| 2020-02-07 06:45:00 | SPY | ETF | 332.78 | 332.78 | 332.78 | 332.78 | 169.0 |
| 2020-02-07 06:50:00 | SPY | ETF | 332.74 | 332.96 | 332.71 | 332.9 | 21200.0 |
| 2020-02-07 06:55:00 | SPY | ETF | 332.9 | 332.96 | 332.9 | 332.96 | 928.0 |
| 2020-02-07 07:00:00 | SPY | ETF | 333.0 | 333.02 | 332.93 | 332.99 | 6787.0 |
| 2020-02-07 07:05:00 | SPY | ETF | 333.04 | 333.1 | 333.04 | 333.04 | 13013.0 |
| 2020-02-07 07:10:00 | SPY | ETF | 333.0 | 333.09 | 333.0 | 333.09 | 4185.0 |
| 2020-02-07 07:15:00 | SPY | ETF | 333.1 | 333.26 | 333.05 | 333.21 | 22623.0 |
| 2020-02-07 07:20:00 | SPY | ETF | 333.2 | 333.2 | 333.11 | 333.16 | 7532.0 |
| 2020-02-07 07:25:00 | SPY | ETF | 333.1 | 333.1 | 333.07 | 333.07 | 6075.0 |
| 2020-02-07 07:30:00 | SPY | ETF | 333.12 | 333.25 | 333.11 | 333.25 | 6750.0 |
| 2020-02-07 07:35:00 | SPY | ETF | 333.16 | 333.19 | 333.16 | 333.17 | 6059.0 |
| 2020-02-07 07:40:00 | SPY | ETF | 333.17 | 333.18 | 333.08 | 333.15 | 3606.0 |
| 2020-02-07 07:45:00 | SPY | ETF | 333.14 | 333.14 | 333.07 | 333.1 | 2238.0 |
| 2020-02-07 07:50:00 | SPY | ETF | 333.08 | 333.139 | 333.08 | 333.1 | 3684.0 |
| 2020-02-07 07:55:00 | SPY | ETF | 333.12 | 333.28 | 333.12 | 333.28 | 24053.0 |
| 2020-02-07 08:00:00 | SPY | ETF | 333.18 | 334.2 | 332.99 | 333.13 | 36117.0 |
| 2020-02-07 08:05:00 | SPY | ETF | 333.19 | 333.19 | 332.97 | 333.0 | 21061.0 |
| 2020-02-07 08:10:00 | SPY | ETF | 333.01 | 333.1 | 332.95 | 333.1 | 21695.0 |
> showing 50 of 66,615 rows — these rows as CSV