PREVIEW / stock_5min / 2013-12-02
file: by_date/stock_5min/2013/2013-12-02.parquet size: 5.5 MB rows: 363,264 symbols: 3,538
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:15: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:35:00 | AAPL | Stock | 19.8643 | 19.8643 | 19.8643 | 19.8643 | 7000.0 |
| 2013-12-02 04:50:00 | AAPL | Stock | 19.9082 | 19.9082 | 19.9082 | 19.9082 | 2800.0 |
| 2013-12-02 04:55:00 | AAPL | Stock | 19.9089 | 19.9111 | 19.9089 | 19.9111 | 5600.0 |
| 2013-12-02 05:00:00 | AAPL | Stock | 19.9236 | 19.9286 | 19.9196 | 19.9286 | 8400.0 |
| 2013-12-02 05:05:00 | AAPL | Stock | 19.9286 | 19.9286 | 19.9286 | 19.9286 | 5600.0 |
| 2013-12-02 05:10:00 | AAPL | Stock | 19.925 | 19.925 | 19.925 | 19.925 | 8400.0 |
| 2013-12-02 05:15:00 | AAPL | Stock | 19.925 | 19.9329 | 19.925 | 19.9329 | 20524.0 |
| 2013-12-02 05:20:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:25: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 | 11200.0 |
| 2013-12-02 05:35:00 | AAPL | Stock | 19.9268 | 19.9268 | 19.9268 | 19.9268 | 2800.0 |
| 2013-12-02 05:50:00 | AAPL | Stock | 19.9407 | 19.9407 | 19.9407 | 19.9407 | 5600.0 |
| 2013-12-02 05:55:00 | AAPL | Stock | 19.9343 | 19.9389 | 19.9343 | 19.9389 | 11200.0 |
| 2013-12-02 06:00:00 | AAPL | Stock | 19.9446 | 19.9579 | 19.9446 | 19.9579 | 11200.0 |
| 2013-12-02 06:05:00 | AAPL | Stock | 19.9639 | 19.9711 | 19.9639 | 19.9711 | 26880.0 |
| 2013-12-02 06:10:00 | AAPL | Stock | 19.9925 | 19.9925 | 19.9925 | 19.9925 | 2800.0 |
| 2013-12-02 06:15:00 | AAPL | Stock | 20.0307 | 20.0307 | 20.0221 | 20.0221 | 5600.0 |
| 2013-12-02 06:20:00 | AAPL | Stock | 20.0139 | 20.0357 | 20.0 | 20.0357 | 42700.0 |
| 2013-12-02 06:25:00 | AAPL | Stock | 20.0357 | 20.0714 | 20.0357 | 20.0607 | 83916.0 |
| 2013-12-02 06:30:00 | AAPL | Stock | 20.0607 | 20.0607 | 20.0518 | 20.0518 | 50232.0 |
| 2013-12-02 06:35:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 14000.0 |
| 2013-12-02 06:40:00 | AAPL | Stock | 20.0179 | 20.0179 | 20.0179 | 20.0179 | 11200.0 |
| 2013-12-02 06:45:00 | AAPL | Stock | 20.0214 | 20.0357 | 20.0179 | 20.0357 | 42000.0 |
| 2013-12-02 06:50:00 | AAPL | Stock | 20.0357 | 20.0425 | 20.0357 | 20.0425 | 24220.0 |
| 2013-12-02 06:55:00 | AAPL | Stock | 20.0229 | 20.0229 | 20.0229 | 20.0229 | 14840.0 |
| 2013-12-02 07:00:00 | AAPL | Stock | 20.0064 | 20.0275 | 19.9911 | 19.9911 | 127652.0 |
| 2013-12-02 07:05:00 | AAPL | Stock | 19.9893 | 20.0107 | 19.9821 | 19.9821 | 135212.0 |
| 2013-12-02 07:10:00 | AAPL | Stock | 19.9861 | 19.9861 | 19.9732 | 19.9804 | 123928.0 |
| 2013-12-02 07:15:00 | AAPL | Stock | 19.9768 | 19.9804 | 19.9639 | 19.9643 | 182924.0 |
| 2013-12-02 07:20:00 | AAPL | Stock | 19.9571 | 19.9636 | 19.9464 | 19.9464 | 101024.0 |
| 2013-12-02 07:25:00 | AAPL | Stock | 19.9525 | 19.9525 | 19.9464 | 19.9464 | 53340.0 |
| 2013-12-02 07:30:00 | AAPL | Stock | 19.9507 | 19.9732 | 19.9507 | 19.9661 | 123704.0 |
| 2013-12-02 07:35:00 | AAPL | Stock | 19.9661 | 19.9661 | 19.9464 | 19.9468 | 79100.0 |
| 2013-12-02 07:40:00 | AAPL | Stock | 19.9464 | 19.9579 | 19.9464 | 19.9579 | 19236.0 |
| 2013-12-02 07:45:00 | AAPL | Stock | 19.9621 | 19.9625 | 19.9518 | 19.9518 | 78400.0 |
| 2013-12-02 07:50:00 | AAPL | Stock | 19.9464 | 19.9489 | 19.935 | 19.9461 | 58800.0 |
| 2013-12-02 07:55:00 | AAPL | Stock | 19.9375 | 19.9529 | 19.9336 | 19.9529 | 78120.0 |
| 2013-12-02 08:00:00 | AAPL | Stock | 19.9525 | 20.0318 | 19.8393 | 19.9143 | 831152.0 |
| 2013-12-02 08:05:00 | AAPL | Stock | 19.9132 | 19.9286 | 19.9125 | 19.9286 | 151900.0 |
| 2013-12-02 08:10:00 | AAPL | Stock | 19.9268 | 19.9496 | 19.9268 | 19.9464 | 225680.0 |
| 2013-12-02 08:15:00 | AAPL | Stock | 19.94 | 19.9464 | 19.9286 | 19.9286 | 474740.0 |
| 2013-12-02 08:20:00 | AAPL | Stock | 19.9379 | 19.9464 | 19.9339 | 19.9375 | 196560.0 |
| 2013-12-02 08:25:00 | AAPL | Stock | 19.9389 | 19.9536 | 19.9389 | 19.9446 | 190708.0 |
| 2013-12-02 08:30:00 | AAPL | Stock | 19.9475 | 19.9514 | 19.9286 | 19.9375 | 240156.0 |
| 2013-12-02 08:35:00 | AAPL | Stock | 19.9336 | 19.9432 | 19.9321 | 19.9429 | 145768.0 |
| 2013-12-02 08:40:00 | AAPL | Stock | 19.9482 | 19.9564 | 19.9339 | 19.95 | 418768.0 |
| 2013-12-02 08:45:00 | AAPL | Stock | 19.9493 | 19.9554 | 19.9482 | 19.9554 | 133168.0 |
| 2013-12-02 08:50:00 | AAPL | Stock | 19.9486 | 19.9643 | 19.9482 | 19.9604 | 313264.0 |
> showing 50 of 363,264 rows — these rows as CSV