PREVIEW / stock_5min / 2019-04-10
file: by_date/stock_5min/2019/2019-04-10.parquet size: 5.6 MB rows: 355,394 symbols: 2,629
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 |
|---|---|---|---|---|---|---|---|
| 2019-04-10 04:00:00 | AAPL | Stock | 49.4475 | 49.45 | 49.3775 | 49.3775 | 34136.0 |
| 2019-04-10 04:05:00 | AAPL | Stock | 49.4 | 49.4 | 49.325 | 49.325 | 2000.0 |
| 2019-04-10 04:10:00 | AAPL | Stock | 49.3625 | 49.3625 | 49.2975 | 49.2975 | 2776.0 |
| 2019-04-10 04:15:00 | AAPL | Stock | 49.2975 | 49.4125 | 49.2975 | 49.4125 | 6180.0 |
| 2019-04-10 04:20:00 | AAPL | Stock | 49.37 | 49.37 | 49.325 | 49.335 | 4800.0 |
| 2019-04-10 04:25:00 | AAPL | Stock | 49.3 | 49.32 | 49.295 | 49.32 | 12524.0 |
| 2019-04-10 04:30:00 | AAPL | Stock | 49.3375 | 49.3375 | 49.3375 | 49.3375 | 400.0 |
| 2019-04-10 04:35:00 | AAPL | Stock | 49.3725 | 49.4 | 49.3725 | 49.4 | 7192.0 |
| 2019-04-10 04:40:00 | AAPL | Stock | 49.4025 | 49.45 | 49.4025 | 49.45 | 8924.0 |
| 2019-04-10 04:45:00 | AAPL | Stock | 49.445 | 49.4575 | 49.435 | 49.435 | 11324.0 |
| 2019-04-10 05:05:00 | AAPL | Stock | 49.3775 | 49.3775 | 49.375 | 49.375 | 11036.0 |
| 2019-04-10 05:10:00 | AAPL | Stock | 49.415 | 49.42 | 49.415 | 49.42 | 13568.0 |
| 2019-04-10 05:20:00 | AAPL | Stock | 49.425 | 49.425 | 49.425 | 49.425 | 800.0 |
| 2019-04-10 05:30:00 | AAPL | Stock | 49.425 | 49.45 | 49.425 | 49.45 | 11532.0 |
| 2019-04-10 05:35:00 | AAPL | Stock | 49.4625 | 49.4625 | 49.445 | 49.445 | 8256.0 |
| 2019-04-10 05:50:00 | AAPL | Stock | 49.465 | 49.475 | 49.465 | 49.465 | 7012.0 |
| 2019-04-10 05:55:00 | AAPL | Stock | 49.475 | 49.475 | 49.47 | 49.47 | 6100.0 |
| 2019-04-10 06:00:00 | AAPL | Stock | 49.475 | 49.5 | 49.47 | 49.47 | 46820.0 |
| 2019-04-10 06:05:00 | AAPL | Stock | 49.4825 | 49.5 | 49.4825 | 49.5 | 8000.0 |
| 2019-04-10 06:10:00 | AAPL | Stock | 49.4875 | 49.5475 | 49.4875 | 49.5325 | 13684.0 |
| 2019-04-10 06:15:00 | AAPL | Stock | 49.5325 | 49.5425 | 49.5025 | 49.5025 | 2700.0 |
| 2019-04-10 06:20:00 | AAPL | Stock | 49.5075 | 49.5075 | 49.5075 | 49.5075 | 1264.0 |
| 2019-04-10 06:25:00 | AAPL | Stock | 49.4875 | 49.4875 | 49.475 | 49.485 | 5400.0 |
| 2019-04-10 06:30:00 | AAPL | Stock | 49.475 | 49.475 | 49.4 | 49.4 | 24488.0 |
| 2019-04-10 06:35:00 | AAPL | Stock | 49.45 | 49.45 | 49.4275 | 49.4275 | 1400.0 |
| 2019-04-10 06:40:00 | AAPL | Stock | 49.47 | 49.475 | 49.4 | 49.4 | 17756.0 |
| 2019-04-10 06:45:00 | AAPL | Stock | 49.375 | 49.4725 | 49.35 | 49.4725 | 21528.0 |
| 2019-04-10 06:50:00 | AAPL | Stock | 49.45 | 49.45 | 49.45 | 49.45 | 400.0 |
| 2019-04-10 06:55:00 | AAPL | Stock | 49.45 | 49.45 | 49.45 | 49.45 | 1200.0 |
| 2019-04-10 07:00:00 | AAPL | Stock | 49.4675 | 49.54 | 49.38 | 49.5225 | 145220.0 |
| 2019-04-10 07:05:00 | AAPL | Stock | 49.5375 | 49.585 | 49.5375 | 49.5625 | 31384.0 |
| 2019-04-10 07:10:00 | AAPL | Stock | 49.5625 | 49.5625 | 49.54 | 49.5525 | 29964.0 |
| 2019-04-10 07:15:00 | AAPL | Stock | 49.5425 | 49.5625 | 49.505 | 49.5075 | 24980.0 |
| 2019-04-10 07:20:00 | AAPL | Stock | 49.525 | 49.665 | 49.525 | 49.6475 | 35784.0 |
| 2019-04-10 07:25:00 | AAPL | Stock | 49.65 | 49.72 | 49.65 | 49.655 | 71420.0 |
| 2019-04-10 07:30:00 | AAPL | Stock | 49.685 | 49.71 | 49.675 | 49.675 | 30332.0 |
| 2019-04-10 07:35:00 | AAPL | Stock | 49.6975 | 49.8 | 49.6975 | 49.74 | 88752.0 |
| 2019-04-10 07:40:00 | AAPL | Stock | 49.73 | 49.73 | 49.7 | 49.715 | 25808.0 |
| 2019-04-10 07:45:00 | AAPL | Stock | 49.705 | 49.81 | 49.705 | 49.775 | 43560.0 |
| 2019-04-10 07:50:00 | AAPL | Stock | 49.7925 | 49.8 | 49.71 | 49.71 | 73556.0 |
| 2019-04-10 07:55:00 | AAPL | Stock | 49.7325 | 49.74 | 49.675 | 49.6925 | 74368.0 |
| 2019-04-10 08:00:00 | AAPL | Stock | 49.55 | 49.75 | 49.4 | 49.745 | 141632.0 |
| 2019-04-10 08:05:00 | AAPL | Stock | 49.7375 | 49.7425 | 49.675 | 49.7025 | 60768.0 |
| 2019-04-10 08:10:00 | AAPL | Stock | 49.695 | 49.7125 | 49.6625 | 49.7125 | 48168.0 |
| 2019-04-10 08:15:00 | AAPL | Stock | 49.6625 | 49.685 | 49.645 | 49.6525 | 52376.0 |
| 2019-04-10 08:20:00 | AAPL | Stock | 49.6725 | 49.7375 | 49.65 | 49.6875 | 47212.0 |
| 2019-04-10 08:25:00 | AAPL | Stock | 49.6925 | 49.7125 | 49.6575 | 49.7125 | 17152.0 |
| 2019-04-10 08:30:00 | AAPL | Stock | 49.7225 | 49.8625 | 49.6775 | 49.7125 | 77704.0 |
| 2019-04-10 08:35:00 | AAPL | Stock | 49.7475 | 49.755 | 49.62 | 49.6575 | 58716.0 |
| 2019-04-10 08:40:00 | AAPL | Stock | 49.635 | 49.675 | 49.62 | 49.625 | 36968.0 |
> showing 50 of 355,394 rows — these rows as CSV