PREVIEW / stock_1hour / 2022-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-17.parquet
  size:    1.4 MB
  rows:    63,452
  symbols: 2,231

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-08-17 04:00:00	AAPL	Stock	173.8	173.8	172.67	172.79	36558.0
2022-08-17 05:00:00	AAPL	Stock	172.87	173.05	172.56	172.65	14666.0
2022-08-17 06:00:00	AAPL	Stock	172.61	172.69	172.25	172.49	24727.0
2022-08-17 07:00:00	AAPL	Stock	172.57	172.7	172.12	172.42	122961.0
2022-08-17 08:00:00	AAPL	Stock	172.6	173.47	172.13	172.7	574406.0
2022-08-17 09:00:00	AAPL	Stock	172.69	174.31	172.32	174.17	9431631.0
2022-08-17 10:00:00	AAPL	Stock	174.1696	174.45	173.08	173.175	9909348.0
2022-08-17 11:00:00	AAPL	Stock	173.18	173.995	173.08	173.3399	6173675.0
2022-08-17 12:00:00	AAPL	Stock	173.34	174.54	173.27	174.07	6002686.0
2022-08-17 13:00:00	AAPL	Stock	174.07	174.78	173.91	174.265	5907828.0
2022-08-17 14:00:00	AAPL	Stock	174.26	176.15	174.1	175.34	13815260.0
2022-08-17 15:00:00	AAPL	Stock	175.34	175.8	174.24	174.62	10713344.0
2022-08-17 16:00:00	AAPL	Stock	174.62	174.8	174.41	174.6286	4594543.0
2022-08-17 17:00:00	AAPL	Stock	174.6	174.6	173.61	173.88	358567.0
2022-08-17 18:00:00	AAPL	Stock	173.91	173.91	173.55	173.57	82168.0
2022-08-17 19:00:00	AAPL	Stock	173.56	173.6	173.2	173.2	121493.0
2022-08-17 04:00:00	MSFT	Stock	291.62	291.62	290.36	290.36	2812.0
2022-08-17 05:00:00	MSFT	Stock	290.77	290.95	290.06	290.07	1849.0
2022-08-17 06:00:00	MSFT	Stock	290.1	290.15	289.8	290.0	9807.0
2022-08-17 07:00:00	MSFT	Stock	290.39	290.5	289.4	289.65	15971.0
2022-08-17 08:00:00	MSFT	Stock	290.1027	291.36	289.0767	289.9	67731.0
2022-08-17 09:00:00	MSFT	Stock	289.94	292.35	289.22	292.08	1800920.0
2022-08-17 10:00:00	MSFT	Stock	292.09	292.47	290.16	290.55	1723652.0
2022-08-17 11:00:00	MSFT	Stock	290.57	291.73	290.21	290.51	1100821.0
2022-08-17 12:00:00	MSFT	Stock	290.52	291.83	290.48	291.51	756854.0
2022-08-17 13:00:00	MSFT	Stock	291.51	291.98	290.86	291.64	823684.0
2022-08-17 14:00:00	MSFT	Stock	291.65	293.35	291.33	292.15	1819857.0
2022-08-17 15:00:00	MSFT	Stock	292.15	292.69	290.7	291.3769	1959671.0
2022-08-17 16:00:00	MSFT	Stock	291.32	291.37	291.0331	291.32	2906277.0
2022-08-17 17:00:00	MSFT	Stock	291.1	291.13	290.81	290.9	3778.0
2022-08-17 18:00:00	MSFT	Stock	291.0	291.0	290.55	290.65	3150.0
2022-08-17 19:00:00	MSFT	Stock	290.35	290.47	290.19	290.37	4318.0
2022-08-17 04:00:00	NVDA	Stock	18.807	18.807	18.716	18.74	52130.0
2022-08-17 05:00:00	NVDA	Stock	18.729	18.76	18.7	18.7	41600.0
2022-08-17 06:00:00	NVDA	Stock	18.712	18.713	18.584	18.617	163070.0
2022-08-17 07:00:00	NVDA	Stock	18.617	18.67	18.5	18.59	449630.0
2022-08-17 08:00:00	NVDA	Stock	18.617	18.8319	18.487	18.522	1435070.0
2022-08-17 09:00:00	NVDA	Stock	18.534	18.688	18.377	18.474	54720430.0
2022-08-17 10:00:00	NVDA	Stock	18.473	18.526	18.192	18.2101	70569500.0
2022-08-17 11:00:00	NVDA	Stock	18.2101	18.337	18.15	18.198	52181770.0
2022-08-17 12:00:00	NVDA	Stock	18.2	18.3065	18.145	18.253	35383350.0
2022-08-17 13:00:00	NVDA	Stock	18.251	18.323	18.1944	18.257	26667190.0
2022-08-17 14:00:00	NVDA	Stock	18.2574	18.57	18.223	18.459	59859270.0
2022-08-17 15:00:00	NVDA	Stock	18.457	18.523	18.307	18.335	43850930.0
2022-08-17 16:00:00	NVDA	Stock	18.335	18.368	18.308	18.35	15882960.0
2022-08-17 17:00:00	NVDA	Stock	18.351	18.372	18.302	18.31	193360.0
2022-08-17 18:00:00	NVDA	Stock	18.302	18.306	18.22	18.252	392960.0
2022-08-17 19:00:00	NVDA	Stock	18.23	18.252	18.158	18.158	541330.0
2022-08-17 04:00:00	AMZN	Stock	144.6	144.6	143.73	143.73	6366.0
2022-08-17 05:00:00	AMZN	Stock	143.74	143.89	143.66	143.75	8298.0

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

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