PREVIEW / stock_5min / 2009-08-18
file: by_date/stock_5min/2009/2009-08-18.parquet size: 4.6 MB rows: 317,128 symbols: 3,369
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-18 04:35:00 | AAPL | Stock | 5.7389 | 5.7389 | 5.7389 | 5.7389 | 25200.0 |
| 2009-08-18 05:50:00 | AAPL | Stock | 5.7357 | 5.7357 | 5.7357 | 5.7357 | 5600.0 |
| 2009-08-18 06:00:00 | AAPL | Stock | 5.7482 | 5.75 | 5.7482 | 5.75 | 58436.0 |
| 2009-08-18 06:10:00 | AAPL | Stock | 5.7496 | 5.7496 | 5.7496 | 5.7496 | 27860.0 |
| 2009-08-18 06:20:00 | AAPL | Stock | 5.75 | 5.7711 | 5.75 | 5.75 | 25200.0 |
| 2009-08-18 06:25:00 | AAPL | Stock | 5.7429 | 5.7429 | 5.7429 | 5.7429 | 8400.0 |
| 2009-08-18 07:00:00 | AAPL | Stock | 5.7429 | 5.7429 | 5.7393 | 5.7393 | 8960.0 |
| 2009-08-18 07:05:00 | AAPL | Stock | 5.7639 | 5.7639 | 5.7639 | 5.7639 | 2800.0 |
| 2009-08-18 07:10:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 16240.0 |
| 2009-08-18 07:20:00 | AAPL | Stock | 5.7482 | 5.7482 | 5.7482 | 5.7482 | 2800.0 |
| 2009-08-18 07:25:00 | AAPL | Stock | 5.75 | 5.7518 | 5.75 | 5.7518 | 75600.0 |
| 2009-08-18 07:30:00 | AAPL | Stock | 5.7571 | 5.7571 | 5.75 | 5.7571 | 96040.0 |
| 2009-08-18 07:35:00 | AAPL | Stock | 5.7507 | 5.7571 | 5.7507 | 5.7571 | 18760.0 |
| 2009-08-18 07:40:00 | AAPL | Stock | 5.7589 | 5.7821 | 5.7589 | 5.7761 | 343000.0 |
| 2009-08-18 07:45:00 | AAPL | Stock | 5.7757 | 5.79 | 5.7714 | 5.7714 | 390320.0 |
| 2009-08-18 07:50:00 | AAPL | Stock | 5.7764 | 5.7768 | 5.7679 | 5.775 | 51660.0 |
| 2009-08-18 07:55:00 | AAPL | Stock | 5.7732 | 5.7746 | 5.7679 | 5.7746 | 58100.0 |
| 2009-08-18 08:00:00 | AAPL | Stock | 5.775 | 5.7768 | 5.7661 | 5.7696 | 611856.0 |
| 2009-08-18 08:05:00 | AAPL | Stock | 5.7707 | 5.7739 | 5.7661 | 5.7689 | 286832.0 |
| 2009-08-18 08:10:00 | AAPL | Stock | 5.7714 | 5.7839 | 5.7696 | 5.7811 | 468020.0 |
| 2009-08-18 08:15:00 | AAPL | Stock | 5.7811 | 5.7811 | 5.7679 | 5.7714 | 236264.0 |
| 2009-08-18 08:20:00 | AAPL | Stock | 5.77 | 5.7761 | 5.77 | 5.775 | 131040.0 |
| 2009-08-18 08:25:00 | AAPL | Stock | 5.7746 | 5.7768 | 5.7693 | 5.7693 | 396732.0 |
| 2009-08-18 08:30:00 | AAPL | Stock | 5.7693 | 5.7732 | 5.7593 | 5.7714 | 318780.0 |
| 2009-08-18 08:35:00 | AAPL | Stock | 5.7693 | 5.7732 | 5.7679 | 5.7711 | 253148.0 |
| 2009-08-18 08:40:00 | AAPL | Stock | 5.7736 | 5.7736 | 5.7714 | 5.7732 | 264124.0 |
| 2009-08-18 08:45:00 | AAPL | Stock | 5.7732 | 5.7811 | 5.7732 | 5.78 | 492380.0 |
| 2009-08-18 08:50:00 | AAPL | Stock | 5.7796 | 5.7804 | 5.7775 | 5.7796 | 178584.0 |
| 2009-08-18 08:55:00 | AAPL | Stock | 5.7796 | 5.7832 | 5.7782 | 5.7789 | 792904.0 |
| 2009-08-18 09:00:00 | AAPL | Stock | 5.7789 | 5.7821 | 5.7768 | 5.78 | 279832.0 |
| 2009-08-18 09:05:00 | AAPL | Stock | 5.7814 | 5.7896 | 5.7804 | 5.7875 | 693980.0 |
| 2009-08-18 09:10:00 | AAPL | Stock | 5.7886 | 5.7893 | 5.7854 | 5.7871 | 391384.0 |
| 2009-08-18 09:15:00 | AAPL | Stock | 5.7868 | 5.7907 | 5.7821 | 5.785 | 237664.0 |
| 2009-08-18 09:20:00 | AAPL | Stock | 5.7843 | 5.7843 | 5.7714 | 5.775 | 162400.0 |
| 2009-08-18 09:25:00 | AAPL | Stock | 5.7754 | 5.7786 | 5.7679 | 5.7739 | 366800.0 |
| 2009-08-18 09:30:00 | AAPL | Stock | 5.7725 | 5.8036 | 5.7646 | 5.784 | 27423816.0 |
| 2009-08-18 09:35:00 | AAPL | Stock | 5.7857 | 5.8036 | 5.7786 | 5.7868 | 13463212.0 |
| 2009-08-18 09:40:00 | AAPL | Stock | 5.7868 | 5.7996 | 5.7757 | 5.7947 | 12473412.0 |
| 2009-08-18 09:45:00 | AAPL | Stock | 5.7943 | 5.7964 | 5.7814 | 5.7925 | 8591632.0 |
| 2009-08-18 09:50:00 | AAPL | Stock | 5.7929 | 5.8029 | 5.7804 | 5.8018 | 10841040.0 |
| 2009-08-18 09:55:00 | AAPL | Stock | 5.8018 | 5.8089 | 5.7879 | 5.7943 | 11188324.0 |
| 2009-08-18 10:00:00 | AAPL | Stock | 5.7943 | 5.805 | 5.7875 | 5.8004 | 8918896.0 |
| 2009-08-18 10:05:00 | AAPL | Stock | 5.8 | 5.8132 | 5.7996 | 5.8068 | 9961532.0 |
| 2009-08-18 10:10:00 | AAPL | Stock | 5.8068 | 5.8143 | 5.8039 | 5.8071 | 8352792.0 |
| 2009-08-18 10:15:00 | AAPL | Stock | 5.8079 | 5.8132 | 5.8018 | 5.8032 | 6281408.0 |
| 2009-08-18 10:20:00 | AAPL | Stock | 5.8032 | 5.8057 | 5.7946 | 5.7999 | 5580512.0 |
| 2009-08-18 10:25:00 | AAPL | Stock | 5.8 | 5.8011 | 5.7933 | 5.7954 | 7182028.0 |
| 2009-08-18 10:30:00 | AAPL | Stock | 5.7954 | 5.8054 | 5.7904 | 5.8046 | 5122432.0 |
| 2009-08-18 10:35:00 | AAPL | Stock | 5.8043 | 5.8057 | 5.7946 | 5.8014 | 4190900.0 |
| 2009-08-18 10:40:00 | AAPL | Stock | 5.8021 | 5.8043 | 5.7961 | 5.7979 | 3202612.0 |
> showing 50 of 317,128 rows — these rows as CSV