PREVIEW / stock_5min / 2004-01-20
file: by_date/stock_5min/2004/2004-01-20.parquet size: 2.6 MB rows: 181,594 symbols: 1,721
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-01-20 08:00:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 11200.0 |
| 2004-01-20 08:05:00 | AAPL | Stock | 0.4064 | 0.4064 | 0.4059 | 0.4059 | 56000.0 |
| 2004-01-20 08:10:00 | AAPL | Stock | 0.4059 | 0.4071 | 0.4059 | 0.4071 | 84000.0 |
| 2004-01-20 08:20:00 | AAPL | Stock | 0.4088 | 0.4088 | 0.4068 | 0.4068 | 235200.0 |
| 2004-01-20 08:25:00 | AAPL | Stock | 0.4068 | 0.4068 | 0.4068 | 0.4068 | 22400.0 |
| 2004-01-20 08:35:00 | AAPL | Stock | 0.4068 | 0.4068 | 0.4068 | 0.4068 | 112000.0 |
| 2004-01-20 08:40:00 | AAPL | Stock | 0.4064 | 0.4064 | 0.4064 | 0.4064 | 28000.0 |
| 2004-01-20 08:50:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4071 | 0.4071 | 24080.0 |
| 2004-01-20 08:55:00 | AAPL | Stock | 0.4059 | 0.4077 | 0.4059 | 0.4077 | 425600.0 |
| 2004-01-20 09:10:00 | AAPL | Stock | 0.408 | 0.408 | 0.408 | 0.408 | 56000.0 |
| 2004-01-20 09:15:00 | AAPL | Stock | 0.4071 | 0.4079 | 0.4071 | 0.4079 | 478800.0 |
| 2004-01-20 09:20:00 | AAPL | Stock | 0.4071 | 0.4071 | 0.4068 | 0.4068 | 33600.0 |
| 2004-01-20 09:25:00 | AAPL | Stock | 0.4057 | 0.4071 | 0.4055 | 0.4055 | 132160.0 |
| 2004-01-20 09:30:00 | AAPL | Stock | 0.4054 | 0.4055 | 0.4025 | 0.4032 | 14856240.0 |
| 2004-01-20 09:35:00 | AAPL | Stock | 0.4032 | 0.4045 | 0.403 | 0.4036 | 6311200.0 |
| 2004-01-20 09:40:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.402 | 0.402 | 5174400.0 |
| 2004-01-20 09:45:00 | AAPL | Stock | 0.402 | 0.4025 | 0.4005 | 0.4007 | 15436904.0 |
| 2004-01-20 09:50:00 | AAPL | Stock | 0.4009 | 0.4014 | 0.4005 | 0.4007 | 9603832.0 |
| 2004-01-20 09:55:00 | AAPL | Stock | 0.4007 | 0.4007 | 0.3996 | 0.3996 | 10952032.0 |
| 2004-01-20 10:00:00 | AAPL | Stock | 0.3995 | 0.3995 | 0.3973 | 0.398 | 9775304.0 |
| 2004-01-20 10:05:00 | AAPL | Stock | 0.398 | 0.3996 | 0.3977 | 0.3991 | 7239400.0 |
| 2004-01-20 10:10:00 | AAPL | Stock | 0.3989 | 0.3991 | 0.3984 | 0.3991 | 5491752.0 |
| 2004-01-20 10:15:00 | AAPL | Stock | 0.3989 | 0.4018 | 0.3989 | 0.4016 | 7178248.0 |
| 2004-01-20 10:20:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.3993 | 0.4011 | 8326584.0 |
| 2004-01-20 10:25:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4005 | 0.4009 | 4403392.0 |
| 2004-01-20 10:30:00 | AAPL | Stock | 0.4005 | 0.4013 | 0.3998 | 0.4004 | 2368352.0 |
| 2004-01-20 10:35:00 | AAPL | Stock | 0.4004 | 0.4014 | 0.4004 | 0.4014 | 1744848.0 |
| 2004-01-20 10:40:00 | AAPL | Stock | 0.4014 | 0.4014 | 0.4007 | 0.4011 | 7484400.0 |
| 2004-01-20 10:45:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.3996 | 0.3998 | 3374392.0 |
| 2004-01-20 10:50:00 | AAPL | Stock | 0.4 | 0.4013 | 0.3998 | 0.4 | 5621448.0 |
| 2004-01-20 10:55:00 | AAPL | Stock | 0.4 | 0.4016 | 0.4 | 0.4013 | 2138808.0 |
| 2004-01-20 11:00:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.3996 | 0.4011 | 6203680.0 |
| 2004-01-20 11:05:00 | AAPL | Stock | 0.4011 | 0.4018 | 0.4009 | 0.4013 | 5467840.0 |
| 2004-01-20 11:10:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4007 | 0.4007 | 1810592.0 |
| 2004-01-20 11:15:00 | AAPL | Stock | 0.4009 | 0.4013 | 0.4007 | 0.4011 | 1522416.0 |
| 2004-01-20 11:20:00 | AAPL | Stock | 0.4012 | 0.4013 | 0.4007 | 0.4007 | 1554056.0 |
| 2004-01-20 11:25:00 | AAPL | Stock | 0.4009 | 0.4009 | 0.4002 | 0.4002 | 1277864.0 |
| 2004-01-20 11:30:00 | AAPL | Stock | 0.4004 | 0.4004 | 0.3996 | 0.3996 | 1845200.0 |
| 2004-01-20 11:35:00 | AAPL | Stock | 0.3996 | 0.4007 | 0.3995 | 0.3998 | 4020968.0 |
| 2004-01-20 11:40:00 | AAPL | Stock | 0.3998 | 0.4009 | 0.3998 | 0.4009 | 1224160.0 |
| 2004-01-20 11:45:00 | AAPL | Stock | 0.4005 | 0.4011 | 0.4 | 0.4009 | 1148224.0 |
| 2004-01-20 11:50:00 | AAPL | Stock | 0.4009 | 0.4018 | 0.4009 | 0.4016 | 1148392.0 |
| 2004-01-20 11:55:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4011 | 0.4016 | 1090040.0 |
| 2004-01-20 12:00:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4011 | 0.4013 | 5029640.0 |
| 2004-01-20 12:05:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4011 | 0.4014 | 1832992.0 |
| 2004-01-20 12:10:00 | AAPL | Stock | 0.4014 | 0.4014 | 0.4011 | 0.4014 | 1647296.0 |
| 2004-01-20 12:15:00 | AAPL | Stock | 0.4013 | 0.4016 | 0.4011 | 0.4013 | 747600.0 |
| 2004-01-20 12:20:00 | AAPL | Stock | 0.4013 | 0.4014 | 0.4011 | 0.4013 | 750568.0 |
| 2004-01-20 12:25:00 | AAPL | Stock | 0.4014 | 0.4016 | 0.4013 | 0.4016 | 916272.0 |
| 2004-01-20 12:30:00 | AAPL | Stock | 0.4014 | 0.4018 | 0.4014 | 0.4016 | 1927128.0 |
> showing 50 of 181,594 rows — these rows as CSV