PREVIEW / stock_5min / 2013-05-10
file: by_date/stock_5min/2013/2013-05-10.parquet size: 4.9 MB rows: 327,643 symbols: 3,510
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 |
|---|---|---|---|---|---|---|---|
| 2013-05-10 04:40:00 | AAPL | Stock | 16.3332 | 16.3332 | 16.3332 | 16.3332 | 8400.0 |
| 2013-05-10 04:45:00 | AAPL | Stock | 16.3346 | 16.3386 | 16.3346 | 16.3386 | 8400.0 |
| 2013-05-10 04:50:00 | AAPL | Stock | 16.3357 | 16.3482 | 16.3357 | 16.3482 | 5600.0 |
| 2013-05-10 04:55:00 | AAPL | Stock | 16.3357 | 16.3357 | 16.3336 | 16.3336 | 81200.0 |
| 2013-05-10 05:05:00 | AAPL | Stock | 16.3336 | 16.3336 | 16.3336 | 16.3336 | 2800.0 |
| 2013-05-10 05:10:00 | AAPL | Stock | 16.3336 | 16.3336 | 16.3336 | 16.3336 | 2800.0 |
| 2013-05-10 06:30:00 | AAPL | Stock | 16.3339 | 16.3339 | 16.3339 | 16.3339 | 2800.0 |
| 2013-05-10 07:00:00 | AAPL | Stock | 16.3471 | 16.3575 | 16.3396 | 16.3571 | 36400.0 |
| 2013-05-10 07:05:00 | AAPL | Stock | 16.3721 | 16.3721 | 16.3643 | 16.3661 | 44240.0 |
| 2013-05-10 07:10:00 | AAPL | Stock | 16.3607 | 16.3739 | 16.3589 | 16.3739 | 39200.0 |
| 2013-05-10 07:15:00 | AAPL | Stock | 16.3679 | 16.3929 | 16.3679 | 16.3929 | 68460.0 |
| 2013-05-10 07:20:00 | AAPL | Stock | 16.3932 | 16.4086 | 16.3889 | 16.4086 | 194320.0 |
| 2013-05-10 07:25:00 | AAPL | Stock | 16.4032 | 16.4032 | 16.3929 | 16.3929 | 19824.0 |
| 2013-05-10 07:30:00 | AAPL | Stock | 16.3761 | 16.3761 | 16.3761 | 16.3761 | 2800.0 |
| 2013-05-10 07:35:00 | AAPL | Stock | 16.3636 | 16.3636 | 16.3607 | 16.3607 | 22400.0 |
| 2013-05-10 07:40:00 | AAPL | Stock | 16.3414 | 16.3529 | 16.3414 | 16.3529 | 11200.0 |
| 2013-05-10 07:45:00 | AAPL | Stock | 16.3621 | 16.375 | 16.3571 | 16.375 | 46060.0 |
| 2013-05-10 07:50:00 | AAPL | Stock | 16.35 | 16.3507 | 16.3482 | 16.3482 | 27300.0 |
| 2013-05-10 07:55:00 | AAPL | Stock | 16.3554 | 16.3571 | 16.3554 | 16.3571 | 11200.0 |
| 2013-05-10 08:00:00 | AAPL | Stock | 16.375 | 16.4089 | 16.3536 | 16.3668 | 177268.0 |
| 2013-05-10 08:05:00 | AAPL | Stock | 16.3686 | 16.3686 | 16.3571 | 16.3686 | 56868.0 |
| 2013-05-10 08:10:00 | AAPL | Stock | 16.3779 | 16.3779 | 16.3411 | 16.3418 | 374864.0 |
| 2013-05-10 08:15:00 | AAPL | Stock | 16.3446 | 16.3746 | 16.3404 | 16.3746 | 150360.0 |
| 2013-05-10 08:20:00 | AAPL | Stock | 16.3604 | 16.3625 | 16.3571 | 16.3625 | 84000.0 |
| 2013-05-10 08:30:00 | AAPL | Stock | 16.3625 | 16.3625 | 16.3571 | 16.3571 | 53900.0 |
| 2013-05-10 08:35:00 | AAPL | Stock | 16.3496 | 16.3571 | 16.3475 | 16.3475 | 44800.0 |
| 2013-05-10 08:40:00 | AAPL | Stock | 16.3446 | 16.3571 | 16.3432 | 16.3557 | 22400.0 |
| 2013-05-10 08:45:00 | AAPL | Stock | 16.3464 | 16.3571 | 16.3464 | 16.3571 | 70252.0 |
| 2013-05-10 08:50:00 | AAPL | Stock | 16.3571 | 16.3661 | 16.3536 | 16.3571 | 126000.0 |
| 2013-05-10 08:55:00 | AAPL | Stock | 16.3579 | 16.3614 | 16.3536 | 16.3536 | 45164.0 |
| 2013-05-10 09:00:00 | AAPL | Stock | 16.35 | 16.35 | 16.345 | 16.345 | 25060.0 |
| 2013-05-10 09:05:00 | AAPL | Stock | 16.3464 | 16.3536 | 16.345 | 16.3536 | 82348.0 |
| 2013-05-10 09:10:00 | AAPL | Stock | 16.3564 | 16.36 | 16.3461 | 16.3461 | 92540.0 |
| 2013-05-10 09:15:00 | AAPL | Stock | 16.3446 | 16.3554 | 16.3446 | 16.3464 | 50400.0 |
| 2013-05-10 09:20:00 | AAPL | Stock | 16.3464 | 16.3529 | 16.3446 | 16.3507 | 291284.0 |
| 2013-05-10 09:25:00 | AAPL | Stock | 16.3464 | 16.3625 | 16.3446 | 16.355 | 420896.0 |
| 2013-05-10 09:30:00 | AAPL | Stock | 16.3554 | 16.4182 | 16.3071 | 16.3814 | 15856484.0 |
| 2013-05-10 09:35:00 | AAPL | Stock | 16.3825 | 16.4029 | 16.3214 | 16.3421 | 7377692.0 |
| 2013-05-10 09:40:00 | AAPL | Stock | 16.3407 | 16.3643 | 16.2964 | 16.3343 | 8444912.0 |
| 2013-05-10 09:45:00 | AAPL | Stock | 16.3361 | 16.3361 | 16.2921 | 16.3036 | 6472368.0 |
| 2013-05-10 09:50:00 | AAPL | Stock | 16.3068 | 16.3143 | 16.2704 | 16.2857 | 9079896.0 |
| 2013-05-10 09:55:00 | AAPL | Stock | 16.2825 | 16.3204 | 16.2696 | 16.3094 | 8224664.0 |
| 2013-05-10 10:00:00 | AAPL | Stock | 16.3082 | 16.35 | 16.3036 | 16.3404 | 8713628.0 |
| 2013-05-10 10:05:00 | AAPL | Stock | 16.3418 | 16.3493 | 16.305 | 16.3091 | 4525696.0 |
| 2013-05-10 10:10:00 | AAPL | Stock | 16.3089 | 16.32 | 16.2832 | 16.3143 | 4211536.0 |
| 2013-05-10 10:15:00 | AAPL | Stock | 16.3169 | 16.3182 | 16.2839 | 16.2936 | 3114944.0 |
| 2013-05-10 10:20:00 | AAPL | Stock | 16.2975 | 16.2979 | 16.1986 | 16.2246 | 12348812.0 |
| 2013-05-10 10:25:00 | AAPL | Stock | 16.2243 | 16.2304 | 16.1639 | 16.1904 | 12982424.0 |
| 2013-05-10 10:30:00 | AAPL | Stock | 16.1906 | 16.1914 | 16.0886 | 16.0893 | 15718808.0 |
| 2013-05-10 10:35:00 | AAPL | Stock | 16.0905 | 16.1475 | 16.0904 | 16.1257 | 10739764.0 |
> showing 50 of 327,643 rows — these rows as CSV