PREVIEW / stock_30min / 2009-08-17
file: by_date/stock_30min/2009/2009-08-17.parquet size: 1.3 MB rows: 74,538 symbols: 3,367
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-08-17 04:00:00 | AAPL | Stock | 5.8843 | 5.8843 | 5.8286 | 5.8286 | 36400.0 |
| 2009-08-17 06:30:00 | AAPL | Stock | 5.8318 | 5.8543 | 5.8318 | 5.8318 | 28000.0 |
| 2009-08-17 07:00:00 | AAPL | Stock | 5.8425 | 5.8425 | 5.8214 | 5.8214 | 19600.0 |
| 2009-08-17 07:30:00 | AAPL | Stock | 5.8393 | 5.8521 | 5.8214 | 5.8332 | 132860.0 |
| 2009-08-17 08:00:00 | AAPL | Stock | 5.8371 | 5.8614 | 5.8286 | 5.8454 | 968352.0 |
| 2009-08-17 08:30:00 | AAPL | Stock | 5.85 | 5.8621 | 5.8436 | 5.8525 | 881972.0 |
| 2009-08-17 09:00:00 | AAPL | Stock | 5.8539 | 5.8561 | 5.8411 | 5.8411 | 828492.0 |
| 2009-08-17 09:30:00 | AAPL | Stock | 5.8425 | 5.8429 | 5.7857 | 5.8211 | 76117300.0 |
| 2009-08-17 10:00:00 | AAPL | Stock | 5.8209 | 5.825 | 5.7982 | 5.7989 | 33573092.0 |
| 2009-08-17 10:30:00 | AAPL | Stock | 5.7989 | 5.8054 | 5.7854 | 5.7904 | 29759604.0 |
| 2009-08-17 11:00:00 | AAPL | Stock | 5.7904 | 5.7918 | 5.7682 | 5.7832 | 38098676.0 |
| 2009-08-17 11:30:00 | AAPL | Stock | 5.7841 | 5.7936 | 5.7829 | 5.7854 | 19760468.0 |
| 2009-08-17 12:00:00 | AAPL | Stock | 5.785 | 5.7889 | 5.7732 | 5.7832 | 17707480.0 |
| 2009-08-17 12:30:00 | AAPL | Stock | 5.7839 | 5.7843 | 5.7618 | 5.7632 | 19014660.0 |
| 2009-08-17 13:00:00 | AAPL | Stock | 5.7632 | 5.7696 | 5.75 | 5.76 | 37039632.0 |
| 2009-08-17 13:30:00 | AAPL | Stock | 5.7607 | 5.7639 | 5.7443 | 5.7611 | 30607976.0 |
| 2009-08-17 14:00:00 | AAPL | Stock | 5.7614 | 5.7614 | 5.7425 | 5.7514 | 21751996.0 |
| 2009-08-17 14:30:00 | AAPL | Stock | 5.7507 | 5.7528 | 5.7275 | 5.7318 | 33448436.0 |
| 2009-08-17 15:00:00 | AAPL | Stock | 5.7318 | 5.7489 | 5.6993 | 5.7074 | 58859892.0 |
| 2009-08-17 15:30:00 | AAPL | Stock | 5.7064 | 5.7171 | 5.6936 | 5.7007 | 78176140.0 |
| 2009-08-17 16:00:00 | AAPL | Stock | 5.7021 | 5.7606 | 5.6975 | 5.7075 | 14497812.0 |
| 2009-08-17 16:30:00 | AAPL | Stock | 5.7773 | 5.7773 | 5.7025 | 5.7107 | 3977316.0 |
| 2009-08-17 17:00:00 | AAPL | Stock | 5.7376 | 5.7376 | 5.7054 | 5.7096 | 217840.0 |
| 2009-08-17 17:30:00 | AAPL | Stock | 5.7096 | 5.7139 | 5.7089 | 5.7132 | 264964.0 |
| 2009-08-17 18:00:00 | AAPL | Stock | 5.7132 | 5.7132 | 5.6996 | 5.71 | 930888.0 |
| 2009-08-17 18:30:00 | AAPL | Stock | 5.7071 | 5.7089 | 5.7054 | 5.7054 | 83720.0 |
| 2009-08-17 19:00:00 | AAPL | Stock | 5.7057 | 5.7139 | 5.7057 | 5.7139 | 23100.0 |
| 2009-08-17 19:30:00 | AAPL | Stock | 5.7125 | 5.7139 | 5.7089 | 5.7132 | 55860.0 |
| 2009-08-17 04:00:00 | MSFT | Stock | 23.46 | 23.46 | 23.46 | 23.46 | 200.0 |
| 2009-08-17 05:30:00 | MSFT | Stock | 23.23 | 23.23 | 23.2 | 23.2 | 902.0 |
| 2009-08-17 06:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.2 | 23.2 | 150.0 |
| 2009-08-17 07:00:00 | MSFT | Stock | 23.3 | 23.3 | 23.17 | 23.17 | 700.0 |
| 2009-08-17 07:30:00 | MSFT | Stock | 23.18 | 23.3 | 23.16 | 23.25 | 10700.0 |
| 2009-08-17 08:00:00 | MSFT | Stock | 23.26 | 23.53 | 23.14 | 23.3 | 38778.0 |
| 2009-08-17 08:30:00 | MSFT | Stock | 23.25 | 23.3 | 23.2 | 23.27 | 34151.0 |
| 2009-08-17 09:00:00 | MSFT | Stock | 23.26 | 23.47 | 23.25 | 23.31 | 110547.0 |
| 2009-08-17 09:30:00 | MSFT | Stock | 23.32 | 23.6 | 23.29 | 23.44 | 6045568.0 |
| 2009-08-17 10:00:00 | MSFT | Stock | 23.44 | 23.45 | 23.34 | 23.35 | 3212205.0 |
| 2009-08-17 10:30:00 | MSFT | Stock | 23.352 | 23.37 | 23.32 | 23.342 | 3112071.0 |
| 2009-08-17 11:00:00 | MSFT | Stock | 23.34 | 23.37 | 23.27 | 23.37 | 2683362.0 |
| 2009-08-17 11:30:00 | MSFT | Stock | 23.36 | 23.38 | 23.31 | 23.343 | 1380747.0 |
| 2009-08-17 12:00:00 | MSFT | Stock | 23.34 | 23.38 | 23.33 | 23.35 | 1778179.0 |
| 2009-08-17 12:30:00 | MSFT | Stock | 23.352 | 23.36 | 23.33 | 23.34 | 869743.0 |
| 2009-08-17 13:00:00 | MSFT | Stock | 23.34 | 23.35 | 23.29 | 23.3 | 1585068.0 |
| 2009-08-17 13:30:00 | MSFT | Stock | 23.29 | 23.31 | 23.25 | 23.28 | 2168532.0 |
| 2009-08-17 14:00:00 | MSFT | Stock | 23.29 | 23.32 | 23.26 | 23.31 | 1897591.0 |
| 2009-08-17 14:30:00 | MSFT | Stock | 23.31 | 23.32 | 23.24 | 23.28 | 1444467.0 |
| 2009-08-17 15:00:00 | MSFT | Stock | 23.27 | 23.33 | 23.23 | 23.27 | 2894737.0 |
| 2009-08-17 15:30:00 | MSFT | Stock | 23.26 | 23.32 | 23.23 | 23.24 | 7220423.0 |
| 2009-08-17 16:00:00 | MSFT | Stock | 23.23 | 23.332 | 23.22 | 23.26 | 2776271.0 |
> showing 50 of 74,538 rows — these rows as CSV