PREVIEW / stock_30min / 2010-06-09
file: by_date/stock_30min/2010/2010-06-09.parquet size: 1.3 MB rows: 72,875 symbols: 3,454
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-09 04:00:00 | AAPL | Stock | 9.0036 | 9.0036 | 8.9196 | 8.9196 | 25200.0 |
| 2010-06-09 04:30:00 | AAPL | Stock | 8.8807 | 8.9107 | 8.8807 | 8.9107 | 20020.0 |
| 2010-06-09 05:00:00 | AAPL | Stock | 8.9404 | 8.9404 | 8.9321 | 8.9321 | 9800.0 |
| 2010-06-09 05:30:00 | AAPL | Stock | 8.9321 | 8.9321 | 8.9196 | 8.9304 | 12432.0 |
| 2010-06-09 06:00:00 | AAPL | Stock | 8.9464 | 8.9464 | 8.9464 | 8.9464 | 2800.0 |
| 2010-06-09 06:30:00 | AAPL | Stock | 8.9429 | 8.9429 | 8.9429 | 8.9429 | 2800.0 |
| 2010-06-09 07:00:00 | AAPL | Stock | 8.9461 | 8.9461 | 8.9332 | 8.9332 | 8400.0 |
| 2010-06-09 07:30:00 | AAPL | Stock | 8.9514 | 9.0111 | 8.9514 | 9.0111 | 272580.0 |
| 2010-06-09 08:00:00 | AAPL | Stock | 9.0 | 9.0075 | 8.9504 | 8.9611 | 1950284.0 |
| 2010-06-09 08:30:00 | AAPL | Stock | 8.9618 | 8.9821 | 8.9571 | 8.9814 | 1218168.0 |
| 2010-06-09 09:00:00 | AAPL | Stock | 8.9811 | 8.9893 | 8.9661 | 8.98 | 1873760.0 |
| 2010-06-09 09:30:00 | AAPL | Stock | 8.9807 | 8.9964 | 8.875 | 8.8943 | 107678004.0 |
| 2010-06-09 10:00:00 | AAPL | Stock | 8.8943 | 8.9071 | 8.8 | 8.8421 | 89040336.0 |
| 2010-06-09 10:30:00 | AAPL | Stock | 8.8421 | 8.8839 | 8.8018 | 8.8802 | 59710392.0 |
| 2010-06-09 11:00:00 | AAPL | Stock | 8.8796 | 8.9478 | 8.8793 | 8.9379 | 72032576.0 |
| 2010-06-09 11:30:00 | AAPL | Stock | 8.9371 | 8.9375 | 8.8804 | 8.9046 | 40099948.0 |
| 2010-06-09 12:00:00 | AAPL | Stock | 8.9039 | 8.9789 | 8.8896 | 8.9546 | 38346728.0 |
| 2010-06-09 12:30:00 | AAPL | Stock | 8.955 | 8.9589 | 8.8954 | 8.8957 | 37010568.0 |
| 2010-06-09 13:00:00 | AAPL | Stock | 8.8964 | 8.9121 | 8.8571 | 8.8579 | 36956668.0 |
| 2010-06-09 13:30:00 | AAPL | Stock | 8.8579 | 8.8586 | 8.8082 | 8.8386 | 43766100.0 |
| 2010-06-09 14:00:00 | AAPL | Stock | 8.8414 | 8.8707 | 8.8004 | 8.8507 | 50648528.0 |
| 2010-06-09 14:30:00 | AAPL | Stock | 8.85 | 8.8643 | 8.775 | 8.775 | 53145400.0 |
| 2010-06-09 15:00:00 | AAPL | Stock | 8.7754 | 8.7989 | 8.7061 | 8.7496 | 87664948.0 |
| 2010-06-09 15:30:00 | AAPL | Stock | 8.7514 | 8.7589 | 8.6604 | 8.6861 | 113019928.0 |
| 2010-06-09 16:00:00 | AAPL | Stock | 8.6909 | 8.7189 | 8.6786 | 8.6921 | 9172744.0 |
| 2010-06-09 16:30:00 | AAPL | Stock | 8.6929 | 8.755 | 8.6875 | 8.6929 | 613956.0 |
| 2010-06-09 17:00:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6832 | 8.6832 | 511308.0 |
| 2010-06-09 17:30:00 | AAPL | Stock | 8.6839 | 8.6839 | 8.6696 | 8.6818 | 989940.0 |
| 2010-06-09 18:00:00 | AAPL | Stock | 8.6768 | 8.6857 | 8.6768 | 8.6839 | 402640.0 |
| 2010-06-09 18:30:00 | AAPL | Stock | 8.6871 | 8.6911 | 8.6857 | 8.6882 | 105448.0 |
| 2010-06-09 19:00:00 | AAPL | Stock | 8.6911 | 8.6911 | 8.6839 | 8.6857 | 117376.0 |
| 2010-06-09 19:30:00 | AAPL | Stock | 8.6837 | 8.6854 | 8.6746 | 8.6854 | 283864.0 |
| 2010-06-09 20:00:00 | AAPL | Stock | 8.9096 | 8.9096 | 8.9096 | 8.9096 | 539000.0 |
| 2010-06-09 07:00:00 | MSFT | Stock | 25.14 | 25.14 | 25.14 | 25.14 | 500.0 |
| 2010-06-09 08:00:00 | MSFT | Stock | 25.18 | 25.23 | 25.11 | 25.19 | 38781.0 |
| 2010-06-09 08:30:00 | MSFT | Stock | 25.19 | 25.3 | 25.11 | 25.28 | 564358.0 |
| 2010-06-09 09:00:00 | MSFT | Stock | 25.27 | 25.33 | 25.11 | 25.21 | 325099.0 |
| 2010-06-09 09:30:00 | MSFT | Stock | 25.22 | 25.28 | 25.05 | 25.19 | 8494006.0 |
| 2010-06-09 10:00:00 | MSFT | Stock | 25.19 | 25.29 | 25.11 | 25.29 | 8441517.0 |
| 2010-06-09 10:30:00 | MSFT | Stock | 25.29 | 25.35 | 25.11 | 25.31 | 5795643.0 |
| 2010-06-09 11:00:00 | MSFT | Stock | 25.31 | 25.52 | 25.11 | 25.48 | 6981795.0 |
| 2010-06-09 11:30:00 | MSFT | Stock | 25.48 | 25.48 | 25.342 | 25.358 | 3571396.0 |
| 2010-06-09 12:00:00 | MSFT | Stock | 25.35 | 25.41 | 25.32 | 25.37 | 2177811.0 |
| 2010-06-09 12:30:00 | MSFT | Stock | 25.37 | 25.4 | 25.11 | 25.34 | 3208328.0 |
| 2010-06-09 13:00:00 | MSFT | Stock | 25.343 | 25.39 | 25.31 | 25.33 | 2950475.0 |
| 2010-06-09 13:30:00 | MSFT | Stock | 25.325 | 25.35 | 25.25 | 25.29 | 3049639.0 |
| 2010-06-09 14:00:00 | MSFT | Stock | 25.3 | 25.3 | 25.19 | 25.26 | 4588359.0 |
| 2010-06-09 14:30:00 | MSFT | Stock | 25.26 | 25.27 | 24.97 | 25.0 | 5036157.0 |
| 2010-06-09 15:00:00 | MSFT | Stock | 24.99 | 25.05 | 24.76 | 24.942 | 7177828.0 |
| 2010-06-09 15:30:00 | MSFT | Stock | 24.95 | 24.95 | 24.75 | 24.78 | 9105612.0 |
> showing 50 of 72,875 rows — these rows as CSV