PREVIEW / stock_30min / 2010-06-08
file: by_date/stock_30min/2010/2010-06-08.parquet size: 1.3 MB rows: 72,880 symbols: 3,466
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-06-08 04:00:00 | AAPL | Stock | 9.0696 | 9.0696 | 9.0696 | 9.0696 | 2800.0 |
| 2010-06-08 05:00:00 | AAPL | Stock | 9.0018 | 9.0018 | 9.0018 | 9.0018 | 11340.0 |
| 2010-06-08 05:30:00 | AAPL | Stock | 9.0229 | 9.0229 | 9.0229 | 9.0229 | 14000.0 |
| 2010-06-08 06:30:00 | AAPL | Stock | 9.0036 | 9.0036 | 9.0036 | 9.0036 | 13720.0 |
| 2010-06-08 07:00:00 | AAPL | Stock | 9.0089 | 9.0354 | 9.0086 | 9.025 | 133896.0 |
| 2010-06-08 07:30:00 | AAPL | Stock | 9.0236 | 9.0329 | 9.0 | 9.0 | 286384.0 |
| 2010-06-08 08:00:00 | AAPL | Stock | 9.0086 | 9.0939 | 8.9982 | 9.0696 | 4062156.0 |
| 2010-06-08 08:30:00 | AAPL | Stock | 9.07 | 9.0789 | 9.0386 | 9.0432 | 2214744.0 |
| 2010-06-08 09:00:00 | AAPL | Stock | 9.0432 | 9.0554 | 9.0282 | 9.0429 | 2171904.0 |
| 2010-06-08 09:30:00 | AAPL | Stock | 9.0439 | 9.0643 | 8.9293 | 8.9588 | 117603304.0 |
| 2010-06-08 10:00:00 | AAPL | Stock | 8.9604 | 9.0143 | 8.8514 | 8.9105 | 105408296.0 |
| 2010-06-08 10:30:00 | AAPL | Stock | 8.9107 | 8.9386 | 8.8543 | 8.9137 | 69144852.0 |
| 2010-06-08 11:00:00 | AAPL | Stock | 8.915 | 8.9946 | 8.8571 | 8.9686 | 73381504.0 |
| 2010-06-08 11:30:00 | AAPL | Stock | 8.9686 | 9.0429 | 8.9614 | 8.9959 | 72162412.0 |
| 2010-06-08 12:00:00 | AAPL | Stock | 8.9968 | 9.0179 | 8.935 | 8.9418 | 40836824.0 |
| 2010-06-08 12:30:00 | AAPL | Stock | 8.9404 | 8.9732 | 8.8929 | 8.9243 | 45146668.0 |
| 2010-06-08 13:00:00 | AAPL | Stock | 8.9243 | 8.9389 | 8.8611 | 8.8659 | 45149244.0 |
| 2010-06-08 13:30:00 | AAPL | Stock | 8.8661 | 8.8725 | 8.825 | 8.8561 | 62846308.0 |
| 2010-06-08 14:00:00 | AAPL | Stock | 8.8575 | 8.8986 | 8.7996 | 8.8768 | 68866336.0 |
| 2010-06-08 14:30:00 | AAPL | Stock | 8.8761 | 8.925 | 8.8179 | 8.8343 | 71567272.0 |
| 2010-06-08 15:00:00 | AAPL | Stock | 8.8336 | 8.8621 | 8.7732 | 8.8453 | 84280280.0 |
| 2010-06-08 15:30:00 | AAPL | Stock | 8.8457 | 8.9096 | 8.8304 | 8.9064 | 117931380.0 |
| 2010-06-08 16:00:00 | AAPL | Stock | 8.9057 | 8.966 | 8.8564 | 8.8986 | 11532892.0 |
| 2010-06-08 16:30:00 | AAPL | Stock | 8.8989 | 8.9487 | 8.8968 | 8.9036 | 446572.0 |
| 2010-06-08 17:00:00 | AAPL | Stock | 8.9036 | 8.9271 | 8.9036 | 8.9179 | 459032.0 |
| 2010-06-08 17:30:00 | AAPL | Stock | 8.9204 | 8.9221 | 8.9075 | 8.9221 | 187600.0 |
| 2010-06-08 18:00:00 | AAPL | Stock | 8.9179 | 8.9193 | 8.9046 | 8.9143 | 183456.0 |
| 2010-06-08 18:30:00 | AAPL | Stock | 8.9175 | 8.9286 | 8.9175 | 8.925 | 172144.0 |
| 2010-06-08 19:00:00 | AAPL | Stock | 8.9196 | 8.9382 | 8.9196 | 8.9382 | 217336.0 |
| 2010-06-08 19:30:00 | AAPL | Stock | 8.9411 | 8.9411 | 8.9286 | 8.9286 | 135268.0 |
| 2010-06-08 20:00:00 | AAPL | Stock | 8.97 | 8.97 | 8.97 | 8.97 | 193200.0 |
| 2010-06-08 07:30:00 | MSFT | Stock | 25.43 | 25.43 | 25.43 | 25.43 | 100.0 |
| 2010-06-08 08:00:00 | MSFT | Stock | 25.4 | 25.42 | 25.08 | 25.35 | 41730.0 |
| 2010-06-08 08:30:00 | MSFT | Stock | 25.35 | 25.42 | 25.24 | 25.35 | 65028.0 |
| 2010-06-08 09:00:00 | MSFT | Stock | 25.38 | 25.42 | 25.24 | 25.25 | 49794.0 |
| 2010-06-08 09:30:00 | MSFT | Stock | 25.25 | 25.26 | 24.98 | 25.01 | 8407591.0 |
| 2010-06-08 10:00:00 | MSFT | Stock | 25.02 | 25.08 | 24.76 | 24.9 | 9807221.0 |
| 2010-06-08 10:30:00 | MSFT | Stock | 24.9 | 25.1 | 24.65 | 24.82 | 7943884.0 |
| 2010-06-08 11:00:00 | MSFT | Stock | 24.82 | 25.03 | 24.75 | 24.89 | 7589283.0 |
| 2010-06-08 11:30:00 | MSFT | Stock | 24.9 | 25.02 | 24.836 | 24.94 | 6906301.0 |
| 2010-06-08 12:00:00 | MSFT | Stock | 24.94 | 24.97 | 24.75 | 24.835 | 5655114.0 |
| 2010-06-08 12:30:00 | MSFT | Stock | 24.83 | 24.9 | 24.82 | 24.86 | 2810364.0 |
| 2010-06-08 13:00:00 | MSFT | Stock | 24.86 | 24.89 | 24.73 | 24.8 | 3400413.0 |
| 2010-06-08 13:30:00 | MSFT | Stock | 24.79 | 24.84 | 24.69 | 24.81 | 4987194.0 |
| 2010-06-08 14:00:00 | MSFT | Stock | 24.81 | 25.0 | 24.8 | 24.925 | 4581924.0 |
| 2010-06-08 14:30:00 | MSFT | Stock | 24.93 | 25.03 | 24.87 | 24.89 | 4843630.0 |
| 2010-06-08 15:00:00 | MSFT | Stock | 24.9 | 25.038 | 24.86 | 25.02 | 5262768.0 |
| 2010-06-08 15:30:00 | MSFT | Stock | 25.02 | 25.16 | 24.98 | 25.11 | 11074648.0 |
| 2010-06-08 16:00:00 | MSFT | Stock | 25.12 | 25.293 | 24.798 | 25.08 | 2542945.0 |
| 2010-06-08 16:30:00 | MSFT | Stock | 25.07 | 25.11 | 24.8 | 25.08 | 119865.0 |
> showing 50 of 72,880 rows — these rows as CSV