PREVIEW / stock_5min / 2007-04-17
file: by_date/stock_5min/2007/2007-04-17.parquet size: 3.6 MB rows: 256,822 symbols: 2,582
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-17 07:00:00 | AAPL | Stock | 3.2518 | 3.2518 | 3.2518 | 3.2518 | 25200.0 |
| 2007-04-17 07:05:00 | AAPL | Stock | 3.2439 | 3.2439 | 3.2321 | 3.2321 | 75600.0 |
| 2007-04-17 07:10:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 14000.0 |
| 2007-04-17 07:15:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 75600.0 |
| 2007-04-17 07:20:00 | AAPL | Stock | 3.2411 | 3.2411 | 3.2411 | 3.2411 | 14000.0 |
| 2007-04-17 07:30:00 | AAPL | Stock | 3.2407 | 3.2411 | 3.2407 | 3.2411 | 78400.0 |
| 2007-04-17 07:35:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2321 | 3.2321 | 2800.0 |
| 2007-04-17 07:40:00 | AAPL | Stock | 3.225 | 3.225 | 3.2246 | 3.2246 | 53200.0 |
| 2007-04-17 07:45:00 | AAPL | Stock | 3.2232 | 3.2321 | 3.2232 | 3.2321 | 56000.0 |
| 2007-04-17 07:50:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2304 | 3.2321 | 154000.0 |
| 2007-04-17 07:55:00 | AAPL | Stock | 3.2321 | 3.2357 | 3.2321 | 3.2357 | 135800.0 |
| 2007-04-17 08:00:00 | AAPL | Stock | 3.2425 | 3.2425 | 3.2357 | 3.2386 | 192948.0 |
| 2007-04-17 08:05:00 | AAPL | Stock | 3.2375 | 3.2393 | 3.2357 | 3.2393 | 185864.0 |
| 2007-04-17 08:10:00 | AAPL | Stock | 3.2393 | 3.245 | 3.2393 | 3.245 | 211456.0 |
| 2007-04-17 08:15:00 | AAPL | Stock | 3.2468 | 3.25 | 3.2446 | 3.25 | 142156.0 |
| 2007-04-17 08:20:00 | AAPL | Stock | 3.2464 | 3.25 | 3.2464 | 3.2489 | 61600.0 |
| 2007-04-17 08:25:00 | AAPL | Stock | 3.2464 | 3.2464 | 3.2432 | 3.2446 | 75600.0 |
| 2007-04-17 08:30:00 | AAPL | Stock | 3.2446 | 3.2568 | 3.2432 | 3.2554 | 366660.0 |
| 2007-04-17 08:35:00 | AAPL | Stock | 3.2568 | 3.26 | 3.2554 | 3.2557 | 374360.0 |
| 2007-04-17 08:40:00 | AAPL | Stock | 3.2536 | 3.2561 | 3.2536 | 3.2536 | 128800.0 |
| 2007-04-17 08:45:00 | AAPL | Stock | 3.2536 | 3.2536 | 3.25 | 3.25 | 151200.0 |
| 2007-04-17 08:50:00 | AAPL | Stock | 3.2525 | 3.2746 | 3.2525 | 3.2707 | 808276.0 |
| 2007-04-17 08:55:00 | AAPL | Stock | 3.2707 | 3.305 | 3.2707 | 3.2982 | 3824464.0 |
| 2007-04-17 09:00:00 | AAPL | Stock | 3.2971 | 3.2982 | 3.2918 | 3.2929 | 652512.0 |
| 2007-04-17 09:05:00 | AAPL | Stock | 3.2936 | 3.2971 | 3.2868 | 3.2929 | 823004.0 |
| 2007-04-17 09:10:00 | AAPL | Stock | 3.2911 | 3.2929 | 3.2829 | 3.2882 | 1004640.0 |
| 2007-04-17 09:15:00 | AAPL | Stock | 3.2889 | 3.2893 | 3.2857 | 3.2857 | 275128.0 |
| 2007-04-17 09:20:00 | AAPL | Stock | 3.2854 | 3.2889 | 3.2854 | 3.2857 | 667408.0 |
| 2007-04-17 09:25:00 | AAPL | Stock | 3.2857 | 3.2893 | 3.2854 | 3.2857 | 963760.0 |
| 2007-04-17 09:30:00 | AAPL | Stock | 3.2857 | 3.2964 | 3.2589 | 3.2607 | 22966832.0 |
| 2007-04-17 09:35:00 | AAPL | Stock | 3.2611 | 3.2679 | 3.2554 | 3.2604 | 16812180.0 |
| 2007-04-17 09:40:00 | AAPL | Stock | 3.2604 | 3.2654 | 3.2536 | 3.2586 | 15620976.0 |
| 2007-04-17 09:45:00 | AAPL | Stock | 3.2589 | 3.2821 | 3.2454 | 3.2457 | 23075388.0 |
| 2007-04-17 09:50:00 | AAPL | Stock | 3.2464 | 3.2486 | 3.2379 | 3.2475 | 20549256.0 |
| 2007-04-17 09:55:00 | AAPL | Stock | 3.2475 | 3.2539 | 3.2471 | 3.2511 | 14058128.0 |
| 2007-04-17 10:00:00 | AAPL | Stock | 3.2511 | 3.2525 | 3.2396 | 3.2404 | 15832936.0 |
| 2007-04-17 10:05:00 | AAPL | Stock | 3.2407 | 3.2482 | 3.2357 | 3.2407 | 17159660.0 |
| 2007-04-17 10:10:00 | AAPL | Stock | 3.2407 | 3.2468 | 3.2405 | 3.2418 | 9290596.0 |
| 2007-04-17 10:15:00 | AAPL | Stock | 3.2421 | 3.25 | 3.2407 | 3.2471 | 9351160.0 |
| 2007-04-17 10:20:00 | AAPL | Stock | 3.2471 | 3.2513 | 3.2361 | 3.2464 | 9574992.0 |
| 2007-04-17 10:25:00 | AAPL | Stock | 3.2468 | 3.2471 | 3.2425 | 3.2443 | 6495916.0 |
| 2007-04-17 10:30:00 | AAPL | Stock | 3.2439 | 3.2439 | 3.2375 | 3.2375 | 7346360.0 |
| 2007-04-17 10:35:00 | AAPL | Stock | 3.2375 | 3.2457 | 3.2375 | 3.2432 | 6891304.0 |
| 2007-04-17 10:40:00 | AAPL | Stock | 3.2432 | 3.2486 | 3.2429 | 3.2482 | 6097028.0 |
| 2007-04-17 10:45:00 | AAPL | Stock | 3.2482 | 3.2543 | 3.2475 | 3.2521 | 9903152.0 |
| 2007-04-17 10:50:00 | AAPL | Stock | 3.2518 | 3.2536 | 3.245 | 3.2457 | 6662908.0 |
| 2007-04-17 10:55:00 | AAPL | Stock | 3.2457 | 3.2494 | 3.245 | 3.2471 | 6726692.0 |
| 2007-04-17 11:00:00 | AAPL | Stock | 3.2475 | 3.25 | 3.2475 | 3.2482 | 3375652.0 |
| 2007-04-17 11:05:00 | AAPL | Stock | 3.2482 | 3.25 | 3.2451 | 3.2472 | 4010356.0 |
| 2007-04-17 11:10:00 | AAPL | Stock | 3.2475 | 3.2478 | 3.2432 | 3.2446 | 4926124.0 |
> showing 50 of 256,822 rows — these rows as CSV