PREVIEW / stock_30min / 2009-09-21
file: by_date/stock_30min/2009/2009-09-21.parquet size: 1.3 MB rows: 72,535 symbols: 3,394
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-09-21 04:30:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6054 | 6.6054 | 12152.0 |
| 2009-09-21 05:00:00 | AAPL | Stock | 6.6054 | 6.6054 | 6.6054 | 6.6054 | 5124.0 |
| 2009-09-21 05:30:00 | AAPL | Stock | 6.5754 | 6.5754 | 6.5754 | 6.5754 | 4200.0 |
| 2009-09-21 07:00:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5661 | 6.5661 | 118580.0 |
| 2009-09-21 07:30:00 | AAPL | Stock | 6.5675 | 6.5829 | 6.5604 | 6.5825 | 208460.0 |
| 2009-09-21 08:00:00 | AAPL | Stock | 6.5832 | 6.5889 | 6.56 | 6.56 | 973196.0 |
| 2009-09-21 08:30:00 | AAPL | Stock | 6.5607 | 6.5714 | 6.5571 | 6.5668 | 696556.0 |
| 2009-09-21 09:00:00 | AAPL | Stock | 6.5668 | 6.5857 | 6.5657 | 6.5857 | 826840.0 |
| 2009-09-21 09:30:00 | AAPL | Stock | 6.5836 | 6.6129 | 6.4864 | 6.5214 | 87205776.0 |
| 2009-09-21 10:00:00 | AAPL | Stock | 6.5243 | 6.5475 | 6.505 | 6.5264 | 44399992.0 |
| 2009-09-21 10:30:00 | AAPL | Stock | 6.5261 | 6.53 | 6.4982 | 6.5018 | 33277804.0 |
| 2009-09-21 11:00:00 | AAPL | Stock | 6.5018 | 6.535 | 6.4943 | 6.5333 | 48634460.0 |
| 2009-09-21 11:30:00 | AAPL | Stock | 6.5332 | 6.5603 | 6.5332 | 6.5545 | 26869388.0 |
| 2009-09-21 12:00:00 | AAPL | Stock | 6.5554 | 6.5639 | 6.5393 | 6.5564 | 21491820.0 |
| 2009-09-21 12:30:00 | AAPL | Stock | 6.5561 | 6.5625 | 6.5464 | 6.5496 | 13363644.0 |
| 2009-09-21 13:00:00 | AAPL | Stock | 6.5496 | 6.555 | 6.54 | 6.5546 | 13969312.0 |
| 2009-09-21 13:30:00 | AAPL | Stock | 6.5543 | 6.5632 | 6.5504 | 6.5554 | 13304648.0 |
| 2009-09-21 14:00:00 | AAPL | Stock | 6.5557 | 6.5611 | 6.5393 | 6.5418 | 19142928.0 |
| 2009-09-21 14:30:00 | AAPL | Stock | 6.5418 | 6.5611 | 6.5407 | 6.5554 | 15243396.0 |
| 2009-09-21 15:00:00 | AAPL | Stock | 6.5554 | 6.5825 | 6.5522 | 6.5743 | 22059436.0 |
| 2009-09-21 15:30:00 | AAPL | Stock | 6.5732 | 6.5746 | 6.5471 | 6.5743 | 38658648.0 |
| 2009-09-21 16:00:00 | AAPL | Stock | 6.5718 | 6.5732 | 6.5473 | 6.5714 | 30768976.0 |
| 2009-09-21 16:30:00 | AAPL | Stock | 6.5682 | 6.5764 | 6.5679 | 6.5764 | 156548.0 |
| 2009-09-21 17:00:00 | AAPL | Stock | 6.5764 | 6.5804 | 6.5721 | 6.58 | 444920.0 |
| 2009-09-21 17:30:00 | AAPL | Stock | 6.58 | 6.58 | 6.5786 | 6.58 | 19656.0 |
| 2009-09-21 18:00:00 | AAPL | Stock | 6.5775 | 6.5796 | 6.5721 | 6.5786 | 319116.0 |
| 2009-09-21 18:30:00 | AAPL | Stock | 6.5779 | 6.5779 | 6.575 | 6.575 | 87304.0 |
| 2009-09-21 19:00:00 | AAPL | Stock | 6.5779 | 6.58 | 6.5779 | 6.58 | 26880.0 |
| 2009-09-21 19:30:00 | AAPL | Stock | 6.5786 | 6.5804 | 6.5754 | 6.5768 | 92372.0 |
| 2009-09-21 06:00:00 | MSFT | Stock | 25.15 | 25.15 | 25.1 | 25.1 | 200.0 |
| 2009-09-21 07:00:00 | MSFT | Stock | 25.12 | 25.12 | 25.12 | 25.12 | 500.0 |
| 2009-09-21 07:30:00 | MSFT | Stock | 25.12 | 25.12 | 25.12 | 25.12 | 340.0 |
| 2009-09-21 08:00:00 | MSFT | Stock | 25.12 | 25.2 | 25.12 | 25.15 | 2498.0 |
| 2009-09-21 08:30:00 | MSFT | Stock | 25.19 | 25.19 | 25.11 | 25.11 | 5200.0 |
| 2009-09-21 09:00:00 | MSFT | Stock | 25.12 | 25.13 | 25.1 | 25.11 | 8977.0 |
| 2009-09-21 09:30:00 | MSFT | Stock | 25.11 | 25.31 | 25.1 | 25.14 | 4779852.0 |
| 2009-09-21 10:00:00 | MSFT | Stock | 25.14 | 25.24 | 25.105 | 25.2 | 3418135.0 |
| 2009-09-21 10:30:00 | MSFT | Stock | 25.2 | 25.2 | 25.14 | 25.2 | 1390139.0 |
| 2009-09-21 11:00:00 | MSFT | Stock | 25.2 | 25.31 | 25.19 | 25.28 | 2398655.0 |
| 2009-09-21 11:30:00 | MSFT | Stock | 25.28 | 25.37 | 25.28 | 25.34 | 1385883.0 |
| 2009-09-21 12:00:00 | MSFT | Stock | 25.345 | 25.35 | 25.29 | 25.29 | 1132631.0 |
| 2009-09-21 12:30:00 | MSFT | Stock | 25.29 | 25.32 | 25.25 | 25.27 | 1300182.0 |
| 2009-09-21 13:00:00 | MSFT | Stock | 25.28 | 25.28 | 25.24 | 25.275 | 1074171.0 |
| 2009-09-21 13:30:00 | MSFT | Stock | 25.27 | 25.29 | 25.25 | 25.26 | 1102149.0 |
| 2009-09-21 14:00:00 | MSFT | Stock | 25.27 | 25.28 | 25.18 | 25.247 | 1851655.0 |
| 2009-09-21 14:30:00 | MSFT | Stock | 25.241 | 25.31 | 25.24 | 25.25 | 1632145.0 |
| 2009-09-21 15:00:00 | MSFT | Stock | 25.25 | 25.33 | 25.24 | 25.3 | 1589692.0 |
| 2009-09-21 15:30:00 | MSFT | Stock | 25.29 | 25.301 | 25.2 | 25.3 | 3484777.0 |
| 2009-09-21 16:00:00 | MSFT | Stock | 25.29 | 25.34 | 25.22 | 25.254 | 1698070.0 |
| 2009-09-21 16:30:00 | MSFT | Stock | 25.3 | 25.3 | 25.3 | 25.3 | 1183.0 |
> showing 50 of 72,535 rows — these rows as CSV