PREVIEW / stock_30min / 2009-06-09
file: by_date/stock_30min/2009/2009-06-09.parquet size: 1.3 MB rows: 72,007 symbols: 3,357
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-06-09 04:30:00 | AAPL | Stock | 5.1679 | 5.1679 | 5.1679 | 5.1679 | 2800.0 |
| 2009-06-09 06:00:00 | AAPL | Stock | 5.13 | 5.1564 | 5.13 | 5.1564 | 16800.0 |
| 2009-06-09 07:00:00 | AAPL | Stock | 5.1461 | 5.1571 | 5.1461 | 5.1554 | 106400.0 |
| 2009-06-09 07:30:00 | AAPL | Stock | 5.1604 | 5.1654 | 5.1511 | 5.1654 | 394464.0 |
| 2009-06-09 08:00:00 | AAPL | Stock | 5.1654 | 5.1696 | 5.1339 | 5.1379 | 823004.0 |
| 2009-06-09 08:30:00 | AAPL | Stock | 5.14 | 5.1521 | 5.1321 | 5.1521 | 1198792.0 |
| 2009-06-09 09:00:00 | AAPL | Stock | 5.1521 | 5.1607 | 5.1271 | 5.1357 | 2347380.0 |
| 2009-06-09 09:30:00 | AAPL | Stock | 5.1361 | 5.15 | 5.0714 | 5.1443 | 121388316.0 |
| 2009-06-09 10:00:00 | AAPL | Stock | 5.1443 | 5.1629 | 5.0964 | 5.1004 | 80455592.0 |
| 2009-06-09 10:30:00 | AAPL | Stock | 5.1 | 5.1104 | 5.0407 | 5.0593 | 65466772.0 |
| 2009-06-09 11:00:00 | AAPL | Stock | 5.0596 | 5.0696 | 5.0196 | 5.0425 | 59968440.0 |
| 2009-06-09 11:30:00 | AAPL | Stock | 5.0425 | 5.0566 | 5.0268 | 5.0396 | 32955664.0 |
| 2009-06-09 12:00:00 | AAPL | Stock | 5.0393 | 5.0804 | 5.0368 | 5.08 | 33976600.0 |
| 2009-06-09 12:30:00 | AAPL | Stock | 5.08 | 5.0986 | 5.0621 | 5.0957 | 36287664.0 |
| 2009-06-09 13:00:00 | AAPL | Stock | 5.0954 | 5.1093 | 5.0871 | 5.1071 | 33222168.0 |
| 2009-06-09 13:30:00 | AAPL | Stock | 5.1071 | 5.1189 | 5.0982 | 5.117 | 22275372.0 |
| 2009-06-09 14:00:00 | AAPL | Stock | 5.1179 | 5.1246 | 5.1104 | 5.1196 | 24304896.0 |
| 2009-06-09 14:30:00 | AAPL | Stock | 5.1196 | 5.1243 | 5.0993 | 5.1111 | 37487044.0 |
| 2009-06-09 15:00:00 | AAPL | Stock | 5.1114 | 5.1214 | 5.0993 | 5.11 | 40528404.0 |
| 2009-06-09 15:30:00 | AAPL | Stock | 5.1096 | 5.1321 | 5.09 | 5.0929 | 62732992.0 |
| 2009-06-09 16:00:00 | AAPL | Stock | 5.0971 | 5.1389 | 5.0814 | 5.0875 | 11652816.0 |
| 2009-06-09 16:30:00 | AAPL | Stock | 5.0857 | 5.0982 | 5.0536 | 5.0536 | 524552.0 |
| 2009-06-09 17:00:00 | AAPL | Stock | 5.0575 | 5.0679 | 5.0536 | 5.0632 | 283752.0 |
| 2009-06-09 17:30:00 | AAPL | Stock | 5.0639 | 5.0643 | 5.0536 | 5.0536 | 444724.0 |
| 2009-06-09 18:00:00 | AAPL | Stock | 5.0554 | 5.0971 | 5.0393 | 5.0971 | 592312.0 |
| 2009-06-09 18:30:00 | AAPL | Stock | 5.0582 | 5.0895 | 5.0464 | 5.0504 | 184324.0 |
| 2009-06-09 19:00:00 | AAPL | Stock | 5.0554 | 5.0611 | 5.0554 | 5.0571 | 151088.0 |
| 2009-06-09 19:30:00 | AAPL | Stock | 5.0571 | 5.0625 | 5.0536 | 5.0607 | 251916.0 |
| 2009-06-09 07:00:00 | MSFT | Stock | 22.09 | 22.1 | 22.09 | 22.1 | 500.0 |
| 2009-06-09 08:00:00 | MSFT | Stock | 22.14 | 22.15 | 22.12 | 22.12 | 4000.0 |
| 2009-06-09 08:30:00 | MSFT | Stock | 22.09 | 22.12 | 22.08 | 22.1 | 4405.0 |
| 2009-06-09 09:00:00 | MSFT | Stock | 22.1 | 22.17 | 22.05 | 22.06 | 8686.0 |
| 2009-06-09 09:30:00 | MSFT | Stock | 22.06 | 22.32 | 21.88 | 22.2 | 5758644.0 |
| 2009-06-09 10:00:00 | MSFT | Stock | 22.19 | 22.3 | 21.99 | 22.007 | 5256954.0 |
| 2009-06-09 10:30:00 | MSFT | Stock | 22.0 | 22.17 | 21.99 | 22.06 | 2074289.0 |
| 2009-06-09 11:00:00 | MSFT | Stock | 22.06 | 22.09 | 22.0 | 22.09 | 2500467.0 |
| 2009-06-09 11:30:00 | MSFT | Stock | 22.09 | 22.17 | 22.07 | 22.08 | 5641399.0 |
| 2009-06-09 12:00:00 | MSFT | Stock | 22.085 | 22.14 | 22.08 | 22.11 | 2877381.0 |
| 2009-06-09 12:30:00 | MSFT | Stock | 22.102 | 22.11 | 22.06 | 22.11 | 1710938.0 |
| 2009-06-09 13:00:00 | MSFT | Stock | 22.1 | 22.113 | 21.99 | 22.08 | 2766773.0 |
| 2009-06-09 13:30:00 | MSFT | Stock | 22.08 | 22.1 | 22.01 | 22.1 | 1445058.0 |
| 2009-06-09 14:00:00 | MSFT | Stock | 22.1 | 22.14 | 22.07 | 22.12 | 2115476.0 |
| 2009-06-09 14:30:00 | MSFT | Stock | 22.12 | 22.17 | 22.1 | 22.12 | 2122867.0 |
| 2009-06-09 15:00:00 | MSFT | Stock | 22.13 | 22.205 | 22.05 | 22.08 | 2512893.0 |
| 2009-06-09 15:30:00 | MSFT | Stock | 22.08 | 22.16 | 22.04 | 22.11 | 7566390.0 |
| 2009-06-09 16:00:00 | MSFT | Stock | 22.11 | 22.137 | 22.024 | 22.08 | 1694874.0 |
| 2009-06-09 16:30:00 | MSFT | Stock | 22.08 | 22.088 | 22.0 | 22.0 | 8938.0 |
| 2009-06-09 17:00:00 | MSFT | Stock | 22.0 | 22.08 | 22.0 | 22.08 | 1715.0 |
| 2009-06-09 17:30:00 | MSFT | Stock | 22.162 | 22.162 | 22.11 | 22.11 | 81000.0 |
| 2009-06-09 18:00:00 | MSFT | Stock | 22.08 | 22.08 | 22.05 | 22.08 | 32310.0 |
> showing 50 of 72,007 rows — these rows as CSV