PREVIEW / stock_30min / 2010-08-10
file: by_date/stock_30min/2010/2010-08-10.parquet size: 1.3 MB rows: 73,144 symbols: 3,483
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-10 06:00:00 | AAPL | Stock | 9.3161 | 9.3161 | 9.3161 | 9.3161 | 5320.0 |
| 2010-08-10 07:00:00 | AAPL | Stock | 9.3107 | 9.3107 | 9.3036 | 9.3036 | 12684.0 |
| 2010-08-10 07:30:00 | AAPL | Stock | 9.3018 | 9.3071 | 9.2821 | 9.2821 | 165760.0 |
| 2010-08-10 08:00:00 | AAPL | Stock | 9.2857 | 9.3036 | 9.2779 | 9.2893 | 1223488.0 |
| 2010-08-10 08:30:00 | AAPL | Stock | 9.2857 | 9.2893 | 9.2707 | 9.285 | 935956.0 |
| 2010-08-10 09:00:00 | AAPL | Stock | 9.2832 | 9.2929 | 9.2754 | 9.28 | 1078672.0 |
| 2010-08-10 09:30:00 | AAPL | Stock | 9.2804 | 9.2996 | 9.2361 | 9.2504 | 67359320.0 |
| 2010-08-10 10:00:00 | AAPL | Stock | 9.2479 | 9.2568 | 9.2321 | 9.2496 | 45013752.0 |
| 2010-08-10 10:30:00 | AAPL | Stock | 9.2496 | 9.2536 | 9.2079 | 9.2143 | 41503700.0 |
| 2010-08-10 11:00:00 | AAPL | Stock | 9.215 | 9.2404 | 9.2107 | 9.2396 | 21022400.0 |
| 2010-08-10 11:30:00 | AAPL | Stock | 9.2394 | 9.2554 | 9.2336 | 9.2457 | 16618476.0 |
| 2010-08-10 12:00:00 | AAPL | Stock | 9.2457 | 9.2493 | 9.2382 | 9.2443 | 12408116.0 |
| 2010-08-10 12:30:00 | AAPL | Stock | 9.2432 | 9.2446 | 9.2218 | 9.2275 | 13937476.0 |
| 2010-08-10 13:00:00 | AAPL | Stock | 9.2275 | 9.2321 | 9.1982 | 9.2021 | 18193476.0 |
| 2010-08-10 13:30:00 | AAPL | Stock | 9.2011 | 9.2204 | 9.1986 | 9.2174 | 16706620.0 |
| 2010-08-10 14:00:00 | AAPL | Stock | 9.2179 | 9.275 | 9.2143 | 9.2543 | 52835076.0 |
| 2010-08-10 14:30:00 | AAPL | Stock | 9.2541 | 9.3018 | 9.254 | 9.2846 | 58468424.0 |
| 2010-08-10 15:00:00 | AAPL | Stock | 9.2839 | 9.2982 | 9.2621 | 9.285 | 35065380.0 |
| 2010-08-10 15:30:00 | AAPL | Stock | 9.285 | 9.2893 | 9.2525 | 9.2643 | 38193932.0 |
| 2010-08-10 16:00:00 | AAPL | Stock | 9.2643 | 9.2744 | 9.2218 | 9.2607 | 7176960.0 |
| 2010-08-10 16:30:00 | AAPL | Stock | 9.2607 | 9.2607 | 9.2157 | 9.2554 | 174440.0 |
| 2010-08-10 17:00:00 | AAPL | Stock | 9.2561 | 9.2596 | 9.2536 | 9.2554 | 82796.0 |
| 2010-08-10 17:30:00 | AAPL | Stock | 9.2529 | 9.2571 | 9.2518 | 9.2521 | 53928.0 |
| 2010-08-10 18:00:00 | AAPL | Stock | 9.2525 | 9.2646 | 9.2521 | 9.2614 | 166320.0 |
| 2010-08-10 18:30:00 | AAPL | Stock | 9.2561 | 9.2607 | 9.2561 | 9.2589 | 40600.0 |
| 2010-08-10 19:00:00 | AAPL | Stock | 9.2589 | 9.2589 | 9.2571 | 9.2589 | 24164.0 |
| 2010-08-10 19:30:00 | AAPL | Stock | 9.2607 | 9.2621 | 9.2564 | 9.2589 | 125244.0 |
| 2010-08-10 07:30:00 | MSFT | Stock | 25.5 | 25.5 | 25.5 | 25.5 | 200.0 |
| 2010-08-10 08:00:00 | MSFT | Stock | 25.4 | 25.46 | 25.39 | 25.4 | 5150.0 |
| 2010-08-10 08:30:00 | MSFT | Stock | 25.38 | 25.43 | 25.37 | 25.38 | 7150.0 |
| 2010-08-10 09:00:00 | MSFT | Stock | 25.38 | 25.38 | 25.3 | 25.33 | 58455.0 |
| 2010-08-10 09:30:00 | MSFT | Stock | 25.33 | 25.34 | 25.0 | 25.11 | 9192990.0 |
| 2010-08-10 10:00:00 | MSFT | Stock | 25.105 | 25.2 | 25.06 | 25.15 | 6668580.0 |
| 2010-08-10 10:30:00 | MSFT | Stock | 25.14 | 25.15 | 25.04 | 25.05 | 4595898.0 |
| 2010-08-10 11:00:00 | MSFT | Stock | 25.05 | 25.09 | 25.03 | 25.09 | 5100744.0 |
| 2010-08-10 11:30:00 | MSFT | Stock | 25.08 | 25.11 | 24.99 | 25.0 | 7220816.0 |
| 2010-08-10 12:00:00 | MSFT | Stock | 25.0 | 25.07 | 24.92 | 25.0 | 5779557.0 |
| 2010-08-10 12:30:00 | MSFT | Stock | 25.01 | 25.03 | 24.99 | 25.0 | 3300664.0 |
| 2010-08-10 13:00:00 | MSFT | Stock | 25.009 | 25.03 | 24.97 | 24.97 | 3647294.0 |
| 2010-08-10 13:30:00 | MSFT | Stock | 24.98 | 24.98 | 24.88 | 24.955 | 3998755.0 |
| 2010-08-10 14:00:00 | MSFT | Stock | 24.955 | 25.11 | 24.94 | 25.06 | 8589123.0 |
| 2010-08-10 14:30:00 | MSFT | Stock | 25.06 | 25.2 | 25.04 | 25.095 | 7971553.0 |
| 2010-08-10 15:00:00 | MSFT | Stock | 25.09 | 25.14 | 25.02 | 25.05 | 5298074.0 |
| 2010-08-10 15:30:00 | MSFT | Stock | 25.05 | 25.09 | 24.97 | 25.03 | 11838049.0 |
| 2010-08-10 16:00:00 | MSFT | Stock | 25.02 | 25.08 | 25.001 | 25.06 | 2814055.0 |
| 2010-08-10 16:30:00 | MSFT | Stock | 25.06 | 25.08 | 24.945 | 25.05 | 43626.0 |
| 2010-08-10 17:00:00 | MSFT | Stock | 25.05 | 25.08 | 25.05 | 25.08 | 1457.0 |
| 2010-08-10 17:30:00 | MSFT | Stock | 25.07 | 25.07 | 25.07 | 25.07 | 100.0 |
| 2010-08-10 18:00:00 | MSFT | Stock | 25.07 | 25.07 | 25.06 | 25.06 | 20826.0 |
| 2010-08-10 18:30:00 | MSFT | Stock | 25.07 | 25.07 | 25.07 | 25.07 | 1366.0 |
> showing 50 of 73,144 rows — these rows as CSV