PREVIEW / stock_5min / 2010-03-19
file: by_date/stock_5min/2010/2010-03-19.parquet size: 5.0 MB rows: 340,672 symbols: 3,459
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-03-19 06:15:00 | AAPL | Stock | 7.9896 | 7.9896 | 7.9896 | 7.9896 | 2800.0 |
| 2010-03-19 06:45:00 | AAPL | Stock | 7.9846 | 7.9846 | 7.9846 | 7.9846 | 5600.0 |
| 2010-03-19 06:55:00 | AAPL | Stock | 7.9871 | 7.9871 | 7.9871 | 7.9871 | 5600.0 |
| 2010-03-19 07:05:00 | AAPL | Stock | 7.9904 | 8.0 | 7.985 | 7.985 | 33600.0 |
| 2010-03-19 07:10:00 | AAPL | Stock | 8.0 | 8.0 | 8.0 | 8.0 | 2800.0 |
| 2010-03-19 07:25:00 | AAPL | Stock | 7.9893 | 7.9893 | 7.9861 | 7.9861 | 6272.0 |
| 2010-03-19 07:30:00 | AAPL | Stock | 7.9861 | 7.9861 | 7.9861 | 7.9861 | 5600.0 |
| 2010-03-19 07:50:00 | AAPL | Stock | 7.9911 | 7.9911 | 7.9911 | 7.9911 | 5600.0 |
| 2010-03-19 08:00:00 | AAPL | Stock | 7.9975 | 8.0086 | 7.9946 | 8.0086 | 205352.0 |
| 2010-03-19 08:05:00 | AAPL | Stock | 8.0054 | 8.0121 | 8.0043 | 8.0089 | 143332.0 |
| 2010-03-19 08:10:00 | AAPL | Stock | 8.0093 | 8.0093 | 8.0057 | 8.0057 | 74200.0 |
| 2010-03-19 08:15:00 | AAPL | Stock | 8.0055 | 8.0089 | 8.0004 | 8.005 | 130116.0 |
| 2010-03-19 08:20:00 | AAPL | Stock | 8.0007 | 8.005 | 8.0007 | 8.0021 | 8428.0 |
| 2010-03-19 08:25:00 | AAPL | Stock | 8.0036 | 8.0082 | 8.0036 | 8.0082 | 87192.0 |
| 2010-03-19 08:30:00 | AAPL | Stock | 8.0039 | 8.0043 | 8.0018 | 8.0018 | 33320.0 |
| 2010-03-19 08:35:00 | AAPL | Stock | 8.0018 | 8.0057 | 7.9975 | 8.0057 | 212492.0 |
| 2010-03-19 08:40:00 | AAPL | Stock | 8.0018 | 8.0036 | 8.0004 | 8.0036 | 29400.0 |
| 2010-03-19 08:45:00 | AAPL | Stock | 8.0036 | 8.0036 | 7.9957 | 7.9982 | 103796.0 |
| 2010-03-19 08:50:00 | AAPL | Stock | 8.0 | 8.0036 | 8.0 | 8.0 | 133672.0 |
| 2010-03-19 08:55:00 | AAPL | Stock | 8.0032 | 8.0036 | 7.9975 | 7.9975 | 203168.0 |
| 2010-03-19 09:00:00 | AAPL | Stock | 7.9989 | 8.0 | 7.9989 | 8.0 | 23380.0 |
| 2010-03-19 09:05:00 | AAPL | Stock | 8.0004 | 8.0025 | 8.0 | 8.0025 | 21504.0 |
| 2010-03-19 09:10:00 | AAPL | Stock | 8.0018 | 8.0032 | 8.0018 | 8.0021 | 63000.0 |
| 2010-03-19 09:15:00 | AAPL | Stock | 8.0025 | 8.0064 | 8.0025 | 8.0057 | 69020.0 |
| 2010-03-19 09:20:00 | AAPL | Stock | 8.005 | 8.005 | 7.9993 | 8.0 | 248836.0 |
| 2010-03-19 09:25:00 | AAPL | Stock | 8.0 | 8.0339 | 7.9986 | 8.0339 | 2993872.0 |
| 2010-03-19 09:30:00 | AAPL | Stock | 8.0346 | 8.0443 | 7.9925 | 7.9954 | 23590784.0 |
| 2010-03-19 09:35:00 | AAPL | Stock | 7.9957 | 7.9993 | 7.9761 | 7.9786 | 13575184.0 |
| 2010-03-19 09:40:00 | AAPL | Stock | 7.9786 | 7.9907 | 7.9618 | 7.9625 | 12371660.0 |
| 2010-03-19 09:45:00 | AAPL | Stock | 7.9625 | 7.9757 | 7.9604 | 7.965 | 10125080.0 |
| 2010-03-19 09:50:00 | AAPL | Stock | 7.9646 | 7.9782 | 7.9643 | 7.9739 | 6015996.0 |
| 2010-03-19 09:55:00 | AAPL | Stock | 7.9743 | 7.9761 | 7.9643 | 7.9746 | 5278448.0 |
| 2010-03-19 10:00:00 | AAPL | Stock | 7.9746 | 7.975 | 7.9468 | 7.9518 | 12282956.0 |
| 2010-03-19 10:05:00 | AAPL | Stock | 7.9511 | 7.9511 | 7.9307 | 7.9361 | 12275676.0 |
| 2010-03-19 10:10:00 | AAPL | Stock | 7.9356 | 7.9446 | 7.9311 | 7.9396 | 7313992.0 |
| 2010-03-19 10:15:00 | AAPL | Stock | 7.9393 | 7.9536 | 7.9339 | 7.9536 | 6748280.0 |
| 2010-03-19 10:20:00 | AAPL | Stock | 7.9529 | 7.9539 | 7.9346 | 7.9429 | 6769280.0 |
| 2010-03-19 10:25:00 | AAPL | Stock | 7.9421 | 7.9446 | 7.9346 | 7.9375 | 5776540.0 |
| 2010-03-19 10:30:00 | AAPL | Stock | 7.9375 | 7.9379 | 7.9179 | 7.9241 | 17627036.0 |
| 2010-03-19 10:35:00 | AAPL | Stock | 7.9271 | 7.9389 | 7.9246 | 7.9368 | 6958644.0 |
| 2010-03-19 10:40:00 | AAPL | Stock | 7.9361 | 7.9386 | 7.9329 | 7.9357 | 4045076.0 |
| 2010-03-19 10:45:00 | AAPL | Stock | 7.935 | 7.9375 | 7.9321 | 7.9367 | 3357564.0 |
| 2010-03-19 10:50:00 | AAPL | Stock | 7.9364 | 7.9368 | 7.9214 | 7.9261 | 5345144.0 |
| 2010-03-19 10:55:00 | AAPL | Stock | 7.9261 | 7.9318 | 7.9221 | 7.9275 | 4382280.0 |
| 2010-03-19 11:00:00 | AAPL | Stock | 7.9284 | 7.9296 | 7.9214 | 7.9224 | 3732260.0 |
| 2010-03-19 11:05:00 | AAPL | Stock | 7.9246 | 7.9361 | 7.9171 | 7.9354 | 6605592.0 |
| 2010-03-19 11:10:00 | AAPL | Stock | 7.9354 | 7.9389 | 7.915 | 7.925 | 8236312.0 |
| 2010-03-19 11:15:00 | AAPL | Stock | 7.9257 | 7.9275 | 7.9154 | 7.9268 | 5804596.0 |
| 2010-03-19 11:20:00 | AAPL | Stock | 7.9257 | 7.9336 | 7.9246 | 7.9311 | 6134604.0 |
| 2010-03-19 11:25:00 | AAPL | Stock | 7.9321 | 7.9346 | 7.9226 | 7.9256 | 5522580.0 |
> showing 50 of 340,672 rows — these rows as CSV