PREVIEW / stock_5min / 2019-10-30
file: by_date/stock_5min/2019/2019-10-30.parquet size: 5.7 MB rows: 361,865 symbols: 2,503
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-10-30 04:00:00 | AAPL | Stock | 60.9575 | 60.9575 | 60.7525 | 60.8525 | 11444.0 |
| 2019-10-30 04:05:00 | AAPL | Stock | 60.825 | 60.835 | 60.825 | 60.835 | 800.0 |
| 2019-10-30 04:10:00 | AAPL | Stock | 60.8275 | 60.835 | 60.8275 | 60.835 | 1200.0 |
| 2019-10-30 04:30:00 | AAPL | Stock | 60.875 | 60.875 | 60.875 | 60.875 | 400.0 |
| 2019-10-30 04:40:00 | AAPL | Stock | 60.88 | 60.88 | 60.875 | 60.875 | 2448.0 |
| 2019-10-30 04:45:00 | AAPL | Stock | 60.875 | 60.875 | 60.875 | 60.875 | 400.0 |
| 2019-10-30 04:50:00 | AAPL | Stock | 60.8725 | 60.8725 | 60.8725 | 60.8725 | 508.0 |
| 2019-10-30 05:00:00 | AAPL | Stock | 60.8725 | 60.8725 | 60.8725 | 60.8725 | 400.0 |
| 2019-10-30 05:30:00 | AAPL | Stock | 60.8675 | 60.875 | 60.8475 | 60.875 | 4240.0 |
| 2019-10-30 05:35:00 | AAPL | Stock | 60.875 | 60.875 | 60.875 | 60.875 | 2588.0 |
| 2019-10-30 05:45:00 | AAPL | Stock | 60.93 | 60.9475 | 60.93 | 60.9475 | 7228.0 |
| 2019-10-30 05:55:00 | AAPL | Stock | 60.9575 | 60.9575 | 60.9575 | 60.9575 | 1008.0 |
| 2019-10-30 06:10:00 | AAPL | Stock | 60.95 | 60.95 | 60.95 | 60.95 | 400.0 |
| 2019-10-30 06:25:00 | AAPL | Stock | 61.0 | 61.0 | 61.0 | 61.0 | 400.0 |
| 2019-10-30 06:30:00 | AAPL | Stock | 61.03 | 61.03 | 61.03 | 61.03 | 400.0 |
| 2019-10-30 06:40:00 | AAPL | Stock | 61.04 | 61.04 | 61.0375 | 61.0375 | 1200.0 |
| 2019-10-30 06:45:00 | AAPL | Stock | 61.005 | 61.005 | 61.0 | 61.0 | 6400.0 |
| 2019-10-30 06:55:00 | AAPL | Stock | 61.0 | 61.0 | 61.0 | 61.0 | 1684.0 |
| 2019-10-30 07:00:00 | AAPL | Stock | 60.975 | 61.0 | 60.975 | 60.9875 | 33956.0 |
| 2019-10-30 07:05:00 | AAPL | Stock | 60.995 | 60.995 | 60.995 | 60.995 | 1880.0 |
| 2019-10-30 07:10:00 | AAPL | Stock | 61.0 | 61.0 | 61.0 | 61.0 | 3200.0 |
| 2019-10-30 07:20:00 | AAPL | Stock | 60.9825 | 61.0 | 60.9825 | 61.0 | 9552.0 |
| 2019-10-30 07:25:00 | AAPL | Stock | 61.0125 | 61.0125 | 61.0125 | 61.0125 | 612.0 |
| 2019-10-30 07:30:00 | AAPL | Stock | 61.0375 | 61.0625 | 61.0 | 61.0125 | 11152.0 |
| 2019-10-30 07:35:00 | AAPL | Stock | 61.05 | 61.07 | 61.05 | 61.0625 | 9460.0 |
| 2019-10-30 07:40:00 | AAPL | Stock | 61.0725 | 61.1725 | 61.0725 | 61.1675 | 87444.0 |
| 2019-10-30 07:45:00 | AAPL | Stock | 61.1725 | 61.25 | 61.17 | 61.23 | 33188.0 |
| 2019-10-30 07:50:00 | AAPL | Stock | 61.23 | 61.23 | 61.175 | 61.2 | 23920.0 |
| 2019-10-30 07:55:00 | AAPL | Stock | 61.2075 | 61.2125 | 61.195 | 61.2125 | 13400.0 |
| 2019-10-30 08:00:00 | AAPL | Stock | 61.0 | 61.245 | 60.9725 | 61.1875 | 106964.0 |
| 2019-10-30 08:05:00 | AAPL | Stock | 61.185 | 61.2225 | 61.175 | 61.1875 | 24584.0 |
| 2019-10-30 08:10:00 | AAPL | Stock | 61.205 | 61.2175 | 61.1625 | 61.1875 | 26632.0 |
| 2019-10-30 08:15:00 | AAPL | Stock | 61.21 | 61.2125 | 61.1625 | 61.1625 | 14320.0 |
| 2019-10-30 08:20:00 | AAPL | Stock | 61.1625 | 61.2025 | 61.15 | 61.2025 | 21444.0 |
| 2019-10-30 08:25:00 | AAPL | Stock | 61.2 | 61.21 | 61.2 | 61.2 | 4452.0 |
| 2019-10-30 08:30:00 | AAPL | Stock | 61.2225 | 61.25 | 61.1875 | 61.2475 | 25588.0 |
| 2019-10-30 08:35:00 | AAPL | Stock | 61.25 | 61.2725 | 61.22 | 61.2575 | 49248.0 |
| 2019-10-30 08:40:00 | AAPL | Stock | 61.265 | 61.3075 | 61.2525 | 61.3025 | 25328.0 |
| 2019-10-30 08:45:00 | AAPL | Stock | 61.2825 | 61.3125 | 61.25 | 61.3122 | 71416.0 |
| 2019-10-30 08:50:00 | AAPL | Stock | 61.3 | 61.3125 | 61.29 | 61.3125 | 33604.0 |
| 2019-10-30 08:55:00 | AAPL | Stock | 61.3125 | 61.3425 | 61.305 | 61.32 | 60104.0 |
| 2019-10-30 09:00:00 | AAPL | Stock | 61.325 | 61.36 | 61.305 | 61.36 | 51424.0 |
| 2019-10-30 09:05:00 | AAPL | Stock | 61.37 | 61.3975 | 61.37 | 61.3925 | 50096.0 |
| 2019-10-30 09:10:00 | AAPL | Stock | 61.3925 | 61.3975 | 61.3525 | 61.3525 | 42556.0 |
| 2019-10-30 09:15:00 | AAPL | Stock | 61.335 | 61.3675 | 61.3175 | 61.3615 | 97088.0 |
| 2019-10-30 09:20:00 | AAPL | Stock | 61.3575 | 61.375 | 61.3475 | 61.3525 | 40284.0 |
| 2019-10-30 09:25:00 | AAPL | Stock | 61.3675 | 61.39 | 61.1425 | 61.2375 | 158632.0 |
| 2019-10-30 09:30:00 | AAPL | Stock | 61.1925 | 61.325 | 61.09 | 61.1092 | 4460980.0 |
| 2019-10-30 09:35:00 | AAPL | Stock | 61.1025 | 61.1025 | 60.7325 | 60.8275 | 3398396.0 |
| 2019-10-30 09:40:00 | AAPL | Stock | 60.83 | 60.83 | 60.5775 | 60.6625 | 2410020.0 |
> showing 50 of 361,865 rows — these rows as CSV