PREVIEW / stock_5min / 2010-05-25
file: by_date/stock_5min/2010/2010-05-25.parquet size: 5.2 MB rows: 351,967 symbols: 3,494
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-05-25 04:15:00 | AAPL | Stock | 8.5714 | 8.6786 | 8.5714 | 8.6786 | 14000.0 |
| 2010-05-25 04:25:00 | AAPL | Stock | 8.6182 | 8.6182 | 8.6182 | 8.6182 | 14000.0 |
| 2010-05-25 04:45:00 | AAPL | Stock | 8.6393 | 8.6393 | 8.6393 | 8.6393 | 2800.0 |
| 2010-05-25 04:55:00 | AAPL | Stock | 8.5554 | 8.5554 | 8.5554 | 8.5554 | 4480.0 |
| 2010-05-25 05:00:00 | AAPL | Stock | 8.5714 | 8.5714 | 8.5714 | 8.5714 | 2800.0 |
| 2010-05-25 05:05:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5857 | 8.5857 | 2800.0 |
| 2010-05-25 05:10:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5857 | 8.5857 | 33600.0 |
| 2010-05-25 05:20:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5857 | 8.5857 | 7000.0 |
| 2010-05-25 05:35:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5804 | 8.5804 | 5600.0 |
| 2010-05-25 05:45:00 | AAPL | Stock | 8.5557 | 8.5557 | 8.5554 | 8.5554 | 6720.0 |
| 2010-05-25 06:00:00 | AAPL | Stock | 8.5557 | 8.5557 | 8.5554 | 8.5554 | 5600.0 |
| 2010-05-25 06:05:00 | AAPL | Stock | 8.5357 | 8.5357 | 8.5357 | 8.5357 | 14560.0 |
| 2010-05-25 06:10:00 | AAPL | Stock | 8.5554 | 8.5554 | 8.55 | 8.55 | 32200.0 |
| 2010-05-25 06:15:00 | AAPL | Stock | 8.5343 | 8.5343 | 8.5343 | 8.5343 | 14000.0 |
| 2010-05-25 06:30:00 | AAPL | Stock | 8.5732 | 8.5732 | 8.5732 | 8.5732 | 11200.0 |
| 2010-05-25 06:40:00 | AAPL | Stock | 8.5746 | 8.6018 | 8.5746 | 8.6018 | 27580.0 |
| 2010-05-25 06:55:00 | AAPL | Stock | 8.6 | 8.6214 | 8.6 | 8.6214 | 18900.0 |
| 2010-05-25 07:00:00 | AAPL | Stock | 8.6071 | 8.6089 | 8.5857 | 8.5857 | 92400.0 |
| 2010-05-25 07:05:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5714 | 8.5821 | 164052.0 |
| 2010-05-25 07:10:00 | AAPL | Stock | 8.5804 | 8.5893 | 8.5754 | 8.5889 | 30800.0 |
| 2010-05-25 07:15:00 | AAPL | Stock | 8.5786 | 8.5854 | 8.5754 | 8.5854 | 55160.0 |
| 2010-05-25 07:20:00 | AAPL | Stock | 8.5768 | 8.5786 | 8.5536 | 8.5675 | 186704.0 |
| 2010-05-25 07:25:00 | AAPL | Stock | 8.5696 | 8.5839 | 8.5696 | 8.5718 | 53200.0 |
| 2010-05-25 07:30:00 | AAPL | Stock | 8.5714 | 8.5793 | 8.5714 | 8.5793 | 81340.0 |
| 2010-05-25 07:35:00 | AAPL | Stock | 8.5725 | 8.6004 | 8.5725 | 8.5996 | 81088.0 |
| 2010-05-25 07:40:00 | AAPL | Stock | 8.5929 | 8.6029 | 8.5839 | 8.5839 | 127456.0 |
| 2010-05-25 07:45:00 | AAPL | Stock | 8.5975 | 8.6 | 8.5975 | 8.6 | 18200.0 |
| 2010-05-25 07:50:00 | AAPL | Stock | 8.5989 | 8.6 | 8.5925 | 8.5996 | 30996.0 |
| 2010-05-25 07:55:00 | AAPL | Stock | 8.6 | 8.6207 | 8.5936 | 8.6207 | 112140.0 |
| 2010-05-25 08:00:00 | AAPL | Stock | 8.6221 | 8.6339 | 8.5893 | 8.6289 | 1272236.0 |
| 2010-05-25 08:05:00 | AAPL | Stock | 8.63 | 8.6386 | 8.6118 | 8.6232 | 620032.0 |
| 2010-05-25 08:10:00 | AAPL | Stock | 8.6257 | 8.6482 | 8.6239 | 8.6343 | 479612.0 |
| 2010-05-25 08:15:00 | AAPL | Stock | 8.6361 | 8.6646 | 8.6361 | 8.6543 | 566580.0 |
| 2010-05-25 08:20:00 | AAPL | Stock | 8.6532 | 8.6604 | 8.6304 | 8.6307 | 819756.0 |
| 2010-05-25 08:25:00 | AAPL | Stock | 8.63 | 8.6446 | 8.6282 | 8.6386 | 353108.0 |
| 2010-05-25 08:30:00 | AAPL | Stock | 8.6425 | 8.6496 | 8.625 | 8.625 | 917308.0 |
| 2010-05-25 08:35:00 | AAPL | Stock | 8.625 | 8.6318 | 8.6186 | 8.6268 | 515228.0 |
| 2010-05-25 08:40:00 | AAPL | Stock | 8.6314 | 8.6321 | 8.6143 | 8.6143 | 586488.0 |
| 2010-05-25 08:45:00 | AAPL | Stock | 8.6161 | 8.6214 | 8.6089 | 8.6189 | 310016.0 |
| 2010-05-25 08:50:00 | AAPL | Stock | 8.6154 | 8.6214 | 8.602 | 8.6121 | 602420.0 |
| 2010-05-25 08:55:00 | AAPL | Stock | 8.6086 | 8.6104 | 8.5807 | 8.5936 | 536060.0 |
| 2010-05-25 09:00:00 | AAPL | Stock | 8.5939 | 8.6004 | 8.5682 | 8.5682 | 980504.0 |
| 2010-05-25 09:05:00 | AAPL | Stock | 8.5679 | 8.57 | 8.5464 | 8.5625 | 1143044.0 |
| 2010-05-25 09:10:00 | AAPL | Stock | 8.5629 | 8.5714 | 8.5579 | 8.5629 | 663628.0 |
| 2010-05-25 09:15:00 | AAPL | Stock | 8.5661 | 8.5818 | 8.5586 | 8.5796 | 526680.0 |
| 2010-05-25 09:20:00 | AAPL | Stock | 8.5807 | 8.5886 | 8.5661 | 8.5696 | 295680.0 |
| 2010-05-25 09:25:00 | AAPL | Stock | 8.5696 | 8.8129 | 8.54 | 8.5482 | 1246756.0 |
| 2010-05-25 09:30:00 | AAPL | Stock | 8.5493 | 8.5968 | 8.5125 | 8.5661 | 41026496.0 |
| 2010-05-25 09:35:00 | AAPL | Stock | 8.5654 | 8.5725 | 8.5207 | 8.5396 | 27896960.0 |
| 2010-05-25 09:40:00 | AAPL | Stock | 8.54 | 8.5523 | 8.47 | 8.5357 | 31448312.0 |
> showing 50 of 351,967 rows — these rows as CSV