PREVIEW / stock_5min / 2020-03-18
file: by_date/stock_5min/2020/2020-03-18.parquet size: 6.7 MB rows: 423,652 symbols: 2,472
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-18 04:00:00 | AAPL | Stock | 59.9275 | 59.9275 | 59.5125 | 59.6975 | 22832.0 |
| 2020-03-18 04:05:00 | AAPL | Stock | 59.685 | 59.745 | 59.5125 | 59.65 | 8704.0 |
| 2020-03-18 04:10:00 | AAPL | Stock | 59.9125 | 59.915 | 59.75 | 59.75 | 7992.0 |
| 2020-03-18 04:15:00 | AAPL | Stock | 59.87 | 59.87 | 59.72 | 59.72 | 14676.0 |
| 2020-03-18 04:20:00 | AAPL | Stock | 59.7 | 59.875 | 59.655 | 59.875 | 15864.0 |
| 2020-03-18 04:25:00 | AAPL | Stock | 59.88 | 59.88 | 59.875 | 59.875 | 1960.0 |
| 2020-03-18 04:30:00 | AAPL | Stock | 59.825 | 59.825 | 59.6275 | 59.635 | 19388.0 |
| 2020-03-18 04:35:00 | AAPL | Stock | 59.625 | 59.775 | 59.5225 | 59.775 | 10580.0 |
| 2020-03-18 04:40:00 | AAPL | Stock | 59.75 | 59.95 | 59.75 | 59.95 | 20480.0 |
| 2020-03-18 04:45:00 | AAPL | Stock | 59.95 | 60.15 | 59.95 | 60.0 | 9540.0 |
| 2020-03-18 04:50:00 | AAPL | Stock | 60.0625 | 60.0625 | 59.9 | 59.9725 | 23248.0 |
| 2020-03-18 04:55:00 | AAPL | Stock | 60.0 | 60.0 | 59.995 | 59.995 | 3012.0 |
| 2020-03-18 05:00:00 | AAPL | Stock | 59.9 | 59.9 | 59.885 | 59.885 | 980.0 |
| 2020-03-18 05:05:00 | AAPL | Stock | 59.875 | 59.9 | 59.875 | 59.9 | 2160.0 |
| 2020-03-18 05:10:00 | AAPL | Stock | 59.925 | 59.925 | 59.875 | 59.875 | 4320.0 |
| 2020-03-18 05:15:00 | AAPL | Stock | 59.9125 | 59.9125 | 59.875 | 59.875 | 5000.0 |
| 2020-03-18 05:20:00 | AAPL | Stock | 59.8375 | 59.8375 | 59.75 | 59.75 | 16760.0 |
| 2020-03-18 05:25:00 | AAPL | Stock | 59.7625 | 59.7625 | 59.65 | 59.7375 | 29752.0 |
| 2020-03-18 05:30:00 | AAPL | Stock | 59.6925 | 59.6925 | 59.6925 | 59.6925 | 18880.0 |
| 2020-03-18 05:35:00 | AAPL | Stock | 59.705 | 59.775 | 59.705 | 59.72 | 4536.0 |
| 2020-03-18 05:40:00 | AAPL | Stock | 59.655 | 59.695 | 59.6425 | 59.695 | 3508.0 |
| 2020-03-18 05:45:00 | AAPL | Stock | 59.65 | 59.65 | 59.525 | 59.525 | 7512.0 |
| 2020-03-18 05:50:00 | AAPL | Stock | 59.5325 | 59.5525 | 59.5 | 59.5025 | 8904.0 |
| 2020-03-18 05:55:00 | AAPL | Stock | 59.525 | 59.645 | 59.525 | 59.625 | 3960.0 |
| 2020-03-18 06:00:00 | AAPL | Stock | 59.675 | 59.68 | 59.62 | 59.62 | 3040.0 |
| 2020-03-18 06:05:00 | AAPL | Stock | 59.5725 | 59.5725 | 59.525 | 59.525 | 3004.0 |
| 2020-03-18 06:10:00 | AAPL | Stock | 59.5 | 59.62 | 59.4525 | 59.6 | 19284.0 |
| 2020-03-18 06:15:00 | AAPL | Stock | 59.5125 | 59.6 | 59.25 | 59.25 | 25664.0 |
| 2020-03-18 06:20:00 | AAPL | Stock | 59.28 | 59.35 | 59.28 | 59.3 | 4772.0 |
| 2020-03-18 06:25:00 | AAPL | Stock | 59.325 | 59.325 | 59.1225 | 59.1225 | 12000.0 |
| 2020-03-18 06:30:00 | AAPL | Stock | 59.125 | 59.375 | 59.125 | 59.25 | 16452.0 |
| 2020-03-18 06:35:00 | AAPL | Stock | 59.2125 | 59.2125 | 59.1225 | 59.145 | 7752.0 |
| 2020-03-18 06:40:00 | AAPL | Stock | 59.125 | 59.195 | 59.0775 | 59.195 | 8560.0 |
| 2020-03-18 06:45:00 | AAPL | Stock | 59.16 | 59.16 | 59.1 | 59.1 | 3700.0 |
| 2020-03-18 06:50:00 | AAPL | Stock | 59.0625 | 59.0675 | 59.0 | 59.0675 | 10240.0 |
| 2020-03-18 06:55:00 | AAPL | Stock | 59.12 | 59.255 | 59.0275 | 59.125 | 67124.0 |
| 2020-03-18 07:00:00 | AAPL | Stock | 59.125 | 59.4625 | 59.125 | 59.3525 | 185584.0 |
| 2020-03-18 07:05:00 | AAPL | Stock | 59.34 | 59.4 | 59.2 | 59.275 | 133376.0 |
| 2020-03-18 07:10:00 | AAPL | Stock | 59.2725 | 59.34 | 59.0625 | 59.25 | 84408.0 |
| 2020-03-18 07:15:00 | AAPL | Stock | 59.25 | 59.3225 | 59.13 | 59.3 | 35856.0 |
| 2020-03-18 07:20:00 | AAPL | Stock | 59.3075 | 59.45 | 59.25 | 59.25 | 84660.0 |
| 2020-03-18 07:25:00 | AAPL | Stock | 59.25 | 59.375 | 59.14 | 59.26 | 49900.0 |
| 2020-03-18 07:30:00 | AAPL | Stock | 59.35 | 59.6 | 59.265 | 59.425 | 65396.0 |
| 2020-03-18 07:35:00 | AAPL | Stock | 59.4625 | 59.475 | 59.3675 | 59.375 | 36656.0 |
| 2020-03-18 07:40:00 | AAPL | Stock | 59.375 | 59.5375 | 59.2525 | 59.2825 | 64476.0 |
| 2020-03-18 07:45:00 | AAPL | Stock | 59.285 | 59.7225 | 59.2725 | 59.675 | 42072.0 |
| 2020-03-18 07:50:00 | AAPL | Stock | 59.6925 | 59.8225 | 59.62 | 59.665 | 77444.0 |
| 2020-03-18 07:55:00 | AAPL | Stock | 59.66 | 59.8375 | 59.625 | 59.8125 | 30152.0 |
| 2020-03-18 08:00:00 | AAPL | Stock | 59.25 | 60.0 | 59.1025 | 59.975 | 406480.0 |
| 2020-03-18 08:05:00 | AAPL | Stock | 59.9025 | 59.9875 | 59.75 | 59.75 | 143660.0 |
> showing 50 of 423,652 rows — these rows as CSV