PREVIEW / stock_5min / 2015-03-31
file: by_date/stock_5min/2015/2015-03-31.parquet size: 5.5 MB rows: 363,593 symbols: 3,526
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-03-31 04:00:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.565 | 31.565 | 2208.0 |
| 2015-03-31 04:15:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 2000.0 |
| 2015-03-31 04:30:00 | AAPL | Stock | 31.5875 | 31.5875 | 31.5875 | 31.5875 | 2800.0 |
| 2015-03-31 04:55:00 | AAPL | Stock | 31.6 | 31.6 | 31.6 | 31.6 | 2000.0 |
| 2015-03-31 06:00:00 | AAPL | Stock | 31.5225 | 31.5225 | 31.3775 | 31.3775 | 11804.0 |
| 2015-03-31 06:10:00 | AAPL | Stock | 31.485 | 31.485 | 31.485 | 31.485 | 2000.0 |
| 2015-03-31 06:15:00 | AAPL | Stock | 31.4875 | 31.4875 | 31.4875 | 31.4875 | 1000.0 |
| 2015-03-31 06:20:00 | AAPL | Stock | 31.47 | 31.47 | 31.47 | 31.47 | 1632.0 |
| 2015-03-31 06:35:00 | AAPL | Stock | 31.4625 | 31.4625 | 31.4625 | 31.4625 | 1600.0 |
| 2015-03-31 06:40:00 | AAPL | Stock | 31.4875 | 31.5 | 31.47 | 31.47 | 7200.0 |
| 2015-03-31 06:45:00 | AAPL | Stock | 31.45 | 31.4975 | 31.45 | 31.4975 | 4156.0 |
| 2015-03-31 06:55:00 | AAPL | Stock | 31.5 | 31.5 | 31.47 | 31.47 | 9828.0 |
| 2015-03-31 07:00:00 | AAPL | Stock | 31.47 | 31.47 | 31.45 | 31.45 | 18100.0 |
| 2015-03-31 07:05:00 | AAPL | Stock | 31.44 | 31.45 | 31.4275 | 31.4375 | 17556.0 |
| 2015-03-31 07:10:00 | AAPL | Stock | 31.4375 | 31.45 | 31.4375 | 31.4375 | 13616.0 |
| 2015-03-31 07:15:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 1600.0 |
| 2015-03-31 07:20:00 | AAPL | Stock | 31.475 | 31.475 | 31.475 | 31.475 | 1200.0 |
| 2015-03-31 07:25:00 | AAPL | Stock | 31.4625 | 31.475 | 31.4475 | 31.4475 | 7640.0 |
| 2015-03-31 07:35:00 | AAPL | Stock | 31.4725 | 31.475 | 31.4625 | 31.4625 | 18032.0 |
| 2015-03-31 07:40:00 | AAPL | Stock | 31.475 | 31.475 | 31.45 | 31.4575 | 50560.0 |
| 2015-03-31 07:45:00 | AAPL | Stock | 31.45 | 31.4725 | 31.4475 | 31.45 | 5200.0 |
| 2015-03-31 07:50:00 | AAPL | Stock | 31.4575 | 31.4575 | 31.445 | 31.45 | 8360.0 |
| 2015-03-31 07:55:00 | AAPL | Stock | 31.45 | 31.45 | 31.45 | 31.45 | 7416.0 |
| 2015-03-31 08:00:00 | AAPL | Stock | 31.4475 | 31.5 | 31.425 | 31.45 | 245260.0 |
| 2015-03-31 08:05:00 | AAPL | Stock | 31.445 | 31.475 | 31.445 | 31.4725 | 30196.0 |
| 2015-03-31 08:10:00 | AAPL | Stock | 31.4825 | 31.485 | 31.4475 | 31.45 | 81996.0 |
| 2015-03-31 08:15:00 | AAPL | Stock | 31.45 | 31.4625 | 31.4225 | 31.46 | 131380.0 |
| 2015-03-31 08:20:00 | AAPL | Stock | 31.4575 | 31.4675 | 31.4325 | 31.4675 | 47504.0 |
| 2015-03-31 08:25:00 | AAPL | Stock | 31.47 | 31.4775 | 31.455 | 31.4725 | 56040.0 |
| 2015-03-31 08:30:00 | AAPL | Stock | 31.465 | 31.485 | 31.465 | 31.485 | 10140.0 |
| 2015-03-31 08:35:00 | AAPL | Stock | 31.485 | 31.4975 | 31.475 | 31.4875 | 56068.0 |
| 2015-03-31 08:40:00 | AAPL | Stock | 31.4825 | 31.495 | 31.4825 | 31.4825 | 6820.0 |
| 2015-03-31 08:45:00 | AAPL | Stock | 31.4825 | 31.5175 | 31.4825 | 31.5175 | 59320.0 |
| 2015-03-31 08:50:00 | AAPL | Stock | 31.5025 | 31.55 | 31.5025 | 31.535 | 119228.0 |
| 2015-03-31 08:55:00 | AAPL | Stock | 31.53 | 31.53 | 31.51 | 31.5125 | 22180.0 |
| 2015-03-31 09:00:00 | AAPL | Stock | 31.515 | 31.515 | 31.4925 | 31.5 | 61760.0 |
| 2015-03-31 09:05:00 | AAPL | Stock | 31.5 | 31.515 | 31.4925 | 31.515 | 26752.0 |
| 2015-03-31 09:10:00 | AAPL | Stock | 31.5175 | 31.5375 | 31.5075 | 31.5375 | 55416.0 |
| 2015-03-31 09:15:00 | AAPL | Stock | 31.5275 | 31.5275 | 31.5 | 31.5028 | 61008.0 |
| 2015-03-31 09:20:00 | AAPL | Stock | 31.5075 | 31.535 | 31.5 | 31.51 | 26708.0 |
| 2015-03-31 09:25:00 | AAPL | Stock | 31.515 | 31.5325 | 31.51 | 31.5175 | 133396.0 |
| 2015-03-31 09:30:00 | AAPL | Stock | 31.5225 | 31.5925 | 31.4625 | 31.525 | 6254900.0 |
| 2015-03-31 09:35:00 | AAPL | Stock | 31.5225 | 31.6225 | 31.5125 | 31.545 | 3546600.0 |
| 2015-03-31 09:40:00 | AAPL | Stock | 31.5425 | 31.5525 | 31.3475 | 31.384 | 5707332.0 |
| 2015-03-31 09:45:00 | AAPL | Stock | 31.3825 | 31.4375 | 31.3525 | 31.395 | 3322504.0 |
| 2015-03-31 09:50:00 | AAPL | Stock | 31.3925 | 31.4075 | 31.3 | 31.4 | 4891276.0 |
| 2015-03-31 09:55:00 | AAPL | Stock | 31.4025 | 31.43 | 31.365 | 31.4125 | 1991980.0 |
| 2015-03-31 10:00:00 | AAPL | Stock | 31.4075 | 31.46 | 31.405 | 31.4075 | 2759272.0 |
| 2015-03-31 10:05:00 | AAPL | Stock | 31.4075 | 31.4225 | 31.34 | 31.415 | 2373652.0 |
| 2015-03-31 10:10:00 | AAPL | Stock | 31.415 | 31.4175 | 31.28 | 31.29 | 3187804.0 |
> showing 50 of 363,593 rows — these rows as CSV