PREVIEW / stock_5min / 2022-03-03
file: by_date/stock_5min/2022/2022-03-03.parquet size: 7.1 MB rows: 440,304 symbols: 2,523
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-03-03 04:00:00 | AAPL | Stock | 166.35 | 166.46 | 166.35 | 166.36 | 1013.0 |
| 2022-03-03 04:05:00 | AAPL | Stock | 166.35 | 166.35 | 166.05 | 166.05 | 2239.0 |
| 2022-03-03 04:10:00 | AAPL | Stock | 166.0 | 166.12 | 165.92 | 166.12 | 1247.0 |
| 2022-03-03 04:15:00 | AAPL | Stock | 166.17 | 166.32 | 166.17 | 166.32 | 855.0 |
| 2022-03-03 04:20:00 | AAPL | Stock | 166.34 | 166.34 | 166.15 | 166.15 | 546.0 |
| 2022-03-03 04:25:00 | AAPL | Stock | 166.32 | 166.32 | 166.32 | 166.32 | 125.0 |
| 2022-03-03 04:35:00 | AAPL | Stock | 166.16 | 166.16 | 166.16 | 166.16 | 260.0 |
| 2022-03-03 04:45:00 | AAPL | Stock | 166.4 | 166.4 | 166.4 | 166.4 | 124.0 |
| 2022-03-03 04:50:00 | AAPL | Stock | 166.43 | 166.43 | 166.41 | 166.41 | 544.0 |
| 2022-03-03 05:00:00 | AAPL | Stock | 166.41 | 166.41 | 166.3 | 166.3 | 740.0 |
| 2022-03-03 05:05:00 | AAPL | Stock | 166.3 | 166.31 | 166.13 | 166.13 | 842.0 |
| 2022-03-03 05:15:00 | AAPL | Stock | 166.21 | 166.21 | 166.12 | 166.12 | 466.0 |
| 2022-03-03 05:20:00 | AAPL | Stock | 166.12 | 166.12 | 166.02 | 166.06 | 1571.0 |
| 2022-03-03 05:35:00 | AAPL | Stock | 166.19 | 166.19 | 166.19 | 166.19 | 338.0 |
| 2022-03-03 05:40:00 | AAPL | Stock | 166.28 | 166.28 | 166.28 | 166.28 | 299.0 |
| 2022-03-03 06:00:00 | AAPL | Stock | 166.3 | 166.3 | 166.3 | 166.3 | 100.0 |
| 2022-03-03 06:15:00 | AAPL | Stock | 166.41 | 166.49 | 166.41 | 166.49 | 487.0 |
| 2022-03-03 06:20:00 | AAPL | Stock | 166.47 | 166.49 | 166.47 | 166.49 | 923.0 |
| 2022-03-03 06:25:00 | AAPL | Stock | 166.48 | 166.68 | 166.48 | 166.68 | 555.0 |
| 2022-03-03 06:30:00 | AAPL | Stock | 166.78 | 166.79 | 166.71 | 166.71 | 500.0 |
| 2022-03-03 06:40:00 | AAPL | Stock | 166.39 | 166.39 | 166.39 | 166.39 | 100.0 |
| 2022-03-03 06:45:00 | AAPL | Stock | 166.27 | 166.27 | 165.93 | 165.93 | 7058.0 |
| 2022-03-03 06:50:00 | AAPL | Stock | 166.09 | 166.09 | 166.08 | 166.08 | 517.0 |
| 2022-03-03 06:55:00 | AAPL | Stock | 166.16 | 166.16 | 166.16 | 166.16 | 225.0 |
| 2022-03-03 07:00:00 | AAPL | Stock | 166.23 | 166.4 | 166.21 | 166.4 | 4588.0 |
| 2022-03-03 07:05:00 | AAPL | Stock | 166.4 | 166.52 | 166.39 | 166.51 | 6588.0 |
| 2022-03-03 07:10:00 | AAPL | Stock | 166.5 | 166.54 | 166.48 | 166.54 | 1145.0 |
| 2022-03-03 07:15:00 | AAPL | Stock | 166.58 | 166.67 | 166.48 | 166.66 | 3987.0 |
| 2022-03-03 07:20:00 | AAPL | Stock | 166.65 | 166.7 | 166.63 | 166.7 | 7587.0 |
| 2022-03-03 07:25:00 | AAPL | Stock | 166.68 | 166.78 | 166.67 | 166.67 | 4341.0 |
| 2022-03-03 07:30:00 | AAPL | Stock | 166.71 | 166.75 | 166.59 | 166.75 | 2942.0 |
| 2022-03-03 07:35:00 | AAPL | Stock | 166.75 | 166.78 | 166.61 | 166.63 | 1742.0 |
| 2022-03-03 07:40:00 | AAPL | Stock | 166.64 | 166.68 | 166.62 | 166.64 | 3261.0 |
| 2022-03-03 07:45:00 | AAPL | Stock | 166.6 | 166.6 | 166.41 | 166.43 | 4918.0 |
| 2022-03-03 07:50:00 | AAPL | Stock | 166.48 | 166.56 | 166.48 | 166.51 | 1569.0 |
| 2022-03-03 07:55:00 | AAPL | Stock | 166.55 | 166.72 | 166.43 | 166.53 | 4237.0 |
| 2022-03-03 08:00:00 | AAPL | Stock | 166.77 | 167.55 | 166.144 | 166.73 | 75231.0 |
| 2022-03-03 08:05:00 | AAPL | Stock | 166.74 | 167.07 | 166.64 | 167.06 | 43499.0 |
| 2022-03-03 08:10:00 | AAPL | Stock | 167.0 | 167.08 | 167.0 | 167.05 | 19895.0 |
| 2022-03-03 08:15:00 | AAPL | Stock | 167.09 | 167.09 | 166.93 | 166.96 | 13984.0 |
| 2022-03-03 08:20:00 | AAPL | Stock | 166.95 | 167.24 | 166.94 | 167.21 | 59612.0 |
| 2022-03-03 08:25:00 | AAPL | Stock | 167.18 | 167.2699 | 167.142 | 167.17 | 30565.0 |
| 2022-03-03 08:30:00 | AAPL | Stock | 167.18 | 167.22 | 166.99 | 167.05 | 30300.0 |
| 2022-03-03 08:35:00 | AAPL | Stock | 167.04 | 167.32 | 167.02 | 167.2279 | 45194.0 |
| 2022-03-03 08:40:00 | AAPL | Stock | 167.23 | 167.33 | 167.17 | 167.31 | 31088.0 |
| 2022-03-03 08:45:00 | AAPL | Stock | 167.3 | 167.36 | 167.24 | 167.35 | 47016.0 |
| 2022-03-03 08:50:00 | AAPL | Stock | 167.3499 | 167.47 | 167.23 | 167.43 | 40780.0 |
| 2022-03-03 08:55:00 | AAPL | Stock | 167.4 | 167.96 | 167.4 | 167.86 | 111586.0 |
| 2022-03-03 09:00:00 | AAPL | Stock | 167.8599 | 168.46 | 167.84 | 168.17 | 157208.0 |
| 2022-03-03 09:05:00 | AAPL | Stock | 168.12 | 168.31 | 168.0 | 168.21 | 62953.0 |
> showing 50 of 440,304 rows — these rows as CSV