PREVIEW / stock_5min / 2010-06-01
file: by_date/stock_5min/2010/2010-06-01.parquet size: 4.9 MB rows: 338,012 symbols: 3,446
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-01 04:05:00 | AAPL | Stock | 9.1714 | 9.1771 | 9.1714 | 9.1743 | 19600.0 |
| 2010-06-01 04:10:00 | AAPL | Stock | 9.1743 | 9.1743 | 9.1714 | 9.1714 | 16800.0 |
| 2010-06-01 04:15:00 | AAPL | Stock | 9.1625 | 9.1661 | 9.1625 | 9.1661 | 58800.0 |
| 2010-06-01 04:25:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 14000.0 |
| 2010-06-01 04:30:00 | AAPL | Stock | 9.1679 | 9.1679 | 9.1679 | 9.1679 | 25200.0 |
| 2010-06-01 04:35:00 | AAPL | Stock | 9.1657 | 9.1739 | 9.1582 | 9.1582 | 36400.0 |
| 2010-06-01 04:40:00 | AAPL | Stock | 9.1575 | 9.1575 | 9.1214 | 9.1571 | 24920.0 |
| 2010-06-01 05:05:00 | AAPL | Stock | 9.1211 | 9.1214 | 9.1211 | 9.1214 | 7728.0 |
| 2010-06-01 05:35:00 | AAPL | Stock | 9.1304 | 9.1304 | 9.1304 | 9.1304 | 2800.0 |
| 2010-06-01 05:55:00 | AAPL | Stock | 9.125 | 9.125 | 9.125 | 9.125 | 8400.0 |
| 2010-06-01 06:10:00 | AAPL | Stock | 9.1321 | 9.1429 | 9.1321 | 9.1429 | 38276.0 |
| 2010-06-01 06:30:00 | AAPL | Stock | 9.175 | 9.175 | 9.175 | 9.175 | 6048.0 |
| 2010-06-01 06:45:00 | AAPL | Stock | 9.1464 | 9.1464 | 9.1464 | 9.1464 | 25900.0 |
| 2010-06-01 07:00:00 | AAPL | Stock | 9.175 | 9.1857 | 9.175 | 9.1854 | 106848.0 |
| 2010-06-01 07:05:00 | AAPL | Stock | 9.1854 | 9.1925 | 9.1743 | 9.1829 | 341544.0 |
| 2010-06-01 07:10:00 | AAPL | Stock | 9.1986 | 9.1986 | 9.1857 | 9.1857 | 64260.0 |
| 2010-06-01 07:15:00 | AAPL | Stock | 9.1961 | 9.1986 | 9.1854 | 9.1968 | 117600.0 |
| 2010-06-01 07:20:00 | AAPL | Stock | 9.1875 | 9.1875 | 9.1875 | 9.1875 | 2800.0 |
| 2010-06-01 07:25:00 | AAPL | Stock | 9.1964 | 9.1964 | 9.1964 | 9.1964 | 30800.0 |
| 2010-06-01 07:30:00 | AAPL | Stock | 9.1879 | 9.2061 | 9.1879 | 9.2061 | 28000.0 |
| 2010-06-01 07:35:00 | AAPL | Stock | 9.1964 | 9.2393 | 9.1961 | 9.225 | 228900.0 |
| 2010-06-01 07:40:00 | AAPL | Stock | 9.2318 | 9.2318 | 9.2036 | 9.2232 | 66136.0 |
| 2010-06-01 07:45:00 | AAPL | Stock | 9.2232 | 9.225 | 9.2143 | 9.2143 | 43568.0 |
| 2010-06-01 07:50:00 | AAPL | Stock | 9.2143 | 9.215 | 9.2143 | 9.215 | 27720.0 |
| 2010-06-01 07:55:00 | AAPL | Stock | 9.2146 | 9.2357 | 9.2143 | 9.2357 | 25424.0 |
| 2010-06-01 08:00:00 | AAPL | Stock | 9.2296 | 9.2564 | 9.2171 | 9.2364 | 892808.0 |
| 2010-06-01 08:05:00 | AAPL | Stock | 9.2357 | 9.245 | 9.2221 | 9.2393 | 754908.0 |
| 2010-06-01 08:10:00 | AAPL | Stock | 9.2411 | 9.2432 | 9.1743 | 9.2414 | 426412.0 |
| 2010-06-01 08:15:00 | AAPL | Stock | 9.2429 | 9.2471 | 9.2375 | 9.2443 | 309736.0 |
| 2010-06-01 08:20:00 | AAPL | Stock | 9.2462 | 9.2657 | 9.2461 | 9.2657 | 912324.0 |
| 2010-06-01 08:25:00 | AAPL | Stock | 9.265 | 9.2657 | 9.2425 | 9.25 | 651196.0 |
| 2010-06-01 08:30:00 | AAPL | Stock | 9.2471 | 9.2561 | 9.245 | 9.2539 | 449540.0 |
| 2010-06-01 08:35:00 | AAPL | Stock | 9.2539 | 9.2539 | 9.2375 | 9.2482 | 415688.0 |
| 2010-06-01 08:40:00 | AAPL | Stock | 9.2436 | 9.2454 | 9.2375 | 9.2439 | 315224.0 |
| 2010-06-01 08:45:00 | AAPL | Stock | 9.2446 | 9.2475 | 9.2375 | 9.2418 | 288204.0 |
| 2010-06-01 08:50:00 | AAPL | Stock | 9.2418 | 9.25 | 9.2414 | 9.25 | 215600.0 |
| 2010-06-01 08:55:00 | AAPL | Stock | 9.2546 | 9.2568 | 9.2482 | 9.2539 | 283360.0 |
| 2010-06-01 09:00:00 | AAPL | Stock | 9.2536 | 9.2536 | 9.2421 | 9.2443 | 708764.0 |
| 2010-06-01 09:05:00 | AAPL | Stock | 9.2446 | 9.2536 | 9.2411 | 9.2507 | 522676.0 |
| 2010-06-01 09:10:00 | AAPL | Stock | 9.2507 | 9.2532 | 9.2482 | 9.2511 | 362292.0 |
| 2010-06-01 09:15:00 | AAPL | Stock | 9.2505 | 9.2532 | 9.2454 | 9.2479 | 266056.0 |
| 2010-06-01 09:20:00 | AAPL | Stock | 9.2493 | 9.2679 | 9.1743 | 9.2593 | 771428.0 |
| 2010-06-01 09:25:00 | AAPL | Stock | 9.2618 | 9.2775 | 9.2596 | 9.2746 | 908348.0 |
| 2010-06-01 09:30:00 | AAPL | Stock | 9.2743 | 9.3193 | 9.2486 | 9.3161 | 36247820.0 |
| 2010-06-01 09:35:00 | AAPL | Stock | 9.3178 | 9.3289 | 9.29 | 9.3007 | 19561976.0 |
| 2010-06-01 09:40:00 | AAPL | Stock | 9.3018 | 9.3425 | 9.3 | 9.3354 | 20124496.0 |
| 2010-06-01 09:45:00 | AAPL | Stock | 9.3354 | 9.3568 | 9.3093 | 9.3464 | 16665376.0 |
| 2010-06-01 09:50:00 | AAPL | Stock | 9.3489 | 9.3643 | 9.335 | 9.3389 | 20731088.0 |
| 2010-06-01 09:55:00 | AAPL | Stock | 9.3407 | 9.3536 | 9.3321 | 9.3332 | 9419536.0 |
| 2010-06-01 10:00:00 | AAPL | Stock | 9.3354 | 9.3907 | 9.3321 | 9.3836 | 23018660.0 |
> showing 50 of 338,012 rows — these rows as CSV