PREVIEW / stock_30min / 2008-09-04
file: by_date/stock_30min/2008/2008-09-04.parquet size: 1.3 MB rows: 70,028 symbols: 3,300
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-04 07:00:00 | AAPL | Stock | 5.9629 | 5.9629 | 5.9429 | 5.9568 | 24556.0 |
| 2008-09-04 07:30:00 | AAPL | Stock | 5.9575 | 5.9575 | 5.9575 | 5.9575 | 8400.0 |
| 2008-09-04 08:00:00 | AAPL | Stock | 5.9568 | 5.9646 | 5.9411 | 5.9411 | 547316.0 |
| 2008-09-04 08:30:00 | AAPL | Stock | 5.9411 | 5.955 | 5.935 | 5.9371 | 361564.0 |
| 2008-09-04 09:00:00 | AAPL | Stock | 5.9411 | 5.9411 | 5.9125 | 5.9246 | 857416.0 |
| 2008-09-04 09:30:00 | AAPL | Stock | 5.9236 | 5.9969 | 5.9136 | 5.955 | 81853128.0 |
| 2008-09-04 10:00:00 | AAPL | Stock | 5.9554 | 5.9761 | 5.9371 | 5.955 | 56931196.0 |
| 2008-09-04 10:30:00 | AAPL | Stock | 5.9554 | 5.9554 | 5.8861 | 5.9168 | 58956660.0 |
| 2008-09-04 11:00:00 | AAPL | Stock | 5.9161 | 5.9393 | 5.8696 | 5.8943 | 42792092.0 |
| 2008-09-04 11:30:00 | AAPL | Stock | 5.8946 | 5.9161 | 5.8643 | 5.8911 | 34106520.0 |
| 2008-09-04 12:00:00 | AAPL | Stock | 5.8911 | 5.9286 | 5.8911 | 5.8939 | 26520788.0 |
| 2008-09-04 12:30:00 | AAPL | Stock | 5.8936 | 5.9029 | 5.8571 | 5.8717 | 34610436.0 |
| 2008-09-04 13:00:00 | AAPL | Stock | 5.8714 | 5.8782 | 5.7679 | 5.7875 | 73298316.0 |
| 2008-09-04 13:30:00 | AAPL | Stock | 5.7875 | 5.8086 | 5.75 | 5.7593 | 55507032.0 |
| 2008-09-04 14:00:00 | AAPL | Stock | 5.7589 | 5.7957 | 5.7432 | 5.7804 | 61168240.0 |
| 2008-09-04 14:30:00 | AAPL | Stock | 5.7804 | 5.8025 | 5.75 | 5.8007 | 49822920.0 |
| 2008-09-04 15:00:00 | AAPL | Stock | 5.8018 | 5.8468 | 5.7893 | 5.8046 | 62325060.0 |
| 2008-09-04 15:30:00 | AAPL | Stock | 5.8061 | 5.8293 | 5.7582 | 5.7582 | 77306936.0 |
| 2008-09-04 16:00:00 | AAPL | Stock | 5.7593 | 5.8548 | 5.7504 | 5.7593 | 17354036.0 |
| 2008-09-04 16:30:00 | AAPL | Stock | 5.7593 | 5.7607 | 5.7579 | 5.7604 | 1111012.0 |
| 2008-09-04 17:00:00 | AAPL | Stock | 5.7625 | 5.765 | 5.7579 | 5.7636 | 785512.0 |
| 2008-09-04 17:30:00 | AAPL | Stock | 5.7625 | 5.7679 | 5.7625 | 5.7679 | 129612.0 |
| 2008-09-04 18:00:00 | AAPL | Stock | 5.7714 | 5.7714 | 5.7518 | 5.7575 | 808220.0 |
| 2008-09-04 18:30:00 | AAPL | Stock | 5.7568 | 5.7568 | 5.7461 | 5.7461 | 237468.0 |
| 2008-09-04 19:00:00 | AAPL | Stock | 5.7439 | 5.7486 | 5.7432 | 5.7486 | 80920.0 |
| 2008-09-04 19:30:00 | AAPL | Stock | 5.7464 | 5.75 | 5.7439 | 5.75 | 125160.0 |
| 2008-09-04 08:00:00 | MSFT | Stock | 26.9 | 26.9 | 26.75 | 26.8 | 296300.0 |
| 2008-09-04 08:30:00 | MSFT | Stock | 26.8 | 26.84 | 26.8 | 26.84 | 800.0 |
| 2008-09-04 09:00:00 | MSFT | Stock | 26.77 | 26.87 | 26.64 | 26.7 | 77603.0 |
| 2008-09-04 09:30:00 | MSFT | Stock | 26.73 | 26.78 | 26.6 | 26.76 | 5577917.0 |
| 2008-09-04 10:00:00 | MSFT | Stock | 26.77 | 26.88 | 26.72 | 26.88 | 3551245.0 |
| 2008-09-04 10:30:00 | MSFT | Stock | 26.88 | 26.89 | 26.62 | 26.67 | 5604670.0 |
| 2008-09-04 11:00:00 | MSFT | Stock | 26.67 | 26.75 | 26.64 | 26.69 | 3631440.0 |
| 2008-09-04 11:30:00 | MSFT | Stock | 26.69 | 26.78 | 26.65 | 26.7 | 2279306.0 |
| 2008-09-04 12:00:00 | MSFT | Stock | 26.7 | 26.79 | 26.66 | 26.662 | 2352009.0 |
| 2008-09-04 12:30:00 | MSFT | Stock | 26.662 | 26.7 | 26.615 | 26.62 | 3315535.0 |
| 2008-09-04 13:00:00 | MSFT | Stock | 26.63 | 26.65 | 26.58 | 26.6 | 2828797.0 |
| 2008-09-04 13:30:00 | MSFT | Stock | 26.6 | 26.63 | 26.57 | 26.622 | 2057288.0 |
| 2008-09-04 14:00:00 | MSFT | Stock | 26.62 | 26.63 | 26.5 | 26.553 | 4847061.0 |
| 2008-09-04 14:30:00 | MSFT | Stock | 26.552 | 26.58 | 26.5 | 26.56 | 4984476.0 |
| 2008-09-04 15:00:00 | MSFT | Stock | 26.56 | 26.63 | 26.46 | 26.52 | 7325285.0 |
| 2008-09-04 15:30:00 | MSFT | Stock | 26.51 | 26.54 | 26.35 | 26.35 | 11531595.0 |
| 2008-09-04 16:00:00 | MSFT | Stock | 26.35 | 26.725 | 26.333 | 26.35 | 3267591.0 |
| 2008-09-04 16:30:00 | MSFT | Stock | 26.35 | 26.487 | 26.35 | 26.4 | 796391.0 |
| 2008-09-04 17:00:00 | MSFT | Stock | 26.35 | 26.47 | 26.35 | 26.42 | 145103.0 |
| 2008-09-04 17:30:00 | MSFT | Stock | 26.38 | 26.38 | 26.37 | 26.37 | 1224.0 |
| 2008-09-04 18:00:00 | MSFT | Stock | 26.528 | 26.528 | 26.35 | 26.35 | 2936.0 |
| 2008-09-04 18:30:00 | MSFT | Stock | 26.35 | 26.35 | 26.34 | 26.34 | 790200.0 |
| 2008-09-04 19:00:00 | MSFT | Stock | 26.33 | 26.38 | 26.33 | 26.38 | 1150.0 |
| 2008-09-04 08:00:00 | NVDA | Stock | 0.2938 | 0.2938 | 0.29 | 0.29 | 77000.0 |
> showing 50 of 70,028 rows — these rows as CSV