PREVIEW / stock_5min / 2021-04-07
file: by_date/stock_5min/2021/2021-04-07.parquet size: 7.5 MB rows: 464,806 symbols: 2,955
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-07 04:00:00 | AAPL | Stock | 126.51 | 126.52 | 126.35 | 126.35 | 885.0 |
| 2021-04-07 04:05:00 | AAPL | Stock | 126.35 | 126.35 | 126.35 | 126.35 | 856.0 |
| 2021-04-07 04:10:00 | AAPL | Stock | 126.25 | 126.29 | 126.25 | 126.29 | 628.0 |
| 2021-04-07 04:15:00 | AAPL | Stock | 126.26 | 126.26 | 126.26 | 126.26 | 220.0 |
| 2021-04-07 04:20:00 | AAPL | Stock | 126.24 | 126.24 | 126.22 | 126.22 | 563.0 |
| 2021-04-07 04:30:00 | AAPL | Stock | 126.28 | 126.31 | 126.28 | 126.31 | 200.0 |
| 2021-04-07 04:40:00 | AAPL | Stock | 126.28 | 126.28 | 126.28 | 126.28 | 229.0 |
| 2021-04-07 04:45:00 | AAPL | Stock | 126.3 | 126.35 | 126.3 | 126.35 | 690.0 |
| 2021-04-07 04:50:00 | AAPL | Stock | 126.33 | 126.33 | 126.33 | 126.33 | 555.0 |
| 2021-04-07 04:55:00 | AAPL | Stock | 126.35 | 126.35 | 126.3 | 126.3 | 1142.0 |
| 2021-04-07 05:00:00 | AAPL | Stock | 126.35 | 126.4 | 126.35 | 126.4 | 378.0 |
| 2021-04-07 05:05:00 | AAPL | Stock | 126.48 | 126.48 | 126.48 | 126.48 | 539.0 |
| 2021-04-07 05:10:00 | AAPL | Stock | 126.4 | 126.45 | 126.4 | 126.45 | 200.0 |
| 2021-04-07 05:15:00 | AAPL | Stock | 126.41 | 126.41 | 126.3 | 126.3 | 4266.0 |
| 2021-04-07 05:20:00 | AAPL | Stock | 126.3 | 126.3 | 126.29 | 126.29 | 200.0 |
| 2021-04-07 05:25:00 | AAPL | Stock | 126.33 | 126.38 | 126.33 | 126.38 | 1750.0 |
| 2021-04-07 05:30:00 | AAPL | Stock | 126.31 | 126.31 | 126.2 | 126.2 | 1155.0 |
| 2021-04-07 05:35:00 | AAPL | Stock | 126.21 | 126.24 | 126.19 | 126.19 | 1861.0 |
| 2021-04-07 05:40:00 | AAPL | Stock | 126.19 | 126.21 | 126.19 | 126.21 | 1001.0 |
| 2021-04-07 05:45:00 | AAPL | Stock | 126.25 | 126.25 | 126.25 | 126.25 | 100.0 |
| 2021-04-07 05:50:00 | AAPL | Stock | 126.27 | 126.27 | 126.27 | 126.27 | 404.0 |
| 2021-04-07 06:00:00 | AAPL | Stock | 126.22 | 126.22 | 126.21 | 126.22 | 800.0 |
| 2021-04-07 06:05:00 | AAPL | Stock | 126.34 | 126.34 | 126.34 | 126.34 | 100.0 |
| 2021-04-07 06:10:00 | AAPL | Stock | 126.4 | 126.5 | 126.4 | 126.5 | 1957.0 |
| 2021-04-07 06:20:00 | AAPL | Stock | 126.42 | 126.42 | 126.42 | 126.42 | 100.0 |
| 2021-04-07 06:25:00 | AAPL | Stock | 126.32 | 126.36 | 126.32 | 126.36 | 200.0 |
| 2021-04-07 06:30:00 | AAPL | Stock | 126.36 | 126.38 | 126.36 | 126.38 | 4552.0 |
| 2021-04-07 06:35:00 | AAPL | Stock | 126.36 | 126.38 | 126.36 | 126.38 | 471.0 |
| 2021-04-07 06:40:00 | AAPL | Stock | 126.38 | 126.38 | 126.38 | 126.38 | 1239.0 |
| 2021-04-07 06:45:00 | AAPL | Stock | 126.36 | 126.41 | 126.35 | 126.41 | 2771.0 |
| 2021-04-07 06:50:00 | AAPL | Stock | 126.45 | 126.45 | 126.42 | 126.42 | 746.0 |
| 2021-04-07 06:55:00 | AAPL | Stock | 126.4 | 126.4 | 126.4 | 126.4 | 406.0 |
| 2021-04-07 07:00:00 | AAPL | Stock | 126.36 | 126.5 | 126.35 | 126.43 | 24458.0 |
| 2021-04-07 07:05:00 | AAPL | Stock | 126.41 | 126.41 | 126.3 | 126.35 | 4403.0 |
| 2021-04-07 07:10:00 | AAPL | Stock | 126.37 | 126.44 | 126.37 | 126.43 | 2038.0 |
| 2021-04-07 07:15:00 | AAPL | Stock | 126.44 | 126.46 | 126.4 | 126.4 | 4837.0 |
| 2021-04-07 07:20:00 | AAPL | Stock | 126.42 | 126.42 | 126.21 | 126.22 | 10263.0 |
| 2021-04-07 07:25:00 | AAPL | Stock | 126.25 | 126.31 | 126.2 | 126.2 | 9938.0 |
| 2021-04-07 07:30:00 | AAPL | Stock | 126.26 | 126.33 | 126.25 | 126.31 | 3850.0 |
| 2021-04-07 07:35:00 | AAPL | Stock | 126.31 | 126.36 | 126.31 | 126.32 | 6304.0 |
| 2021-04-07 07:40:00 | AAPL | Stock | 126.35 | 126.42 | 126.35 | 126.36 | 6081.0 |
| 2021-04-07 07:45:00 | AAPL | Stock | 126.37 | 126.5 | 126.37 | 126.48 | 16220.0 |
| 2021-04-07 07:50:00 | AAPL | Stock | 126.47 | 126.47 | 126.37 | 126.4 | 4852.0 |
| 2021-04-07 07:55:00 | AAPL | Stock | 126.4 | 126.4 | 126.3 | 126.3 | 15442.0 |
| 2021-04-07 08:00:00 | AAPL | Stock | 126.4694 | 126.525 | 126.23 | 126.37 | 84066.0 |
| 2021-04-07 08:05:00 | AAPL | Stock | 126.37 | 126.5 | 126.37 | 126.47 | 28424.0 |
| 2021-04-07 08:10:00 | AAPL | Stock | 126.44 | 126.44 | 126.35 | 126.37 | 12993.0 |
| 2021-04-07 08:15:00 | AAPL | Stock | 126.38 | 126.38 | 126.21 | 126.3 | 27624.0 |
| 2021-04-07 08:20:00 | AAPL | Stock | 126.3 | 126.33 | 126.23 | 126.33 | 7815.0 |
| 2021-04-07 08:25:00 | AAPL | Stock | 126.3 | 126.32 | 126.26 | 126.3 | 4422.0 |
> showing 50 of 464,806 rows — these rows as CSV