PREVIEW / stock_30min / 2009-03-30
file: by_date/stock_30min/2009/2009-03-30.parquet size: 1.2 MB rows: 69,820 symbols: 3,305
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-03-30 04:00:00 | AAPL | Stock | 3.7321 | 3.7321 | 3.7321 | 3.7321 | 19600.0 |
| 2009-03-30 04:30:00 | AAPL | Stock | 3.7007 | 3.7007 | 3.6861 | 3.6861 | 31360.0 |
| 2009-03-30 05:30:00 | AAPL | Stock | 3.6675 | 3.6718 | 3.6675 | 3.6718 | 8400.0 |
| 2009-03-30 06:00:00 | AAPL | Stock | 3.6704 | 3.6704 | 3.6686 | 3.6686 | 16800.0 |
| 2009-03-30 07:00:00 | AAPL | Stock | 3.6893 | 3.7321 | 3.6893 | 3.7168 | 72744.0 |
| 2009-03-30 07:30:00 | AAPL | Stock | 3.7318 | 3.7318 | 3.7179 | 3.7214 | 67760.0 |
| 2009-03-30 08:00:00 | AAPL | Stock | 3.7214 | 3.7321 | 3.71 | 3.7114 | 599032.0 |
| 2009-03-30 08:30:00 | AAPL | Stock | 3.7143 | 3.7336 | 3.7107 | 3.7268 | 616476.0 |
| 2009-03-30 09:00:00 | AAPL | Stock | 3.7311 | 3.7368 | 3.7143 | 3.7286 | 1305836.0 |
| 2009-03-30 09:30:00 | AAPL | Stock | 3.7257 | 3.7504 | 3.7146 | 3.7336 | 69484464.0 |
| 2009-03-30 10:00:00 | AAPL | Stock | 3.7321 | 3.74 | 3.6893 | 3.6968 | 46408824.0 |
| 2009-03-30 10:30:00 | AAPL | Stock | 3.6968 | 3.6968 | 3.6646 | 3.6818 | 41568884.0 |
| 2009-03-30 11:00:00 | AAPL | Stock | 3.6811 | 3.7079 | 3.6786 | 3.6843 | 30641296.0 |
| 2009-03-30 11:30:00 | AAPL | Stock | 3.6832 | 3.6986 | 3.6761 | 3.6925 | 21936880.0 |
| 2009-03-30 12:00:00 | AAPL | Stock | 3.6918 | 3.7075 | 3.6825 | 3.7032 | 18970196.0 |
| 2009-03-30 12:30:00 | AAPL | Stock | 3.7025 | 3.7125 | 3.6929 | 3.6961 | 17269896.0 |
| 2009-03-30 13:00:00 | AAPL | Stock | 3.6964 | 3.7 | 3.6807 | 3.6918 | 20637120.0 |
| 2009-03-30 13:30:00 | AAPL | Stock | 3.6921 | 3.6979 | 3.6664 | 3.6868 | 27760180.0 |
| 2009-03-30 14:00:00 | AAPL | Stock | 3.6864 | 3.7082 | 3.6814 | 3.6939 | 28600432.0 |
| 2009-03-30 14:30:00 | AAPL | Stock | 3.6936 | 3.7 | 3.6711 | 3.6757 | 28536592.0 |
| 2009-03-30 15:00:00 | AAPL | Stock | 3.6764 | 3.7018 | 3.6732 | 3.6986 | 37840236.0 |
| 2009-03-30 15:30:00 | AAPL | Stock | 3.6985 | 3.7321 | 3.6911 | 3.7304 | 76640368.0 |
| 2009-03-30 16:00:00 | AAPL | Stock | 3.7307 | 3.7449 | 3.6875 | 3.7325 | 25143804.0 |
| 2009-03-30 16:30:00 | AAPL | Stock | 3.7296 | 3.7375 | 3.7268 | 3.7318 | 1443932.0 |
| 2009-03-30 17:00:00 | AAPL | Stock | 3.7375 | 3.7389 | 3.7375 | 3.7389 | 109508.0 |
| 2009-03-30 17:30:00 | AAPL | Stock | 3.7375 | 3.7375 | 3.7357 | 3.7357 | 111384.0 |
| 2009-03-30 18:00:00 | AAPL | Stock | 3.7375 | 3.7375 | 3.7357 | 3.7375 | 102816.0 |
| 2009-03-30 18:30:00 | AAPL | Stock | 3.7368 | 3.7411 | 3.7368 | 3.7411 | 19040.0 |
| 2009-03-30 19:00:00 | AAPL | Stock | 3.7446 | 3.7464 | 3.7446 | 3.7464 | 25620.0 |
| 2009-03-30 19:30:00 | AAPL | Stock | 3.7496 | 3.7496 | 3.7464 | 3.7496 | 22400.0 |
| 2009-03-30 04:00:00 | MSFT | Stock | 17.96 | 18.01 | 17.8 | 17.8 | 1500.0 |
| 2009-03-30 07:00:00 | MSFT | Stock | 17.81 | 17.85 | 17.81 | 17.85 | 600.0 |
| 2009-03-30 07:30:00 | MSFT | Stock | 17.86 | 17.86 | 17.8 | 17.8 | 619.0 |
| 2009-03-30 08:00:00 | MSFT | Stock | 17.89 | 18.02 | 17.75 | 17.8 | 27532.0 |
| 2009-03-30 08:30:00 | MSFT | Stock | 17.8 | 17.8 | 17.76 | 17.76 | 6475.0 |
| 2009-03-30 09:00:00 | MSFT | Stock | 17.76 | 17.79 | 17.75 | 17.76 | 31998.0 |
| 2009-03-30 09:30:00 | MSFT | Stock | 17.75 | 17.76 | 17.33 | 17.44 | 6966820.0 |
| 2009-03-30 10:00:00 | MSFT | Stock | 17.45 | 17.54 | 17.42 | 17.51 | 4124225.0 |
| 2009-03-30 10:30:00 | MSFT | Stock | 17.51 | 17.52 | 17.41 | 17.41 | 3562204.0 |
| 2009-03-30 11:00:00 | MSFT | Stock | 17.42 | 17.47 | 17.33 | 17.34 | 4024195.0 |
| 2009-03-30 11:30:00 | MSFT | Stock | 17.34 | 17.44 | 17.27 | 17.39 | 2766951.0 |
| 2009-03-30 12:00:00 | MSFT | Stock | 17.39 | 17.512 | 17.38 | 17.5 | 2520545.0 |
| 2009-03-30 12:30:00 | MSFT | Stock | 17.5 | 17.54 | 17.43 | 17.44 | 1924573.0 |
| 2009-03-30 13:00:00 | MSFT | Stock | 17.44 | 17.45 | 17.38 | 17.42 | 1572808.0 |
| 2009-03-30 13:30:00 | MSFT | Stock | 17.42 | 17.45 | 17.34 | 17.44 | 2308810.0 |
| 2009-03-30 14:00:00 | MSFT | Stock | 17.44 | 17.52 | 17.42 | 17.47 | 1765441.0 |
| 2009-03-30 14:30:00 | MSFT | Stock | 17.47 | 17.51 | 17.34 | 17.34 | 2530969.0 |
| 2009-03-30 15:00:00 | MSFT | Stock | 17.35 | 17.5 | 17.34 | 17.45 | 3060339.0 |
| 2009-03-30 15:30:00 | MSFT | Stock | 17.45 | 17.61 | 17.42 | 17.49 | 7555120.0 |
| 2009-03-30 16:00:00 | MSFT | Stock | 17.48 | 17.55 | 17.4 | 17.55 | 3588798.0 |
> showing 50 of 69,820 rows — these rows as CSV