PREVIEW / stock_30min / 2010-08-30
file: by_date/stock_30min/2010/2010-08-30.parquet size: 1.3 MB rows: 73,281 symbols: 3,459
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-08-30 06:30:00 | AAPL | Stock | 8.65 | 8.65 | 8.65 | 8.65 | 14000.0 |
| 2010-08-30 07:00:00 | AAPL | Stock | 8.6375 | 8.6407 | 8.6254 | 8.6254 | 69832.0 |
| 2010-08-30 07:30:00 | AAPL | Stock | 8.6357 | 8.6489 | 8.6332 | 8.6393 | 84000.0 |
| 2010-08-30 08:00:00 | AAPL | Stock | 8.6329 | 8.6389 | 8.615 | 8.625 | 620116.0 |
| 2010-08-30 08:30:00 | AAPL | Stock | 8.6246 | 8.6396 | 8.6107 | 8.6225 | 1010772.0 |
| 2010-08-30 09:00:00 | AAPL | Stock | 8.6225 | 8.6257 | 8.5914 | 8.5989 | 542024.0 |
| 2010-08-30 09:30:00 | AAPL | Stock | 8.5986 | 8.7718 | 8.5957 | 8.7625 | 81097716.0 |
| 2010-08-30 10:00:00 | AAPL | Stock | 8.7625 | 8.7768 | 8.7286 | 8.7464 | 41843424.0 |
| 2010-08-30 10:30:00 | AAPL | Stock | 8.7456 | 8.7671 | 8.7279 | 8.7582 | 25690168.0 |
| 2010-08-30 11:00:00 | AAPL | Stock | 8.7581 | 8.7607 | 8.7286 | 8.7422 | 16610692.0 |
| 2010-08-30 11:30:00 | AAPL | Stock | 8.7429 | 8.7446 | 8.6975 | 8.7071 | 24953824.0 |
| 2010-08-30 12:00:00 | AAPL | Stock | 8.7061 | 8.7286 | 8.7061 | 8.7239 | 13108872.0 |
| 2010-08-30 12:30:00 | AAPL | Stock | 8.7246 | 8.7446 | 8.7189 | 8.735 | 16753044.0 |
| 2010-08-30 13:00:00 | AAPL | Stock | 8.7343 | 8.7429 | 8.7093 | 8.7179 | 19999700.0 |
| 2010-08-30 13:30:00 | AAPL | Stock | 8.7196 | 8.7307 | 8.7086 | 8.7121 | 12192600.0 |
| 2010-08-30 14:00:00 | AAPL | Stock | 8.7121 | 8.7243 | 8.7007 | 8.7187 | 15248576.0 |
| 2010-08-30 14:30:00 | AAPL | Stock | 8.7189 | 8.7357 | 8.7111 | 8.7214 | 16980292.0 |
| 2010-08-30 15:00:00 | AAPL | Stock | 8.7213 | 8.73 | 8.6868 | 8.6984 | 29093904.0 |
| 2010-08-30 15:30:00 | AAPL | Stock | 8.7004 | 8.7009 | 8.6561 | 8.6611 | 46326560.0 |
| 2010-08-30 16:00:00 | AAPL | Stock | 8.6607 | 8.719 | 8.6102 | 8.6639 | 14882840.0 |
| 2010-08-30 16:30:00 | AAPL | Stock | 8.6643 | 8.6962 | 8.6582 | 8.6671 | 1750196.0 |
| 2010-08-30 17:00:00 | AAPL | Stock | 8.6643 | 8.7159 | 8.6643 | 8.6679 | 125832.0 |
| 2010-08-30 17:30:00 | AAPL | Stock | 8.6607 | 8.6714 | 8.6607 | 8.6711 | 550060.0 |
| 2010-08-30 18:00:00 | AAPL | Stock | 8.6661 | 8.675 | 8.6654 | 8.675 | 48692.0 |
| 2010-08-30 18:30:00 | AAPL | Stock | 8.6761 | 8.6839 | 8.6696 | 8.6786 | 121996.0 |
| 2010-08-30 19:00:00 | AAPL | Stock | 8.6732 | 8.6732 | 8.6286 | 8.6607 | 228704.0 |
| 2010-08-30 19:30:00 | AAPL | Stock | 8.6732 | 8.675 | 8.67 | 8.675 | 112700.0 |
| 2010-08-30 07:00:00 | MSFT | Stock | 23.93 | 23.93 | 23.93 | 23.93 | 200.0 |
| 2010-08-30 08:00:00 | MSFT | Stock | 23.9 | 23.94 | 23.79 | 23.89 | 5891.0 |
| 2010-08-30 08:30:00 | MSFT | Stock | 23.88 | 23.93 | 23.78 | 23.86 | 42437.0 |
| 2010-08-30 09:00:00 | MSFT | Stock | 23.84 | 23.89 | 23.72 | 23.74 | 57456.0 |
| 2010-08-30 09:30:00 | MSFT | Stock | 23.74 | 23.8 | 23.65 | 23.73 | 4059274.0 |
| 2010-08-30 10:00:00 | MSFT | Stock | 23.73 | 23.82 | 23.69 | 23.72 | 3835081.0 |
| 2010-08-30 10:30:00 | MSFT | Stock | 23.71 | 23.78 | 23.69 | 23.76 | 2378075.0 |
| 2010-08-30 11:00:00 | MSFT | Stock | 23.76 | 23.79 | 23.71 | 23.738 | 1683543.0 |
| 2010-08-30 11:30:00 | MSFT | Stock | 23.74 | 23.74 | 23.665 | 23.7 | 3691849.0 |
| 2010-08-30 12:00:00 | MSFT | Stock | 23.7 | 23.75 | 23.69 | 23.702 | 1410973.0 |
| 2010-08-30 12:30:00 | MSFT | Stock | 23.708 | 23.77 | 23.7 | 23.72 | 1851211.0 |
| 2010-08-30 13:00:00 | MSFT | Stock | 23.725 | 23.76 | 23.68 | 23.698 | 2076067.0 |
| 2010-08-30 13:30:00 | MSFT | Stock | 23.695 | 23.77 | 23.69 | 23.72 | 1736202.0 |
| 2010-08-30 14:00:00 | MSFT | Stock | 23.72 | 23.77 | 23.69 | 23.77 | 2462915.0 |
| 2010-08-30 14:30:00 | MSFT | Stock | 23.76 | 23.8 | 23.73 | 23.749 | 2093778.0 |
| 2010-08-30 15:00:00 | MSFT | Stock | 23.75 | 23.77 | 23.68 | 23.7 | 3810982.0 |
| 2010-08-30 15:30:00 | MSFT | Stock | 23.695 | 23.74 | 23.6 | 23.64 | 7562189.0 |
| 2010-08-30 16:00:00 | MSFT | Stock | 23.64 | 23.755 | 23.63 | 23.64 | 5060752.0 |
| 2010-08-30 16:30:00 | MSFT | Stock | 23.64 | 23.71 | 23.62 | 23.62 | 470940.0 |
| 2010-08-30 17:00:00 | MSFT | Stock | 23.706 | 23.706 | 23.64 | 23.64 | 2856.0 |
| 2010-08-30 17:30:00 | MSFT | Stock | 23.64 | 23.64 | 23.63 | 23.63 | 44793.0 |
| 2010-08-30 18:30:00 | MSFT | Stock | 23.64 | 23.66 | 23.63 | 23.65 | 7148.0 |
| 2010-08-30 19:00:00 | MSFT | Stock | 23.64 | 23.65 | 23.64 | 23.65 | 36049.0 |
> showing 50 of 73,281 rows — these rows as CSV