PREVIEW / stock_5min / 2020-03-04
file: by_date/stock_5min/2020/2020-03-04.parquet size: 6.3 MB rows: 385,913 symbols: 2,414
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 |
|---|---|---|---|---|---|---|---|
| 2020-03-04 04:00:00 | AAPL | Stock | 73.675 | 73.9875 | 73.675 | 73.89 | 33020.0 |
| 2020-03-04 04:05:00 | AAPL | Stock | 73.875 | 73.8975 | 73.575 | 73.575 | 15944.0 |
| 2020-03-04 04:10:00 | AAPL | Stock | 73.575 | 73.65 | 73.45 | 73.45 | 13400.0 |
| 2020-03-04 04:15:00 | AAPL | Stock | 73.615 | 73.775 | 73.615 | 73.775 | 4924.0 |
| 2020-03-04 04:20:00 | AAPL | Stock | 73.725 | 73.735 | 73.725 | 73.725 | 2000.0 |
| 2020-03-04 04:25:00 | AAPL | Stock | 73.75 | 73.8 | 73.75 | 73.755 | 1328.0 |
| 2020-03-04 04:30:00 | AAPL | Stock | 73.775 | 73.775 | 73.6625 | 73.6625 | 10260.0 |
| 2020-03-04 04:35:00 | AAPL | Stock | 73.58 | 73.8175 | 73.58 | 73.8175 | 7476.0 |
| 2020-03-04 04:40:00 | AAPL | Stock | 73.775 | 73.9375 | 73.775 | 73.875 | 8556.0 |
| 2020-03-04 04:45:00 | AAPL | Stock | 73.9475 | 73.9975 | 73.9475 | 73.9975 | 800.0 |
| 2020-03-04 04:50:00 | AAPL | Stock | 73.9975 | 74.025 | 73.8375 | 73.875 | 13532.0 |
| 2020-03-04 04:55:00 | AAPL | Stock | 73.9175 | 73.9625 | 73.875 | 73.9625 | 7772.0 |
| 2020-03-04 05:00:00 | AAPL | Stock | 73.9725 | 73.9725 | 73.875 | 73.875 | 2004.0 |
| 2020-03-04 05:05:00 | AAPL | Stock | 73.85 | 73.885 | 73.85 | 73.885 | 4296.0 |
| 2020-03-04 05:15:00 | AAPL | Stock | 73.955 | 73.955 | 73.955 | 73.955 | 632.0 |
| 2020-03-04 05:20:00 | AAPL | Stock | 73.95 | 74.0 | 73.95 | 74.0 | 4780.0 |
| 2020-03-04 05:25:00 | AAPL | Stock | 74.0475 | 74.1 | 74.005 | 74.09 | 4280.0 |
| 2020-03-04 05:30:00 | AAPL | Stock | 74.0875 | 74.105 | 74.0275 | 74.0275 | 13876.0 |
| 2020-03-04 05:35:00 | AAPL | Stock | 73.92 | 74.03 | 73.9125 | 74.03 | 3448.0 |
| 2020-03-04 05:40:00 | AAPL | Stock | 74.05 | 74.0925 | 74.05 | 74.085 | 3800.0 |
| 2020-03-04 05:45:00 | AAPL | Stock | 74.075 | 74.075 | 73.9125 | 73.92 | 11028.0 |
| 2020-03-04 05:50:00 | AAPL | Stock | 73.9975 | 73.9975 | 73.9975 | 73.9975 | 400.0 |
| 2020-03-04 05:55:00 | AAPL | Stock | 73.9125 | 73.9725 | 73.895 | 73.9525 | 5720.0 |
| 2020-03-04 06:00:00 | AAPL | Stock | 73.9975 | 74.0025 | 73.925 | 73.9875 | 3024.0 |
| 2020-03-04 06:05:00 | AAPL | Stock | 73.8975 | 73.8975 | 73.8275 | 73.8275 | 12852.0 |
| 2020-03-04 06:10:00 | AAPL | Stock | 73.8375 | 73.875 | 73.8075 | 73.875 | 4340.0 |
| 2020-03-04 06:15:00 | AAPL | Stock | 73.81 | 73.9175 | 73.75 | 73.8025 | 14460.0 |
| 2020-03-04 06:20:00 | AAPL | Stock | 73.795 | 74.0025 | 73.79 | 73.9875 | 15164.0 |
| 2020-03-04 06:25:00 | AAPL | Stock | 73.935 | 74.0 | 73.935 | 74.0 | 3180.0 |
| 2020-03-04 06:30:00 | AAPL | Stock | 74.04 | 74.125 | 74.0 | 74.125 | 13020.0 |
| 2020-03-04 06:35:00 | AAPL | Stock | 74.1 | 74.125 | 74.04 | 74.125 | 18292.0 |
| 2020-03-04 06:40:00 | AAPL | Stock | 74.03 | 74.125 | 74.03 | 74.05 | 3404.0 |
| 2020-03-04 06:50:00 | AAPL | Stock | 74.0475 | 74.125 | 74.0475 | 74.125 | 1600.0 |
| 2020-03-04 06:55:00 | AAPL | Stock | 74.075 | 74.075 | 74.075 | 74.075 | 800.0 |
| 2020-03-04 07:00:00 | AAPL | Stock | 74.0975 | 74.1875 | 73.95 | 74.0 | 189356.0 |
| 2020-03-04 07:05:00 | AAPL | Stock | 74.0 | 74.33 | 74.0 | 74.3125 | 181736.0 |
| 2020-03-04 07:10:00 | AAPL | Stock | 74.31 | 74.45 | 74.295 | 74.375 | 133520.0 |
| 2020-03-04 07:15:00 | AAPL | Stock | 74.3875 | 74.525 | 74.35 | 74.525 | 53180.0 |
| 2020-03-04 07:20:00 | AAPL | Stock | 74.5 | 74.5375 | 74.375 | 74.375 | 128900.0 |
| 2020-03-04 07:25:00 | AAPL | Stock | 74.3975 | 74.4375 | 74.2475 | 74.375 | 79588.0 |
| 2020-03-04 07:30:00 | AAPL | Stock | 74.375 | 74.5375 | 74.375 | 74.4875 | 106376.0 |
| 2020-03-04 07:35:00 | AAPL | Stock | 74.4875 | 74.6225 | 74.405 | 74.5275 | 67232.0 |
| 2020-03-04 07:40:00 | AAPL | Stock | 74.5 | 74.5 | 74.375 | 74.4125 | 59532.0 |
| 2020-03-04 07:45:00 | AAPL | Stock | 74.4375 | 74.46 | 74.35 | 74.3725 | 45736.0 |
| 2020-03-04 07:50:00 | AAPL | Stock | 74.4 | 74.5 | 74.355 | 74.375 | 55824.0 |
| 2020-03-04 07:55:00 | AAPL | Stock | 74.375 | 74.4375 | 74.29 | 74.3 | 47952.0 |
| 2020-03-04 08:00:00 | AAPL | Stock | 74.325 | 74.6225 | 73.975 | 74.25 | 428728.0 |
| 2020-03-04 08:05:00 | AAPL | Stock | 74.215 | 74.237 | 73.835 | 74.0025 | 230708.0 |
| 2020-03-04 08:10:00 | AAPL | Stock | 73.9695 | 74.245 | 73.875 | 73.95 | 107244.0 |
| 2020-03-04 08:15:00 | AAPL | Stock | 73.9905 | 74.125 | 73.9125 | 73.9975 | 82132.0 |
> showing 50 of 385,913 rows — these rows as CSV