PREVIEW / stock_5min / 2009-11-16
file: by_date/stock_5min/2009/2009-11-16.parquet size: 4.8 MB rows: 327,759 symbols: 3,433
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-11-16 06:15:00 | AAPL | Stock | 7.35 | 7.35 | 7.35 | 7.35 | 2800.0 |
| 2009-11-16 07:05:00 | AAPL | Stock | 7.3543 | 7.3546 | 7.3543 | 7.3546 | 5600.0 |
| 2009-11-16 07:10:00 | AAPL | Stock | 7.3568 | 7.3568 | 7.3554 | 7.3554 | 10640.0 |
| 2009-11-16 07:15:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 5600.0 |
| 2009-11-16 07:20:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3529 | 7.3529 | 119840.0 |
| 2009-11-16 07:25:00 | AAPL | Stock | 7.3536 | 7.3536 | 7.3536 | 7.3536 | 2800.0 |
| 2009-11-16 07:30:00 | AAPL | Stock | 7.3536 | 7.3554 | 7.3536 | 7.3554 | 10360.0 |
| 2009-11-16 07:40:00 | AAPL | Stock | 7.3554 | 7.3554 | 7.3554 | 7.3554 | 33600.0 |
| 2009-11-16 07:45:00 | AAPL | Stock | 7.3518 | 7.3518 | 7.3375 | 7.3375 | 299600.0 |
| 2009-11-16 07:50:00 | AAPL | Stock | 7.3393 | 7.3393 | 7.3286 | 7.3304 | 132188.0 |
| 2009-11-16 07:55:00 | AAPL | Stock | 7.33 | 7.3304 | 7.3286 | 7.3286 | 16800.0 |
| 2009-11-16 08:00:00 | AAPL | Stock | 7.3318 | 7.354 | 7.3214 | 7.3446 | 1005340.0 |
| 2009-11-16 08:05:00 | AAPL | Stock | 7.3461 | 7.3482 | 7.3371 | 7.3389 | 355796.0 |
| 2009-11-16 08:10:00 | AAPL | Stock | 7.3389 | 7.3393 | 7.3286 | 7.3321 | 188636.0 |
| 2009-11-16 08:15:00 | AAPL | Stock | 7.3307 | 7.3386 | 7.3261 | 7.3386 | 364028.0 |
| 2009-11-16 08:20:00 | AAPL | Stock | 7.3386 | 7.3393 | 7.3339 | 7.3393 | 112392.0 |
| 2009-11-16 08:25:00 | AAPL | Stock | 7.3389 | 7.3393 | 7.3318 | 7.3375 | 238868.0 |
| 2009-11-16 08:30:00 | AAPL | Stock | 7.3354 | 7.3393 | 7.3279 | 7.335 | 306516.0 |
| 2009-11-16 08:35:00 | AAPL | Stock | 7.3325 | 7.3357 | 7.3321 | 7.3354 | 139020.0 |
| 2009-11-16 08:40:00 | AAPL | Stock | 7.3357 | 7.3371 | 7.3357 | 7.3357 | 44800.0 |
| 2009-11-16 08:45:00 | AAPL | Stock | 7.3373 | 7.3393 | 7.3357 | 7.3386 | 200676.0 |
| 2009-11-16 08:50:00 | AAPL | Stock | 7.3393 | 7.3393 | 7.3364 | 7.3389 | 236600.0 |
| 2009-11-16 08:55:00 | AAPL | Stock | 7.3375 | 7.3436 | 7.3375 | 7.343 | 325780.0 |
| 2009-11-16 09:00:00 | AAPL | Stock | 7.3425 | 7.3425 | 7.3389 | 7.3393 | 71960.0 |
| 2009-11-16 09:05:00 | AAPL | Stock | 7.3411 | 7.3429 | 7.3382 | 7.3429 | 93940.0 |
| 2009-11-16 09:10:00 | AAPL | Stock | 7.3429 | 7.3479 | 7.3429 | 7.3471 | 230636.0 |
| 2009-11-16 09:15:00 | AAPL | Stock | 7.3464 | 7.3479 | 7.3432 | 7.3461 | 199332.0 |
| 2009-11-16 09:20:00 | AAPL | Stock | 7.3432 | 7.3432 | 7.3396 | 7.34 | 113400.0 |
| 2009-11-16 09:25:00 | AAPL | Stock | 7.3432 | 7.3443 | 7.3339 | 7.3361 | 289968.0 |
| 2009-11-16 09:30:00 | AAPL | Stock | 7.3371 | 7.3536 | 7.3218 | 7.3536 | 19387900.0 |
| 2009-11-16 09:35:00 | AAPL | Stock | 7.3514 | 7.3707 | 7.347 | 7.3672 | 17196564.0 |
| 2009-11-16 09:40:00 | AAPL | Stock | 7.3668 | 7.3907 | 7.3657 | 7.3882 | 16108484.0 |
| 2009-11-16 09:45:00 | AAPL | Stock | 7.3886 | 7.3981 | 7.3771 | 7.3943 | 13040944.0 |
| 2009-11-16 09:50:00 | AAPL | Stock | 7.3942 | 7.4286 | 7.3857 | 7.4229 | 16040108.0 |
| 2009-11-16 09:55:00 | AAPL | Stock | 7.4236 | 7.4286 | 7.405 | 7.405 | 14217728.0 |
| 2009-11-16 10:00:00 | AAPL | Stock | 7.4054 | 7.4182 | 7.3975 | 7.4175 | 11383288.0 |
| 2009-11-16 10:05:00 | AAPL | Stock | 7.4171 | 7.4268 | 7.4149 | 7.4161 | 12034708.0 |
| 2009-11-16 10:10:00 | AAPL | Stock | 7.4157 | 7.4214 | 7.4111 | 7.4175 | 7643412.0 |
| 2009-11-16 10:15:00 | AAPL | Stock | 7.4175 | 7.4243 | 7.415 | 7.4225 | 6343092.0 |
| 2009-11-16 10:20:00 | AAPL | Stock | 7.4225 | 7.4271 | 7.4161 | 7.4204 | 7813540.0 |
| 2009-11-16 10:25:00 | AAPL | Stock | 7.4204 | 7.4286 | 7.4146 | 7.415 | 6326236.0 |
| 2009-11-16 10:30:00 | AAPL | Stock | 7.415 | 7.4264 | 7.4143 | 7.4207 | 4687872.0 |
| 2009-11-16 10:35:00 | AAPL | Stock | 7.4211 | 7.4211 | 7.3929 | 7.4014 | 12371380.0 |
| 2009-11-16 10:40:00 | AAPL | Stock | 7.4014 | 7.4071 | 7.3971 | 7.4039 | 5985392.0 |
| 2009-11-16 10:45:00 | AAPL | Stock | 7.405 | 7.4064 | 7.3964 | 7.3964 | 3837680.0 |
| 2009-11-16 10:50:00 | AAPL | Stock | 7.3957 | 7.4018 | 7.3861 | 7.4 | 6963936.0 |
| 2009-11-16 10:55:00 | AAPL | Stock | 7.4004 | 7.41 | 7.3982 | 7.4039 | 4885160.0 |
| 2009-11-16 11:00:00 | AAPL | Stock | 7.4036 | 7.4057 | 7.3982 | 7.4046 | 2956576.0 |
| 2009-11-16 11:05:00 | AAPL | Stock | 7.4037 | 7.415 | 7.4037 | 7.4039 | 4779264.0 |
| 2009-11-16 11:10:00 | AAPL | Stock | 7.4039 | 7.4052 | 7.3982 | 7.4007 | 2599100.0 |
> showing 50 of 327,759 rows — these rows as CSV