PREVIEW / stock_5min / 2008-03-19
file: by_date/stock_5min/2008/2008-03-19.parquet size: 4.5 MB rows: 323,706 symbols: 3,281
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-19 04:15:00 | AAPL | Stock | 4.7389 | 4.7389 | 4.7389 | 4.7389 | 2800.0 |
| 2008-03-19 05:55:00 | AAPL | Stock | 4.6875 | 4.6875 | 4.6875 | 4.6875 | 2800.0 |
| 2008-03-19 06:00:00 | AAPL | Stock | 4.6875 | 4.6875 | 4.6875 | 4.6875 | 5600.0 |
| 2008-03-19 06:35:00 | AAPL | Stock | 4.6875 | 4.6968 | 4.6782 | 4.6968 | 25200.0 |
| 2008-03-19 06:40:00 | AAPL | Stock | 4.6982 | 4.6982 | 4.6982 | 4.6982 | 8400.0 |
| 2008-03-19 06:45:00 | AAPL | Stock | 4.7086 | 4.7089 | 4.6975 | 4.6975 | 8400.0 |
| 2008-03-19 07:00:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.6982 | 4.6982 | 15400.0 |
| 2008-03-19 07:05:00 | AAPL | Stock | 4.7018 | 4.7018 | 4.7018 | 4.7018 | 22400.0 |
| 2008-03-19 07:10:00 | AAPL | Stock | 4.6943 | 4.6946 | 4.6932 | 4.6932 | 8400.0 |
| 2008-03-19 07:15:00 | AAPL | Stock | 4.7 | 4.7029 | 4.7 | 4.7029 | 30240.0 |
| 2008-03-19 07:20:00 | AAPL | Stock | 4.7057 | 4.7057 | 4.7029 | 4.7029 | 23128.0 |
| 2008-03-19 07:25:00 | AAPL | Stock | 4.7029 | 4.7107 | 4.7029 | 4.7057 | 55272.0 |
| 2008-03-19 07:30:00 | AAPL | Stock | 4.7161 | 4.7161 | 4.7057 | 4.7143 | 74480.0 |
| 2008-03-19 07:35:00 | AAPL | Stock | 4.7143 | 4.7189 | 4.7143 | 4.7189 | 28000.0 |
| 2008-03-19 07:40:00 | AAPL | Stock | 4.72 | 4.72 | 4.7179 | 4.7179 | 8988.0 |
| 2008-03-19 07:45:00 | AAPL | Stock | 4.7143 | 4.725 | 4.7071 | 4.725 | 55776.0 |
| 2008-03-19 07:50:00 | AAPL | Stock | 4.725 | 4.725 | 4.7179 | 4.7189 | 86800.0 |
| 2008-03-19 07:55:00 | AAPL | Stock | 4.7189 | 4.7229 | 4.7107 | 4.7139 | 207256.0 |
| 2008-03-19 08:00:00 | AAPL | Stock | 4.7196 | 4.7229 | 4.7143 | 4.7143 | 404208.0 |
| 2008-03-19 08:05:00 | AAPL | Stock | 4.7143 | 4.7179 | 4.7079 | 4.7079 | 127820.0 |
| 2008-03-19 08:10:00 | AAPL | Stock | 4.71 | 4.7179 | 4.7082 | 4.7179 | 261576.0 |
| 2008-03-19 08:15:00 | AAPL | Stock | 4.7168 | 4.7171 | 4.7143 | 4.7171 | 58436.0 |
| 2008-03-19 08:20:00 | AAPL | Stock | 4.7143 | 4.7175 | 4.7143 | 4.7175 | 85008.0 |
| 2008-03-19 08:25:00 | AAPL | Stock | 4.7175 | 4.7207 | 4.7143 | 4.7164 | 258748.0 |
| 2008-03-19 08:30:00 | AAPL | Stock | 4.7179 | 4.7264 | 4.7179 | 4.7214 | 400988.0 |
| 2008-03-19 08:35:00 | AAPL | Stock | 4.7239 | 4.7268 | 4.7214 | 4.7225 | 159488.0 |
| 2008-03-19 08:40:00 | AAPL | Stock | 4.7196 | 4.7243 | 4.7196 | 4.7243 | 121996.0 |
| 2008-03-19 08:45:00 | AAPL | Stock | 4.7243 | 4.7361 | 4.7243 | 4.7346 | 627844.0 |
| 2008-03-19 08:50:00 | AAPL | Stock | 4.74 | 4.7404 | 4.7304 | 4.7357 | 218540.0 |
| 2008-03-19 08:55:00 | AAPL | Stock | 4.7364 | 4.7389 | 4.7321 | 4.7321 | 171360.0 |
| 2008-03-19 09:00:00 | AAPL | Stock | 4.7314 | 4.7464 | 4.7311 | 4.7429 | 562352.0 |
| 2008-03-19 09:05:00 | AAPL | Stock | 4.7443 | 4.7571 | 4.7393 | 4.7571 | 1214304.0 |
| 2008-03-19 09:10:00 | AAPL | Stock | 4.7586 | 4.7639 | 4.7521 | 4.7632 | 1072708.0 |
| 2008-03-19 09:15:00 | AAPL | Stock | 4.7629 | 4.7664 | 4.7557 | 4.7589 | 844172.0 |
| 2008-03-19 09:20:00 | AAPL | Stock | 4.7575 | 4.7607 | 4.7525 | 4.7525 | 346612.0 |
| 2008-03-19 09:25:00 | AAPL | Stock | 4.7543 | 4.7596 | 4.7464 | 4.75 | 537600.0 |
| 2008-03-19 09:30:00 | AAPL | Stock | 4.75 | 4.7571 | 4.7232 | 4.7525 | 23897272.0 |
| 2008-03-19 09:35:00 | AAPL | Stock | 4.7539 | 4.7571 | 4.7268 | 4.7404 | 19759936.0 |
| 2008-03-19 09:40:00 | AAPL | Stock | 4.7404 | 4.7846 | 4.7375 | 4.7732 | 33822600.0 |
| 2008-03-19 09:45:00 | AAPL | Stock | 4.7732 | 4.7961 | 4.7696 | 4.7929 | 24333512.0 |
| 2008-03-19 09:50:00 | AAPL | Stock | 4.7929 | 4.7946 | 4.7643 | 4.7661 | 24615696.0 |
| 2008-03-19 09:55:00 | AAPL | Stock | 4.7671 | 4.7692 | 4.7246 | 4.725 | 22050168.0 |
| 2008-03-19 10:00:00 | AAPL | Stock | 4.7246 | 4.7586 | 4.7232 | 4.7575 | 22615544.0 |
| 2008-03-19 10:05:00 | AAPL | Stock | 4.7568 | 4.7582 | 4.7393 | 4.7468 | 14996912.0 |
| 2008-03-19 10:10:00 | AAPL | Stock | 4.7464 | 4.7554 | 4.7407 | 4.7414 | 13708016.0 |
| 2008-03-19 10:15:00 | AAPL | Stock | 4.7407 | 4.7421 | 4.7193 | 4.7286 | 15561224.0 |
| 2008-03-19 10:20:00 | AAPL | Stock | 4.7275 | 4.7493 | 4.7236 | 4.7396 | 14132356.0 |
| 2008-03-19 10:25:00 | AAPL | Stock | 4.7382 | 4.7425 | 4.7279 | 4.7346 | 10781792.0 |
| 2008-03-19 10:30:00 | AAPL | Stock | 4.7332 | 4.7371 | 4.7007 | 4.7011 | 18390260.0 |
| 2008-03-19 10:35:00 | AAPL | Stock | 4.7012 | 4.7046 | 4.6772 | 4.6846 | 26577404.0 |
> showing 50 of 323,706 rows — these rows as CSV