PREVIEW / stock_30min / 2008-07-10
file: by_date/stock_30min/2008/2008-07-10.parquet size: 1.3 MB rows: 69,774 symbols: 3,315
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-10 04:00:00 | AAPL | Stock | 6.2621 | 6.2621 | 6.2621 | 6.2621 | 2800.0 |
| 2008-07-10 06:30:00 | AAPL | Stock | 6.2757 | 6.29 | 6.2757 | 6.2757 | 68488.0 |
| 2008-07-10 07:00:00 | AAPL | Stock | 6.2643 | 6.2857 | 6.2564 | 6.2857 | 163772.0 |
| 2008-07-10 07:30:00 | AAPL | Stock | 6.2875 | 6.3454 | 6.2875 | 6.3086 | 776748.0 |
| 2008-07-10 08:00:00 | AAPL | Stock | 6.3086 | 6.3239 | 6.28 | 6.2989 | 2183944.0 |
| 2008-07-10 08:30:00 | AAPL | Stock | 6.3025 | 6.3182 | 6.2539 | 6.2629 | 2709700.0 |
| 2008-07-10 09:00:00 | AAPL | Stock | 6.2671 | 6.2696 | 6.2261 | 6.2471 | 4179364.0 |
| 2008-07-10 09:30:00 | AAPL | Stock | 6.2464 | 6.3214 | 6.2432 | 6.2761 | 113103732.0 |
| 2008-07-10 10:00:00 | AAPL | Stock | 6.2771 | 6.3011 | 6.2057 | 6.2857 | 86135812.0 |
| 2008-07-10 10:30:00 | AAPL | Stock | 6.2836 | 6.3279 | 6.2507 | 6.2968 | 65660308.0 |
| 2008-07-10 11:00:00 | AAPL | Stock | 6.2975 | 6.3336 | 6.2682 | 6.2732 | 44578212.0 |
| 2008-07-10 11:30:00 | AAPL | Stock | 6.2721 | 6.3079 | 6.25 | 6.255 | 39248104.0 |
| 2008-07-10 12:00:00 | AAPL | Stock | 6.2564 | 6.31 | 6.2539 | 6.2643 | 36192884.0 |
| 2008-07-10 12:30:00 | AAPL | Stock | 6.2643 | 6.2786 | 6.2189 | 6.2421 | 59856384.0 |
| 2008-07-10 13:00:00 | AAPL | Stock | 6.2425 | 6.2718 | 6.2379 | 6.2604 | 36288364.0 |
| 2008-07-10 13:30:00 | AAPL | Stock | 6.2611 | 6.3071 | 6.2582 | 6.2679 | 43185632.0 |
| 2008-07-10 14:00:00 | AAPL | Stock | 6.2696 | 6.2811 | 6.2011 | 6.2086 | 45031420.0 |
| 2008-07-10 14:30:00 | AAPL | Stock | 6.2089 | 6.2298 | 6.1204 | 6.1404 | 74824596.0 |
| 2008-07-10 15:00:00 | AAPL | Stock | 6.1389 | 6.2517 | 6.1339 | 6.2407 | 84490728.0 |
| 2008-07-10 15:30:00 | AAPL | Stock | 6.2425 | 6.3089 | 6.2143 | 6.3071 | 75787040.0 |
| 2008-07-10 16:00:00 | AAPL | Stock | 6.3082 | 6.3196 | 6.2129 | 6.3107 | 9192036.0 |
| 2008-07-10 16:30:00 | AAPL | Stock | 6.3107 | 6.3161 | 6.2232 | 6.3161 | 1760696.0 |
| 2008-07-10 17:00:00 | AAPL | Stock | 6.3171 | 6.3393 | 6.3107 | 6.3393 | 529340.0 |
| 2008-07-10 17:30:00 | AAPL | Stock | 6.2451 | 6.3482 | 6.2451 | 6.3411 | 1344168.0 |
| 2008-07-10 18:00:00 | AAPL | Stock | 6.3396 | 6.3539 | 6.3396 | 6.3443 | 425208.0 |
| 2008-07-10 18:30:00 | AAPL | Stock | 6.3464 | 6.3539 | 6.3429 | 6.3464 | 115444.0 |
| 2008-07-10 19:00:00 | AAPL | Stock | 6.3436 | 6.3482 | 6.3425 | 6.3425 | 226044.0 |
| 2008-07-10 19:30:00 | AAPL | Stock | 6.3393 | 6.3479 | 6.3393 | 6.3479 | 114884.0 |
| 2008-07-10 07:30:00 | MSFT | Stock | 25.45 | 25.45 | 25.45 | 25.45 | 650.0 |
| 2008-07-10 08:00:00 | MSFT | Stock | 25.28 | 25.33 | 25.28 | 25.33 | 1250.0 |
| 2008-07-10 08:30:00 | MSFT | Stock | 25.33 | 25.4 | 25.29 | 25.29 | 11020.0 |
| 2008-07-10 09:00:00 | MSFT | Stock | 25.29 | 25.3 | 25.12 | 25.15 | 26643.0 |
| 2008-07-10 09:30:00 | MSFT | Stock | 25.18 | 25.67 | 25.17 | 25.34 | 5689357.0 |
| 2008-07-10 10:00:00 | MSFT | Stock | 25.34 | 25.4 | 25.01 | 25.4 | 7128841.0 |
| 2008-07-10 10:30:00 | MSFT | Stock | 25.39 | 25.46 | 25.23 | 25.27 | 3429340.0 |
| 2008-07-10 11:00:00 | MSFT | Stock | 25.26 | 25.44 | 25.192 | 25.23 | 3563048.0 |
| 2008-07-10 11:30:00 | MSFT | Stock | 25.23 | 25.42 | 25.21 | 25.38 | 2893054.0 |
| 2008-07-10 12:00:00 | MSFT | Stock | 25.371 | 25.55 | 25.371 | 25.43 | 2399419.0 |
| 2008-07-10 12:30:00 | MSFT | Stock | 25.44 | 25.51 | 25.38 | 25.42 | 1799075.0 |
| 2008-07-10 13:00:00 | MSFT | Stock | 25.42 | 25.52 | 25.4 | 25.5 | 2129054.0 |
| 2008-07-10 13:30:00 | MSFT | Stock | 25.5 | 25.53 | 25.43 | 25.44 | 2583727.0 |
| 2008-07-10 14:00:00 | MSFT | Stock | 25.44 | 25.48 | 25.13 | 25.178 | 3418059.0 |
| 2008-07-10 14:30:00 | MSFT | Stock | 25.17 | 25.24 | 24.98 | 25.01 | 4211002.0 |
| 2008-07-10 15:00:00 | MSFT | Stock | 25.02 | 25.43 | 25.01 | 25.39 | 6601643.0 |
| 2008-07-10 15:30:00 | MSFT | Stock | 25.39 | 25.46 | 25.24 | 25.45 | 6352085.0 |
| 2008-07-10 16:00:00 | MSFT | Stock | 25.46 | 25.5 | 25.06 | 25.49 | 2388309.0 |
| 2008-07-10 16:30:00 | MSFT | Stock | 25.49 | 25.49 | 25.23 | 25.49 | 133100.0 |
| 2008-07-10 17:00:00 | MSFT | Stock | 25.49 | 25.49 | 25.313 | 25.49 | 2440.0 |
| 2008-07-10 17:30:00 | MSFT | Stock | 25.45 | 25.52 | 25.45 | 25.52 | 230102.0 |
| 2008-07-10 18:00:00 | MSFT | Stock | 25.45 | 25.5 | 25.45 | 25.5 | 865150.0 |
> showing 50 of 69,774 rows — these rows as CSV