PREVIEW / etf_5min / 2019-12-11
file: by_date/etf_5min/2019/2019-12-11.parquet size: 1.4 MB rows: 61,185
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-12-11 04:00:00 | SPY | ETF | 313.5 | 313.63 | 313.5 | 313.63 | 200.0 |
| 2019-12-11 04:05:00 | SPY | ETF | 313.77 | 313.77 | 313.77 | 313.77 | 200.0 |
| 2019-12-11 04:10:00 | SPY | ETF | 313.72 | 313.75 | 313.72 | 313.73 | 921.0 |
| 2019-12-11 04:15:00 | SPY | ETF | 313.68 | 313.69 | 313.68 | 313.69 | 620.0 |
| 2019-12-11 04:20:00 | SPY | ETF | 313.7 | 313.7 | 313.7 | 313.7 | 450.0 |
| 2019-12-11 04:25:00 | SPY | ETF | 313.63 | 313.7 | 313.63 | 313.7 | 1000.0 |
| 2019-12-11 04:35:00 | SPY | ETF | 313.69 | 313.69 | 313.69 | 313.69 | 350.0 |
| 2019-12-11 04:40:00 | SPY | ETF | 313.72 | 313.72 | 313.72 | 313.72 | 320.0 |
| 2019-12-11 04:55:00 | SPY | ETF | 313.7 | 313.7 | 313.7 | 313.7 | 320.0 |
| 2019-12-11 05:00:00 | SPY | ETF | 313.8 | 313.82 | 313.8 | 313.82 | 1250.0 |
| 2019-12-11 05:05:00 | SPY | ETF | 313.84 | 313.84 | 313.81 | 313.84 | 600.0 |
| 2019-12-11 05:15:00 | SPY | ETF | 313.78 | 313.84 | 313.78 | 313.84 | 631.0 |
| 2019-12-11 05:20:00 | SPY | ETF | 313.8 | 313.85 | 313.78 | 313.78 | 1520.0 |
| 2019-12-11 05:30:00 | SPY | ETF | 313.75 | 313.75 | 313.75 | 313.75 | 355.0 |
| 2019-12-11 05:35:00 | SPY | ETF | 313.68 | 313.68 | 313.52 | 313.54 | 3207.0 |
| 2019-12-11 05:40:00 | SPY | ETF | 313.62 | 313.62 | 313.57 | 313.57 | 2605.0 |
| 2019-12-11 05:45:00 | SPY | ETF | 313.55 | 313.59 | 313.55 | 313.59 | 600.0 |
| 2019-12-11 05:55:00 | SPY | ETF | 313.68 | 313.7 | 313.68 | 313.7 | 520.0 |
| 2019-12-11 06:00:00 | SPY | ETF | 313.76 | 313.76 | 313.76 | 313.76 | 205.0 |
| 2019-12-11 06:05:00 | SPY | ETF | 313.81 | 313.81 | 313.79 | 313.79 | 1000.0 |
| 2019-12-11 06:10:00 | SPY | ETF | 313.7 | 313.71 | 313.7 | 313.71 | 800.0 |
| 2019-12-11 06:15:00 | SPY | ETF | 313.71 | 313.71 | 313.7 | 313.7 | 600.0 |
| 2019-12-11 06:20:00 | SPY | ETF | 313.65 | 313.65 | 313.6 | 313.65 | 503.0 |
| 2019-12-11 06:25:00 | SPY | ETF | 313.64 | 313.64 | 313.6 | 313.6 | 720.0 |
| 2019-12-11 06:30:00 | SPY | ETF | 313.7 | 313.74 | 313.7 | 313.74 | 930.0 |
| 2019-12-11 06:35:00 | SPY | ETF | 313.8 | 313.89 | 313.8 | 313.84 | 1750.0 |
| 2019-12-11 06:40:00 | SPY | ETF | 313.86 | 313.86 | 313.86 | 313.86 | 1000.0 |
| 2019-12-11 06:45:00 | SPY | ETF | 313.87 | 313.87 | 313.85 | 313.85 | 200.0 |
| 2019-12-11 06:50:00 | SPY | ETF | 313.85 | 313.9 | 313.85 | 313.9 | 1100.0 |
| 2019-12-11 06:55:00 | SPY | ETF | 313.94 | 313.95 | 313.91 | 313.95 | 2072.0 |
| 2019-12-11 07:00:00 | SPY | ETF | 313.99 | 314.1 | 313.95 | 314.07 | 133942.0 |
| 2019-12-11 07:05:00 | SPY | ETF | 314.0 | 314.04 | 313.98 | 314.03 | 6759.0 |
| 2019-12-11 07:10:00 | SPY | ETF | 314.0 | 314.08 | 314.0 | 314.08 | 1902.0 |
| 2019-12-11 07:20:00 | SPY | ETF | 314.0 | 314.0 | 313.95 | 313.95 | 6553.0 |
| 2019-12-11 07:25:00 | SPY | ETF | 313.93 | 313.93 | 313.87 | 313.88 | 1879.0 |
| 2019-12-11 07:30:00 | SPY | ETF | 313.91 | 313.94 | 313.89 | 313.94 | 5495.0 |
| 2019-12-11 07:35:00 | SPY | ETF | 313.96 | 313.975 | 313.92 | 313.92 | 530.0 |
| 2019-12-11 07:40:00 | SPY | ETF | 313.97 | 313.97 | 313.97 | 313.97 | 100.0 |
| 2019-12-11 07:45:00 | SPY | ETF | 314.05 | 314.16 | 314.05 | 314.12 | 10533.0 |
| 2019-12-11 07:50:00 | SPY | ETF | 314.1 | 314.1 | 314.1 | 314.1 | 2000.0 |
| 2019-12-11 07:55:00 | SPY | ETF | 314.12 | 314.15 | 314.12 | 314.13 | 3277.0 |
| 2019-12-11 08:00:00 | SPY | ETF | 314.11 | 314.5 | 313.64 | 314.07 | 10320.0 |
| 2019-12-11 08:05:00 | SPY | ETF | 314.11 | 314.15 | 314.06 | 314.1 | 23164.0 |
| 2019-12-11 08:10:00 | SPY | ETF | 314.1 | 314.22 | 314.1 | 314.18 | 16070.0 |
| 2019-12-11 08:15:00 | SPY | ETF | 314.18 | 314.18 | 314.12 | 314.15 | 4793.0 |
| 2019-12-11 08:20:00 | SPY | ETF | 314.14 | 314.18 | 314.1 | 314.15 | 12114.0 |
| 2019-12-11 08:25:00 | SPY | ETF | 314.15 | 314.2 | 314.13 | 314.19 | 17379.0 |
| 2019-12-11 08:30:00 | SPY | ETF | 314.2 | 314.2 | 314.1 | 314.1 | 4874.0 |
| 2019-12-11 08:35:00 | SPY | ETF | 314.09 | 314.15 | 314.03 | 314.15 | 3872.0 |
| 2019-12-11 08:40:00 | SPY | ETF | 314.18 | 314.2799 | 314.17 | 314.2599 | 18868.0 |
> showing 50 of 61,185 rows — these rows as CSV