PREVIEW / stock_5min / 2023-03-30
file: by_date/stock_5min/2023/2023-03-30.parquet size: 6.7 MB rows: 409,778 symbols: 1,722
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-03-30 04:00:00 | AAPL | Stock | 161.15 | 161.15 | 160.9 | 160.9 | 1102.0 |
| 2023-03-30 04:10:00 | AAPL | Stock | 160.86 | 161.0 | 160.86 | 161.0 | 771.0 |
| 2023-03-30 04:15:00 | AAPL | Stock | 161.03 | 161.14 | 161.01 | 161.14 | 700.0 |
| 2023-03-30 04:20:00 | AAPL | Stock | 161.0 | 161.0 | 160.92 | 160.92 | 814.0 |
| 2023-03-30 04:25:00 | AAPL | Stock | 160.86 | 160.86 | 160.86 | 160.86 | 450.0 |
| 2023-03-30 04:30:00 | AAPL | Stock | 160.9 | 160.93 | 160.9 | 160.93 | 440.0 |
| 2023-03-30 04:35:00 | AAPL | Stock | 160.94 | 160.96 | 160.94 | 160.96 | 251.0 |
| 2023-03-30 04:40:00 | AAPL | Stock | 160.99 | 160.99 | 160.99 | 160.99 | 130.0 |
| 2023-03-30 04:45:00 | AAPL | Stock | 160.95 | 160.95 | 160.95 | 160.95 | 300.0 |
| 2023-03-30 05:00:00 | AAPL | Stock | 160.94 | 160.94 | 160.94 | 160.94 | 100.0 |
| 2023-03-30 05:05:00 | AAPL | Stock | 160.9 | 160.9 | 160.9 | 160.9 | 100.0 |
| 2023-03-30 05:10:00 | AAPL | Stock | 160.92 | 160.92 | 160.92 | 160.92 | 100.0 |
| 2023-03-30 05:20:00 | AAPL | Stock | 160.9 | 160.92 | 160.9 | 160.92 | 329.0 |
| 2023-03-30 05:25:00 | AAPL | Stock | 160.92 | 161.08 | 160.92 | 161.08 | 5269.0 |
| 2023-03-30 05:30:00 | AAPL | Stock | 160.99 | 161.0 | 160.95 | 161.0 | 749.0 |
| 2023-03-30 05:35:00 | AAPL | Stock | 160.99 | 161.0 | 160.99 | 160.99 | 1563.0 |
| 2023-03-30 05:40:00 | AAPL | Stock | 160.92 | 160.92 | 160.92 | 160.92 | 357.0 |
| 2023-03-30 05:45:00 | AAPL | Stock | 160.94 | 160.94 | 160.94 | 160.94 | 496.0 |
| 2023-03-30 05:55:00 | AAPL | Stock | 161.04 | 161.04 | 161.0 | 161.04 | 2119.0 |
| 2023-03-30 06:00:00 | AAPL | Stock | 161.04 | 161.06 | 160.98 | 160.98 | 986.0 |
| 2023-03-30 06:05:00 | AAPL | Stock | 160.95 | 161.06 | 160.95 | 161.03 | 708.0 |
| 2023-03-30 06:10:00 | AAPL | Stock | 161.07 | 161.07 | 161.07 | 161.07 | 210.0 |
| 2023-03-30 06:15:00 | AAPL | Stock | 161.03 | 161.03 | 160.99 | 160.99 | 200.0 |
| 2023-03-30 06:20:00 | AAPL | Stock | 161.05 | 161.12 | 161.05 | 161.12 | 3201.0 |
| 2023-03-30 06:30:00 | AAPL | Stock | 161.13 | 161.15 | 161.13 | 161.14 | 557.0 |
| 2023-03-30 06:35:00 | AAPL | Stock | 161.15 | 161.15 | 161.15 | 161.15 | 1057.0 |
| 2023-03-30 06:40:00 | AAPL | Stock | 161.08 | 161.29 | 161.08 | 161.29 | 1327.0 |
| 2023-03-30 06:45:00 | AAPL | Stock | 161.27 | 161.28 | 161.2 | 161.2 | 6053.0 |
| 2023-03-30 06:50:00 | AAPL | Stock | 161.17 | 161.17 | 161.17 | 161.17 | 200.0 |
| 2023-03-30 06:55:00 | AAPL | Stock | 161.26 | 161.29 | 161.26 | 161.26 | 1287.0 |
| 2023-03-30 07:00:00 | AAPL | Stock | 161.2 | 161.38 | 161.09 | 161.38 | 25466.0 |
| 2023-03-30 07:05:00 | AAPL | Stock | 161.37 | 161.43 | 161.35 | 161.43 | 6593.0 |
| 2023-03-30 07:10:00 | AAPL | Stock | 161.4 | 161.43 | 161.4 | 161.43 | 3113.0 |
| 2023-03-30 07:15:00 | AAPL | Stock | 161.42 | 161.42 | 161.3 | 161.3 | 6948.0 |
| 2023-03-30 07:20:00 | AAPL | Stock | 161.31 | 161.34 | 161.31 | 161.34 | 1753.0 |
| 2023-03-30 07:25:00 | AAPL | Stock | 161.4 | 161.47 | 161.4 | 161.47 | 1700.0 |
| 2023-03-30 07:30:00 | AAPL | Stock | 161.45 | 161.45 | 161.39 | 161.39 | 2100.0 |
| 2023-03-30 07:35:00 | AAPL | Stock | 161.39 | 161.44 | 161.38 | 161.4 | 3888.0 |
| 2023-03-30 07:40:00 | AAPL | Stock | 161.36 | 161.36 | 161.33 | 161.35 | 3672.0 |
| 2023-03-30 07:45:00 | AAPL | Stock | 161.39 | 161.4 | 161.23 | 161.23 | 8021.0 |
| 2023-03-30 07:50:00 | AAPL | Stock | 161.22 | 161.22 | 161.08 | 161.1 | 12111.0 |
| 2023-03-30 07:55:00 | AAPL | Stock | 161.17 | 161.17 | 161.15 | 161.15 | 245.0 |
| 2023-03-30 08:00:00 | AAPL | Stock | 161.16 | 161.49 | 160.25 | 161.15 | 46238.0 |
| 2023-03-30 08:05:00 | AAPL | Stock | 161.15 | 161.24 | 161.15 | 161.22 | 1822.0 |
| 2023-03-30 08:10:00 | AAPL | Stock | 161.2 | 161.31 | 161.2 | 161.27 | 3468.0 |
| 2023-03-30 08:15:00 | AAPL | Stock | 161.27 | 161.3493 | 161.255 | 161.3 | 2384.0 |
| 2023-03-30 08:20:00 | AAPL | Stock | 161.2999 | 161.3 | 161.14 | 161.15 | 7474.0 |
| 2023-03-30 08:25:00 | AAPL | Stock | 161.15 | 161.17 | 161.0999 | 161.17 | 14083.0 |
| 2023-03-30 08:30:00 | AAPL | Stock | 161.13 | 161.4 | 161.08 | 161.33 | 13055.0 |
| 2023-03-30 08:35:00 | AAPL | Stock | 161.31 | 161.45 | 161.26 | 161.3016 | 15888.0 |
> showing 50 of 409,778 rows — these rows as CSV