PREVIEW / stock_30min / 2009-05-21
file: by_date/stock_30min/2009/2009-05-21.parquet size: 1.3 MB rows: 70,598 symbols: 3,343
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-05-21 06:30:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4821 | 4.4821 | 5600.0 |
| 2009-05-21 07:00:00 | AAPL | Stock | 4.4757 | 4.4757 | 4.4757 | 4.4757 | 2800.0 |
| 2009-05-21 07:30:00 | AAPL | Stock | 4.4768 | 4.4821 | 4.4768 | 4.4796 | 64400.0 |
| 2009-05-21 08:00:00 | AAPL | Stock | 4.4821 | 4.4821 | 4.4714 | 4.4786 | 228452.0 |
| 2009-05-21 08:30:00 | AAPL | Stock | 4.4786 | 4.4786 | 4.4593 | 4.4679 | 356356.0 |
| 2009-05-21 09:00:00 | AAPL | Stock | 4.4686 | 4.4729 | 4.4586 | 4.4696 | 684572.0 |
| 2009-05-21 09:30:00 | AAPL | Stock | 4.4696 | 4.5279 | 4.4464 | 4.5093 | 60778984.0 |
| 2009-05-21 10:00:00 | AAPL | Stock | 4.508 | 4.5239 | 4.4575 | 4.4721 | 40915476.0 |
| 2009-05-21 10:30:00 | AAPL | Stock | 4.4711 | 4.4882 | 4.4446 | 4.445 | 29224384.0 |
| 2009-05-21 11:00:00 | AAPL | Stock | 4.445 | 4.4461 | 4.4046 | 4.4211 | 44421020.0 |
| 2009-05-21 11:30:00 | AAPL | Stock | 4.4204 | 4.4382 | 4.4164 | 4.4314 | 18298812.0 |
| 2009-05-21 12:00:00 | AAPL | Stock | 4.4311 | 4.4363 | 4.4096 | 4.4121 | 18046840.0 |
| 2009-05-21 12:30:00 | AAPL | Stock | 4.4125 | 4.4321 | 4.4107 | 4.4286 | 16455656.0 |
| 2009-05-21 13:00:00 | AAPL | Stock | 4.4268 | 4.4368 | 4.3964 | 4.3982 | 16790340.0 |
| 2009-05-21 13:30:00 | AAPL | Stock | 4.3982 | 4.4304 | 4.3961 | 4.4261 | 20542256.0 |
| 2009-05-21 14:00:00 | AAPL | Stock | 4.4261 | 4.4439 | 4.3964 | 4.405 | 26264364.0 |
| 2009-05-21 14:30:00 | AAPL | Stock | 4.405 | 4.4757 | 4.3889 | 4.4046 | 25052160.0 |
| 2009-05-21 15:00:00 | AAPL | Stock | 4.4046 | 4.415 | 4.3954 | 4.4058 | 22763132.0 |
| 2009-05-21 15:30:00 | AAPL | Stock | 4.4068 | 4.4375 | 4.4014 | 4.4257 | 48529796.0 |
| 2009-05-21 16:00:00 | AAPL | Stock | 4.4254 | 4.4582 | 4.4202 | 4.4332 | 15176952.0 |
| 2009-05-21 16:30:00 | AAPL | Stock | 4.4329 | 4.4411 | 4.4325 | 4.4393 | 748664.0 |
| 2009-05-21 17:00:00 | AAPL | Stock | 4.4389 | 4.4389 | 4.4128 | 4.4389 | 282800.0 |
| 2009-05-21 17:30:00 | AAPL | Stock | 4.4357 | 4.44 | 4.4357 | 4.4389 | 33600.0 |
| 2009-05-21 18:00:00 | AAPL | Stock | 4.4379 | 4.4379 | 4.4304 | 4.4307 | 580272.0 |
| 2009-05-21 18:30:00 | AAPL | Stock | 4.4325 | 4.4329 | 4.4311 | 4.4311 | 24220.0 |
| 2009-05-21 19:00:00 | AAPL | Stock | 4.4321 | 4.4389 | 4.4321 | 4.4343 | 60200.0 |
| 2009-05-21 19:30:00 | AAPL | Stock | 4.435 | 4.435 | 4.4275 | 4.4275 | 96600.0 |
| 2009-05-21 08:00:00 | MSFT | Stock | 20.36 | 20.4 | 20.3 | 20.4 | 2985.0 |
| 2009-05-21 08:30:00 | MSFT | Stock | 20.3 | 20.3 | 20.25 | 20.25 | 7504.0 |
| 2009-05-21 09:00:00 | MSFT | Stock | 20.26 | 20.26 | 20.1 | 20.14 | 35426.0 |
| 2009-05-21 09:30:00 | MSFT | Stock | 20.14 | 20.23 | 20.01 | 20.03 | 6133750.0 |
| 2009-05-21 10:00:00 | MSFT | Stock | 20.03 | 20.11 | 19.94 | 19.98 | 7064655.0 |
| 2009-05-21 10:30:00 | MSFT | Stock | 19.98 | 19.99 | 19.73 | 19.73 | 3865632.0 |
| 2009-05-21 11:00:00 | MSFT | Stock | 19.73 | 19.75 | 19.67 | 19.7 | 3499288.0 |
| 2009-05-21 11:30:00 | MSFT | Stock | 19.7 | 20.122 | 19.68 | 19.74 | 3177869.0 |
| 2009-05-21 12:00:00 | MSFT | Stock | 19.75 | 19.8 | 19.7 | 19.742 | 3432601.0 |
| 2009-05-21 12:30:00 | MSFT | Stock | 19.75 | 19.76 | 19.69 | 19.73 | 2400013.0 |
| 2009-05-21 13:00:00 | MSFT | Stock | 19.72 | 19.78 | 19.66 | 19.68 | 2229406.0 |
| 2009-05-21 13:30:00 | MSFT | Stock | 19.67 | 19.69 | 19.585 | 19.649 | 3258385.0 |
| 2009-05-21 14:00:00 | MSFT | Stock | 19.65 | 19.7 | 19.55 | 19.557 | 3337860.0 |
| 2009-05-21 14:30:00 | MSFT | Stock | 19.56 | 19.63 | 19.51 | 19.63 | 2745854.0 |
| 2009-05-21 15:00:00 | MSFT | Stock | 19.63 | 19.7 | 19.6 | 19.68 | 2943492.0 |
| 2009-05-21 15:30:00 | MSFT | Stock | 19.67 | 19.88 | 19.67 | 19.84 | 10342313.0 |
| 2009-05-21 16:00:00 | MSFT | Stock | 19.88 | 19.89 | 19.73 | 19.82 | 3481622.0 |
| 2009-05-21 16:30:00 | MSFT | Stock | 19.82 | 19.84 | 19.82 | 19.84 | 109557.0 |
| 2009-05-21 17:00:00 | MSFT | Stock | 19.84 | 19.84 | 19.84 | 19.84 | 900.0 |
| 2009-05-21 17:30:00 | MSFT | Stock | 19.83 | 19.83 | 19.78 | 19.79 | 12770.0 |
| 2009-05-21 18:00:00 | MSFT | Stock | 19.82 | 19.82 | 19.82 | 19.82 | 1400.0 |
| 2009-05-21 18:30:00 | MSFT | Stock | 19.82 | 19.82 | 19.8 | 19.82 | 1610.0 |
| 2009-05-21 19:00:00 | MSFT | Stock | 19.82 | 19.83 | 19.81 | 19.82 | 1973.0 |
> showing 50 of 70,598 rows — these rows as CSV