PREVIEW / stock_5min / 2012-05-08
file: by_date/stock_5min/2012/2012-05-08.parquet size: 5.0 MB rows: 332,083 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-08 04:10:00 | AAPL | Stock | 20.2882 | 20.2882 | 20.2882 | 20.2882 | 2800.0 |
| 2012-05-08 04:20:00 | AAPL | Stock | 20.2857 | 20.2857 | 20.2857 | 20.2857 | 2800.0 |
| 2012-05-08 04:45:00 | AAPL | Stock | 20.2854 | 20.2854 | 20.2854 | 20.2854 | 2800.0 |
| 2012-05-08 04:50:00 | AAPL | Stock | 20.2514 | 20.2514 | 20.2496 | 20.2496 | 36400.0 |
| 2012-05-08 05:35:00 | AAPL | Stock | 20.2393 | 20.2393 | 20.2143 | 20.2143 | 22288.0 |
| 2012-05-08 05:40:00 | AAPL | Stock | 20.2021 | 20.2021 | 20.2021 | 20.2021 | 10640.0 |
| 2012-05-08 06:20:00 | AAPL | Stock | 20.2311 | 20.2311 | 20.2311 | 20.2311 | 2800.0 |
| 2012-05-08 06:30:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 2800.0 |
| 2012-05-08 06:35:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 11760.0 |
| 2012-05-08 06:40:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 8400.0 |
| 2012-05-08 06:45:00 | AAPL | Stock | 20.2321 | 20.2321 | 20.2321 | 20.2321 | 5600.0 |
| 2012-05-08 06:50:00 | AAPL | Stock | 20.2354 | 20.2354 | 20.2354 | 20.2354 | 2800.0 |
| 2012-05-08 07:00:00 | AAPL | Stock | 20.2325 | 20.2589 | 20.2325 | 20.2589 | 22568.0 |
| 2012-05-08 07:05:00 | AAPL | Stock | 20.2589 | 20.2589 | 20.25 | 20.25 | 20832.0 |
| 2012-05-08 07:10:00 | AAPL | Stock | 20.25 | 20.2821 | 20.25 | 20.2821 | 29400.0 |
| 2012-05-08 07:15:00 | AAPL | Stock | 20.2882 | 20.3 | 20.2882 | 20.3 | 11200.0 |
| 2012-05-08 07:25:00 | AAPL | Stock | 20.2954 | 20.2954 | 20.2954 | 20.2954 | 2800.0 |
| 2012-05-08 07:30:00 | AAPL | Stock | 20.3032 | 20.3032 | 20.2821 | 20.2893 | 14000.0 |
| 2012-05-08 07:35:00 | AAPL | Stock | 20.2875 | 20.2939 | 20.2857 | 20.2939 | 11200.0 |
| 2012-05-08 07:40:00 | AAPL | Stock | 20.2939 | 20.2939 | 20.2939 | 20.2939 | 2800.0 |
| 2012-05-08 07:45:00 | AAPL | Stock | 20.3214 | 20.3214 | 20.3214 | 20.3214 | 10920.0 |
| 2012-05-08 07:50:00 | AAPL | Stock | 20.3071 | 20.3211 | 20.3071 | 20.3211 | 25200.0 |
| 2012-05-08 07:55:00 | AAPL | Stock | 20.3336 | 20.3571 | 20.3336 | 20.3571 | 99680.0 |
| 2012-05-08 08:00:00 | AAPL | Stock | 20.3571 | 20.41 | 20.3179 | 20.4064 | 414400.0 |
| 2012-05-08 08:05:00 | AAPL | Stock | 20.405 | 20.4407 | 20.3821 | 20.3929 | 415856.0 |
| 2012-05-08 08:10:00 | AAPL | Stock | 20.3929 | 20.4179 | 20.3893 | 20.4111 | 90356.0 |
| 2012-05-08 08:15:00 | AAPL | Stock | 20.4107 | 20.4107 | 20.3686 | 20.3686 | 242816.0 |
| 2012-05-08 08:20:00 | AAPL | Stock | 20.3589 | 20.3661 | 20.3411 | 20.3571 | 192640.0 |
| 2012-05-08 08:25:00 | AAPL | Stock | 20.3611 | 20.3611 | 20.3046 | 20.3046 | 209552.0 |
| 2012-05-08 08:30:00 | AAPL | Stock | 20.3082 | 20.3318 | 20.3007 | 20.3104 | 145964.0 |
| 2012-05-08 08:35:00 | AAPL | Stock | 20.3071 | 20.3714 | 20.3036 | 20.3643 | 195496.0 |
| 2012-05-08 08:40:00 | AAPL | Stock | 20.3575 | 20.3714 | 20.3464 | 20.3571 | 97328.0 |
| 2012-05-08 08:45:00 | AAPL | Stock | 20.3607 | 20.375 | 20.3579 | 20.375 | 111524.0 |
| 2012-05-08 08:50:00 | AAPL | Stock | 20.375 | 20.3875 | 20.3714 | 20.3786 | 127624.0 |
| 2012-05-08 08:55:00 | AAPL | Stock | 20.3804 | 20.3821 | 20.3696 | 20.3696 | 42952.0 |
| 2012-05-08 09:00:00 | AAPL | Stock | 20.3679 | 20.3693 | 20.3461 | 20.3489 | 296184.0 |
| 2012-05-08 09:05:00 | AAPL | Stock | 20.345 | 20.345 | 20.3304 | 20.3411 | 81172.0 |
| 2012-05-08 09:10:00 | AAPL | Stock | 20.3407 | 20.3468 | 20.3357 | 20.3361 | 44352.0 |
| 2012-05-08 09:15:00 | AAPL | Stock | 20.3429 | 20.3564 | 20.3332 | 20.3407 | 73780.0 |
| 2012-05-08 09:20:00 | AAPL | Stock | 20.3386 | 20.3554 | 20.3321 | 20.3321 | 49140.0 |
| 2012-05-08 09:25:00 | AAPL | Stock | 20.3304 | 20.375 | 20.3261 | 20.3529 | 685412.0 |
| 2012-05-08 09:30:00 | AAPL | Stock | 20.3554 | 20.4107 | 20.2757 | 20.2854 | 15891148.0 |
| 2012-05-08 09:35:00 | AAPL | Stock | 20.2732 | 20.2985 | 20.2143 | 20.215 | 14006916.0 |
| 2012-05-08 09:40:00 | AAPL | Stock | 20.2143 | 20.2775 | 20.1829 | 20.2268 | 10444756.0 |
| 2012-05-08 09:45:00 | AAPL | Stock | 20.2268 | 20.3089 | 20.2239 | 20.2714 | 8054928.0 |
| 2012-05-08 09:50:00 | AAPL | Stock | 20.2714 | 20.285 | 20.1879 | 20.1996 | 7671272.0 |
| 2012-05-08 09:55:00 | AAPL | Stock | 20.2018 | 20.2143 | 20.1579 | 20.1743 | 9280740.0 |
| 2012-05-08 10:00:00 | AAPL | Stock | 20.1764 | 20.1781 | 20.1293 | 20.1521 | 9235352.0 |
| 2012-05-08 10:05:00 | AAPL | Stock | 20.1476 | 20.1721 | 20.1357 | 20.1532 | 6744556.0 |
| 2012-05-08 10:10:00 | AAPL | Stock | 20.1582 | 20.2103 | 20.1414 | 20.1818 | 7422772.0 |
> showing 50 of 332,083 rows — these rows as CSV