PREVIEW / stock_5min / 2012-01-03
file: by_date/stock_5min/2012/2012-01-03.parquet size: 4.9 MB rows: 334,457 symbols: 3,574
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-01-03 04:00:00 | AAPL | Stock | 14.4571 | 14.7143 | 14.4571 | 14.7143 | 77252.0 |
| 2012-01-03 04:05:00 | AAPL | Stock | 14.6786 | 14.6786 | 14.6786 | 14.6786 | 2800.0 |
| 2012-01-03 04:20:00 | AAPL | Stock | 14.7107 | 14.7143 | 14.7107 | 14.7143 | 30800.0 |
| 2012-01-03 04:55:00 | AAPL | Stock | 14.7196 | 14.7429 | 14.7196 | 14.7429 | 6160.0 |
| 2012-01-03 05:15:00 | AAPL | Stock | 14.7375 | 14.7375 | 14.7375 | 14.7375 | 2800.0 |
| 2012-01-03 05:25:00 | AAPL | Stock | 14.7357 | 14.7357 | 14.7357 | 14.7357 | 2800.0 |
| 2012-01-03 05:35:00 | AAPL | Stock | 14.6786 | 14.6786 | 14.6786 | 14.6786 | 25200.0 |
| 2012-01-03 05:40:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 2800.0 |
| 2012-01-03 05:50:00 | AAPL | Stock | 14.7036 | 14.7036 | 14.7036 | 14.7036 | 5600.0 |
| 2012-01-03 05:55:00 | AAPL | Stock | 14.6904 | 14.6904 | 14.6904 | 14.6904 | 15820.0 |
| 2012-01-03 06:00:00 | AAPL | Stock | 14.6904 | 14.6904 | 14.6904 | 14.6904 | 2800.0 |
| 2012-01-03 06:10:00 | AAPL | Stock | 14.7143 | 14.7143 | 14.7143 | 14.7143 | 5600.0 |
| 2012-01-03 06:15:00 | AAPL | Stock | 14.7125 | 14.7125 | 14.6904 | 14.6904 | 14000.0 |
| 2012-01-03 06:25:00 | AAPL | Stock | 14.6964 | 14.6964 | 14.6964 | 14.6964 | 19600.0 |
| 2012-01-03 06:30:00 | AAPL | Stock | 14.6964 | 14.6964 | 14.6964 | 14.6964 | 7280.0 |
| 2012-01-03 06:35:00 | AAPL | Stock | 14.6904 | 14.6904 | 14.6596 | 14.6596 | 38584.0 |
| 2012-01-03 06:45:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6607 | 14.6607 | 2800.0 |
| 2012-01-03 06:50:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6607 | 14.6607 | 53200.0 |
| 2012-01-03 07:00:00 | AAPL | Stock | 14.6782 | 14.6782 | 14.6429 | 14.6429 | 112000.0 |
| 2012-01-03 07:05:00 | AAPL | Stock | 14.6289 | 14.6421 | 14.6268 | 14.6286 | 122080.0 |
| 2012-01-03 07:10:00 | AAPL | Stock | 14.6357 | 14.6443 | 14.6357 | 14.6429 | 16800.0 |
| 2012-01-03 07:15:00 | AAPL | Stock | 14.6357 | 14.6429 | 14.6357 | 14.6429 | 8400.0 |
| 2012-01-03 07:20:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6357 | 14.6429 | 36400.0 |
| 2012-01-03 07:25:00 | AAPL | Stock | 14.6432 | 14.6432 | 14.6393 | 14.6393 | 19600.0 |
| 2012-01-03 07:30:00 | AAPL | Stock | 14.6339 | 14.6429 | 14.6339 | 14.6425 | 64736.0 |
| 2012-01-03 07:35:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6286 | 14.6286 | 36400.0 |
| 2012-01-03 07:40:00 | AAPL | Stock | 14.6275 | 14.6475 | 14.6275 | 14.6475 | 91280.0 |
| 2012-01-03 07:45:00 | AAPL | Stock | 14.6368 | 14.6475 | 14.6368 | 14.6475 | 69468.0 |
| 2012-01-03 07:50:00 | AAPL | Stock | 14.6436 | 14.6436 | 14.6429 | 14.6429 | 23940.0 |
| 2012-01-03 07:55:00 | AAPL | Stock | 14.6429 | 14.6429 | 14.6268 | 14.6293 | 97748.0 |
| 2012-01-03 08:00:00 | AAPL | Stock | 14.6607 | 14.6607 | 14.6071 | 14.6161 | 567168.0 |
| 2012-01-03 08:05:00 | AAPL | Stock | 14.6146 | 14.6161 | 14.5964 | 14.6018 | 175084.0 |
| 2012-01-03 08:10:00 | AAPL | Stock | 14.5964 | 14.6071 | 14.5754 | 14.5964 | 480816.0 |
| 2012-01-03 08:15:00 | AAPL | Stock | 14.5929 | 14.6068 | 14.5893 | 14.6064 | 100240.0 |
| 2012-01-03 08:20:00 | AAPL | Stock | 14.605 | 14.6071 | 14.4643 | 14.6018 | 706356.0 |
| 2012-01-03 08:25:00 | AAPL | Stock | 14.5979 | 14.5996 | 14.5929 | 14.5996 | 40236.0 |
| 2012-01-03 08:30:00 | AAPL | Stock | 14.5936 | 14.6 | 14.575 | 14.5968 | 405804.0 |
| 2012-01-03 08:35:00 | AAPL | Stock | 14.6 | 14.6 | 14.5893 | 14.5964 | 39340.0 |
| 2012-01-03 08:40:00 | AAPL | Stock | 14.6011 | 14.6032 | 14.5964 | 14.6025 | 38080.0 |
| 2012-01-03 08:45:00 | AAPL | Stock | 14.5996 | 14.6018 | 14.5821 | 14.5911 | 161896.0 |
| 2012-01-03 08:50:00 | AAPL | Stock | 14.5896 | 14.5896 | 14.5764 | 14.5764 | 259952.0 |
| 2012-01-03 08:55:00 | AAPL | Stock | 14.5771 | 14.5893 | 14.5771 | 14.5893 | 295540.0 |
| 2012-01-03 09:00:00 | AAPL | Stock | 14.5918 | 14.6036 | 14.4643 | 14.6 | 341628.0 |
| 2012-01-03 09:05:00 | AAPL | Stock | 14.6 | 14.6121 | 14.5975 | 14.5975 | 740740.0 |
| 2012-01-03 09:10:00 | AAPL | Stock | 14.6086 | 14.6236 | 14.5993 | 14.6136 | 555184.0 |
| 2012-01-03 09:15:00 | AAPL | Stock | 14.6146 | 14.6146 | 14.6071 | 14.61 | 345268.0 |
| 2012-01-03 09:20:00 | AAPL | Stock | 14.61 | 14.6139 | 14.5986 | 14.6 | 458360.0 |
| 2012-01-03 09:25:00 | AAPL | Stock | 14.6054 | 14.6389 | 14.5932 | 14.6179 | 773920.0 |
| 2012-01-03 09:30:00 | AAPL | Stock | 14.6179 | 14.6429 | 14.6071 | 14.6354 | 18421228.0 |
| 2012-01-03 09:35:00 | AAPL | Stock | 14.6354 | 14.6964 | 14.6329 | 14.6889 | 13824804.0 |
> showing 50 of 334,457 rows — these rows as CSV