PREVIEW / stock_5min / 2009-12-24
file: by_date/stock_5min/2009/2009-12-24.parquet size: 2.5 MB rows: 163,535 symbols: 3,372
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-12-24 07:00:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 2800.0 |
| 2009-12-24 07:05:00 | AAPL | Stock | 7.2361 | 7.2361 | 7.2361 | 7.2361 | 5320.0 |
| 2009-12-24 07:20:00 | AAPL | Stock | 7.25 | 7.25 | 7.25 | 7.25 | 19600.0 |
| 2009-12-24 07:25:00 | AAPL | Stock | 7.2436 | 7.25 | 7.2436 | 7.25 | 21420.0 |
| 2009-12-24 07:35:00 | AAPL | Stock | 7.2536 | 7.2536 | 7.2536 | 7.2536 | 27580.0 |
| 2009-12-24 07:40:00 | AAPL | Stock | 7.2568 | 7.2589 | 7.25 | 7.25 | 168000.0 |
| 2009-12-24 07:45:00 | AAPL | Stock | 7.25 | 7.25 | 7.2496 | 7.25 | 53200.0 |
| 2009-12-24 07:50:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 140000.0 |
| 2009-12-24 07:55:00 | AAPL | Stock | 7.2496 | 7.25 | 7.2496 | 7.25 | 84000.0 |
| 2009-12-24 08:00:00 | AAPL | Stock | 7.25 | 7.25 | 7.2429 | 7.2496 | 371980.0 |
| 2009-12-24 08:05:00 | AAPL | Stock | 7.25 | 7.25 | 7.245 | 7.25 | 255836.0 |
| 2009-12-24 08:10:00 | AAPL | Stock | 7.2518 | 7.2589 | 7.2504 | 7.2571 | 202300.0 |
| 2009-12-24 08:15:00 | AAPL | Stock | 7.2586 | 7.2607 | 7.2539 | 7.2607 | 114100.0 |
| 2009-12-24 08:20:00 | AAPL | Stock | 7.2607 | 7.2661 | 7.2607 | 7.2643 | 220780.0 |
| 2009-12-24 08:25:00 | AAPL | Stock | 7.262 | 7.262 | 7.2561 | 7.2571 | 315644.0 |
| 2009-12-24 08:30:00 | AAPL | Stock | 7.2568 | 7.2661 | 7.2568 | 7.2607 | 320852.0 |
| 2009-12-24 08:35:00 | AAPL | Stock | 7.2625 | 7.2714 | 7.2607 | 7.2714 | 443660.0 |
| 2009-12-24 08:40:00 | AAPL | Stock | 7.2686 | 7.2736 | 7.2682 | 7.2736 | 105840.0 |
| 2009-12-24 08:45:00 | AAPL | Stock | 7.2746 | 7.2786 | 7.2725 | 7.2725 | 334040.0 |
| 2009-12-24 08:50:00 | AAPL | Stock | 7.2729 | 7.275 | 7.2682 | 7.2682 | 171640.0 |
| 2009-12-24 08:55:00 | AAPL | Stock | 7.2682 | 7.2693 | 7.2654 | 7.2679 | 125160.0 |
| 2009-12-24 09:00:00 | AAPL | Stock | 7.265 | 7.2736 | 7.2646 | 7.2661 | 165760.0 |
| 2009-12-24 09:05:00 | AAPL | Stock | 7.2661 | 7.2757 | 7.2661 | 7.2732 | 177240.0 |
| 2009-12-24 09:10:00 | AAPL | Stock | 7.2718 | 7.2821 | 7.2718 | 7.2821 | 497784.0 |
| 2009-12-24 09:15:00 | AAPL | Stock | 7.2821 | 7.2836 | 7.275 | 7.275 | 337904.0 |
| 2009-12-24 09:20:00 | AAPL | Stock | 7.275 | 7.2771 | 7.2696 | 7.2748 | 325304.0 |
| 2009-12-24 09:25:00 | AAPL | Stock | 7.2754 | 7.2825 | 7.2714 | 7.275 | 901376.0 |
| 2009-12-24 09:30:00 | AAPL | Stock | 7.2696 | 7.3179 | 7.2611 | 7.3179 | 23643760.0 |
| 2009-12-24 09:35:00 | AAPL | Stock | 7.3171 | 7.3357 | 7.3161 | 7.3314 | 24110352.0 |
| 2009-12-24 09:40:00 | AAPL | Stock | 7.3314 | 7.3621 | 7.3307 | 7.3611 | 21008792.0 |
| 2009-12-24 09:45:00 | AAPL | Stock | 7.3612 | 7.3911 | 7.3414 | 7.3654 | 26898900.0 |
| 2009-12-24 09:50:00 | AAPL | Stock | 7.3654 | 7.3736 | 7.3561 | 7.3711 | 10816596.0 |
| 2009-12-24 09:55:00 | AAPL | Stock | 7.3705 | 7.3836 | 7.3689 | 7.3832 | 11562180.0 |
| 2009-12-24 10:00:00 | AAPL | Stock | 7.3836 | 7.4196 | 7.3818 | 7.4107 | 29254120.0 |
| 2009-12-24 10:05:00 | AAPL | Stock | 7.4125 | 7.4286 | 7.3986 | 7.402 | 24600016.0 |
| 2009-12-24 10:10:00 | AAPL | Stock | 7.4014 | 7.4064 | 7.3896 | 7.4029 | 12996676.0 |
| 2009-12-24 10:15:00 | AAPL | Stock | 7.4036 | 7.405 | 7.3946 | 7.3993 | 7361956.0 |
| 2009-12-24 10:20:00 | AAPL | Stock | 7.3993 | 7.4129 | 7.3971 | 7.4111 | 9057888.0 |
| 2009-12-24 10:25:00 | AAPL | Stock | 7.4116 | 7.4182 | 7.4007 | 7.4052 | 9127272.0 |
| 2009-12-24 10:30:00 | AAPL | Stock | 7.405 | 7.4062 | 7.3964 | 7.3965 | 5928580.0 |
| 2009-12-24 10:35:00 | AAPL | Stock | 7.3964 | 7.4171 | 7.3954 | 7.4164 | 7775404.0 |
| 2009-12-24 10:40:00 | AAPL | Stock | 7.4161 | 7.4204 | 7.3989 | 7.401 | 7811384.0 |
| 2009-12-24 10:45:00 | AAPL | Stock | 7.4004 | 7.4125 | 7.4004 | 7.4064 | 5492172.0 |
| 2009-12-24 10:50:00 | AAPL | Stock | 7.4064 | 7.4096 | 7.4011 | 7.4089 | 3972808.0 |
| 2009-12-24 10:55:00 | AAPL | Stock | 7.4089 | 7.4157 | 7.405 | 7.4073 | 5335344.0 |
| 2009-12-24 11:00:00 | AAPL | Stock | 7.4072 | 7.4132 | 7.4064 | 7.4066 | 5744116.0 |
| 2009-12-24 11:05:00 | AAPL | Stock | 7.4065 | 7.4232 | 7.4057 | 7.4213 | 9402540.0 |
| 2009-12-24 11:10:00 | AAPL | Stock | 7.4218 | 7.4386 | 7.4211 | 7.4356 | 17026436.0 |
| 2009-12-24 11:15:00 | AAPL | Stock | 7.4346 | 7.4421 | 7.4286 | 7.4393 | 10220756.0 |
| 2009-12-24 11:20:00 | AAPL | Stock | 7.44 | 7.4414 | 7.4332 | 7.4407 | 6356448.0 |
> showing 50 of 163,535 rows — these rows as CSV