PREVIEW / stock_5min / 2015-05-01
file: by_date/stock_5min/2015/2015-05-01.parquet size: 5.4 MB rows: 363,245 symbols: 3,516
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-05-01 05:25:00 | AAPL | Stock | 31.3025 | 31.3025 | 31.2625 | 31.2625 | 1600.0 |
| 2015-05-01 05:35:00 | AAPL | Stock | 31.3875 | 31.3875 | 31.3875 | 31.3875 | 400.0 |
| 2015-05-01 05:50:00 | AAPL | Stock | 31.3875 | 31.3875 | 31.3875 | 31.3875 | 2000.0 |
| 2015-05-01 06:00:00 | AAPL | Stock | 31.3925 | 31.43 | 31.3875 | 31.425 | 7436.0 |
| 2015-05-01 06:05:00 | AAPL | Stock | 31.43 | 31.43 | 31.43 | 31.43 | 2000.0 |
| 2015-05-01 06:10:00 | AAPL | Stock | 31.4225 | 31.4225 | 31.42 | 31.42 | 2120.0 |
| 2015-05-01 06:15:00 | AAPL | Stock | 31.4175 | 31.4175 | 31.4175 | 31.4175 | 400.0 |
| 2015-05-01 06:25:00 | AAPL | Stock | 31.4175 | 31.4175 | 31.4175 | 31.4175 | 3160.0 |
| 2015-05-01 06:30:00 | AAPL | Stock | 31.425 | 31.425 | 31.3775 | 31.3775 | 23840.0 |
| 2015-05-01 06:35:00 | AAPL | Stock | 31.3875 | 31.3875 | 31.3875 | 31.3875 | 800.0 |
| 2015-05-01 06:40:00 | AAPL | Stock | 31.3875 | 31.3875 | 31.305 | 31.305 | 15600.0 |
| 2015-05-01 06:45:00 | AAPL | Stock | 31.3275 | 31.39 | 31.3275 | 31.39 | 11244.0 |
| 2015-05-01 06:50:00 | AAPL | Stock | 31.39 | 31.39 | 31.39 | 31.39 | 6000.0 |
| 2015-05-01 06:55:00 | AAPL | Stock | 31.3925 | 31.3925 | 31.3925 | 31.3925 | 3200.0 |
| 2015-05-01 07:00:00 | AAPL | Stock | 31.3975 | 31.4025 | 31.375 | 31.4025 | 43044.0 |
| 2015-05-01 07:05:00 | AAPL | Stock | 31.425 | 31.4675 | 31.425 | 31.4375 | 37340.0 |
| 2015-05-01 07:10:00 | AAPL | Stock | 31.45 | 31.475 | 31.4375 | 31.4625 | 30320.0 |
| 2015-05-01 07:15:00 | AAPL | Stock | 31.4625 | 31.5375 | 31.4625 | 31.525 | 57256.0 |
| 2015-05-01 07:20:00 | AAPL | Stock | 31.5275 | 31.545 | 31.5075 | 31.5075 | 7156.0 |
| 2015-05-01 07:25:00 | AAPL | Stock | 31.5075 | 31.54 | 31.5 | 31.54 | 23208.0 |
| 2015-05-01 07:30:00 | AAPL | Stock | 31.5325 | 31.56 | 31.5275 | 31.55 | 55200.0 |
| 2015-05-01 07:35:00 | AAPL | Stock | 31.5425 | 31.55 | 31.525 | 31.5375 | 21940.0 |
| 2015-05-01 07:40:00 | AAPL | Stock | 31.53 | 31.53 | 31.5 | 31.5 | 48916.0 |
| 2015-05-01 07:45:00 | AAPL | Stock | 31.5 | 31.5125 | 31.5 | 31.5125 | 26380.0 |
| 2015-05-01 07:50:00 | AAPL | Stock | 31.5025 | 31.5025 | 31.4875 | 31.4875 | 15508.0 |
| 2015-05-01 07:55:00 | AAPL | Stock | 31.495 | 31.5 | 31.475 | 31.475 | 24188.0 |
| 2015-05-01 08:00:00 | AAPL | Stock | 31.4925 | 31.56 | 31.375 | 31.4525 | 254456.0 |
| 2015-05-01 08:05:00 | AAPL | Stock | 31.4725 | 31.4975 | 31.465 | 31.4825 | 96760.0 |
| 2015-05-01 08:10:00 | AAPL | Stock | 31.4825 | 31.4875 | 31.475 | 31.4875 | 70216.0 |
| 2015-05-01 08:15:00 | AAPL | Stock | 31.4775 | 31.4975 | 31.4725 | 31.4725 | 80488.0 |
| 2015-05-01 08:20:00 | AAPL | Stock | 31.4775 | 31.485 | 31.4625 | 31.48 | 86860.0 |
| 2015-05-01 08:25:00 | AAPL | Stock | 31.48 | 31.485 | 31.47 | 31.4725 | 23716.0 |
| 2015-05-01 08:30:00 | AAPL | Stock | 31.47 | 31.4775 | 31.4625 | 31.47 | 28804.0 |
| 2015-05-01 08:35:00 | AAPL | Stock | 31.4725 | 31.475 | 31.4625 | 31.4675 | 44680.0 |
| 2015-05-01 08:40:00 | AAPL | Stock | 31.4675 | 31.47 | 31.45 | 31.45 | 63240.0 |
| 2015-05-01 08:45:00 | AAPL | Stock | 31.445 | 31.46 | 31.445 | 31.46 | 35380.0 |
| 2015-05-01 08:50:00 | AAPL | Stock | 31.46 | 31.475 | 31.45 | 31.475 | 31016.0 |
| 2015-05-01 08:55:00 | AAPL | Stock | 31.475 | 31.475 | 31.445 | 31.4575 | 52400.0 |
| 2015-05-01 09:00:00 | AAPL | Stock | 31.4575 | 31.475 | 31.45 | 31.475 | 96596.0 |
| 2015-05-01 09:05:00 | AAPL | Stock | 31.4825 | 31.4975 | 31.4825 | 31.495 | 91076.0 |
| 2015-05-01 09:10:00 | AAPL | Stock | 31.495 | 31.5125 | 31.4875 | 31.495 | 180512.0 |
| 2015-05-01 09:15:00 | AAPL | Stock | 31.4925 | 31.5 | 31.4775 | 31.4925 | 147388.0 |
| 2015-05-01 09:20:00 | AAPL | Stock | 31.4928 | 31.5175 | 31.4928 | 31.5175 | 110356.0 |
| 2015-05-01 09:25:00 | AAPL | Stock | 31.5125 | 31.56 | 31.5075 | 31.5225 | 186288.0 |
| 2015-05-01 09:30:00 | AAPL | Stock | 31.5225 | 31.6125 | 31.445 | 31.4632 | 10314480.0 |
| 2015-05-01 09:35:00 | AAPL | Stock | 31.4625 | 31.485 | 31.325 | 31.4695 | 6857060.0 |
| 2015-05-01 09:40:00 | AAPL | Stock | 31.465 | 31.5725 | 31.4375 | 31.55 | 4747704.0 |
| 2015-05-01 09:45:00 | AAPL | Stock | 31.5525 | 31.6325 | 31.5275 | 31.55 | 6231028.0 |
| 2015-05-01 09:50:00 | AAPL | Stock | 31.55 | 31.6075 | 31.5175 | 31.57 | 3530528.0 |
| 2015-05-01 09:55:00 | AAPL | Stock | 31.57 | 31.5725 | 31.49 | 31.5375 | 3346700.0 |
> showing 50 of 363,245 rows — these rows as CSV