PREVIEW / stock_5min / 2020-01-03
file: by_date/stock_5min/2020/2020-01-03.parquet size: 6.0 MB rows: 373,180 symbols: 2,458
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-01-03 04:00:00 | AAPL | Stock | 74.3375 | 74.3375 | 74.0525 | 74.1975 | 35540.0 |
| 2020-01-03 04:05:00 | AAPL | Stock | 74.1875 | 74.1875 | 74.03 | 74.03 | 36176.0 |
| 2020-01-03 04:10:00 | AAPL | Stock | 74.0425 | 74.05 | 73.925 | 73.975 | 32816.0 |
| 2020-01-03 04:15:00 | AAPL | Stock | 73.975 | 74.0525 | 73.9725 | 74.0525 | 7120.0 |
| 2020-01-03 04:20:00 | AAPL | Stock | 74.0525 | 74.0525 | 74.025 | 74.025 | 5148.0 |
| 2020-01-03 04:25:00 | AAPL | Stock | 74.0525 | 74.0525 | 73.975 | 73.975 | 24420.0 |
| 2020-01-03 04:30:00 | AAPL | Stock | 74.0525 | 74.0525 | 74.02 | 74.02 | 4856.0 |
| 2020-01-03 04:35:00 | AAPL | Stock | 74.02 | 74.0675 | 74.02 | 74.0325 | 3036.0 |
| 2020-01-03 04:40:00 | AAPL | Stock | 74.0675 | 74.0675 | 73.95 | 73.95 | 6500.0 |
| 2020-01-03 04:45:00 | AAPL | Stock | 73.955 | 73.96 | 73.9 | 73.9 | 9260.0 |
| 2020-01-03 04:50:00 | AAPL | Stock | 73.9825 | 74.0 | 73.95 | 73.9625 | 7252.0 |
| 2020-01-03 04:55:00 | AAPL | Stock | 73.9625 | 74.05 | 73.9625 | 74.05 | 7320.0 |
| 2020-01-03 05:00:00 | AAPL | Stock | 74.045 | 74.075 | 74.045 | 74.075 | 12804.0 |
| 2020-01-03 05:05:00 | AAPL | Stock | 74.075 | 74.15 | 74.065 | 74.065 | 2116.0 |
| 2020-01-03 05:10:00 | AAPL | Stock | 74.05 | 74.1475 | 74.01 | 74.075 | 8692.0 |
| 2020-01-03 05:15:00 | AAPL | Stock | 74.055 | 74.06 | 73.9 | 73.9075 | 11472.0 |
| 2020-01-03 05:20:00 | AAPL | Stock | 74.0 | 74.05 | 74.0 | 74.05 | 1820.0 |
| 2020-01-03 05:25:00 | AAPL | Stock | 74.0 | 74.0 | 74.0 | 74.0 | 2280.0 |
| 2020-01-03 05:30:00 | AAPL | Stock | 73.9825 | 73.985 | 73.875 | 73.875 | 21640.0 |
| 2020-01-03 05:35:00 | AAPL | Stock | 73.905 | 73.95 | 73.8625 | 73.95 | 12736.0 |
| 2020-01-03 05:40:00 | AAPL | Stock | 73.9225 | 73.9225 | 73.8 | 73.8825 | 23548.0 |
| 2020-01-03 05:45:00 | AAPL | Stock | 73.875 | 73.875 | 73.7775 | 73.7775 | 3220.0 |
| 2020-01-03 05:50:00 | AAPL | Stock | 73.7775 | 73.7775 | 73.75 | 73.75 | 13000.0 |
| 2020-01-03 05:55:00 | AAPL | Stock | 73.75 | 73.75 | 73.595 | 73.71 | 30876.0 |
| 2020-01-03 06:00:00 | AAPL | Stock | 73.71 | 73.75 | 73.7075 | 73.75 | 10592.0 |
| 2020-01-03 06:05:00 | AAPL | Stock | 73.8475 | 73.8475 | 73.79 | 73.79 | 1600.0 |
| 2020-01-03 06:10:00 | AAPL | Stock | 73.8125 | 73.825 | 73.75 | 73.8075 | 8772.0 |
| 2020-01-03 06:15:00 | AAPL | Stock | 73.8075 | 73.8825 | 73.8075 | 73.8825 | 31128.0 |
| 2020-01-03 06:20:00 | AAPL | Stock | 73.8925 | 73.8925 | 73.8375 | 73.8375 | 7888.0 |
| 2020-01-03 06:25:00 | AAPL | Stock | 73.8725 | 73.9 | 73.7525 | 73.9 | 31100.0 |
| 2020-01-03 06:30:00 | AAPL | Stock | 73.955 | 73.955 | 73.825 | 73.8275 | 25952.0 |
| 2020-01-03 06:35:00 | AAPL | Stock | 73.86 | 73.9 | 73.8525 | 73.9 | 11596.0 |
| 2020-01-03 06:40:00 | AAPL | Stock | 73.9 | 73.9 | 73.8575 | 73.8575 | 4600.0 |
| 2020-01-03 06:45:00 | AAPL | Stock | 73.9075 | 73.9075 | 73.8675 | 73.8675 | 4096.0 |
| 2020-01-03 06:50:00 | AAPL | Stock | 73.945 | 73.975 | 73.9 | 73.975 | 25076.0 |
| 2020-01-03 06:55:00 | AAPL | Stock | 73.945 | 73.9675 | 73.8875 | 73.9175 | 15684.0 |
| 2020-01-03 07:00:00 | AAPL | Stock | 73.9475 | 74.2 | 73.9 | 74.125 | 218836.0 |
| 2020-01-03 07:05:00 | AAPL | Stock | 74.125 | 74.22 | 74.125 | 74.2 | 83388.0 |
| 2020-01-03 07:10:00 | AAPL | Stock | 74.2025 | 74.2975 | 74.15 | 74.275 | 77164.0 |
| 2020-01-03 07:15:00 | AAPL | Stock | 74.275 | 74.375 | 74.25 | 74.3725 | 53176.0 |
| 2020-01-03 07:20:00 | AAPL | Stock | 74.35 | 74.35 | 74.225 | 74.225 | 69312.0 |
| 2020-01-03 07:25:00 | AAPL | Stock | 74.22 | 74.3 | 74.2025 | 74.3 | 56516.0 |
| 2020-01-03 07:30:00 | AAPL | Stock | 74.285 | 74.3575 | 74.2775 | 74.3575 | 50180.0 |
| 2020-01-03 07:35:00 | AAPL | Stock | 74.3275 | 74.3725 | 74.3275 | 74.35 | 26768.0 |
| 2020-01-03 07:40:00 | AAPL | Stock | 74.35 | 74.3975 | 74.3175 | 74.395 | 59776.0 |
| 2020-01-03 07:45:00 | AAPL | Stock | 74.4 | 74.4225 | 74.35 | 74.35 | 87732.0 |
| 2020-01-03 07:50:00 | AAPL | Stock | 74.4075 | 74.45 | 74.38 | 74.38 | 138632.0 |
| 2020-01-03 07:55:00 | AAPL | Stock | 74.3925 | 74.55 | 74.3925 | 74.5125 | 99620.0 |
| 2020-01-03 08:00:00 | AAPL | Stock | 74.5025 | 74.6175 | 73.9125 | 74.6175 | 621980.0 |
| 2020-01-03 08:05:00 | AAPL | Stock | 74.6 | 74.625 | 74.5625 | 74.5625 | 136824.0 |
> showing 50 of 373,180 rows — these rows as CSV