PREVIEW / stock_5min / 2024-07-19
file: by_date/stock_5min/2024/2024-07-19.parquet size: 6.2 MB rows: 379,691 symbols: 882
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-19 04:00:00 | AAPL | Stock | 224.13 | 224.18 | 223.93 | 224.14 | 2012.0 |
| 2024-07-19 04:05:00 | AAPL | Stock | 224.16 | 224.2 | 224.13 | 224.14 | 4311.0 |
| 2024-07-19 04:10:00 | AAPL | Stock | 224.14 | 224.17 | 224.01 | 224.01 | 1099.0 |
| 2024-07-19 04:15:00 | AAPL | Stock | 224.0 | 224.01 | 223.19 | 223.19 | 7324.0 |
| 2024-07-19 04:20:00 | AAPL | Stock | 223.2 | 223.2 | 222.0 | 222.18 | 9109.0 |
| 2024-07-19 04:25:00 | AAPL | Stock | 222.36 | 222.71 | 222.17 | 222.7 | 9109.0 |
| 2024-07-19 04:30:00 | AAPL | Stock | 222.64 | 222.8 | 222.62 | 222.75 | 1369.0 |
| 2024-07-19 04:35:00 | AAPL | Stock | 222.84 | 223.2 | 222.8 | 223.18 | 4008.0 |
| 2024-07-19 04:40:00 | AAPL | Stock | 223.05 | 223.06 | 223.04 | 223.06 | 490.0 |
| 2024-07-19 04:45:00 | AAPL | Stock | 223.13 | 223.18 | 223.0 | 223.0 | 1783.0 |
| 2024-07-19 04:50:00 | AAPL | Stock | 223.0 | 223.0 | 222.92 | 222.92 | 929.0 |
| 2024-07-19 04:55:00 | AAPL | Stock | 223.0 | 223.0 | 223.0 | 223.0 | 1313.0 |
| 2024-07-19 05:00:00 | AAPL | Stock | 222.93 | 223.67 | 222.91 | 223.46 | 2893.0 |
| 2024-07-19 05:05:00 | AAPL | Stock | 223.29 | 223.57 | 223.2 | 223.37 | 3277.0 |
| 2024-07-19 05:10:00 | AAPL | Stock | 223.33 | 223.33 | 223.2 | 223.28 | 1073.0 |
| 2024-07-19 05:15:00 | AAPL | Stock | 223.28 | 223.51 | 223.28 | 223.51 | 762.0 |
| 2024-07-19 05:20:00 | AAPL | Stock | 223.34 | 223.34 | 223.16 | 223.19 | 1005.0 |
| 2024-07-19 05:25:00 | AAPL | Stock | 223.21 | 223.66 | 223.21 | 223.59 | 1706.0 |
| 2024-07-19 05:30:00 | AAPL | Stock | 223.68 | 224.47 | 223.68 | 224.47 | 11829.0 |
| 2024-07-19 05:35:00 | AAPL | Stock | 224.28 | 224.28 | 224.21 | 224.21 | 1594.0 |
| 2024-07-19 05:40:00 | AAPL | Stock | 223.85 | 224.19 | 223.8 | 224.0 | 2234.0 |
| 2024-07-19 05:45:00 | AAPL | Stock | 224.2 | 224.9 | 224.13 | 224.9 | 9346.0 |
| 2024-07-19 05:50:00 | AAPL | Stock | 224.85 | 224.9 | 224.72 | 224.9 | 750.0 |
| 2024-07-19 05:55:00 | AAPL | Stock | 224.88 | 224.89 | 224.7 | 224.85 | 1271.0 |
| 2024-07-19 06:00:00 | AAPL | Stock | 224.79 | 225.37 | 224.79 | 225.37 | 3504.0 |
| 2024-07-19 06:05:00 | AAPL | Stock | 225.44 | 225.5 | 225.27 | 225.27 | 2891.0 |
| 2024-07-19 06:10:00 | AAPL | Stock | 225.29 | 225.43 | 225.23 | 225.43 | 976.0 |
| 2024-07-19 06:15:00 | AAPL | Stock | 225.46 | 225.46 | 225.33 | 225.33 | 1834.0 |
| 2024-07-19 06:20:00 | AAPL | Stock | 225.31 | 225.32 | 225.03 | 225.03 | 1305.0 |
| 2024-07-19 06:25:00 | AAPL | Stock | 225.2 | 225.4 | 225.2 | 225.4 | 3621.0 |
| 2024-07-19 06:30:00 | AAPL | Stock | 225.31 | 225.46 | 225.31 | 225.4 | 1872.0 |
| 2024-07-19 06:35:00 | AAPL | Stock | 225.31 | 225.66 | 225.3 | 225.49 | 4772.0 |
| 2024-07-19 06:40:00 | AAPL | Stock | 225.43 | 225.43 | 225.35 | 225.35 | 2836.0 |
| 2024-07-19 06:45:00 | AAPL | Stock | 225.38 | 225.52 | 225.38 | 225.52 | 1723.0 |
| 2024-07-19 06:50:00 | AAPL | Stock | 225.56 | 225.56 | 225.38 | 225.46 | 850.0 |
| 2024-07-19 06:55:00 | AAPL | Stock | 225.43 | 225.43 | 225.1 | 225.1 | 1481.0 |
| 2024-07-19 07:00:00 | AAPL | Stock | 225.0 | 225.3 | 225.0 | 225.21 | 6215.0 |
| 2024-07-19 07:05:00 | AAPL | Stock | 225.21 | 225.54 | 225.11 | 225.54 | 9275.0 |
| 2024-07-19 07:10:00 | AAPL | Stock | 225.5 | 225.75 | 225.5 | 225.64 | 2191.0 |
| 2024-07-19 07:15:00 | AAPL | Stock | 225.7 | 225.79 | 225.7 | 225.7 | 3351.0 |
| 2024-07-19 07:20:00 | AAPL | Stock | 225.78 | 226.24 | 225.78 | 226.2 | 8952.0 |
| 2024-07-19 07:25:00 | AAPL | Stock | 225.86 | 225.95 | 225.86 | 225.95 | 1099.0 |
| 2024-07-19 07:30:00 | AAPL | Stock | 226.0 | 226.2 | 226.0 | 226.2 | 1179.0 |
| 2024-07-19 07:35:00 | AAPL | Stock | 226.0 | 226.1 | 225.95 | 226.06 | 1569.0 |
| 2024-07-19 07:40:00 | AAPL | Stock | 226.04 | 226.04 | 225.68 | 225.82 | 3639.0 |
| 2024-07-19 07:45:00 | AAPL | Stock | 225.85 | 225.99 | 225.72 | 225.99 | 2771.0 |
| 2024-07-19 07:50:00 | AAPL | Stock | 225.85 | 225.85 | 225.7 | 225.85 | 3572.0 |
| 2024-07-19 07:55:00 | AAPL | Stock | 225.9 | 225.9 | 225.84 | 225.9 | 329.0 |
| 2024-07-19 08:00:00 | AAPL | Stock | 225.15 | 226.25 | 223.26 | 226.2 | 94562.0 |
| 2024-07-19 08:05:00 | AAPL | Stock | 225.98 | 226.2 | 225.98 | 225.99 | 5231.0 |
> showing 50 of 379,691 rows — these rows as CSV