PREVIEW / stock_5min / 2020-07-24
file: by_date/stock_5min/2020/2020-07-24.parquet size: 6.3 MB rows: 400,034 symbols: 2,425
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 |
|---|---|---|---|---|---|---|---|
| 2020-07-24 04:00:00 | AAPL | Stock | 91.5 | 91.575 | 91.25 | 91.515 | 43952.0 |
| 2020-07-24 04:05:00 | AAPL | Stock | 91.51 | 91.51 | 91.125 | 91.125 | 23824.0 |
| 2020-07-24 04:10:00 | AAPL | Stock | 91.14 | 91.375 | 91.14 | 91.375 | 17392.0 |
| 2020-07-24 04:15:00 | AAPL | Stock | 91.475 | 91.5 | 91.475 | 91.5 | 1496.0 |
| 2020-07-24 04:20:00 | AAPL | Stock | 91.4525 | 91.4525 | 91.3775 | 91.43 | 15576.0 |
| 2020-07-24 04:25:00 | AAPL | Stock | 91.425 | 91.425 | 91.3825 | 91.415 | 15012.0 |
| 2020-07-24 04:30:00 | AAPL | Stock | 91.425 | 91.4725 | 91.3875 | 91.45 | 10412.0 |
| 2020-07-24 04:35:00 | AAPL | Stock | 91.45 | 91.5775 | 91.45 | 91.5775 | 8776.0 |
| 2020-07-24 04:40:00 | AAPL | Stock | 91.5575 | 91.5575 | 91.5025 | 91.5025 | 1040.0 |
| 2020-07-24 04:50:00 | AAPL | Stock | 91.4625 | 91.5 | 91.4075 | 91.4975 | 5464.0 |
| 2020-07-24 04:55:00 | AAPL | Stock | 91.5 | 91.5 | 91.5 | 91.5 | 1600.0 |
| 2020-07-24 05:00:00 | AAPL | Stock | 91.46 | 91.46 | 91.43 | 91.43 | 1920.0 |
| 2020-07-24 05:05:00 | AAPL | Stock | 91.3875 | 91.3875 | 91.3875 | 91.3875 | 400.0 |
| 2020-07-24 05:10:00 | AAPL | Stock | 91.445 | 91.4975 | 91.445 | 91.4975 | 2136.0 |
| 2020-07-24 05:15:00 | AAPL | Stock | 91.35 | 91.35 | 91.35 | 91.35 | 600.0 |
| 2020-07-24 05:20:00 | AAPL | Stock | 91.3275 | 91.35 | 91.305 | 91.35 | 5960.0 |
| 2020-07-24 05:25:00 | AAPL | Stock | 91.3725 | 91.3875 | 91.37 | 91.3875 | 7652.0 |
| 2020-07-24 05:30:00 | AAPL | Stock | 91.3725 | 91.4725 | 91.3725 | 91.4725 | 3028.0 |
| 2020-07-24 05:35:00 | AAPL | Stock | 91.5175 | 91.55 | 91.5175 | 91.55 | 5292.0 |
| 2020-07-24 05:40:00 | AAPL | Stock | 91.505 | 91.505 | 91.505 | 91.505 | 800.0 |
| 2020-07-24 05:45:00 | AAPL | Stock | 91.5375 | 91.5375 | 91.375 | 91.375 | 11780.0 |
| 2020-07-24 05:50:00 | AAPL | Stock | 91.445 | 91.5 | 91.445 | 91.4875 | 5196.0 |
| 2020-07-24 05:55:00 | AAPL | Stock | 91.505 | 91.5625 | 91.5 | 91.5625 | 9324.0 |
| 2020-07-24 06:00:00 | AAPL | Stock | 91.5625 | 91.5625 | 91.5 | 91.5625 | 11720.0 |
| 2020-07-24 06:05:00 | AAPL | Stock | 91.625 | 91.75 | 91.5675 | 91.75 | 3372.0 |
| 2020-07-24 06:10:00 | AAPL | Stock | 91.75 | 91.8 | 91.75 | 91.79 | 3596.0 |
| 2020-07-24 06:15:00 | AAPL | Stock | 91.75 | 91.8975 | 91.75 | 91.8975 | 15336.0 |
| 2020-07-24 06:20:00 | AAPL | Stock | 91.9 | 91.9275 | 91.81 | 91.875 | 7676.0 |
| 2020-07-24 06:25:00 | AAPL | Stock | 91.875 | 91.9925 | 91.875 | 91.9625 | 13936.0 |
| 2020-07-24 06:30:00 | AAPL | Stock | 91.9625 | 91.9925 | 91.675 | 91.675 | 11596.0 |
| 2020-07-24 06:35:00 | AAPL | Stock | 91.62 | 91.62 | 91.515 | 91.5375 | 27840.0 |
| 2020-07-24 06:40:00 | AAPL | Stock | 91.555 | 91.555 | 91.54 | 91.54 | 3512.0 |
| 2020-07-24 06:45:00 | AAPL | Stock | 91.54 | 91.5525 | 91.5375 | 91.545 | 15080.0 |
| 2020-07-24 06:50:00 | AAPL | Stock | 91.6 | 91.725 | 91.5625 | 91.725 | 18996.0 |
| 2020-07-24 06:55:00 | AAPL | Stock | 91.7125 | 91.725 | 91.7075 | 91.7075 | 2296.0 |
| 2020-07-24 07:00:00 | AAPL | Stock | 91.75 | 92.0 | 91.6775 | 92.0 | 62332.0 |
| 2020-07-24 07:05:00 | AAPL | Stock | 91.975 | 91.9825 | 91.7825 | 91.9475 | 33856.0 |
| 2020-07-24 07:10:00 | AAPL | Stock | 91.9475 | 91.9475 | 91.7025 | 91.7125 | 26772.0 |
| 2020-07-24 07:15:00 | AAPL | Stock | 91.685 | 91.7875 | 91.3825 | 91.6375 | 51140.0 |
| 2020-07-24 07:20:00 | AAPL | Stock | 91.6375 | 91.6375 | 91.3825 | 91.4375 | 68216.0 |
| 2020-07-24 07:25:00 | AAPL | Stock | 91.44 | 91.5 | 91.195 | 91.195 | 110152.0 |
| 2020-07-24 07:30:00 | AAPL | Stock | 91.1575 | 91.245 | 91.125 | 91.19 | 47988.0 |
| 2020-07-24 07:35:00 | AAPL | Stock | 91.175 | 91.2075 | 91.1 | 91.125 | 46588.0 |
| 2020-07-24 07:40:00 | AAPL | Stock | 91.08 | 91.1925 | 91.0275 | 91.075 | 58820.0 |
| 2020-07-24 07:45:00 | AAPL | Stock | 91.085 | 91.1 | 90.775 | 90.88 | 74284.0 |
| 2020-07-24 07:50:00 | AAPL | Stock | 90.96 | 91.0325 | 90.775 | 91.0325 | 86900.0 |
| 2020-07-24 07:55:00 | AAPL | Stock | 91.0 | 91.255 | 91.0 | 91.22 | 21264.0 |
| 2020-07-24 08:00:00 | AAPL | Stock | 91.8125 | 92.0 | 90.85 | 91.19 | 186792.0 |
| 2020-07-24 08:05:00 | AAPL | Stock | 91.25 | 91.63 | 91.25 | 91.525 | 81008.0 |
| 2020-07-24 08:10:00 | AAPL | Stock | 91.525 | 91.7 | 91.45 | 91.6725 | 115052.0 |
> showing 50 of 400,034 rows — these rows as CSV