PREVIEW / stock_5min / 2008-07-22
file: by_date/stock_5min/2008/2008-07-22.parquet size: 4.5 MB rows: 320,459 symbols: 3,325
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-22 04:00:00 | AAPL | Stock | 5.3214 | 5.3214 | 5.3214 | 5.3214 | 56000.0 |
| 2008-07-22 04:15:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 2800.0 |
| 2008-07-22 04:40:00 | AAPL | Stock | 5.3389 | 5.3389 | 5.3389 | 5.3389 | 2800.0 |
| 2008-07-22 05:00:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3264 | 5.3286 | 67200.0 |
| 2008-07-22 05:15:00 | AAPL | Stock | 5.3189 | 5.3189 | 5.3189 | 5.3189 | 5600.0 |
| 2008-07-22 05:20:00 | AAPL | Stock | 5.3189 | 5.3214 | 5.3143 | 5.3214 | 177520.0 |
| 2008-07-22 05:50:00 | AAPL | Stock | 5.3454 | 5.3454 | 5.3454 | 5.3454 | 9240.0 |
| 2008-07-22 05:55:00 | AAPL | Stock | 5.3454 | 5.3571 | 5.3454 | 5.3571 | 312760.0 |
| 2008-07-22 06:10:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 16800.0 |
| 2008-07-22 07:00:00 | AAPL | Stock | 5.3393 | 5.3571 | 5.3393 | 5.3393 | 39200.0 |
| 2008-07-22 07:05:00 | AAPL | Stock | 5.3286 | 5.3286 | 5.3114 | 5.3179 | 359800.0 |
| 2008-07-22 07:10:00 | AAPL | Stock | 5.315 | 5.3325 | 5.3143 | 5.3304 | 542080.0 |
| 2008-07-22 07:15:00 | AAPL | Stock | 5.325 | 5.3571 | 5.325 | 5.3389 | 47600.0 |
| 2008-07-22 07:20:00 | AAPL | Stock | 5.3325 | 5.3386 | 5.3214 | 5.3214 | 149100.0 |
| 2008-07-22 07:25:00 | AAPL | Stock | 5.3171 | 5.3321 | 5.3143 | 5.325 | 189560.0 |
| 2008-07-22 07:30:00 | AAPL | Stock | 5.3293 | 5.3482 | 5.325 | 5.3464 | 73388.0 |
| 2008-07-22 07:35:00 | AAPL | Stock | 5.3393 | 5.3643 | 5.3393 | 5.3507 | 701680.0 |
| 2008-07-22 07:40:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3518 | 5.3554 | 255164.0 |
| 2008-07-22 07:45:00 | AAPL | Stock | 5.3536 | 5.3554 | 5.3432 | 5.3536 | 166180.0 |
| 2008-07-22 07:50:00 | AAPL | Stock | 5.3536 | 5.3536 | 5.3311 | 5.3321 | 372708.0 |
| 2008-07-22 07:55:00 | AAPL | Stock | 5.3357 | 5.3357 | 5.3089 | 5.3143 | 805840.0 |
| 2008-07-22 08:00:00 | AAPL | Stock | 5.3089 | 5.3321 | 5.2921 | 5.3089 | 3536652.0 |
| 2008-07-22 08:05:00 | AAPL | Stock | 5.3071 | 5.3343 | 5.3032 | 5.3071 | 1744988.0 |
| 2008-07-22 08:10:00 | AAPL | Stock | 5.3107 | 5.3343 | 5.2986 | 5.3318 | 2019640.0 |
| 2008-07-22 08:15:00 | AAPL | Stock | 5.3336 | 5.3686 | 5.3321 | 5.3639 | 2676800.0 |
| 2008-07-22 08:20:00 | AAPL | Stock | 5.3636 | 5.3771 | 5.3429 | 5.3607 | 3502548.0 |
| 2008-07-22 08:25:00 | AAPL | Stock | 5.36 | 5.3636 | 5.3432 | 5.3518 | 1602860.0 |
| 2008-07-22 08:30:00 | AAPL | Stock | 5.3518 | 5.3564 | 5.3393 | 5.3493 | 986216.0 |
| 2008-07-22 08:35:00 | AAPL | Stock | 5.3496 | 5.3782 | 5.3411 | 5.3743 | 2050328.0 |
| 2008-07-22 08:40:00 | AAPL | Stock | 5.3711 | 5.3957 | 5.3646 | 5.3889 | 2878736.0 |
| 2008-07-22 08:45:00 | AAPL | Stock | 5.3896 | 5.3914 | 5.3571 | 5.3714 | 2526580.0 |
| 2008-07-22 08:50:00 | AAPL | Stock | 5.3707 | 5.3714 | 5.3107 | 5.3596 | 4735444.0 |
| 2008-07-22 08:55:00 | AAPL | Stock | 5.3571 | 5.3643 | 5.3571 | 5.3575 | 4450628.0 |
| 2008-07-22 09:00:00 | AAPL | Stock | 5.3536 | 5.3571 | 5.2932 | 5.3289 | 6619312.0 |
| 2008-07-22 09:05:00 | AAPL | Stock | 5.33 | 5.3393 | 5.3232 | 5.3357 | 3186820.0 |
| 2008-07-22 09:10:00 | AAPL | Stock | 5.3357 | 5.3536 | 5.3321 | 5.3518 | 3261720.0 |
| 2008-07-22 09:15:00 | AAPL | Stock | 5.3529 | 5.3575 | 5.3436 | 5.3489 | 4779012.0 |
| 2008-07-22 09:20:00 | AAPL | Stock | 5.3482 | 5.3536 | 5.3393 | 5.3536 | 2337132.0 |
| 2008-07-22 09:25:00 | AAPL | Stock | 5.3539 | 5.3571 | 5.3125 | 5.3207 | 9894864.0 |
| 2008-07-22 09:30:00 | AAPL | Stock | 5.3204 | 5.3571 | 5.2332 | 5.3282 | 124765088.0 |
| 2008-07-22 09:35:00 | AAPL | Stock | 5.3282 | 5.4207 | 5.3139 | 5.4189 | 78964956.0 |
| 2008-07-22 09:40:00 | AAPL | Stock | 5.4187 | 5.4286 | 5.3837 | 5.3939 | 61593364.0 |
| 2008-07-22 09:45:00 | AAPL | Stock | 5.3946 | 5.4 | 5.3182 | 5.3929 | 37842784.0 |
| 2008-07-22 09:50:00 | AAPL | Stock | 5.3923 | 5.455 | 5.3918 | 5.4436 | 53939060.0 |
| 2008-07-22 09:55:00 | AAPL | Stock | 5.4443 | 5.4554 | 5.4089 | 5.4182 | 39943148.0 |
| 2008-07-22 10:00:00 | AAPL | Stock | 5.4182 | 5.4404 | 5.4089 | 5.4232 | 36644216.0 |
| 2008-07-22 10:05:00 | AAPL | Stock | 5.4255 | 5.4543 | 5.4182 | 5.4261 | 35319872.0 |
| 2008-07-22 10:10:00 | AAPL | Stock | 5.4261 | 5.435 | 5.4 | 5.4096 | 34598844.0 |
| 2008-07-22 10:15:00 | AAPL | Stock | 5.41 | 5.48 | 5.4096 | 5.4696 | 45451420.0 |
| 2008-07-22 10:20:00 | AAPL | Stock | 5.4686 | 5.4849 | 5.4375 | 5.4582 | 30762200.0 |
> showing 50 of 320,459 rows — these rows as CSV