PREVIEW / stock_30min / 2012-05-08
file: by_date/stock_30min/2012/2012-05-08.parquet size: 1.4 MB rows: 75,900 symbols: 3,549
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-08 04:00:00 | AAPL | Stock | 20.2882 | 20.2882 | 20.2857 | 20.2857 | 5600.0 |
| 2012-05-08 04:30:00 | AAPL | Stock | 20.2854 | 20.2854 | 20.2496 | 20.2496 | 39200.0 |
| 2012-05-08 05:30:00 | AAPL | Stock | 20.2393 | 20.2393 | 20.2021 | 20.2021 | 32928.0 |
| 2012-05-08 06:00:00 | AAPL | Stock | 20.2311 | 20.2311 | 20.2311 | 20.2311 | 2800.0 |
| 2012-05-08 06:30:00 | AAPL | Stock | 20.2321 | 20.2354 | 20.2321 | 20.2354 | 31360.0 |
| 2012-05-08 07:00:00 | AAPL | Stock | 20.2325 | 20.3 | 20.2325 | 20.2954 | 86800.0 |
| 2012-05-08 07:30:00 | AAPL | Stock | 20.3032 | 20.3571 | 20.2821 | 20.3571 | 163800.0 |
| 2012-05-08 08:00:00 | AAPL | Stock | 20.3571 | 20.4407 | 20.3046 | 20.3046 | 1565620.0 |
| 2012-05-08 08:30:00 | AAPL | Stock | 20.3082 | 20.3875 | 20.3007 | 20.3696 | 720888.0 |
| 2012-05-08 09:00:00 | AAPL | Stock | 20.3679 | 20.375 | 20.3261 | 20.3529 | 1230040.0 |
| 2012-05-08 09:30:00 | AAPL | Stock | 20.3554 | 20.4107 | 20.1579 | 20.1743 | 65349760.0 |
| 2012-05-08 10:00:00 | AAPL | Stock | 20.1764 | 20.2321 | 20.1293 | 20.1843 | 38459736.0 |
| 2012-05-08 10:30:00 | AAPL | Stock | 20.1789 | 20.2046 | 20.0125 | 20.0911 | 49591920.0 |
| 2012-05-08 11:00:00 | AAPL | Stock | 20.0961 | 20.1214 | 19.9546 | 20.0939 | 48129480.0 |
| 2012-05-08 11:30:00 | AAPL | Stock | 20.0954 | 20.1511 | 20.025 | 20.1068 | 34765780.0 |
| 2012-05-08 12:00:00 | AAPL | Stock | 20.1046 | 20.1193 | 19.9836 | 20.0119 | 22576820.0 |
| 2012-05-08 12:30:00 | AAPL | Stock | 20.0111 | 20.0518 | 19.9821 | 20.0036 | 17286976.0 |
| 2012-05-08 13:00:00 | AAPL | Stock | 20.0021 | 20.0696 | 19.9861 | 20.0661 | 18296964.0 |
| 2012-05-08 13:30:00 | AAPL | Stock | 20.0646 | 20.1425 | 20.0486 | 20.1064 | 22518132.0 |
| 2012-05-08 14:00:00 | AAPL | Stock | 20.1018 | 20.1932 | 20.0961 | 20.1864 | 20816740.0 |
| 2012-05-08 14:30:00 | AAPL | Stock | 20.1861 | 20.3268 | 20.1625 | 20.2751 | 42142464.0 |
| 2012-05-08 15:00:00 | AAPL | Stock | 20.275 | 20.37 | 20.2036 | 20.3571 | 44275476.0 |
| 2012-05-08 15:30:00 | AAPL | Stock | 20.3495 | 20.3875 | 20.2846 | 20.2882 | 46688516.0 |
| 2012-05-08 16:00:00 | AAPL | Stock | 20.2914 | 20.2971 | 20.0856 | 20.2946 | 13880692.0 |
| 2012-05-08 16:30:00 | AAPL | Stock | 20.2893 | 20.2993 | 20.2416 | 20.2921 | 369320.0 |
| 2012-05-08 17:00:00 | AAPL | Stock | 20.275 | 20.2857 | 20.275 | 20.28 | 38892.0 |
| 2012-05-08 17:30:00 | AAPL | Stock | 20.2782 | 20.2939 | 20.2782 | 20.2829 | 216048.0 |
| 2012-05-08 18:00:00 | AAPL | Stock | 20.2829 | 20.2857 | 20.2804 | 20.2857 | 125160.0 |
| 2012-05-08 18:30:00 | AAPL | Stock | 20.2793 | 20.2871 | 20.2793 | 20.2857 | 134036.0 |
| 2012-05-08 19:00:00 | AAPL | Stock | 20.2811 | 20.2811 | 20.2554 | 20.2607 | 191072.0 |
| 2012-05-08 19:30:00 | AAPL | Stock | 20.2571 | 20.2625 | 20.2482 | 20.25 | 249396.0 |
| 2012-05-08 07:00:00 | MSFT | Stock | 30.5 | 30.5 | 30.5 | 30.5 | 549.0 |
| 2012-05-08 08:00:00 | MSFT | Stock | 30.6 | 30.65 | 30.5 | 30.5 | 8547.0 |
| 2012-05-08 08:30:00 | MSFT | Stock | 30.46 | 30.54 | 30.41 | 30.49 | 7051.0 |
| 2012-05-08 09:00:00 | MSFT | Stock | 30.48 | 30.55 | 30.46 | 30.48 | 29659.0 |
| 2012-05-08 09:30:00 | MSFT | Stock | 30.51 | 30.78 | 30.48 | 30.56 | 5546168.0 |
| 2012-05-08 10:00:00 | MSFT | Stock | 30.57 | 30.58 | 30.4 | 30.42 | 3664018.0 |
| 2012-05-08 10:30:00 | MSFT | Stock | 30.42 | 30.42 | 30.23 | 30.33 | 4971170.0 |
| 2012-05-08 11:00:00 | MSFT | Stock | 30.325 | 30.38 | 30.25 | 30.26 | 3332307.0 |
| 2012-05-08 11:30:00 | MSFT | Stock | 30.255 | 30.39 | 30.17 | 30.33 | 4203577.0 |
| 2012-05-08 12:00:00 | MSFT | Stock | 30.33 | 30.34 | 30.2 | 30.285 | 2792357.0 |
| 2012-05-08 12:30:00 | MSFT | Stock | 30.28 | 30.31 | 30.22 | 30.26 | 2514714.0 |
| 2012-05-08 13:00:00 | MSFT | Stock | 30.25 | 30.41 | 30.25 | 30.41 | 1908355.0 |
| 2012-05-08 13:30:00 | MSFT | Stock | 30.41 | 30.49 | 30.37 | 30.451 | 1666853.0 |
| 2012-05-08 14:00:00 | MSFT | Stock | 30.45 | 30.48 | 30.38 | 30.45 | 1416267.0 |
| 2012-05-08 14:30:00 | MSFT | Stock | 30.45 | 30.53 | 30.42 | 30.455 | 2281933.0 |
| 2012-05-08 15:00:00 | MSFT | Stock | 30.455 | 30.58 | 30.4 | 30.5 | 3092544.0 |
| 2012-05-08 15:30:00 | MSFT | Stock | 30.5 | 30.545 | 30.45 | 30.49 | 5799095.0 |
| 2012-05-08 16:00:00 | MSFT | Stock | 30.49 | 30.53 | 30.413 | 30.53 | 2786031.0 |
| 2012-05-08 16:30:00 | MSFT | Stock | 30.51 | 30.737 | 30.45 | 30.737 | 124629.0 |
> showing 50 of 75,900 rows — these rows as CSV