PREVIEW / stock_5min / 2014-01-21
file: by_date/stock_5min/2014/2014-01-21.parquet size: 5.6 MB rows: 367,220 symbols: 3,553
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-21 04:00:00 | AAPL | Stock | 19.3107 | 19.3929 | 19.3107 | 19.3571 | 18620.0 |
| 2014-01-21 04:10:00 | AAPL | Stock | 19.3571 | 19.3643 | 19.3571 | 19.3589 | 8624.0 |
| 2014-01-21 04:15:00 | AAPL | Stock | 19.3589 | 19.3782 | 19.3589 | 19.3782 | 5600.0 |
| 2014-01-21 04:25:00 | AAPL | Stock | 19.3629 | 19.3629 | 19.3629 | 19.3629 | 6300.0 |
| 2014-01-21 04:35:00 | AAPL | Stock | 19.3607 | 19.37 | 19.3607 | 19.37 | 7280.0 |
| 2014-01-21 05:00:00 | AAPL | Stock | 19.3704 | 19.3704 | 19.3704 | 19.3704 | 2800.0 |
| 2014-01-21 05:05:00 | AAPL | Stock | 19.3729 | 19.375 | 19.3729 | 19.375 | 8400.0 |
| 2014-01-21 05:10:00 | AAPL | Stock | 19.375 | 19.3786 | 19.375 | 19.3786 | 11956.0 |
| 2014-01-21 05:15:00 | AAPL | Stock | 19.3764 | 19.3764 | 19.375 | 19.375 | 14000.0 |
| 2014-01-21 05:25:00 | AAPL | Stock | 19.3921 | 19.4107 | 19.3921 | 19.4107 | 35392.0 |
| 2014-01-21 05:30:00 | AAPL | Stock | 19.3861 | 19.4079 | 19.3861 | 19.4079 | 19824.0 |
| 2014-01-21 05:35:00 | AAPL | Stock | 19.4079 | 19.4079 | 19.4079 | 19.4079 | 2800.0 |
| 2014-01-21 05:40:00 | AAPL | Stock | 19.4139 | 19.415 | 19.4139 | 19.415 | 26320.0 |
| 2014-01-21 05:50:00 | AAPL | Stock | 19.415 | 19.4161 | 19.4132 | 19.4132 | 15484.0 |
| 2014-01-21 06:05:00 | AAPL | Stock | 19.4093 | 19.4093 | 19.4093 | 19.4093 | 2800.0 |
| 2014-01-21 06:15:00 | AAPL | Stock | 19.4071 | 19.4179 | 19.4071 | 19.4143 | 18200.0 |
| 2014-01-21 06:20:00 | AAPL | Stock | 19.4161 | 19.4161 | 19.4107 | 19.4107 | 17472.0 |
| 2014-01-21 06:35:00 | AAPL | Stock | 19.4071 | 19.4071 | 19.4071 | 19.4071 | 2800.0 |
| 2014-01-21 06:40:00 | AAPL | Stock | 19.4089 | 19.4089 | 19.4071 | 19.4071 | 21952.0 |
| 2014-01-21 06:50:00 | AAPL | Stock | 19.4079 | 19.4079 | 19.4079 | 19.4079 | 2800.0 |
| 2014-01-21 06:55:00 | AAPL | Stock | 19.3929 | 19.3932 | 19.3929 | 19.3932 | 14000.0 |
| 2014-01-21 07:00:00 | AAPL | Stock | 19.3968 | 19.4279 | 19.3968 | 19.4018 | 79800.0 |
| 2014-01-21 07:10:00 | AAPL | Stock | 19.4 | 19.4 | 19.3893 | 19.3893 | 44800.0 |
| 2014-01-21 07:15:00 | AAPL | Stock | 19.3943 | 19.3943 | 19.3893 | 19.3893 | 25200.0 |
| 2014-01-21 07:20:00 | AAPL | Stock | 19.3821 | 19.3821 | 19.3821 | 19.3821 | 26236.0 |
| 2014-01-21 07:25:00 | AAPL | Stock | 19.3821 | 19.3857 | 19.3821 | 19.3839 | 45640.0 |
| 2014-01-21 07:30:00 | AAPL | Stock | 19.375 | 19.3786 | 19.355 | 19.355 | 70560.0 |
| 2014-01-21 07:35:00 | AAPL | Stock | 19.3561 | 19.3586 | 19.3479 | 19.3479 | 43540.0 |
| 2014-01-21 07:40:00 | AAPL | Stock | 19.3357 | 19.3489 | 19.3321 | 19.3343 | 116620.0 |
| 2014-01-21 07:45:00 | AAPL | Stock | 19.3389 | 19.3389 | 19.3107 | 19.3107 | 75852.0 |
| 2014-01-21 07:50:00 | AAPL | Stock | 19.3107 | 19.3143 | 19.3021 | 19.3143 | 27272.0 |
| 2014-01-21 07:55:00 | AAPL | Stock | 19.3143 | 19.3143 | 19.2614 | 19.2714 | 198884.0 |
| 2014-01-21 08:00:00 | AAPL | Stock | 19.275 | 19.3954 | 19.275 | 19.3321 | 568288.0 |
| 2014-01-21 08:05:00 | AAPL | Stock | 19.325 | 19.3304 | 19.275 | 19.275 | 257628.0 |
| 2014-01-21 08:10:00 | AAPL | Stock | 19.2771 | 19.2893 | 19.2679 | 19.275 | 160440.0 |
| 2014-01-21 08:15:00 | AAPL | Stock | 19.2732 | 19.2857 | 19.2593 | 19.2857 | 154672.0 |
| 2014-01-21 08:20:00 | AAPL | Stock | 19.28 | 19.2821 | 19.2679 | 19.2768 | 67508.0 |
| 2014-01-21 08:25:00 | AAPL | Stock | 19.2739 | 19.2782 | 19.2643 | 19.2714 | 74424.0 |
| 2014-01-21 08:30:00 | AAPL | Stock | 19.2675 | 19.3025 | 19.2675 | 19.3025 | 49672.0 |
| 2014-01-21 08:35:00 | AAPL | Stock | 19.3086 | 19.3125 | 19.2857 | 19.3014 | 254044.0 |
| 2014-01-21 08:40:00 | AAPL | Stock | 19.3036 | 19.3125 | 19.2964 | 19.3125 | 146188.0 |
| 2014-01-21 08:45:00 | AAPL | Stock | 19.3061 | 19.3125 | 19.3036 | 19.3089 | 179060.0 |
| 2014-01-21 08:50:00 | AAPL | Stock | 19.3107 | 19.3357 | 19.3093 | 19.3339 | 329756.0 |
| 2014-01-21 08:55:00 | AAPL | Stock | 19.3339 | 19.335 | 19.3214 | 19.3304 | 117460.0 |
| 2014-01-21 09:00:00 | AAPL | Stock | 19.3304 | 19.3393 | 19.3304 | 19.335 | 189196.0 |
| 2014-01-21 09:05:00 | AAPL | Stock | 19.3357 | 19.3393 | 19.3354 | 19.3393 | 331576.0 |
| 2014-01-21 09:10:00 | AAPL | Stock | 19.3393 | 19.3393 | 19.3268 | 19.3286 | 140700.0 |
| 2014-01-21 09:15:00 | AAPL | Stock | 19.3321 | 19.3389 | 19.3218 | 19.3285 | 128912.0 |
| 2014-01-21 09:20:00 | AAPL | Stock | 19.325 | 19.3339 | 19.3171 | 19.3321 | 312200.0 |
| 2014-01-21 09:25:00 | AAPL | Stock | 19.325 | 19.325 | 19.3036 | 19.3214 | 559384.0 |
> showing 50 of 367,220 rows — these rows as CSV