PREVIEW / stock_5min / 2019-03-22
file: by_date/stock_5min/2019/2019-03-22.parquet size: 5.8 MB rows: 367,127 symbols: 2,627
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-22 04:00:00 | AAPL | Stock | 49.1 | 49.25 | 49.1 | 49.125 | 6576.0 |
| 2019-03-22 04:10:00 | AAPL | Stock | 49.15 | 49.1625 | 49.145 | 49.145 | 15840.0 |
| 2019-03-22 04:15:00 | AAPL | Stock | 49.145 | 49.145 | 49.0525 | 49.06 | 6400.0 |
| 2019-03-22 04:20:00 | AAPL | Stock | 49.0625 | 49.0625 | 49.0325 | 49.0325 | 1200.0 |
| 2019-03-22 04:30:00 | AAPL | Stock | 49.0975 | 49.0975 | 49.0125 | 49.0125 | 10244.0 |
| 2019-03-22 04:35:00 | AAPL | Stock | 49.035 | 49.035 | 49.0025 | 49.03 | 3096.0 |
| 2019-03-22 04:45:00 | AAPL | Stock | 49.0125 | 49.0125 | 48.9625 | 48.9625 | 4236.0 |
| 2019-03-22 04:50:00 | AAPL | Stock | 48.9825 | 48.9825 | 48.91 | 48.91 | 17148.0 |
| 2019-03-22 04:55:00 | AAPL | Stock | 48.88 | 48.88 | 48.88 | 48.88 | 1600.0 |
| 2019-03-22 05:00:00 | AAPL | Stock | 48.9425 | 48.945 | 48.9425 | 48.945 | 872.0 |
| 2019-03-22 05:15:00 | AAPL | Stock | 48.8825 | 48.9025 | 48.8725 | 48.8725 | 19408.0 |
| 2019-03-22 05:20:00 | AAPL | Stock | 48.8425 | 48.89 | 48.7875 | 48.89 | 9200.0 |
| 2019-03-22 05:25:00 | AAPL | Stock | 48.875 | 48.875 | 48.875 | 48.875 | 400.0 |
| 2019-03-22 05:30:00 | AAPL | Stock | 48.81 | 48.81 | 48.81 | 48.81 | 1200.0 |
| 2019-03-22 05:35:00 | AAPL | Stock | 48.865 | 48.865 | 48.865 | 48.865 | 568.0 |
| 2019-03-22 05:45:00 | AAPL | Stock | 48.9 | 48.9 | 48.8875 | 48.8875 | 1648.0 |
| 2019-03-22 06:00:00 | AAPL | Stock | 48.8875 | 48.8875 | 48.8875 | 48.8875 | 400.0 |
| 2019-03-22 06:05:00 | AAPL | Stock | 48.865 | 48.865 | 48.8625 | 48.8625 | 2252.0 |
| 2019-03-22 06:15:00 | AAPL | Stock | 48.8625 | 48.8625 | 48.8625 | 48.8625 | 2400.0 |
| 2019-03-22 06:20:00 | AAPL | Stock | 48.825 | 48.825 | 48.825 | 48.825 | 800.0 |
| 2019-03-22 06:25:00 | AAPL | Stock | 48.81 | 48.825 | 48.8075 | 48.8075 | 1600.0 |
| 2019-03-22 06:30:00 | AAPL | Stock | 48.8325 | 48.835 | 48.8125 | 48.8125 | 4024.0 |
| 2019-03-22 06:40:00 | AAPL | Stock | 48.825 | 48.835 | 48.825 | 48.835 | 4400.0 |
| 2019-03-22 06:45:00 | AAPL | Stock | 48.8125 | 48.8125 | 48.775 | 48.775 | 2400.0 |
| 2019-03-22 06:50:00 | AAPL | Stock | 48.8025 | 48.8125 | 48.7725 | 48.7725 | 3964.0 |
| 2019-03-22 06:55:00 | AAPL | Stock | 48.775 | 48.775 | 48.7725 | 48.7725 | 1592.0 |
| 2019-03-22 07:00:00 | AAPL | Stock | 48.7975 | 48.8975 | 48.7975 | 48.8975 | 43288.0 |
| 2019-03-22 07:05:00 | AAPL | Stock | 48.895 | 48.92 | 48.875 | 48.875 | 25092.0 |
| 2019-03-22 07:10:00 | AAPL | Stock | 48.875 | 48.875 | 48.83 | 48.83 | 19224.0 |
| 2019-03-22 07:15:00 | AAPL | Stock | 48.86 | 48.8975 | 48.86 | 48.875 | 12772.0 |
| 2019-03-22 07:20:00 | AAPL | Stock | 48.9 | 48.925 | 48.8875 | 48.8875 | 12500.0 |
| 2019-03-22 07:25:00 | AAPL | Stock | 48.8875 | 48.92 | 48.875 | 48.92 | 18924.0 |
| 2019-03-22 07:30:00 | AAPL | Stock | 48.91 | 48.92 | 48.89 | 48.8925 | 14648.0 |
| 2019-03-22 07:35:00 | AAPL | Stock | 48.8875 | 48.8875 | 48.8875 | 48.8875 | 1808.0 |
| 2019-03-22 07:40:00 | AAPL | Stock | 48.88 | 48.88 | 48.8775 | 48.8775 | 2400.0 |
| 2019-03-22 07:45:00 | AAPL | Stock | 48.8775 | 48.8775 | 48.825 | 48.8475 | 15328.0 |
| 2019-03-22 07:50:00 | AAPL | Stock | 48.8275 | 48.84 | 48.8125 | 48.8325 | 21596.0 |
| 2019-03-22 07:55:00 | AAPL | Stock | 48.8325 | 48.855 | 48.8275 | 48.855 | 14848.0 |
| 2019-03-22 08:00:00 | AAPL | Stock | 48.835 | 48.9225 | 48.775 | 48.855 | 128336.0 |
| 2019-03-22 08:05:00 | AAPL | Stock | 48.8525 | 48.8825 | 48.8525 | 48.86 | 30400.0 |
| 2019-03-22 08:10:00 | AAPL | Stock | 48.8625 | 48.895 | 48.825 | 48.8275 | 201864.0 |
| 2019-03-22 08:15:00 | AAPL | Stock | 48.8275 | 48.8725 | 48.825 | 48.85 | 109696.0 |
| 2019-03-22 08:20:00 | AAPL | Stock | 48.85 | 48.8725 | 48.8275 | 48.85 | 88492.0 |
| 2019-03-22 08:25:00 | AAPL | Stock | 48.85 | 48.85 | 48.72 | 48.72 | 295776.0 |
| 2019-03-22 08:30:00 | AAPL | Stock | 48.7275 | 48.735 | 48.675 | 48.705 | 75252.0 |
| 2019-03-22 08:35:00 | AAPL | Stock | 48.7125 | 48.7125 | 48.6675 | 48.6775 | 35788.0 |
| 2019-03-22 08:40:00 | AAPL | Stock | 48.6625 | 48.7625 | 48.6325 | 48.7625 | 101160.0 |
| 2019-03-22 08:45:00 | AAPL | Stock | 48.7625 | 48.775 | 48.7225 | 48.745 | 49940.0 |
| 2019-03-22 08:50:00 | AAPL | Stock | 48.745 | 48.7975 | 48.7 | 48.7425 | 32916.0 |
| 2019-03-22 08:55:00 | AAPL | Stock | 48.73 | 48.7875 | 48.705 | 48.7725 | 84252.0 |
> showing 50 of 367,127 rows — these rows as CSV