PREVIEW / stock_5min / 2023-06-21
file: by_date/stock_5min/2023/2023-06-21.parquet size: 6.7 MB rows: 414,396 symbols: 1,604
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-06-21 04:00:00 | AAPL | Stock | 184.75 | 184.75 | 184.71 | 184.71 | 1600.0 |
| 2023-06-21 04:05:00 | AAPL | Stock | 184.7 | 184.81 | 184.7 | 184.81 | 1217.0 |
| 2023-06-21 04:10:00 | AAPL | Stock | 184.81 | 184.82 | 184.74 | 184.74 | 443.0 |
| 2023-06-21 04:25:00 | AAPL | Stock | 184.75 | 184.75 | 184.75 | 184.75 | 448.0 |
| 2023-06-21 04:30:00 | AAPL | Stock | 184.77 | 184.81 | 184.77 | 184.81 | 771.0 |
| 2023-06-21 04:35:00 | AAPL | Stock | 184.83 | 184.83 | 184.83 | 184.83 | 500.0 |
| 2023-06-21 04:40:00 | AAPL | Stock | 184.82 | 184.82 | 184.8 | 184.8 | 800.0 |
| 2023-06-21 04:50:00 | AAPL | Stock | 184.71 | 184.71 | 184.71 | 184.71 | 122.0 |
| 2023-06-21 05:10:00 | AAPL | Stock | 184.79 | 184.79 | 184.79 | 184.79 | 100.0 |
| 2023-06-21 05:20:00 | AAPL | Stock | 184.71 | 184.71 | 184.7 | 184.7 | 906.0 |
| 2023-06-21 05:45:00 | AAPL | Stock | 184.8 | 184.8 | 184.8 | 184.8 | 100.0 |
| 2023-06-21 06:15:00 | AAPL | Stock | 184.7 | 184.7 | 184.7 | 184.7 | 145.0 |
| 2023-06-21 06:30:00 | AAPL | Stock | 184.73 | 184.74 | 184.73 | 184.74 | 997.0 |
| 2023-06-21 06:40:00 | AAPL | Stock | 184.78 | 184.78 | 184.73 | 184.73 | 445.0 |
| 2023-06-21 06:45:00 | AAPL | Stock | 184.72 | 184.72 | 184.71 | 184.72 | 1441.0 |
| 2023-06-21 07:00:00 | AAPL | Stock | 184.81 | 184.88 | 184.77 | 184.8 | 11589.0 |
| 2023-06-21 07:05:00 | AAPL | Stock | 184.76 | 184.8 | 184.7 | 184.79 | 2619.0 |
| 2023-06-21 07:10:00 | AAPL | Stock | 184.74 | 184.77 | 184.72 | 184.72 | 610.0 |
| 2023-06-21 07:15:00 | AAPL | Stock | 184.72 | 184.72 | 184.67 | 184.67 | 5506.0 |
| 2023-06-21 07:20:00 | AAPL | Stock | 184.69 | 184.69 | 184.66 | 184.66 | 1006.0 |
| 2023-06-21 07:25:00 | AAPL | Stock | 184.7 | 184.7 | 184.62 | 184.62 | 2357.0 |
| 2023-06-21 07:30:00 | AAPL | Stock | 184.63 | 184.63 | 184.6 | 184.6 | 2519.0 |
| 2023-06-21 07:35:00 | AAPL | Stock | 184.6 | 184.6 | 184.56 | 184.56 | 2562.0 |
| 2023-06-21 07:40:00 | AAPL | Stock | 184.5 | 184.6 | 184.5 | 184.6 | 3121.0 |
| 2023-06-21 07:45:00 | AAPL | Stock | 184.65 | 184.65 | 184.65 | 184.65 | 253.0 |
| 2023-06-21 07:50:00 | AAPL | Stock | 184.7 | 184.7 | 184.7 | 184.7 | 100.0 |
| 2023-06-21 07:55:00 | AAPL | Stock | 184.75 | 184.75 | 184.7 | 184.7 | 2874.0 |
| 2023-06-21 08:00:00 | AAPL | Stock | 184.7015 | 185.1 | 183.93 | 184.68 | 57719.0 |
| 2023-06-21 08:05:00 | AAPL | Stock | 184.56 | 184.64 | 184.52 | 184.61 | 6400.0 |
| 2023-06-21 08:10:00 | AAPL | Stock | 184.6388 | 184.6388 | 184.33 | 184.48 | 17202.0 |
| 2023-06-21 08:15:00 | AAPL | Stock | 184.42 | 184.5408 | 184.39 | 184.44 | 8881.0 |
| 2023-06-21 08:20:00 | AAPL | Stock | 184.54 | 184.63 | 184.37 | 184.4 | 17648.0 |
| 2023-06-21 08:25:00 | AAPL | Stock | 184.4 | 184.47 | 184.2 | 184.22 | 34108.0 |
| 2023-06-21 08:30:00 | AAPL | Stock | 184.22 | 184.46 | 184.15 | 184.25 | 23467.0 |
| 2023-06-21 08:35:00 | AAPL | Stock | 184.29 | 184.3 | 184.12 | 184.3 | 19708.0 |
| 2023-06-21 08:40:00 | AAPL | Stock | 184.26 | 184.45 | 184.26 | 184.26 | 43419.0 |
| 2023-06-21 08:45:00 | AAPL | Stock | 184.38 | 184.43 | 184.27 | 184.43 | 8373.0 |
| 2023-06-21 08:50:00 | AAPL | Stock | 184.35 | 184.35 | 184.3 | 184.31 | 5765.0 |
| 2023-06-21 08:55:00 | AAPL | Stock | 184.4568 | 184.47 | 184.32 | 184.32 | 2421.0 |
| 2023-06-21 09:00:00 | AAPL | Stock | 184.34 | 184.3999 | 184.25 | 184.34 | 11847.0 |
| 2023-06-21 09:05:00 | AAPL | Stock | 184.33 | 184.33 | 184.16 | 184.24 | 12474.0 |
| 2023-06-21 09:10:00 | AAPL | Stock | 184.251 | 184.37 | 184.251 | 184.31 | 4565.0 |
| 2023-06-21 09:15:00 | AAPL | Stock | 184.3729 | 184.43 | 184.32 | 184.33 | 7232.0 |
| 2023-06-21 09:20:00 | AAPL | Stock | 184.36 | 184.42 | 184.32 | 184.39 | 7301.0 |
| 2023-06-21 09:25:00 | AAPL | Stock | 184.42 | 184.97 | 184.42 | 184.9 | 67094.0 |
| 2023-06-21 09:30:00 | AAPL | Stock | 184.9 | 185.35 | 184.57 | 185.325 | 1619167.0 |
| 2023-06-21 09:35:00 | AAPL | Stock | 185.325 | 185.39 | 185.0402 | 185.175 | 630214.0 |
| 2023-06-21 09:40:00 | AAPL | Stock | 185.2 | 185.41 | 184.97 | 185.19 | 744545.0 |
| 2023-06-21 09:45:00 | AAPL | Stock | 185.2 | 185.2115 | 184.71 | 184.715 | 567792.0 |
| 2023-06-21 09:50:00 | AAPL | Stock | 184.715 | 184.81 | 184.12 | 184.14 | 995535.0 |
> showing 50 of 414,396 rows — these rows as CSV