PREVIEW / stock_5min / 2020-03-19
file: by_date/stock_5min/2020/2020-03-19.parquet size: 6.8 MB rows: 428,075 symbols: 2,446
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-19 04:00:00 | AAPL | Stock | 61.4975 | 61.875 | 61.15 | 61.6775 | 23668.0 |
| 2020-03-19 04:05:00 | AAPL | Stock | 61.5275 | 61.5275 | 61.15 | 61.15 | 7520.0 |
| 2020-03-19 04:10:00 | AAPL | Stock | 61.45 | 61.575 | 61.45 | 61.4625 | 1600.0 |
| 2020-03-19 04:15:00 | AAPL | Stock | 61.4975 | 61.75 | 61.4975 | 61.75 | 1600.0 |
| 2020-03-19 04:20:00 | AAPL | Stock | 61.9 | 61.9975 | 61.9 | 61.9975 | 1968.0 |
| 2020-03-19 04:25:00 | AAPL | Stock | 61.9775 | 62.25 | 61.8775 | 62.25 | 9404.0 |
| 2020-03-19 04:30:00 | AAPL | Stock | 62.375 | 62.75 | 62.25 | 62.695 | 12280.0 |
| 2020-03-19 04:35:00 | AAPL | Stock | 62.68 | 62.7375 | 62.5 | 62.5 | 5708.0 |
| 2020-03-19 04:40:00 | AAPL | Stock | 62.3625 | 62.45 | 62.25 | 62.45 | 2404.0 |
| 2020-03-19 04:45:00 | AAPL | Stock | 62.05 | 62.225 | 62.05 | 62.225 | 3896.0 |
| 2020-03-19 04:50:00 | AAPL | Stock | 62.2225 | 62.345 | 62.2225 | 62.2625 | 3200.0 |
| 2020-03-19 04:55:00 | AAPL | Stock | 62.2775 | 62.5 | 62.25 | 62.5 | 5896.0 |
| 2020-03-19 05:00:00 | AAPL | Stock | 62.495 | 62.495 | 62.495 | 62.495 | 400.0 |
| 2020-03-19 05:05:00 | AAPL | Stock | 62.5725 | 62.5725 | 62.3175 | 62.5075 | 5416.0 |
| 2020-03-19 05:10:00 | AAPL | Stock | 62.5 | 62.5 | 62.5 | 62.5 | 400.0 |
| 2020-03-19 05:20:00 | AAPL | Stock | 62.445 | 62.445 | 62.265 | 62.265 | 1200.0 |
| 2020-03-19 05:25:00 | AAPL | Stock | 62.05 | 62.05 | 62.0375 | 62.0375 | 1428.0 |
| 2020-03-19 05:35:00 | AAPL | Stock | 61.81 | 61.905 | 61.685 | 61.905 | 2648.0 |
| 2020-03-19 05:40:00 | AAPL | Stock | 61.9125 | 61.9125 | 61.9125 | 61.9125 | 400.0 |
| 2020-03-19 05:50:00 | AAPL | Stock | 61.975 | 61.975 | 61.975 | 61.975 | 400.0 |
| 2020-03-19 05:55:00 | AAPL | Stock | 61.605 | 61.65 | 61.5875 | 61.5875 | 4884.0 |
| 2020-03-19 06:05:00 | AAPL | Stock | 61.3925 | 61.4075 | 61.25 | 61.27 | 7384.0 |
| 2020-03-19 06:10:00 | AAPL | Stock | 61.375 | 61.375 | 61.375 | 61.375 | 1628.0 |
| 2020-03-19 06:15:00 | AAPL | Stock | 61.25 | 61.25 | 61.035 | 61.035 | 9200.0 |
| 2020-03-19 06:20:00 | AAPL | Stock | 61.15 | 61.15 | 61.15 | 61.15 | 400.0 |
| 2020-03-19 06:25:00 | AAPL | Stock | 61.275 | 61.275 | 61.275 | 61.275 | 672.0 |
| 2020-03-19 06:30:00 | AAPL | Stock | 61.42 | 61.5 | 61.42 | 61.5 | 3100.0 |
| 2020-03-19 06:35:00 | AAPL | Stock | 61.4875 | 61.5 | 61.485 | 61.5 | 7580.0 |
| 2020-03-19 06:40:00 | AAPL | Stock | 61.26 | 61.5825 | 61.25 | 61.5 | 11768.0 |
| 2020-03-19 06:45:00 | AAPL | Stock | 61.3125 | 61.3125 | 61.3125 | 61.3125 | 1600.0 |
| 2020-03-19 06:50:00 | AAPL | Stock | 61.3125 | 61.3125 | 61.305 | 61.3125 | 11588.0 |
| 2020-03-19 06:55:00 | AAPL | Stock | 61.2475 | 61.3 | 61.2475 | 61.26 | 2884.0 |
| 2020-03-19 07:00:00 | AAPL | Stock | 61.4325 | 61.915 | 61.41 | 61.7175 | 66404.0 |
| 2020-03-19 07:05:00 | AAPL | Stock | 61.705 | 61.75 | 61.55 | 61.5625 | 34940.0 |
| 2020-03-19 07:10:00 | AAPL | Stock | 61.54 | 61.665 | 61.455 | 61.665 | 30192.0 |
| 2020-03-19 07:15:00 | AAPL | Stock | 61.5775 | 61.6525 | 61.55 | 61.55 | 12636.0 |
| 2020-03-19 07:20:00 | AAPL | Stock | 61.5125 | 61.5875 | 61.4125 | 61.5 | 25816.0 |
| 2020-03-19 07:25:00 | AAPL | Stock | 61.5125 | 61.5825 | 61.4625 | 61.515 | 14636.0 |
| 2020-03-19 07:30:00 | AAPL | Stock | 61.4975 | 61.4975 | 61.2275 | 61.2425 | 14292.0 |
| 2020-03-19 07:35:00 | AAPL | Stock | 61.235 | 61.25 | 60.975 | 61.13 | 35060.0 |
| 2020-03-19 07:40:00 | AAPL | Stock | 60.95 | 60.95 | 60.7775 | 60.9 | 22636.0 |
| 2020-03-19 07:45:00 | AAPL | Stock | 60.905 | 61.0 | 60.7625 | 60.9925 | 24016.0 |
| 2020-03-19 07:50:00 | AAPL | Stock | 61.0 | 61.1325 | 61.0 | 61.005 | 27992.0 |
| 2020-03-19 07:55:00 | AAPL | Stock | 61.025 | 61.025 | 60.8925 | 60.9025 | 18104.0 |
| 2020-03-19 08:00:00 | AAPL | Stock | 61.41 | 61.745 | 60.7525 | 61.125 | 172360.0 |
| 2020-03-19 08:05:00 | AAPL | Stock | 61.12 | 61.125 | 60.9375 | 61.005 | 59912.0 |
| 2020-03-19 08:10:00 | AAPL | Stock | 61.0425 | 61.1125 | 60.9 | 60.9 | 45564.0 |
| 2020-03-19 08:15:00 | AAPL | Stock | 60.8775 | 60.8775 | 60.75 | 60.825 | 35444.0 |
| 2020-03-19 08:20:00 | AAPL | Stock | 60.7625 | 60.825 | 60.45 | 60.4825 | 67680.0 |
| 2020-03-19 08:25:00 | AAPL | Stock | 60.45 | 60.51 | 60.375 | 60.5 | 26876.0 |
> showing 50 of 428,075 rows — these rows as CSV