PREVIEW / stock_30min / 2008-07-22
file: by_date/stock_30min/2008/2008-07-22.parquet size: 1.3 MB rows: 69,551 symbols: 3,325
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-22 04:00:00 | AAPL | Stock | 5.3214 | 5.3571 | 5.3214 | 5.3571 | 58800.0 |
| 2008-07-22 04:30:00 | AAPL | Stock | 5.3389 | 5.3389 | 5.3389 | 5.3389 | 2800.0 |
| 2008-07-22 05:00:00 | AAPL | Stock | 5.3393 | 5.3393 | 5.3143 | 5.3214 | 250320.0 |
| 2008-07-22 05:30:00 | AAPL | Stock | 5.3454 | 5.3571 | 5.3454 | 5.3571 | 322000.0 |
| 2008-07-22 06:00:00 | AAPL | Stock | 5.3571 | 5.3571 | 5.3571 | 5.3571 | 16800.0 |
| 2008-07-22 07:00:00 | AAPL | Stock | 5.3393 | 5.3571 | 5.3114 | 5.325 | 1327340.0 |
| 2008-07-22 07:30:00 | AAPL | Stock | 5.3293 | 5.3643 | 5.3089 | 5.3143 | 2374960.0 |
| 2008-07-22 08:00:00 | AAPL | Stock | 5.3089 | 5.3771 | 5.2921 | 5.3518 | 15083488.0 |
| 2008-07-22 08:30:00 | AAPL | Stock | 5.3518 | 5.3957 | 5.3107 | 5.3575 | 17627932.0 |
| 2008-07-22 09:00:00 | AAPL | Stock | 5.3536 | 5.3575 | 5.2932 | 5.3207 | 30078860.0 |
| 2008-07-22 09:30:00 | AAPL | Stock | 5.3204 | 5.4554 | 5.2332 | 5.4182 | 397048400.0 |
| 2008-07-22 10:00:00 | AAPL | Stock | 5.4182 | 5.4849 | 5.4 | 5.4382 | 203085456.0 |
| 2008-07-22 10:30:00 | AAPL | Stock | 5.4389 | 5.4843 | 5.4189 | 5.4629 | 117053160.0 |
| 2008-07-22 11:00:00 | AAPL | Stock | 5.4629 | 5.5007 | 5.4475 | 5.4844 | 93609964.0 |
| 2008-07-22 11:30:00 | AAPL | Stock | 5.4854 | 5.5021 | 5.4568 | 5.4811 | 77252616.0 |
| 2008-07-22 12:00:00 | AAPL | Stock | 5.4811 | 5.4829 | 5.4221 | 5.47 | 58415084.0 |
| 2008-07-22 12:30:00 | AAPL | Stock | 5.4714 | 5.4804 | 5.4475 | 5.4747 | 40649308.0 |
| 2008-07-22 13:00:00 | AAPL | Stock | 5.475 | 5.5271 | 5.4707 | 5.5107 | 80427536.0 |
| 2008-07-22 13:30:00 | AAPL | Stock | 5.5107 | 5.5386 | 5.5 | 5.5374 | 66700200.0 |
| 2008-07-22 14:00:00 | AAPL | Stock | 5.5379 | 5.5857 | 5.5307 | 5.5829 | 122429328.0 |
| 2008-07-22 14:30:00 | AAPL | Stock | 5.5829 | 5.6864 | 5.5629 | 5.6839 | 169252720.0 |
| 2008-07-22 15:00:00 | AAPL | Stock | 5.6839 | 5.7093 | 5.6457 | 5.6682 | 153560400.0 |
| 2008-07-22 15:30:00 | AAPL | Stock | 5.6682 | 5.8129 | 5.6525 | 5.7925 | 201993848.0 |
| 2008-07-22 16:00:00 | AAPL | Stock | 5.7925 | 5.7925 | 5.5154 | 5.7864 | 11844056.0 |
| 2008-07-22 16:30:00 | AAPL | Stock | 5.7864 | 5.8004 | 5.7612 | 5.7875 | 2812824.0 |
| 2008-07-22 17:00:00 | AAPL | Stock | 5.7879 | 5.7893 | 5.7768 | 5.7796 | 915516.0 |
| 2008-07-22 17:30:00 | AAPL | Stock | 5.7775 | 5.7843 | 5.7775 | 5.7821 | 308672.0 |
| 2008-07-22 18:00:00 | AAPL | Stock | 5.7821 | 5.7975 | 5.7821 | 5.7946 | 2148104.0 |
| 2008-07-22 18:30:00 | AAPL | Stock | 5.7946 | 5.8018 | 5.7921 | 5.8018 | 218344.0 |
| 2008-07-22 19:00:00 | AAPL | Stock | 5.7954 | 5.8 | 5.7864 | 5.7996 | 208516.0 |
| 2008-07-22 19:30:00 | AAPL | Stock | 5.7993 | 5.8018 | 5.7879 | 5.8018 | 197792.0 |
| 2008-07-22 06:30:00 | MSFT | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 400.0 |
| 2008-07-22 07:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.35 | 25.35 | 1200.0 |
| 2008-07-22 07:30:00 | MSFT | Stock | 25.45 | 25.45 | 25.35 | 25.35 | 1600.0 |
| 2008-07-22 08:00:00 | MSFT | Stock | 25.36 | 25.44 | 25.36 | 25.44 | 9587.0 |
| 2008-07-22 08:30:00 | MSFT | Stock | 25.45 | 25.48 | 25.4 | 25.4 | 77878.0 |
| 2008-07-22 09:00:00 | MSFT | Stock | 25.4 | 25.58 | 25.38 | 25.57 | 91479.0 |
| 2008-07-22 09:30:00 | MSFT | Stock | 25.58 | 25.65 | 25.49 | 25.63 | 12361797.0 |
| 2008-07-22 10:00:00 | MSFT | Stock | 25.62 | 25.94 | 25.56 | 25.771 | 7740869.0 |
| 2008-07-22 10:30:00 | MSFT | Stock | 25.76 | 25.83 | 25.53 | 25.54 | 6208666.0 |
| 2008-07-22 11:00:00 | MSFT | Stock | 25.54 | 25.56 | 25.48 | 25.51 | 5193203.0 |
| 2008-07-22 11:30:00 | MSFT | Stock | 25.5 | 25.6 | 25.48 | 25.505 | 4504392.0 |
| 2008-07-22 12:00:00 | MSFT | Stock | 25.5 | 25.6 | 25.5 | 25.56 | 4024362.0 |
| 2008-07-22 12:30:00 | MSFT | Stock | 25.553 | 25.68 | 25.55 | 25.68 | 5578124.0 |
| 2008-07-22 13:00:00 | MSFT | Stock | 25.68 | 25.73 | 25.63 | 25.68 | 6036763.0 |
| 2008-07-22 13:30:00 | MSFT | Stock | 25.67 | 25.72 | 25.67 | 25.7 | 5428668.0 |
| 2008-07-22 14:00:00 | MSFT | Stock | 25.7 | 25.74 | 25.59 | 25.62 | 6474290.0 |
| 2008-07-22 14:30:00 | MSFT | Stock | 25.61 | 25.64 | 25.57 | 25.6 | 5665000.0 |
| 2008-07-22 15:00:00 | MSFT | Stock | 25.6 | 25.64 | 25.58 | 25.62 | 4804721.0 |
| 2008-07-22 15:30:00 | MSFT | Stock | 25.61 | 25.8 | 25.61 | 25.8 | 10840547.0 |
> showing 50 of 69,551 rows — these rows as CSV