PREVIEW / stock_5min / 2009-02-25
file: by_date/stock_5min/2009/2009-02-25.parquet size: 4.5 MB rows: 311,316 symbols: 3,309
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-25 06:50:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.2018 | 3.2018 | 5600.0 |
| 2009-02-25 07:20:00 | AAPL | Stock | 3.2018 | 3.2018 | 3.1964 | 3.1964 | 5964.0 |
| 2009-02-25 07:35:00 | AAPL | Stock | 3.1807 | 3.1807 | 3.1807 | 3.1807 | 2800.0 |
| 2009-02-25 07:40:00 | AAPL | Stock | 3.2136 | 3.2143 | 3.2136 | 3.2143 | 22400.0 |
| 2009-02-25 07:45:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2009-02-25 08:10:00 | AAPL | Stock | 3.2143 | 3.2143 | 3.2143 | 3.2143 | 2800.0 |
| 2009-02-25 08:15:00 | AAPL | Stock | 3.2143 | 3.2232 | 3.2143 | 3.2232 | 53200.0 |
| 2009-02-25 08:20:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2232 | 3.2232 | 4200.0 |
| 2009-02-25 08:30:00 | AAPL | Stock | 3.2179 | 3.2229 | 3.2179 | 3.2196 | 18060.0 |
| 2009-02-25 08:35:00 | AAPL | Stock | 3.2182 | 3.2182 | 3.215 | 3.2179 | 26992.0 |
| 2009-02-25 08:40:00 | AAPL | Stock | 3.2182 | 3.2232 | 3.2182 | 3.2232 | 33600.0 |
| 2009-02-25 08:45:00 | AAPL | Stock | 3.2196 | 3.2196 | 3.2189 | 3.2189 | 15344.0 |
| 2009-02-25 08:50:00 | AAPL | Stock | 3.2229 | 3.2229 | 3.2182 | 3.2186 | 35840.0 |
| 2009-02-25 08:55:00 | AAPL | Stock | 3.2189 | 3.22 | 3.2164 | 3.2164 | 47600.0 |
| 2009-02-25 09:00:00 | AAPL | Stock | 3.2196 | 3.2214 | 3.2143 | 3.2143 | 109004.0 |
| 2009-02-25 09:05:00 | AAPL | Stock | 3.2064 | 3.2064 | 3.2054 | 3.2054 | 44800.0 |
| 2009-02-25 09:10:00 | AAPL | Stock | 3.2086 | 3.2125 | 3.2079 | 3.2104 | 58800.0 |
| 2009-02-25 09:15:00 | AAPL | Stock | 3.2107 | 3.225 | 3.2104 | 3.2179 | 125440.0 |
| 2009-02-25 09:20:00 | AAPL | Stock | 3.2175 | 3.2286 | 3.2175 | 3.2282 | 56028.0 |
| 2009-02-25 09:25:00 | AAPL | Stock | 3.2254 | 3.2286 | 3.2029 | 3.2089 | 640472.0 |
| 2009-02-25 09:30:00 | AAPL | Stock | 3.2136 | 3.25 | 3.205 | 3.2357 | 22370208.0 |
| 2009-02-25 09:35:00 | AAPL | Stock | 3.2346 | 3.2379 | 3.2189 | 3.2343 | 14212996.0 |
| 2009-02-25 09:40:00 | AAPL | Stock | 3.2339 | 3.2561 | 3.2339 | 3.2439 | 13530804.0 |
| 2009-02-25 09:45:00 | AAPL | Stock | 3.2436 | 3.2504 | 3.2307 | 3.2489 | 13245512.0 |
| 2009-02-25 09:50:00 | AAPL | Stock | 3.2493 | 3.2621 | 3.2429 | 3.2616 | 15378720.0 |
| 2009-02-25 09:55:00 | AAPL | Stock | 3.2614 | 3.2679 | 3.2393 | 3.2393 | 11853380.0 |
| 2009-02-25 10:00:00 | AAPL | Stock | 3.2396 | 3.2404 | 3.2179 | 3.2289 | 14751240.0 |
| 2009-02-25 10:05:00 | AAPL | Stock | 3.2296 | 3.23 | 3.2036 | 3.2132 | 12381852.0 |
| 2009-02-25 10:10:00 | AAPL | Stock | 3.2129 | 3.2161 | 3.1971 | 3.2032 | 13737192.0 |
| 2009-02-25 10:15:00 | AAPL | Stock | 3.2032 | 3.2118 | 3.1875 | 3.2107 | 14822220.0 |
| 2009-02-25 10:20:00 | AAPL | Stock | 3.2113 | 3.2132 | 3.1929 | 3.2086 | 9192540.0 |
| 2009-02-25 10:25:00 | AAPL | Stock | 3.2082 | 3.2164 | 3.2032 | 3.2146 | 6890408.0 |
| 2009-02-25 10:30:00 | AAPL | Stock | 3.215 | 3.2418 | 3.2029 | 3.2321 | 21988456.0 |
| 2009-02-25 10:35:00 | AAPL | Stock | 3.2321 | 3.25 | 3.2304 | 3.2404 | 15773184.0 |
| 2009-02-25 10:40:00 | AAPL | Stock | 3.2404 | 3.2486 | 3.1996 | 3.2014 | 15749300.0 |
| 2009-02-25 10:45:00 | AAPL | Stock | 3.2011 | 3.2143 | 3.1993 | 3.2114 | 9036804.0 |
| 2009-02-25 10:50:00 | AAPL | Stock | 3.2118 | 3.2314 | 3.2111 | 3.2307 | 8292872.0 |
| 2009-02-25 10:55:00 | AAPL | Stock | 3.2311 | 3.2332 | 3.2229 | 3.2286 | 6164396.0 |
| 2009-02-25 11:00:00 | AAPL | Stock | 3.2282 | 3.2314 | 3.2218 | 3.2271 | 4836132.0 |
| 2009-02-25 11:05:00 | AAPL | Stock | 3.2268 | 3.2339 | 3.2229 | 3.2296 | 8398572.0 |
| 2009-02-25 11:10:00 | AAPL | Stock | 3.2296 | 3.2393 | 3.2271 | 3.2393 | 6474048.0 |
| 2009-02-25 11:15:00 | AAPL | Stock | 3.2393 | 3.2536 | 3.2357 | 3.2464 | 9723504.0 |
| 2009-02-25 11:20:00 | AAPL | Stock | 3.2464 | 3.26 | 3.2464 | 3.2568 | 7819448.0 |
| 2009-02-25 11:25:00 | AAPL | Stock | 3.2568 | 3.2657 | 3.2539 | 3.259 | 8510320.0 |
| 2009-02-25 11:30:00 | AAPL | Stock | 3.2586 | 3.2593 | 3.2507 | 3.2557 | 4828768.0 |
| 2009-02-25 11:35:00 | AAPL | Stock | 3.2561 | 3.2582 | 3.245 | 3.2479 | 6446692.0 |
| 2009-02-25 11:40:00 | AAPL | Stock | 3.2479 | 3.2736 | 3.2475 | 3.2733 | 10072580.0 |
| 2009-02-25 11:45:00 | AAPL | Stock | 3.2729 | 3.2893 | 3.2729 | 3.2771 | 18429068.0 |
| 2009-02-25 11:50:00 | AAPL | Stock | 3.2771 | 3.2807 | 3.2604 | 3.2636 | 14989464.0 |
| 2009-02-25 11:55:00 | AAPL | Stock | 3.2639 | 3.2668 | 3.2571 | 3.26 | 7156212.0 |
> showing 50 of 311,316 rows — these rows as CSV