PREVIEW / stock_5min / 2003-06-13
file: by_date/stock_5min/2003/2003-06-13.parquet size: 2.1 MB rows: 153,272 symbols: 1,586
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-06-13 09:25:00 | AAPL | Stock | 0.3166 | 0.317 | 0.3166 | 0.3166 | 72800.0 |
| 2003-06-13 09:30:00 | AAPL | Stock | 0.317 | 0.3198 | 0.3168 | 0.3193 | 2650480.0 |
| 2003-06-13 09:35:00 | AAPL | Stock | 0.3195 | 0.3205 | 0.3193 | 0.3204 | 2467360.0 |
| 2003-06-13 09:40:00 | AAPL | Stock | 0.32 | 0.3205 | 0.3177 | 0.3198 | 3208576.0 |
| 2003-06-13 09:45:00 | AAPL | Stock | 0.32 | 0.3202 | 0.3164 | 0.3168 | 3790864.0 |
| 2003-06-13 09:50:00 | AAPL | Stock | 0.3168 | 0.3179 | 0.3166 | 0.3177 | 2119208.0 |
| 2003-06-13 09:55:00 | AAPL | Stock | 0.3177 | 0.3184 | 0.3168 | 0.3173 | 2044000.0 |
| 2003-06-13 10:00:00 | AAPL | Stock | 0.3171 | 0.3171 | 0.3152 | 0.3154 | 2581376.0 |
| 2003-06-13 10:05:00 | AAPL | Stock | 0.3155 | 0.3162 | 0.3129 | 0.3138 | 3373160.0 |
| 2003-06-13 10:10:00 | AAPL | Stock | 0.3138 | 0.3139 | 0.3089 | 0.31 | 7709352.0 |
| 2003-06-13 10:15:00 | AAPL | Stock | 0.31 | 0.31 | 0.3082 | 0.3082 | 7118272.0 |
| 2003-06-13 10:20:00 | AAPL | Stock | 0.3086 | 0.3093 | 0.3071 | 0.3093 | 5737760.0 |
| 2003-06-13 10:25:00 | AAPL | Stock | 0.3089 | 0.3107 | 0.3088 | 0.3089 | 9641968.0 |
| 2003-06-13 10:30:00 | AAPL | Stock | 0.3089 | 0.3091 | 0.307 | 0.3077 | 3623088.0 |
| 2003-06-13 10:35:00 | AAPL | Stock | 0.3077 | 0.3084 | 0.3073 | 0.3075 | 2268000.0 |
| 2003-06-13 10:40:00 | AAPL | Stock | 0.3075 | 0.3086 | 0.3071 | 0.3075 | 1881600.0 |
| 2003-06-13 10:45:00 | AAPL | Stock | 0.3077 | 0.3096 | 0.3073 | 0.3095 | 1803200.0 |
| 2003-06-13 10:50:00 | AAPL | Stock | 0.3095 | 0.3096 | 0.3086 | 0.3091 | 1544872.0 |
| 2003-06-13 10:55:00 | AAPL | Stock | 0.3095 | 0.31 | 0.308 | 0.3082 | 2567320.0 |
| 2003-06-13 11:00:00 | AAPL | Stock | 0.308 | 0.3096 | 0.3075 | 0.3086 | 3805200.0 |
| 2003-06-13 11:05:00 | AAPL | Stock | 0.3084 | 0.3089 | 0.3082 | 0.3084 | 2262400.0 |
| 2003-06-13 11:10:00 | AAPL | Stock | 0.3084 | 0.3086 | 0.3073 | 0.3079 | 2467360.0 |
| 2003-06-13 11:15:00 | AAPL | Stock | 0.3079 | 0.308 | 0.3073 | 0.3073 | 1783600.0 |
| 2003-06-13 11:20:00 | AAPL | Stock | 0.3073 | 0.3073 | 0.3064 | 0.3066 | 2610608.0 |
| 2003-06-13 11:25:00 | AAPL | Stock | 0.3066 | 0.3066 | 0.3059 | 0.3064 | 1786400.0 |
| 2003-06-13 11:30:00 | AAPL | Stock | 0.3064 | 0.3082 | 0.3064 | 0.308 | 2224600.0 |
| 2003-06-13 11:35:00 | AAPL | Stock | 0.308 | 0.3082 | 0.3064 | 0.3071 | 1399384.0 |
| 2003-06-13 11:40:00 | AAPL | Stock | 0.3071 | 0.3075 | 0.3068 | 0.3068 | 1003016.0 |
| 2003-06-13 11:45:00 | AAPL | Stock | 0.3068 | 0.3082 | 0.3066 | 0.3077 | 1586480.0 |
| 2003-06-13 11:50:00 | AAPL | Stock | 0.3075 | 0.3089 | 0.3073 | 0.3084 | 1344056.0 |
| 2003-06-13 11:55:00 | AAPL | Stock | 0.3084 | 0.3089 | 0.307 | 0.3073 | 1097824.0 |
| 2003-06-13 12:00:00 | AAPL | Stock | 0.3073 | 0.3082 | 0.3073 | 0.3079 | 1031408.0 |
| 2003-06-13 12:05:00 | AAPL | Stock | 0.3082 | 0.3084 | 0.308 | 0.3082 | 649600.0 |
| 2003-06-13 12:10:00 | AAPL | Stock | 0.308 | 0.3084 | 0.308 | 0.3084 | 1145760.0 |
| 2003-06-13 12:15:00 | AAPL | Stock | 0.3082 | 0.3086 | 0.3082 | 0.3084 | 1106616.0 |
| 2003-06-13 12:20:00 | AAPL | Stock | 0.3086 | 0.3093 | 0.3084 | 0.3089 | 1050000.0 |
| 2003-06-13 12:25:00 | AAPL | Stock | 0.3091 | 0.3104 | 0.3091 | 0.3102 | 2194752.0 |
| 2003-06-13 12:30:00 | AAPL | Stock | 0.3104 | 0.3105 | 0.31 | 0.3102 | 1666560.0 |
| 2003-06-13 12:35:00 | AAPL | Stock | 0.3102 | 0.3104 | 0.31 | 0.31 | 1248800.0 |
| 2003-06-13 12:40:00 | AAPL | Stock | 0.3102 | 0.3107 | 0.31 | 0.3106 | 1534400.0 |
| 2003-06-13 12:45:00 | AAPL | Stock | 0.3107 | 0.3107 | 0.3104 | 0.3104 | 627200.0 |
| 2003-06-13 12:50:00 | AAPL | Stock | 0.3105 | 0.3105 | 0.3098 | 0.31 | 3345440.0 |
| 2003-06-13 12:55:00 | AAPL | Stock | 0.31 | 0.3104 | 0.3096 | 0.3102 | 1338400.0 |
| 2003-06-13 13:00:00 | AAPL | Stock | 0.31 | 0.3105 | 0.31 | 0.3105 | 1921920.0 |
| 2003-06-13 13:05:00 | AAPL | Stock | 0.3105 | 0.3107 | 0.3102 | 0.3107 | 1344000.0 |
| 2003-06-13 13:10:00 | AAPL | Stock | 0.3107 | 0.3114 | 0.3105 | 0.3113 | 2314928.0 |
| 2003-06-13 13:15:00 | AAPL | Stock | 0.3111 | 0.3114 | 0.3111 | 0.3111 | 1032640.0 |
| 2003-06-13 13:20:00 | AAPL | Stock | 0.3113 | 0.3113 | 0.3109 | 0.3111 | 484512.0 |
| 2003-06-13 13:25:00 | AAPL | Stock | 0.3111 | 0.3111 | 0.3107 | 0.3107 | 380800.0 |
| 2003-06-13 13:30:00 | AAPL | Stock | 0.3107 | 0.3109 | 0.3105 | 0.3105 | 323680.0 |
> showing 50 of 153,272 rows — these rows as CSV