PREVIEW / stock_5min / 2023-11-29
file: by_date/stock_5min/2023/2023-11-29.parquet size: 6.7 MB rows: 409,353 symbols: 1,292
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-29 04:00:00 | AAPL | Stock | 189.9 | 190.13 | 189.9 | 190.05 | 4015.0 |
| 2023-11-29 04:05:00 | AAPL | Stock | 190.1 | 190.14 | 189.91 | 189.91 | 1897.0 |
| 2023-11-29 04:10:00 | AAPL | Stock | 189.96 | 189.96 | 189.8 | 189.8 | 1206.0 |
| 2023-11-29 04:15:00 | AAPL | Stock | 189.9 | 189.91 | 189.9 | 189.91 | 2451.0 |
| 2023-11-29 04:20:00 | AAPL | Stock | 189.94 | 190.18 | 189.94 | 190.18 | 3509.0 |
| 2023-11-29 04:25:00 | AAPL | Stock | 190.18 | 190.18 | 190.18 | 190.18 | 450.0 |
| 2023-11-29 04:30:00 | AAPL | Stock | 190.15 | 190.25 | 190.14 | 190.25 | 4406.0 |
| 2023-11-29 04:40:00 | AAPL | Stock | 190.16 | 190.16 | 190.16 | 190.16 | 592.0 |
| 2023-11-29 04:45:00 | AAPL | Stock | 190.17 | 190.2 | 190.17 | 190.2 | 2646.0 |
| 2023-11-29 04:50:00 | AAPL | Stock | 190.29 | 190.29 | 190.28 | 190.29 | 1255.0 |
| 2023-11-29 04:55:00 | AAPL | Stock | 190.25 | 190.3 | 190.25 | 190.3 | 280.0 |
| 2023-11-29 05:00:00 | AAPL | Stock | 190.3 | 190.3 | 190.3 | 190.3 | 143.0 |
| 2023-11-29 05:05:00 | AAPL | Stock | 190.3 | 190.33 | 190.3 | 190.33 | 219.0 |
| 2023-11-29 05:10:00 | AAPL | Stock | 190.36 | 190.38 | 190.32 | 190.32 | 500.0 |
| 2023-11-29 05:20:00 | AAPL | Stock | 190.36 | 190.36 | 190.36 | 190.36 | 150.0 |
| 2023-11-29 05:35:00 | AAPL | Stock | 190.28 | 190.28 | 190.28 | 190.28 | 165.0 |
| 2023-11-29 05:40:00 | AAPL | Stock | 190.26 | 190.26 | 190.26 | 190.26 | 500.0 |
| 2023-11-29 05:45:00 | AAPL | Stock | 190.26 | 190.26 | 190.26 | 190.26 | 100.0 |
| 2023-11-29 06:00:00 | AAPL | Stock | 190.22 | 190.22 | 190.22 | 190.22 | 100.0 |
| 2023-11-29 06:05:00 | AAPL | Stock | 190.21 | 190.23 | 190.21 | 190.22 | 749.0 |
| 2023-11-29 06:10:00 | AAPL | Stock | 190.21 | 190.24 | 190.2 | 190.2 | 549.0 |
| 2023-11-29 06:15:00 | AAPL | Stock | 190.17 | 190.17 | 190.17 | 190.17 | 660.0 |
| 2023-11-29 06:20:00 | AAPL | Stock | 190.17 | 190.17 | 190.17 | 190.17 | 200.0 |
| 2023-11-29 06:30:00 | AAPL | Stock | 190.2 | 190.21 | 190.17 | 190.17 | 804.0 |
| 2023-11-29 06:40:00 | AAPL | Stock | 190.18 | 190.18 | 190.18 | 190.18 | 150.0 |
| 2023-11-29 06:45:00 | AAPL | Stock | 190.17 | 190.17 | 190.17 | 190.17 | 597.0 |
| 2023-11-29 06:50:00 | AAPL | Stock | 190.17 | 190.33 | 190.17 | 190.33 | 1872.0 |
| 2023-11-29 06:55:00 | AAPL | Stock | 190.35 | 190.46 | 190.35 | 190.46 | 1956.0 |
| 2023-11-29 07:00:00 | AAPL | Stock | 190.4 | 190.41 | 190.36 | 190.38 | 2574.0 |
| 2023-11-29 07:05:00 | AAPL | Stock | 190.4 | 190.4 | 190.3 | 190.36 | 1958.0 |
| 2023-11-29 07:10:00 | AAPL | Stock | 190.3 | 190.4 | 190.28 | 190.4 | 4031.0 |
| 2023-11-29 07:15:00 | AAPL | Stock | 190.44 | 190.63 | 190.44 | 190.51 | 12092.0 |
| 2023-11-29 07:20:00 | AAPL | Stock | 190.5 | 190.6 | 190.45 | 190.56 | 2116.0 |
| 2023-11-29 07:25:00 | AAPL | Stock | 190.55 | 190.68 | 190.55 | 190.57 | 2589.0 |
| 2023-11-29 07:30:00 | AAPL | Stock | 190.6 | 190.65 | 190.55 | 190.55 | 11781.0 |
| 2023-11-29 07:35:00 | AAPL | Stock | 190.55 | 190.6 | 190.5 | 190.5 | 6097.0 |
| 2023-11-29 07:40:00 | AAPL | Stock | 190.45 | 190.45 | 190.4 | 190.4 | 4902.0 |
| 2023-11-29 07:45:00 | AAPL | Stock | 190.39 | 190.39 | 190.32 | 190.35 | 2608.0 |
| 2023-11-29 07:50:00 | AAPL | Stock | 190.33 | 190.4 | 190.33 | 190.4 | 1881.0 |
| 2023-11-29 07:55:00 | AAPL | Stock | 190.4 | 190.47 | 190.4 | 190.47 | 10937.0 |
| 2023-11-29 08:00:00 | AAPL | Stock | 190.36 | 190.74 | 189.72 | 190.7 | 35173.0 |
| 2023-11-29 08:05:00 | AAPL | Stock | 190.68 | 190.75 | 190.65 | 190.65 | 5251.0 |
| 2023-11-29 08:10:00 | AAPL | Stock | 190.72 | 190.72 | 190.61 | 190.63 | 3550.0 |
| 2023-11-29 08:15:00 | AAPL | Stock | 190.62 | 190.68 | 190.59 | 190.59 | 2178.0 |
| 2023-11-29 08:20:00 | AAPL | Stock | 190.63 | 190.73 | 190.6 | 190.71 | 9153.0 |
| 2023-11-29 08:25:00 | AAPL | Stock | 190.67 | 191.03 | 190.5909 | 190.87 | 48702.0 |
| 2023-11-29 08:30:00 | AAPL | Stock | 190.86 | 190.96 | 190.8 | 190.8 | 8741.0 |
| 2023-11-29 08:35:00 | AAPL | Stock | 190.77 | 190.7899 | 190.65 | 190.7 | 6848.0 |
| 2023-11-29 08:40:00 | AAPL | Stock | 190.67 | 190.8 | 190.6416 | 190.75 | 9993.0 |
| 2023-11-29 08:45:00 | AAPL | Stock | 190.75 | 190.8378 | 190.75 | 190.75 | 1328.0 |
> showing 50 of 409,353 rows — these rows as CSV