PREVIEW / stock_5min / 2019-09-06
file: by_date/stock_5min/2019/2019-09-06.parquet size: 5.5 MB rows: 349,719 symbols: 2,555
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-09-06 04:10:00 | AAPL | Stock | 53.3025 | 53.3025 | 53.3025 | 53.3025 | 772.0 |
| 2019-09-06 04:25:00 | AAPL | Stock | 53.285 | 53.2875 | 53.285 | 53.2875 | 800.0 |
| 2019-09-06 04:45:00 | AAPL | Stock | 53.3375 | 53.3375 | 53.3375 | 53.3375 | 8000.0 |
| 2019-09-06 04:50:00 | AAPL | Stock | 53.3375 | 53.3375 | 53.3375 | 53.3375 | 740.0 |
| 2019-09-06 05:05:00 | AAPL | Stock | 53.315 | 53.315 | 53.315 | 53.315 | 400.0 |
| 2019-09-06 05:10:00 | AAPL | Stock | 53.35 | 53.3775 | 53.35 | 53.3575 | 2400.0 |
| 2019-09-06 05:15:00 | AAPL | Stock | 53.41 | 53.4625 | 53.41 | 53.4625 | 3004.0 |
| 2019-09-06 05:20:00 | AAPL | Stock | 53.4625 | 53.4975 | 53.3775 | 53.4975 | 12540.0 |
| 2019-09-06 05:30:00 | AAPL | Stock | 53.46 | 53.46 | 53.345 | 53.345 | 1600.0 |
| 2019-09-06 05:35:00 | AAPL | Stock | 53.49 | 53.5175 | 53.49 | 53.5075 | 10460.0 |
| 2019-09-06 05:40:00 | AAPL | Stock | 53.465 | 53.465 | 53.4325 | 53.4325 | 1136.0 |
| 2019-09-06 05:45:00 | AAPL | Stock | 53.4125 | 53.4125 | 53.4125 | 53.4125 | 400.0 |
| 2019-09-06 06:00:00 | AAPL | Stock | 53.2525 | 53.2675 | 53.2275 | 53.23 | 2400.0 |
| 2019-09-06 06:05:00 | AAPL | Stock | 53.35 | 53.35 | 53.3225 | 53.325 | 3600.0 |
| 2019-09-06 06:10:00 | AAPL | Stock | 53.3125 | 53.315 | 53.3125 | 53.315 | 1200.0 |
| 2019-09-06 06:15:00 | AAPL | Stock | 53.325 | 53.325 | 53.325 | 53.325 | 4120.0 |
| 2019-09-06 06:20:00 | AAPL | Stock | 53.325 | 53.325 | 53.325 | 53.325 | 1600.0 |
| 2019-09-06 06:40:00 | AAPL | Stock | 53.335 | 53.335 | 53.335 | 53.335 | 7708.0 |
| 2019-09-06 06:55:00 | AAPL | Stock | 53.3675 | 53.3675 | 53.3675 | 53.3675 | 2000.0 |
| 2019-09-06 07:00:00 | AAPL | Stock | 53.4425 | 53.4425 | 53.335 | 53.3875 | 35028.0 |
| 2019-09-06 07:05:00 | AAPL | Stock | 53.3825 | 53.3825 | 53.38 | 53.38 | 1732.0 |
| 2019-09-06 07:10:00 | AAPL | Stock | 53.375 | 53.375 | 53.325 | 53.3625 | 36888.0 |
| 2019-09-06 07:15:00 | AAPL | Stock | 53.355 | 53.36 | 53.3375 | 53.36 | 3668.0 |
| 2019-09-06 07:20:00 | AAPL | Stock | 53.405 | 53.4375 | 53.405 | 53.4325 | 6060.0 |
| 2019-09-06 07:25:00 | AAPL | Stock | 53.4075 | 53.425 | 53.4075 | 53.425 | 1276.0 |
| 2019-09-06 07:30:00 | AAPL | Stock | 53.3925 | 53.4625 | 53.3875 | 53.4625 | 10452.0 |
| 2019-09-06 07:35:00 | AAPL | Stock | 53.4525 | 53.455 | 53.445 | 53.445 | 1812.0 |
| 2019-09-06 07:45:00 | AAPL | Stock | 53.445 | 53.465 | 53.4425 | 53.4525 | 24632.0 |
| 2019-09-06 07:50:00 | AAPL | Stock | 53.4625 | 53.47 | 53.45 | 53.47 | 19880.0 |
| 2019-09-06 07:55:00 | AAPL | Stock | 53.47 | 53.4725 | 53.45 | 53.47 | 19904.0 |
| 2019-09-06 08:00:00 | AAPL | Stock | 53.3502 | 53.4975 | 53.35 | 53.45 | 84604.0 |
| 2019-09-06 08:05:00 | AAPL | Stock | 53.4575 | 53.4575 | 53.4275 | 53.4275 | 22160.0 |
| 2019-09-06 08:10:00 | AAPL | Stock | 53.4475 | 53.4875 | 53.43 | 53.4675 | 29332.0 |
| 2019-09-06 08:15:00 | AAPL | Stock | 53.4525 | 53.4625 | 53.43 | 53.4325 | 9800.0 |
| 2019-09-06 08:20:00 | AAPL | Stock | 53.43 | 53.43 | 53.4025 | 53.4025 | 9708.0 |
| 2019-09-06 08:25:00 | AAPL | Stock | 53.4275 | 53.45 | 53.3925 | 53.4275 | 12120.0 |
| 2019-09-06 08:30:00 | AAPL | Stock | 53.4275 | 53.4375 | 53.2675 | 53.43 | 67444.0 |
| 2019-09-06 08:35:00 | AAPL | Stock | 53.4025 | 53.4375 | 53.3875 | 53.4375 | 5072.0 |
| 2019-09-06 08:40:00 | AAPL | Stock | 53.4375 | 53.5675 | 53.4325 | 53.5475 | 71876.0 |
| 2019-09-06 08:45:00 | AAPL | Stock | 53.5 | 53.5225 | 53.445 | 53.4575 | 21332.0 |
| 2019-09-06 08:50:00 | AAPL | Stock | 53.4575 | 53.4975 | 53.4475 | 53.4675 | 18364.0 |
| 2019-09-06 08:55:00 | AAPL | Stock | 53.425 | 53.445 | 53.375 | 53.4125 | 26408.0 |
| 2019-09-06 09:00:00 | AAPL | Stock | 53.415 | 53.4675 | 53.395 | 53.4025 | 12256.0 |
| 2019-09-06 09:05:00 | AAPL | Stock | 53.4275 | 53.4575 | 53.4025 | 53.45 | 21004.0 |
| 2019-09-06 09:10:00 | AAPL | Stock | 53.44 | 53.475 | 53.43 | 53.475 | 21860.0 |
| 2019-09-06 09:15:00 | AAPL | Stock | 53.4425 | 53.45 | 53.425 | 53.4275 | 18712.0 |
| 2019-09-06 09:20:00 | AAPL | Stock | 53.4325 | 53.44 | 53.4125 | 53.4125 | 17452.0 |
| 2019-09-06 09:25:00 | AAPL | Stock | 53.4125 | 53.55 | 53.4125 | 53.495 | 52164.0 |
| 2019-09-06 09:30:00 | AAPL | Stock | 53.495 | 53.605 | 53.4275 | 53.4625 | 3967756.0 |
| 2019-09-06 09:35:00 | AAPL | Stock | 53.46 | 53.4625 | 53.26 | 53.3825 | 1788904.0 |
> showing 50 of 349,719 rows — these rows as CSV