PREVIEW / stock_5min / 2019-12-10
file: by_date/stock_5min/2019/2019-12-10.parquet size: 5.8 MB rows: 365,781 symbols: 2,490
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-10 04:00:00 | AAPL | Stock | 66.4375 | 66.4375 | 66.3 | 66.35 | 7280.0 |
| 2019-12-10 04:15:00 | AAPL | Stock | 66.33 | 66.33 | 66.33 | 66.33 | 400.0 |
| 2019-12-10 04:25:00 | AAPL | Stock | 66.3175 | 66.3175 | 66.3175 | 66.3175 | 1200.0 |
| 2019-12-10 04:30:00 | AAPL | Stock | 66.3125 | 66.3375 | 66.3125 | 66.33 | 17244.0 |
| 2019-12-10 04:35:00 | AAPL | Stock | 66.3625 | 66.3625 | 66.2875 | 66.2875 | 2840.0 |
| 2019-12-10 04:40:00 | AAPL | Stock | 66.25 | 66.26 | 66.215 | 66.215 | 3400.0 |
| 2019-12-10 04:45:00 | AAPL | Stock | 66.235 | 66.235 | 66.1775 | 66.1775 | 1456.0 |
| 2019-12-10 04:55:00 | AAPL | Stock | 66.235 | 66.2825 | 66.235 | 66.2825 | 800.0 |
| 2019-12-10 05:00:00 | AAPL | Stock | 66.3225 | 66.35 | 66.26 | 66.35 | 7520.0 |
| 2019-12-10 05:25:00 | AAPL | Stock | 66.375 | 66.375 | 66.375 | 66.375 | 1140.0 |
| 2019-12-10 05:30:00 | AAPL | Stock | 66.3425 | 66.3425 | 66.265 | 66.265 | 5492.0 |
| 2019-12-10 05:35:00 | AAPL | Stock | 66.265 | 66.265 | 66.2625 | 66.2625 | 1600.0 |
| 2019-12-10 05:45:00 | AAPL | Stock | 66.3175 | 66.3175 | 66.3175 | 66.3175 | 400.0 |
| 2019-12-10 05:55:00 | AAPL | Stock | 66.295 | 66.295 | 66.295 | 66.295 | 400.0 |
| 2019-12-10 06:05:00 | AAPL | Stock | 66.2975 | 66.2975 | 66.2975 | 66.2975 | 400.0 |
| 2019-12-10 06:15:00 | AAPL | Stock | 66.295 | 66.3075 | 66.2575 | 66.2575 | 3760.0 |
| 2019-12-10 06:25:00 | AAPL | Stock | 66.2 | 66.2 | 66.0625 | 66.0625 | 11412.0 |
| 2019-12-10 06:30:00 | AAPL | Stock | 66.025 | 66.085 | 66.02 | 66.085 | 9680.0 |
| 2019-12-10 06:35:00 | AAPL | Stock | 66.13 | 66.1975 | 66.125 | 66.1975 | 5496.0 |
| 2019-12-10 06:45:00 | AAPL | Stock | 66.2175 | 66.27 | 66.19 | 66.27 | 6308.0 |
| 2019-12-10 06:50:00 | AAPL | Stock | 66.2625 | 66.2625 | 66.2625 | 66.2625 | 1600.0 |
| 2019-12-10 06:55:00 | AAPL | Stock | 66.2475 | 66.2475 | 66.225 | 66.225 | 1600.0 |
| 2019-12-10 07:00:00 | AAPL | Stock | 66.2475 | 66.2675 | 66.19 | 66.19 | 37872.0 |
| 2019-12-10 07:05:00 | AAPL | Stock | 66.195 | 66.195 | 66.1625 | 66.1875 | 29356.0 |
| 2019-12-10 07:10:00 | AAPL | Stock | 66.19 | 66.2 | 66.1875 | 66.2 | 4600.0 |
| 2019-12-10 07:15:00 | AAPL | Stock | 66.2 | 66.2 | 66.125 | 66.125 | 23720.0 |
| 2019-12-10 07:20:00 | AAPL | Stock | 66.16 | 66.23 | 66.16 | 66.1875 | 43224.0 |
| 2019-12-10 07:25:00 | AAPL | Stock | 66.2 | 66.2225 | 66.2 | 66.2225 | 4964.0 |
| 2019-12-10 07:30:00 | AAPL | Stock | 66.2175 | 66.2175 | 66.2 | 66.2075 | 17856.0 |
| 2019-12-10 07:35:00 | AAPL | Stock | 66.2 | 66.2175 | 66.2 | 66.2075 | 5312.0 |
| 2019-12-10 07:40:00 | AAPL | Stock | 66.2 | 66.2 | 66.1825 | 66.1825 | 1004.0 |
| 2019-12-10 07:45:00 | AAPL | Stock | 66.1825 | 66.1825 | 66.175 | 66.175 | 2800.0 |
| 2019-12-10 07:50:00 | AAPL | Stock | 66.175 | 66.175 | 66.1 | 66.1025 | 25688.0 |
| 2019-12-10 07:55:00 | AAPL | Stock | 66.125 | 66.16 | 66.125 | 66.16 | 11416.0 |
| 2019-12-10 08:00:00 | AAPL | Stock | 66.1632 | 66.25 | 66.0925 | 66.1575 | 83088.0 |
| 2019-12-10 08:05:00 | AAPL | Stock | 66.1575 | 66.1575 | 66.15 | 66.15 | 2196.0 |
| 2019-12-10 08:10:00 | AAPL | Stock | 66.1275 | 66.285 | 66.125 | 66.285 | 58272.0 |
| 2019-12-10 08:15:00 | AAPL | Stock | 66.3175 | 66.3475 | 66.2525 | 66.315 | 83840.0 |
| 2019-12-10 08:20:00 | AAPL | Stock | 66.3125 | 66.3475 | 66.278 | 66.3225 | 54040.0 |
| 2019-12-10 08:25:00 | AAPL | Stock | 66.285 | 66.45 | 66.2825 | 66.4125 | 39340.0 |
| 2019-12-10 08:30:00 | AAPL | Stock | 66.425 | 66.7875 | 66.33 | 66.75 | 192524.0 |
| 2019-12-10 08:35:00 | AAPL | Stock | 66.775 | 67.2025 | 66.675 | 67.2025 | 435788.0 |
| 2019-12-10 08:40:00 | AAPL | Stock | 67.215 | 67.31 | 67.175 | 67.2375 | 715368.0 |
| 2019-12-10 08:45:00 | AAPL | Stock | 67.2225 | 67.2425 | 67.125 | 67.165 | 265804.0 |
| 2019-12-10 08:50:00 | AAPL | Stock | 67.1312 | 67.25 | 67.1275 | 67.2025 | 161244.0 |
| 2019-12-10 08:55:00 | AAPL | Stock | 67.2 | 67.26 | 67.09 | 67.1625 | 162560.0 |
| 2019-12-10 09:00:00 | AAPL | Stock | 67.1725 | 67.2075 | 67.12 | 67.125 | 64900.0 |
| 2019-12-10 09:05:00 | AAPL | Stock | 67.1375 | 67.2 | 67.125 | 67.1525 | 109168.0 |
| 2019-12-10 09:10:00 | AAPL | Stock | 67.1525 | 67.1875 | 67.1 | 67.17 | 98004.0 |
| 2019-12-10 09:15:00 | AAPL | Stock | 67.1875 | 67.1875 | 67.115 | 67.1575 | 23588.0 |
> showing 50 of 365,781 rows — these rows as CSV