PREVIEW / stock_30min / 2009-07-13
file: by_date/stock_30min/2009/2009-07-13.parquet size: 1.3 MB rows: 74,710 symbols: 3,339
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-07-13 07:00:00 | AAPL | Stock | 4.9475 | 4.9475 | 4.9468 | 4.9468 | 25200.0 |
| 2009-07-13 07:30:00 | AAPL | Stock | 4.9375 | 4.9375 | 4.9375 | 4.9375 | 14000.0 |
| 2009-07-13 08:00:00 | AAPL | Stock | 4.9375 | 4.9711 | 4.9375 | 4.9682 | 595952.0 |
| 2009-07-13 08:30:00 | AAPL | Stock | 4.9682 | 4.9857 | 4.9643 | 4.9821 | 1273356.0 |
| 2009-07-13 09:00:00 | AAPL | Stock | 4.9832 | 4.9857 | 4.9764 | 4.9821 | 2000936.0 |
| 2009-07-13 09:30:00 | AAPL | Stock | 4.9825 | 5.0014 | 4.9118 | 4.9457 | 86814812.0 |
| 2009-07-13 10:00:00 | AAPL | Stock | 4.9461 | 4.9907 | 4.9246 | 4.9821 | 54178460.0 |
| 2009-07-13 10:30:00 | AAPL | Stock | 4.9821 | 5.0221 | 4.98 | 5.0196 | 47470192.0 |
| 2009-07-13 11:00:00 | AAPL | Stock | 5.02 | 5.0318 | 5.0111 | 5.0286 | 30942324.0 |
| 2009-07-13 11:30:00 | AAPL | Stock | 5.0292 | 5.0621 | 5.0282 | 5.0579 | 38820992.0 |
| 2009-07-13 12:00:00 | AAPL | Stock | 5.0579 | 5.0625 | 5.0454 | 5.0539 | 19453364.0 |
| 2009-07-13 12:30:00 | AAPL | Stock | 5.0537 | 5.0582 | 5.0411 | 5.0461 | 17515932.0 |
| 2009-07-13 13:00:00 | AAPL | Stock | 5.0467 | 5.0621 | 5.0407 | 5.0593 | 16821672.0 |
| 2009-07-13 13:30:00 | AAPL | Stock | 5.0604 | 5.0611 | 5.0471 | 5.0546 | 14588980.0 |
| 2009-07-13 14:00:00 | AAPL | Stock | 5.0543 | 5.0661 | 5.045 | 5.0593 | 21819700.0 |
| 2009-07-13 14:30:00 | AAPL | Stock | 5.06 | 5.0625 | 5.0482 | 5.055 | 15957396.0 |
| 2009-07-13 15:00:00 | AAPL | Stock | 5.0543 | 5.0657 | 5.0518 | 5.055 | 23769620.0 |
| 2009-07-13 15:30:00 | AAPL | Stock | 5.055 | 5.0832 | 5.0532 | 5.0832 | 62140764.0 |
| 2009-07-13 16:00:00 | AAPL | Stock | 5.0832 | 5.0846 | 5.0182 | 5.0714 | 12741008.0 |
| 2009-07-13 16:30:00 | AAPL | Stock | 5.0764 | 5.0836 | 5.0714 | 5.0746 | 2004436.0 |
| 2009-07-13 17:00:00 | AAPL | Stock | 5.0761 | 5.0836 | 5.0743 | 5.0789 | 179676.0 |
| 2009-07-13 17:30:00 | AAPL | Stock | 5.0732 | 5.0796 | 5.0732 | 5.0796 | 16800.0 |
| 2009-07-13 18:00:00 | AAPL | Stock | 5.0796 | 5.0836 | 5.075 | 5.0836 | 1430604.0 |
| 2009-07-13 18:30:00 | AAPL | Stock | 5.0779 | 5.0836 | 5.0779 | 5.0836 | 4677316.0 |
| 2009-07-13 19:00:00 | AAPL | Stock | 5.0821 | 5.0843 | 5.0757 | 5.0843 | 72744.0 |
| 2009-07-13 19:30:00 | AAPL | Stock | 5.0839 | 5.0871 | 5.0825 | 5.0861 | 133420.0 |
| 2009-07-13 08:00:00 | MSFT | Stock | 22.45 | 22.5 | 22.4 | 22.5 | 3659.0 |
| 2009-07-13 08:30:00 | MSFT | Stock | 22.45 | 22.5 | 22.4 | 22.4 | 5628.0 |
| 2009-07-13 09:00:00 | MSFT | Stock | 22.4 | 22.65 | 22.4 | 22.4 | 29704.0 |
| 2009-07-13 09:30:00 | MSFT | Stock | 22.42 | 22.51 | 22.14 | 22.33 | 5130132.0 |
| 2009-07-13 10:00:00 | MSFT | Stock | 22.34 | 22.54 | 22.28 | 22.49 | 5856064.0 |
| 2009-07-13 10:30:00 | MSFT | Stock | 22.5 | 22.71 | 22.5 | 22.71 | 3453518.0 |
| 2009-07-13 11:00:00 | MSFT | Stock | 22.706 | 22.74 | 22.67 | 22.69 | 2503546.0 |
| 2009-07-13 11:30:00 | MSFT | Stock | 22.699 | 23.03 | 22.69 | 22.99 | 6458501.0 |
| 2009-07-13 12:00:00 | MSFT | Stock | 22.99 | 23.01 | 22.89 | 22.94 | 2932243.0 |
| 2009-07-13 12:30:00 | MSFT | Stock | 22.94 | 23.0 | 22.91 | 23.0 | 2651333.0 |
| 2009-07-13 13:00:00 | MSFT | Stock | 22.995 | 23.08 | 22.97 | 23.013 | 3549293.0 |
| 2009-07-13 13:30:00 | MSFT | Stock | 23.02 | 23.03 | 23.0 | 23.0 | 1636811.0 |
| 2009-07-13 14:00:00 | MSFT | Stock | 23.005 | 23.06 | 23.0 | 23.01 | 3778532.0 |
| 2009-07-13 14:30:00 | MSFT | Stock | 23.01 | 23.15 | 23.0 | 23.13 | 5168061.0 |
| 2009-07-13 15:00:00 | MSFT | Stock | 23.13 | 23.19 | 23.1 | 23.165 | 6661116.0 |
| 2009-07-13 15:30:00 | MSFT | Stock | 23.17 | 23.25 | 23.14 | 23.23 | 10890195.0 |
| 2009-07-13 16:00:00 | MSFT | Stock | 23.24 | 23.29 | 22.896 | 23.14 | 4682078.0 |
| 2009-07-13 16:30:00 | MSFT | Stock | 23.14 | 23.23 | 23.14 | 23.23 | 124314.0 |
| 2009-07-13 17:00:00 | MSFT | Stock | 23.15 | 23.23 | 23.14 | 23.19 | 51440.0 |
| 2009-07-13 17:30:00 | MSFT | Stock | 23.19 | 23.22 | 23.15 | 23.21 | 31830.0 |
| 2009-07-13 18:00:00 | MSFT | Stock | 23.15 | 23.23 | 23.15 | 23.15 | 1177.0 |
| 2009-07-13 18:30:00 | MSFT | Stock | 23.23 | 23.23 | 23.15 | 23.16 | 804366.0 |
| 2009-07-13 19:30:00 | MSFT | Stock | 23.16 | 23.19 | 23.16 | 23.16 | 1100.0 |
| 2009-07-13 08:30:00 | NVDA | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 4000.0 |
> showing 50 of 74,710 rows — these rows as CSV