PREVIEW / stock_5min / 2004-06-25
file: by_date/stock_5min/2004/2004-06-25.parquet size: 2.7 MB rows: 192,905 symbols: 1,782
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-25 08:45:00 | AAPL | Stock | 0.592 | 0.592 | 0.592 | 0.592 | 11200.0 |
| 2004-06-25 09:25:00 | AAPL | Stock | 0.5902 | 0.5925 | 0.5895 | 0.5911 | 522368.0 |
| 2004-06-25 09:30:00 | AAPL | Stock | 0.5893 | 0.5971 | 0.5893 | 0.5946 | 7231448.0 |
| 2004-06-25 09:35:00 | AAPL | Stock | 0.5948 | 0.5966 | 0.5946 | 0.595 | 3810016.0 |
| 2004-06-25 09:40:00 | AAPL | Stock | 0.5954 | 0.598 | 0.5954 | 0.5968 | 4562992.0 |
| 2004-06-25 09:45:00 | AAPL | Stock | 0.5973 | 0.5973 | 0.5938 | 0.5955 | 4220160.0 |
| 2004-06-25 09:50:00 | AAPL | Stock | 0.5957 | 0.598 | 0.5943 | 0.5964 | 4633664.0 |
| 2004-06-25 09:55:00 | AAPL | Stock | 0.5963 | 0.5973 | 0.5943 | 0.595 | 2844016.0 |
| 2004-06-25 10:00:00 | AAPL | Stock | 0.5948 | 0.5971 | 0.5943 | 0.5952 | 2903824.0 |
| 2004-06-25 10:05:00 | AAPL | Stock | 0.5952 | 0.597 | 0.5945 | 0.5959 | 2575664.0 |
| 2004-06-25 10:10:00 | AAPL | Stock | 0.5959 | 0.5973 | 0.5957 | 0.5964 | 2226616.0 |
| 2004-06-25 10:15:00 | AAPL | Stock | 0.5963 | 0.5971 | 0.5961 | 0.5964 | 1385552.0 |
| 2004-06-25 10:20:00 | AAPL | Stock | 0.5964 | 0.5973 | 0.5964 | 0.597 | 2417016.0 |
| 2004-06-25 10:25:00 | AAPL | Stock | 0.597 | 0.597 | 0.5964 | 0.5964 | 1291472.0 |
| 2004-06-25 10:30:00 | AAPL | Stock | 0.5966 | 0.5973 | 0.5964 | 0.5968 | 3068744.0 |
| 2004-06-25 10:35:00 | AAPL | Stock | 0.5968 | 0.5995 | 0.5966 | 0.5993 | 4105528.0 |
| 2004-06-25 10:40:00 | AAPL | Stock | 0.5993 | 0.5993 | 0.5988 | 0.5993 | 1347752.0 |
| 2004-06-25 10:45:00 | AAPL | Stock | 0.5993 | 0.5998 | 0.5991 | 0.5993 | 1113672.0 |
| 2004-06-25 10:50:00 | AAPL | Stock | 0.5993 | 0.5993 | 0.5979 | 0.5982 | 1908368.0 |
| 2004-06-25 10:55:00 | AAPL | Stock | 0.5979 | 0.5986 | 0.597 | 0.5974 | 2818816.0 |
| 2004-06-25 11:00:00 | AAPL | Stock | 0.5975 | 0.5977 | 0.5971 | 0.5975 | 1094352.0 |
| 2004-06-25 11:05:00 | AAPL | Stock | 0.5971 | 0.5973 | 0.5964 | 0.5966 | 1600536.0 |
| 2004-06-25 11:10:00 | AAPL | Stock | 0.5966 | 0.5973 | 0.5959 | 0.5971 | 2039632.0 |
| 2004-06-25 11:15:00 | AAPL | Stock | 0.597 | 0.5973 | 0.5964 | 0.5966 | 1960672.0 |
| 2004-06-25 11:20:00 | AAPL | Stock | 0.5971 | 0.5975 | 0.5964 | 0.5966 | 1179920.0 |
| 2004-06-25 11:25:00 | AAPL | Stock | 0.5966 | 0.5993 | 0.5964 | 0.5993 | 4535104.0 |
| 2004-06-25 11:30:00 | AAPL | Stock | 0.5995 | 0.6005 | 0.598 | 0.5986 | 3573584.0 |
| 2004-06-25 11:35:00 | AAPL | Stock | 0.5986 | 0.5986 | 0.5977 | 0.5979 | 1428168.0 |
| 2004-06-25 11:40:00 | AAPL | Stock | 0.5975 | 0.5977 | 0.5961 | 0.5966 | 2905056.0 |
| 2004-06-25 11:45:00 | AAPL | Stock | 0.5966 | 0.5971 | 0.5966 | 0.5968 | 1331400.0 |
| 2004-06-25 11:50:00 | AAPL | Stock | 0.597 | 0.5971 | 0.597 | 0.597 | 1760472.0 |
| 2004-06-25 11:55:00 | AAPL | Stock | 0.597 | 0.5977 | 0.597 | 0.5971 | 1830752.0 |
| 2004-06-25 12:00:00 | AAPL | Stock | 0.5973 | 0.5977 | 0.5971 | 0.5977 | 921312.0 |
| 2004-06-25 12:05:00 | AAPL | Stock | 0.5977 | 0.5977 | 0.5964 | 0.5964 | 2120384.0 |
| 2004-06-25 12:10:00 | AAPL | Stock | 0.5968 | 0.5968 | 0.5961 | 0.5961 | 1614928.0 |
| 2004-06-25 12:15:00 | AAPL | Stock | 0.5963 | 0.5971 | 0.5961 | 0.597 | 842408.0 |
| 2004-06-25 12:20:00 | AAPL | Stock | 0.597 | 0.5975 | 0.5964 | 0.597 | 1817032.0 |
| 2004-06-25 12:25:00 | AAPL | Stock | 0.5968 | 0.5971 | 0.5955 | 0.5955 | 3649464.0 |
| 2004-06-25 12:30:00 | AAPL | Stock | 0.5964 | 0.5964 | 0.5943 | 0.595 | 9894752.0 |
| 2004-06-25 12:35:00 | AAPL | Stock | 0.595 | 0.595 | 0.5938 | 0.5945 | 4286800.0 |
| 2004-06-25 12:40:00 | AAPL | Stock | 0.5946 | 0.5946 | 0.5929 | 0.5929 | 2977800.0 |
| 2004-06-25 12:45:00 | AAPL | Stock | 0.593 | 0.5943 | 0.5927 | 0.5936 | 1795024.0 |
| 2004-06-25 12:50:00 | AAPL | Stock | 0.5936 | 0.5938 | 0.5923 | 0.5932 | 2374344.0 |
| 2004-06-25 12:55:00 | AAPL | Stock | 0.5934 | 0.5943 | 0.5934 | 0.5938 | 2394952.0 |
| 2004-06-25 13:00:00 | AAPL | Stock | 0.5938 | 0.5966 | 0.593 | 0.5954 | 5029696.0 |
| 2004-06-25 13:05:00 | AAPL | Stock | 0.5954 | 0.5963 | 0.5943 | 0.5952 | 3852576.0 |
| 2004-06-25 13:10:00 | AAPL | Stock | 0.595 | 0.595 | 0.5925 | 0.5929 | 2009952.0 |
| 2004-06-25 13:15:00 | AAPL | Stock | 0.5929 | 0.5943 | 0.5929 | 0.5938 | 2279648.0 |
| 2004-06-25 13:20:00 | AAPL | Stock | 0.5938 | 0.5938 | 0.5929 | 0.593 | 1214248.0 |
| 2004-06-25 13:25:00 | AAPL | Stock | 0.593 | 0.5938 | 0.593 | 0.5938 | 1824928.0 |
> showing 50 of 192,905 rows — these rows as CSV