PREVIEW / stock_30min / 2009-12-28
file: by_date/stock_30min/2009/2009-12-28.parquet size: 1.3 MB rows: 73,050 symbols: 3,445
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-12-28 05:00:00 | AAPL | Stock | 7.4771 | 7.4771 | 7.4771 | 7.4771 | 7000.0 |
| 2009-12-28 07:00:00 | AAPL | Stock | 7.4996 | 7.5332 | 7.4996 | 7.5071 | 203868.0 |
| 2009-12-28 07:30:00 | AAPL | Stock | 7.5107 | 7.5107 | 7.4921 | 7.4929 | 294560.0 |
| 2009-12-28 08:00:00 | AAPL | Stock | 7.4946 | 7.5618 | 7.4821 | 7.5454 | 4339160.0 |
| 2009-12-28 08:30:00 | AAPL | Stock | 7.5446 | 7.5779 | 7.5411 | 7.5714 | 3754520.0 |
| 2009-12-28 09:00:00 | AAPL | Stock | 7.5714 | 7.5839 | 7.5511 | 7.5589 | 5648552.0 |
| 2009-12-28 09:30:00 | AAPL | Stock | 7.5614 | 7.6411 | 7.5393 | 7.6004 | 125723584.0 |
| 2009-12-28 10:00:00 | AAPL | Stock | 7.6 | 7.6232 | 7.5875 | 7.6086 | 62208300.0 |
| 2009-12-28 10:30:00 | AAPL | Stock | 7.6093 | 7.6161 | 7.5929 | 7.6139 | 28395780.0 |
| 2009-12-28 11:00:00 | AAPL | Stock | 7.6139 | 7.625 | 7.5982 | 7.6061 | 36629292.0 |
| 2009-12-28 11:30:00 | AAPL | Stock | 7.6061 | 7.6143 | 7.6011 | 7.6029 | 20222580.0 |
| 2009-12-28 12:00:00 | AAPL | Stock | 7.6029 | 7.6029 | 7.5618 | 7.5744 | 48935740.0 |
| 2009-12-28 12:30:00 | AAPL | Stock | 7.5745 | 7.5768 | 7.5614 | 7.575 | 22396920.0 |
| 2009-12-28 13:00:00 | AAPL | Stock | 7.575 | 7.6029 | 7.575 | 7.6007 | 20798484.0 |
| 2009-12-28 13:30:00 | AAPL | Stock | 7.6004 | 7.6068 | 7.5796 | 7.5832 | 20481804.0 |
| 2009-12-28 14:00:00 | AAPL | Stock | 7.5831 | 7.5882 | 7.4861 | 7.5082 | 64580712.0 |
| 2009-12-28 14:30:00 | AAPL | Stock | 7.5082 | 7.5446 | 7.4932 | 7.5376 | 59213588.0 |
| 2009-12-28 15:00:00 | AAPL | Stock | 7.5379 | 7.5554 | 7.52 | 7.5321 | 37766064.0 |
| 2009-12-28 15:30:00 | AAPL | Stock | 7.5314 | 7.5654 | 7.5193 | 7.5564 | 59219832.0 |
| 2009-12-28 16:00:00 | AAPL | Stock | 7.5561 | 7.575 | 7.5435 | 7.5532 | 6857676.0 |
| 2009-12-28 16:30:00 | AAPL | Stock | 7.5445 | 7.5575 | 7.5445 | 7.5575 | 1180928.0 |
| 2009-12-28 17:00:00 | AAPL | Stock | 7.5482 | 7.5575 | 7.5482 | 7.5575 | 130144.0 |
| 2009-12-28 17:30:00 | AAPL | Stock | 7.5546 | 7.555 | 7.54 | 7.5464 | 485380.0 |
| 2009-12-28 18:00:00 | AAPL | Stock | 7.5464 | 7.5575 | 7.5464 | 7.5529 | 547512.0 |
| 2009-12-28 18:30:00 | AAPL | Stock | 7.55 | 7.5529 | 7.5482 | 7.5518 | 105000.0 |
| 2009-12-28 19:00:00 | AAPL | Stock | 7.5518 | 7.5518 | 7.5464 | 7.5464 | 124600.0 |
| 2009-12-28 19:30:00 | AAPL | Stock | 7.5468 | 7.55 | 7.5464 | 7.5496 | 122696.0 |
| 2009-12-28 20:00:00 | AAPL | Stock | 7.6086 | 7.6086 | 7.6086 | 7.6086 | 14000.0 |
| 2009-12-28 08:00:00 | MSFT | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 800.0 |
| 2009-12-28 08:30:00 | MSFT | Stock | 31.06 | 31.06 | 31.0 | 31.05 | 2179.0 |
| 2009-12-28 09:00:00 | MSFT | Stock | 31.04 | 31.04 | 30.98 | 31.0 | 25540.0 |
| 2009-12-28 09:30:00 | MSFT | Stock | 31.0 | 31.0 | 30.98 | 30.99 | 2767381.0 |
| 2009-12-28 10:00:00 | MSFT | Stock | 30.99 | 31.0 | 30.97 | 30.99 | 1610831.0 |
| 2009-12-28 10:30:00 | MSFT | Stock | 30.99 | 31.0 | 30.98 | 30.995 | 989789.0 |
| 2009-12-28 11:00:00 | MSFT | Stock | 31.0 | 31.0 | 30.98 | 30.995 | 1020597.0 |
| 2009-12-28 11:30:00 | MSFT | Stock | 30.995 | 31.0 | 30.99 | 31.0 | 664281.0 |
| 2009-12-28 12:00:00 | MSFT | Stock | 30.99 | 31.0 | 30.99 | 31.0 | 979007.0 |
| 2009-12-28 12:30:00 | MSFT | Stock | 30.99 | 31.0 | 30.99 | 30.99 | 647549.0 |
| 2009-12-28 13:00:00 | MSFT | Stock | 31.0 | 31.0 | 30.99 | 30.995 | 789612.0 |
| 2009-12-28 13:30:00 | MSFT | Stock | 30.992 | 31.0 | 30.99 | 31.0 | 994547.0 |
| 2009-12-28 14:00:00 | MSFT | Stock | 30.992 | 31.02 | 30.89 | 30.935 | 5471214.0 |
| 2009-12-28 14:30:00 | MSFT | Stock | 30.94 | 30.98 | 30.91 | 30.97 | 1353824.0 |
| 2009-12-28 15:00:00 | MSFT | Stock | 30.97 | 31.02 | 30.96 | 31.0 | 1398116.0 |
| 2009-12-28 15:30:00 | MSFT | Stock | 31.0 | 31.18 | 31.0 | 31.17 | 4382841.0 |
| 2009-12-28 16:00:00 | MSFT | Stock | 31.16 | 31.18 | 31.007 | 31.15 | 1348443.0 |
| 2009-12-28 16:30:00 | MSFT | Stock | 31.093 | 31.16 | 30.943 | 31.16 | 224080.0 |
| 2009-12-28 17:00:00 | MSFT | Stock | 31.16 | 31.17 | 31.15 | 31.15 | 18816.0 |
| 2009-12-28 17:30:00 | MSFT | Stock | 31.15 | 31.15 | 31.13 | 31.15 | 1415.0 |
| 2009-12-28 18:00:00 | MSFT | Stock | 31.11 | 31.11 | 31.11 | 31.11 | 1000.0 |
| 2009-12-28 18:30:00 | MSFT | Stock | 31.11 | 31.11 | 31.11 | 31.11 | 200.0 |
> showing 50 of 73,050 rows — these rows as CSV