PREVIEW / stock_5min / 2022-12-09
file: by_date/stock_5min/2022/2022-12-09.parquet size: 6.7 MB rows: 412,728 symbols: 2,028
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-09 04:00:00 | AAPL | Stock | 143.69 | 143.69 | 143.0 | 143.28 | 3954.0 |
| 2022-12-09 04:05:00 | AAPL | Stock | 143.34 | 143.45 | 143.26 | 143.45 | 1298.0 |
| 2022-12-09 04:10:00 | AAPL | Stock | 143.39 | 143.39 | 143.39 | 143.39 | 100.0 |
| 2022-12-09 04:15:00 | AAPL | Stock | 143.45 | 143.48 | 143.44 | 143.48 | 702.0 |
| 2022-12-09 04:20:00 | AAPL | Stock | 143.43 | 143.43 | 143.38 | 143.43 | 319.0 |
| 2022-12-09 04:25:00 | AAPL | Stock | 143.38 | 143.38 | 143.38 | 143.38 | 120.0 |
| 2022-12-09 04:30:00 | AAPL | Stock | 143.32 | 143.32 | 143.26 | 143.29 | 531.0 |
| 2022-12-09 04:35:00 | AAPL | Stock | 143.28 | 143.29 | 143.23 | 143.23 | 1569.0 |
| 2022-12-09 04:40:00 | AAPL | Stock | 143.21 | 143.21 | 143.15 | 143.15 | 1225.0 |
| 2022-12-09 04:45:00 | AAPL | Stock | 143.19 | 143.19 | 143.19 | 143.19 | 100.0 |
| 2022-12-09 04:50:00 | AAPL | Stock | 143.21 | 143.21 | 143.19 | 143.21 | 1810.0 |
| 2022-12-09 04:55:00 | AAPL | Stock | 143.2 | 143.2 | 143.2 | 143.2 | 151.0 |
| 2022-12-09 05:00:00 | AAPL | Stock | 143.13 | 143.15 | 142.97 | 143.13 | 4493.0 |
| 2022-12-09 05:05:00 | AAPL | Stock | 143.11 | 143.14 | 143.01 | 143.01 | 1412.0 |
| 2022-12-09 05:10:00 | AAPL | Stock | 143.1 | 143.1 | 143.1 | 143.1 | 100.0 |
| 2022-12-09 05:15:00 | AAPL | Stock | 143.03 | 143.09 | 143.03 | 143.09 | 2435.0 |
| 2022-12-09 05:20:00 | AAPL | Stock | 143.15 | 143.15 | 143.15 | 143.15 | 200.0 |
| 2022-12-09 05:25:00 | AAPL | Stock | 143.16 | 143.2 | 143.16 | 143.2 | 1316.0 |
| 2022-12-09 05:40:00 | AAPL | Stock | 143.23 | 143.24 | 143.23 | 143.24 | 708.0 |
| 2022-12-09 05:45:00 | AAPL | Stock | 143.24 | 143.24 | 143.24 | 143.24 | 376.0 |
| 2022-12-09 05:50:00 | AAPL | Stock | 143.2 | 143.2 | 143.2 | 143.2 | 100.0 |
| 2022-12-09 05:55:00 | AAPL | Stock | 143.27 | 143.38 | 143.27 | 143.35 | 1997.0 |
| 2022-12-09 06:00:00 | AAPL | Stock | 143.35 | 143.49 | 143.35 | 143.49 | 2500.0 |
| 2022-12-09 06:05:00 | AAPL | Stock | 143.35 | 143.35 | 143.34 | 143.34 | 323.0 |
| 2022-12-09 06:10:00 | AAPL | Stock | 143.37 | 143.49 | 143.37 | 143.44 | 10667.0 |
| 2022-12-09 06:15:00 | AAPL | Stock | 143.45 | 143.47 | 143.45 | 143.47 | 1748.0 |
| 2022-12-09 06:20:00 | AAPL | Stock | 143.46 | 143.47 | 143.46 | 143.47 | 1867.0 |
| 2022-12-09 06:25:00 | AAPL | Stock | 143.47 | 143.49 | 143.47 | 143.49 | 3693.0 |
| 2022-12-09 06:30:00 | AAPL | Stock | 143.59 | 143.6 | 143.5 | 143.6 | 4176.0 |
| 2022-12-09 06:35:00 | AAPL | Stock | 143.5 | 143.5 | 143.5 | 143.5 | 150.0 |
| 2022-12-09 06:40:00 | AAPL | Stock | 143.47 | 143.47 | 143.47 | 143.47 | 200.0 |
| 2022-12-09 06:45:00 | AAPL | Stock | 143.45 | 143.5 | 143.45 | 143.5 | 2067.0 |
| 2022-12-09 06:50:00 | AAPL | Stock | 143.59 | 143.72 | 143.59 | 143.72 | 2400.0 |
| 2022-12-09 06:55:00 | AAPL | Stock | 143.64 | 143.64 | 143.61 | 143.61 | 1342.0 |
| 2022-12-09 07:00:00 | AAPL | Stock | 143.64 | 143.69 | 143.55 | 143.65 | 8190.0 |
| 2022-12-09 07:05:00 | AAPL | Stock | 143.68 | 143.83 | 143.68 | 143.82 | 9228.0 |
| 2022-12-09 07:10:00 | AAPL | Stock | 143.84 | 143.9 | 143.7 | 143.78 | 16474.0 |
| 2022-12-09 07:15:00 | AAPL | Stock | 143.8 | 143.8 | 143.75 | 143.76 | 2479.0 |
| 2022-12-09 07:20:00 | AAPL | Stock | 143.78 | 143.94 | 143.78 | 143.94 | 4147.0 |
| 2022-12-09 07:25:00 | AAPL | Stock | 143.93 | 143.98 | 143.89 | 143.97 | 3279.0 |
| 2022-12-09 07:30:00 | AAPL | Stock | 143.97 | 144.1 | 143.97 | 144.03 | 3418.0 |
| 2022-12-09 07:35:00 | AAPL | Stock | 144.0 | 144.02 | 143.96 | 143.97 | 1994.0 |
| 2022-12-09 07:40:00 | AAPL | Stock | 143.99 | 144.06 | 143.94 | 143.94 | 7676.0 |
| 2022-12-09 07:45:00 | AAPL | Stock | 143.94 | 144.01 | 143.94 | 144.0 | 6287.0 |
| 2022-12-09 07:50:00 | AAPL | Stock | 143.98 | 144.0 | 143.98 | 143.98 | 2000.0 |
| 2022-12-09 07:55:00 | AAPL | Stock | 143.99 | 144.12 | 143.98 | 144.03 | 6691.0 |
| 2022-12-09 08:00:00 | AAPL | Stock | 143.6492 | 144.1 | 142.294 | 144.0295 | 68028.0 |
| 2022-12-09 08:05:00 | AAPL | Stock | 144.01 | 144.07 | 144.0 | 144.0 | 16534.0 |
| 2022-12-09 08:10:00 | AAPL | Stock | 144.01 | 144.01 | 143.86 | 143.92 | 8342.0 |
| 2022-12-09 08:15:00 | AAPL | Stock | 143.92 | 143.92 | 143.84 | 143.87 | 10407.0 |
> showing 50 of 412,728 rows — these rows as CSV