PREVIEW / stock_5min / 2012-09-19
file: by_date/stock_5min/2012/2012-09-19.parquet size: 4.8 MB rows: 323,872 symbols: 3,472
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-09-19 04:00:00 | AAPL | Stock | 25.1429 | 25.1429 | 25.1321 | 25.1321 | 43316.0 |
| 2012-09-19 04:10:00 | AAPL | Stock | 25.1107 | 25.1107 | 25.1071 | 25.1071 | 17192.0 |
| 2012-09-19 04:20:00 | AAPL | Stock | 25.1071 | 25.1071 | 25.1071 | 25.1071 | 2800.0 |
| 2012-09-19 04:25:00 | AAPL | Stock | 25.1071 | 25.1071 | 25.1071 | 25.1071 | 2800.0 |
| 2012-09-19 04:30:00 | AAPL | Stock | 25.1071 | 25.1071 | 25.1071 | 25.1071 | 9240.0 |
| 2012-09-19 04:40:00 | AAPL | Stock | 25.1071 | 25.1071 | 25.1071 | 25.1071 | 9968.0 |
| 2012-09-19 04:45:00 | AAPL | Stock | 25.1079 | 25.1079 | 25.1071 | 25.1071 | 5600.0 |
| 2012-09-19 04:55:00 | AAPL | Stock | 25.0957 | 25.1057 | 25.0957 | 25.1057 | 8400.0 |
| 2012-09-19 05:00:00 | AAPL | Stock | 25.0714 | 25.0714 | 25.0714 | 25.0714 | 2800.0 |
| 2012-09-19 05:20:00 | AAPL | Stock | 25.0989 | 25.0989 | 25.0989 | 25.0989 | 2800.0 |
| 2012-09-19 05:35:00 | AAPL | Stock | 25.0989 | 25.0989 | 25.0989 | 25.0989 | 6580.0 |
| 2012-09-19 05:50:00 | AAPL | Stock | 25.0893 | 25.0893 | 25.0893 | 25.0893 | 11200.0 |
| 2012-09-19 05:55:00 | AAPL | Stock | 25.0911 | 25.0911 | 25.0911 | 25.0911 | 5320.0 |
| 2012-09-19 06:00:00 | AAPL | Stock | 25.0982 | 25.0982 | 25.0982 | 25.0982 | 4704.0 |
| 2012-09-19 06:30:00 | AAPL | Stock | 25.0964 | 25.0982 | 25.0964 | 25.0982 | 5600.0 |
| 2012-09-19 06:35:00 | AAPL | Stock | 25.0857 | 25.0857 | 25.0857 | 25.0857 | 3920.0 |
| 2012-09-19 07:00:00 | AAPL | Stock | 25.0929 | 25.0929 | 25.0714 | 25.0714 | 121800.0 |
| 2012-09-19 07:05:00 | AAPL | Stock | 25.0714 | 25.0714 | 25.0607 | 25.0607 | 20608.0 |
| 2012-09-19 07:10:00 | AAPL | Stock | 25.075 | 25.075 | 25.0679 | 25.0714 | 44520.0 |
| 2012-09-19 07:15:00 | AAPL | Stock | 25.0711 | 25.0814 | 25.0711 | 25.0714 | 76776.0 |
| 2012-09-19 07:20:00 | AAPL | Stock | 25.0679 | 25.0679 | 25.0679 | 25.0679 | 2800.0 |
| 2012-09-19 07:25:00 | AAPL | Stock | 25.0679 | 25.0679 | 25.0357 | 25.0357 | 53592.0 |
| 2012-09-19 07:30:00 | AAPL | Stock | 25.0429 | 25.0429 | 25.0361 | 25.0361 | 9100.0 |
| 2012-09-19 07:35:00 | AAPL | Stock | 25.0482 | 25.0482 | 25.0482 | 25.0482 | 5600.0 |
| 2012-09-19 07:40:00 | AAPL | Stock | 25.0371 | 25.0464 | 25.0371 | 25.0393 | 28924.0 |
| 2012-09-19 07:45:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0357 | 25.0357 | 2800.0 |
| 2012-09-19 07:50:00 | AAPL | Stock | 25.0357 | 25.0421 | 25.0311 | 25.0357 | 40320.0 |
| 2012-09-19 07:55:00 | AAPL | Stock | 25.0357 | 25.0357 | 25.0286 | 25.0286 | 15400.0 |
| 2012-09-19 08:00:00 | AAPL | Stock | 25.0343 | 25.0714 | 25.025 | 25.0607 | 241696.0 |
| 2012-09-19 08:05:00 | AAPL | Stock | 25.0536 | 25.0679 | 25.0461 | 25.0536 | 238952.0 |
| 2012-09-19 08:10:00 | AAPL | Stock | 25.0596 | 25.0596 | 25.0071 | 25.0071 | 332360.0 |
| 2012-09-19 08:15:00 | AAPL | Stock | 25.0036 | 25.0107 | 24.9929 | 25.0071 | 218344.0 |
| 2012-09-19 08:20:00 | AAPL | Stock | 25.0064 | 25.0286 | 25.0032 | 25.0286 | 156156.0 |
| 2012-09-19 08:25:00 | AAPL | Stock | 25.0311 | 25.0357 | 25.0071 | 25.0075 | 196868.0 |
| 2012-09-19 08:30:00 | AAPL | Stock | 25.0071 | 25.0268 | 25.0071 | 25.0236 | 181160.0 |
| 2012-09-19 08:35:00 | AAPL | Stock | 25.0236 | 25.0311 | 25.0161 | 25.0279 | 119224.0 |
| 2012-09-19 08:40:00 | AAPL | Stock | 25.0164 | 25.025 | 25.0164 | 25.025 | 23856.0 |
| 2012-09-19 08:45:00 | AAPL | Stock | 25.025 | 25.0464 | 25.025 | 25.0457 | 295708.0 |
| 2012-09-19 08:50:00 | AAPL | Stock | 25.045 | 25.0532 | 25.0393 | 25.0486 | 317800.0 |
| 2012-09-19 08:55:00 | AAPL | Stock | 25.0432 | 25.0532 | 25.0429 | 25.0532 | 163436.0 |
| 2012-09-19 09:00:00 | AAPL | Stock | 25.0532 | 25.0532 | 25.0411 | 25.0411 | 128296.0 |
| 2012-09-19 09:05:00 | AAPL | Stock | 25.0454 | 25.0511 | 25.0179 | 25.0179 | 765044.0 |
| 2012-09-19 09:10:00 | AAPL | Stock | 25.0182 | 25.0218 | 25.0057 | 25.0143 | 484484.0 |
| 2012-09-19 09:15:00 | AAPL | Stock | 25.0111 | 25.0161 | 25.0 | 25.0 | 506632.0 |
| 2012-09-19 09:20:00 | AAPL | Stock | 25.0046 | 25.0146 | 24.9964 | 25.0071 | 270788.0 |
| 2012-09-19 09:25:00 | AAPL | Stock | 25.0107 | 25.025 | 25.0071 | 25.0089 | 380492.0 |
| 2012-09-19 09:30:00 | AAPL | Stock | 25.0164 | 25.0536 | 24.9846 | 25.0161 | 14324968.0 |
| 2012-09-19 09:35:00 | AAPL | Stock | 25.0179 | 25.0657 | 25.0114 | 25.0491 | 9550436.0 |
| 2012-09-19 09:40:00 | AAPL | Stock | 25.0389 | 25.1214 | 25.0296 | 25.1019 | 12909652.0 |
| 2012-09-19 09:45:00 | AAPL | Stock | 25.1054 | 25.125 | 25.0779 | 25.0918 | 8908172.0 |
> showing 50 of 323,872 rows — these rows as CSV