PREVIEW / stock_5min / 2019-12-13
file: by_date/stock_5min/2019/2019-12-13.parquet size: 5.9 MB rows: 368,414 symbols: 2,500
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-12-13 04:00:00 | AAPL | Stock | 68.285 | 68.4575 | 68.2525 | 68.425 | 5400.0 |
| 2019-12-13 04:05:00 | AAPL | Stock | 68.3025 | 68.3025 | 68.3025 | 68.3025 | 400.0 |
| 2019-12-13 04:10:00 | AAPL | Stock | 68.3175 | 68.3175 | 68.3175 | 68.3175 | 400.0 |
| 2019-12-13 04:15:00 | AAPL | Stock | 68.295 | 68.295 | 68.295 | 68.295 | 400.0 |
| 2019-12-13 04:20:00 | AAPL | Stock | 68.345 | 68.345 | 68.345 | 68.345 | 1932.0 |
| 2019-12-13 04:25:00 | AAPL | Stock | 68.3525 | 68.3525 | 68.35 | 68.35 | 2216.0 |
| 2019-12-13 04:30:00 | AAPL | Stock | 68.3525 | 68.3525 | 68.3525 | 68.3525 | 532.0 |
| 2019-12-13 04:35:00 | AAPL | Stock | 68.325 | 68.325 | 68.325 | 68.325 | 1600.0 |
| 2019-12-13 04:45:00 | AAPL | Stock | 68.4 | 68.4 | 68.375 | 68.375 | 3652.0 |
| 2019-12-13 04:50:00 | AAPL | Stock | 68.335 | 68.335 | 68.325 | 68.325 | 1868.0 |
| 2019-12-13 05:00:00 | AAPL | Stock | 68.33 | 68.33 | 68.33 | 68.33 | 400.0 |
| 2019-12-13 05:05:00 | AAPL | Stock | 68.35 | 68.35 | 68.35 | 68.35 | 1940.0 |
| 2019-12-13 05:10:00 | AAPL | Stock | 68.35 | 68.35 | 68.35 | 68.35 | 1200.0 |
| 2019-12-13 05:20:00 | AAPL | Stock | 68.35 | 68.35 | 68.35 | 68.35 | 2400.0 |
| 2019-12-13 05:25:00 | AAPL | Stock | 68.35 | 68.3875 | 68.35 | 68.3875 | 7800.0 |
| 2019-12-13 05:40:00 | AAPL | Stock | 68.3825 | 68.3825 | 68.3825 | 68.3825 | 784.0 |
| 2019-12-13 05:45:00 | AAPL | Stock | 68.365 | 68.365 | 68.365 | 68.365 | 1200.0 |
| 2019-12-13 05:50:00 | AAPL | Stock | 68.4 | 68.4 | 68.4 | 68.4 | 1108.0 |
| 2019-12-13 05:55:00 | AAPL | Stock | 68.3875 | 68.3875 | 68.3875 | 68.3875 | 1996.0 |
| 2019-12-13 06:00:00 | AAPL | Stock | 68.385 | 68.385 | 68.3625 | 68.3625 | 3008.0 |
| 2019-12-13 06:10:00 | AAPL | Stock | 68.3725 | 68.3725 | 68.3725 | 68.3725 | 2108.0 |
| 2019-12-13 06:15:00 | AAPL | Stock | 68.3275 | 68.3275 | 68.31 | 68.31 | 3220.0 |
| 2019-12-13 06:20:00 | AAPL | Stock | 68.325 | 68.33 | 68.325 | 68.33 | 1292.0 |
| 2019-12-13 06:25:00 | AAPL | Stock | 68.28 | 68.28 | 68.275 | 68.28 | 15840.0 |
| 2019-12-13 06:30:00 | AAPL | Stock | 68.2875 | 68.2875 | 68.2575 | 68.2575 | 4388.0 |
| 2019-12-13 06:35:00 | AAPL | Stock | 68.275 | 68.275 | 68.275 | 68.275 | 800.0 |
| 2019-12-13 06:40:00 | AAPL | Stock | 68.2125 | 68.2375 | 68.15 | 68.2375 | 3816.0 |
| 2019-12-13 06:45:00 | AAPL | Stock | 68.205 | 68.205 | 68.1875 | 68.1875 | 6440.0 |
| 2019-12-13 06:50:00 | AAPL | Stock | 68.2 | 68.2 | 68.19 | 68.19 | 1944.0 |
| 2019-12-13 06:55:00 | AAPL | Stock | 68.1875 | 68.195 | 68.1875 | 68.195 | 4320.0 |
| 2019-12-13 07:00:00 | AAPL | Stock | 68.2375 | 68.2975 | 68.15 | 68.185 | 40720.0 |
| 2019-12-13 07:05:00 | AAPL | Stock | 68.2125 | 68.2125 | 68.18 | 68.18 | 4720.0 |
| 2019-12-13 07:10:00 | AAPL | Stock | 68.1875 | 68.2125 | 68.175 | 68.2075 | 12180.0 |
| 2019-12-13 07:15:00 | AAPL | Stock | 68.1875 | 68.2 | 68.15 | 68.2 | 28568.0 |
| 2019-12-13 07:20:00 | AAPL | Stock | 68.2 | 68.2125 | 68.1375 | 68.1375 | 21376.0 |
| 2019-12-13 07:25:00 | AAPL | Stock | 68.175 | 68.175 | 68.1625 | 68.1625 | 2800.0 |
| 2019-12-13 07:30:00 | AAPL | Stock | 68.1625 | 68.1875 | 68.15 | 68.175 | 10328.0 |
| 2019-12-13 07:35:00 | AAPL | Stock | 68.185 | 68.185 | 68.1375 | 68.1625 | 35200.0 |
| 2019-12-13 07:40:00 | AAPL | Stock | 68.185 | 68.25 | 68.175 | 68.175 | 48432.0 |
| 2019-12-13 07:45:00 | AAPL | Stock | 68.175 | 68.1875 | 68.175 | 68.1875 | 1812.0 |
| 2019-12-13 07:50:00 | AAPL | Stock | 68.1875 | 68.1875 | 68.13 | 68.13 | 8184.0 |
| 2019-12-13 07:55:00 | AAPL | Stock | 68.125 | 68.125 | 67.675 | 67.875 | 100052.0 |
| 2019-12-13 08:00:00 | AAPL | Stock | 67.9475 | 68.2975 | 67.7475 | 68.075 | 187884.0 |
| 2019-12-13 08:05:00 | AAPL | Stock | 68.0975 | 68.1 | 68.03 | 68.075 | 65304.0 |
| 2019-12-13 08:10:00 | AAPL | Stock | 68.0775 | 68.125 | 68.0775 | 68.1102 | 40200.0 |
| 2019-12-13 08:15:00 | AAPL | Stock | 68.125 | 68.165 | 68.125 | 68.1325 | 37588.0 |
| 2019-12-13 08:20:00 | AAPL | Stock | 68.1325 | 68.1475 | 68.11 | 68.1325 | 6004.0 |
| 2019-12-13 08:25:00 | AAPL | Stock | 68.1325 | 68.15 | 68.09 | 68.1475 | 31884.0 |
| 2019-12-13 08:30:00 | AAPL | Stock | 68.1275 | 68.185 | 68.1125 | 68.1725 | 37400.0 |
| 2019-12-13 08:35:00 | AAPL | Stock | 68.1625 | 68.25 | 68.1625 | 68.2375 | 94636.0 |
> showing 50 of 368,414 rows — these rows as CSV