PREVIEW / stock_30min / 2005-09-19
file: by_date/stock_30min/2005/2005-09-19.parquet size: 848 KB rows: 45,888 symbols: 2,062
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-09-19 08:00:00 | AAPL | Stock | 1.8282 | 1.8361 | 1.8225 | 1.8321 | 832300.0 |
| 2005-09-19 08:30:00 | AAPL | Stock | 1.8321 | 1.8321 | 1.8289 | 1.8289 | 278572.0 |
| 2005-09-19 09:00:00 | AAPL | Stock | 1.8289 | 1.8321 | 1.8232 | 1.8236 | 1145704.0 |
| 2005-09-19 09:30:00 | AAPL | Stock | 1.8232 | 1.86 | 1.8232 | 1.8432 | 113443288.0 |
| 2005-09-19 10:00:00 | AAPL | Stock | 1.8432 | 1.8704 | 1.8432 | 1.8689 | 88664968.0 |
| 2005-09-19 10:30:00 | AAPL | Stock | 1.8686 | 1.8832 | 1.865 | 1.8736 | 95174632.0 |
| 2005-09-19 11:00:00 | AAPL | Stock | 1.8736 | 1.8807 | 1.8693 | 1.8771 | 48450248.0 |
| 2005-09-19 11:30:00 | AAPL | Stock | 1.8761 | 1.8789 | 1.8704 | 1.8725 | 31836056.0 |
| 2005-09-19 12:00:00 | AAPL | Stock | 1.8725 | 1.8786 | 1.8704 | 1.8757 | 20170108.0 |
| 2005-09-19 12:30:00 | AAPL | Stock | 1.8757 | 1.8836 | 1.8729 | 1.8804 | 27712356.0 |
| 2005-09-19 13:00:00 | AAPL | Stock | 1.88 | 1.8889 | 1.8796 | 1.8861 | 37977632.0 |
| 2005-09-19 13:30:00 | AAPL | Stock | 1.8861 | 1.8882 | 1.8839 | 1.8843 | 22503292.0 |
| 2005-09-19 14:00:00 | AAPL | Stock | 1.8843 | 1.885 | 1.865 | 1.8689 | 54054392.0 |
| 2005-09-19 14:30:00 | AAPL | Stock | 1.8693 | 1.8736 | 1.865 | 1.8693 | 29885268.0 |
| 2005-09-19 15:00:00 | AAPL | Stock | 1.8693 | 1.88 | 1.8682 | 1.8746 | 38553368.0 |
| 2005-09-19 15:30:00 | AAPL | Stock | 1.875 | 1.8854 | 1.8743 | 1.8807 | 66981096.0 |
| 2005-09-19 16:00:00 | AAPL | Stock | 1.88 | 1.8868 | 1.8776 | 1.8829 | 50934464.0 |
| 2005-09-19 16:30:00 | AAPL | Stock | 1.8829 | 1.8832 | 1.8789 | 1.8807 | 740292.0 |
| 2005-09-19 17:00:00 | AAPL | Stock | 1.8821 | 1.8821 | 1.8789 | 1.8789 | 55552.0 |
| 2005-09-19 17:30:00 | AAPL | Stock | 1.8811 | 1.8811 | 1.8811 | 1.8811 | 30800.0 |
| 2005-09-19 18:00:00 | AAPL | Stock | 1.8814 | 1.8814 | 1.8814 | 1.8814 | 47544.0 |
| 2005-09-19 07:30:00 | MSFT | Stock | 26.13 | 26.13 | 26.13 | 26.13 | 100.0 |
| 2005-09-19 08:00:00 | MSFT | Stock | 26.14 | 26.15 | 26.07 | 26.1 | 13750.0 |
| 2005-09-19 08:30:00 | MSFT | Stock | 26.08 | 26.13 | 26.08 | 26.12 | 25915.0 |
| 2005-09-19 09:00:00 | MSFT | Stock | 26.12 | 26.13 | 26.06 | 26.09 | 898899.0 |
| 2005-09-19 09:30:00 | MSFT | Stock | 26.09 | 26.27 | 26.08 | 26.25 | 11724376.0 |
| 2005-09-19 10:00:00 | MSFT | Stock | 26.24 | 26.25 | 26.08 | 26.09 | 5431849.0 |
| 2005-09-19 10:30:00 | MSFT | Stock | 26.09 | 26.19 | 26.07 | 26.1 | 4674868.0 |
| 2005-09-19 11:00:00 | MSFT | Stock | 26.1 | 26.17 | 26.09 | 26.111 | 3117736.0 |
| 2005-09-19 11:30:00 | MSFT | Stock | 26.11 | 26.13 | 26.08 | 26.1 | 2615476.0 |
| 2005-09-19 12:00:00 | MSFT | Stock | 26.102 | 26.15 | 26.09 | 26.13 | 2209973.0 |
| 2005-09-19 12:30:00 | MSFT | Stock | 26.12 | 26.13 | 26.05 | 26.07 | 1860277.0 |
| 2005-09-19 13:00:00 | MSFT | Stock | 26.06 | 26.1 | 26.0 | 26.0 | 2852388.0 |
| 2005-09-19 13:30:00 | MSFT | Stock | 26.0 | 26.05 | 25.97 | 26.03 | 3033234.0 |
| 2005-09-19 14:00:00 | MSFT | Stock | 26.02 | 26.03 | 25.92 | 25.931 | 3198929.0 |
| 2005-09-19 14:30:00 | MSFT | Stock | 25.931 | 25.99 | 25.899 | 25.9 | 2921145.0 |
| 2005-09-19 15:00:00 | MSFT | Stock | 25.9 | 25.94 | 25.86 | 25.88 | 3794017.0 |
| 2005-09-19 15:30:00 | MSFT | Stock | 25.88 | 26.03 | 25.86 | 26.0 | 10439143.0 |
| 2005-09-19 16:00:00 | MSFT | Stock | 26.01 | 26.066 | 25.959 | 25.959 | 516960.0 |
| 2005-09-19 16:30:00 | MSFT | Stock | 26.01 | 26.01 | 26.0 | 26.01 | 6200.0 |
| 2005-09-19 17:00:00 | MSFT | Stock | 26.01 | 26.01 | 26.01 | 26.01 | 2600.0 |
| 2005-09-19 17:30:00 | MSFT | Stock | 26.01 | 26.03 | 26.01 | 26.02 | 17935.0 |
| 2005-09-19 18:00:00 | MSFT | Stock | 26.0 | 26.02 | 26.0 | 26.02 | 4000.0 |
| 2005-09-19 09:00:00 | NVDA | Stock | 0.2767 | 0.2767 | 0.2767 | 0.2767 | 24000.0 |
| 2005-09-19 09:30:00 | NVDA | Stock | 0.2767 | 0.2777 | 0.275 | 0.2757 | 44623920.0 |
| 2005-09-19 10:00:00 | NVDA | Stock | 0.2757 | 0.2757 | 0.2739 | 0.2747 | 77071440.0 |
| 2005-09-19 10:30:00 | NVDA | Stock | 0.2747 | 0.2756 | 0.2737 | 0.2749 | 35507880.0 |
| 2005-09-19 11:00:00 | NVDA | Stock | 0.2748 | 0.2752 | 0.274 | 0.274 | 33024480.0 |
| 2005-09-19 11:30:00 | NVDA | Stock | 0.2741 | 0.2741 | 0.2721 | 0.2724 | 32743800.0 |
| 2005-09-19 12:00:00 | NVDA | Stock | 0.2725 | 0.2732 | 0.2723 | 0.2723 | 18718440.0 |
> showing 50 of 45,888 rows — these rows as CSV