PREVIEW / stock_5min / 2012-02-13
file: by_date/stock_5min/2012/2012-02-13.parquet size: 4.9 MB rows: 328,059 symbols: 3,545
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-13 04:00:00 | AAPL | Stock | 17.6139 | 17.8479 | 17.6139 | 17.8464 | 22400.0 |
| 2012-02-13 04:05:00 | AAPL | Stock | 17.83 | 17.8393 | 17.83 | 17.8393 | 28980.0 |
| 2012-02-13 04:15:00 | AAPL | Stock | 17.8268 | 17.8268 | 17.8268 | 17.8268 | 5600.0 |
| 2012-02-13 04:20:00 | AAPL | Stock | 17.825 | 17.825 | 17.825 | 17.825 | 5600.0 |
| 2012-02-13 04:25:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 22400.0 |
| 2012-02-13 04:30:00 | AAPL | Stock | 17.8214 | 17.8321 | 17.8214 | 17.825 | 11200.0 |
| 2012-02-13 04:35:00 | AAPL | Stock | 17.8232 | 17.8232 | 17.8232 | 17.8232 | 5600.0 |
| 2012-02-13 04:40:00 | AAPL | Stock | 17.8314 | 17.8314 | 17.8314 | 17.8314 | 2800.0 |
| 2012-02-13 04:50:00 | AAPL | Stock | 17.8321 | 17.8393 | 17.8321 | 17.8393 | 6720.0 |
| 2012-02-13 04:55:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 3948.0 |
| 2012-02-13 05:05:00 | AAPL | Stock | 17.8268 | 17.8286 | 17.8268 | 17.8286 | 21252.0 |
| 2012-02-13 05:10:00 | AAPL | Stock | 17.8286 | 17.8286 | 17.8214 | 17.8214 | 26824.0 |
| 2012-02-13 05:15:00 | AAPL | Stock | 17.8171 | 17.8171 | 17.8171 | 17.8171 | 11536.0 |
| 2012-02-13 05:25:00 | AAPL | Stock | 17.8132 | 17.8132 | 17.8132 | 17.8132 | 8400.0 |
| 2012-02-13 05:30:00 | AAPL | Stock | 17.8132 | 17.8132 | 17.8132 | 17.8132 | 8400.0 |
| 2012-02-13 05:35:00 | AAPL | Stock | 17.8214 | 17.8321 | 17.8214 | 17.8286 | 24920.0 |
| 2012-02-13 05:40:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8214 | 17.8214 | 7000.0 |
| 2012-02-13 05:45:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 18760.0 |
| 2012-02-13 05:50:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 16800.0 |
| 2012-02-13 05:55:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8214 | 17.8286 | 8400.0 |
| 2012-02-13 06:05:00 | AAPL | Stock | 17.8286 | 17.8286 | 17.8286 | 17.8286 | 2800.0 |
| 2012-02-13 06:15:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8321 | 17.8321 | 4480.0 |
| 2012-02-13 06:25:00 | AAPL | Stock | 17.8286 | 17.8343 | 17.8286 | 17.8343 | 6580.0 |
| 2012-02-13 06:30:00 | AAPL | Stock | 17.8389 | 17.8393 | 17.8389 | 17.8393 | 45080.0 |
| 2012-02-13 06:40:00 | AAPL | Stock | 17.825 | 17.8357 | 17.825 | 17.8357 | 14000.0 |
| 2012-02-13 06:50:00 | AAPL | Stock | 17.8357 | 17.8357 | 17.8357 | 17.8357 | 6160.0 |
| 2012-02-13 06:55:00 | AAPL | Stock | 17.8321 | 17.8321 | 17.8214 | 17.8321 | 44520.0 |
| 2012-02-13 07:00:00 | AAPL | Stock | 17.8214 | 17.8214 | 17.8125 | 17.8214 | 179200.0 |
| 2012-02-13 07:05:00 | AAPL | Stock | 17.8214 | 17.825 | 17.8125 | 17.8125 | 90300.0 |
| 2012-02-13 07:10:00 | AAPL | Stock | 17.8125 | 17.8207 | 17.8125 | 17.8207 | 113400.0 |
| 2012-02-13 07:15:00 | AAPL | Stock | 17.82 | 17.8375 | 17.8075 | 17.8075 | 350000.0 |
| 2012-02-13 07:20:00 | AAPL | Stock | 17.8107 | 17.8157 | 17.8036 | 17.8064 | 19460.0 |
| 2012-02-13 07:25:00 | AAPL | Stock | 17.8075 | 17.8218 | 17.8071 | 17.8211 | 198324.0 |
| 2012-02-13 07:30:00 | AAPL | Stock | 17.8282 | 17.8282 | 17.8111 | 17.8207 | 178080.0 |
| 2012-02-13 07:35:00 | AAPL | Stock | 17.815 | 17.8204 | 17.815 | 17.8179 | 20720.0 |
| 2012-02-13 07:40:00 | AAPL | Stock | 17.8168 | 17.8207 | 17.8168 | 17.8207 | 27944.0 |
| 2012-02-13 07:45:00 | AAPL | Stock | 17.8211 | 17.8214 | 17.8179 | 17.8214 | 107912.0 |
| 2012-02-13 07:50:00 | AAPL | Stock | 17.8211 | 17.8257 | 17.8179 | 17.8179 | 243964.0 |
| 2012-02-13 07:55:00 | AAPL | Stock | 17.8168 | 17.8214 | 17.8132 | 17.8211 | 120960.0 |
| 2012-02-13 08:00:00 | AAPL | Stock | 17.8211 | 17.8257 | 17.8068 | 17.8168 | 690592.0 |
| 2012-02-13 08:05:00 | AAPL | Stock | 17.8146 | 17.8189 | 17.8143 | 17.8189 | 197008.0 |
| 2012-02-13 08:10:00 | AAPL | Stock | 17.8189 | 17.8214 | 17.8107 | 17.8207 | 226856.0 |
| 2012-02-13 08:15:00 | AAPL | Stock | 17.82 | 17.8257 | 17.8125 | 17.8211 | 861336.0 |
| 2012-02-13 08:20:00 | AAPL | Stock | 17.8214 | 17.8257 | 17.8179 | 17.8182 | 292992.0 |
| 2012-02-13 08:25:00 | AAPL | Stock | 17.8196 | 17.8257 | 17.8196 | 17.8196 | 289324.0 |
| 2012-02-13 08:30:00 | AAPL | Stock | 17.8214 | 17.8471 | 17.7968 | 17.8393 | 1718892.0 |
| 2012-02-13 08:35:00 | AAPL | Stock | 17.8354 | 17.8539 | 17.8289 | 17.8454 | 757680.0 |
| 2012-02-13 08:40:00 | AAPL | Stock | 17.8489 | 17.855 | 17.8429 | 17.8443 | 693196.0 |
| 2012-02-13 08:45:00 | AAPL | Stock | 17.8439 | 17.85 | 17.8429 | 17.8475 | 659652.0 |
| 2012-02-13 08:50:00 | AAPL | Stock | 17.8454 | 17.8482 | 17.8311 | 17.8332 | 492744.0 |
> showing 50 of 328,059 rows — these rows as CSV