PREVIEW / stock_5min / 2012-02-15
file: by_date/stock_5min/2012/2012-02-15.parquet size: 5.0 MB rows: 333,341 symbols: 3,536
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-02-15 04:00:00 | AAPL | Stock | 18.2982 | 18.4921 | 18.2982 | 18.4921 | 19600.0 |
| 2012-02-15 04:05:00 | AAPL | Stock | 18.4982 | 18.5 | 18.4643 | 18.5 | 8400.0 |
| 2012-02-15 04:10:00 | AAPL | Stock | 18.5 | 18.5243 | 18.5 | 18.5 | 14000.0 |
| 2012-02-15 04:15:00 | AAPL | Stock | 18.5 | 18.5 | 18.5 | 18.5 | 19460.0 |
| 2012-02-15 04:30:00 | AAPL | Stock | 18.4821 | 18.4821 | 18.4821 | 18.4821 | 2800.0 |
| 2012-02-15 04:35:00 | AAPL | Stock | 18.4911 | 18.4911 | 18.4893 | 18.4893 | 5600.0 |
| 2012-02-15 04:45:00 | AAPL | Stock | 18.4825 | 18.4893 | 18.4643 | 18.4643 | 35000.0 |
| 2012-02-15 04:50:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4571 | 18.4643 | 47600.0 |
| 2012-02-15 04:55:00 | AAPL | Stock | 18.4607 | 18.4607 | 18.4493 | 18.4493 | 5600.0 |
| 2012-02-15 05:05:00 | AAPL | Stock | 18.4554 | 18.4554 | 18.4536 | 18.4536 | 11200.0 |
| 2012-02-15 05:10:00 | AAPL | Stock | 18.4893 | 18.4893 | 18.4893 | 18.4893 | 11200.0 |
| 2012-02-15 05:30:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 7000.0 |
| 2012-02-15 05:35:00 | AAPL | Stock | 18.4589 | 18.4643 | 18.4554 | 18.4643 | 34888.0 |
| 2012-02-15 05:40:00 | AAPL | Stock | 18.4482 | 18.4482 | 18.4325 | 18.4325 | 13832.0 |
| 2012-02-15 05:55:00 | AAPL | Stock | 18.4575 | 18.4575 | 18.4561 | 18.4561 | 17780.0 |
| 2012-02-15 06:00:00 | AAPL | Stock | 18.4536 | 18.4536 | 18.4536 | 18.4536 | 28000.0 |
| 2012-02-15 06:05:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 56000.0 |
| 2012-02-15 06:20:00 | AAPL | Stock | 18.455 | 18.455 | 18.4464 | 18.4464 | 25200.0 |
| 2012-02-15 06:25:00 | AAPL | Stock | 18.4536 | 18.4604 | 18.4464 | 18.4604 | 154000.0 |
| 2012-02-15 06:30:00 | AAPL | Stock | 18.455 | 18.4604 | 18.455 | 18.4604 | 11760.0 |
| 2012-02-15 06:35:00 | AAPL | Stock | 18.4561 | 18.4561 | 18.4464 | 18.4464 | 18200.0 |
| 2012-02-15 06:40:00 | AAPL | Stock | 18.45 | 18.45 | 18.45 | 18.45 | 12600.0 |
| 2012-02-15 06:45:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4429 | 18.4429 | 13580.0 |
| 2012-02-15 06:50:00 | AAPL | Stock | 18.4429 | 18.4429 | 18.4429 | 18.4429 | 3220.0 |
| 2012-02-15 06:55:00 | AAPL | Stock | 18.4464 | 18.4532 | 18.4464 | 18.4532 | 32452.0 |
| 2012-02-15 07:00:00 | AAPL | Stock | 18.4393 | 18.4536 | 18.4107 | 18.4179 | 319340.0 |
| 2012-02-15 07:05:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4018 | 18.4179 | 65520.0 |
| 2012-02-15 07:10:00 | AAPL | Stock | 18.4179 | 18.4257 | 18.3929 | 18.42 | 105168.0 |
| 2012-02-15 07:15:00 | AAPL | Stock | 18.4218 | 18.4286 | 18.4179 | 18.4286 | 67200.0 |
| 2012-02-15 07:20:00 | AAPL | Stock | 18.4321 | 18.4339 | 18.4179 | 18.4246 | 51268.0 |
| 2012-02-15 07:25:00 | AAPL | Stock | 18.4196 | 18.4268 | 18.4196 | 18.4229 | 37940.0 |
| 2012-02-15 07:30:00 | AAPL | Stock | 18.4239 | 18.4421 | 18.4232 | 18.4286 | 376264.0 |
| 2012-02-15 07:35:00 | AAPL | Stock | 18.4336 | 18.4421 | 18.4286 | 18.4286 | 90440.0 |
| 2012-02-15 07:40:00 | AAPL | Stock | 18.4286 | 18.4404 | 18.4286 | 18.4404 | 84224.0 |
| 2012-02-15 07:45:00 | AAPL | Stock | 18.4393 | 18.4414 | 18.4286 | 18.4286 | 124460.0 |
| 2012-02-15 07:50:00 | AAPL | Stock | 18.4289 | 18.4346 | 18.4204 | 18.4271 | 463372.0 |
| 2012-02-15 07:55:00 | AAPL | Stock | 18.42 | 18.4286 | 18.4118 | 18.4143 | 266280.0 |
| 2012-02-15 08:00:00 | AAPL | Stock | 18.4143 | 18.4386 | 18.3929 | 18.4164 | 738640.0 |
| 2012-02-15 08:05:00 | AAPL | Stock | 18.4132 | 18.4604 | 18.3821 | 18.3868 | 1015504.0 |
| 2012-02-15 08:10:00 | AAPL | Stock | 18.3929 | 18.3982 | 18.3679 | 18.3679 | 788312.0 |
| 2012-02-15 08:15:00 | AAPL | Stock | 18.3679 | 18.37 | 18.3446 | 18.3568 | 936544.0 |
| 2012-02-15 08:20:00 | AAPL | Stock | 18.3532 | 18.3571 | 18.3414 | 18.3529 | 168056.0 |
| 2012-02-15 08:25:00 | AAPL | Stock | 18.3518 | 18.3661 | 18.3514 | 18.3589 | 400316.0 |
| 2012-02-15 08:30:00 | AAPL | Stock | 18.3589 | 18.3589 | 18.34 | 18.3429 | 452312.0 |
| 2012-02-15 08:35:00 | AAPL | Stock | 18.3464 | 18.3679 | 18.3432 | 18.3564 | 722596.0 |
| 2012-02-15 08:40:00 | AAPL | Stock | 18.3568 | 18.3571 | 18.3475 | 18.3518 | 187656.0 |
| 2012-02-15 08:45:00 | AAPL | Stock | 18.3511 | 18.3661 | 18.325 | 18.3325 | 785764.0 |
| 2012-02-15 08:50:00 | AAPL | Stock | 18.3268 | 18.3304 | 18.3111 | 18.3214 | 654360.0 |
| 2012-02-15 08:55:00 | AAPL | Stock | 18.3214 | 18.3214 | 18.2786 | 18.2789 | 1509088.0 |
| 2012-02-15 09:00:00 | AAPL | Stock | 18.2814 | 18.3057 | 18.2768 | 18.2807 | 1242640.0 |
> showing 50 of 333,341 rows — these rows as CSV