PREVIEW / stock_30min / 2005-01-14
file: by_date/stock_30min/2005/2005-01-14.parquet size: 783 KB rows: 42,537 symbols: 1,915
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-14 08:00:00 | AAPL | Stock | 1.2545 | 1.258 | 1.2461 | 1.25 | 5129208.0 |
| 2005-01-14 08:30:00 | AAPL | Stock | 1.25 | 1.2605 | 1.25 | 1.2591 | 2709168.0 |
| 2005-01-14 09:00:00 | AAPL | Stock | 1.2591 | 1.2604 | 1.2507 | 1.2541 | 6414856.0 |
| 2005-01-14 09:30:00 | AAPL | Stock | 1.2536 | 1.2598 | 1.2355 | 1.2434 | 272177808.0 |
| 2005-01-14 10:00:00 | AAPL | Stock | 1.2436 | 1.2571 | 1.2393 | 1.2571 | 129689672.0 |
| 2005-01-14 10:30:00 | AAPL | Stock | 1.257 | 1.2777 | 1.2566 | 1.27 | 251964944.0 |
| 2005-01-14 11:00:00 | AAPL | Stock | 1.27 | 1.2807 | 1.2679 | 1.2718 | 126433664.0 |
| 2005-01-14 11:30:00 | AAPL | Stock | 1.2714 | 1.2802 | 1.2645 | 1.2688 | 88212544.0 |
| 2005-01-14 12:00:00 | AAPL | Stock | 1.2684 | 1.2688 | 1.2559 | 1.2602 | 102085032.0 |
| 2005-01-14 12:30:00 | AAPL | Stock | 1.2602 | 1.2716 | 1.258 | 1.2584 | 62755616.0 |
| 2005-01-14 13:00:00 | AAPL | Stock | 1.2588 | 1.2598 | 1.2527 | 1.2532 | 76974632.0 |
| 2005-01-14 13:30:00 | AAPL | Stock | 1.2532 | 1.2807 | 1.2477 | 1.2502 | 216389880.0 |
| 2005-01-14 14:00:00 | AAPL | Stock | 1.25 | 1.2746 | 1.248 | 1.2514 | 169688792.0 |
| 2005-01-14 14:30:00 | AAPL | Stock | 1.2513 | 1.2568 | 1.2509 | 1.252 | 52284176.0 |
| 2005-01-14 15:00:00 | AAPL | Stock | 1.252 | 1.2525 | 1.2448 | 1.2471 | 66544072.0 |
| 2005-01-14 15:30:00 | AAPL | Stock | 1.2471 | 1.2554 | 1.245 | 1.2536 | 99371384.0 |
| 2005-01-14 16:00:00 | AAPL | Stock | 1.2527 | 1.2539 | 1.2509 | 1.2511 | 5038656.0 |
| 2005-01-14 16:30:00 | AAPL | Stock | 1.2505 | 1.2536 | 1.2505 | 1.2527 | 839552.0 |
| 2005-01-14 17:00:00 | AAPL | Stock | 1.2518 | 1.2536 | 1.2518 | 1.2536 | 276864.0 |
| 2005-01-14 17:30:00 | AAPL | Stock | 1.2536 | 1.2536 | 1.2527 | 1.2527 | 132216.0 |
| 2005-01-14 18:00:00 | AAPL | Stock | 1.2525 | 1.2536 | 1.2525 | 1.2536 | 307048.0 |
| 2005-01-14 08:00:00 | MSFT | Stock | 26.34 | 26.38 | 26.3 | 26.38 | 19375.0 |
| 2005-01-14 08:30:00 | MSFT | Stock | 26.38 | 26.43 | 26.38 | 26.41 | 55054.0 |
| 2005-01-14 09:00:00 | MSFT | Stock | 26.41 | 27.0 | 26.35 | 26.4 | 145712.0 |
| 2005-01-14 09:30:00 | MSFT | Stock | 26.4 | 26.45 | 26.09 | 26.17 | 12461568.0 |
| 2005-01-14 10:00:00 | MSFT | Stock | 26.18 | 26.29 | 26.08 | 26.28 | 8589828.0 |
| 2005-01-14 10:30:00 | MSFT | Stock | 26.28 | 26.32 | 26.19 | 26.23 | 6665810.0 |
| 2005-01-14 11:00:00 | MSFT | Stock | 26.23 | 26.32 | 26.22 | 26.29 | 6651340.0 |
| 2005-01-14 11:30:00 | MSFT | Stock | 26.28 | 26.29 | 26.19 | 26.2 | 3741536.0 |
| 2005-01-14 12:00:00 | MSFT | Stock | 26.201 | 26.26 | 26.2 | 26.24 | 2464406.0 |
| 2005-01-14 12:30:00 | MSFT | Stock | 26.24 | 26.28 | 26.14 | 26.14 | 4801321.0 |
| 2005-01-14 13:00:00 | MSFT | Stock | 26.14 | 26.16 | 26.11 | 26.12 | 3553310.0 |
| 2005-01-14 13:30:00 | MSFT | Stock | 26.12 | 26.45 | 26.1 | 26.16 | 3374090.0 |
| 2005-01-14 14:00:00 | MSFT | Stock | 26.16 | 26.32 | 26.13 | 26.14 | 17992547.0 |
| 2005-01-14 14:30:00 | MSFT | Stock | 26.14 | 26.2 | 26.13 | 26.17 | 3969481.0 |
| 2005-01-14 15:00:00 | MSFT | Stock | 26.16 | 26.17 | 26.06 | 26.08 | 4891167.0 |
| 2005-01-14 15:30:00 | MSFT | Stock | 26.08 | 26.13 | 26.04 | 26.13 | 9667701.0 |
| 2005-01-14 16:00:00 | MSFT | Stock | 26.13 | 26.13 | 26.05 | 26.13 | 1596079.0 |
| 2005-01-14 16:30:00 | MSFT | Stock | 26.1 | 26.13 | 26.08 | 26.13 | 57724.0 |
| 2005-01-14 17:00:00 | MSFT | Stock | 26.1 | 26.1 | 26.09 | 26.09 | 3618.0 |
| 2005-01-14 17:30:00 | MSFT | Stock | 26.13 | 26.13 | 26.09 | 26.09 | 50650.0 |
| 2005-01-14 18:00:00 | MSFT | Stock | 26.09 | 26.12 | 26.09 | 26.12 | 4190.0 |
| 2005-01-14 08:00:00 | NVDA | Stock | 0.1822 | 0.1824 | 0.1809 | 0.1824 | 540000.0 |
| 2005-01-14 08:30:00 | NVDA | Stock | 0.1824 | 0.1825 | 0.1812 | 0.1814 | 2736000.0 |
| 2005-01-14 09:00:00 | NVDA | Stock | 0.1814 | 0.1824 | 0.179 | 0.1817 | 1036800.0 |
| 2005-01-14 09:30:00 | NVDA | Stock | 0.182 | 0.1824 | 0.1802 | 0.1802 | 71943120.0 |
| 2005-01-14 10:00:00 | NVDA | Stock | 0.1801 | 0.1805 | 0.1779 | 0.1796 | 102554640.0 |
| 2005-01-14 10:30:00 | NVDA | Stock | 0.1797 | 0.1809 | 0.1792 | 0.1797 | 55322040.0 |
| 2005-01-14 11:00:00 | NVDA | Stock | 0.1797 | 0.18 | 0.1784 | 0.1786 | 22173600.0 |
| 2005-01-14 11:30:00 | NVDA | Stock | 0.1787 | 0.1791 | 0.1778 | 0.178 | 27105840.0 |
> showing 50 of 42,537 rows — these rows as CSV