PREVIEW / stock_1hour / 2023-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-06-21.parquet
  size:    1.3 MB
  rows:    59,983
  symbols: 1,604

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
2023-06-21 04:00:00	AAPL	Stock	184.75	184.83	184.7	184.71	5901.0
2023-06-21 05:00:00	AAPL	Stock	184.79	184.8	184.7	184.8	1106.0
2023-06-21 06:00:00	AAPL	Stock	184.7	184.78	184.7	184.72	3028.0
2023-06-21 07:00:00	AAPL	Stock	184.81	184.88	184.5	184.7	35116.0
2023-06-21 08:00:00	AAPL	Stock	184.7015	185.1	183.93	184.32	245111.0
2023-06-21 09:00:00	AAPL	Stock	184.34	185.41	183.88	184.11	5594819.0
2023-06-21 10:00:00	AAPL	Stock	184.1	184.41	183.2	183.495	5814955.0
2023-06-21 11:00:00	AAPL	Stock	183.5	183.82	182.5901	183.26	5169630.0
2023-06-21 12:00:00	AAPL	Stock	183.2531	184.34	183.14	184.24	3735029.0
2023-06-21 13:00:00	AAPL	Stock	184.23	184.65	183.97	184.585	2499638.0
2023-06-21 14:00:00	AAPL	Stock	184.595	185.1992	184.43	184.9	3220790.0
2023-06-21 15:00:00	AAPL	Stock	184.905	184.91	183.79	183.96	5456484.0
2023-06-21 16:00:00	AAPL	Stock	183.95	184.05	183.7	183.7815	10019926.0
2023-06-21 17:00:00	AAPL	Stock	183.7811	183.96	183.7	183.7	39671.0
2023-06-21 18:00:00	AAPL	Stock	183.76	183.85	183.6359	183.71	22584.0
2023-06-21 19:00:00	AAPL	Stock	183.7	183.85	183.65	183.67	11110.0
2023-06-21 04:00:00	MSFT	Stock	337.49	337.6	337.3	337.53	1819.0
2023-06-21 05:00:00	MSFT	Stock	337.29	337.49	337.29	337.49	217.0
2023-06-21 06:00:00	MSFT	Stock	337.29	337.36	337.03	337.06	4776.0
2023-06-21 07:00:00	MSFT	Stock	337.49	337.49	336.26	336.6	12080.0
2023-06-21 08:00:00	MSFT	Stock	336.7	338.5	336.0101	336.66	26423.0
2023-06-21 09:00:00	MSFT	Stock	336.69	337.73	334.32	335.17	2115041.0
2023-06-21 10:00:00	MSFT	Stock	335.14	335.34	333.07	334.042	2429340.0
2023-06-21 11:00:00	MSFT	Stock	334.04	334.15	332.07	332.4291	1949068.0
2023-06-21 12:00:00	MSFT	Stock	332.49	334.57	332.33	334.23	1467051.0
2023-06-21 13:00:00	MSFT	Stock	334.19	334.48	333.55	334.35	928003.0
2023-06-21 14:00:00	MSFT	Stock	334.36	335.78	334.1601	334.82	1104980.0
2023-06-21 15:00:00	MSFT	Stock	334.835	334.89	333.16	333.57	1970399.0
2023-06-21 16:00:00	MSFT	Stock	333.56	334.09	333.56	333.85	5269583.0
2023-06-21 17:00:00	MSFT	Stock	333.77	334.0999	333.56	333.9	25179.0
2023-06-21 18:00:00	MSFT	Stock	334.1	334.44	333.96	334.23	16490.0
2023-06-21 19:00:00	MSFT	Stock	334.3	335.15	334.3	334.75	4247.0
2023-06-21 04:00:00	NVDA	Stock	43.774	43.982	43.659	43.84	142810.0
2023-06-21 05:00:00	NVDA	Stock	43.826	43.85	43.73	43.81	85220.0
2023-06-21 06:00:00	NVDA	Stock	43.79	43.82	43.66	43.67	91930.0
2023-06-21 07:00:00	NVDA	Stock	43.67	43.803	43.588	43.6	547310.0
2023-06-21 08:00:00	NVDA	Stock	43.722	43.894	43.411	43.467	2160780.0
2023-06-21 09:00:00	NVDA	Stock	43.4629	43.615	42.6135	42.63	55185750.0
2023-06-21 10:00:00	NVDA	Stock	42.63	42.791	42.136	42.218	86231410.0
2023-06-21 11:00:00	NVDA	Stock	42.215	42.823	42.08	42.386	63396730.0
2023-06-21 12:00:00	NVDA	Stock	42.387	42.979	42.3772	42.7841	45832200.0
2023-06-21 13:00:00	NVDA	Stock	42.784	43.028	42.626	43.013	34037530.0
2023-06-21 14:00:00	NVDA	Stock	43.012	43.409	42.903	43.369	47168390.0
2023-06-21 15:00:00	NVDA	Stock	43.369	43.467	43.001	43.043	64049160.0
2023-06-21 16:00:00	NVDA	Stock	43.038	43.06	42.75	42.796	23501450.0
2023-06-21 17:00:00	NVDA	Stock	42.8	42.849	42.76	42.766	496580.0
2023-06-21 18:00:00	NVDA	Stock	42.78	42.83	42.567	42.68	1166310.0
2023-06-21 19:00:00	NVDA	Stock	42.67	42.822	42.67	42.8	547970.0
2023-06-21 04:00:00	AMZN	Stock	125.6	125.74	125.26	125.5	9870.0
2023-06-21 05:00:00	AMZN	Stock	125.46	125.74	125.46	125.74	2767.0

> showing 50 of 59,983 rows — these rows as CSV

> unlock the full archive -- $79 one-time