PREVIEW / stock_5min / 2008-01-17
file: by_date/stock_5min/2008/2008-01-17.parquet size: 4.5 MB rows: 323,280 symbols: 3,283
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-01-17 05:30:00 | AAPL | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 12124.0 |
| 2008-01-17 05:35:00 | AAPL | Stock | 5.7679 | 5.7679 | 5.7679 | 5.7679 | 14000.0 |
| 2008-01-17 05:40:00 | AAPL | Stock | 5.7718 | 5.7718 | 5.7718 | 5.7718 | 8400.0 |
| 2008-01-17 06:20:00 | AAPL | Stock | 5.775 | 5.775 | 5.75 | 5.75 | 30800.0 |
| 2008-01-17 06:30:00 | AAPL | Stock | 5.7729 | 5.7732 | 5.7729 | 5.7732 | 39200.0 |
| 2008-01-17 06:35:00 | AAPL | Stock | 5.7661 | 5.7661 | 5.7661 | 5.7661 | 25200.0 |
| 2008-01-17 06:40:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 112000.0 |
| 2008-01-17 06:45:00 | AAPL | Stock | 5.7589 | 5.7596 | 5.7536 | 5.7596 | 16800.0 |
| 2008-01-17 06:50:00 | AAPL | Stock | 5.7661 | 5.7661 | 5.7661 | 5.7661 | 22120.0 |
| 2008-01-17 06:55:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.7589 | 5.7589 | 19600.0 |
| 2008-01-17 07:00:00 | AAPL | Stock | 5.7589 | 5.7589 | 5.75 | 5.75 | 210000.0 |
| 2008-01-17 07:05:00 | AAPL | Stock | 5.7571 | 5.7571 | 5.7343 | 5.755 | 266560.0 |
| 2008-01-17 07:10:00 | AAPL | Stock | 5.7546 | 5.755 | 5.7357 | 5.75 | 100016.0 |
| 2008-01-17 07:15:00 | AAPL | Stock | 5.7486 | 5.75 | 5.7164 | 5.7393 | 457800.0 |
| 2008-01-17 07:20:00 | AAPL | Stock | 5.7425 | 5.7425 | 5.7257 | 5.7425 | 87500.0 |
| 2008-01-17 07:25:00 | AAPL | Stock | 5.7418 | 5.7418 | 5.7321 | 5.7321 | 39200.0 |
| 2008-01-17 07:30:00 | AAPL | Stock | 5.7318 | 5.7318 | 5.7118 | 5.7232 | 522340.0 |
| 2008-01-17 07:35:00 | AAPL | Stock | 5.73 | 5.73 | 5.7214 | 5.7232 | 146888.0 |
| 2008-01-17 07:40:00 | AAPL | Stock | 5.7429 | 5.7429 | 5.7275 | 5.7404 | 34076.0 |
| 2008-01-17 07:45:00 | AAPL | Stock | 5.7393 | 5.7407 | 5.7321 | 5.7321 | 58520.0 |
| 2008-01-17 07:50:00 | AAPL | Stock | 5.7289 | 5.7375 | 5.7289 | 5.7375 | 16520.0 |
| 2008-01-17 07:55:00 | AAPL | Stock | 5.7304 | 5.7389 | 5.7304 | 5.7389 | 41440.0 |
| 2008-01-17 08:00:00 | AAPL | Stock | 5.7389 | 5.7389 | 5.7089 | 5.7089 | 1848336.0 |
| 2008-01-17 08:05:00 | AAPL | Stock | 5.7089 | 5.7211 | 5.7071 | 5.7143 | 610848.0 |
| 2008-01-17 08:10:00 | AAPL | Stock | 5.7139 | 5.7143 | 5.6986 | 5.7054 | 1152704.0 |
| 2008-01-17 08:15:00 | AAPL | Stock | 5.7054 | 5.7182 | 5.7036 | 5.7143 | 818300.0 |
| 2008-01-17 08:20:00 | AAPL | Stock | 5.7125 | 5.7143 | 5.7061 | 5.7071 | 621012.0 |
| 2008-01-17 08:25:00 | AAPL | Stock | 5.7075 | 5.7143 | 5.7018 | 5.7039 | 1234296.0 |
| 2008-01-17 08:30:00 | AAPL | Stock | 5.7039 | 5.7268 | 5.7018 | 5.7268 | 1391488.0 |
| 2008-01-17 08:35:00 | AAPL | Stock | 5.725 | 5.7461 | 5.7225 | 5.7371 | 1445752.0 |
| 2008-01-17 08:40:00 | AAPL | Stock | 5.7425 | 5.7607 | 5.7361 | 5.7589 | 1003968.0 |
| 2008-01-17 08:45:00 | AAPL | Stock | 5.7582 | 5.7661 | 5.7554 | 5.7586 | 733320.0 |
| 2008-01-17 08:50:00 | AAPL | Stock | 5.7554 | 5.8068 | 5.7554 | 5.7929 | 2800504.0 |
| 2008-01-17 08:55:00 | AAPL | Stock | 5.7889 | 5.8 | 5.7857 | 5.7939 | 1773016.0 |
| 2008-01-17 09:00:00 | AAPL | Stock | 5.7925 | 5.7936 | 5.7743 | 5.7811 | 1105720.0 |
| 2008-01-17 09:05:00 | AAPL | Stock | 5.7811 | 5.7946 | 5.7811 | 5.7875 | 1283856.0 |
| 2008-01-17 09:10:00 | AAPL | Stock | 5.7861 | 5.7964 | 5.7857 | 5.7961 | 2093700.0 |
| 2008-01-17 09:15:00 | AAPL | Stock | 5.7986 | 5.7986 | 5.7829 | 5.7954 | 690816.0 |
| 2008-01-17 09:20:00 | AAPL | Stock | 5.7946 | 5.7946 | 5.7857 | 5.7875 | 947240.0 |
| 2008-01-17 09:25:00 | AAPL | Stock | 5.7875 | 5.7879 | 5.7704 | 5.7704 | 1817704.0 |
| 2008-01-17 09:30:00 | AAPL | Stock | 5.7682 | 5.79 | 5.7429 | 5.7514 | 42161532.0 |
| 2008-01-17 09:35:00 | AAPL | Stock | 5.7507 | 5.7796 | 5.74 | 5.7668 | 38733464.0 |
| 2008-01-17 09:40:00 | AAPL | Stock | 5.7679 | 5.8264 | 5.7629 | 5.8114 | 33809048.0 |
| 2008-01-17 09:45:00 | AAPL | Stock | 5.8125 | 5.8396 | 5.7896 | 5.8289 | 29970416.0 |
| 2008-01-17 09:50:00 | AAPL | Stock | 5.8293 | 5.8482 | 5.8171 | 5.8325 | 25399220.0 |
| 2008-01-17 09:55:00 | AAPL | Stock | 5.8324 | 5.9918 | 5.8282 | 5.8318 | 24641680.0 |
| 2008-01-17 10:00:00 | AAPL | Stock | 5.8318 | 5.8364 | 5.7764 | 5.7847 | 42101416.0 |
| 2008-01-17 10:05:00 | AAPL | Stock | 5.7852 | 5.9918 | 5.7839 | 5.8254 | 29377236.0 |
| 2008-01-17 10:10:00 | AAPL | Stock | 5.825 | 5.8268 | 5.7854 | 5.8157 | 23743636.0 |
| 2008-01-17 10:15:00 | AAPL | Stock | 5.8136 | 5.8146 | 5.7407 | 5.7518 | 27445768.0 |
> showing 50 of 323,280 rows — these rows as CSV