PREVIEW / stock_30min / 2008-12-08
file: by_date/stock_30min/2008/2008-12-08.parquet size: 1.2 MB rows: 71,157 symbols: 3,362
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-12-08 06:00:00 | AAPL | Stock | 3.4168 | 3.4168 | 3.4168 | 3.4168 | 28000.0 |
| 2008-12-08 06:30:00 | AAPL | Stock | 3.4279 | 3.4321 | 3.4279 | 3.4321 | 14000.0 |
| 2008-12-08 07:00:00 | AAPL | Stock | 3.4311 | 3.4461 | 3.4286 | 3.4461 | 132244.0 |
| 2008-12-08 07:30:00 | AAPL | Stock | 3.4464 | 3.4643 | 3.4461 | 3.4518 | 390012.0 |
| 2008-12-08 08:00:00 | AAPL | Stock | 3.4607 | 3.4857 | 3.4411 | 3.475 | 1785504.0 |
| 2008-12-08 08:30:00 | AAPL | Stock | 3.4786 | 3.4868 | 3.4721 | 3.4768 | 1889160.0 |
| 2008-12-08 09:00:00 | AAPL | Stock | 3.4779 | 3.5 | 3.4596 | 3.4729 | 4827704.0 |
| 2008-12-08 09:30:00 | AAPL | Stock | 3.4743 | 3.4821 | 3.4214 | 3.4568 | 145222140.0 |
| 2008-12-08 10:00:00 | AAPL | Stock | 3.4561 | 3.5096 | 3.4489 | 3.5082 | 107746212.0 |
| 2008-12-08 10:30:00 | AAPL | Stock | 3.5086 | 3.5625 | 3.5036 | 3.5432 | 114012808.0 |
| 2008-12-08 11:00:00 | AAPL | Stock | 3.5432 | 3.5514 | 3.5182 | 3.5189 | 70748160.0 |
| 2008-12-08 11:30:00 | AAPL | Stock | 3.5187 | 3.5386 | 3.5018 | 3.5211 | 60620728.0 |
| 2008-12-08 12:00:00 | AAPL | Stock | 3.5214 | 3.5464 | 3.5132 | 3.5407 | 50425452.0 |
| 2008-12-08 12:30:00 | AAPL | Stock | 3.5414 | 3.5464 | 3.5239 | 3.5329 | 41184892.0 |
| 2008-12-08 13:00:00 | AAPL | Stock | 3.5325 | 3.5554 | 3.5325 | 3.5457 | 52712184.0 |
| 2008-12-08 13:30:00 | AAPL | Stock | 3.5454 | 3.5457 | 3.5186 | 3.5364 | 61391260.0 |
| 2008-12-08 14:00:00 | AAPL | Stock | 3.5379 | 3.5593 | 3.5282 | 3.5454 | 62170276.0 |
| 2008-12-08 14:30:00 | AAPL | Stock | 3.5461 | 3.5893 | 3.5446 | 3.5879 | 107323580.0 |
| 2008-12-08 15:00:00 | AAPL | Stock | 3.5882 | 3.6 | 3.5736 | 3.5825 | 101090808.0 |
| 2008-12-08 15:30:00 | AAPL | Stock | 3.5828 | 3.5843 | 3.5146 | 3.5607 | 155427608.0 |
| 2008-12-08 16:00:00 | AAPL | Stock | 3.5611 | 3.5645 | 3.5294 | 3.5421 | 36423548.0 |
| 2008-12-08 16:30:00 | AAPL | Stock | 3.5553 | 3.5614 | 3.5286 | 3.5357 | 1468740.0 |
| 2008-12-08 17:00:00 | AAPL | Stock | 3.5354 | 3.5614 | 3.5307 | 3.5418 | 614096.0 |
| 2008-12-08 17:30:00 | AAPL | Stock | 3.5396 | 3.5421 | 3.5357 | 3.5361 | 363664.0 |
| 2008-12-08 18:00:00 | AAPL | Stock | 3.5357 | 3.5614 | 3.5282 | 3.5293 | 766360.0 |
| 2008-12-08 18:30:00 | AAPL | Stock | 3.5293 | 3.5304 | 3.525 | 3.525 | 127456.0 |
| 2008-12-08 19:00:00 | AAPL | Stock | 3.5229 | 3.5268 | 3.5171 | 3.5232 | 261884.0 |
| 2008-12-08 19:30:00 | AAPL | Stock | 3.5229 | 3.5246 | 3.5171 | 3.5196 | 171696.0 |
| 2008-12-08 07:00:00 | MSFT | Stock | 20.17 | 20.18 | 20.17 | 20.18 | 4817.0 |
| 2008-12-08 07:30:00 | MSFT | Stock | 20.17 | 20.22 | 20.15 | 20.22 | 5500.0 |
| 2008-12-08 08:00:00 | MSFT | Stock | 20.18 | 20.37 | 20.01 | 20.28 | 50949.0 |
| 2008-12-08 08:30:00 | MSFT | Stock | 20.31 | 20.4 | 20.3 | 20.34 | 38816.0 |
| 2008-12-08 09:00:00 | MSFT | Stock | 20.35 | 20.42 | 20.25 | 20.36 | 190899.0 |
| 2008-12-08 09:30:00 | MSFT | Stock | 20.36 | 20.5 | 20.16 | 20.19 | 9100793.0 |
| 2008-12-08 10:00:00 | MSFT | Stock | 20.19 | 20.56 | 20.14 | 20.481 | 9363657.0 |
| 2008-12-08 10:30:00 | MSFT | Stock | 20.49 | 20.79 | 20.48 | 20.6 | 6962951.0 |
| 2008-12-08 11:00:00 | MSFT | Stock | 20.6 | 20.71 | 20.59 | 20.65 | 5401044.0 |
| 2008-12-08 11:30:00 | MSFT | Stock | 20.65 | 20.72 | 20.54 | 20.66 | 4738381.0 |
| 2008-12-08 12:00:00 | MSFT | Stock | 20.66 | 20.84 | 20.58 | 20.815 | 4450166.0 |
| 2008-12-08 12:30:00 | MSFT | Stock | 20.82 | 20.85 | 20.67 | 20.7 | 4663353.0 |
| 2008-12-08 13:00:00 | MSFT | Stock | 20.701 | 20.89 | 20.701 | 20.87 | 5117320.0 |
| 2008-12-08 13:30:00 | MSFT | Stock | 20.861 | 20.89 | 20.69 | 20.742 | 5506275.0 |
| 2008-12-08 14:00:00 | MSFT | Stock | 20.74 | 20.99 | 20.69 | 20.96 | 5254768.0 |
| 2008-12-08 14:30:00 | MSFT | Stock | 20.96 | 21.1 | 20.85 | 21.08 | 6463603.0 |
| 2008-12-08 15:00:00 | MSFT | Stock | 21.07 | 21.25 | 20.99 | 21.13 | 8757570.0 |
| 2008-12-08 15:30:00 | MSFT | Stock | 21.12 | 21.2 | 20.76 | 21.01 | 19454859.0 |
| 2008-12-08 16:00:00 | MSFT | Stock | 21.01 | 21.01 | 20.758 | 20.85 | 9588393.0 |
| 2008-12-08 16:30:00 | MSFT | Stock | 20.927 | 21.01 | 20.81 | 20.81 | 56463.0 |
| 2008-12-08 17:00:00 | MSFT | Stock | 21.01 | 21.01 | 20.81 | 20.85 | 137702.0 |
| 2008-12-08 17:30:00 | MSFT | Stock | 20.79 | 20.85 | 20.76 | 20.76 | 1887.0 |
> showing 50 of 71,157 rows — these rows as CSV