PREVIEW / stock_1hour / 2022-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-30.parquet
  size:    1.4 MB
  rows:    63,213
  symbols: 2,418

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
2022-06-30 04:00:00	AAPL	Stock	138.11	139.1	137.04	137.22	57019.0
2022-06-30 05:00:00	AAPL	Stock	137.2	137.31	136.5	136.85	31551.0
2022-06-30 06:00:00	AAPL	Stock	136.9	136.97	136.6	136.8	22788.0
2022-06-30 07:00:00	AAPL	Stock	136.92	137.0	136.55	136.73	100000.0
2022-06-30 08:00:00	AAPL	Stock	136.8	137.82	136.6	137.02	548115.0
2022-06-30 09:00:00	AAPL	Stock	137.04	137.6	134.92	134.945	10017443.0
2022-06-30 10:00:00	AAPL	Stock	134.96	135.6	133.7737	135.5	12523918.0
2022-06-30 11:00:00	AAPL	Stock	135.51	137.68	135.22	137.385	10242012.0
2022-06-30 12:00:00	AAPL	Stock	137.385	138.37	136.486	137.715	8624794.0
2022-06-30 13:00:00	AAPL	Stock	137.72	138.12	136.87	137.97	6127759.0
2022-06-30 14:00:00	AAPL	Stock	137.97	138.15	136.48	136.6241	6735027.0
2022-06-30 15:00:00	AAPL	Stock	136.64	137.44	135.7	136.76	15023114.0
2022-06-30 16:00:00	AAPL	Stock	136.83	137.06	136.27	136.77	18359743.0
2022-06-30 17:00:00	AAPL	Stock	136.75	136.85	136.64	136.69	61141.0
2022-06-30 18:00:00	AAPL	Stock	136.67	136.67	136.2	136.55	47793.0
2022-06-30 19:00:00	AAPL	Stock	136.63	137.15	136.47	136.73	51946.0
2022-06-30 04:00:00	MSFT	Stock	258.49	258.49	255.97	256.1	49184.0
2022-06-30 05:00:00	MSFT	Stock	256.15	256.15	254.32	255.35	5929.0
2022-06-30 06:00:00	MSFT	Stock	255.3	255.7	254.99	255.7	3792.0
2022-06-30 07:00:00	MSFT	Stock	255.94	256.0	255.0	255.64	16105.0
2022-06-30 08:00:00	MSFT	Stock	255.7	258.67	255.0	256.0	61175.0
2022-06-30 09:00:00	MSFT	Stock	255.86	258.97	254.62	254.7	2023882.0
2022-06-30 10:00:00	MSFT	Stock	254.74	256.93	252.9	256.82	2820671.0
2022-06-30 11:00:00	MSFT	Stock	256.82	258.65	256.17	258.49	1810252.0
2022-06-30 12:00:00	MSFT	Stock	258.5	259.53	256.96	258.64	1669517.0
2022-06-30 13:00:00	MSFT	Stock	258.66	259.27	257.23	258.89	1080303.0
2022-06-30 14:00:00	MSFT	Stock	258.895	259.18	256.585	256.94	1487721.0
2022-06-30 15:00:00	MSFT	Stock	256.94	258.63	255.0	256.86	4885072.0
2022-06-30 16:00:00	MSFT	Stock	256.83	257.01	256.0	257.0	7747335.0
2022-06-30 17:00:00	MSFT	Stock	257.0	257.17	256.85	257.17	2957.0
2022-06-30 18:00:00	MSFT	Stock	256.8	256.97	256.0	256.5	9808.0
2022-06-30 19:00:00	MSFT	Stock	256.25	258.28	256.25	257.65	8144.0
2022-06-30 04:00:00	NVDA	Stock	15.389	15.389	15.144	15.235	264920.0
2022-06-30 05:00:00	NVDA	Stock	15.252	15.252	15.13	15.24	172070.0
2022-06-30 06:00:00	NVDA	Stock	15.229	15.25	15.17	15.199	195900.0
2022-06-30 07:00:00	NVDA	Stock	15.195	15.223	15.142	15.18	655370.0
2022-06-30 08:00:00	NVDA	Stock	15.175	15.454	15.141	15.282	2130890.0
2022-06-30 09:00:00	NVDA	Stock	15.272	15.4329	14.964	15.0244	82737360.0
2022-06-30 10:00:00	NVDA	Stock	15.0206	15.091	14.862	15.0848	96607230.0
2022-06-30 11:00:00	NVDA	Stock	15.084	15.469	15.051	15.424	82188600.0
2022-06-30 12:00:00	NVDA	Stock	15.4245	15.567	15.262	15.43	59178150.0
2022-06-30 13:00:00	NVDA	Stock	15.43	15.468	15.249	15.365	46675020.0
2022-06-30 14:00:00	NVDA	Stock	15.367	15.368	15.216	15.22	47354240.0
2022-06-30 15:00:00	NVDA	Stock	15.217	15.344	15.052	15.159	102153690.0
2022-06-30 16:00:00	NVDA	Stock	15.165	15.197	14.966	15.127	48615380.0
2022-06-30 17:00:00	NVDA	Stock	15.132	15.156	15.068	15.095	524160.0
2022-06-30 18:00:00	NVDA	Stock	15.088	15.1	15.058	15.071	432010.0
2022-06-30 19:00:00	NVDA	Stock	15.078	15.131	15.056	15.1	358640.0
2022-06-30 04:00:00	AMZN	Stock	107.98	108.38	107.07	107.13	19594.0
2022-06-30 05:00:00	AMZN	Stock	107.15	107.16	106.36	107.01	43434.0

> showing 50 of 63,213 rows — these rows as CSV

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