PREVIEW / stock_30min / 2009-07-29
file: by_date/stock_30min/2009/2009-07-29.parquet size: 1.3 MB rows: 73,819 symbols: 3,338
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-07-29 04:30:00 | AAPL | Stock | 5.6786 | 5.6786 | 5.6786 | 5.6786 | 4200.0 |
| 2009-07-29 07:30:00 | AAPL | Stock | 5.6896 | 5.7032 | 5.6864 | 5.7032 | 56588.0 |
| 2009-07-29 08:00:00 | AAPL | Stock | 5.6868 | 5.6982 | 5.6839 | 5.6911 | 215824.0 |
| 2009-07-29 08:30:00 | AAPL | Stock | 5.6839 | 5.6986 | 5.6786 | 5.6786 | 472192.0 |
| 2009-07-29 09:00:00 | AAPL | Stock | 5.6796 | 5.6854 | 5.6754 | 5.6764 | 435568.0 |
| 2009-07-29 09:30:00 | AAPL | Stock | 5.6754 | 5.6929 | 5.6518 | 5.6689 | 44114812.0 |
| 2009-07-29 10:00:00 | AAPL | Stock | 5.6696 | 5.7 | 5.6643 | 5.6957 | 35571032.0 |
| 2009-07-29 10:30:00 | AAPL | Stock | 5.6964 | 5.7143 | 5.6857 | 5.7057 | 36883224.0 |
| 2009-07-29 11:00:00 | AAPL | Stock | 5.7057 | 5.7107 | 5.6757 | 5.6807 | 22572116.0 |
| 2009-07-29 11:30:00 | AAPL | Stock | 5.6807 | 5.705 | 5.6718 | 5.7036 | 20720840.0 |
| 2009-07-29 12:00:00 | AAPL | Stock | 5.7032 | 5.71 | 5.695 | 5.71 | 17523380.0 |
| 2009-07-29 12:30:00 | AAPL | Stock | 5.71 | 5.7146 | 5.7018 | 5.7021 | 24902136.0 |
| 2009-07-29 13:00:00 | AAPL | Stock | 5.7021 | 5.7025 | 5.6821 | 5.6871 | 24281880.0 |
| 2009-07-29 13:30:00 | AAPL | Stock | 5.6861 | 5.7014 | 5.6714 | 5.6996 | 23306444.0 |
| 2009-07-29 14:00:00 | AAPL | Stock | 5.7 | 5.71 | 5.6861 | 5.7061 | 23209060.0 |
| 2009-07-29 14:30:00 | AAPL | Stock | 5.7058 | 5.7067 | 5.6882 | 5.6936 | 16109996.0 |
| 2009-07-29 15:00:00 | AAPL | Stock | 5.6943 | 5.7118 | 5.6921 | 5.7055 | 20437704.0 |
| 2009-07-29 15:30:00 | AAPL | Stock | 5.7057 | 5.7304 | 5.7029 | 5.7161 | 60939116.0 |
| 2009-07-29 16:00:00 | AAPL | Stock | 5.7154 | 5.7193 | 5.6772 | 5.7154 | 6150676.0 |
| 2009-07-29 16:30:00 | AAPL | Stock | 5.7168 | 5.7189 | 5.7143 | 5.7146 | 479416.0 |
| 2009-07-29 17:00:00 | AAPL | Stock | 5.7146 | 5.7171 | 5.7143 | 5.7168 | 200732.0 |
| 2009-07-29 17:30:00 | AAPL | Stock | 5.7026 | 5.7171 | 5.7026 | 5.7171 | 82544.0 |
| 2009-07-29 18:00:00 | AAPL | Stock | 5.7154 | 5.7179 | 5.7154 | 5.7179 | 140728.0 |
| 2009-07-29 18:30:00 | AAPL | Stock | 5.7179 | 5.7189 | 5.7164 | 5.7171 | 109480.0 |
| 2009-07-29 19:00:00 | AAPL | Stock | 5.7154 | 5.7225 | 5.7154 | 5.7214 | 74368.0 |
| 2009-07-29 19:30:00 | AAPL | Stock | 5.7193 | 5.7211 | 5.7164 | 5.7211 | 74704.0 |
| 2009-07-29 04:00:00 | MSFT | Stock | 23.57 | 23.64 | 23.56 | 23.64 | 500.0 |
| 2009-07-29 04:30:00 | MSFT | Stock | 23.64 | 23.64 | 23.64 | 23.64 | 100.0 |
| 2009-07-29 05:00:00 | MSFT | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 200.0 |
| 2009-07-29 06:00:00 | MSFT | Stock | 23.56 | 23.56 | 23.56 | 23.56 | 189.0 |
| 2009-07-29 06:30:00 | MSFT | Stock | 23.57 | 23.57 | 23.57 | 23.57 | 511.0 |
| 2009-07-29 07:00:00 | MSFT | Stock | 23.57 | 23.63 | 23.5 | 23.63 | 2389.0 |
| 2009-07-29 07:30:00 | MSFT | Stock | 23.55 | 23.75 | 23.3 | 23.7 | 127590.0 |
| 2009-07-29 08:00:00 | MSFT | Stock | 23.65 | 23.89 | 23.52 | 23.6 | 1126405.0 |
| 2009-07-29 08:30:00 | MSFT | Stock | 23.6 | 23.81 | 23.51 | 23.57 | 1067801.0 |
| 2009-07-29 09:00:00 | MSFT | Stock | 23.56 | 23.77 | 23.56 | 23.74 | 666630.0 |
| 2009-07-29 09:30:00 | MSFT | Stock | 23.73 | 23.91 | 23.47 | 23.58 | 11651994.0 |
| 2009-07-29 10:00:00 | MSFT | Stock | 23.58 | 23.72 | 23.55 | 23.66 | 5842570.0 |
| 2009-07-29 10:30:00 | MSFT | Stock | 23.67 | 23.68 | 23.5 | 23.57 | 5876720.0 |
| 2009-07-29 11:00:00 | MSFT | Stock | 23.58 | 23.67 | 23.52 | 23.54 | 3625898.0 |
| 2009-07-29 11:30:00 | MSFT | Stock | 23.53 | 23.57 | 23.46 | 23.54 | 4756412.0 |
| 2009-07-29 12:00:00 | MSFT | Stock | 23.55 | 23.62 | 23.53 | 23.59 | 2375477.0 |
| 2009-07-29 12:30:00 | MSFT | Stock | 23.59 | 23.63 | 23.52 | 23.531 | 2758665.0 |
| 2009-07-29 13:00:00 | MSFT | Stock | 23.53 | 23.56 | 23.42 | 23.45 | 5175029.0 |
| 2009-07-29 13:30:00 | MSFT | Stock | 23.45 | 23.53 | 23.34 | 23.5 | 3362360.0 |
| 2009-07-29 14:00:00 | MSFT | Stock | 23.51 | 23.62 | 23.43 | 23.613 | 3663939.0 |
| 2009-07-29 14:30:00 | MSFT | Stock | 23.62 | 23.68 | 23.59 | 23.63 | 4710559.0 |
| 2009-07-29 15:00:00 | MSFT | Stock | 23.64 | 23.7 | 23.63 | 23.678 | 2749584.0 |
| 2009-07-29 15:30:00 | MSFT | Stock | 23.68 | 23.88 | 23.66 | 23.79 | 10371279.0 |
| 2009-07-29 16:00:00 | MSFT | Stock | 23.77 | 23.81 | 23.54 | 23.81 | 2030157.0 |
> showing 50 of 73,819 rows — these rows as CSV