PREVIEW / stock_5min / 2019-09-16
file: by_date/stock_5min/2019/2019-09-16.parquet size: 5.8 MB rows: 371,371 symbols: 2,559
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-09-16 04:00:00 | AAPL | Stock | 54.3725 | 54.3725 | 54.0775 | 54.0775 | 14296.0 |
| 2019-09-16 04:05:00 | AAPL | Stock | 54.2 | 54.2 | 54.175 | 54.175 | 2800.0 |
| 2019-09-16 04:10:00 | AAPL | Stock | 54.175 | 54.175 | 54.175 | 54.175 | 2800.0 |
| 2019-09-16 04:15:00 | AAPL | Stock | 54.185 | 54.215 | 54.185 | 54.215 | 12384.0 |
| 2019-09-16 04:20:00 | AAPL | Stock | 54.1625 | 54.1625 | 54.1625 | 54.1625 | 2000.0 |
| 2019-09-16 04:25:00 | AAPL | Stock | 54.1375 | 54.1375 | 54.1125 | 54.1125 | 17112.0 |
| 2019-09-16 04:30:00 | AAPL | Stock | 54.1375 | 54.1375 | 54.1375 | 54.1375 | 800.0 |
| 2019-09-16 04:35:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.0925 | 54.0925 | 3040.0 |
| 2019-09-16 04:40:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.075 | 54.075 | 4808.0 |
| 2019-09-16 04:45:00 | AAPL | Stock | 54.0975 | 54.0975 | 54.0975 | 54.0975 | 6800.0 |
| 2019-09-16 04:50:00 | AAPL | Stock | 54.1125 | 54.1625 | 54.1125 | 54.125 | 11200.0 |
| 2019-09-16 05:00:00 | AAPL | Stock | 54.1275 | 54.1625 | 54.1275 | 54.1625 | 31152.0 |
| 2019-09-16 05:05:00 | AAPL | Stock | 54.175 | 54.21 | 54.175 | 54.21 | 4400.0 |
| 2019-09-16 05:10:00 | AAPL | Stock | 54.18 | 54.18 | 54.15 | 54.15 | 24240.0 |
| 2019-09-16 05:15:00 | AAPL | Stock | 54.1 | 54.1 | 54.1 | 54.1 | 2000.0 |
| 2019-09-16 05:25:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 20400.0 |
| 2019-09-16 05:35:00 | AAPL | Stock | 54.1275 | 54.1275 | 54.0925 | 54.0925 | 2000.0 |
| 2019-09-16 05:40:00 | AAPL | Stock | 54.15 | 54.1525 | 54.15 | 54.15 | 13600.0 |
| 2019-09-16 05:45:00 | AAPL | Stock | 54.15 | 54.15 | 54.15 | 54.15 | 800.0 |
| 2019-09-16 06:00:00 | AAPL | Stock | 54.175 | 54.2 | 54.1625 | 54.2 | 1600.0 |
| 2019-09-16 06:05:00 | AAPL | Stock | 54.2 | 54.2 | 54.2 | 54.2 | 2400.0 |
| 2019-09-16 06:10:00 | AAPL | Stock | 54.1925 | 54.265 | 54.1925 | 54.265 | 7220.0 |
| 2019-09-16 06:15:00 | AAPL | Stock | 54.25 | 54.25 | 54.25 | 54.25 | 800.0 |
| 2019-09-16 06:20:00 | AAPL | Stock | 54.235 | 54.3075 | 54.235 | 54.255 | 3200.0 |
| 2019-09-16 06:25:00 | AAPL | Stock | 54.265 | 54.31 | 54.25 | 54.31 | 5600.0 |
| 2019-09-16 06:30:00 | AAPL | Stock | 54.295 | 54.295 | 54.2125 | 54.25 | 6260.0 |
| 2019-09-16 06:35:00 | AAPL | Stock | 54.28 | 54.28 | 54.215 | 54.2175 | 1856.0 |
| 2019-09-16 06:40:00 | AAPL | Stock | 54.2525 | 54.2525 | 54.2525 | 54.2525 | 400.0 |
| 2019-09-16 06:45:00 | AAPL | Stock | 54.3125 | 54.3125 | 54.3125 | 54.3125 | 1200.0 |
| 2019-09-16 07:00:00 | AAPL | Stock | 54.255 | 54.295 | 54.225 | 54.225 | 22228.0 |
| 2019-09-16 07:05:00 | AAPL | Stock | 54.225 | 54.25 | 54.2 | 54.25 | 40120.0 |
| 2019-09-16 07:10:00 | AAPL | Stock | 54.3 | 54.3 | 54.2025 | 54.21 | 11440.0 |
| 2019-09-16 07:15:00 | AAPL | Stock | 54.2 | 54.2 | 54.15 | 54.165 | 19492.0 |
| 2019-09-16 07:20:00 | AAPL | Stock | 54.165 | 54.24 | 54.1575 | 54.24 | 12940.0 |
| 2019-09-16 07:25:00 | AAPL | Stock | 54.245 | 54.355 | 54.2425 | 54.35 | 30052.0 |
| 2019-09-16 07:30:00 | AAPL | Stock | 54.345 | 54.3875 | 54.325 | 54.3375 | 24760.0 |
| 2019-09-16 07:35:00 | AAPL | Stock | 54.35 | 54.4125 | 54.35 | 54.4125 | 30676.0 |
| 2019-09-16 07:40:00 | AAPL | Stock | 54.395 | 54.425 | 54.375 | 54.4 | 21628.0 |
| 2019-09-16 07:45:00 | AAPL | Stock | 54.3775 | 54.3875 | 54.375 | 54.3875 | 18628.0 |
| 2019-09-16 07:50:00 | AAPL | Stock | 54.375 | 54.385 | 54.375 | 54.385 | 4376.0 |
| 2019-09-16 07:55:00 | AAPL | Stock | 54.3875 | 54.45 | 54.3875 | 54.4475 | 12500.0 |
| 2019-09-16 08:00:00 | AAPL | Stock | 54.2005 | 54.485 | 54.15 | 54.4625 | 155912.0 |
| 2019-09-16 08:05:00 | AAPL | Stock | 54.44 | 54.46 | 54.4275 | 54.4575 | 13000.0 |
| 2019-09-16 08:10:00 | AAPL | Stock | 54.4775 | 54.525 | 54.475 | 54.4825 | 27620.0 |
| 2019-09-16 08:15:00 | AAPL | Stock | 54.5 | 54.5175 | 54.47 | 54.4875 | 18580.0 |
| 2019-09-16 08:20:00 | AAPL | Stock | 54.5175 | 54.5175 | 54.4025 | 54.4775 | 16808.0 |
| 2019-09-16 08:25:00 | AAPL | Stock | 54.47 | 54.5275 | 54.4125 | 54.45 | 19344.0 |
| 2019-09-16 08:30:00 | AAPL | Stock | 54.45 | 54.4765 | 54.3925 | 54.395 | 30804.0 |
| 2019-09-16 08:35:00 | AAPL | Stock | 54.4 | 54.465 | 54.375 | 54.455 | 14332.0 |
| 2019-09-16 08:40:00 | AAPL | Stock | 54.4675 | 54.48 | 54.4375 | 54.4375 | 9956.0 |
> showing 50 of 371,371 rows — these rows as CSV