PREVIEW / stock_5min / 2019-03-07
file: by_date/stock_5min/2019/2019-03-07.parquet size: 5.7 MB rows: 363,728 symbols: 2,656
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-03-07 04:00:00 | AAPL | Stock | 43.5 | 43.5 | 43.475 | 43.475 | 4432.0 |
| 2019-03-07 04:25:00 | AAPL | Stock | 43.485 | 43.485 | 43.485 | 43.485 | 400.0 |
| 2019-03-07 05:05:00 | AAPL | Stock | 43.44 | 43.44 | 43.44 | 43.44 | 400.0 |
| 2019-03-07 06:05:00 | AAPL | Stock | 43.47 | 43.47 | 43.47 | 43.47 | 800.0 |
| 2019-03-07 06:45:00 | AAPL | Stock | 43.4775 | 43.4775 | 43.4775 | 43.4775 | 1200.0 |
| 2019-03-07 07:00:00 | AAPL | Stock | 43.4875 | 43.4925 | 43.45 | 43.475 | 11040.0 |
| 2019-03-07 07:05:00 | AAPL | Stock | 43.4775 | 43.5 | 43.4775 | 43.5 | 9828.0 |
| 2019-03-07 07:10:00 | AAPL | Stock | 43.5375 | 43.545 | 43.5275 | 43.5275 | 5060.0 |
| 2019-03-07 07:15:00 | AAPL | Stock | 43.5275 | 43.5275 | 43.525 | 43.525 | 5340.0 |
| 2019-03-07 07:20:00 | AAPL | Stock | 43.5175 | 43.5175 | 43.5175 | 43.5175 | 3828.0 |
| 2019-03-07 07:25:00 | AAPL | Stock | 43.5375 | 43.5425 | 43.5375 | 43.5425 | 3200.0 |
| 2019-03-07 07:40:00 | AAPL | Stock | 43.5325 | 43.5325 | 43.525 | 43.525 | 2368.0 |
| 2019-03-07 07:45:00 | AAPL | Stock | 43.5375 | 43.5875 | 43.5025 | 43.5025 | 37508.0 |
| 2019-03-07 07:50:00 | AAPL | Stock | 43.5125 | 43.5125 | 43.5125 | 43.5125 | 1200.0 |
| 2019-03-07 07:55:00 | AAPL | Stock | 43.5475 | 43.5875 | 43.5475 | 43.5875 | 9620.0 |
| 2019-03-07 08:00:00 | AAPL | Stock | 43.515 | 43.575 | 43.495 | 43.5625 | 19532.0 |
| 2019-03-07 08:05:00 | AAPL | Stock | 43.6 | 43.625 | 43.6 | 43.625 | 3400.0 |
| 2019-03-07 08:10:00 | AAPL | Stock | 43.6275 | 43.6275 | 43.575 | 43.575 | 18996.0 |
| 2019-03-07 08:15:00 | AAPL | Stock | 43.5775 | 43.5775 | 43.575 | 43.575 | 2600.0 |
| 2019-03-07 08:20:00 | AAPL | Stock | 43.5975 | 43.6225 | 43.5975 | 43.62 | 3600.0 |
| 2019-03-07 08:25:00 | AAPL | Stock | 43.5875 | 43.6275 | 43.5875 | 43.6275 | 8248.0 |
| 2019-03-07 08:30:00 | AAPL | Stock | 43.6125 | 43.65 | 43.5875 | 43.6475 | 64424.0 |
| 2019-03-07 08:35:00 | AAPL | Stock | 43.645 | 43.6675 | 43.63 | 43.6625 | 11796.0 |
| 2019-03-07 08:40:00 | AAPL | Stock | 43.65 | 43.675 | 43.65 | 43.6625 | 5088.0 |
| 2019-03-07 08:45:00 | AAPL | Stock | 43.655 | 43.6625 | 43.625 | 43.645 | 9984.0 |
| 2019-03-07 08:50:00 | AAPL | Stock | 43.62 | 43.62 | 43.575 | 43.575 | 9804.0 |
| 2019-03-07 08:55:00 | AAPL | Stock | 43.575 | 43.59 | 43.57 | 43.58 | 7200.0 |
| 2019-03-07 09:00:00 | AAPL | Stock | 43.5875 | 43.6075 | 43.5875 | 43.6025 | 15664.0 |
| 2019-03-07 09:05:00 | AAPL | Stock | 43.62 | 43.62 | 43.5925 | 43.5925 | 2972.0 |
| 2019-03-07 09:10:00 | AAPL | Stock | 43.59 | 43.59 | 43.55 | 43.5625 | 14816.0 |
| 2019-03-07 09:15:00 | AAPL | Stock | 43.5775 | 43.5875 | 43.5775 | 43.5875 | 7600.0 |
| 2019-03-07 09:20:00 | AAPL | Stock | 43.565 | 43.565 | 43.5275 | 43.5275 | 13848.0 |
| 2019-03-07 09:25:00 | AAPL | Stock | 43.4875 | 43.5375 | 43.4875 | 43.5 | 14444.0 |
| 2019-03-07 09:30:00 | AAPL | Stock | 43.4675 | 43.61 | 43.4375 | 43.5645 | 2866880.0 |
| 2019-03-07 09:35:00 | AAPL | Stock | 43.5625 | 43.5762 | 43.4925 | 43.525 | 1512780.0 |
| 2019-03-07 09:40:00 | AAPL | Stock | 43.52 | 43.5575 | 43.49 | 43.5075 | 1720036.0 |
| 2019-03-07 09:45:00 | AAPL | Stock | 43.5075 | 43.515 | 43.3875 | 43.41 | 1897904.0 |
| 2019-03-07 09:50:00 | AAPL | Stock | 43.41 | 43.455 | 43.395 | 43.425 | 1622904.0 |
| 2019-03-07 09:55:00 | AAPL | Stock | 43.425 | 43.445 | 43.3625 | 43.3825 | 1383656.0 |
| 2019-03-07 10:00:00 | AAPL | Stock | 43.385 | 43.3875 | 43.255 | 43.33 | 2021640.0 |
| 2019-03-07 10:05:00 | AAPL | Stock | 43.3225 | 43.3625 | 43.285 | 43.3005 | 1678128.0 |
| 2019-03-07 10:10:00 | AAPL | Stock | 43.3025 | 43.3025 | 43.1325 | 43.1575 | 2070364.0 |
| 2019-03-07 10:15:00 | AAPL | Stock | 43.1525 | 43.1875 | 43.005 | 43.052 | 2206832.0 |
| 2019-03-07 10:20:00 | AAPL | Stock | 43.05 | 43.1725 | 43.02 | 43.1725 | 1407776.0 |
| 2019-03-07 10:25:00 | AAPL | Stock | 43.17 | 43.2 | 43.1475 | 43.1825 | 1217016.0 |
| 2019-03-07 10:30:00 | AAPL | Stock | 43.1825 | 43.22 | 43.1275 | 43.175 | 1010644.0 |
| 2019-03-07 10:35:00 | AAPL | Stock | 43.1725 | 43.1825 | 43.0908 | 43.12 | 945712.0 |
| 2019-03-07 10:40:00 | AAPL | Stock | 43.12 | 43.1575 | 43.0675 | 43.115 | 1156416.0 |
| 2019-03-07 10:45:00 | AAPL | Stock | 43.1175 | 43.235 | 43.1175 | 43.225 | 825044.0 |
| 2019-03-07 10:50:00 | AAPL | Stock | 43.225 | 43.245 | 43.2025 | 43.2325 | 1140360.0 |
> showing 50 of 363,728 rows — these rows as CSV