PREVIEW / stock_30min / 2009-06-18
file: by_date/stock_30min/2009/2009-06-18.parquet size: 1.3 MB rows: 69,726 symbols: 3,341
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-18 07:00:00 | AAPL | Stock | 4.8454 | 4.8454 | 4.8454 | 4.8454 | 8400.0 |
| 2009-06-18 07:30:00 | AAPL | Stock | 4.8404 | 4.8404 | 4.8368 | 4.8389 | 44800.0 |
| 2009-06-18 08:00:00 | AAPL | Stock | 4.8393 | 4.8393 | 4.8296 | 4.8368 | 108976.0 |
| 2009-06-18 08:30:00 | AAPL | Stock | 4.8375 | 4.8661 | 4.8375 | 4.8661 | 522200.0 |
| 2009-06-18 09:00:00 | AAPL | Stock | 4.8639 | 4.8729 | 4.8564 | 4.8596 | 1075536.0 |
| 2009-06-18 09:30:00 | AAPL | Stock | 4.8593 | 4.9286 | 4.8425 | 4.9211 | 96443620.0 |
| 2009-06-18 10:00:00 | AAPL | Stock | 4.9211 | 4.9275 | 4.8971 | 4.8971 | 39242952.0 |
| 2009-06-18 10:30:00 | AAPL | Stock | 4.8975 | 4.9086 | 4.8829 | 4.9047 | 30717064.0 |
| 2009-06-18 11:00:00 | AAPL | Stock | 4.9061 | 4.9132 | 4.8993 | 4.9061 | 18567108.0 |
| 2009-06-18 11:30:00 | AAPL | Stock | 4.9054 | 4.9068 | 4.8868 | 4.9004 | 18339076.0 |
| 2009-06-18 12:00:00 | AAPL | Stock | 4.9004 | 4.9096 | 4.8911 | 4.8939 | 13813268.0 |
| 2009-06-18 12:30:00 | AAPL | Stock | 4.8936 | 4.9114 | 4.8886 | 4.9107 | 16894136.0 |
| 2009-06-18 13:00:00 | AAPL | Stock | 4.9114 | 4.9254 | 4.9096 | 4.9179 | 18113004.0 |
| 2009-06-18 13:30:00 | AAPL | Stock | 4.9175 | 4.9239 | 4.9054 | 4.9104 | 20875764.0 |
| 2009-06-18 14:00:00 | AAPL | Stock | 4.9107 | 4.9136 | 4.8979 | 4.9061 | 17575880.0 |
| 2009-06-18 14:30:00 | AAPL | Stock | 4.9064 | 4.9071 | 4.8936 | 4.9025 | 18459224.0 |
| 2009-06-18 15:00:00 | AAPL | Stock | 4.9025 | 4.905 | 4.8714 | 4.8777 | 27475336.0 |
| 2009-06-18 15:30:00 | AAPL | Stock | 4.8779 | 4.8854 | 4.8539 | 4.8539 | 53291308.0 |
| 2009-06-18 16:00:00 | AAPL | Stock | 4.8554 | 4.9111 | 4.8286 | 4.8461 | 30891112.0 |
| 2009-06-18 16:30:00 | AAPL | Stock | 4.8482 | 4.8536 | 4.8393 | 4.85 | 615328.0 |
| 2009-06-18 17:00:00 | AAPL | Stock | 4.8496 | 4.8721 | 4.8393 | 4.8721 | 1193528.0 |
| 2009-06-18 17:30:00 | AAPL | Stock | 4.8721 | 4.8907 | 4.8696 | 4.8821 | 951300.0 |
| 2009-06-18 18:00:00 | AAPL | Stock | 4.8839 | 4.8907 | 4.8529 | 4.8832 | 695688.0 |
| 2009-06-18 18:30:00 | AAPL | Stock | 4.8857 | 4.8907 | 4.8846 | 4.8886 | 524524.0 |
| 2009-06-18 19:00:00 | AAPL | Stock | 4.8886 | 4.8911 | 4.8861 | 4.8875 | 114520.0 |
| 2009-06-18 19:30:00 | AAPL | Stock | 4.8914 | 4.8946 | 4.8896 | 4.8929 | 219660.0 |
| 2009-06-18 07:30:00 | MSFT | Stock | 23.71 | 23.73 | 23.55 | 23.73 | 650.0 |
| 2009-06-18 08:00:00 | MSFT | Stock | 23.68 | 23.7 | 23.61 | 23.62 | 5262.0 |
| 2009-06-18 08:30:00 | MSFT | Stock | 23.7 | 23.7 | 23.6 | 23.67 | 13077.0 |
| 2009-06-18 09:00:00 | MSFT | Stock | 23.59 | 23.68 | 23.56 | 23.61 | 20595.0 |
| 2009-06-18 09:30:00 | MSFT | Stock | 23.62 | 23.65 | 23.34 | 23.42 | 6663973.0 |
| 2009-06-18 10:00:00 | MSFT | Stock | 23.42 | 23.69 | 23.41 | 23.488 | 8010139.0 |
| 2009-06-18 10:30:00 | MSFT | Stock | 23.485 | 23.51 | 23.34 | 23.38 | 5868973.0 |
| 2009-06-18 11:00:00 | MSFT | Stock | 23.39 | 23.43 | 23.34 | 23.35 | 4270162.0 |
| 2009-06-18 11:30:00 | MSFT | Stock | 23.35 | 23.37 | 23.3 | 23.35 | 3084720.0 |
| 2009-06-18 12:00:00 | MSFT | Stock | 23.35 | 23.43 | 23.33 | 23.42 | 2137319.0 |
| 2009-06-18 12:30:00 | MSFT | Stock | 23.43 | 23.55 | 23.415 | 23.54 | 1958603.0 |
| 2009-06-18 13:00:00 | MSFT | Stock | 23.55 | 23.57 | 23.49 | 23.53 | 2038808.0 |
| 2009-06-18 13:30:00 | MSFT | Stock | 23.53 | 23.55 | 23.44 | 23.45 | 2127792.0 |
| 2009-06-18 14:00:00 | MSFT | Stock | 23.45 | 23.5 | 23.4 | 23.46 | 2934981.0 |
| 2009-06-18 14:30:00 | MSFT | Stock | 23.46 | 23.56 | 23.44 | 23.518 | 2512840.0 |
| 2009-06-18 15:00:00 | MSFT | Stock | 23.51 | 23.65 | 23.47 | 23.56 | 4959276.0 |
| 2009-06-18 15:30:00 | MSFT | Stock | 23.56 | 23.64 | 23.48 | 23.5 | 8567091.0 |
| 2009-06-18 16:00:00 | MSFT | Stock | 23.5 | 23.68 | 23.38 | 23.46 | 2189636.0 |
| 2009-06-18 16:30:00 | MSFT | Stock | 23.49 | 23.54 | 23.49 | 23.51 | 12174.0 |
| 2009-06-18 17:00:00 | MSFT | Stock | 23.51 | 23.59 | 23.51 | 23.51 | 6700.0 |
| 2009-06-18 17:30:00 | MSFT | Stock | 23.55 | 23.59 | 23.5 | 23.5 | 104359.0 |
| 2009-06-18 18:00:00 | MSFT | Stock | 23.57 | 23.57 | 23.57 | 23.57 | 200.0 |
| 2009-06-18 18:30:00 | MSFT | Stock | 23.6 | 23.62 | 23.6 | 23.62 | 2396.0 |
| 2009-06-18 19:00:00 | MSFT | Stock | 23.59 | 23.68 | 23.59 | 23.59 | 9504.0 |
> showing 50 of 69,726 rows — these rows as CSV