PREVIEW / stock_1hour / 2022-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-16.parquet
  size:    1.4 MB
  rows:    62,430
  symbols: 2,184

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-09-16 04:00:00	AAPL	Stock	151.35	151.55	150.53	150.82	49623.0
2022-09-16 05:00:00	AAPL	Stock	150.84	150.93	150.72	150.89	15055.0
2022-09-16 06:00:00	AAPL	Stock	150.84	151.42	150.63	151.39	42329.0
2022-09-16 07:00:00	AAPL	Stock	151.39	151.4	150.78	151.04	108332.0
2022-09-16 08:00:00	AAPL	Stock	151.12	151.2	150.16	150.18	404838.0
2022-09-16 09:00:00	AAPL	Stock	150.2	151.53	148.37	148.49	27773774.0
2022-09-16 10:00:00	AAPL	Stock	148.49	150.53	148.47	148.995	16631937.0
2022-09-16 11:00:00	AAPL	Stock	148.99	149.96	148.73	149.86	8803167.0
2022-09-16 12:00:00	AAPL	Stock	149.87	149.915	148.66	149.41	7246324.0
2022-09-16 13:00:00	AAPL	Stock	149.405	149.91	149.02	149.325	6421654.0
2022-09-16 14:00:00	AAPL	Stock	149.33	150.81	149.26	150.51	9306272.0
2022-09-16 15:00:00	AAPL	Stock	150.5	151.35	150.3	150.44	17224431.0
2022-09-16 16:00:00	AAPL	Stock	150.44	150.96	150.44	150.96	50781292.0
2022-09-16 17:00:00	AAPL	Stock	150.9	150.98	150.63	150.94	111235.0
2022-09-16 18:00:00	AAPL	Stock	150.97	151.18	150.92	151.11	65686.0
2022-09-16 19:00:00	AAPL	Stock	151.1	151.3	151.1	151.3	29055.0
2022-09-16 04:00:00	MSFT	Stock	243.72	243.72	242.89	243.14	12382.0
2022-09-16 05:00:00	MSFT	Stock	243.2	243.56	243.05	243.56	4420.0
2022-09-16 06:00:00	MSFT	Stock	243.1	243.86	243.0	243.86	9349.0
2022-09-16 07:00:00	MSFT	Stock	243.62	243.62	243.07	243.45	18748.0
2022-09-16 08:00:00	MSFT	Stock	243.4287	243.79	242.65	242.81	51989.0
2022-09-16 09:00:00	MSFT	Stock	242.8	244.97	242.1	242.68	9387987.0
2022-09-16 10:00:00	MSFT	Stock	242.72	244.58	242.42	242.42	3165201.0
2022-09-16 11:00:00	MSFT	Stock	242.455	244.28	242.41	244.1565	2240179.0
2022-09-16 12:00:00	MSFT	Stock	244.19	244.22	242.37	243.21	1629255.0
2022-09-16 13:00:00	MSFT	Stock	243.18	243.36	242.16	242.44	1658694.0
2022-09-16 14:00:00	MSFT	Stock	242.435	244.2	242.0627	243.711	2071427.0
2022-09-16 15:00:00	MSFT	Stock	243.7	245.3	243.62	244.75	4778004.0
2022-09-16 16:00:00	MSFT	Stock	244.74	245.19	244.74	245.04	7487715.0
2022-09-16 17:00:00	MSFT	Stock	245.04	245.15	244.74	245.15	26176.0
2022-09-16 18:00:00	MSFT	Stock	245.06	245.12	245.0	245.07	5185.0
2022-09-16 19:00:00	MSFT	Stock	245.11	245.47	245.07	245.47	3457.0
2022-09-16 04:00:00	NVDA	Stock	12.81	12.81	12.66	12.718	330100.0
2022-09-16 05:00:00	NVDA	Stock	12.719	12.724	12.671	12.7	104160.0
2022-09-16 06:00:00	NVDA	Stock	12.691	12.757	12.684	12.751	92550.0
2022-09-16 07:00:00	NVDA	Stock	12.75	12.75	12.706	12.728	206590.0
2022-09-16 08:00:00	NVDA	Stock	12.7135	12.7501	12.675	12.682	1467180.0
2022-09-16 09:00:00	NVDA	Stock	12.69	12.82	12.617	12.734	82708180.0
2022-09-16 10:00:00	NVDA	Stock	12.74	13.118	12.725	12.8979	104686180.0
2022-09-16 11:00:00	NVDA	Stock	12.897	12.953	12.806	12.949	58063190.0
2022-09-16 12:00:00	NVDA	Stock	12.953	12.988	12.802	12.9855	48984830.0
2022-09-16 13:00:00	NVDA	Stock	12.986	13.015	12.892	12.936	45182800.0
2022-09-16 14:00:00	NVDA	Stock	12.938	13.129	12.931	13.0909	54845530.0
2022-09-16 15:00:00	NVDA	Stock	13.088	13.212	13.009	13.199	96380500.0
2022-09-16 16:00:00	NVDA	Stock	13.198	13.202	13.165	13.198	64434150.0
2022-09-16 17:00:00	NVDA	Stock	13.2	13.218	13.1832	13.218	573040.0
2022-09-16 18:00:00	NVDA	Stock	13.215	13.249	13.212	13.245	344680.0
2022-09-16 19:00:00	NVDA	Stock	13.245	13.25	13.216	13.249	251460.0
2022-09-16 04:00:00	AMZN	Stock	123.45	123.45	122.55	122.86	28092.0
2022-09-16 05:00:00	AMZN	Stock	122.86	122.94	122.75	122.9	12279.0

> showing 50 of 62,430 rows — these rows as CSV

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