PREVIEW / etf_5min / 2019-01-22
file: by_date/etf_5min/2019/2019-01-22.parquet size: 1.6 MB rows: 67,943
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 |
|---|---|---|---|---|---|---|---|
| 2019-01-22 04:00:00 | SPY | ETF | 265.11 | 265.25 | 264.94 | 265.07 | 10228.0 |
| 2019-01-22 04:05:00 | SPY | ETF | 265.01 | 265.02 | 264.91 | 265.02 | 8789.0 |
| 2019-01-22 04:10:00 | SPY | ETF | 265.1 | 265.1 | 264.97 | 265.02 | 2118.0 |
| 2019-01-22 04:15:00 | SPY | ETF | 265.02 | 265.1 | 264.97 | 265.07 | 2313.0 |
| 2019-01-22 04:25:00 | SPY | ETF | 265.02 | 265.02 | 264.97 | 264.97 | 350.0 |
| 2019-01-22 04:30:00 | SPY | ETF | 265.09 | 265.16 | 265.09 | 265.16 | 3823.0 |
| 2019-01-22 04:35:00 | SPY | ETF | 265.15 | 265.16 | 265.01 | 265.14 | 1619.0 |
| 2019-01-22 04:40:00 | SPY | ETF | 265.2 | 265.2 | 265.09 | 265.09 | 603.0 |
| 2019-01-22 04:45:00 | SPY | ETF | 265.07 | 265.07 | 265.05 | 265.05 | 1800.0 |
| 2019-01-22 04:50:00 | SPY | ETF | 265.0 | 265.02 | 264.91 | 265.02 | 6750.0 |
| 2019-01-22 04:55:00 | SPY | ETF | 264.9 | 264.99 | 264.9 | 264.98 | 1910.0 |
| 2019-01-22 05:00:00 | SPY | ETF | 265.0 | 265.02 | 264.98 | 264.98 | 450.0 |
| 2019-01-22 05:05:00 | SPY | ETF | 264.99 | 264.99 | 264.94 | 264.94 | 650.0 |
| 2019-01-22 05:10:00 | SPY | ETF | 264.94 | 264.94 | 264.87 | 264.88 | 1160.0 |
| 2019-01-22 05:15:00 | SPY | ETF | 264.82 | 264.9 | 264.82 | 264.9 | 435.0 |
| 2019-01-22 05:20:00 | SPY | ETF | 264.87 | 264.87 | 264.8 | 264.8 | 1700.0 |
| 2019-01-22 05:25:00 | SPY | ETF | 264.81 | 264.85 | 264.81 | 264.85 | 600.0 |
| 2019-01-22 05:30:00 | SPY | ETF | 264.82 | 264.83 | 264.73 | 264.83 | 4510.0 |
| 2019-01-22 05:35:00 | SPY | ETF | 264.78 | 264.8 | 264.76 | 264.76 | 2100.0 |
| 2019-01-22 05:40:00 | SPY | ETF | 264.8 | 264.8 | 264.7 | 264.7 | 2375.0 |
| 2019-01-22 05:45:00 | SPY | ETF | 264.75 | 264.78 | 264.75 | 264.77 | 19052.0 |
| 2019-01-22 05:50:00 | SPY | ETF | 264.76 | 264.76 | 264.76 | 264.76 | 200.0 |
| 2019-01-22 05:55:00 | SPY | ETF | 264.74 | 264.78 | 264.65 | 264.65 | 2500.0 |
| 2019-01-22 06:00:00 | SPY | ETF | 264.65 | 264.67 | 264.59 | 264.66 | 6450.0 |
| 2019-01-22 06:05:00 | SPY | ETF | 264.57 | 264.58 | 264.48 | 264.58 | 2756.0 |
| 2019-01-22 06:10:00 | SPY | ETF | 264.57 | 264.62 | 264.41 | 264.41 | 2910.0 |
| 2019-01-22 06:15:00 | SPY | ETF | 264.4 | 264.46 | 264.31 | 264.42 | 6000.0 |
| 2019-01-22 06:20:00 | SPY | ETF | 264.42 | 264.43 | 264.41 | 264.42 | 10295.0 |
| 2019-01-22 06:25:00 | SPY | ETF | 264.45 | 264.45 | 264.45 | 264.45 | 300.0 |
| 2019-01-22 06:30:00 | SPY | ETF | 264.35 | 264.4 | 264.3 | 264.4 | 3967.0 |
| 2019-01-22 06:35:00 | SPY | ETF | 264.37 | 264.45 | 264.37 | 264.45 | 14300.0 |
| 2019-01-22 06:40:00 | SPY | ETF | 264.48 | 264.48 | 264.4 | 264.47 | 550.0 |
| 2019-01-22 06:45:00 | SPY | ETF | 264.5 | 264.54 | 264.43 | 264.5 | 17500.0 |
| 2019-01-22 06:50:00 | SPY | ETF | 264.48 | 264.5 | 264.4 | 264.4 | 7700.0 |
| 2019-01-22 06:55:00 | SPY | ETF | 264.44 | 264.65 | 264.44 | 264.62 | 14650.0 |
| 2019-01-22 07:00:00 | SPY | ETF | 264.67 | 264.81 | 264.63 | 264.81 | 46518.0 |
| 2019-01-22 07:05:00 | SPY | ETF | 264.84 | 264.85 | 264.74 | 264.8 | 25828.0 |
| 2019-01-22 07:10:00 | SPY | ETF | 264.76 | 264.83 | 264.74 | 264.82 | 16277.0 |
| 2019-01-22 07:15:00 | SPY | ETF | 264.83 | 264.85 | 264.78 | 264.79 | 15810.0 |
| 2019-01-22 07:20:00 | SPY | ETF | 264.85 | 264.94 | 264.84 | 264.94 | 27441.0 |
| 2019-01-22 07:25:00 | SPY | ETF | 264.95 | 265.0 | 264.88 | 264.98 | 11512.0 |
| 2019-01-22 07:30:00 | SPY | ETF | 264.99 | 265.08 | 264.94 | 265.05 | 50451.0 |
| 2019-01-22 07:35:00 | SPY | ETF | 265.06 | 265.11 | 265.0 | 265.0 | 10877.0 |
| 2019-01-22 07:40:00 | SPY | ETF | 265.0 | 265.07 | 265.0 | 265.07 | 16589.0 |
| 2019-01-22 07:45:00 | SPY | ETF | 265.09 | 265.09 | 264.96 | 265.01 | 12746.0 |
| 2019-01-22 07:50:00 | SPY | ETF | 265.03 | 265.08 | 264.98 | 264.99 | 25960.0 |
| 2019-01-22 07:55:00 | SPY | ETF | 264.99 | 265.07 | 264.88 | 264.9 | 35613.0 |
| 2019-01-22 08:00:00 | SPY | ETF | 265.0503 | 266.151 | 264.4 | 264.9 | 70779.0 |
| 2019-01-22 08:05:00 | SPY | ETF | 264.89 | 265.07 | 264.88 | 265.04 | 17247.0 |
| 2019-01-22 08:10:00 | SPY | ETF | 265.05 | 265.09 | 264.95 | 264.98 | 33018.0 |
> showing 50 of 67,943 rows — these rows as CSV