PREVIEW / stock_5min / 2020-09-24
file: by_date/stock_5min/2020/2020-09-24.parquet size: 6.6 MB rows: 416,883 symbols: 2,496
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-09-24 04:00:00 | AAPL | Stock | 106.5 | 106.85 | 106.28 | 106.28 | 15537.0 |
| 2020-09-24 04:05:00 | AAPL | Stock | 106.25 | 106.35 | 106.2 | 106.2 | 4137.0 |
| 2020-09-24 04:10:00 | AAPL | Stock | 106.35 | 106.35 | 106.0 | 106.0 | 8287.0 |
| 2020-09-24 04:15:00 | AAPL | Stock | 105.92 | 106.05 | 105.82 | 106.05 | 6689.0 |
| 2020-09-24 04:20:00 | AAPL | Stock | 106.05 | 106.18 | 106.05 | 106.1 | 2394.0 |
| 2020-09-24 04:25:00 | AAPL | Stock | 106.22 | 106.5 | 106.22 | 106.49 | 3126.0 |
| 2020-09-24 04:30:00 | AAPL | Stock | 106.44 | 106.55 | 106.35 | 106.55 | 1160.0 |
| 2020-09-24 04:35:00 | AAPL | Stock | 106.52 | 106.6 | 106.46 | 106.46 | 6626.0 |
| 2020-09-24 04:40:00 | AAPL | Stock | 106.45 | 106.53 | 106.4 | 106.4 | 1091.0 |
| 2020-09-24 04:45:00 | AAPL | Stock | 106.41 | 106.41 | 106.25 | 106.25 | 6695.0 |
| 2020-09-24 04:50:00 | AAPL | Stock | 106.12 | 106.25 | 106.04 | 106.19 | 1052.0 |
| 2020-09-24 04:55:00 | AAPL | Stock | 106.25 | 106.31 | 106.18 | 106.31 | 1263.0 |
| 2020-09-24 05:00:00 | AAPL | Stock | 106.25 | 106.25 | 106.08 | 106.1 | 1304.0 |
| 2020-09-24 05:05:00 | AAPL | Stock | 106.1 | 106.1 | 105.9 | 105.9 | 3950.0 |
| 2020-09-24 05:10:00 | AAPL | Stock | 105.93 | 106.25 | 105.93 | 106.1 | 5637.0 |
| 2020-09-24 05:15:00 | AAPL | Stock | 106.14 | 106.18 | 106.14 | 106.18 | 381.0 |
| 2020-09-24 05:20:00 | AAPL | Stock | 106.2 | 106.25 | 106.2 | 106.25 | 269.0 |
| 2020-09-24 05:25:00 | AAPL | Stock | 106.25 | 106.28 | 106.25 | 106.25 | 2224.0 |
| 2020-09-24 05:30:00 | AAPL | Stock | 106.23 | 106.3 | 105.99 | 105.99 | 4938.0 |
| 2020-09-24 05:35:00 | AAPL | Stock | 106.09 | 106.09 | 106.04 | 106.06 | 1456.0 |
| 2020-09-24 05:40:00 | AAPL | Stock | 106.06 | 106.1 | 105.93 | 106.1 | 1644.0 |
| 2020-09-24 05:45:00 | AAPL | Stock | 106.13 | 106.13 | 106.1 | 106.13 | 938.0 |
| 2020-09-24 05:50:00 | AAPL | Stock | 106.08 | 106.13 | 106.08 | 106.13 | 277.0 |
| 2020-09-24 05:55:00 | AAPL | Stock | 105.98 | 106.09 | 105.98 | 106.09 | 434.0 |
| 2020-09-24 06:00:00 | AAPL | Stock | 106.19 | 106.6 | 106.19 | 106.56 | 3769.0 |
| 2020-09-24 06:05:00 | AAPL | Stock | 106.56 | 106.79 | 106.56 | 106.65 | 6554.0 |
| 2020-09-24 06:10:00 | AAPL | Stock | 106.66 | 106.7 | 106.6 | 106.6 | 3449.0 |
| 2020-09-24 06:15:00 | AAPL | Stock | 106.6 | 106.6 | 106.56 | 106.6 | 2518.0 |
| 2020-09-24 06:20:00 | AAPL | Stock | 106.59 | 106.6 | 106.53 | 106.59 | 2060.0 |
| 2020-09-24 06:25:00 | AAPL | Stock | 106.59 | 106.59 | 106.54 | 106.54 | 1863.0 |
| 2020-09-24 06:30:00 | AAPL | Stock | 106.54 | 106.54 | 106.4 | 106.5 | 3653.0 |
| 2020-09-24 06:35:00 | AAPL | Stock | 106.57 | 107.01 | 106.57 | 106.87 | 9198.0 |
| 2020-09-24 06:40:00 | AAPL | Stock | 106.87 | 106.94 | 106.67 | 106.74 | 2179.0 |
| 2020-09-24 06:45:00 | AAPL | Stock | 106.75 | 106.75 | 106.5 | 106.51 | 6607.0 |
| 2020-09-24 06:50:00 | AAPL | Stock | 106.5 | 106.67 | 106.36 | 106.67 | 1974.0 |
| 2020-09-24 06:55:00 | AAPL | Stock | 106.78 | 106.8 | 106.53 | 106.55 | 2419.0 |
| 2020-09-24 07:00:00 | AAPL | Stock | 106.53 | 106.68 | 106.3 | 106.55 | 53073.0 |
| 2020-09-24 07:05:00 | AAPL | Stock | 106.54 | 106.54 | 106.31 | 106.4 | 17178.0 |
| 2020-09-24 07:10:00 | AAPL | Stock | 106.4 | 106.5 | 106.33 | 106.37 | 14241.0 |
| 2020-09-24 07:15:00 | AAPL | Stock | 106.39 | 106.4 | 106.26 | 106.31 | 12417.0 |
| 2020-09-24 07:20:00 | AAPL | Stock | 106.33 | 106.37 | 106.2 | 106.31 | 23288.0 |
| 2020-09-24 07:25:00 | AAPL | Stock | 106.31 | 106.54 | 106.29 | 106.49 | 16379.0 |
| 2020-09-24 07:30:00 | AAPL | Stock | 106.52 | 106.63 | 106.34 | 106.41 | 31912.0 |
| 2020-09-24 07:35:00 | AAPL | Stock | 106.45 | 106.55 | 106.41 | 106.44 | 13492.0 |
| 2020-09-24 07:40:00 | AAPL | Stock | 106.43 | 106.51 | 106.2 | 106.2 | 32776.0 |
| 2020-09-24 07:45:00 | AAPL | Stock | 106.2 | 106.3 | 106.12 | 106.16 | 27400.0 |
| 2020-09-24 07:50:00 | AAPL | Stock | 106.15 | 106.25 | 106.0 | 106.0 | 41978.0 |
| 2020-09-24 07:55:00 | AAPL | Stock | 106.0 | 106.0 | 105.83 | 105.91 | 36918.0 |
| 2020-09-24 08:00:00 | AAPL | Stock | 106.431 | 106.6 | 105.7 | 105.702 | 283714.0 |
| 2020-09-24 08:05:00 | AAPL | Stock | 105.7 | 105.73 | 105.53 | 105.73 | 94227.0 |
> showing 50 of 416,883 rows — these rows as CSV