PREVIEW / stock_5min / 2010-04-07
file: by_date/stock_5min/2010/2010-04-07.parquet size: 4.9 MB rows: 337,682 symbols: 3,485
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 |
|---|---|---|---|---|---|---|---|
| 2010-04-07 04:15:00 | AAPL | Stock | 8.5582 | 8.5582 | 8.5582 | 8.5582 | 50400.0 |
| 2010-04-07 06:15:00 | AAPL | Stock | 8.5589 | 8.5589 | 8.5589 | 8.5589 | 2800.0 |
| 2010-04-07 07:15:00 | AAPL | Stock | 8.5446 | 8.5446 | 8.5446 | 8.5446 | 2800.0 |
| 2010-04-07 07:25:00 | AAPL | Stock | 8.5425 | 8.5425 | 8.5339 | 8.5339 | 5600.0 |
| 2010-04-07 07:30:00 | AAPL | Stock | 8.5311 | 8.5311 | 8.5311 | 8.5311 | 2800.0 |
| 2010-04-07 07:35:00 | AAPL | Stock | 8.5436 | 8.5436 | 8.5436 | 8.5436 | 8400.0 |
| 2010-04-07 07:40:00 | AAPL | Stock | 8.5321 | 8.5321 | 8.5271 | 8.5282 | 38192.0 |
| 2010-04-07 07:45:00 | AAPL | Stock | 8.5339 | 8.5339 | 8.5339 | 8.5339 | 14000.0 |
| 2010-04-07 07:50:00 | AAPL | Stock | 8.5339 | 8.5339 | 8.5339 | 8.5339 | 5600.0 |
| 2010-04-07 07:55:00 | AAPL | Stock | 8.5379 | 8.5393 | 8.5361 | 8.5361 | 21420.0 |
| 2010-04-07 08:00:00 | AAPL | Stock | 8.5361 | 8.5393 | 8.5357 | 8.5382 | 190036.0 |
| 2010-04-07 08:05:00 | AAPL | Stock | 8.5382 | 8.5464 | 8.5382 | 8.5464 | 67620.0 |
| 2010-04-07 08:10:00 | AAPL | Stock | 8.5464 | 8.5468 | 8.5393 | 8.5404 | 123872.0 |
| 2010-04-07 08:15:00 | AAPL | Stock | 8.5414 | 8.5432 | 8.5375 | 8.5411 | 140700.0 |
| 2010-04-07 08:20:00 | AAPL | Stock | 8.54 | 8.54 | 8.5357 | 8.537 | 206920.0 |
| 2010-04-07 08:25:00 | AAPL | Stock | 8.5364 | 8.5425 | 8.5357 | 8.5371 | 230020.0 |
| 2010-04-07 08:30:00 | AAPL | Stock | 8.5386 | 8.5436 | 8.5361 | 8.5432 | 184604.0 |
| 2010-04-07 08:35:00 | AAPL | Stock | 8.5432 | 8.5432 | 8.5404 | 8.5414 | 147280.0 |
| 2010-04-07 08:40:00 | AAPL | Stock | 8.5432 | 8.5432 | 8.5407 | 8.5407 | 16800.0 |
| 2010-04-07 08:45:00 | AAPL | Stock | 8.5429 | 8.555 | 8.5375 | 8.5404 | 278320.0 |
| 2010-04-07 08:50:00 | AAPL | Stock | 8.5411 | 8.5411 | 8.5379 | 8.5393 | 89600.0 |
| 2010-04-07 08:55:00 | AAPL | Stock | 8.5414 | 8.5436 | 8.5404 | 8.5436 | 68040.0 |
| 2010-04-07 09:00:00 | AAPL | Stock | 8.5436 | 8.5436 | 8.5404 | 8.5425 | 120596.0 |
| 2010-04-07 09:05:00 | AAPL | Stock | 8.5425 | 8.5432 | 8.5425 | 8.5429 | 90328.0 |
| 2010-04-07 09:10:00 | AAPL | Stock | 8.5439 | 8.5454 | 8.5429 | 8.545 | 161056.0 |
| 2010-04-07 09:15:00 | AAPL | Stock | 8.5418 | 8.5429 | 8.5404 | 8.5429 | 32760.0 |
| 2010-04-07 09:20:00 | AAPL | Stock | 8.5411 | 8.5439 | 8.5411 | 8.5429 | 89600.0 |
| 2010-04-07 09:25:00 | AAPL | Stock | 8.5429 | 8.5614 | 8.5429 | 8.5557 | 495376.0 |
| 2010-04-07 09:30:00 | AAPL | Stock | 8.5557 | 8.5661 | 8.5443 | 8.5589 | 13603968.0 |
| 2010-04-07 09:35:00 | AAPL | Stock | 8.5589 | 8.5779 | 8.5536 | 8.5725 | 10267656.0 |
| 2010-04-07 09:40:00 | AAPL | Stock | 8.5741 | 8.5929 | 8.5696 | 8.5914 | 14298844.0 |
| 2010-04-07 09:45:00 | AAPL | Stock | 8.5929 | 8.6071 | 8.5857 | 8.5896 | 15570408.0 |
| 2010-04-07 09:50:00 | AAPL | Stock | 8.59 | 8.5979 | 8.5875 | 8.5935 | 6994820.0 |
| 2010-04-07 09:55:00 | AAPL | Stock | 8.5929 | 8.6029 | 8.5789 | 8.579 | 10728872.0 |
| 2010-04-07 10:00:00 | AAPL | Stock | 8.5796 | 8.5871 | 8.5761 | 8.5825 | 7379680.0 |
| 2010-04-07 10:05:00 | AAPL | Stock | 8.5829 | 8.5982 | 8.5815 | 8.5954 | 7129528.0 |
| 2010-04-07 10:10:00 | AAPL | Stock | 8.5954 | 8.6046 | 8.5907 | 8.6014 | 6880748.0 |
| 2010-04-07 10:15:00 | AAPL | Stock | 8.6025 | 8.6143 | 8.6018 | 8.6132 | 9922724.0 |
| 2010-04-07 10:20:00 | AAPL | Stock | 8.6132 | 8.6196 | 8.5979 | 8.602 | 13902560.0 |
| 2010-04-07 10:25:00 | AAPL | Stock | 8.602 | 8.6152 | 8.5982 | 8.6082 | 5263888.0 |
| 2010-04-07 10:30:00 | AAPL | Stock | 8.6082 | 8.615 | 8.6011 | 8.6086 | 6847792.0 |
| 2010-04-07 10:35:00 | AAPL | Stock | 8.6086 | 8.6225 | 8.6071 | 8.6125 | 7540596.0 |
| 2010-04-07 10:40:00 | AAPL | Stock | 8.6125 | 8.6164 | 8.59 | 8.596 | 11861920.0 |
| 2010-04-07 10:45:00 | AAPL | Stock | 8.5957 | 8.5968 | 8.5796 | 8.5925 | 10795932.0 |
| 2010-04-07 10:50:00 | AAPL | Stock | 8.5918 | 8.5971 | 8.5864 | 8.5925 | 6119652.0 |
| 2010-04-07 10:55:00 | AAPL | Stock | 8.5936 | 8.5996 | 8.5893 | 8.5986 | 5618144.0 |
| 2010-04-07 11:00:00 | AAPL | Stock | 8.5986 | 8.6014 | 8.5861 | 8.5971 | 7485744.0 |
| 2010-04-07 11:05:00 | AAPL | Stock | 8.5982 | 8.605 | 8.595 | 8.6045 | 5230428.0 |
| 2010-04-07 11:10:00 | AAPL | Stock | 8.6043 | 8.6143 | 8.5989 | 8.6136 | 6123936.0 |
| 2010-04-07 11:15:00 | AAPL | Stock | 8.6143 | 8.6164 | 8.6089 | 8.6121 | 7048076.0 |
> showing 50 of 337,682 rows — these rows as CSV