PREVIEW / stock_1min / 2013-12-02
file: by_date/stock_1min/2013/2013-12-02.parquet size: 14.7 MB rows: 1,071,548 symbols: 2,861
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-12-02 04:19:00 | AAPL | Stock | 19.8854 | 19.8854 | 19.8854 | 19.8854 | 2800.0 |
| 2013-12-02 04:25:00 | AAPL | Stock | 19.865 | 19.865 | 19.865 | 19.865 | 8400.0 |
| 2013-12-02 04:37:00 | AAPL | Stock | 19.8643 | 19.8643 | 19.8643 | 19.8643 | 2800.0 |
| 2013-12-02 04:38:00 | AAPL | Stock | 19.8643 | 19.8643 | 19.8643 | 19.8643 | 4200.0 |
| 2013-12-02 04:54:00 | AAPL | Stock | 19.9082 | 19.9082 | 19.9082 | 19.9082 | 2800.0 |
| 2013-12-02 04:55:00 | AAPL | Stock | 19.9089 | 19.9089 | 19.9089 | 19.9089 | 2800.0 |
| 2013-12-02 04:57:00 | AAPL | Stock | 19.9111 | 19.9111 | 19.9111 | 19.9111 | 2800.0 |
| 2013-12-02 05:01:00 | AAPL | Stock | 19.9236 | 19.9286 | 19.9196 | 19.9286 | 8400.0 |
| 2013-12-02 05:07:00 | AAPL | Stock | 19.9286 | 19.9286 | 19.9286 | 19.9286 | 5600.0 |
| 2013-12-02 05:13:00 | AAPL | Stock | 19.925 | 19.925 | 19.925 | 19.925 | 5600.0 |
| 2013-12-02 05:14:00 | AAPL | Stock | 19.925 | 19.925 | 19.925 | 19.925 | 2800.0 |
| 2013-12-02 05:16:00 | AAPL | Stock | 19.925 | 19.9329 | 19.925 | 19.9329 | 20524.0 |
| 2013-12-02 05:23:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:26:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:30:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:32:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:33:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 5600.0 |
| 2013-12-02 05:36:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:51:00 | AAPL | Stock | 19.9407 | 19.9407 | 19.9407 | 19.9407 | 2800.0 |
| 2013-12-02 05:53:00 | AAPL | Stock | 19.9407 | 19.9407 | 19.9407 | 19.9407 | 2800.0 |
| 2013-12-02 05:57:00 | AAPL | Stock | 19.9343 | 19.9389 | 19.9343 | 19.9389 | 11200.0 |
| 2013-12-02 06:01:00 | AAPL | Stock | 19.9446 | 19.9446 | 19.9446 | 19.9446 | 2800.0 |
| 2013-12-02 06:02:00 | AAPL | Stock | 19.9518 | 19.9579 | 19.9518 | 19.9579 | 8400.0 |
| 2013-12-02 06:08:00 | AAPL | Stock | 19.9639 | 19.9639 | 19.9639 | 19.9639 | 7280.0 |
| 2013-12-02 06:09:00 | AAPL | Stock | 19.9639 | 19.9711 | 19.9639 | 19.9711 | 19600.0 |
| 2013-12-02 06:12:00 | AAPL | Stock | 19.9925 | 19.9925 | 19.9925 | 19.9925 | 2800.0 |
| 2013-12-02 06:18:00 | AAPL | Stock | 20.0307 | 20.0307 | 20.0307 | 20.0307 | 2800.0 |
| 2013-12-02 06:19:00 | AAPL | Stock | 20.0221 | 20.0221 | 20.0221 | 20.0221 | 2800.0 |
| 2013-12-02 06:22:00 | AAPL | Stock | 20.0139 | 20.0139 | 20.0139 | 20.0139 | 2800.0 |
| 2013-12-02 06:23:00 | AAPL | Stock | 20.0339 | 20.0357 | 20.0 | 20.0 | 27300.0 |
| 2013-12-02 06:24:00 | AAPL | Stock | 20.0007 | 20.0357 | 20.0 | 20.0357 | 12600.0 |
| 2013-12-02 06:25:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 14000.0 |
| 2013-12-02 06:28:00 | AAPL | Stock | 20.0514 | 20.0714 | 20.0514 | 20.0714 | 41916.0 |
| 2013-12-02 06:29:00 | AAPL | Stock | 20.0604 | 20.0607 | 20.0604 | 20.0607 | 28000.0 |
| 2013-12-02 06:30:00 | AAPL | Stock | 20.0607 | 20.0607 | 20.0607 | 20.0607 | 2800.0 |
| 2013-12-02 06:31:00 | AAPL | Stock | 20.0554 | 20.0554 | 20.0554 | 20.0554 | 16800.0 |
| 2013-12-02 06:32:00 | AAPL | Stock | 20.0554 | 20.0554 | 20.0536 | 20.0536 | 8232.0 |
| 2013-12-02 06:33:00 | AAPL | Stock | 20.0518 | 20.0607 | 20.0518 | 20.0607 | 19600.0 |
| 2013-12-02 06:34:00 | AAPL | Stock | 20.0518 | 20.0518 | 20.0518 | 20.0518 | 2800.0 |
| 2013-12-02 06:37:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 14000.0 |
| 2013-12-02 06:42:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 8400.0 |
| 2013-12-02 06:44:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 2800.0 |
| 2013-12-02 06:45:00 | AAPL | Stock | 20.0214 | 20.0214 | 20.0214 | 20.0214 | 2800.0 |
| 2013-12-02 06:47:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 2800.0 |
| 2013-12-02 06:48:00 | AAPL | Stock | 20.025 | 20.0318 | 20.025 | 20.0318 | 19600.0 |
| 2013-12-02 06:49:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0354 | 20.0357 | 16800.0 |
| 2013-12-02 06:51:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 4620.0 |
| 2013-12-02 06:52:00 | AAPL | Stock | 20.0393 | 20.0393 | 20.0393 | 20.0393 | 14000.0 |
| 2013-12-02 06:54:00 | AAPL | Stock | 20.0393 | 20.0425 | 20.0393 | 20.0425 | 5600.0 |
| 2013-12-02 06:57:00 | AAPL | Stock | 20.0229 | 20.0229 | 20.0229 | 20.0229 | 11620.0 |
> showing 50 of 1,071,548 rows — these rows as CSV