PREVIEW / etf_5min / 2019-04-11
file: by_date/etf_5min/2019/2019-04-11.parquet size: 1.4 MB rows: 60,580
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-04-11 04:00:00 | SPY | ETF | 288.17 | 288.17 | 288.1 | 288.13 | 5337.0 |
| 2019-04-11 04:05:00 | SPY | ETF | 288.15 | 288.15 | 288.15 | 288.15 | 500.0 |
| 2019-04-11 04:10:00 | SPY | ETF | 288.2 | 288.21 | 288.2 | 288.21 | 480.0 |
| 2019-04-11 04:15:00 | SPY | ETF | 288.21 | 288.21 | 288.2 | 288.2 | 810.0 |
| 2019-04-11 04:20:00 | SPY | ETF | 288.13 | 288.18 | 288.13 | 288.18 | 600.0 |
| 2019-04-11 04:25:00 | SPY | ETF | 288.18 | 288.18 | 288.18 | 288.18 | 500.0 |
| 2019-04-11 04:35:00 | SPY | ETF | 288.19 | 288.19 | 288.19 | 288.19 | 1100.0 |
| 2019-04-11 04:50:00 | SPY | ETF | 288.4 | 288.4 | 288.4 | 288.4 | 400.0 |
| 2019-04-11 04:55:00 | SPY | ETF | 288.39 | 288.39 | 288.39 | 288.39 | 1100.0 |
| 2019-04-11 05:10:00 | SPY | ETF | 288.42 | 288.42 | 288.42 | 288.42 | 400.0 |
| 2019-04-11 05:25:00 | SPY | ETF | 288.59 | 288.59 | 288.58 | 288.59 | 4500.0 |
| 2019-04-11 05:35:00 | SPY | ETF | 288.59 | 288.59 | 288.59 | 288.59 | 300.0 |
| 2019-04-11 05:40:00 | SPY | ETF | 288.64 | 288.7 | 288.64 | 288.7 | 720.0 |
| 2019-04-11 05:45:00 | SPY | ETF | 288.66 | 288.66 | 288.64 | 288.64 | 1450.0 |
| 2019-04-11 05:50:00 | SPY | ETF | 288.64 | 288.74 | 288.64 | 288.74 | 1050.0 |
| 2019-04-11 05:55:00 | SPY | ETF | 288.69 | 288.69 | 288.69 | 288.69 | 200.0 |
| 2019-04-11 06:00:00 | SPY | ETF | 288.66 | 288.74 | 288.66 | 288.74 | 1305.0 |
| 2019-04-11 06:05:00 | SPY | ETF | 288.77 | 288.81 | 288.77 | 288.81 | 845.0 |
| 2019-04-11 06:10:00 | SPY | ETF | 288.77 | 288.77 | 288.77 | 288.77 | 140.0 |
| 2019-04-11 06:20:00 | SPY | ETF | 288.78 | 288.78 | 288.78 | 288.78 | 100.0 |
| 2019-04-11 06:25:00 | SPY | ETF | 288.74 | 288.74 | 288.71 | 288.71 | 450.0 |
| 2019-04-11 06:30:00 | SPY | ETF | 288.74 | 288.78 | 288.74 | 288.78 | 225.0 |
| 2019-04-11 06:35:00 | SPY | ETF | 288.75 | 288.75 | 288.75 | 288.75 | 100.0 |
| 2019-04-11 06:40:00 | SPY | ETF | 288.78 | 288.78 | 288.74 | 288.74 | 2100.0 |
| 2019-04-11 06:45:00 | SPY | ETF | 288.8 | 288.88 | 288.8 | 288.8 | 6150.0 |
| 2019-04-11 06:50:00 | SPY | ETF | 288.88 | 288.88 | 288.88 | 288.88 | 120.0 |
| 2019-04-11 07:00:00 | SPY | ETF | 288.89 | 288.96 | 288.89 | 288.95 | 4288.0 |
| 2019-04-11 07:05:00 | SPY | ETF | 288.98 | 288.99 | 288.98 | 288.99 | 4675.0 |
| 2019-04-11 07:10:00 | SPY | ETF | 288.99 | 288.99 | 288.86 | 288.87 | 11720.0 |
| 2019-04-11 07:15:00 | SPY | ETF | 288.88 | 288.91 | 288.88 | 288.91 | 750.0 |
| 2019-04-11 07:20:00 | SPY | ETF | 288.87 | 288.92 | 288.84 | 288.92 | 6177.0 |
| 2019-04-11 07:25:00 | SPY | ETF | 288.85 | 288.85 | 288.77 | 288.78 | 6450.0 |
| 2019-04-11 07:30:00 | SPY | ETF | 288.87 | 288.87 | 288.82 | 288.82 | 2500.0 |
| 2019-04-11 07:35:00 | SPY | ETF | 288.84 | 288.85 | 288.81 | 288.83 | 1750.0 |
| 2019-04-11 07:40:00 | SPY | ETF | 288.75 | 288.75 | 288.74 | 288.74 | 670.0 |
| 2019-04-11 07:45:00 | SPY | ETF | 288.78 | 288.8 | 288.78 | 288.8 | 2977.0 |
| 2019-04-11 07:50:00 | SPY | ETF | 288.84 | 288.84 | 288.78 | 288.79 | 2982.0 |
| 2019-04-11 07:55:00 | SPY | ETF | 288.81 | 288.81 | 288.76 | 288.77 | 3100.0 |
| 2019-04-11 08:00:00 | SPY | ETF | 288.89 | 289.0 | 288.08 | 288.75 | 344384.0 |
| 2019-04-11 08:05:00 | SPY | ETF | 288.3 | 288.75 | 288.3 | 288.73 | 154415.0 |
| 2019-04-11 08:10:00 | SPY | ETF | 288.71 | 288.71 | 288.62 | 288.67 | 9571.0 |
| 2019-04-11 08:15:00 | SPY | ETF | 288.65 | 288.67 | 288.6 | 288.6 | 9943.0 |
| 2019-04-11 08:20:00 | SPY | ETF | 288.59 | 288.76 | 288.59 | 288.73 | 25475.0 |
| 2019-04-11 08:25:00 | SPY | ETF | 288.73 | 288.82 | 288.73 | 288.78 | 45189.0 |
| 2019-04-11 08:30:00 | SPY | ETF | 288.73 | 288.84 | 288.62 | 288.8 | 42031.0 |
| 2019-04-11 08:35:00 | SPY | ETF | 288.81 | 288.84 | 288.4 | 288.75 | 169398.0 |
| 2019-04-11 08:40:00 | SPY | ETF | 288.74 | 288.75 | 288.6 | 288.65 | 16078.0 |
| 2019-04-11 08:45:00 | SPY | ETF | 288.65 | 288.77 | 288.64 | 288.7 | 8202.0 |
| 2019-04-11 08:50:00 | SPY | ETF | 288.72 | 288.75 | 288.67 | 288.7 | 14731.0 |
| 2019-04-11 08:55:00 | SPY | ETF | 288.7 | 288.7 | 288.6 | 288.62 | 15463.0 |
> showing 50 of 60,580 rows — these rows as CSV