PREVIEW / stock_5min / 2003-09-12
file: by_date/stock_5min/2003/2003-09-12.parquet size: 2.1 MB rows: 148,208 symbols: 1,609
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 |
|---|---|---|---|---|---|---|---|
| 2003-09-12 08:40:00 | AAPL | Stock | 0.402 | 0.402 | 0.402 | 0.402 | 28000.0 |
| 2003-09-12 08:45:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4029 | 0.4029 | 291200.0 |
| 2003-09-12 09:25:00 | AAPL | Stock | 0.4023 | 0.4023 | 0.4021 | 0.4021 | 11200.0 |
| 2003-09-12 09:30:00 | AAPL | Stock | 0.402 | 0.403 | 0.4009 | 0.4014 | 3080000.0 |
| 2003-09-12 09:35:00 | AAPL | Stock | 0.4016 | 0.4016 | 0.4005 | 0.4011 | 2077600.0 |
| 2003-09-12 09:40:00 | AAPL | Stock | 0.4016 | 0.403 | 0.4007 | 0.4013 | 3363808.0 |
| 2003-09-12 09:45:00 | AAPL | Stock | 0.4013 | 0.4013 | 0.3998 | 0.4002 | 2694048.0 |
| 2003-09-12 09:50:00 | AAPL | Stock | 0.4007 | 0.4013 | 0.3989 | 0.3991 | 2823856.0 |
| 2003-09-12 09:55:00 | AAPL | Stock | 0.3991 | 0.4 | 0.3984 | 0.3989 | 2963744.0 |
| 2003-09-12 10:00:00 | AAPL | Stock | 0.3989 | 0.4002 | 0.3984 | 0.3998 | 1758400.0 |
| 2003-09-12 10:05:00 | AAPL | Stock | 0.4 | 0.4006 | 0.3993 | 0.4004 | 840000.0 |
| 2003-09-12 10:10:00 | AAPL | Stock | 0.4007 | 0.4011 | 0.4 | 0.4 | 610456.0 |
| 2003-09-12 10:15:00 | AAPL | Stock | 0.4 | 0.4002 | 0.3998 | 0.4 | 498288.0 |
| 2003-09-12 10:20:00 | AAPL | Stock | 0.4 | 0.4009 | 0.3998 | 0.4009 | 1145200.0 |
| 2003-09-12 10:25:00 | AAPL | Stock | 0.4009 | 0.4016 | 0.4 | 0.4 | 2834552.0 |
| 2003-09-12 10:30:00 | AAPL | Stock | 0.4002 | 0.4004 | 0.4 | 0.4 | 1331904.0 |
| 2003-09-12 10:35:00 | AAPL | Stock | 0.4 | 0.402 | 0.4 | 0.4013 | 1288280.0 |
| 2003-09-12 10:40:00 | AAPL | Stock | 0.4014 | 0.4021 | 0.4013 | 0.4021 | 1881600.0 |
| 2003-09-12 10:45:00 | AAPL | Stock | 0.4021 | 0.4036 | 0.402 | 0.4029 | 2872800.0 |
| 2003-09-12 10:50:00 | AAPL | Stock | 0.4029 | 0.403 | 0.4013 | 0.4027 | 1650320.0 |
| 2003-09-12 10:55:00 | AAPL | Stock | 0.4025 | 0.4025 | 0.4009 | 0.4013 | 1002400.0 |
| 2003-09-12 11:00:00 | AAPL | Stock | 0.4011 | 0.4013 | 0.4009 | 0.4013 | 1049664.0 |
| 2003-09-12 11:05:00 | AAPL | Stock | 0.4011 | 0.4017 | 0.4011 | 0.4013 | 672000.0 |
| 2003-09-12 11:10:00 | AAPL | Stock | 0.4013 | 0.4038 | 0.4013 | 0.4029 | 1786736.0 |
| 2003-09-12 11:15:00 | AAPL | Stock | 0.4023 | 0.4038 | 0.4021 | 0.403 | 2693880.0 |
| 2003-09-12 11:20:00 | AAPL | Stock | 0.403 | 0.4032 | 0.4023 | 0.4029 | 3923136.0 |
| 2003-09-12 11:25:00 | AAPL | Stock | 0.4027 | 0.4027 | 0.4018 | 0.4023 | 1691200.0 |
| 2003-09-12 11:30:00 | AAPL | Stock | 0.4021 | 0.4029 | 0.402 | 0.402 | 5779200.0 |
| 2003-09-12 11:35:00 | AAPL | Stock | 0.402 | 0.4027 | 0.4016 | 0.4027 | 1824144.0 |
| 2003-09-12 11:40:00 | AAPL | Stock | 0.4027 | 0.4034 | 0.4023 | 0.403 | 1937656.0 |
| 2003-09-12 11:45:00 | AAPL | Stock | 0.4032 | 0.4036 | 0.4027 | 0.4027 | 3813600.0 |
| 2003-09-12 11:50:00 | AAPL | Stock | 0.4027 | 0.4029 | 0.4025 | 0.4027 | 2206008.0 |
| 2003-09-12 11:55:00 | AAPL | Stock | 0.4027 | 0.4029 | 0.4027 | 0.4029 | 1904000.0 |
| 2003-09-12 12:00:00 | AAPL | Stock | 0.4027 | 0.4034 | 0.4027 | 0.4027 | 591416.0 |
| 2003-09-12 12:05:00 | AAPL | Stock | 0.4029 | 0.4029 | 0.4023 | 0.4023 | 1022392.0 |
| 2003-09-12 12:10:00 | AAPL | Stock | 0.4023 | 0.4029 | 0.4023 | 0.4027 | 828800.0 |
| 2003-09-12 12:15:00 | AAPL | Stock | 0.4027 | 0.4041 | 0.4027 | 0.4038 | 1254400.0 |
| 2003-09-12 12:20:00 | AAPL | Stock | 0.4036 | 0.4038 | 0.4027 | 0.4029 | 935200.0 |
| 2003-09-12 12:25:00 | AAPL | Stock | 0.403 | 0.4039 | 0.403 | 0.4039 | 1013600.0 |
| 2003-09-12 12:30:00 | AAPL | Stock | 0.4041 | 0.4043 | 0.4027 | 0.4029 | 2635864.0 |
| 2003-09-12 12:35:00 | AAPL | Stock | 0.403 | 0.4036 | 0.4029 | 0.4032 | 341600.0 |
| 2003-09-12 12:40:00 | AAPL | Stock | 0.4032 | 0.4032 | 0.4026 | 0.4029 | 1292256.0 |
| 2003-09-12 12:45:00 | AAPL | Stock | 0.4027 | 0.4034 | 0.4027 | 0.4032 | 509432.0 |
| 2003-09-12 12:50:00 | AAPL | Stock | 0.403 | 0.4032 | 0.4027 | 0.4027 | 403200.0 |
| 2003-09-12 12:55:00 | AAPL | Stock | 0.4029 | 0.403 | 0.4027 | 0.403 | 464800.0 |
| 2003-09-12 13:00:00 | AAPL | Stock | 0.403 | 0.4036 | 0.4028 | 0.4036 | 1103200.0 |
| 2003-09-12 13:05:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.403 | 0.403 | 2548000.0 |
| 2003-09-12 13:10:00 | AAPL | Stock | 0.403 | 0.4032 | 0.403 | 0.403 | 403200.0 |
| 2003-09-12 13:15:00 | AAPL | Stock | 0.4032 | 0.4046 | 0.403 | 0.4046 | 3804080.0 |
| 2003-09-12 13:20:00 | AAPL | Stock | 0.4046 | 0.4061 | 0.4046 | 0.4061 | 2880192.0 |
> showing 50 of 148,208 rows — these rows as CSV