PREVIEW / stock_5min / 2015-11-05
file: by_date/stock_5min/2015/2015-11-05.parquet size: 5.5 MB rows: 362,480 symbols: 3,406
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-05 04:00:00 | AAPL | Stock | 30.4575 | 30.46 | 30.4 | 30.4 | 4240.0 |
| 2015-11-05 04:30:00 | AAPL | Stock | 30.4025 | 30.4025 | 30.4025 | 30.4025 | 400.0 |
| 2015-11-05 04:50:00 | AAPL | Stock | 30.4025 | 30.4025 | 30.3875 | 30.3875 | 4600.0 |
| 2015-11-05 05:10:00 | AAPL | Stock | 30.3875 | 30.3875 | 30.375 | 30.375 | 9980.0 |
| 2015-11-05 05:15:00 | AAPL | Stock | 30.3625 | 30.3625 | 30.3625 | 30.3625 | 4000.0 |
| 2015-11-05 05:25:00 | AAPL | Stock | 30.3875 | 30.3875 | 30.375 | 30.3875 | 2148.0 |
| 2015-11-05 05:30:00 | AAPL | Stock | 30.41 | 30.45 | 30.41 | 30.4375 | 13000.0 |
| 2015-11-05 05:35:00 | AAPL | Stock | 30.4625 | 30.4975 | 30.4625 | 30.4975 | 6656.0 |
| 2015-11-05 06:00:00 | AAPL | Stock | 30.45 | 30.48 | 30.45 | 30.48 | 5996.0 |
| 2015-11-05 06:20:00 | AAPL | Stock | 30.48 | 30.485 | 30.475 | 30.475 | 9480.0 |
| 2015-11-05 06:25:00 | AAPL | Stock | 30.47 | 30.475 | 30.47 | 30.475 | 13600.0 |
| 2015-11-05 06:30:00 | AAPL | Stock | 30.4725 | 30.475 | 30.4725 | 30.475 | 12000.0 |
| 2015-11-05 06:35:00 | AAPL | Stock | 30.475 | 30.475 | 30.4725 | 30.4725 | 8432.0 |
| 2015-11-05 06:40:00 | AAPL | Stock | 30.4725 | 30.5225 | 30.4725 | 30.5025 | 14400.0 |
| 2015-11-05 06:50:00 | AAPL | Stock | 30.4975 | 30.4975 | 30.475 | 30.475 | 800.0 |
| 2015-11-05 06:55:00 | AAPL | Stock | 30.49 | 30.49 | 30.49 | 30.49 | 400.0 |
| 2015-11-05 07:00:00 | AAPL | Stock | 30.4825 | 30.4825 | 30.4625 | 30.4625 | 5320.0 |
| 2015-11-05 07:05:00 | AAPL | Stock | 30.475 | 30.48 | 30.4375 | 30.445 | 26276.0 |
| 2015-11-05 07:10:00 | AAPL | Stock | 30.44 | 30.4775 | 30.44 | 30.46 | 29216.0 |
| 2015-11-05 07:15:00 | AAPL | Stock | 30.46 | 30.4825 | 30.455 | 30.4625 | 32840.0 |
| 2015-11-05 07:20:00 | AAPL | Stock | 30.4575 | 30.4575 | 30.4075 | 30.4125 | 35808.0 |
| 2015-11-05 07:25:00 | AAPL | Stock | 30.4225 | 30.425 | 30.4175 | 30.42 | 6800.0 |
| 2015-11-05 07:30:00 | AAPL | Stock | 30.415 | 30.45 | 30.39 | 30.445 | 38104.0 |
| 2015-11-05 07:35:00 | AAPL | Stock | 30.445 | 30.465 | 30.4425 | 30.4625 | 17200.0 |
| 2015-11-05 07:40:00 | AAPL | Stock | 30.45 | 30.46 | 30.4375 | 30.4375 | 66188.0 |
| 2015-11-05 07:45:00 | AAPL | Stock | 30.4425 | 30.45 | 30.4425 | 30.4475 | 44120.0 |
| 2015-11-05 07:50:00 | AAPL | Stock | 30.4425 | 30.45 | 30.42 | 30.4225 | 79748.0 |
| 2015-11-05 07:55:00 | AAPL | Stock | 30.4225 | 30.425 | 30.4175 | 30.425 | 41884.0 |
| 2015-11-05 08:00:00 | AAPL | Stock | 30.425 | 30.475 | 30.4025 | 30.4425 | 142740.0 |
| 2015-11-05 08:05:00 | AAPL | Stock | 30.44 | 30.4675 | 30.4375 | 30.4675 | 110772.0 |
| 2015-11-05 08:10:00 | AAPL | Stock | 30.4675 | 30.4775 | 30.4525 | 30.4525 | 80100.0 |
| 2015-11-05 08:15:00 | AAPL | Stock | 30.4525 | 30.475 | 30.45 | 30.4725 | 28792.0 |
| 2015-11-05 08:20:00 | AAPL | Stock | 30.47 | 30.475 | 30.46 | 30.47 | 23688.0 |
| 2015-11-05 08:25:00 | AAPL | Stock | 30.475 | 30.5125 | 30.4675 | 30.5 | 84128.0 |
| 2015-11-05 08:30:00 | AAPL | Stock | 30.4775 | 30.5 | 30.475 | 30.4875 | 57068.0 |
| 2015-11-05 08:35:00 | AAPL | Stock | 30.4775 | 30.48 | 30.4625 | 30.4675 | 67228.0 |
| 2015-11-05 08:40:00 | AAPL | Stock | 30.465 | 30.4725 | 30.45 | 30.465 | 40672.0 |
| 2015-11-05 08:45:00 | AAPL | Stock | 30.4625 | 30.4675 | 30.455 | 30.4675 | 17140.0 |
| 2015-11-05 08:50:00 | AAPL | Stock | 30.47 | 30.475 | 30.46 | 30.4625 | 34600.0 |
| 2015-11-05 08:55:00 | AAPL | Stock | 30.46 | 30.4625 | 30.4425 | 30.455 | 59496.0 |
| 2015-11-05 09:00:00 | AAPL | Stock | 30.46 | 30.475 | 30.46 | 30.4675 | 42948.0 |
| 2015-11-05 09:05:00 | AAPL | Stock | 30.4625 | 30.4675 | 30.4525 | 30.4525 | 24744.0 |
| 2015-11-05 09:10:00 | AAPL | Stock | 30.4525 | 30.455 | 30.4375 | 30.44 | 128240.0 |
| 2015-11-05 09:15:00 | AAPL | Stock | 30.44 | 30.4425 | 30.4375 | 30.4375 | 4288.0 |
| 2015-11-05 09:20:00 | AAPL | Stock | 30.4325 | 30.45 | 30.4225 | 30.45 | 15612.0 |
| 2015-11-05 09:25:00 | AAPL | Stock | 30.44 | 30.505 | 30.4325 | 30.495 | 224200.0 |
| 2015-11-05 09:30:00 | AAPL | Stock | 30.4625 | 30.56 | 30.445 | 30.5375 | 6306864.0 |
| 2015-11-05 09:35:00 | AAPL | Stock | 30.5375 | 30.6375 | 30.5075 | 30.6275 | 3988116.0 |
| 2015-11-05 09:40:00 | AAPL | Stock | 30.6275 | 30.655 | 30.5825 | 30.64 | 3518008.0 |
| 2015-11-05 09:45:00 | AAPL | Stock | 30.6462 | 30.67 | 30.6075 | 30.6275 | 3401516.0 |
> showing 50 of 362,480 rows — these rows as CSV