PREVIEW / stock_30min / 2010-05-25
file: by_date/stock_30min/2010/2010-05-25.parquet size: 1.5 MB rows: 78,768 symbols: 3,494
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-25 04:00:00 | AAPL | Stock | 8.5714 | 8.6786 | 8.5714 | 8.6182 | 28000.0 |
| 2010-05-25 04:30:00 | AAPL | Stock | 8.6393 | 8.6393 | 8.5554 | 8.5554 | 7280.0 |
| 2010-05-25 05:00:00 | AAPL | Stock | 8.5714 | 8.5857 | 8.5714 | 8.5857 | 46200.0 |
| 2010-05-25 05:30:00 | AAPL | Stock | 8.5857 | 8.5857 | 8.5554 | 8.5554 | 12320.0 |
| 2010-05-25 06:00:00 | AAPL | Stock | 8.5557 | 8.5557 | 8.5343 | 8.5343 | 66360.0 |
| 2010-05-25 06:30:00 | AAPL | Stock | 8.5732 | 8.6214 | 8.5732 | 8.6214 | 57680.0 |
| 2010-05-25 07:00:00 | AAPL | Stock | 8.6071 | 8.6089 | 8.5536 | 8.5718 | 582316.0 |
| 2010-05-25 07:30:00 | AAPL | Stock | 8.5714 | 8.6207 | 8.5714 | 8.6207 | 451220.0 |
| 2010-05-25 08:00:00 | AAPL | Stock | 8.6221 | 8.6646 | 8.5893 | 8.6386 | 4111324.0 |
| 2010-05-25 08:30:00 | AAPL | Stock | 8.6425 | 8.6496 | 8.5807 | 8.5936 | 3467520.0 |
| 2010-05-25 09:00:00 | AAPL | Stock | 8.5939 | 8.8129 | 8.54 | 8.5482 | 4856292.0 |
| 2010-05-25 09:30:00 | AAPL | Stock | 8.5493 | 8.5968 | 8.47 | 8.5261 | 159689908.0 |
| 2010-05-25 10:00:00 | AAPL | Stock | 8.5286 | 8.6425 | 8.5114 | 8.5775 | 114392460.0 |
| 2010-05-25 10:30:00 | AAPL | Stock | 8.5796 | 8.5914 | 8.5118 | 8.56 | 78293040.0 |
| 2010-05-25 11:00:00 | AAPL | Stock | 8.5614 | 8.6207 | 8.55 | 8.5686 | 56652820.0 |
| 2010-05-25 11:30:00 | AAPL | Stock | 8.5711 | 8.6071 | 8.5182 | 8.5986 | 56552804.0 |
| 2010-05-25 12:00:00 | AAPL | Stock | 8.6007 | 8.6479 | 8.5822 | 8.5836 | 55630148.0 |
| 2010-05-25 12:30:00 | AAPL | Stock | 8.5836 | 8.5936 | 8.5479 | 8.5811 | 29268820.0 |
| 2010-05-25 13:00:00 | AAPL | Stock | 8.5831 | 8.5875 | 8.5357 | 8.56 | 32237016.0 |
| 2010-05-25 13:30:00 | AAPL | Stock | 8.5603 | 8.5636 | 8.5236 | 8.5378 | 39128012.0 |
| 2010-05-25 14:00:00 | AAPL | Stock | 8.5361 | 8.625 | 8.5179 | 8.61 | 58833488.0 |
| 2010-05-25 14:30:00 | AAPL | Stock | 8.6082 | 8.6929 | 8.5743 | 8.6598 | 87326428.0 |
| 2010-05-25 15:00:00 | AAPL | Stock | 8.658 | 8.7661 | 8.6579 | 8.7389 | 86946776.0 |
| 2010-05-25 15:30:00 | AAPL | Stock | 8.7426 | 8.8129 | 8.6929 | 8.7571 | 147606284.0 |
| 2010-05-25 16:00:00 | AAPL | Stock | 8.7571 | 8.7657 | 8.5807 | 8.7572 | 14242508.0 |
| 2010-05-25 16:30:00 | AAPL | Stock | 8.7579 | 8.7664 | 8.638 | 8.7664 | 2010540.0 |
| 2010-05-25 17:00:00 | AAPL | Stock | 8.7664 | 8.8104 | 8.7664 | 8.8104 | 1264760.0 |
| 2010-05-25 17:30:00 | AAPL | Stock | 8.8029 | 8.825 | 8.7968 | 8.8171 | 958272.0 |
| 2010-05-25 18:00:00 | AAPL | Stock | 8.8171 | 8.8204 | 8.7579 | 8.8157 | 627452.0 |
| 2010-05-25 18:30:00 | AAPL | Stock | 8.8143 | 8.8143 | 8.8071 | 8.8079 | 211540.0 |
| 2010-05-25 19:00:00 | AAPL | Stock | 8.8125 | 8.8204 | 8.8107 | 8.8196 | 312452.0 |
| 2010-05-25 19:30:00 | AAPL | Stock | 8.8193 | 8.8268 | 8.8179 | 8.8229 | 364560.0 |
| 2010-05-25 20:00:00 | AAPL | Stock | 8.8086 | 8.8086 | 8.8086 | 8.8086 | 103600.0 |
| 2010-05-25 06:00:00 | MSFT | Stock | 25.55 | 25.68 | 25.55 | 25.68 | 3150.0 |
| 2010-05-25 06:30:00 | MSFT | Stock | 25.68 | 25.7 | 25.68 | 25.7 | 2100.0 |
| 2010-05-25 07:00:00 | MSFT | Stock | 25.79 | 25.79 | 25.7 | 25.7 | 7565.0 |
| 2010-05-25 07:30:00 | MSFT | Stock | 25.7 | 25.85 | 25.65 | 25.85 | 30399.0 |
| 2010-05-25 08:00:00 | MSFT | Stock | 25.89 | 25.9 | 25.66 | 25.72 | 75981.0 |
| 2010-05-25 08:30:00 | MSFT | Stock | 25.71 | 25.72 | 25.62 | 25.65 | 40194.0 |
| 2010-05-25 09:00:00 | MSFT | Stock | 25.64 | 26.8 | 25.6 | 25.64 | 110719.0 |
| 2010-05-25 09:30:00 | MSFT | Stock | 25.65 | 26.27 | 25.38 | 25.59 | 10791450.0 |
| 2010-05-25 10:00:00 | MSFT | Stock | 25.59 | 25.67 | 25.465 | 25.54 | 12702294.0 |
| 2010-05-25 10:30:00 | MSFT | Stock | 25.53 | 25.65 | 25.47 | 25.64 | 5693292.0 |
| 2010-05-25 11:00:00 | MSFT | Stock | 25.64 | 25.82 | 25.57 | 25.79 | 6344347.0 |
| 2010-05-25 11:30:00 | MSFT | Stock | 25.785 | 25.82 | 25.63 | 25.81 | 5231567.0 |
| 2010-05-25 12:00:00 | MSFT | Stock | 25.82 | 25.93 | 25.66 | 25.78 | 4904425.0 |
| 2010-05-25 12:30:00 | MSFT | Stock | 25.78 | 25.83 | 25.72 | 25.78 | 3288480.0 |
| 2010-05-25 13:00:00 | MSFT | Stock | 25.77 | 25.8 | 25.6 | 25.681 | 4458517.0 |
| 2010-05-25 13:30:00 | MSFT | Stock | 25.685 | 25.72 | 25.58 | 25.65 | 4112156.0 |
| 2010-05-25 14:00:00 | MSFT | Stock | 25.65 | 25.81 | 25.62 | 25.76 | 5812566.0 |
> showing 50 of 78,768 rows — these rows as CSV