PREVIEW / stock_5min / 2015-12-09
file: by_date/stock_5min/2015/2015-12-09.parquet size: 5.6 MB rows: 369,125 symbols: 3,410
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-12-09 04:00:00 | AAPL | Stock | 29.49 | 29.49 | 29.4825 | 29.4825 | 2400.0 |
| 2015-12-09 04:10:00 | AAPL | Stock | 29.4875 | 29.4875 | 29.4875 | 29.4875 | 400.0 |
| 2015-12-09 04:15:00 | AAPL | Stock | 29.525 | 29.525 | 29.525 | 29.525 | 400.0 |
| 2015-12-09 04:20:00 | AAPL | Stock | 29.4725 | 29.4725 | 29.47 | 29.47 | 6800.0 |
| 2015-12-09 04:25:00 | AAPL | Stock | 29.47 | 29.47 | 29.47 | 29.47 | 2400.0 |
| 2015-12-09 04:30:00 | AAPL | Stock | 29.465 | 29.465 | 29.465 | 29.465 | 560.0 |
| 2015-12-09 04:45:00 | AAPL | Stock | 29.4675 | 29.4675 | 29.4675 | 29.4675 | 800.0 |
| 2015-12-09 05:05:00 | AAPL | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 460.0 |
| 2015-12-09 05:20:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 1200.0 |
| 2015-12-09 05:25:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 800.0 |
| 2015-12-09 05:45:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 5540.0 |
| 2015-12-09 05:55:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 4880.0 |
| 2015-12-09 06:10:00 | AAPL | Stock | 29.4525 | 29.4525 | 29.4525 | 29.4525 | 400.0 |
| 2015-12-09 06:15:00 | AAPL | Stock | 29.435 | 29.435 | 29.435 | 29.435 | 2000.0 |
| 2015-12-09 06:20:00 | AAPL | Stock | 29.435 | 29.45 | 29.435 | 29.45 | 12800.0 |
| 2015-12-09 06:25:00 | AAPL | Stock | 29.475 | 29.475 | 29.475 | 29.475 | 3600.0 |
| 2015-12-09 06:30:00 | AAPL | Stock | 29.45 | 29.45 | 29.445 | 29.45 | 13200.0 |
| 2015-12-09 06:35:00 | AAPL | Stock | 29.4575 | 29.4575 | 29.4575 | 29.4575 | 800.0 |
| 2015-12-09 06:45:00 | AAPL | Stock | 29.425 | 29.425 | 29.425 | 29.425 | 1764.0 |
| 2015-12-09 06:50:00 | AAPL | Stock | 29.445 | 29.445 | 29.445 | 29.445 | 1216.0 |
| 2015-12-09 06:55:00 | AAPL | Stock | 29.4275 | 29.4275 | 29.4275 | 29.4275 | 800.0 |
| 2015-12-09 07:00:00 | AAPL | Stock | 29.45 | 29.455 | 29.44 | 29.44 | 6392.0 |
| 2015-12-09 07:10:00 | AAPL | Stock | 29.44 | 29.455 | 29.4375 | 29.45 | 14200.0 |
| 2015-12-09 07:15:00 | AAPL | Stock | 29.45 | 29.5 | 29.45 | 29.5 | 12400.0 |
| 2015-12-09 07:20:00 | AAPL | Stock | 29.475 | 29.505 | 29.44 | 29.505 | 5548.0 |
| 2015-12-09 07:25:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 480.0 |
| 2015-12-09 07:40:00 | AAPL | Stock | 29.4625 | 29.4625 | 29.4625 | 29.4625 | 8000.0 |
| 2015-12-09 07:45:00 | AAPL | Stock | 29.465 | 29.465 | 29.465 | 29.465 | 400.0 |
| 2015-12-09 07:55:00 | AAPL | Stock | 29.475 | 29.475 | 29.475 | 29.475 | 8000.0 |
| 2015-12-09 08:00:00 | AAPL | Stock | 29.485 | 29.485 | 29.4375 | 29.44 | 37252.0 |
| 2015-12-09 08:05:00 | AAPL | Stock | 29.44 | 29.455 | 29.44 | 29.45 | 25380.0 |
| 2015-12-09 08:10:00 | AAPL | Stock | 29.4575 | 29.4825 | 29.455 | 29.4825 | 15832.0 |
| 2015-12-09 08:20:00 | AAPL | Stock | 29.485 | 29.485 | 29.485 | 29.485 | 2512.0 |
| 2015-12-09 08:25:00 | AAPL | Stock | 29.495 | 29.5225 | 29.495 | 29.505 | 33720.0 |
| 2015-12-09 08:30:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.51 | 29.51 | 10000.0 |
| 2015-12-09 08:35:00 | AAPL | Stock | 29.515 | 29.5375 | 29.51 | 29.51 | 52532.0 |
| 2015-12-09 08:40:00 | AAPL | Stock | 29.5125 | 29.5125 | 29.4825 | 29.4825 | 38200.0 |
| 2015-12-09 08:45:00 | AAPL | Stock | 29.4775 | 29.48 | 29.4525 | 29.4525 | 24432.0 |
| 2015-12-09 08:50:00 | AAPL | Stock | 29.4525 | 29.4625 | 29.4525 | 29.4525 | 5000.0 |
| 2015-12-09 08:55:00 | AAPL | Stock | 29.4675 | 29.4675 | 29.455 | 29.455 | 15096.0 |
| 2015-12-09 09:00:00 | AAPL | Stock | 29.455 | 29.455 | 29.415 | 29.415 | 64780.0 |
| 2015-12-09 09:05:00 | AAPL | Stock | 29.415 | 29.4275 | 29.4 | 29.4 | 74300.0 |
| 2015-12-09 09:10:00 | AAPL | Stock | 29.4 | 29.435 | 29.4 | 29.435 | 14736.0 |
| 2015-12-09 09:15:00 | AAPL | Stock | 29.4375 | 29.44 | 29.435 | 29.44 | 15048.0 |
| 2015-12-09 09:20:00 | AAPL | Stock | 29.4475 | 29.5575 | 29.4375 | 29.4475 | 39996.0 |
| 2015-12-09 09:25:00 | AAPL | Stock | 29.4475 | 29.45 | 29.38 | 29.39 | 113576.0 |
| 2015-12-09 09:30:00 | AAPL | Stock | 29.3775 | 29.4225 | 29.27 | 29.275 | 4943672.0 |
| 2015-12-09 09:35:00 | AAPL | Stock | 29.275 | 29.3925 | 29.2725 | 29.3575 | 2453528.0 |
| 2015-12-09 09:40:00 | AAPL | Stock | 29.3575 | 29.4125 | 29.3325 | 29.345 | 2269036.0 |
| 2015-12-09 09:45:00 | AAPL | Stock | 29.3438 | 29.3725 | 29.3172 | 29.3725 | 1999256.0 |
> showing 50 of 369,125 rows — these rows as CSV