PREVIEW / stock_1hour / 2022-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-07.parquet
  size:    1.4 MB
  rows:    61,579
  symbols: 2,324

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-07-07 04:00:00	AAPL	Stock	143.15	143.66	143.15	143.6	43289.0
2022-07-07 05:00:00	AAPL	Stock	143.47	143.49	143.04	143.07	11411.0
2022-07-07 06:00:00	AAPL	Stock	143.13	143.3	142.8	143.21	15113.0
2022-07-07 07:00:00	AAPL	Stock	143.22	143.56	143.15	143.56	41612.0
2022-07-07 08:00:00	AAPL	Stock	143.25	143.57	142.563	143.32	266473.0
2022-07-07 09:00:00	AAPL	Stock	143.3599	145.401	142.95	145.23	9804213.0
2022-07-07 10:00:00	AAPL	Stock	145.225	145.99	144.91	145.3599	10312097.0
2022-07-07 11:00:00	AAPL	Stock	145.36	145.66	145.01	145.55	5327963.0
2022-07-07 12:00:00	AAPL	Stock	145.545	145.99	145.45	145.89	4768379.0
2022-07-07 13:00:00	AAPL	Stock	145.895	146.49	145.53	146.36	4988956.0
2022-07-07 14:00:00	AAPL	Stock	146.355	146.55	146.0101	146.1953	4684649.0
2022-07-07 15:00:00	AAPL	Stock	146.2	146.55	146.11	146.35	10410676.0
2022-07-07 16:00:00	AAPL	Stock	146.34	146.4	146.04	146.07	8178222.0
2022-07-07 17:00:00	AAPL	Stock	146.02	146.33	145.95	146.1	43413.0
2022-07-07 18:00:00	AAPL	Stock	146.06	146.11	145.86	145.99	23072.0
2022-07-07 19:00:00	AAPL	Stock	145.99	146.07	145.83	145.9	30319.0
2022-07-07 04:00:00	MSFT	Stock	267.58	267.7	266.98	267.7	616.0
2022-07-07 05:00:00	MSFT	Stock	267.03	267.65	265.81	266.0	2480.0
2022-07-07 06:00:00	MSFT	Stock	266.05	266.3	265.63	266.3	1327.0
2022-07-07 07:00:00	MSFT	Stock	266.79	267.17	266.41	266.95	7287.0
2022-07-07 08:00:00	MSFT	Stock	266.7999	267.35	265.545	266.41	39951.0
2022-07-07 09:00:00	MSFT	Stock	266.45	268.155	264.84	267.711	1996546.0
2022-07-07 10:00:00	MSFT	Stock	267.78	269.055	266.865	268.0712	2068914.0
2022-07-07 11:00:00	MSFT	Stock	268.1	268.56	267.05	268.03	1319117.0
2022-07-07 12:00:00	MSFT	Stock	268.01	268.08	267.37	267.69	1085270.0
2022-07-07 13:00:00	MSFT	Stock	267.7	268.07	267.26	268.05	964085.0
2022-07-07 14:00:00	MSFT	Stock	268.06	268.3604	267.64	267.8235	1134236.0
2022-07-07 15:00:00	MSFT	Stock	267.83	268.98	267.73	268.38	3023959.0
2022-07-07 16:00:00	MSFT	Stock	268.4	268.4	267.73	267.73	4079084.0
2022-07-07 17:00:00	MSFT	Stock	267.9	268.0	267.76	267.98	5926.0
2022-07-07 18:00:00	MSFT	Stock	267.75	267.85	267.62	267.62	2482.0
2022-07-07 19:00:00	MSFT	Stock	267.53	267.78	267.52	267.65	5486.0
2022-07-07 04:00:00	NVDA	Stock	15.31	15.4	15.235	15.4	320340.0
2022-07-07 05:00:00	NVDA	Stock	15.367	15.42	15.35	15.35	90070.0
2022-07-07 06:00:00	NVDA	Stock	15.354	15.38	15.353	15.378	30810.0
2022-07-07 07:00:00	NVDA	Stock	15.355	15.387	15.326	15.385	274300.0
2022-07-07 08:00:00	NVDA	Stock	15.3759	15.45	15.327	15.42	1648960.0
2022-07-07 09:00:00	NVDA	Stock	15.423	15.664	15.389	15.581	71901980.0
2022-07-07 10:00:00	NVDA	Stock	15.5758	15.669	15.455	15.624	86118560.0
2022-07-07 11:00:00	NVDA	Stock	15.625	15.755	15.5726	15.751	61500510.0
2022-07-07 12:00:00	NVDA	Stock	15.7505	15.8238	15.713	15.7932	45839930.0
2022-07-07 13:00:00	NVDA	Stock	15.793	15.883	15.764	15.879	29073580.0
2022-07-07 14:00:00	NVDA	Stock	15.879	15.945	15.836	15.8913	38479330.0
2022-07-07 15:00:00	NVDA	Stock	15.892	15.9197	15.808	15.866	60656910.0
2022-07-07 16:00:00	NVDA	Stock	15.868	15.8778	15.802	15.803	19757680.0
2022-07-07 17:00:00	NVDA	Stock	15.813	15.815	15.801	15.806	250070.0
2022-07-07 18:00:00	NVDA	Stock	15.803	15.813	15.78	15.787	283790.0
2022-07-07 19:00:00	NVDA	Stock	15.786	15.787	15.76	15.787	329000.0
2022-07-07 04:00:00	AMZN	Stock	114.67	115.15	114.62	114.99	16265.0
2022-07-07 05:00:00	AMZN	Stock	114.78	114.9	114.51	114.51	3225.0

> showing 50 of 61,579 rows — these rows as CSV

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