PREVIEW / stock_30min / 2010-12-13
file: by_date/stock_30min/2010/2010-12-13.parquet size: 1.4 MB rows: 77,355 symbols: 3,542
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-12-13 04:00:00 | AAPL | Stock | 11.4939 | 11.55 | 11.4846 | 11.55 | 164304.0 |
| 2010-12-13 04:30:00 | AAPL | Stock | 11.5639 | 11.5639 | 11.5246 | 11.5357 | 110460.0 |
| 2010-12-13 05:00:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-13 05:30:00 | AAPL | Stock | 11.5536 | 11.5689 | 11.5464 | 11.5689 | 98504.0 |
| 2010-12-13 06:00:00 | AAPL | Stock | 11.5593 | 11.5643 | 11.5575 | 11.5643 | 11200.0 |
| 2010-12-13 06:30:00 | AAPL | Stock | 11.5643 | 11.5893 | 11.5643 | 11.5846 | 143920.0 |
| 2010-12-13 07:00:00 | AAPL | Stock | 11.5957 | 11.5968 | 11.5529 | 11.5764 | 664692.0 |
| 2010-12-13 07:30:00 | AAPL | Stock | 11.58 | 11.5839 | 11.5514 | 11.5829 | 1052408.0 |
| 2010-12-13 08:00:00 | AAPL | Stock | 11.5793 | 11.58 | 11.5368 | 11.56 | 4267536.0 |
| 2010-12-13 08:30:00 | AAPL | Stock | 11.5582 | 11.5968 | 11.5582 | 11.5946 | 5085388.0 |
| 2010-12-13 09:00:00 | AAPL | Stock | 11.5939 | 11.6364 | 11.5929 | 11.5939 | 7329336.0 |
| 2010-12-13 09:30:00 | AAPL | Stock | 11.5964 | 11.6093 | 11.5468 | 11.5511 | 108083752.0 |
| 2010-12-13 10:00:00 | AAPL | Stock | 11.5514 | 11.5839 | 11.5511 | 11.5711 | 31272724.0 |
| 2010-12-13 10:30:00 | AAPL | Stock | 11.5696 | 11.6018 | 11.5661 | 11.5986 | 29700608.0 |
| 2010-12-13 11:00:00 | AAPL | Stock | 11.5986 | 11.6068 | 11.5871 | 11.5886 | 29678824.0 |
| 2010-12-13 11:30:00 | AAPL | Stock | 11.5893 | 11.5986 | 11.5825 | 11.5893 | 15897980.0 |
| 2010-12-13 12:00:00 | AAPL | Stock | 11.5893 | 11.5943 | 11.5786 | 11.5851 | 12180476.0 |
| 2010-12-13 12:30:00 | AAPL | Stock | 11.5868 | 11.6014 | 11.5821 | 11.5982 | 12468764.0 |
| 2010-12-13 13:00:00 | AAPL | Stock | 11.5971 | 11.5994 | 11.5821 | 11.5832 | 9925440.0 |
| 2010-12-13 13:30:00 | AAPL | Stock | 11.5825 | 11.5907 | 11.5721 | 11.5793 | 13539064.0 |
| 2010-12-13 14:00:00 | AAPL | Stock | 11.5784 | 11.595 | 11.5779 | 11.5807 | 10855096.0 |
| 2010-12-13 14:30:00 | AAPL | Stock | 11.5814 | 11.5929 | 11.5761 | 11.5789 | 21304556.0 |
| 2010-12-13 15:00:00 | AAPL | Stock | 11.5793 | 11.5814 | 11.5396 | 11.5486 | 36342936.0 |
| 2010-12-13 15:30:00 | AAPL | Stock | 11.5476 | 11.5504 | 11.4643 | 11.4857 | 66754604.0 |
| 2010-12-13 16:00:00 | AAPL | Stock | 11.4857 | 11.5689 | 11.4482 | 11.5093 | 10579268.0 |
| 2010-12-13 16:30:00 | AAPL | Stock | 11.5093 | 11.5529 | 11.5007 | 11.5079 | 679756.0 |
| 2010-12-13 17:00:00 | AAPL | Stock | 11.5093 | 11.52 | 11.5064 | 11.5179 | 583296.0 |
| 2010-12-13 17:30:00 | AAPL | Stock | 11.5179 | 11.5214 | 11.5179 | 11.52 | 172592.0 |
| 2010-12-13 18:00:00 | AAPL | Stock | 11.5214 | 11.5229 | 11.4882 | 11.5114 | 273672.0 |
| 2010-12-13 18:30:00 | AAPL | Stock | 11.5111 | 11.5136 | 11.505 | 11.5054 | 94752.0 |
| 2010-12-13 19:00:00 | AAPL | Stock | 11.5036 | 11.5089 | 11.5036 | 11.5046 | 162932.0 |
| 2010-12-13 19:30:00 | AAPL | Stock | 11.5075 | 11.5079 | 11.4982 | 11.5054 | 417060.0 |
| 2010-12-13 07:00:00 | MSFT | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 400.0 |
| 2010-12-13 07:30:00 | MSFT | Stock | 27.38 | 27.38 | 27.38 | 27.38 | 1014.0 |
| 2010-12-13 08:00:00 | MSFT | Stock | 27.38 | 27.39 | 27.36 | 27.36 | 4601.0 |
| 2010-12-13 08:30:00 | MSFT | Stock | 27.39 | 27.4 | 27.38 | 27.39 | 21379.0 |
| 2010-12-13 09:00:00 | MSFT | Stock | 27.39 | 27.4 | 27.25 | 27.27 | 122210.0 |
| 2010-12-13 09:30:00 | MSFT | Stock | 27.27 | 27.35 | 27.172 | 27.21 | 7404319.0 |
| 2010-12-13 10:00:00 | MSFT | Stock | 27.215 | 27.27 | 27.21 | 27.242 | 3309434.0 |
| 2010-12-13 10:30:00 | MSFT | Stock | 27.25 | 27.3 | 27.2 | 27.293 | 3062683.0 |
| 2010-12-13 11:00:00 | MSFT | Stock | 27.296 | 27.3 | 27.26 | 27.29 | 3278122.0 |
| 2010-12-13 11:30:00 | MSFT | Stock | 27.29 | 27.33 | 27.27 | 27.314 | 2551731.0 |
| 2010-12-13 12:00:00 | MSFT | Stock | 27.31 | 27.35 | 27.28 | 27.35 | 2036395.0 |
| 2010-12-13 12:30:00 | MSFT | Stock | 27.35 | 27.39 | 27.32 | 27.368 | 2004791.0 |
| 2010-12-13 13:00:00 | MSFT | Stock | 27.365 | 27.39 | 27.35 | 27.357 | 1466833.0 |
| 2010-12-13 13:30:00 | MSFT | Stock | 27.352 | 27.4 | 27.35 | 27.395 | 2004250.0 |
| 2010-12-13 14:00:00 | MSFT | Stock | 27.4 | 27.44 | 27.39 | 27.42 | 2578633.0 |
| 2010-12-13 14:30:00 | MSFT | Stock | 27.42 | 27.44 | 27.41 | 27.42 | 1882011.0 |
| 2010-12-13 15:00:00 | MSFT | Stock | 27.428 | 27.45 | 27.4 | 27.41 | 3727954.0 |
| 2010-12-13 15:30:00 | MSFT | Stock | 27.415 | 27.42 | 27.23 | 27.23 | 6831868.0 |
> showing 50 of 77,355 rows — these rows as CSV