PREVIEW / stock_5min / 2020-06-03
file: by_date/stock_5min/2020/2020-06-03.parquet size: 6.8 MB rows: 424,232 symbols: 2,394
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-06-03 04:00:00 | AAPL | Stock | 81.125 | 81.25 | 81.075 | 81.2475 | 14072.0 |
| 2020-06-03 04:05:00 | AAPL | Stock | 81.15 | 81.225 | 81.125 | 81.1575 | 3832.0 |
| 2020-06-03 04:15:00 | AAPL | Stock | 81.15 | 81.15 | 81.15 | 81.15 | 3060.0 |
| 2020-06-03 04:20:00 | AAPL | Stock | 81.1875 | 81.1875 | 81.1875 | 81.1875 | 1856.0 |
| 2020-06-03 04:25:00 | AAPL | Stock | 81.2125 | 81.3725 | 81.2075 | 81.3725 | 5560.0 |
| 2020-06-03 04:30:00 | AAPL | Stock | 81.3725 | 81.3725 | 81.3725 | 81.3725 | 664.0 |
| 2020-06-03 04:35:00 | AAPL | Stock | 81.3575 | 81.4125 | 81.3575 | 81.4125 | 3600.0 |
| 2020-06-03 04:45:00 | AAPL | Stock | 81.2775 | 81.2775 | 81.275 | 81.275 | 6572.0 |
| 2020-06-03 05:00:00 | AAPL | Stock | 81.345 | 81.345 | 81.345 | 81.345 | 800.0 |
| 2020-06-03 05:10:00 | AAPL | Stock | 81.275 | 81.275 | 81.275 | 81.275 | 5104.0 |
| 2020-06-03 05:15:00 | AAPL | Stock | 81.32 | 81.3225 | 81.32 | 81.3225 | 1200.0 |
| 2020-06-03 05:25:00 | AAPL | Stock | 81.3725 | 81.3725 | 81.3725 | 81.3725 | 400.0 |
| 2020-06-03 05:30:00 | AAPL | Stock | 81.3575 | 81.3575 | 81.3575 | 81.3575 | 1200.0 |
| 2020-06-03 05:35:00 | AAPL | Stock | 81.3575 | 81.3575 | 81.3575 | 81.3575 | 1956.0 |
| 2020-06-03 05:40:00 | AAPL | Stock | 81.3725 | 81.3725 | 81.3725 | 81.3725 | 800.0 |
| 2020-06-03 06:00:00 | AAPL | Stock | 81.26 | 81.275 | 81.2575 | 81.275 | 2060.0 |
| 2020-06-03 06:05:00 | AAPL | Stock | 81.2575 | 81.2575 | 81.25 | 81.25 | 12472.0 |
| 2020-06-03 06:10:00 | AAPL | Stock | 81.3 | 81.3125 | 81.3 | 81.3125 | 1600.0 |
| 2020-06-03 06:15:00 | AAPL | Stock | 81.25 | 81.25 | 81.25 | 81.25 | 2180.0 |
| 2020-06-03 06:20:00 | AAPL | Stock | 81.2325 | 81.2325 | 81.2325 | 81.2325 | 2720.0 |
| 2020-06-03 06:25:00 | AAPL | Stock | 81.225 | 81.25 | 81.225 | 81.25 | 7652.0 |
| 2020-06-03 06:35:00 | AAPL | Stock | 81.25 | 81.315 | 81.2475 | 81.3 | 17008.0 |
| 2020-06-03 06:40:00 | AAPL | Stock | 81.2825 | 81.2825 | 81.2825 | 81.2825 | 532.0 |
| 2020-06-03 06:45:00 | AAPL | Stock | 81.2825 | 81.2825 | 81.2825 | 81.2825 | 400.0 |
| 2020-06-03 06:50:00 | AAPL | Stock | 81.28 | 81.2825 | 81.275 | 81.275 | 4000.0 |
| 2020-06-03 06:55:00 | AAPL | Stock | 81.2525 | 81.275 | 81.2025 | 81.22 | 9536.0 |
| 2020-06-03 07:00:00 | AAPL | Stock | 81.195 | 81.235 | 81.1225 | 81.19 | 49104.0 |
| 2020-06-03 07:05:00 | AAPL | Stock | 81.2 | 81.2 | 81.125 | 81.1625 | 33700.0 |
| 2020-06-03 07:10:00 | AAPL | Stock | 81.2075 | 81.225 | 81.2075 | 81.225 | 4104.0 |
| 2020-06-03 07:15:00 | AAPL | Stock | 81.215 | 81.245 | 81.215 | 81.23 | 14836.0 |
| 2020-06-03 07:20:00 | AAPL | Stock | 81.23 | 81.2325 | 81.1 | 81.1 | 11584.0 |
| 2020-06-03 07:25:00 | AAPL | Stock | 81.18 | 81.1825 | 81.1325 | 81.18 | 8836.0 |
| 2020-06-03 07:30:00 | AAPL | Stock | 81.165 | 81.165 | 81.0875 | 81.0875 | 6032.0 |
| 2020-06-03 07:35:00 | AAPL | Stock | 81.0875 | 81.1125 | 81.075 | 81.1125 | 5520.0 |
| 2020-06-03 07:40:00 | AAPL | Stock | 81.1125 | 81.1625 | 81.1125 | 81.1625 | 8564.0 |
| 2020-06-03 07:45:00 | AAPL | Stock | 81.175 | 81.31 | 81.175 | 81.2775 | 74436.0 |
| 2020-06-03 07:50:00 | AAPL | Stock | 81.28 | 81.31 | 81.25 | 81.31 | 21668.0 |
| 2020-06-03 07:55:00 | AAPL | Stock | 81.3 | 81.3125 | 81.25 | 81.25 | 10276.0 |
| 2020-06-03 08:00:00 | AAPL | Stock | 81.1718 | 81.3125 | 81.075 | 81.25 | 107776.0 |
| 2020-06-03 08:05:00 | AAPL | Stock | 81.225 | 81.225 | 81.16 | 81.2 | 15712.0 |
| 2020-06-03 08:10:00 | AAPL | Stock | 81.1975 | 81.25 | 81.1975 | 81.25 | 13140.0 |
| 2020-06-03 08:15:00 | AAPL | Stock | 81.25 | 81.2825 | 81.2125 | 81.2475 | 34384.0 |
| 2020-06-03 08:20:00 | AAPL | Stock | 81.245 | 81.25 | 81.15 | 81.21 | 16984.0 |
| 2020-06-03 08:25:00 | AAPL | Stock | 81.2425 | 81.25 | 81.215 | 81.225 | 18240.0 |
| 2020-06-03 08:30:00 | AAPL | Stock | 81.19 | 81.2175 | 81.1625 | 81.1825 | 16380.0 |
| 2020-06-03 08:35:00 | AAPL | Stock | 81.1625 | 81.19 | 81.0725 | 81.0875 | 68516.0 |
| 2020-06-03 08:40:00 | AAPL | Stock | 81.0875 | 81.0875 | 80.875 | 80.9725 | 69600.0 |
| 2020-06-03 08:45:00 | AAPL | Stock | 80.9725 | 81.0275 | 80.9725 | 81.0225 | 49228.0 |
| 2020-06-03 08:50:00 | AAPL | Stock | 81.0075 | 81.065 | 80.98 | 81.0575 | 36756.0 |
| 2020-06-03 08:55:00 | AAPL | Stock | 81.0825 | 81.0875 | 81.005 | 81.045 | 23880.0 |
> showing 50 of 424,232 rows — these rows as CSV