PREVIEW / stock_5min / 2005-10-19
file: by_date/stock_5min/2005/2005-10-19.parquet size: 2.9 MB rows: 208,111 symbols: 2,099
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 |
|---|---|---|---|---|---|---|---|
| 2005-10-19 07:40:00 | AAPL | Stock | 1.8461 | 1.8461 | 1.8461 | 1.8461 | 11200.0 |
| 2005-10-19 07:55:00 | AAPL | Stock | 1.8464 | 1.8464 | 1.8464 | 1.8464 | 32480.0 |
| 2005-10-19 08:00:00 | AAPL | Stock | 1.845 | 1.8571 | 1.845 | 1.8529 | 403732.0 |
| 2005-10-19 08:05:00 | AAPL | Stock | 1.8514 | 1.8514 | 1.8429 | 1.8429 | 354900.0 |
| 2005-10-19 08:10:00 | AAPL | Stock | 1.8464 | 1.8514 | 1.8411 | 1.8468 | 274120.0 |
| 2005-10-19 08:15:00 | AAPL | Stock | 1.8468 | 1.8468 | 1.8429 | 1.8446 | 255780.0 |
| 2005-10-19 08:20:00 | AAPL | Stock | 1.8439 | 1.8446 | 1.8411 | 1.8411 | 135940.0 |
| 2005-10-19 08:25:00 | AAPL | Stock | 1.8414 | 1.8421 | 1.8357 | 1.8393 | 483980.0 |
| 2005-10-19 08:30:00 | AAPL | Stock | 1.8393 | 1.8514 | 1.8393 | 1.8514 | 482720.0 |
| 2005-10-19 08:35:00 | AAPL | Stock | 1.8514 | 1.8521 | 1.8489 | 1.8493 | 323092.0 |
| 2005-10-19 08:40:00 | AAPL | Stock | 1.8493 | 1.85 | 1.8493 | 1.85 | 12460.0 |
| 2005-10-19 08:45:00 | AAPL | Stock | 1.8507 | 1.8507 | 1.8489 | 1.8489 | 77812.0 |
| 2005-10-19 08:50:00 | AAPL | Stock | 1.8486 | 1.8511 | 1.8486 | 1.8489 | 134904.0 |
| 2005-10-19 08:55:00 | AAPL | Stock | 1.8511 | 1.8521 | 1.8486 | 1.8514 | 86800.0 |
| 2005-10-19 09:00:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.85 | 1.8511 | 81200.0 |
| 2005-10-19 09:05:00 | AAPL | Stock | 1.8518 | 1.8518 | 1.8496 | 1.8496 | 49420.0 |
| 2005-10-19 09:10:00 | AAPL | Stock | 1.8496 | 1.8546 | 1.8496 | 1.8546 | 233324.0 |
| 2005-10-19 09:15:00 | AAPL | Stock | 1.8554 | 1.8571 | 1.8518 | 1.8529 | 272160.0 |
| 2005-10-19 09:20:00 | AAPL | Stock | 1.8529 | 1.8536 | 1.8529 | 1.8532 | 14000.0 |
| 2005-10-19 09:25:00 | AAPL | Stock | 1.8536 | 1.8625 | 1.8532 | 1.8596 | 708960.0 |
| 2005-10-19 09:30:00 | AAPL | Stock | 1.8596 | 1.8632 | 1.8489 | 1.8525 | 15516368.0 |
| 2005-10-19 09:35:00 | AAPL | Stock | 1.8525 | 1.8532 | 1.8461 | 1.8493 | 10427368.0 |
| 2005-10-19 09:40:00 | AAPL | Stock | 1.8493 | 1.8529 | 1.8482 | 1.8514 | 8157856.0 |
| 2005-10-19 09:45:00 | AAPL | Stock | 1.8507 | 1.8514 | 1.8375 | 1.8379 | 9978472.0 |
| 2005-10-19 09:50:00 | AAPL | Stock | 1.8375 | 1.8454 | 1.8375 | 1.8436 | 10941000.0 |
| 2005-10-19 09:55:00 | AAPL | Stock | 1.8432 | 1.8539 | 1.8425 | 1.8518 | 9176104.0 |
| 2005-10-19 10:00:00 | AAPL | Stock | 1.8518 | 1.8554 | 1.8514 | 1.8546 | 5928888.0 |
| 2005-10-19 10:05:00 | AAPL | Stock | 1.8546 | 1.8636 | 1.8536 | 1.8618 | 10724308.0 |
| 2005-10-19 10:10:00 | AAPL | Stock | 1.8621 | 1.8661 | 1.8504 | 1.8511 | 12811512.0 |
| 2005-10-19 10:15:00 | AAPL | Stock | 1.8511 | 1.855 | 1.8493 | 1.8525 | 8665048.0 |
| 2005-10-19 10:20:00 | AAPL | Stock | 1.8528 | 1.855 | 1.85 | 1.85 | 5701304.0 |
| 2005-10-19 10:25:00 | AAPL | Stock | 1.85 | 1.8518 | 1.8457 | 1.8457 | 7021588.0 |
| 2005-10-19 10:30:00 | AAPL | Stock | 1.8461 | 1.8571 | 1.8461 | 1.8514 | 9539824.0 |
| 2005-10-19 10:35:00 | AAPL | Stock | 1.8521 | 1.8607 | 1.8507 | 1.8607 | 9483320.0 |
| 2005-10-19 10:40:00 | AAPL | Stock | 1.8604 | 1.8639 | 1.8575 | 1.8625 | 8963220.0 |
| 2005-10-19 10:45:00 | AAPL | Stock | 1.8625 | 1.8625 | 1.8557 | 1.8575 | 5401088.0 |
| 2005-10-19 10:50:00 | AAPL | Stock | 1.8575 | 1.8596 | 1.8536 | 1.8546 | 4968124.0 |
| 2005-10-19 10:55:00 | AAPL | Stock | 1.855 | 1.8607 | 1.8546 | 1.8557 | 3221092.0 |
| 2005-10-19 11:00:00 | AAPL | Stock | 1.8554 | 1.8586 | 1.8521 | 1.8568 | 4597096.0 |
| 2005-10-19 11:05:00 | AAPL | Stock | 1.8561 | 1.8564 | 1.8464 | 1.8479 | 5875268.0 |
| 2005-10-19 11:10:00 | AAPL | Stock | 1.8475 | 1.8507 | 1.8464 | 1.8489 | 2704856.0 |
| 2005-10-19 11:15:00 | AAPL | Stock | 1.8482 | 1.8511 | 1.8446 | 1.8457 | 5724852.0 |
| 2005-10-19 11:20:00 | AAPL | Stock | 1.8454 | 1.8464 | 1.8386 | 1.8393 | 6799128.0 |
| 2005-10-19 11:25:00 | AAPL | Stock | 1.8389 | 1.8414 | 1.8339 | 1.8346 | 8975960.0 |
| 2005-10-19 11:30:00 | AAPL | Stock | 1.8346 | 1.8436 | 1.8346 | 1.8411 | 8159536.0 |
| 2005-10-19 11:35:00 | AAPL | Stock | 1.8411 | 1.8425 | 1.8364 | 1.8375 | 3430980.0 |
| 2005-10-19 11:40:00 | AAPL | Stock | 1.8375 | 1.84 | 1.8361 | 1.8375 | 3237836.0 |
| 2005-10-19 11:45:00 | AAPL | Stock | 1.8375 | 1.8411 | 1.8375 | 1.8396 | 2601396.0 |
| 2005-10-19 11:50:00 | AAPL | Stock | 1.8396 | 1.8407 | 1.8289 | 1.8304 | 9931152.0 |
| 2005-10-19 11:55:00 | AAPL | Stock | 1.8304 | 1.8357 | 1.83 | 1.8314 | 8757196.0 |
> showing 50 of 208,111 rows — these rows as CSV