PREVIEW / stock_5min / 2019-08-12
file: by_date/stock_5min/2019/2019-08-12.parquet size: 5.5 MB rows: 349,733 symbols: 2,534
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-08-12 04:00:00 | AAPL | Stock | 50.6225 | 50.6225 | 50.5 | 50.5 | 2404.0 |
| 2019-08-12 04:05:00 | AAPL | Stock | 50.5 | 50.5 | 50.375 | 50.375 | 3392.0 |
| 2019-08-12 04:15:00 | AAPL | Stock | 50.3325 | 50.3325 | 50.3 | 50.3 | 1600.0 |
| 2019-08-12 04:20:00 | AAPL | Stock | 50.3275 | 50.3275 | 50.28 | 50.28 | 5316.0 |
| 2019-08-12 04:25:00 | AAPL | Stock | 50.2375 | 50.2375 | 50.2375 | 50.2375 | 800.0 |
| 2019-08-12 04:30:00 | AAPL | Stock | 50.2125 | 50.2125 | 50.2125 | 50.2125 | 400.0 |
| 2019-08-12 04:50:00 | AAPL | Stock | 50.1025 | 50.1025 | 50.0125 | 50.0125 | 8120.0 |
| 2019-08-12 04:55:00 | AAPL | Stock | 50.035 | 50.0875 | 50.035 | 50.0875 | 9572.0 |
| 2019-08-12 05:00:00 | AAPL | Stock | 50.05 | 50.055 | 49.9425 | 49.9425 | 15800.0 |
| 2019-08-12 05:05:00 | AAPL | Stock | 49.9425 | 49.9425 | 49.9425 | 49.9425 | 3000.0 |
| 2019-08-12 05:20:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 788.0 |
| 2019-08-12 05:25:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 1320.0 |
| 2019-08-12 05:30:00 | AAPL | Stock | 50.05 | 50.05 | 50.005 | 50.005 | 4400.0 |
| 2019-08-12 05:35:00 | AAPL | Stock | 50.0 | 50.0 | 50.0 | 50.0 | 2000.0 |
| 2019-08-12 05:50:00 | AAPL | Stock | 49.955 | 49.955 | 49.955 | 49.955 | 1288.0 |
| 2019-08-12 06:00:00 | AAPL | Stock | 49.945 | 49.945 | 49.945 | 49.945 | 11064.0 |
| 2019-08-12 06:05:00 | AAPL | Stock | 49.91 | 49.91 | 49.91 | 49.91 | 400.0 |
| 2019-08-12 06:10:00 | AAPL | Stock | 49.9375 | 49.9375 | 49.9375 | 49.9375 | 2936.0 |
| 2019-08-12 06:25:00 | AAPL | Stock | 49.9375 | 49.9375 | 49.88 | 49.8875 | 1200.0 |
| 2019-08-12 06:30:00 | AAPL | Stock | 49.875 | 49.875 | 49.8025 | 49.825 | 8676.0 |
| 2019-08-12 06:35:00 | AAPL | Stock | 49.825 | 49.8375 | 49.8225 | 49.8225 | 7268.0 |
| 2019-08-12 06:40:00 | AAPL | Stock | 49.825 | 49.825 | 49.8 | 49.8 | 17124.0 |
| 2019-08-12 06:45:00 | AAPL | Stock | 49.77 | 49.7775 | 49.7575 | 49.7775 | 10200.0 |
| 2019-08-12 06:50:00 | AAPL | Stock | 49.845 | 49.865 | 49.845 | 49.865 | 2496.0 |
| 2019-08-12 07:00:00 | AAPL | Stock | 49.875 | 49.995 | 49.865 | 49.995 | 23064.0 |
| 2019-08-12 07:05:00 | AAPL | Stock | 49.9625 | 49.9625 | 49.96 | 49.9625 | 4660.0 |
| 2019-08-12 07:10:00 | AAPL | Stock | 49.9125 | 49.9125 | 49.88 | 49.88 | 1964.0 |
| 2019-08-12 07:15:00 | AAPL | Stock | 49.88 | 49.88 | 49.815 | 49.815 | 14548.0 |
| 2019-08-12 07:20:00 | AAPL | Stock | 49.825 | 49.825 | 49.7825 | 49.7825 | 6620.0 |
| 2019-08-12 07:25:00 | AAPL | Stock | 49.7625 | 49.7625 | 49.725 | 49.7575 | 31824.0 |
| 2019-08-12 07:30:00 | AAPL | Stock | 49.765 | 49.81 | 49.75 | 49.8 | 11580.0 |
| 2019-08-12 07:35:00 | AAPL | Stock | 49.7875 | 49.7875 | 49.7875 | 49.7875 | 400.0 |
| 2019-08-12 07:40:00 | AAPL | Stock | 49.86 | 49.8875 | 49.86 | 49.8875 | 9620.0 |
| 2019-08-12 07:45:00 | AAPL | Stock | 49.8325 | 49.87 | 49.8325 | 49.87 | 2396.0 |
| 2019-08-12 07:50:00 | AAPL | Stock | 49.8375 | 49.85 | 49.8375 | 49.85 | 4580.0 |
| 2019-08-12 07:55:00 | AAPL | Stock | 49.8125 | 49.8125 | 49.775 | 49.8 | 27000.0 |
| 2019-08-12 08:00:00 | AAPL | Stock | 49.9625 | 50.0 | 49.6975 | 49.905 | 80432.0 |
| 2019-08-12 08:05:00 | AAPL | Stock | 49.905 | 49.935 | 49.855 | 49.865 | 7984.0 |
| 2019-08-12 08:10:00 | AAPL | Stock | 49.8675 | 49.9332 | 49.8625 | 49.875 | 19100.0 |
| 2019-08-12 08:15:00 | AAPL | Stock | 49.875 | 49.9 | 49.85 | 49.8875 | 13672.0 |
| 2019-08-12 08:20:00 | AAPL | Stock | 49.895 | 49.914 | 49.895 | 49.914 | 5300.0 |
| 2019-08-12 08:25:00 | AAPL | Stock | 49.9 | 49.915 | 49.8325 | 49.8325 | 15328.0 |
| 2019-08-12 08:30:00 | AAPL | Stock | 49.8625 | 49.9125 | 49.8525 | 49.8675 | 6180.0 |
| 2019-08-12 08:35:00 | AAPL | Stock | 49.9 | 49.9 | 49.7875 | 49.7875 | 6740.0 |
| 2019-08-12 08:40:00 | AAPL | Stock | 49.7875 | 49.8475 | 49.7875 | 49.82 | 10244.0 |
| 2019-08-12 08:45:00 | AAPL | Stock | 49.82 | 49.82 | 49.82 | 49.82 | 6400.0 |
| 2019-08-12 08:50:00 | AAPL | Stock | 49.8775 | 50.0325 | 49.86 | 49.9975 | 56132.0 |
| 2019-08-12 08:55:00 | AAPL | Stock | 49.9382 | 50.0 | 49.925 | 49.925 | 13084.0 |
| 2019-08-12 09:00:00 | AAPL | Stock | 49.95 | 49.9975 | 49.8725 | 49.8725 | 20864.0 |
| 2019-08-12 09:05:00 | AAPL | Stock | 49.91 | 49.965 | 49.8875 | 49.9625 | 22536.0 |
> showing 50 of 349,733 rows — these rows as CSV