PREVIEW / stock_5min / 2004-06-24
file: by_date/stock_5min/2004/2004-06-24.parquet size: 2.4 MB rows: 179,569 symbols: 1,792
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-24 08:00:00 | AAPL | Stock | 0.5988 | 0.601 | 0.5988 | 0.601 | 128800.0 |
| 2004-06-24 08:05:00 | AAPL | Stock | 0.5991 | 0.5996 | 0.5991 | 0.5996 | 11200.0 |
| 2004-06-24 08:50:00 | AAPL | Stock | 0.5996 | 0.5996 | 0.5996 | 0.5996 | 5600.0 |
| 2004-06-24 08:55:00 | AAPL | Stock | 0.602 | 0.602 | 0.5996 | 0.5996 | 52976.0 |
| 2004-06-24 09:05:00 | AAPL | Stock | 0.5996 | 0.5996 | 0.5996 | 0.5996 | 23744.0 |
| 2004-06-24 09:25:00 | AAPL | Stock | 0.6004 | 0.6004 | 0.5991 | 0.5991 | 336000.0 |
| 2004-06-24 09:30:00 | AAPL | Stock | 0.5986 | 0.5996 | 0.5957 | 0.5986 | 7492408.0 |
| 2004-06-24 09:35:00 | AAPL | Stock | 0.5988 | 0.5995 | 0.5977 | 0.5993 | 3788792.0 |
| 2004-06-24 09:40:00 | AAPL | Stock | 0.5988 | 0.6018 | 0.5986 | 0.5995 | 4546416.0 |
| 2004-06-24 09:45:00 | AAPL | Stock | 0.5991 | 0.6004 | 0.5988 | 0.5998 | 4428424.0 |
| 2004-06-24 09:50:00 | AAPL | Stock | 0.5996 | 0.6 | 0.5996 | 0.6 | 9111368.0 |
| 2004-06-24 09:55:00 | AAPL | Stock | 0.6 | 0.6013 | 0.5993 | 0.5998 | 5032552.0 |
| 2004-06-24 10:00:00 | AAPL | Stock | 0.5998 | 0.6014 | 0.5991 | 0.5998 | 4369008.0 |
| 2004-06-24 10:05:00 | AAPL | Stock | 0.5996 | 0.6009 | 0.598 | 0.5986 | 3949232.0 |
| 2004-06-24 10:10:00 | AAPL | Stock | 0.5989 | 0.6 | 0.5977 | 0.5988 | 4842712.0 |
| 2004-06-24 10:15:00 | AAPL | Stock | 0.5988 | 0.5989 | 0.5971 | 0.5973 | 3962448.0 |
| 2004-06-24 10:20:00 | AAPL | Stock | 0.5973 | 0.5982 | 0.5964 | 0.5966 | 3576608.0 |
| 2004-06-24 10:25:00 | AAPL | Stock | 0.5964 | 0.5973 | 0.5959 | 0.5964 | 3147816.0 |
| 2004-06-24 10:30:00 | AAPL | Stock | 0.5966 | 0.5973 | 0.5964 | 0.5966 | 2649808.0 |
| 2004-06-24 10:35:00 | AAPL | Stock | 0.5968 | 0.597 | 0.5948 | 0.595 | 3534272.0 |
| 2004-06-24 10:40:00 | AAPL | Stock | 0.5952 | 0.5971 | 0.595 | 0.5955 | 3185392.0 |
| 2004-06-24 10:45:00 | AAPL | Stock | 0.5957 | 0.5968 | 0.5955 | 0.5966 | 3174080.0 |
| 2004-06-24 10:50:00 | AAPL | Stock | 0.597 | 0.5971 | 0.5959 | 0.5961 | 1401512.0 |
| 2004-06-24 10:55:00 | AAPL | Stock | 0.5961 | 0.5968 | 0.5955 | 0.5957 | 1904784.0 |
| 2004-06-24 11:00:00 | AAPL | Stock | 0.5959 | 0.5964 | 0.5957 | 0.5961 | 3425912.0 |
| 2004-06-24 11:05:00 | AAPL | Stock | 0.5959 | 0.5964 | 0.5952 | 0.5952 | 1912120.0 |
| 2004-06-24 11:10:00 | AAPL | Stock | 0.5954 | 0.5966 | 0.5952 | 0.5957 | 3996216.0 |
| 2004-06-24 11:15:00 | AAPL | Stock | 0.5959 | 0.5966 | 0.5957 | 0.5961 | 3209696.0 |
| 2004-06-24 11:20:00 | AAPL | Stock | 0.5964 | 0.5964 | 0.5955 | 0.5959 | 3129504.0 |
| 2004-06-24 11:25:00 | AAPL | Stock | 0.5959 | 0.5964 | 0.5957 | 0.5964 | 1651104.0 |
| 2004-06-24 11:30:00 | AAPL | Stock | 0.5964 | 0.5971 | 0.5955 | 0.5964 | 4084920.0 |
| 2004-06-24 11:35:00 | AAPL | Stock | 0.5964 | 0.5966 | 0.5952 | 0.5964 | 5294744.0 |
| 2004-06-24 11:40:00 | AAPL | Stock | 0.5963 | 0.5971 | 0.5963 | 0.5968 | 1859928.0 |
| 2004-06-24 11:45:00 | AAPL | Stock | 0.5968 | 0.5971 | 0.5964 | 0.5964 | 3014928.0 |
| 2004-06-24 11:50:00 | AAPL | Stock | 0.5964 | 0.5973 | 0.5959 | 0.5971 | 1430800.0 |
| 2004-06-24 11:55:00 | AAPL | Stock | 0.5971 | 0.5971 | 0.5966 | 0.5968 | 838376.0 |
| 2004-06-24 12:00:00 | AAPL | Stock | 0.5968 | 0.5973 | 0.5966 | 0.5973 | 1509928.0 |
| 2004-06-24 12:05:00 | AAPL | Stock | 0.5973 | 0.5973 | 0.5966 | 0.5968 | 595728.0 |
| 2004-06-24 12:10:00 | AAPL | Stock | 0.5966 | 0.5971 | 0.5959 | 0.5971 | 1448720.0 |
| 2004-06-24 12:15:00 | AAPL | Stock | 0.5973 | 0.5973 | 0.5963 | 0.597 | 1224832.0 |
| 2004-06-24 12:20:00 | AAPL | Stock | 0.5973 | 0.5973 | 0.597 | 0.5971 | 299600.0 |
| 2004-06-24 12:25:00 | AAPL | Stock | 0.5973 | 0.5975 | 0.597 | 0.5973 | 1069096.0 |
| 2004-06-24 12:30:00 | AAPL | Stock | 0.5975 | 0.5982 | 0.5973 | 0.598 | 790104.0 |
| 2004-06-24 12:35:00 | AAPL | Stock | 0.598 | 0.5982 | 0.5979 | 0.598 | 925960.0 |
| 2004-06-24 12:40:00 | AAPL | Stock | 0.5979 | 0.5991 | 0.5979 | 0.5989 | 1751064.0 |
| 2004-06-24 12:45:00 | AAPL | Stock | 0.5989 | 0.5995 | 0.5986 | 0.5991 | 1247400.0 |
| 2004-06-24 12:50:00 | AAPL | Stock | 0.5993 | 0.5993 | 0.5989 | 0.5991 | 1075424.0 |
| 2004-06-24 12:55:00 | AAPL | Stock | 0.5989 | 0.5991 | 0.5979 | 0.5988 | 1248520.0 |
| 2004-06-24 13:00:00 | AAPL | Stock | 0.5984 | 0.5984 | 0.5977 | 0.598 | 1155280.0 |
| 2004-06-24 13:05:00 | AAPL | Stock | 0.598 | 0.5988 | 0.598 | 0.5982 | 1296008.0 |
> showing 50 of 179,569 rows — these rows as CSV