PREVIEW / stock_5min / 2009-10-29
file: by_date/stock_5min/2009/2009-10-29.parquet size: 4.8 MB rows: 325,924 symbols: 3,402
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-29 04:20:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 2800.0 |
| 2009-10-29 04:35:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 5600.0 |
| 2009-10-29 04:40:00 | AAPL | Stock | 6.8039 | 6.8039 | 6.7986 | 6.7986 | 8400.0 |
| 2009-10-29 05:00:00 | AAPL | Stock | 6.8214 | 6.8214 | 6.8214 | 6.8214 | 14000.0 |
| 2009-10-29 05:05:00 | AAPL | Stock | 6.8232 | 6.8232 | 6.8232 | 6.8232 | 5600.0 |
| 2009-10-29 05:10:00 | AAPL | Stock | 6.8232 | 6.8232 | 6.8093 | 6.8093 | 16800.0 |
| 2009-10-29 05:15:00 | AAPL | Stock | 6.8139 | 6.8139 | 6.8139 | 6.8139 | 5600.0 |
| 2009-10-29 05:20:00 | AAPL | Stock | 6.8232 | 6.8232 | 6.8232 | 6.8232 | 13776.0 |
| 2009-10-29 05:30:00 | AAPL | Stock | 6.8232 | 6.8232 | 6.8232 | 6.8232 | 5908.0 |
| 2009-10-29 06:15:00 | AAPL | Stock | 6.835 | 6.835 | 6.835 | 6.835 | 2800.0 |
| 2009-10-29 06:30:00 | AAPL | Stock | 6.8389 | 6.8389 | 6.8389 | 6.8389 | 14000.0 |
| 2009-10-29 06:40:00 | AAPL | Stock | 6.8339 | 6.8393 | 6.8214 | 6.8393 | 22400.0 |
| 2009-10-29 06:45:00 | AAPL | Stock | 6.8304 | 6.8307 | 6.8304 | 6.8307 | 5600.0 |
| 2009-10-29 06:50:00 | AAPL | Stock | 6.8307 | 6.8382 | 6.8307 | 6.8382 | 8092.0 |
| 2009-10-29 07:00:00 | AAPL | Stock | 6.8304 | 6.8382 | 6.8304 | 6.8382 | 29512.0 |
| 2009-10-29 07:05:00 | AAPL | Stock | 6.8429 | 6.8489 | 6.8429 | 6.8489 | 11200.0 |
| 2009-10-29 07:10:00 | AAPL | Stock | 6.8486 | 6.8539 | 6.8396 | 6.8539 | 25200.0 |
| 2009-10-29 07:15:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8536 | 6.8536 | 8400.0 |
| 2009-10-29 07:20:00 | AAPL | Stock | 6.8568 | 6.8568 | 6.8568 | 6.8568 | 2800.0 |
| 2009-10-29 07:25:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8571 | 6.8571 | 24360.0 |
| 2009-10-29 07:30:00 | AAPL | Stock | 6.8521 | 6.8571 | 6.8521 | 6.8571 | 5600.0 |
| 2009-10-29 07:35:00 | AAPL | Stock | 6.8496 | 6.8536 | 6.8321 | 6.8321 | 28000.0 |
| 2009-10-29 07:40:00 | AAPL | Stock | 6.8339 | 6.8429 | 6.8321 | 6.8429 | 8400.0 |
| 2009-10-29 07:45:00 | AAPL | Stock | 6.8393 | 6.8482 | 6.8321 | 6.8464 | 60200.0 |
| 2009-10-29 07:50:00 | AAPL | Stock | 6.8482 | 6.8561 | 6.8393 | 6.8561 | 25676.0 |
| 2009-10-29 08:00:00 | AAPL | Stock | 6.8393 | 6.8482 | 6.8393 | 6.8464 | 106260.0 |
| 2009-10-29 08:05:00 | AAPL | Stock | 6.8479 | 6.8564 | 6.8464 | 6.8536 | 290724.0 |
| 2009-10-29 08:10:00 | AAPL | Stock | 6.8554 | 6.8661 | 6.8536 | 6.8571 | 447552.0 |
| 2009-10-29 08:15:00 | AAPL | Stock | 6.8571 | 6.8571 | 6.8554 | 6.8564 | 220164.0 |
| 2009-10-29 08:20:00 | AAPL | Stock | 6.85 | 6.8536 | 6.8418 | 6.8418 | 37520.0 |
| 2009-10-29 08:25:00 | AAPL | Stock | 6.8482 | 6.8525 | 6.8482 | 6.8507 | 105420.0 |
| 2009-10-29 08:30:00 | AAPL | Stock | 6.8521 | 6.9643 | 6.8521 | 6.9468 | 3069528.0 |
| 2009-10-29 08:35:00 | AAPL | Stock | 6.9464 | 6.9561 | 6.9289 | 6.9418 | 2058532.0 |
| 2009-10-29 08:40:00 | AAPL | Stock | 6.9407 | 6.9646 | 6.9357 | 6.95 | 1816724.0 |
| 2009-10-29 08:45:00 | AAPL | Stock | 6.9464 | 6.9532 | 6.9382 | 6.9532 | 990836.0 |
| 2009-10-29 08:50:00 | AAPL | Stock | 6.9518 | 6.9571 | 6.95 | 6.9571 | 513436.0 |
| 2009-10-29 08:55:00 | AAPL | Stock | 6.9571 | 6.9936 | 6.9568 | 6.9911 | 2245516.0 |
| 2009-10-29 09:00:00 | AAPL | Stock | 6.99 | 6.9954 | 6.9757 | 6.9896 | 974092.0 |
| 2009-10-29 09:05:00 | AAPL | Stock | 6.9875 | 6.9946 | 6.9829 | 6.9857 | 539672.0 |
| 2009-10-29 09:10:00 | AAPL | Stock | 6.9857 | 6.9857 | 6.9718 | 6.9718 | 708484.0 |
| 2009-10-29 09:15:00 | AAPL | Stock | 6.9721 | 6.9839 | 6.9711 | 6.9825 | 504952.0 |
| 2009-10-29 09:20:00 | AAPL | Stock | 6.9825 | 6.9839 | 6.975 | 6.975 | 178668.0 |
| 2009-10-29 09:25:00 | AAPL | Stock | 6.9784 | 6.9786 | 6.9536 | 6.9593 | 612472.0 |
| 2009-10-29 09:30:00 | AAPL | Stock | 6.9596 | 6.9643 | 6.9139 | 6.9168 | 23501296.0 |
| 2009-10-29 09:35:00 | AAPL | Stock | 6.9143 | 6.9432 | 6.9057 | 6.9239 | 20219584.0 |
| 2009-10-29 09:40:00 | AAPL | Stock | 6.9236 | 6.9236 | 6.8843 | 6.885 | 19414220.0 |
| 2009-10-29 09:45:00 | AAPL | Stock | 6.885 | 6.9036 | 6.8621 | 6.8936 | 20563032.0 |
| 2009-10-29 09:50:00 | AAPL | Stock | 6.895 | 6.91 | 6.8939 | 6.9021 | 13343428.0 |
| 2009-10-29 09:55:00 | AAPL | Stock | 6.9021 | 6.9429 | 6.9018 | 6.9393 | 14043512.0 |
| 2009-10-29 10:00:00 | AAPL | Stock | 6.9421 | 6.971 | 6.9389 | 6.9679 | 20140288.0 |
> showing 50 of 325,924 rows — these rows as CSV