PREVIEW / stock_5min / 2012-10-03
file: by_date/stock_5min/2012/2012-10-03.parquet size: 4.8 MB rows: 322,018 symbols: 3,456
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-10-03 04:00:00 | AAPL | Stock | 23.6425 | 23.6964 | 23.6425 | 23.6964 | 8400.0 |
| 2012-10-03 04:05:00 | AAPL | Stock | 23.6786 | 23.6786 | 23.6714 | 23.6714 | 7672.0 |
| 2012-10-03 04:15:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.7143 | 23.7143 | 5600.0 |
| 2012-10-03 04:25:00 | AAPL | Stock | 23.7464 | 23.7464 | 23.7464 | 23.7464 | 7532.0 |
| 2012-10-03 04:55:00 | AAPL | Stock | 23.7146 | 23.7146 | 23.7143 | 23.7143 | 5600.0 |
| 2012-10-03 05:10:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 14000.0 |
| 2012-10-03 05:45:00 | AAPL | Stock | 23.75 | 23.75 | 23.75 | 23.75 | 2800.0 |
| 2012-10-03 06:05:00 | AAPL | Stock | 23.7507 | 23.7661 | 23.7507 | 23.7625 | 11200.0 |
| 2012-10-03 06:20:00 | AAPL | Stock | 23.7625 | 23.7643 | 23.7625 | 23.7643 | 7000.0 |
| 2012-10-03 06:45:00 | AAPL | Stock | 23.7518 | 23.7518 | 23.7518 | 23.7518 | 6328.0 |
| 2012-10-03 06:50:00 | AAPL | Stock | 23.7514 | 23.7514 | 23.75 | 23.75 | 32200.0 |
| 2012-10-03 07:00:00 | AAPL | Stock | 23.7161 | 23.7321 | 23.7161 | 23.7286 | 28280.0 |
| 2012-10-03 07:05:00 | AAPL | Stock | 23.7314 | 23.7479 | 23.7286 | 23.7479 | 49280.0 |
| 2012-10-03 07:15:00 | AAPL | Stock | 23.7464 | 23.7464 | 23.7375 | 23.7375 | 36400.0 |
| 2012-10-03 07:20:00 | AAPL | Stock | 23.7461 | 23.7464 | 23.7411 | 23.7411 | 12740.0 |
| 2012-10-03 07:25:00 | AAPL | Stock | 23.7411 | 23.7411 | 23.7325 | 23.7325 | 5600.0 |
| 2012-10-03 07:30:00 | AAPL | Stock | 23.7443 | 23.7461 | 23.7321 | 23.7321 | 16100.0 |
| 2012-10-03 07:35:00 | AAPL | Stock | 23.7339 | 23.745 | 23.7321 | 23.7321 | 19600.0 |
| 2012-10-03 07:40:00 | AAPL | Stock | 23.7379 | 23.7411 | 23.7357 | 23.7357 | 12600.0 |
| 2012-10-03 07:50:00 | AAPL | Stock | 23.7414 | 23.75 | 23.7393 | 23.7393 | 42448.0 |
| 2012-10-03 07:55:00 | AAPL | Stock | 23.7407 | 23.7407 | 23.7357 | 23.7357 | 29260.0 |
| 2012-10-03 08:00:00 | AAPL | Stock | 23.7325 | 23.7407 | 23.6929 | 23.6964 | 235368.0 |
| 2012-10-03 08:05:00 | AAPL | Stock | 23.6943 | 23.7025 | 23.6789 | 23.6904 | 86660.0 |
| 2012-10-03 08:10:00 | AAPL | Stock | 23.7 | 23.7161 | 23.7 | 23.7161 | 73416.0 |
| 2012-10-03 08:15:00 | AAPL | Stock | 23.7093 | 23.7282 | 23.7093 | 23.725 | 131012.0 |
| 2012-10-03 08:20:00 | AAPL | Stock | 23.7193 | 23.7193 | 23.6932 | 23.6964 | 171864.0 |
| 2012-10-03 08:25:00 | AAPL | Stock | 23.6964 | 23.7168 | 23.6964 | 23.7136 | 71624.0 |
| 2012-10-03 08:30:00 | AAPL | Stock | 23.7143 | 23.7143 | 23.6786 | 23.6786 | 246120.0 |
| 2012-10-03 08:35:00 | AAPL | Stock | 23.6679 | 23.6839 | 23.6607 | 23.6607 | 202216.0 |
| 2012-10-03 08:40:00 | AAPL | Stock | 23.6607 | 23.6607 | 23.6036 | 23.605 | 269864.0 |
| 2012-10-03 08:45:00 | AAPL | Stock | 23.6 | 23.6325 | 23.5793 | 23.6325 | 293076.0 |
| 2012-10-03 08:50:00 | AAPL | Stock | 23.6207 | 23.6468 | 23.6071 | 23.6314 | 216076.0 |
| 2012-10-03 08:55:00 | AAPL | Stock | 23.6421 | 23.6675 | 23.6321 | 23.66 | 115920.0 |
| 2012-10-03 09:00:00 | AAPL | Stock | 23.6536 | 23.685 | 23.6536 | 23.675 | 178136.0 |
| 2012-10-03 09:05:00 | AAPL | Stock | 23.6821 | 23.6886 | 23.6821 | 23.6857 | 90636.0 |
| 2012-10-03 09:10:00 | AAPL | Stock | 23.6836 | 23.7068 | 23.6832 | 23.7068 | 190372.0 |
| 2012-10-03 09:15:00 | AAPL | Stock | 23.6979 | 23.7143 | 23.6979 | 23.7082 | 131516.0 |
| 2012-10-03 09:20:00 | AAPL | Stock | 23.7 | 23.7054 | 23.6964 | 23.7054 | 97020.0 |
| 2012-10-03 09:25:00 | AAPL | Stock | 23.7007 | 23.7582 | 23.7007 | 23.75 | 775880.0 |
| 2012-10-03 09:30:00 | AAPL | Stock | 23.7496 | 23.8293 | 23.7146 | 23.8192 | 22833720.0 |
| 2012-10-03 09:35:00 | AAPL | Stock | 23.8211 | 23.8489 | 23.7543 | 23.7579 | 11495960.0 |
| 2012-10-03 09:40:00 | AAPL | Stock | 23.7582 | 23.7779 | 23.6918 | 23.6925 | 10349472.0 |
| 2012-10-03 09:45:00 | AAPL | Stock | 23.6925 | 23.7493 | 23.6925 | 23.7175 | 7337596.0 |
| 2012-10-03 09:50:00 | AAPL | Stock | 23.7136 | 23.7911 | 23.7125 | 23.7764 | 9767268.0 |
| 2012-10-03 09:55:00 | AAPL | Stock | 23.7707 | 23.7707 | 23.7054 | 23.7621 | 5495028.0 |
| 2012-10-03 10:00:00 | AAPL | Stock | 23.7621 | 23.7857 | 23.6689 | 23.7136 | 11112948.0 |
| 2012-10-03 10:05:00 | AAPL | Stock | 23.7143 | 23.7268 | 23.6654 | 23.7089 | 7556276.0 |
| 2012-10-03 10:10:00 | AAPL | Stock | 23.7086 | 23.7964 | 23.7041 | 23.7843 | 10981068.0 |
| 2012-10-03 10:15:00 | AAPL | Stock | 23.7832 | 23.8375 | 23.7561 | 23.8336 | 9682988.0 |
| 2012-10-03 10:20:00 | AAPL | Stock | 23.8336 | 23.8571 | 23.8061 | 23.8086 | 8577800.0 |
> showing 50 of 322,018 rows — these rows as CSV