PREVIEW / stock_30min / 2007-01-30
file: by_date/stock_30min/2007/2007-01-30.parquet size: 972 KB rows: 52,702 symbols: 2,518
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-30 07:00:00 | AAPL | Stock | 3.0893 | 3.1 | 3.0804 | 3.1 | 135324.0 |
| 2007-01-30 07:30:00 | AAPL | Stock | 3.0911 | 3.0964 | 3.0893 | 3.095 | 437360.0 |
| 2007-01-30 08:00:00 | AAPL | Stock | 3.0936 | 3.0982 | 3.0918 | 3.0964 | 2228492.0 |
| 2007-01-30 08:30:00 | AAPL | Stock | 3.0961 | 3.0961 | 3.0893 | 3.0939 | 815724.0 |
| 2007-01-30 09:00:00 | AAPL | Stock | 3.0936 | 3.0943 | 3.0864 | 3.0875 | 2552424.0 |
| 2007-01-30 09:30:00 | AAPL | Stock | 3.0868 | 3.0889 | 3.0557 | 3.065 | 108318672.0 |
| 2007-01-30 10:00:00 | AAPL | Stock | 3.0646 | 3.0714 | 3.0625 | 3.0654 | 58701440.0 |
| 2007-01-30 10:30:00 | AAPL | Stock | 3.0654 | 3.0696 | 3.0504 | 3.0614 | 71896692.0 |
| 2007-01-30 11:00:00 | AAPL | Stock | 3.0614 | 3.0711 | 3.0561 | 3.0636 | 46813732.0 |
| 2007-01-30 11:30:00 | AAPL | Stock | 3.0639 | 3.0664 | 3.0575 | 3.0586 | 27308232.0 |
| 2007-01-30 12:00:00 | AAPL | Stock | 3.0589 | 3.0596 | 3.0482 | 3.0493 | 44913988.0 |
| 2007-01-30 12:30:00 | AAPL | Stock | 3.0489 | 3.0582 | 3.0471 | 3.0579 | 24991540.0 |
| 2007-01-30 13:00:00 | AAPL | Stock | 3.0575 | 3.0579 | 3.0446 | 3.0539 | 34942628.0 |
| 2007-01-30 13:30:00 | AAPL | Stock | 3.0539 | 3.0593 | 3.0482 | 3.0589 | 27384112.0 |
| 2007-01-30 14:00:00 | AAPL | Stock | 3.0586 | 3.0587 | 3.0507 | 3.0529 | 21984032.0 |
| 2007-01-30 14:30:00 | AAPL | Stock | 3.0525 | 3.0557 | 3.0489 | 3.0536 | 21957292.0 |
| 2007-01-30 15:00:00 | AAPL | Stock | 3.0539 | 3.0621 | 3.0529 | 3.0561 | 30064412.0 |
| 2007-01-30 15:30:00 | AAPL | Stock | 3.0557 | 3.0589 | 3.0518 | 3.0554 | 41605480.0 |
| 2007-01-30 16:00:00 | AAPL | Stock | 3.0568 | 3.06 | 3.0536 | 3.055 | 2275392.0 |
| 2007-01-30 16:30:00 | AAPL | Stock | 3.0546 | 3.0582 | 3.0546 | 3.0582 | 273112.0 |
| 2007-01-30 17:00:00 | AAPL | Stock | 3.0589 | 3.0596 | 3.0557 | 3.0557 | 533512.0 |
| 2007-01-30 17:30:00 | AAPL | Stock | 3.0557 | 3.0586 | 3.0536 | 3.0536 | 237580.0 |
| 2007-01-30 18:00:00 | AAPL | Stock | 3.0536 | 3.0554 | 3.0518 | 3.0518 | 295456.0 |
| 2007-01-30 18:30:00 | AAPL | Stock | 3.0518 | 3.055 | 3.0518 | 3.0518 | 235116.0 |
| 2007-01-30 19:00:00 | AAPL | Stock | 3.0536 | 3.055 | 3.0536 | 3.055 | 105700.0 |
| 2007-01-30 19:30:00 | AAPL | Stock | 3.0557 | 3.0586 | 3.0536 | 3.0536 | 126000.0 |
| 2007-01-30 07:00:00 | MSFT | Stock | 30.65 | 30.65 | 30.65 | 30.65 | 400.0 |
| 2007-01-30 07:30:00 | MSFT | Stock | 30.67 | 30.67 | 30.67 | 30.67 | 375.0 |
| 2007-01-30 08:00:00 | MSFT | Stock | 30.61 | 30.67 | 30.61 | 30.62 | 20958.0 |
| 2007-01-30 08:30:00 | MSFT | Stock | 30.61 | 30.65 | 30.55 | 30.57 | 34919.0 |
| 2007-01-30 09:00:00 | MSFT | Stock | 30.57 | 30.65 | 30.54 | 30.64 | 59722.0 |
| 2007-01-30 09:30:00 | MSFT | Stock | 30.57 | 30.64 | 30.14 | 30.32 | 9151393.0 |
| 2007-01-30 10:00:00 | MSFT | Stock | 30.32 | 30.33 | 30.16 | 30.27 | 5585478.0 |
| 2007-01-30 10:30:00 | MSFT | Stock | 30.27 | 30.33 | 30.239 | 30.26 | 4191997.0 |
| 2007-01-30 11:00:00 | MSFT | Stock | 30.26 | 30.41 | 30.18 | 30.35 | 4777191.0 |
| 2007-01-30 11:30:00 | MSFT | Stock | 30.35 | 30.38 | 30.3 | 30.32 | 2446819.0 |
| 2007-01-30 12:00:00 | MSFT | Stock | 30.31 | 30.33 | 30.27 | 30.33 | 3300466.0 |
| 2007-01-30 12:30:00 | MSFT | Stock | 30.32 | 30.39 | 30.31 | 30.38 | 2592189.0 |
| 2007-01-30 13:00:00 | MSFT | Stock | 30.39 | 30.39 | 30.33 | 30.38 | 4838009.0 |
| 2007-01-30 13:30:00 | MSFT | Stock | 30.37 | 30.45 | 30.34 | 30.39 | 3916518.0 |
| 2007-01-30 14:00:00 | MSFT | Stock | 30.36 | 30.38 | 30.3 | 30.34 | 3912862.0 |
| 2007-01-30 14:30:00 | MSFT | Stock | 30.33 | 30.46 | 30.31 | 30.44 | 2793249.0 |
| 2007-01-30 15:00:00 | MSFT | Stock | 30.439 | 30.6 | 30.33 | 30.47 | 4766711.0 |
| 2007-01-30 15:30:00 | MSFT | Stock | 30.48 | 30.54 | 30.44 | 30.49 | 7296473.0 |
| 2007-01-30 16:00:00 | MSFT | Stock | 30.5 | 30.52 | 30.4 | 30.42 | 657710.0 |
| 2007-01-30 16:30:00 | MSFT | Stock | 30.42 | 30.42 | 30.41 | 30.41 | 13365.0 |
| 2007-01-30 17:00:00 | MSFT | Stock | 30.41 | 30.43 | 30.41 | 30.42 | 2671.0 |
| 2007-01-30 17:30:00 | MSFT | Stock | 30.42 | 30.43 | 30.42 | 30.43 | 3855.0 |
| 2007-01-30 18:00:00 | MSFT | Stock | 30.43 | 30.45 | 30.43 | 30.45 | 13490.0 |
| 2007-01-30 18:30:00 | MSFT | Stock | 30.45 | 30.46 | 30.44 | 30.44 | 2200.0 |
> showing 50 of 52,702 rows — these rows as CSV