PREVIEW / stock_5min / 2019-09-18
file: by_date/stock_5min/2019/2019-09-18.parquet size: 5.7 MB rows: 362,091 symbols: 2,552
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-18 04:10:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 7852.0 |
| 2019-09-18 04:30:00 | AAPL | Stock | 55.2 | 55.2 | 55.2 | 55.2 | 400.0 |
| 2019-09-18 04:40:00 | AAPL | Stock | 55.25 | 55.25 | 55.2325 | 55.2325 | 800.0 |
| 2019-09-18 04:45:00 | AAPL | Stock | 55.25 | 55.25 | 55.25 | 55.25 | 6732.0 |
| 2019-09-18 05:20:00 | AAPL | Stock | 55.2 | 55.2 | 55.2 | 55.2 | 400.0 |
| 2019-09-18 05:25:00 | AAPL | Stock | 55.2225 | 55.23 | 55.2225 | 55.23 | 1392.0 |
| 2019-09-18 05:40:00 | AAPL | Stock | 55.1875 | 55.1875 | 55.1875 | 55.1875 | 400.0 |
| 2019-09-18 05:50:00 | AAPL | Stock | 55.225 | 55.2325 | 55.225 | 55.2325 | 3600.0 |
| 2019-09-18 06:05:00 | AAPL | Stock | 55.225 | 55.225 | 55.225 | 55.225 | 1936.0 |
| 2019-09-18 06:10:00 | AAPL | Stock | 55.1775 | 55.1775 | 55.16 | 55.16 | 4420.0 |
| 2019-09-18 06:15:00 | AAPL | Stock | 55.16 | 55.1625 | 55.125 | 55.125 | 2844.0 |
| 2019-09-18 06:20:00 | AAPL | Stock | 55.1175 | 55.1475 | 55.1175 | 55.1475 | 2476.0 |
| 2019-09-18 06:35:00 | AAPL | Stock | 55.175 | 55.205 | 55.175 | 55.175 | 2376.0 |
| 2019-09-18 07:00:00 | AAPL | Stock | 55.2 | 55.245 | 55.2 | 55.2375 | 9400.0 |
| 2019-09-18 07:05:00 | AAPL | Stock | 55.195 | 55.205 | 55.1475 | 55.1475 | 18204.0 |
| 2019-09-18 07:10:00 | AAPL | Stock | 55.1375 | 55.1625 | 55.1225 | 55.135 | 11028.0 |
| 2019-09-18 07:15:00 | AAPL | Stock | 55.125 | 55.125 | 55.12 | 55.12 | 2800.0 |
| 2019-09-18 07:20:00 | AAPL | Stock | 55.1425 | 55.1425 | 55.1425 | 55.1425 | 2000.0 |
| 2019-09-18 07:25:00 | AAPL | Stock | 55.1425 | 55.15 | 55.1425 | 55.15 | 2996.0 |
| 2019-09-18 07:30:00 | AAPL | Stock | 55.1725 | 55.215 | 55.17 | 55.17 | 15284.0 |
| 2019-09-18 07:35:00 | AAPL | Stock | 55.17 | 55.175 | 55.15 | 55.15 | 11828.0 |
| 2019-09-18 07:40:00 | AAPL | Stock | 55.1275 | 55.1275 | 55.0125 | 55.105 | 32356.0 |
| 2019-09-18 07:45:00 | AAPL | Stock | 55.1475 | 55.1475 | 55.14 | 55.14 | 3580.0 |
| 2019-09-18 07:50:00 | AAPL | Stock | 55.1625 | 55.175 | 55.1625 | 55.17 | 3876.0 |
| 2019-09-18 07:55:00 | AAPL | Stock | 55.17 | 55.17 | 55.125 | 55.125 | 4972.0 |
| 2019-09-18 08:00:00 | AAPL | Stock | 55.175 | 55.245 | 55.1125 | 55.1975 | 39516.0 |
| 2019-09-18 08:05:00 | AAPL | Stock | 55.175 | 55.205 | 55.17 | 55.205 | 4112.0 |
| 2019-09-18 08:10:00 | AAPL | Stock | 55.2 | 55.2225 | 55.2 | 55.2225 | 12640.0 |
| 2019-09-18 08:15:00 | AAPL | Stock | 55.2225 | 55.225 | 55.21 | 55.2125 | 5996.0 |
| 2019-09-18 08:20:00 | AAPL | Stock | 55.2175 | 55.2175 | 55.215 | 55.2175 | 2172.0 |
| 2019-09-18 08:25:00 | AAPL | Stock | 55.225 | 55.2375 | 55.2175 | 55.22 | 10980.0 |
| 2019-09-18 08:30:00 | AAPL | Stock | 55.2375 | 55.275 | 55.2375 | 55.275 | 21728.0 |
| 2019-09-18 08:35:00 | AAPL | Stock | 55.295 | 55.3375 | 55.2875 | 55.3275 | 59064.0 |
| 2019-09-18 08:40:00 | AAPL | Stock | 55.325 | 55.3275 | 55.2875 | 55.3 | 14500.0 |
| 2019-09-18 08:45:00 | AAPL | Stock | 55.3125 | 55.3275 | 55.3 | 55.3275 | 12696.0 |
| 2019-09-18 08:50:00 | AAPL | Stock | 55.3125 | 55.3375 | 55.3 | 55.31 | 22352.0 |
| 2019-09-18 08:55:00 | AAPL | Stock | 55.31 | 55.3225 | 55.31 | 55.3125 | 2000.0 |
| 2019-09-18 09:00:00 | AAPL | Stock | 55.32 | 55.325 | 55.3075 | 55.325 | 4444.0 |
| 2019-09-18 09:05:00 | AAPL | Stock | 55.3075 | 55.325 | 55.3 | 55.305 | 16328.0 |
| 2019-09-18 09:10:00 | AAPL | Stock | 55.295 | 55.3125 | 55.2925 | 55.3125 | 6924.0 |
| 2019-09-18 09:15:00 | AAPL | Stock | 55.315 | 55.32 | 55.3125 | 55.3175 | 15952.0 |
| 2019-09-18 09:20:00 | AAPL | Stock | 55.3175 | 55.35 | 55.3175 | 55.34 | 17496.0 |
| 2019-09-18 09:25:00 | AAPL | Stock | 55.325 | 55.325 | 55.255 | 55.2625 | 73428.0 |
| 2019-09-18 09:30:00 | AAPL | Stock | 55.2825 | 55.4225 | 55.17 | 55.3825 | 3923992.0 |
| 2019-09-18 09:35:00 | AAPL | Stock | 55.3825 | 55.5275 | 55.35 | 55.4825 | 2469028.0 |
| 2019-09-18 09:40:00 | AAPL | Stock | 55.48 | 55.5075 | 55.3375 | 55.3812 | 1374724.0 |
| 2019-09-18 09:45:00 | AAPL | Stock | 55.3875 | 55.47 | 55.315 | 55.435 | 1394152.0 |
| 2019-09-18 09:50:00 | AAPL | Stock | 55.44 | 55.4825 | 55.3975 | 55.4525 | 1488488.0 |
| 2019-09-18 09:55:00 | AAPL | Stock | 55.455 | 55.525 | 55.45 | 55.465 | 1523080.0 |
| 2019-09-18 10:00:00 | AAPL | Stock | 55.4648 | 55.56 | 55.46 | 55.535 | 1459536.0 |
> showing 50 of 362,091 rows — these rows as CSV