PREVIEW / stock_5min / 2009-02-05
file: by_date/stock_5min/2009/2009-02-05.parquet size: 4.4 MB rows: 301,589 symbols: 3,312
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-05 07:45:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3125 | 3.3125 | 5600.0 |
| 2009-02-05 07:50:00 | AAPL | Stock | 3.3125 | 3.3125 | 3.3107 | 3.3107 | 22400.0 |
| 2009-02-05 07:55:00 | AAPL | Stock | 3.3164 | 3.3164 | 3.3164 | 3.3164 | 2800.0 |
| 2009-02-05 08:00:00 | AAPL | Stock | 3.3243 | 3.3264 | 3.3125 | 3.3125 | 33600.0 |
| 2009-02-05 08:05:00 | AAPL | Stock | 3.3086 | 3.3125 | 3.3079 | 3.3125 | 43120.0 |
| 2009-02-05 08:10:00 | AAPL | Stock | 3.3161 | 3.3289 | 3.3161 | 3.3289 | 78400.0 |
| 2009-02-05 08:15:00 | AAPL | Stock | 3.3214 | 3.3293 | 3.3186 | 3.3186 | 28000.0 |
| 2009-02-05 08:20:00 | AAPL | Stock | 3.32 | 3.32 | 3.32 | 3.32 | 2800.0 |
| 2009-02-05 08:25:00 | AAPL | Stock | 3.3211 | 3.3211 | 3.3175 | 3.3179 | 95200.0 |
| 2009-02-05 08:30:00 | AAPL | Stock | 3.3161 | 3.3307 | 3.3093 | 3.3189 | 315000.0 |
| 2009-02-05 08:35:00 | AAPL | Stock | 3.3179 | 3.3179 | 3.3129 | 3.315 | 95088.0 |
| 2009-02-05 08:40:00 | AAPL | Stock | 3.315 | 3.3179 | 3.315 | 3.315 | 64344.0 |
| 2009-02-05 08:45:00 | AAPL | Stock | 3.3129 | 3.3143 | 3.3107 | 3.3111 | 197400.0 |
| 2009-02-05 08:50:00 | AAPL | Stock | 3.3111 | 3.3143 | 3.3071 | 3.3143 | 178080.0 |
| 2009-02-05 08:55:00 | AAPL | Stock | 3.3143 | 3.3171 | 3.3143 | 3.3161 | 67396.0 |
| 2009-02-05 09:00:00 | AAPL | Stock | 3.3186 | 3.3186 | 3.3171 | 3.3186 | 50204.0 |
| 2009-02-05 09:05:00 | AAPL | Stock | 3.3175 | 3.3182 | 3.3161 | 3.3182 | 83412.0 |
| 2009-02-05 09:10:00 | AAPL | Stock | 3.3182 | 3.3214 | 3.3179 | 3.3179 | 72716.0 |
| 2009-02-05 09:15:00 | AAPL | Stock | 3.3182 | 3.3182 | 3.3075 | 3.3075 | 135660.0 |
| 2009-02-05 09:20:00 | AAPL | Stock | 3.3075 | 3.31 | 3.3075 | 3.31 | 221872.0 |
| 2009-02-05 09:25:00 | AAPL | Stock | 3.3107 | 3.3168 | 3.3089 | 3.315 | 241276.0 |
| 2009-02-05 09:30:00 | AAPL | Stock | 3.315 | 3.325 | 3.3079 | 3.3146 | 12287660.0 |
| 2009-02-05 09:35:00 | AAPL | Stock | 3.3143 | 3.3225 | 3.3082 | 3.3175 | 11345068.0 |
| 2009-02-05 09:40:00 | AAPL | Stock | 3.3171 | 3.3321 | 3.3107 | 3.3239 | 13088152.0 |
| 2009-02-05 09:45:00 | AAPL | Stock | 3.3243 | 3.3514 | 3.3221 | 3.3457 | 14798672.0 |
| 2009-02-05 09:50:00 | AAPL | Stock | 3.3454 | 3.3482 | 3.3282 | 3.3343 | 14342300.0 |
| 2009-02-05 09:55:00 | AAPL | Stock | 3.3339 | 3.3468 | 3.3314 | 3.3432 | 8009372.0 |
| 2009-02-05 10:00:00 | AAPL | Stock | 3.3432 | 3.3618 | 3.3343 | 3.3614 | 13700344.0 |
| 2009-02-05 10:05:00 | AAPL | Stock | 3.3611 | 3.3711 | 3.3579 | 3.3625 | 15149260.0 |
| 2009-02-05 10:10:00 | AAPL | Stock | 3.3625 | 3.3814 | 3.3607 | 3.3814 | 11521580.0 |
| 2009-02-05 10:15:00 | AAPL | Stock | 3.3814 | 3.3825 | 3.3714 | 3.3729 | 11864804.0 |
| 2009-02-05 10:20:00 | AAPL | Stock | 3.3721 | 3.3818 | 3.3696 | 3.3714 | 8558312.0 |
| 2009-02-05 10:25:00 | AAPL | Stock | 3.3714 | 3.3821 | 3.37 | 3.3711 | 6011544.0 |
| 2009-02-05 10:30:00 | AAPL | Stock | 3.3704 | 3.3786 | 3.3657 | 3.3786 | 5843992.0 |
| 2009-02-05 10:35:00 | AAPL | Stock | 3.3786 | 3.3925 | 3.3782 | 3.3904 | 8673868.0 |
| 2009-02-05 10:40:00 | AAPL | Stock | 3.3907 | 3.4064 | 3.3886 | 3.405 | 11370100.0 |
| 2009-02-05 10:45:00 | AAPL | Stock | 3.4046 | 3.4229 | 3.4039 | 3.4139 | 15368724.0 |
| 2009-02-05 10:50:00 | AAPL | Stock | 3.4146 | 3.4314 | 3.4075 | 3.425 | 15216796.0 |
| 2009-02-05 10:55:00 | AAPL | Stock | 3.4254 | 3.43 | 3.4164 | 3.4179 | 10652880.0 |
| 2009-02-05 11:00:00 | AAPL | Stock | 3.4186 | 3.4286 | 3.4111 | 3.4271 | 9773652.0 |
| 2009-02-05 11:05:00 | AAPL | Stock | 3.4268 | 3.4286 | 3.4171 | 3.42 | 7701708.0 |
| 2009-02-05 11:10:00 | AAPL | Stock | 3.4196 | 3.4214 | 3.4054 | 3.4089 | 7379820.0 |
| 2009-02-05 11:15:00 | AAPL | Stock | 3.4096 | 3.4114 | 3.3996 | 3.4096 | 7163044.0 |
| 2009-02-05 11:20:00 | AAPL | Stock | 3.4093 | 3.4143 | 3.4075 | 3.4139 | 6499080.0 |
| 2009-02-05 11:25:00 | AAPL | Stock | 3.4132 | 3.4217 | 3.4114 | 3.4204 | 7221088.0 |
| 2009-02-05 11:30:00 | AAPL | Stock | 3.4196 | 3.4293 | 3.4196 | 3.4293 | 11113564.0 |
| 2009-02-05 11:35:00 | AAPL | Stock | 3.4293 | 3.4307 | 3.4257 | 3.4268 | 9928632.0 |
| 2009-02-05 11:40:00 | AAPL | Stock | 3.4264 | 3.4286 | 3.4232 | 3.4254 | 4838400.0 |
| 2009-02-05 11:45:00 | AAPL | Stock | 3.4254 | 3.4307 | 3.4186 | 3.4226 | 7783188.0 |
| 2009-02-05 11:50:00 | AAPL | Stock | 3.4225 | 3.4304 | 3.4225 | 3.4282 | 6936048.0 |
> showing 50 of 301,589 rows — these rows as CSV