PREVIEW / stock_5min / 2009-03-05
file: by_date/stock_5min/2009/2009-03-05.parquet size: 4.5 MB rows: 310,014 symbols: 3,351
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-03-05 04:30:00 | AAPL | Stock | 3.2414 | 3.2414 | 3.2414 | 3.2414 | 16800.0 |
| 2009-03-05 06:00:00 | AAPL | Stock | 3.2336 | 3.2336 | 3.2336 | 3.2336 | 11200.0 |
| 2009-03-05 06:05:00 | AAPL | Stock | 3.2314 | 3.2314 | 3.2314 | 3.2314 | 5600.0 |
| 2009-03-05 06:20:00 | AAPL | Stock | 3.2157 | 3.2157 | 3.2157 | 3.2157 | 5600.0 |
| 2009-03-05 06:45:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 5600.0 |
| 2009-03-05 07:05:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 2800.0 |
| 2009-03-05 07:20:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 2800.0 |
| 2009-03-05 07:30:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 8400.0 |
| 2009-03-05 07:45:00 | AAPL | Stock | 3.2107 | 3.2143 | 3.2107 | 3.2143 | 14000.0 |
| 2009-03-05 07:50:00 | AAPL | Stock | 3.2139 | 3.2139 | 3.2139 | 3.2139 | 5600.0 |
| 2009-03-05 07:55:00 | AAPL | Stock | 3.2107 | 3.2107 | 3.2107 | 3.2107 | 8400.0 |
| 2009-03-05 08:00:00 | AAPL | Stock | 3.2125 | 3.2268 | 3.2125 | 3.2268 | 193228.0 |
| 2009-03-05 08:05:00 | AAPL | Stock | 3.2232 | 3.2336 | 3.2214 | 3.2336 | 129388.0 |
| 2009-03-05 08:10:00 | AAPL | Stock | 3.2286 | 3.2293 | 3.2286 | 3.2293 | 66556.0 |
| 2009-03-05 08:15:00 | AAPL | Stock | 3.2286 | 3.2286 | 3.2232 | 3.2232 | 25816.0 |
| 2009-03-05 08:20:00 | AAPL | Stock | 3.225 | 3.2321 | 3.225 | 3.2254 | 46480.0 |
| 2009-03-05 08:25:00 | AAPL | Stock | 3.2271 | 3.2271 | 3.22 | 3.2221 | 25200.0 |
| 2009-03-05 08:35:00 | AAPL | Stock | 3.2314 | 3.2357 | 3.2246 | 3.2246 | 461720.0 |
| 2009-03-05 08:40:00 | AAPL | Stock | 3.2218 | 3.2246 | 3.2189 | 3.2211 | 181300.0 |
| 2009-03-05 08:45:00 | AAPL | Stock | 3.2218 | 3.2339 | 3.2218 | 3.2339 | 88760.0 |
| 2009-03-05 08:50:00 | AAPL | Stock | 3.2343 | 3.2343 | 3.2304 | 3.2304 | 169316.0 |
| 2009-03-05 08:55:00 | AAPL | Stock | 3.2311 | 3.2311 | 3.22 | 3.225 | 61936.0 |
| 2009-03-05 09:00:00 | AAPL | Stock | 3.225 | 3.2357 | 3.225 | 3.2357 | 120400.0 |
| 2009-03-05 09:05:00 | AAPL | Stock | 3.2321 | 3.2321 | 3.2286 | 3.2286 | 117600.0 |
| 2009-03-05 09:10:00 | AAPL | Stock | 3.2289 | 3.2321 | 3.2289 | 3.2289 | 61600.0 |
| 2009-03-05 09:15:00 | AAPL | Stock | 3.2304 | 3.2321 | 3.2304 | 3.2321 | 98000.0 |
| 2009-03-05 09:20:00 | AAPL | Stock | 3.2321 | 3.2357 | 3.2321 | 3.2357 | 64344.0 |
| 2009-03-05 09:25:00 | AAPL | Stock | 3.2357 | 3.2375 | 3.2232 | 3.2354 | 379764.0 |
| 2009-03-05 09:30:00 | AAPL | Stock | 3.2318 | 3.2604 | 3.2204 | 3.2443 | 17807524.0 |
| 2009-03-05 09:35:00 | AAPL | Stock | 3.2439 | 3.275 | 3.2414 | 3.2675 | 15953700.0 |
| 2009-03-05 09:40:00 | AAPL | Stock | 3.2675 | 3.2786 | 3.2575 | 3.2581 | 12197388.0 |
| 2009-03-05 09:45:00 | AAPL | Stock | 3.2589 | 3.2811 | 3.2514 | 3.2518 | 12236840.0 |
| 2009-03-05 09:50:00 | AAPL | Stock | 3.2525 | 3.2679 | 3.2511 | 3.2643 | 8694336.0 |
| 2009-03-05 09:55:00 | AAPL | Stock | 3.2646 | 3.2789 | 3.2554 | 3.2568 | 9125256.0 |
| 2009-03-05 10:00:00 | AAPL | Stock | 3.2564 | 3.2739 | 3.2554 | 3.2739 | 9543632.0 |
| 2009-03-05 10:05:00 | AAPL | Stock | 3.2739 | 3.2786 | 3.2511 | 3.2529 | 12200244.0 |
| 2009-03-05 10:10:00 | AAPL | Stock | 3.2525 | 3.2532 | 3.2225 | 3.2236 | 15964284.0 |
| 2009-03-05 10:15:00 | AAPL | Stock | 3.2232 | 3.2336 | 3.2182 | 3.23 | 9017456.0 |
| 2009-03-05 10:20:00 | AAPL | Stock | 3.2296 | 3.2311 | 3.2054 | 3.2096 | 13373528.0 |
| 2009-03-05 10:25:00 | AAPL | Stock | 3.21 | 3.2118 | 3.2004 | 3.205 | 12129628.0 |
| 2009-03-05 10:30:00 | AAPL | Stock | 3.205 | 3.2161 | 3.2021 | 3.2143 | 9917992.0 |
| 2009-03-05 10:35:00 | AAPL | Stock | 3.2139 | 3.2179 | 3.2032 | 3.2075 | 7878248.0 |
| 2009-03-05 10:40:00 | AAPL | Stock | 3.2075 | 3.2179 | 3.2064 | 3.21 | 6927676.0 |
| 2009-03-05 10:45:00 | AAPL | Stock | 3.21 | 3.2104 | 3.1932 | 3.2004 | 11008956.0 |
| 2009-03-05 10:50:00 | AAPL | Stock | 3.2 | 3.2036 | 3.1932 | 3.2004 | 6329092.0 |
| 2009-03-05 10:55:00 | AAPL | Stock | 3.2 | 3.2046 | 3.1875 | 3.1911 | 8696912.0 |
| 2009-03-05 11:00:00 | AAPL | Stock | 3.1911 | 3.205 | 3.1886 | 3.1986 | 4907980.0 |
| 2009-03-05 11:05:00 | AAPL | Stock | 3.1986 | 3.2125 | 3.1986 | 3.2107 | 8606304.0 |
| 2009-03-05 11:10:00 | AAPL | Stock | 3.211 | 3.2179 | 3.2093 | 3.2104 | 9263548.0 |
| 2009-03-05 11:15:00 | AAPL | Stock | 3.2111 | 3.2111 | 3.185 | 3.1893 | 10856692.0 |
> showing 50 of 310,014 rows — these rows as CSV