PREVIEW / stock_5min / 2018-05-10
file: by_date/stock_5min/2018/2018-05-10.parquet size: 5.6 MB rows: 358,530 symbols: 2,842
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-10 04:00:00 | AAPL | Stock | 46.86 | 46.86 | 46.86 | 46.86 | 17200.0 |
| 2018-05-10 04:05:00 | AAPL | Stock | 46.86 | 46.86 | 46.84 | 46.84 | 10400.0 |
| 2018-05-10 05:35:00 | AAPL | Stock | 46.805 | 46.805 | 46.8025 | 46.8025 | 1600.0 |
| 2018-05-10 05:40:00 | AAPL | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 6000.0 |
| 2018-05-10 06:05:00 | AAPL | Stock | 46.805 | 46.805 | 46.805 | 46.805 | 800.0 |
| 2018-05-10 06:35:00 | AAPL | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 3600.0 |
| 2018-05-10 07:00:00 | AAPL | Stock | 46.8325 | 46.8475 | 46.82 | 46.8475 | 9380.0 |
| 2018-05-10 07:05:00 | AAPL | Stock | 46.825 | 46.825 | 46.81 | 46.8125 | 19136.0 |
| 2018-05-10 07:10:00 | AAPL | Stock | 46.8125 | 46.8125 | 46.8125 | 46.8125 | 2800.0 |
| 2018-05-10 07:15:00 | AAPL | Stock | 46.8125 | 46.82 | 46.8075 | 46.8075 | 3200.0 |
| 2018-05-10 07:20:00 | AAPL | Stock | 46.8125 | 46.8375 | 46.8125 | 46.815 | 2368.0 |
| 2018-05-10 07:25:00 | AAPL | Stock | 46.8175 | 46.8375 | 46.815 | 46.8375 | 10240.0 |
| 2018-05-10 07:30:00 | AAPL | Stock | 46.845 | 46.845 | 46.845 | 46.845 | 400.0 |
| 2018-05-10 07:35:00 | AAPL | Stock | 46.8475 | 46.85 | 46.8475 | 46.85 | 13720.0 |
| 2018-05-10 07:40:00 | AAPL | Stock | 46.8575 | 46.8625 | 46.8575 | 46.8625 | 2000.0 |
| 2018-05-10 07:45:00 | AAPL | Stock | 46.8625 | 46.8625 | 46.8525 | 46.855 | 7772.0 |
| 2018-05-10 07:50:00 | AAPL | Stock | 46.855 | 46.87 | 46.855 | 46.87 | 20028.0 |
| 2018-05-10 07:55:00 | AAPL | Stock | 46.865 | 46.875 | 46.8625 | 46.865 | 18040.0 |
| 2018-05-10 08:00:00 | AAPL | Stock | 46.8625 | 46.885 | 46.8 | 46.8525 | 50152.0 |
| 2018-05-10 08:05:00 | AAPL | Stock | 46.855 | 46.8725 | 46.8175 | 46.8175 | 83344.0 |
| 2018-05-10 08:10:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.8375 | 46.8375 | 24000.0 |
| 2018-05-10 08:15:00 | AAPL | Stock | 46.8375 | 46.8425 | 46.8375 | 46.8425 | 7900.0 |
| 2018-05-10 08:20:00 | AAPL | Stock | 46.8375 | 46.85 | 46.8375 | 46.8375 | 16208.0 |
| 2018-05-10 08:25:00 | AAPL | Stock | 46.8375 | 46.8442 | 46.8375 | 46.8425 | 2944.0 |
| 2018-05-10 08:30:00 | AAPL | Stock | 46.8375 | 46.9325 | 46.8375 | 46.88 | 45836.0 |
| 2018-05-10 08:35:00 | AAPL | Stock | 46.8925 | 46.8975 | 46.88 | 46.89 | 29968.0 |
| 2018-05-10 08:40:00 | AAPL | Stock | 46.885 | 46.9125 | 46.88 | 46.9125 | 19800.0 |
| 2018-05-10 08:45:00 | AAPL | Stock | 46.9125 | 46.9425 | 46.8975 | 46.9425 | 99648.0 |
| 2018-05-10 08:50:00 | AAPL | Stock | 46.9375 | 46.95 | 46.925 | 46.95 | 34520.0 |
| 2018-05-10 08:55:00 | AAPL | Stock | 46.955 | 46.9675 | 46.95 | 46.9625 | 45356.0 |
| 2018-05-10 09:00:00 | AAPL | Stock | 46.9425 | 46.95 | 46.9225 | 46.9225 | 33712.0 |
| 2018-05-10 09:05:00 | AAPL | Stock | 46.925 | 46.94 | 46.925 | 46.94 | 4400.0 |
| 2018-05-10 09:10:00 | AAPL | Stock | 46.925 | 46.935 | 46.9 | 46.9125 | 11496.0 |
| 2018-05-10 09:15:00 | AAPL | Stock | 46.9125 | 46.925 | 46.9125 | 46.915 | 27716.0 |
| 2018-05-10 09:20:00 | AAPL | Stock | 46.92 | 46.9325 | 46.92 | 46.93 | 13032.0 |
| 2018-05-10 09:25:00 | AAPL | Stock | 46.925 | 46.9875 | 46.91 | 46.9225 | 138816.0 |
| 2018-05-10 09:30:00 | AAPL | Stock | 46.935 | 47.0 | 46.9125 | 46.988 | 3311168.0 |
| 2018-05-10 09:35:00 | AAPL | Stock | 46.99 | 47.06 | 46.965 | 47.0175 | 2897416.0 |
| 2018-05-10 09:40:00 | AAPL | Stock | 47.02 | 47.14 | 47.0175 | 47.105 | 2495276.0 |
| 2018-05-10 09:45:00 | AAPL | Stock | 47.105 | 47.135 | 46.955 | 46.965 | 2267972.0 |
| 2018-05-10 09:50:00 | AAPL | Stock | 46.96 | 47.105 | 46.96 | 47.0925 | 1335136.0 |
| 2018-05-10 09:55:00 | AAPL | Stock | 47.0925 | 47.1025 | 46.9968 | 47.0 | 1528448.0 |
| 2018-05-10 10:00:00 | AAPL | Stock | 47.0 | 47.0155 | 46.9362 | 46.995 | 1227864.0 |
| 2018-05-10 10:05:00 | AAPL | Stock | 46.9935 | 47.0625 | 46.9775 | 47.03 | 1250128.0 |
| 2018-05-10 10:10:00 | AAPL | Stock | 47.0325 | 47.115 | 47.015 | 47.0975 | 1466972.0 |
| 2018-05-10 10:15:00 | AAPL | Stock | 47.0988 | 47.1275 | 47.0425 | 47.0712 | 1725124.0 |
| 2018-05-10 10:20:00 | AAPL | Stock | 47.07 | 47.0925 | 47.0475 | 47.09 | 1499576.0 |
| 2018-05-10 10:25:00 | AAPL | Stock | 47.09 | 47.1575 | 47.06 | 47.1525 | 1492764.0 |
| 2018-05-10 10:30:00 | AAPL | Stock | 47.15 | 47.1525 | 47.0875 | 47.112 | 1200860.0 |
| 2018-05-10 10:35:00 | AAPL | Stock | 47.1125 | 47.1275 | 47.09 | 47.1 | 652532.0 |
> showing 50 of 358,530 rows — these rows as CSV