PREVIEW / stock_30min / 2010-08-06
file: by_date/stock_30min/2010/2010-08-06.parquet size: 1.3 MB rows: 71,849 symbols: 3,455
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-08-06 07:00:00 | AAPL | Stock | 9.3479 | 9.3479 | 9.3479 | 9.3479 | 3360.0 |
| 2010-08-06 08:00:00 | AAPL | Stock | 9.3432 | 9.3529 | 9.3157 | 9.3214 | 435540.0 |
| 2010-08-06 08:30:00 | AAPL | Stock | 9.3214 | 9.3339 | 9.2729 | 9.2911 | 4300828.0 |
| 2010-08-06 09:00:00 | AAPL | Stock | 9.2904 | 9.3214 | 9.2554 | 9.2746 | 3005856.0 |
| 2010-08-06 09:30:00 | AAPL | Stock | 9.2757 | 9.3332 | 9.2357 | 9.3304 | 64475208.0 |
| 2010-08-06 10:00:00 | AAPL | Stock | 9.3289 | 9.3389 | 9.2946 | 9.31 | 34198388.0 |
| 2010-08-06 10:30:00 | AAPL | Stock | 9.31 | 9.326 | 9.2296 | 9.2364 | 59052728.0 |
| 2010-08-06 11:00:00 | AAPL | Stock | 9.2346 | 9.2575 | 9.2196 | 9.2443 | 37976232.0 |
| 2010-08-06 11:30:00 | AAPL | Stock | 9.2436 | 9.2614 | 9.2332 | 9.2479 | 20265868.0 |
| 2010-08-06 12:00:00 | AAPL | Stock | 9.2486 | 9.2536 | 9.2354 | 9.2357 | 12368692.0 |
| 2010-08-06 12:30:00 | AAPL | Stock | 9.2357 | 9.255 | 9.2339 | 9.2432 | 8765204.0 |
| 2010-08-06 13:00:00 | AAPL | Stock | 9.2432 | 9.2546 | 9.2329 | 9.2379 | 12987296.0 |
| 2010-08-06 13:30:00 | AAPL | Stock | 9.2371 | 9.2464 | 9.2204 | 9.2236 | 20722408.0 |
| 2010-08-06 14:00:00 | AAPL | Stock | 9.2232 | 9.2264 | 9.2011 | 9.2222 | 28292964.0 |
| 2010-08-06 14:30:00 | AAPL | Stock | 9.2204 | 9.2782 | 9.2171 | 9.2746 | 39528048.0 |
| 2010-08-06 15:00:00 | AAPL | Stock | 9.2729 | 9.2929 | 9.2579 | 9.2811 | 40334308.0 |
| 2010-08-06 15:30:00 | AAPL | Stock | 9.2811 | 9.2968 | 9.2714 | 9.2911 | 47769260.0 |
| 2010-08-06 16:00:00 | AAPL | Stock | 9.2886 | 9.292 | 9.2482 | 9.2864 | 3670604.0 |
| 2010-08-06 16:30:00 | AAPL | Stock | 9.2861 | 9.2948 | 9.2569 | 9.285 | 537656.0 |
| 2010-08-06 17:00:00 | AAPL | Stock | 9.2854 | 9.2886 | 9.2843 | 9.2875 | 61096.0 |
| 2010-08-06 17:30:00 | AAPL | Stock | 9.2846 | 9.2857 | 9.2821 | 9.2821 | 78848.0 |
| 2010-08-06 18:00:00 | AAPL | Stock | 9.2854 | 9.2889 | 9.2854 | 9.2871 | 233716.0 |
| 2010-08-06 18:30:00 | AAPL | Stock | 9.2857 | 9.2857 | 9.2857 | 9.2857 | 27244.0 |
| 2010-08-06 19:00:00 | AAPL | Stock | 9.2843 | 9.2861 | 9.2843 | 9.2861 | 8876.0 |
| 2010-08-06 19:30:00 | AAPL | Stock | 9.2857 | 9.2875 | 9.2821 | 9.2821 | 60200.0 |
| 2010-08-06 04:00:00 | MSFT | Stock | 25.44 | 25.44 | 25.44 | 25.44 | 500.0 |
| 2010-08-06 07:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.4 | 25.4 | 400.0 |
| 2010-08-06 08:00:00 | MSFT | Stock | 25.4 | 25.4 | 25.29 | 25.29 | 12353.0 |
| 2010-08-06 08:30:00 | MSFT | Stock | 25.25 | 25.27 | 25.12 | 25.16 | 39497.0 |
| 2010-08-06 09:00:00 | MSFT | Stock | 25.16 | 25.22 | 25.12 | 25.17 | 47439.0 |
| 2010-08-06 09:30:00 | MSFT | Stock | 25.18 | 25.31 | 25.03 | 25.26 | 5884542.0 |
| 2010-08-06 10:00:00 | MSFT | Stock | 25.26 | 25.31 | 25.17 | 25.225 | 4562013.0 |
| 2010-08-06 10:30:00 | MSFT | Stock | 25.23 | 25.24 | 25.03 | 25.03 | 6333475.0 |
| 2010-08-06 11:00:00 | MSFT | Stock | 25.04 | 25.15 | 25.02 | 25.12 | 5011200.0 |
| 2010-08-06 11:30:00 | MSFT | Stock | 25.12 | 25.17 | 25.05 | 25.11 | 2650168.0 |
| 2010-08-06 12:00:00 | MSFT | Stock | 25.11 | 25.13 | 25.05 | 25.058 | 2318342.0 |
| 2010-08-06 12:30:00 | MSFT | Stock | 25.05 | 25.14 | 25.05 | 25.1 | 2094921.0 |
| 2010-08-06 13:00:00 | MSFT | Stock | 25.105 | 25.14 | 25.08 | 25.1 | 2240456.0 |
| 2010-08-06 13:30:00 | MSFT | Stock | 25.105 | 25.16 | 25.06 | 25.095 | 2053760.0 |
| 2010-08-06 14:00:00 | MSFT | Stock | 25.095 | 25.16 | 25.07 | 25.15 | 2839636.0 |
| 2010-08-06 14:30:00 | MSFT | Stock | 25.158 | 25.33 | 25.14 | 25.31 | 3634208.0 |
| 2010-08-06 15:00:00 | MSFT | Stock | 25.32 | 25.39 | 25.29 | 25.36 | 4510178.0 |
| 2010-08-06 15:30:00 | MSFT | Stock | 25.365 | 25.56 | 25.35 | 25.56 | 10087955.0 |
| 2010-08-06 16:00:00 | MSFT | Stock | 25.55 | 25.6 | 25.105 | 25.55 | 1332457.0 |
| 2010-08-06 16:30:00 | MSFT | Stock | 25.45 | 25.55 | 25.36 | 25.55 | 25600.0 |
| 2010-08-06 17:00:00 | MSFT | Stock | 25.53 | 25.53 | 25.5 | 25.5 | 656.0 |
| 2010-08-06 17:30:00 | MSFT | Stock | 25.53 | 25.55 | 25.5 | 25.5 | 7680.0 |
| 2010-08-06 18:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.46 | 25.46 | 6066.0 |
| 2010-08-06 18:30:00 | MSFT | Stock | 25.54 | 25.54 | 25.52 | 25.52 | 2293.0 |
| 2010-08-06 19:00:00 | MSFT | Stock | 25.53 | 25.53 | 25.53 | 25.53 | 100.0 |
> showing 50 of 71,849 rows — these rows as CSV