PREVIEW / stock_30min / 2009-02-11
file: by_date/stock_30min/2009/2009-02-11.parquet size: 1.2 MB rows: 65,675 symbols: 3,285
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-02-11 04:00:00 | AAPL | Stock | 3.5007 | 3.5007 | 3.5007 | 3.5007 | 14000.0 |
| 2009-02-11 04:30:00 | AAPL | Stock | 3.5036 | 3.5036 | 3.5036 | 3.5036 | 14000.0 |
| 2009-02-11 07:00:00 | AAPL | Stock | 3.5089 | 3.5089 | 3.4446 | 3.4464 | 453096.0 |
| 2009-02-11 07:30:00 | AAPL | Stock | 3.4296 | 3.4443 | 3.4218 | 3.4286 | 655844.0 |
| 2009-02-11 08:00:00 | AAPL | Stock | 3.4218 | 3.4389 | 3.4179 | 3.4193 | 2763208.0 |
| 2009-02-11 08:30:00 | AAPL | Stock | 3.4196 | 3.4232 | 3.4036 | 3.4179 | 2319632.0 |
| 2009-02-11 09:00:00 | AAPL | Stock | 3.4161 | 3.4429 | 3.4143 | 3.4429 | 3015236.0 |
| 2009-02-11 09:30:00 | AAPL | Stock | 3.4425 | 3.5071 | 3.4389 | 3.4939 | 106153936.0 |
| 2009-02-11 10:00:00 | AAPL | Stock | 3.4939 | 3.5071 | 3.4507 | 3.4532 | 75115824.0 |
| 2009-02-11 10:30:00 | AAPL | Stock | 3.4536 | 3.4779 | 3.4439 | 3.4673 | 48526772.0 |
| 2009-02-11 11:00:00 | AAPL | Stock | 3.4668 | 3.4993 | 3.4554 | 3.4964 | 38191552.0 |
| 2009-02-11 11:30:00 | AAPL | Stock | 3.4968 | 3.5111 | 3.4857 | 3.4929 | 38040940.0 |
| 2009-02-11 12:00:00 | AAPL | Stock | 3.4921 | 3.5 | 3.4789 | 3.4857 | 25174940.0 |
| 2009-02-11 12:30:00 | AAPL | Stock | 3.485 | 3.5046 | 3.4757 | 3.4864 | 29052380.0 |
| 2009-02-11 13:00:00 | AAPL | Stock | 3.4864 | 3.4946 | 3.4775 | 3.4804 | 26808628.0 |
| 2009-02-11 13:30:00 | AAPL | Stock | 3.4804 | 3.4804 | 3.4421 | 3.4511 | 40957616.0 |
| 2009-02-11 14:00:00 | AAPL | Stock | 3.4504 | 3.4593 | 3.4204 | 3.4454 | 50821260.0 |
| 2009-02-11 14:30:00 | AAPL | Stock | 3.4457 | 3.4789 | 3.4271 | 3.4696 | 59733100.0 |
| 2009-02-11 15:00:00 | AAPL | Stock | 3.4696 | 3.4904 | 3.46 | 3.4771 | 52969840.0 |
| 2009-02-11 15:30:00 | AAPL | Stock | 3.4768 | 3.4868 | 3.4496 | 3.4582 | 58868712.0 |
| 2009-02-11 16:00:00 | AAPL | Stock | 3.4575 | 3.4809 | 3.45 | 3.4579 | 5178824.0 |
| 2009-02-11 16:30:00 | AAPL | Stock | 3.4539 | 3.4589 | 3.4539 | 3.4571 | 74172.0 |
| 2009-02-11 17:00:00 | AAPL | Stock | 3.4554 | 3.4554 | 3.4536 | 3.4536 | 76860.0 |
| 2009-02-11 17:30:00 | AAPL | Stock | 3.4507 | 3.4507 | 3.4475 | 3.4475 | 42000.0 |
| 2009-02-11 18:00:00 | AAPL | Stock | 3.45 | 3.4579 | 3.4475 | 3.4536 | 3944024.0 |
| 2009-02-11 18:30:00 | AAPL | Stock | 3.4554 | 3.4564 | 3.4554 | 3.4557 | 28420.0 |
| 2009-02-11 19:00:00 | AAPL | Stock | 3.4507 | 3.4507 | 3.4468 | 3.4475 | 18760.0 |
| 2009-02-11 19:30:00 | AAPL | Stock | 3.4468 | 3.455 | 3.4468 | 3.4482 | 49168.0 |
| 2009-02-11 07:00:00 | MSFT | Stock | 19.05 | 19.05 | 19.05 | 19.05 | 200.0 |
| 2009-02-11 07:30:00 | MSFT | Stock | 18.88 | 18.88 | 18.75 | 18.75 | 5100.0 |
| 2009-02-11 08:00:00 | MSFT | Stock | 18.88 | 18.89 | 18.82 | 18.89 | 5100.0 |
| 2009-02-11 08:30:00 | MSFT | Stock | 18.88 | 18.99 | 18.88 | 18.93 | 5650.0 |
| 2009-02-11 09:00:00 | MSFT | Stock | 18.93 | 18.98 | 18.93 | 18.95 | 17531.0 |
| 2009-02-11 09:30:00 | MSFT | Stock | 18.94 | 19.29 | 18.92 | 19.24 | 6353954.0 |
| 2009-02-11 10:00:00 | MSFT | Stock | 19.23 | 19.34 | 19.11 | 19.13 | 7629927.0 |
| 2009-02-11 10:30:00 | MSFT | Stock | 19.14 | 19.37 | 19.1 | 19.3 | 5378131.0 |
| 2009-02-11 11:00:00 | MSFT | Stock | 19.3 | 19.32 | 19.21 | 19.289 | 2683485.0 |
| 2009-02-11 11:30:00 | MSFT | Stock | 19.28 | 19.35 | 19.21 | 19.25 | 2531896.0 |
| 2009-02-11 12:00:00 | MSFT | Stock | 19.245 | 19.37 | 19.15 | 19.195 | 2879690.0 |
| 2009-02-11 12:30:00 | MSFT | Stock | 19.19 | 19.34 | 19.13 | 19.15 | 3018048.0 |
| 2009-02-11 13:00:00 | MSFT | Stock | 19.15 | 19.23 | 19.12 | 19.211 | 3072861.0 |
| 2009-02-11 13:30:00 | MSFT | Stock | 19.21 | 19.22 | 19.01 | 19.02 | 2406386.0 |
| 2009-02-11 14:00:00 | MSFT | Stock | 19.03 | 19.2 | 18.99 | 19.129 | 3750029.0 |
| 2009-02-11 14:30:00 | MSFT | Stock | 19.127 | 19.44 | 19.11 | 19.41 | 4708088.0 |
| 2009-02-11 15:00:00 | MSFT | Stock | 19.42 | 19.49 | 19.32 | 19.37 | 5853124.0 |
| 2009-02-11 15:30:00 | MSFT | Stock | 19.36 | 19.4 | 19.21 | 19.21 | 6027886.0 |
| 2009-02-11 16:00:00 | MSFT | Stock | 19.22 | 19.36 | 19.16 | 19.25 | 1316789.0 |
| 2009-02-11 16:30:00 | MSFT | Stock | 19.21 | 19.28 | 19.21 | 19.28 | 3563.0 |
| 2009-02-11 17:00:00 | MSFT | Stock | 19.25 | 19.25 | 19.22 | 19.22 | 400.0 |
| 2009-02-11 17:30:00 | MSFT | Stock | 19.25 | 19.25 | 19.25 | 19.25 | 14900.0 |
> showing 50 of 65,675 rows — these rows as CSV