PREVIEW / stock_30min / 2004-07-15
file: by_date/stock_30min/2004/2004-07-15.parquet size: 744 KB rows: 40,023 symbols: 1,793
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 |
|---|---|---|---|---|---|---|---|
| 2004-07-15 08:00:00 | AAPL | Stock | 0.5796 | 0.5836 | 0.5634 | 0.5777 | 19965288.0 |
| 2004-07-15 08:30:00 | AAPL | Stock | 0.5782 | 0.5839 | 0.5759 | 0.58 | 10839752.0 |
| 2004-07-15 09:00:00 | AAPL | Stock | 0.5804 | 0.5855 | 0.5768 | 0.583 | 13752088.0 |
| 2004-07-15 09:30:00 | AAPL | Stock | 0.5813 | 0.6005 | 0.5809 | 0.5889 | 531712888.0 |
| 2004-07-15 10:00:00 | AAPL | Stock | 0.5889 | 0.5911 | 0.5804 | 0.5888 | 267327088.0 |
| 2004-07-15 10:30:00 | AAPL | Stock | 0.5888 | 0.5896 | 0.5816 | 0.5818 | 100457000.0 |
| 2004-07-15 11:00:00 | AAPL | Stock | 0.5818 | 0.5852 | 0.575 | 0.5777 | 122458616.0 |
| 2004-07-15 11:30:00 | AAPL | Stock | 0.5775 | 0.5809 | 0.5734 | 0.5802 | 111142808.0 |
| 2004-07-15 12:00:00 | AAPL | Stock | 0.5802 | 0.588 | 0.58 | 0.5857 | 88638200.0 |
| 2004-07-15 12:30:00 | AAPL | Stock | 0.5857 | 0.5932 | 0.5841 | 0.5888 | 66048304.0 |
| 2004-07-15 13:00:00 | AAPL | Stock | 0.5889 | 0.592 | 0.5879 | 0.5889 | 56310912.0 |
| 2004-07-15 13:30:00 | AAPL | Stock | 0.5888 | 0.592 | 0.5877 | 0.5902 | 54089672.0 |
| 2004-07-15 14:00:00 | AAPL | Stock | 0.5902 | 0.5907 | 0.5877 | 0.5886 | 42881496.0 |
| 2004-07-15 14:30:00 | AAPL | Stock | 0.5886 | 0.5934 | 0.5877 | 0.5904 | 60401432.0 |
| 2004-07-15 15:00:00 | AAPL | Stock | 0.5904 | 0.5911 | 0.5888 | 0.59 | 51533664.0 |
| 2004-07-15 15:30:00 | AAPL | Stock | 0.59 | 0.5904 | 0.5855 | 0.5884 | 107908864.0 |
| 2004-07-15 16:00:00 | AAPL | Stock | 0.5877 | 0.5884 | 0.5852 | 0.5861 | 10566024.0 |
| 2004-07-15 16:30:00 | AAPL | Stock | 0.5875 | 0.588 | 0.5864 | 0.5864 | 5232304.0 |
| 2004-07-15 17:00:00 | AAPL | Stock | 0.5883 | 0.5883 | 0.5864 | 0.5864 | 94080.0 |
| 2004-07-15 17:30:00 | AAPL | Stock | 0.5857 | 0.5857 | 0.5834 | 0.585 | 548800.0 |
| 2004-07-15 18:00:00 | AAPL | Stock | 0.5855 | 0.5855 | 0.5836 | 0.5836 | 134400.0 |
| 2004-07-15 08:00:00 | MSFT | Stock | 28.15 | 28.16 | 28.13 | 28.13 | 2100.0 |
| 2004-07-15 08:30:00 | MSFT | Stock | 28.13 | 28.16 | 28.12 | 28.15 | 17460.0 |
| 2004-07-15 09:00:00 | MSFT | Stock | 28.19 | 28.19 | 28.04 | 28.04 | 189542.0 |
| 2004-07-15 09:30:00 | MSFT | Stock | 28.049 | 28.18 | 27.99 | 28.01 | 5920401.0 |
| 2004-07-15 10:00:00 | MSFT | Stock | 28.01 | 28.05 | 27.8 | 27.96 | 5014187.0 |
| 2004-07-15 10:30:00 | MSFT | Stock | 27.96 | 28.01 | 27.9 | 27.9 | 2045696.0 |
| 2004-07-15 11:00:00 | MSFT | Stock | 27.9 | 28.05 | 27.86 | 27.93 | 3232038.0 |
| 2004-07-15 11:30:00 | MSFT | Stock | 27.93 | 28.02 | 27.8899 | 27.979 | 3167173.0 |
| 2004-07-15 12:00:00 | MSFT | Stock | 27.98 | 28.2037 | 27.97 | 28.11 | 3711160.0 |
| 2004-07-15 12:30:00 | MSFT | Stock | 28.11 | 28.16 | 28.07 | 28.12 | 2695488.0 |
| 2004-07-15 13:00:00 | MSFT | Stock | 28.12 | 28.2 | 28.089 | 28.11 | 1854711.0 |
| 2004-07-15 13:30:00 | MSFT | Stock | 28.11 | 28.14 | 28.01 | 28.05 | 2017482.0 |
| 2004-07-15 14:00:00 | MSFT | Stock | 28.05 | 28.12 | 27.99 | 28.08 | 3049956.0 |
| 2004-07-15 14:30:00 | MSFT | Stock | 28.08 | 28.15 | 28.06 | 28.09 | 2981306.0 |
| 2004-07-15 15:00:00 | MSFT | Stock | 28.08 | 28.11 | 28.03 | 28.04 | 2231478.0 |
| 2004-07-15 15:30:00 | MSFT | Stock | 28.03 | 28.04 | 27.85 | 27.87 | 6442680.0 |
| 2004-07-15 16:00:00 | MSFT | Stock | 27.88 | 28.0189 | 27.67 | 27.96 | 546386.0 |
| 2004-07-15 16:30:00 | MSFT | Stock | 27.95 | 27.97 | 27.86 | 27.86 | 49354.0 |
| 2004-07-15 17:00:00 | MSFT | Stock | 27.89 | 27.89 | 27.79 | 27.85 | 31006.0 |
| 2004-07-15 17:30:00 | MSFT | Stock | 27.87 | 27.87 | 27.87 | 27.87 | 1706.0 |
| 2004-07-15 18:00:00 | MSFT | Stock | 27.89 | 27.89 | 27.89 | 27.89 | 400.0 |
| 2004-07-15 08:30:00 | NVDA | Stock | 0.1333 | 0.1333 | 0.1333 | 0.1333 | 48000.0 |
| 2004-07-15 09:00:00 | NVDA | Stock | 0.1333 | 0.1333 | 0.1325 | 0.1325 | 442560.0 |
| 2004-07-15 09:30:00 | NVDA | Stock | 0.1326 | 0.134 | 0.1317 | 0.1325 | 64130280.0 |
| 2004-07-15 10:00:00 | NVDA | Stock | 0.1324 | 0.1331 | 0.131 | 0.1315 | 40119240.0 |
| 2004-07-15 10:30:00 | NVDA | Stock | 0.1314 | 0.1321 | 0.131 | 0.1316 | 36205320.0 |
| 2004-07-15 11:00:00 | NVDA | Stock | 0.1317 | 0.132 | 0.1308 | 0.1309 | 41464680.0 |
| 2004-07-15 11:30:00 | NVDA | Stock | 0.1309 | 0.1317 | 0.13 | 0.1311 | 39499680.0 |
| 2004-07-15 12:00:00 | NVDA | Stock | 0.1312 | 0.1325 | 0.131 | 0.1323 | 53950440.0 |
> showing 50 of 40,023 rows — these rows as CSV