PREVIEW / stock_5min / 2014-10-09
file: by_date/stock_5min/2014/2014-10-09.parquet size: 5.6 MB rows: 364,837 symbols: 3,545
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-09 04:00:00 | AAPL | Stock | 25.235 | 25.2825 | 25.235 | 25.2825 | 4400.0 |
| 2014-10-09 04:10:00 | AAPL | Stock | 25.225 | 25.225 | 25.225 | 25.225 | 2000.0 |
| 2014-10-09 04:20:00 | AAPL | Stock | 25.25 | 25.28 | 25.25 | 25.28 | 8548.0 |
| 2014-10-09 04:25:00 | AAPL | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 2000.0 |
| 2014-10-09 04:30:00 | AAPL | Stock | 25.275 | 25.275 | 25.275 | 25.275 | 800.0 |
| 2014-10-09 04:35:00 | AAPL | Stock | 25.275 | 25.275 | 25.275 | 25.275 | 568.0 |
| 2014-10-09 04:50:00 | AAPL | Stock | 25.2625 | 25.2625 | 25.2625 | 25.2625 | 5040.0 |
| 2014-10-09 04:55:00 | AAPL | Stock | 25.2625 | 25.2625 | 25.2625 | 25.2625 | 1600.0 |
| 2014-10-09 05:00:00 | AAPL | Stock | 25.23 | 25.23 | 25.23 | 25.23 | 1360.0 |
| 2014-10-09 05:05:00 | AAPL | Stock | 25.225 | 25.225 | 25.225 | 25.225 | 4200.0 |
| 2014-10-09 05:10:00 | AAPL | Stock | 25.23 | 25.23 | 25.23 | 25.23 | 800.0 |
| 2014-10-09 05:15:00 | AAPL | Stock | 25.23 | 25.2375 | 25.23 | 25.2375 | 2240.0 |
| 2014-10-09 05:25:00 | AAPL | Stock | 25.23 | 25.2375 | 25.21 | 25.21 | 3600.0 |
| 2014-10-09 05:30:00 | AAPL | Stock | 25.225 | 25.225 | 25.225 | 25.225 | 1200.0 |
| 2014-10-09 05:40:00 | AAPL | Stock | 25.225 | 25.225 | 25.225 | 25.225 | 800.0 |
| 2014-10-09 06:05:00 | AAPL | Stock | 25.255 | 25.255 | 25.255 | 25.255 | 400.0 |
| 2014-10-09 06:10:00 | AAPL | Stock | 25.2625 | 25.275 | 25.2625 | 25.275 | 2632.0 |
| 2014-10-09 06:20:00 | AAPL | Stock | 25.2625 | 25.2625 | 25.2625 | 25.2625 | 2000.0 |
| 2014-10-09 06:25:00 | AAPL | Stock | 25.2625 | 25.2625 | 25.2625 | 25.2625 | 3600.0 |
| 2014-10-09 06:30:00 | AAPL | Stock | 25.2375 | 25.3325 | 25.2375 | 25.3325 | 31780.0 |
| 2014-10-09 06:35:00 | AAPL | Stock | 25.3325 | 25.34 | 25.31 | 25.33 | 48348.0 |
| 2014-10-09 06:40:00 | AAPL | Stock | 25.3325 | 25.3775 | 25.325 | 25.335 | 24164.0 |
| 2014-10-09 06:45:00 | AAPL | Stock | 25.35 | 25.35 | 25.3325 | 25.345 | 22912.0 |
| 2014-10-09 06:50:00 | AAPL | Stock | 25.34 | 25.36 | 25.34 | 25.3575 | 6244.0 |
| 2014-10-09 06:55:00 | AAPL | Stock | 25.365 | 25.365 | 25.3025 | 25.3025 | 5176.0 |
| 2014-10-09 07:00:00 | AAPL | Stock | 25.355 | 25.3575 | 25.3 | 25.305 | 51600.0 |
| 2014-10-09 07:05:00 | AAPL | Stock | 25.3 | 25.3075 | 25.27 | 25.27 | 18208.0 |
| 2014-10-09 07:10:00 | AAPL | Stock | 25.2775 | 25.33 | 25.2775 | 25.3 | 100948.0 |
| 2014-10-09 07:15:00 | AAPL | Stock | 25.295 | 25.3 | 25.2875 | 25.3 | 25456.0 |
| 2014-10-09 07:20:00 | AAPL | Stock | 25.3 | 25.3 | 25.2725 | 25.275 | 25120.0 |
| 2014-10-09 07:25:00 | AAPL | Stock | 25.28 | 25.28 | 25.28 | 25.28 | 400.0 |
| 2014-10-09 07:30:00 | AAPL | Stock | 25.2725 | 25.2975 | 25.27 | 25.2875 | 12232.0 |
| 2014-10-09 07:35:00 | AAPL | Stock | 25.27 | 25.275 | 25.27 | 25.27 | 13480.0 |
| 2014-10-09 07:40:00 | AAPL | Stock | 25.275 | 25.275 | 25.21 | 25.2225 | 94704.0 |
| 2014-10-09 07:45:00 | AAPL | Stock | 25.22 | 25.2425 | 25.2 | 25.23 | 125960.0 |
| 2014-10-09 07:50:00 | AAPL | Stock | 25.235 | 25.2375 | 25.1875 | 25.1875 | 25156.0 |
| 2014-10-09 07:55:00 | AAPL | Stock | 25.18 | 25.18 | 25.13 | 25.1675 | 45692.0 |
| 2014-10-09 08:00:00 | AAPL | Stock | 25.175 | 25.33 | 25.125 | 25.185 | 191048.0 |
| 2014-10-09 08:05:00 | AAPL | Stock | 25.175 | 25.2 | 25.1625 | 25.165 | 58588.0 |
| 2014-10-09 08:10:00 | AAPL | Stock | 25.17 | 25.185 | 25.1625 | 25.185 | 14000.0 |
| 2014-10-09 08:15:00 | AAPL | Stock | 25.175 | 25.1875 | 25.175 | 25.175 | 35780.0 |
| 2014-10-09 08:20:00 | AAPL | Stock | 25.1725 | 25.175 | 25.1625 | 25.175 | 33112.0 |
| 2014-10-09 08:25:00 | AAPL | Stock | 25.175 | 25.225 | 25.175 | 25.21 | 56936.0 |
| 2014-10-09 08:30:00 | AAPL | Stock | 25.215 | 25.3 | 25.215 | 25.2875 | 370036.0 |
| 2014-10-09 08:35:00 | AAPL | Stock | 25.2725 | 25.375 | 25.2125 | 25.35 | 819764.0 |
| 2014-10-09 08:40:00 | AAPL | Stock | 25.3625 | 25.4475 | 25.3475 | 25.4325 | 1109664.0 |
| 2014-10-09 08:45:00 | AAPL | Stock | 25.4475 | 25.46 | 25.38 | 25.45 | 1320108.0 |
| 2014-10-09 08:50:00 | AAPL | Stock | 25.45 | 25.47 | 25.4 | 25.4375 | 703384.0 |
| 2014-10-09 08:55:00 | AAPL | Stock | 25.4275 | 25.4375 | 25.3825 | 25.425 | 384220.0 |
| 2014-10-09 09:00:00 | AAPL | Stock | 25.425 | 25.4325 | 25.3925 | 25.395 | 388492.0 |
> showing 50 of 364,837 rows — these rows as CSV