PREVIEW / stock_5min / 2003-09-09
file: by_date/stock_5min/2003/2003-09-09.parquet size: 2.1 MB rows: 154,109 symbols: 1,612
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-09 08:00:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4055 | 0.4055 | 2256800.0 |
| 2003-09-09 08:25:00 | AAPL | Stock | 0.4055 | 0.4055 | 0.4055 | 0.4055 | 5600.0 |
| 2003-09-09 08:40:00 | AAPL | Stock | 0.4048 | 0.4048 | 0.4048 | 0.4048 | 13832.0 |
| 2003-09-09 08:50:00 | AAPL | Stock | 0.4054 | 0.4054 | 0.4054 | 0.4054 | 56000.0 |
| 2003-09-09 09:25:00 | AAPL | Stock | 0.4046 | 0.4046 | 0.4032 | 0.4038 | 89600.0 |
| 2003-09-09 09:30:00 | AAPL | Stock | 0.4023 | 0.4045 | 0.4004 | 0.4004 | 7236600.0 |
| 2003-09-09 09:35:00 | AAPL | Stock | 0.4004 | 0.4016 | 0.4002 | 0.4014 | 9368296.0 |
| 2003-09-09 09:40:00 | AAPL | Stock | 0.4016 | 0.4018 | 0.4004 | 0.4014 | 4966584.0 |
| 2003-09-09 09:45:00 | AAPL | Stock | 0.4014 | 0.4032 | 0.4009 | 0.4025 | 6127856.0 |
| 2003-09-09 09:50:00 | AAPL | Stock | 0.4025 | 0.4027 | 0.4013 | 0.4018 | 1946616.0 |
| 2003-09-09 09:55:00 | AAPL | Stock | 0.4018 | 0.4021 | 0.4011 | 0.4018 | 1395016.0 |
| 2003-09-09 10:00:00 | AAPL | Stock | 0.4018 | 0.4023 | 0.4004 | 0.4009 | 3287200.0 |
| 2003-09-09 10:05:00 | AAPL | Stock | 0.4011 | 0.4014 | 0.4004 | 0.4009 | 3676400.0 |
| 2003-09-09 10:10:00 | AAPL | Stock | 0.4007 | 0.4009 | 0.3975 | 0.3979 | 5143488.0 |
| 2003-09-09 10:15:00 | AAPL | Stock | 0.3975 | 0.3991 | 0.3968 | 0.3968 | 3672872.0 |
| 2003-09-09 10:20:00 | AAPL | Stock | 0.3968 | 0.397 | 0.3964 | 0.3964 | 4129944.0 |
| 2003-09-09 10:25:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.395 | 0.395 | 3368400.0 |
| 2003-09-09 10:30:00 | AAPL | Stock | 0.395 | 0.3991 | 0.395 | 0.3982 | 7864696.0 |
| 2003-09-09 10:35:00 | AAPL | Stock | 0.3982 | 0.3982 | 0.397 | 0.398 | 1782536.0 |
| 2003-09-09 10:40:00 | AAPL | Stock | 0.398 | 0.3984 | 0.3968 | 0.3977 | 2491496.0 |
| 2003-09-09 10:45:00 | AAPL | Stock | 0.3975 | 0.3993 | 0.3975 | 0.3989 | 2713144.0 |
| 2003-09-09 10:50:00 | AAPL | Stock | 0.3991 | 0.3993 | 0.398 | 0.3984 | 1915200.0 |
| 2003-09-09 10:55:00 | AAPL | Stock | 0.3984 | 0.3984 | 0.3975 | 0.398 | 736232.0 |
| 2003-09-09 11:00:00 | AAPL | Stock | 0.398 | 0.3991 | 0.3979 | 0.3988 | 1652336.0 |
| 2003-09-09 11:05:00 | AAPL | Stock | 0.3988 | 0.3996 | 0.3988 | 0.3988 | 1451744.0 |
| 2003-09-09 11:10:00 | AAPL | Stock | 0.3991 | 0.4004 | 0.3986 | 0.3995 | 6160336.0 |
| 2003-09-09 11:15:00 | AAPL | Stock | 0.3995 | 0.402 | 0.3993 | 0.4018 | 3001600.0 |
| 2003-09-09 11:20:00 | AAPL | Stock | 0.4018 | 0.4023 | 0.4016 | 0.4016 | 1346800.0 |
| 2003-09-09 11:25:00 | AAPL | Stock | 0.402 | 0.402 | 0.4013 | 0.402 | 683760.0 |
| 2003-09-09 11:30:00 | AAPL | Stock | 0.4019 | 0.4029 | 0.4019 | 0.4021 | 900088.0 |
| 2003-09-09 11:35:00 | AAPL | Stock | 0.4021 | 0.4023 | 0.4021 | 0.4023 | 112000.0 |
| 2003-09-09 11:40:00 | AAPL | Stock | 0.4023 | 0.4027 | 0.4021 | 0.4021 | 667520.0 |
| 2003-09-09 11:45:00 | AAPL | Stock | 0.4021 | 0.4021 | 0.4018 | 0.402 | 341600.0 |
| 2003-09-09 11:50:00 | AAPL | Stock | 0.4018 | 0.402 | 0.4016 | 0.4016 | 806288.0 |
| 2003-09-09 11:55:00 | AAPL | Stock | 0.4016 | 0.4018 | 0.4016 | 0.4016 | 453600.0 |
| 2003-09-09 12:00:00 | AAPL | Stock | 0.4018 | 0.4025 | 0.4018 | 0.4025 | 655200.0 |
| 2003-09-09 12:05:00 | AAPL | Stock | 0.4025 | 0.4043 | 0.4025 | 0.4036 | 2128168.0 |
| 2003-09-09 12:10:00 | AAPL | Stock | 0.4036 | 0.4041 | 0.4036 | 0.4036 | 588000.0 |
| 2003-09-09 12:15:00 | AAPL | Stock | 0.4038 | 0.4045 | 0.4036 | 0.4041 | 1332800.0 |
| 2003-09-09 12:20:00 | AAPL | Stock | 0.4043 | 0.4048 | 0.4043 | 0.4046 | 1008000.0 |
| 2003-09-09 12:25:00 | AAPL | Stock | 0.4046 | 0.4048 | 0.4036 | 0.4036 | 1461600.0 |
| 2003-09-09 12:30:00 | AAPL | Stock | 0.4034 | 0.4038 | 0.4032 | 0.4034 | 313600.0 |
| 2003-09-09 12:35:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.403 | 0.403 | 716800.0 |
| 2003-09-09 12:40:00 | AAPL | Stock | 0.4032 | 0.4038 | 0.4032 | 0.4036 | 1310400.0 |
| 2003-09-09 12:45:00 | AAPL | Stock | 0.4036 | 0.4036 | 0.4029 | 0.403 | 963200.0 |
| 2003-09-09 12:50:00 | AAPL | Stock | 0.403 | 0.4032 | 0.4007 | 0.4009 | 3189200.0 |
| 2003-09-09 12:55:00 | AAPL | Stock | 0.4007 | 0.4016 | 0.4004 | 0.4016 | 2408840.0 |
| 2003-09-09 13:00:00 | AAPL | Stock | 0.4016 | 0.4018 | 0.4007 | 0.4013 | 2021600.0 |
| 2003-09-09 13:05:00 | AAPL | Stock | 0.4011 | 0.4011 | 0.3996 | 0.4007 | 1075312.0 |
| 2003-09-09 13:10:00 | AAPL | Stock | 0.4009 | 0.4009 | 0.4004 | 0.4005 | 448000.0 |
> showing 50 of 154,109 rows — these rows as CSV