PREVIEW / stock_30min / 2008-10-01
file: by_date/stock_30min/2008/2008-10-01.parquet size: 1.2 MB rows: 70,481 symbols: 3,347
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-01 05:30:00 | AAPL | Stock | 4.0714 | 4.0714 | 4.0714 | 4.0714 | 5600.0 |
| 2008-10-01 06:30:00 | AAPL | Stock | 4.0714 | 4.0714 | 4.0714 | 4.0714 | 2800.0 |
| 2008-10-01 07:00:00 | AAPL | Stock | 4.0539 | 4.0704 | 4.0539 | 4.0546 | 66500.0 |
| 2008-10-01 07:30:00 | AAPL | Stock | 4.0543 | 4.0543 | 4.0354 | 4.0357 | 600600.0 |
| 2008-10-01 08:00:00 | AAPL | Stock | 4.0482 | 4.0496 | 3.9857 | 4.0043 | 2460864.0 |
| 2008-10-01 08:30:00 | AAPL | Stock | 4.0007 | 4.0268 | 3.9964 | 4.0032 | 1383676.0 |
| 2008-10-01 09:00:00 | AAPL | Stock | 4.0054 | 4.0157 | 3.9929 | 3.9961 | 2253412.0 |
| 2008-10-01 09:30:00 | AAPL | Stock | 3.9961 | 4.0125 | 3.9286 | 3.98 | 145216820.0 |
| 2008-10-01 10:00:00 | AAPL | Stock | 3.9811 | 3.9821 | 3.895 | 3.9079 | 134801212.0 |
| 2008-10-01 10:30:00 | AAPL | Stock | 3.9075 | 3.9086 | 3.8414 | 3.8593 | 98445452.0 |
| 2008-10-01 11:00:00 | AAPL | Stock | 3.8589 | 3.9043 | 3.8354 | 3.8925 | 81565400.0 |
| 2008-10-01 11:30:00 | AAPL | Stock | 3.8932 | 3.9107 | 3.8782 | 3.8882 | 51717540.0 |
| 2008-10-01 12:00:00 | AAPL | Stock | 3.888 | 3.9375 | 3.8689 | 3.9268 | 65441180.0 |
| 2008-10-01 12:30:00 | AAPL | Stock | 3.9275 | 4.0129 | 3.9218 | 3.9868 | 109290356.0 |
| 2008-10-01 13:00:00 | AAPL | Stock | 3.9871 | 3.9893 | 3.9321 | 3.9387 | 68780376.0 |
| 2008-10-01 13:30:00 | AAPL | Stock | 3.94 | 3.9961 | 3.8793 | 3.9629 | 137318188.0 |
| 2008-10-01 14:00:00 | AAPL | Stock | 3.9636 | 3.9932 | 3.9286 | 3.9764 | 82266912.0 |
| 2008-10-01 14:30:00 | AAPL | Stock | 3.975 | 4.0004 | 3.9286 | 3.9404 | 75817784.0 |
| 2008-10-01 15:00:00 | AAPL | Stock | 3.9411 | 3.9454 | 3.8911 | 3.8989 | 89421892.0 |
| 2008-10-01 15:30:00 | AAPL | Stock | 3.8993 | 3.9429 | 3.8968 | 3.8971 | 98082348.0 |
| 2008-10-01 16:00:00 | AAPL | Stock | 3.9036 | 3.9429 | 3.8864 | 3.9114 | 29054368.0 |
| 2008-10-01 16:30:00 | AAPL | Stock | 3.931 | 3.931 | 3.897 | 3.9125 | 845768.0 |
| 2008-10-01 17:00:00 | AAPL | Stock | 3.9107 | 3.9325 | 3.9079 | 3.9168 | 447664.0 |
| 2008-10-01 17:30:00 | AAPL | Stock | 3.9161 | 3.9189 | 3.9107 | 3.9107 | 198380.0 |
| 2008-10-01 18:00:00 | AAPL | Stock | 3.9179 | 3.9425 | 3.9179 | 3.9425 | 365232.0 |
| 2008-10-01 18:30:00 | AAPL | Stock | 3.9411 | 3.9607 | 3.9411 | 3.9589 | 256648.0 |
| 2008-10-01 19:00:00 | AAPL | Stock | 3.9589 | 3.9589 | 3.9286 | 3.9393 | 145460.0 |
| 2008-10-01 19:30:00 | AAPL | Stock | 3.9457 | 3.9521 | 3.9286 | 3.9464 | 240324.0 |
| 2008-10-01 06:30:00 | MSFT | Stock | 26.13 | 26.13 | 26.13 | 26.13 | 100.0 |
| 2008-10-01 08:00:00 | MSFT | Stock | 26.5 | 26.6 | 26.35 | 26.49 | 34328.0 |
| 2008-10-01 08:30:00 | MSFT | Stock | 26.45 | 26.69 | 26.36 | 26.36 | 82234.0 |
| 2008-10-01 09:00:00 | MSFT | Stock | 26.37 | 26.43 | 26.25 | 26.38 | 65342.0 |
| 2008-10-01 09:30:00 | MSFT | Stock | 26.39 | 26.87 | 26.32 | 26.73 | 8380695.0 |
| 2008-10-01 10:00:00 | MSFT | Stock | 26.73 | 26.73 | 26.28 | 26.63 | 7672901.0 |
| 2008-10-01 10:30:00 | MSFT | Stock | 26.64 | 26.85 | 26.51 | 26.71 | 6181820.0 |
| 2008-10-01 11:00:00 | MSFT | Stock | 26.72 | 26.73 | 26.54 | 26.64 | 3892720.0 |
| 2008-10-01 11:30:00 | MSFT | Stock | 26.64 | 26.74 | 26.54 | 26.72 | 4049184.0 |
| 2008-10-01 12:00:00 | MSFT | Stock | 26.71 | 26.87 | 26.64 | 26.79 | 4042675.0 |
| 2008-10-01 12:30:00 | MSFT | Stock | 26.8 | 26.99 | 26.78 | 26.91 | 5163894.0 |
| 2008-10-01 13:00:00 | MSFT | Stock | 26.9 | 26.92 | 26.74 | 26.81 | 4397689.0 |
| 2008-10-01 13:30:00 | MSFT | Stock | 26.81 | 26.86 | 26.49 | 26.57 | 8006890.0 |
| 2008-10-01 14:00:00 | MSFT | Stock | 26.57 | 26.72 | 26.5 | 26.7 | 4808225.0 |
| 2008-10-01 14:30:00 | MSFT | Stock | 26.7 | 26.87 | 26.58 | 26.65 | 5132424.0 |
| 2008-10-01 15:00:00 | MSFT | Stock | 26.655 | 26.67 | 26.41 | 26.49 | 6271798.0 |
| 2008-10-01 15:30:00 | MSFT | Stock | 26.5 | 26.69 | 26.455 | 26.47 | 7729254.0 |
| 2008-10-01 16:00:00 | MSFT | Stock | 26.48 | 26.744 | 26.47 | 26.608 | 11037730.0 |
| 2008-10-01 16:30:00 | MSFT | Stock | 26.479 | 26.58 | 26.479 | 26.48 | 85869.0 |
| 2008-10-01 17:00:00 | MSFT | Stock | 26.55 | 26.651 | 26.5 | 26.59 | 16277.0 |
| 2008-10-01 17:30:00 | MSFT | Stock | 26.58 | 26.58 | 26.228 | 26.55 | 9525.0 |
| 2008-10-01 18:00:00 | MSFT | Stock | 26.48 | 26.48 | 26.48 | 26.48 | 31824.0 |
> showing 50 of 70,481 rows — these rows as CSV