PREVIEW / etf_5min / 2013-12-16
file: by_date/etf_5min/2013/2013-12-16.parquet size: 978 KB rows: 41,586
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-16 04:05:00 | SPY | ETF | 178.01 | 178.01 | 178.01 | 178.01 | 100.0 |
| 2013-12-16 04:10:00 | SPY | ETF | 178.09 | 178.14 | 178.09 | 178.1 | 711.0 |
| 2013-12-16 04:15:00 | SPY | ETF | 178.09 | 178.09 | 178.09 | 178.09 | 100.0 |
| 2013-12-16 04:20:00 | SPY | ETF | 178.06 | 178.2 | 178.05 | 178.18 | 16000.0 |
| 2013-12-16 04:25:00 | SPY | ETF | 178.18 | 178.29 | 178.18 | 178.25 | 6723.0 |
| 2013-12-16 04:30:00 | SPY | ETF | 178.31 | 178.33 | 178.3 | 178.3 | 401.0 |
| 2013-12-16 04:35:00 | SPY | ETF | 178.27 | 178.31 | 178.27 | 178.31 | 900.0 |
| 2013-12-16 04:40:00 | SPY | ETF | 178.31 | 178.31 | 178.24 | 178.24 | 713.0 |
| 2013-12-16 04:45:00 | SPY | ETF | 178.24 | 178.27 | 178.24 | 178.24 | 3187.0 |
| 2013-12-16 04:50:00 | SPY | ETF | 178.27 | 178.27 | 178.27 | 178.27 | 102.0 |
| 2013-12-16 04:55:00 | SPY | ETF | 178.32 | 178.36 | 178.3 | 178.3 | 4810.0 |
| 2013-12-16 05:00:00 | SPY | ETF | 178.27 | 178.27 | 178.24 | 178.24 | 1201.0 |
| 2013-12-16 05:05:00 | SPY | ETF | 178.23 | 178.33 | 178.23 | 178.33 | 42316.0 |
| 2013-12-16 05:10:00 | SPY | ETF | 178.36 | 178.51 | 178.36 | 178.51 | 2530.0 |
| 2013-12-16 05:15:00 | SPY | ETF | 178.5 | 178.81 | 178.5 | 178.73 | 23494.0 |
| 2013-12-16 05:20:00 | SPY | ETF | 178.75 | 178.8 | 178.69 | 178.8 | 12340.0 |
| 2013-12-16 05:25:00 | SPY | ETF | 178.84 | 178.86 | 178.75 | 178.75 | 3700.0 |
| 2013-12-16 05:30:00 | SPY | ETF | 178.78 | 178.79 | 178.67 | 178.7 | 12100.0 |
| 2013-12-16 05:35:00 | SPY | ETF | 178.72 | 178.75 | 178.72 | 178.75 | 418.0 |
| 2013-12-16 05:40:00 | SPY | ETF | 178.76 | 178.76 | 178.72 | 178.72 | 400.0 |
| 2013-12-16 05:50:00 | SPY | ETF | 178.75 | 178.75 | 178.75 | 178.75 | 100.0 |
| 2013-12-16 05:55:00 | SPY | ETF | 178.78 | 178.81 | 178.78 | 178.81 | 500.0 |
| 2013-12-16 06:00:00 | SPY | ETF | 178.8 | 178.81 | 178.77 | 178.78 | 16753.0 |
| 2013-12-16 06:05:00 | SPY | ETF | 178.75 | 178.75 | 178.75 | 178.75 | 100.0 |
| 2013-12-16 06:10:00 | SPY | ETF | 178.77 | 178.81 | 178.77 | 178.79 | 3674.0 |
| 2013-12-16 06:15:00 | SPY | ETF | 178.78 | 178.78 | 178.78 | 178.78 | 1102.0 |
| 2013-12-16 06:20:00 | SPY | ETF | 178.78 | 178.78 | 178.78 | 178.78 | 1578.0 |
| 2013-12-16 06:25:00 | SPY | ETF | 178.75 | 178.77 | 178.75 | 178.75 | 1253.0 |
| 2013-12-16 06:30:00 | SPY | ETF | 178.77 | 178.79 | 178.75 | 178.79 | 3107.0 |
| 2013-12-16 06:35:00 | SPY | ETF | 178.8 | 178.84 | 178.8 | 178.84 | 2833.0 |
| 2013-12-16 06:40:00 | SPY | ETF | 178.83 | 179.04 | 178.83 | 178.93 | 41144.0 |
| 2013-12-16 06:45:00 | SPY | ETF | 178.93 | 178.93 | 178.9 | 178.9 | 24596.0 |
| 2013-12-16 06:50:00 | SPY | ETF | 178.9 | 178.9 | 178.85 | 178.85 | 32300.0 |
| 2013-12-16 06:55:00 | SPY | ETF | 178.85 | 178.85 | 178.83 | 178.83 | 9500.0 |
| 2013-12-16 07:00:00 | SPY | ETF | 178.82 | 178.94 | 178.8 | 178.91 | 99961.0 |
| 2013-12-16 07:05:00 | SPY | ETF | 178.94 | 178.96 | 178.93 | 178.93 | 26811.0 |
| 2013-12-16 07:10:00 | SPY | ETF | 178.92 | 178.92 | 178.92 | 178.92 | 20200.0 |
| 2013-12-16 07:15:00 | SPY | ETF | 178.92 | 178.92 | 178.91 | 178.92 | 42200.0 |
| 2013-12-16 07:20:00 | SPY | ETF | 178.91 | 178.99 | 178.91 | 178.94 | 54755.0 |
| 2013-12-16 07:25:00 | SPY | ETF | 178.94 | 178.96 | 178.92 | 178.93 | 42114.0 |
| 2013-12-16 07:30:00 | SPY | ETF | 178.96 | 178.97 | 178.94 | 178.96 | 17393.0 |
| 2013-12-16 07:35:00 | SPY | ETF | 178.96 | 178.97 | 178.93 | 178.94 | 15700.0 |
| 2013-12-16 07:40:00 | SPY | ETF | 178.95 | 178.95 | 178.93 | 178.93 | 12700.0 |
| 2013-12-16 07:45:00 | SPY | ETF | 178.93 | 178.94 | 178.93 | 178.94 | 20745.0 |
| 2013-12-16 07:50:00 | SPY | ETF | 178.94 | 178.98 | 178.93 | 178.98 | 41450.0 |
| 2013-12-16 07:55:00 | SPY | ETF | 178.99 | 179.16 | 178.98 | 179.05 | 44615.0 |
| 2013-12-16 08:00:00 | SPY | ETF | 179.07 | 179.08 | 177.04 | 179.03 | 84233.0 |
| 2013-12-16 08:05:00 | SPY | ETF | 179.05 | 179.07 | 179.03 | 179.05 | 32959.0 |
| 2013-12-16 08:10:00 | SPY | ETF | 179.05 | 179.05 | 178.97 | 178.99 | 51975.0 |
| 2013-12-16 08:15:00 | SPY | ETF | 178.97 | 178.99 | 178.95 | 178.95 | 13500.0 |
> showing 50 of 41,586 rows — these rows as CSV