PREVIEW / stock_30min / 2009-11-17
file: by_date/stock_30min/2009/2009-11-17.parquet size: 1.3 MB rows: 71,645 symbols: 3,421
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-17 07:00:00 | AAPL | Stock | 7.35 | 7.3571 | 7.35 | 7.3571 | 11200.0 |
| 2009-11-17 07:30:00 | AAPL | Stock | 7.3571 | 7.3571 | 7.3411 | 7.3414 | 28000.0 |
| 2009-11-17 08:00:00 | AAPL | Stock | 7.3546 | 7.3639 | 7.3546 | 7.3586 | 174832.0 |
| 2009-11-17 08:30:00 | AAPL | Stock | 7.3571 | 7.3743 | 7.3511 | 7.3664 | 517440.0 |
| 2009-11-17 09:00:00 | AAPL | Stock | 7.3696 | 7.3732 | 7.3589 | 7.3596 | 442512.0 |
| 2009-11-17 09:30:00 | AAPL | Stock | 7.36 | 7.4086 | 7.3596 | 7.3839 | 62411776.0 |
| 2009-11-17 10:00:00 | AAPL | Stock | 7.385 | 7.39 | 7.3639 | 7.3746 | 24090276.0 |
| 2009-11-17 10:30:00 | AAPL | Stock | 7.3746 | 7.3789 | 7.35 | 7.3643 | 21491848.0 |
| 2009-11-17 11:00:00 | AAPL | Stock | 7.365 | 7.3661 | 7.3436 | 7.3557 | 20547716.0 |
| 2009-11-17 11:30:00 | AAPL | Stock | 7.3557 | 7.3679 | 7.3471 | 7.3661 | 15976744.0 |
| 2009-11-17 12:00:00 | AAPL | Stock | 7.3654 | 7.3879 | 7.3589 | 7.3761 | 14307944.0 |
| 2009-11-17 12:30:00 | AAPL | Stock | 7.3757 | 7.39 | 7.3754 | 7.3786 | 11987304.0 |
| 2009-11-17 13:00:00 | AAPL | Stock | 7.3786 | 7.3821 | 7.3661 | 7.3686 | 9574656.0 |
| 2009-11-17 13:30:00 | AAPL | Stock | 7.3686 | 7.3854 | 7.3682 | 7.3789 | 11326084.0 |
| 2009-11-17 14:00:00 | AAPL | Stock | 7.3782 | 7.3807 | 7.3214 | 7.3471 | 63514668.0 |
| 2009-11-17 14:30:00 | AAPL | Stock | 7.3479 | 7.3571 | 7.3425 | 7.3518 | 21091084.0 |
| 2009-11-17 15:00:00 | AAPL | Stock | 7.3518 | 7.3796 | 7.3511 | 7.3707 | 28661724.0 |
| 2009-11-17 15:30:00 | AAPL | Stock | 7.3704 | 7.3929 | 7.3561 | 7.3929 | 43040228.0 |
| 2009-11-17 16:00:00 | AAPL | Stock | 7.3925 | 7.395 | 7.3678 | 7.3914 | 8400756.0 |
| 2009-11-17 16:30:00 | AAPL | Stock | 7.3918 | 7.3929 | 7.3886 | 7.3886 | 251552.0 |
| 2009-11-17 17:00:00 | AAPL | Stock | 7.3886 | 7.3904 | 7.3879 | 7.3879 | 103628.0 |
| 2009-11-17 17:30:00 | AAPL | Stock | 7.3886 | 7.3886 | 7.3879 | 7.3886 | 54460.0 |
| 2009-11-17 18:00:00 | AAPL | Stock | 7.3857 | 7.3929 | 7.3839 | 7.3886 | 256676.0 |
| 2009-11-17 18:30:00 | AAPL | Stock | 7.3886 | 7.3886 | 7.3714 | 7.3857 | 48692.0 |
| 2009-11-17 19:00:00 | AAPL | Stock | 7.3864 | 7.3929 | 7.3861 | 7.3929 | 131908.0 |
| 2009-11-17 19:30:00 | AAPL | Stock | 7.3929 | 7.3929 | 7.3857 | 7.3893 | 122668.0 |
| 2009-11-17 06:30:00 | MSFT | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 110.0 |
| 2009-11-17 07:00:00 | MSFT | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 2890.0 |
| 2009-11-17 07:30:00 | MSFT | Stock | 29.47 | 29.48 | 29.45 | 29.48 | 564.0 |
| 2009-11-17 08:00:00 | MSFT | Stock | 29.48 | 29.5 | 29.42 | 29.5 | 7961.0 |
| 2009-11-17 08:30:00 | MSFT | Stock | 29.5 | 29.56 | 29.47 | 29.52 | 48522.0 |
| 2009-11-17 09:00:00 | MSFT | Stock | 29.52 | 29.54 | 29.49 | 29.52 | 56750.0 |
| 2009-11-17 09:30:00 | MSFT | Stock | 29.51 | 29.85 | 29.47 | 29.76 | 11332511.0 |
| 2009-11-17 10:00:00 | MSFT | Stock | 29.76 | 29.79 | 29.71 | 29.78 | 4352162.0 |
| 2009-11-17 10:30:00 | MSFT | Stock | 29.771 | 29.83 | 29.73 | 29.75 | 5328595.0 |
| 2009-11-17 11:00:00 | MSFT | Stock | 29.75 | 29.85 | 29.74 | 29.85 | 4549009.0 |
| 2009-11-17 11:30:00 | MSFT | Stock | 29.85 | 29.89 | 29.79 | 29.87 | 2393410.0 |
| 2009-11-17 12:00:00 | MSFT | Stock | 29.864 | 29.95 | 29.86 | 29.932 | 3862470.0 |
| 2009-11-17 12:30:00 | MSFT | Stock | 29.94 | 29.97 | 29.88 | 29.88 | 4256234.0 |
| 2009-11-17 13:00:00 | MSFT | Stock | 29.88 | 29.92 | 29.82 | 29.842 | 4607431.0 |
| 2009-11-17 13:30:00 | MSFT | Stock | 29.84 | 29.95 | 29.84 | 29.915 | 2471742.0 |
| 2009-11-17 14:00:00 | MSFT | Stock | 29.91 | 29.97 | 29.89 | 29.94 | 2125211.0 |
| 2009-11-17 14:30:00 | MSFT | Stock | 29.94 | 30.0 | 29.91 | 29.98 | 6276013.0 |
| 2009-11-17 15:00:00 | MSFT | Stock | 29.97 | 30.0 | 29.95 | 29.97 | 5512514.0 |
| 2009-11-17 15:30:00 | MSFT | Stock | 29.965 | 30.0 | 29.95 | 29.99 | 8379470.0 |
| 2009-11-17 16:00:00 | MSFT | Stock | 29.99 | 30.08 | 29.435 | 30.0 | 2220852.0 |
| 2009-11-17 16:30:00 | MSFT | Stock | 29.98 | 30.0 | 29.96 | 29.96 | 61799.0 |
| 2009-11-17 17:00:00 | MSFT | Stock | 29.41 | 30.02 | 29.41 | 30.02 | 159642.0 |
| 2009-11-17 17:30:00 | MSFT | Stock | 30.02 | 30.02 | 30.0 | 30.02 | 6384.0 |
| 2009-11-17 18:00:00 | MSFT | Stock | 30.01 | 30.02 | 30.0 | 30.02 | 36303.0 |
> showing 50 of 71,645 rows — these rows as CSV