PREVIEW / stock_30min / 2004-07-16
file: by_date/stock_30min/2004/2004-07-16.parquet size: 743 KB rows: 40,097 symbols: 1,796
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-16 08:00:00 | AAPL | Stock | 0.5893 | 0.5893 | 0.5857 | 0.5863 | 543200.0 |
| 2004-07-16 08:30:00 | AAPL | Stock | 0.5866 | 0.5871 | 0.5857 | 0.5857 | 39200.0 |
| 2004-07-16 09:00:00 | AAPL | Stock | 0.5857 | 0.5879 | 0.5852 | 0.5861 | 1174152.0 |
| 2004-07-16 09:30:00 | AAPL | Stock | 0.5879 | 0.5879 | 0.5798 | 0.583 | 71851976.0 |
| 2004-07-16 10:00:00 | AAPL | Stock | 0.5827 | 0.5864 | 0.58 | 0.582 | 44312128.0 |
| 2004-07-16 10:30:00 | AAPL | Stock | 0.5823 | 0.5836 | 0.5784 | 0.5804 | 50289680.0 |
| 2004-07-16 11:00:00 | AAPL | Stock | 0.5805 | 0.5857 | 0.5804 | 0.582 | 23397136.0 |
| 2004-07-16 11:30:00 | AAPL | Stock | 0.5821 | 0.5832 | 0.5807 | 0.582 | 19821928.0 |
| 2004-07-16 12:00:00 | AAPL | Stock | 0.582 | 0.5829 | 0.5814 | 0.5829 | 15332576.0 |
| 2004-07-16 12:30:00 | AAPL | Stock | 0.5829 | 0.5839 | 0.582 | 0.5823 | 16376584.0 |
| 2004-07-16 13:00:00 | AAPL | Stock | 0.5823 | 0.5829 | 0.5805 | 0.5814 | 11156376.0 |
| 2004-07-16 13:30:00 | AAPL | Stock | 0.5813 | 0.5829 | 0.5813 | 0.582 | 8195040.0 |
| 2004-07-16 14:00:00 | AAPL | Stock | 0.582 | 0.582 | 0.5805 | 0.5816 | 14547176.0 |
| 2004-07-16 14:30:00 | AAPL | Stock | 0.5814 | 0.582 | 0.5804 | 0.5811 | 23024008.0 |
| 2004-07-16 15:00:00 | AAPL | Stock | 0.5811 | 0.5818 | 0.5782 | 0.5791 | 33112184.0 |
| 2004-07-16 15:30:00 | AAPL | Stock | 0.5804 | 0.5804 | 0.5743 | 0.5745 | 85268512.0 |
| 2004-07-16 16:00:00 | AAPL | Stock | 0.5743 | 0.5763 | 0.5729 | 0.5738 | 9554720.0 |
| 2004-07-16 17:00:00 | AAPL | Stock | 0.5748 | 0.575 | 0.5748 | 0.575 | 28000.0 |
| 2004-07-16 17:30:00 | AAPL | Stock | 0.575 | 0.575 | 0.575 | 0.575 | 252000.0 |
| 2004-07-16 08:00:00 | MSFT | Stock | 27.97 | 28.19 | 27.97 | 28.05 | 45020.0 |
| 2004-07-16 08:30:00 | MSFT | Stock | 28.1 | 28.17 | 28.06 | 28.15 | 89975.0 |
| 2004-07-16 09:00:00 | MSFT | Stock | 28.11 | 28.16 | 28.06 | 28.16 | 324106.0 |
| 2004-07-16 09:30:00 | MSFT | Stock | 28.16 | 28.19 | 27.92 | 28.02 | 11027998.0 |
| 2004-07-16 10:00:00 | MSFT | Stock | 28.02 | 28.04 | 27.93 | 28.0 | 5741717.0 |
| 2004-07-16 10:30:00 | MSFT | Stock | 27.99 | 28.0 | 27.81 | 27.92 | 5622541.0 |
| 2004-07-16 11:00:00 | MSFT | Stock | 27.92 | 27.97 | 27.87 | 27.89 | 3027524.0 |
| 2004-07-16 11:30:00 | MSFT | Stock | 27.9 | 27.95 | 27.85 | 27.88 | 2839105.0 |
| 2004-07-16 12:00:00 | MSFT | Stock | 27.88 | 27.92 | 27.85 | 27.889 | 1891423.0 |
| 2004-07-16 12:30:00 | MSFT | Stock | 27.89 | 27.94 | 27.84 | 27.92 | 2163804.0 |
| 2004-07-16 13:00:00 | MSFT | Stock | 27.92 | 27.93 | 27.84 | 27.84 | 2504304.0 |
| 2004-07-16 13:30:00 | MSFT | Stock | 27.84 | 27.88 | 27.78 | 27.85 | 2016058.0 |
| 2004-07-16 14:00:00 | MSFT | Stock | 27.85 | 27.87 | 27.61 | 27.64 | 4013183.0 |
| 2004-07-16 14:30:00 | MSFT | Stock | 27.64 | 27.67 | 27.52 | 27.54 | 5780949.0 |
| 2004-07-16 15:00:00 | MSFT | Stock | 27.54 | 27.67 | 27.535 | 27.65 | 3909139.0 |
| 2004-07-16 15:30:00 | MSFT | Stock | 27.65 | 27.69 | 27.47 | 27.49 | 8950984.0 |
| 2004-07-16 16:00:00 | MSFT | Stock | 27.49 | 27.707 | 27.45 | 27.49 | 2090293.0 |
| 2004-07-16 16:30:00 | MSFT | Stock | 27.49 | 27.52 | 27.47 | 27.5 | 56600.0 |
| 2004-07-16 17:00:00 | MSFT | Stock | 27.52 | 27.52 | 27.5 | 27.52 | 53600.0 |
| 2004-07-16 17:30:00 | MSFT | Stock | 27.52 | 27.52 | 27.5 | 27.52 | 2100.0 |
| 2004-07-16 08:00:00 | NVDA | Stock | 0.1317 | 0.1332 | 0.1303 | 0.1317 | 9336000.0 |
| 2004-07-16 08:30:00 | NVDA | Stock | 0.1329 | 0.1333 | 0.1329 | 0.1333 | 2021160.0 |
| 2004-07-16 09:00:00 | NVDA | Stock | 0.1333 | 0.1341 | 0.1332 | 0.1341 | 1992000.0 |
| 2004-07-16 09:30:00 | NVDA | Stock | 0.1342 | 0.1344 | 0.1304 | 0.1312 | 68031840.0 |
| 2004-07-16 10:00:00 | NVDA | Stock | 0.1312 | 0.1314 | 0.1306 | 0.131 | 40917960.0 |
| 2004-07-16 10:30:00 | NVDA | Stock | 0.131 | 0.131 | 0.1293 | 0.1302 | 44291040.0 |
| 2004-07-16 11:00:00 | NVDA | Stock | 0.1302 | 0.1303 | 0.1286 | 0.1287 | 31773600.0 |
| 2004-07-16 11:30:00 | NVDA | Stock | 0.1287 | 0.1291 | 0.128 | 0.1283 | 30757560.0 |
| 2004-07-16 12:00:00 | NVDA | Stock | 0.1282 | 0.1291 | 0.1279 | 0.1286 | 31639680.0 |
| 2004-07-16 12:30:00 | NVDA | Stock | 0.1285 | 0.1291 | 0.128 | 0.1288 | 18036960.0 |
| 2004-07-16 13:00:00 | NVDA | Stock | 0.1288 | 0.1289 | 0.1285 | 0.1286 | 15393360.0 |
> showing 50 of 40,097 rows — these rows as CSV