PREVIEW / stock_5min / 2007-09-24
file: by_date/stock_5min/2007/2007-09-24.parquet size: 4.2 MB rows: 304,784 symbols: 3,124
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-09-24 05:50:00 | AAPL | Stock | 5.1493 | 5.1493 | 5.1493 | 5.1493 | 16576.0 |
| 2007-09-24 05:55:00 | AAPL | Stock | 5.1582 | 5.1582 | 5.1582 | 5.1582 | 11200.0 |
| 2007-09-24 07:00:00 | AAPL | Stock | 5.1729 | 5.1839 | 5.1729 | 5.1786 | 106400.0 |
| 2007-09-24 07:05:00 | AAPL | Stock | 5.1696 | 5.1743 | 5.1696 | 5.1743 | 19600.0 |
| 2007-09-24 07:10:00 | AAPL | Stock | 5.17 | 5.17 | 5.17 | 5.17 | 11200.0 |
| 2007-09-24 07:15:00 | AAPL | Stock | 5.1743 | 5.1929 | 5.1736 | 5.1786 | 191324.0 |
| 2007-09-24 07:20:00 | AAPL | Stock | 5.1821 | 5.1857 | 5.1786 | 5.1821 | 416920.0 |
| 2007-09-24 07:25:00 | AAPL | Stock | 5.1821 | 5.1857 | 5.1786 | 5.1857 | 105700.0 |
| 2007-09-24 07:30:00 | AAPL | Stock | 5.1889 | 5.2143 | 5.1889 | 5.2125 | 633668.0 |
| 2007-09-24 07:35:00 | AAPL | Stock | 5.2143 | 5.2196 | 5.2075 | 5.2171 | 907200.0 |
| 2007-09-24 07:40:00 | AAPL | Stock | 5.2143 | 5.2161 | 5.2071 | 5.2146 | 269360.0 |
| 2007-09-24 07:45:00 | AAPL | Stock | 5.2146 | 5.2164 | 5.2146 | 5.2164 | 130312.0 |
| 2007-09-24 07:50:00 | AAPL | Stock | 5.215 | 5.2164 | 5.2079 | 5.2125 | 1080604.0 |
| 2007-09-24 07:55:00 | AAPL | Stock | 5.2125 | 5.2175 | 5.2107 | 5.2125 | 1648836.0 |
| 2007-09-24 08:00:00 | AAPL | Stock | 5.2136 | 5.2175 | 5.2071 | 5.2129 | 3139052.0 |
| 2007-09-24 08:05:00 | AAPL | Stock | 5.2125 | 5.2143 | 5.2071 | 5.2107 | 963088.0 |
| 2007-09-24 08:10:00 | AAPL | Stock | 5.2086 | 5.2196 | 5.2086 | 5.2196 | 1546804.0 |
| 2007-09-24 08:15:00 | AAPL | Stock | 5.22 | 5.2421 | 5.2182 | 5.2418 | 2272592.0 |
| 2007-09-24 08:20:00 | AAPL | Stock | 5.24 | 5.2575 | 5.24 | 5.2446 | 2186464.0 |
| 2007-09-24 08:25:00 | AAPL | Stock | 5.2432 | 5.25 | 5.2379 | 5.25 | 1503488.0 |
| 2007-09-24 08:30:00 | AAPL | Stock | 5.25 | 5.2529 | 5.2482 | 5.2525 | 1166144.0 |
| 2007-09-24 08:35:00 | AAPL | Stock | 5.2511 | 5.2554 | 5.2446 | 5.2446 | 1546244.0 |
| 2007-09-24 08:40:00 | AAPL | Stock | 5.2468 | 5.2482 | 5.2446 | 5.2446 | 414680.0 |
| 2007-09-24 08:45:00 | AAPL | Stock | 5.2446 | 5.2446 | 5.2321 | 5.2411 | 978880.0 |
| 2007-09-24 08:50:00 | AAPL | Stock | 5.2425 | 5.25 | 5.2357 | 5.25 | 632520.0 |
| 2007-09-24 08:55:00 | AAPL | Stock | 5.245 | 5.25 | 5.2411 | 5.2479 | 334264.0 |
| 2007-09-24 09:00:00 | AAPL | Stock | 5.2464 | 5.2475 | 5.2421 | 5.2425 | 468328.0 |
| 2007-09-24 09:05:00 | AAPL | Stock | 5.2436 | 5.25 | 5.2436 | 5.25 | 1400028.0 |
| 2007-09-24 09:10:00 | AAPL | Stock | 5.2482 | 5.2507 | 5.2482 | 5.2482 | 1435644.0 |
| 2007-09-24 09:15:00 | AAPL | Stock | 5.2482 | 5.2486 | 5.2446 | 5.2464 | 525560.0 |
| 2007-09-24 09:20:00 | AAPL | Stock | 5.2464 | 5.2475 | 5.2429 | 5.2446 | 600656.0 |
| 2007-09-24 09:25:00 | AAPL | Stock | 5.2436 | 5.2471 | 5.235 | 5.2396 | 2496956.0 |
| 2007-09-24 09:30:00 | AAPL | Stock | 5.2404 | 5.2882 | 5.2375 | 5.2766 | 61886300.0 |
| 2007-09-24 09:35:00 | AAPL | Stock | 5.2782 | 5.3 | 5.2729 | 5.2829 | 45600100.0 |
| 2007-09-24 09:40:00 | AAPL | Stock | 5.2836 | 5.3182 | 5.2736 | 5.3104 | 38717728.0 |
| 2007-09-24 09:45:00 | AAPL | Stock | 5.31 | 5.3304 | 5.3036 | 5.3096 | 43500940.0 |
| 2007-09-24 09:50:00 | AAPL | Stock | 5.3096 | 5.3129 | 5.2825 | 5.2904 | 39498788.0 |
| 2007-09-24 09:55:00 | AAPL | Stock | 5.29 | 5.3018 | 5.2886 | 5.2961 | 23013452.0 |
| 2007-09-24 10:00:00 | AAPL | Stock | 5.2964 | 5.3054 | 5.2911 | 5.3021 | 16855776.0 |
| 2007-09-24 10:05:00 | AAPL | Stock | 5.3022 | 5.31 | 5.2875 | 5.2886 | 18959696.0 |
| 2007-09-24 10:10:00 | AAPL | Stock | 5.2886 | 5.3025 | 5.2821 | 5.2832 | 17467268.0 |
| 2007-09-24 10:15:00 | AAPL | Stock | 5.2832 | 5.3021 | 5.2825 | 5.2929 | 18340588.0 |
| 2007-09-24 10:20:00 | AAPL | Stock | 5.2932 | 5.3157 | 5.2918 | 5.3136 | 14951524.0 |
| 2007-09-24 10:25:00 | AAPL | Stock | 5.3129 | 5.3393 | 5.3129 | 5.3382 | 37605512.0 |
| 2007-09-24 10:30:00 | AAPL | Stock | 5.3382 | 5.3393 | 5.3264 | 5.3361 | 17040492.0 |
| 2007-09-24 10:35:00 | AAPL | Stock | 5.3361 | 5.3518 | 5.3057 | 5.3311 | 26478536.0 |
| 2007-09-24 10:40:00 | AAPL | Stock | 5.3311 | 5.3429 | 5.3282 | 5.3304 | 13281968.0 |
| 2007-09-24 10:45:00 | AAPL | Stock | 5.3296 | 5.3379 | 5.3296 | 5.3318 | 9809772.0 |
| 2007-09-24 10:50:00 | AAPL | Stock | 5.3318 | 5.3375 | 5.3296 | 5.3354 | 8878996.0 |
| 2007-09-24 10:55:00 | AAPL | Stock | 5.335 | 5.3464 | 5.3036 | 5.343 | 11519172.0 |
> showing 50 of 304,784 rows — these rows as CSV