PREVIEW / stock_5min / 2009-02-02
file: by_date/stock_5min/2009/2009-02-02.parquet size: 4.4 MB rows: 307,632 symbols: 3,294
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-02-02 07:25:00 | AAPL | Stock | 3.1932 | 3.1932 | 3.1786 | 3.1786 | 11200.0 |
| 2009-02-02 07:40:00 | AAPL | Stock | 3.1607 | 3.1607 | 3.1607 | 3.1607 | 2800.0 |
| 2009-02-02 08:00:00 | AAPL | Stock | 3.1768 | 3.1961 | 3.1768 | 3.1882 | 119084.0 |
| 2009-02-02 08:05:00 | AAPL | Stock | 3.1882 | 3.1886 | 3.1821 | 3.1821 | 26600.0 |
| 2009-02-02 08:10:00 | AAPL | Stock | 3.1789 | 3.1821 | 3.1704 | 3.1821 | 31640.0 |
| 2009-02-02 08:15:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.175 | 3.175 | 11200.0 |
| 2009-02-02 08:20:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1714 | 3.1714 | 84700.0 |
| 2009-02-02 08:25:00 | AAPL | Stock | 3.1714 | 3.1714 | 3.1704 | 3.1714 | 65996.0 |
| 2009-02-02 08:30:00 | AAPL | Stock | 3.1714 | 3.1732 | 3.1714 | 3.1732 | 12264.0 |
| 2009-02-02 08:35:00 | AAPL | Stock | 3.1732 | 3.1736 | 3.1704 | 3.1718 | 105924.0 |
| 2009-02-02 08:40:00 | AAPL | Stock | 3.1754 | 3.1757 | 3.1743 | 3.1743 | 46564.0 |
| 2009-02-02 08:45:00 | AAPL | Stock | 3.175 | 3.1771 | 3.1736 | 3.1743 | 46592.0 |
| 2009-02-02 08:50:00 | AAPL | Stock | 3.1736 | 3.1804 | 3.1736 | 3.1804 | 51800.0 |
| 2009-02-02 08:55:00 | AAPL | Stock | 3.1786 | 3.1786 | 3.1743 | 3.1771 | 64400.0 |
| 2009-02-02 09:00:00 | AAPL | Stock | 3.1796 | 3.1804 | 3.1796 | 3.1796 | 44800.0 |
| 2009-02-02 09:05:00 | AAPL | Stock | 3.1796 | 3.1811 | 3.1796 | 3.1811 | 51520.0 |
| 2009-02-02 09:10:00 | AAPL | Stock | 3.1804 | 3.185 | 3.1786 | 3.1836 | 124600.0 |
| 2009-02-02 09:15:00 | AAPL | Stock | 3.1839 | 3.1857 | 3.1839 | 3.1857 | 42000.0 |
| 2009-02-02 09:20:00 | AAPL | Stock | 3.1882 | 3.2189 | 3.1875 | 3.1882 | 421764.0 |
| 2009-02-02 09:25:00 | AAPL | Stock | 3.1893 | 3.1929 | 3.1825 | 3.1825 | 336728.0 |
| 2009-02-02 09:30:00 | AAPL | Stock | 3.1821 | 3.2075 | 3.175 | 3.2039 | 17261552.0 |
| 2009-02-02 09:35:00 | AAPL | Stock | 3.2039 | 3.2364 | 3.2025 | 3.2282 | 15851668.0 |
| 2009-02-02 09:40:00 | AAPL | Stock | 3.2279 | 3.2443 | 3.2129 | 3.24 | 14718116.0 |
| 2009-02-02 09:45:00 | AAPL | Stock | 3.24 | 3.2425 | 3.225 | 3.2386 | 8987832.0 |
| 2009-02-02 09:50:00 | AAPL | Stock | 3.2382 | 3.2436 | 3.2211 | 3.2218 | 11165812.0 |
| 2009-02-02 09:55:00 | AAPL | Stock | 3.2218 | 3.2346 | 3.215 | 3.2339 | 7484876.0 |
| 2009-02-02 10:00:00 | AAPL | Stock | 3.2325 | 3.255 | 3.2325 | 3.24 | 14585424.0 |
| 2009-02-02 10:05:00 | AAPL | Stock | 3.24 | 3.2507 | 3.2289 | 3.2475 | 10986612.0 |
| 2009-02-02 10:10:00 | AAPL | Stock | 3.2475 | 3.2589 | 3.2429 | 3.2579 | 10391948.0 |
| 2009-02-02 10:15:00 | AAPL | Stock | 3.2589 | 3.2729 | 3.2571 | 3.2638 | 11548852.0 |
| 2009-02-02 10:20:00 | AAPL | Stock | 3.2633 | 3.2671 | 3.2589 | 3.2625 | 6256432.0 |
| 2009-02-02 10:25:00 | AAPL | Stock | 3.2625 | 3.2646 | 3.255 | 3.2624 | 7573636.0 |
| 2009-02-02 10:30:00 | AAPL | Stock | 3.2618 | 3.2639 | 3.2511 | 3.2514 | 6174644.0 |
| 2009-02-02 10:35:00 | AAPL | Stock | 3.2518 | 3.2586 | 3.2471 | 3.2493 | 6410152.0 |
| 2009-02-02 10:40:00 | AAPL | Stock | 3.249 | 3.2525 | 3.2393 | 3.2393 | 6880020.0 |
| 2009-02-02 10:45:00 | AAPL | Stock | 3.2393 | 3.245 | 3.2375 | 3.2439 | 5920124.0 |
| 2009-02-02 10:50:00 | AAPL | Stock | 3.2436 | 3.25 | 3.2404 | 3.2429 | 5011552.0 |
| 2009-02-02 10:55:00 | AAPL | Stock | 3.2421 | 3.2464 | 3.2325 | 3.2332 | 5091604.0 |
| 2009-02-02 11:00:00 | AAPL | Stock | 3.2336 | 3.2357 | 3.2239 | 3.2271 | 5669384.0 |
| 2009-02-02 11:05:00 | AAPL | Stock | 3.2264 | 3.2407 | 3.2264 | 3.2368 | 6818896.0 |
| 2009-02-02 11:10:00 | AAPL | Stock | 3.2375 | 3.245 | 3.2357 | 3.2379 | 6136424.0 |
| 2009-02-02 11:15:00 | AAPL | Stock | 3.2382 | 3.2454 | 3.2375 | 3.2414 | 3598392.0 |
| 2009-02-02 11:20:00 | AAPL | Stock | 3.242 | 3.2439 | 3.2332 | 3.2396 | 7223104.0 |
| 2009-02-02 11:25:00 | AAPL | Stock | 3.24 | 3.2407 | 3.2336 | 3.2375 | 2946412.0 |
| 2009-02-02 11:30:00 | AAPL | Stock | 3.2377 | 3.2489 | 3.2375 | 3.2482 | 5029360.0 |
| 2009-02-02 11:35:00 | AAPL | Stock | 3.2475 | 3.2493 | 3.2386 | 3.2386 | 3379460.0 |
| 2009-02-02 11:40:00 | AAPL | Stock | 3.2389 | 3.2396 | 3.2304 | 3.2364 | 4028668.0 |
| 2009-02-02 11:45:00 | AAPL | Stock | 3.2361 | 3.2479 | 3.235 | 3.2457 | 3112200.0 |
| 2009-02-02 11:50:00 | AAPL | Stock | 3.2461 | 3.2539 | 3.2454 | 3.2486 | 5247508.0 |
| 2009-02-02 11:55:00 | AAPL | Stock | 3.2486 | 3.2496 | 3.2411 | 3.2443 | 3839892.0 |
> showing 50 of 307,632 rows — these rows as CSV