PREVIEW / stock_1hour / 2022-07-11

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-07-11.parquet
  size:    1.3 MB
  rows:    60,887
  symbols: 2,299

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-11 04:00:00	AAPL	Stock	145.98	145.98	145.3	145.63	29328.0
2022-07-11 05:00:00	AAPL	Stock	145.63	146.05	145.62	145.86	34337.0
2022-07-11 06:00:00	AAPL	Stock	145.87	146.19	145.82	145.98	23879.0
2022-07-11 07:00:00	AAPL	Stock	146.0	146.2	145.82	145.82	67609.0
2022-07-11 08:00:00	AAPL	Stock	146.1097	146.673	145.5	145.99	157176.0
2022-07-11 09:00:00	AAPL	Stock	146.0301	146.13	143.78	144.32	7405172.0
2022-07-11 10:00:00	AAPL	Stock	144.3111	145.625	144.04	145.065	7955718.0
2022-07-11 11:00:00	AAPL	Stock	145.06	145.66	144.91	145.15	5424672.0
2022-07-11 12:00:00	AAPL	Stock	145.15	145.64	145.0	145.485	3720133.0
2022-07-11 13:00:00	AAPL	Stock	145.48	146.64	145.44	146.415	5036252.0
2022-07-11 14:00:00	AAPL	Stock	146.4179	146.465	145.32	145.32	4676308.0
2022-07-11 15:00:00	AAPL	Stock	145.32	145.46	144.4	144.905	9796297.0
2022-07-11 16:00:00	AAPL	Stock	144.9	145.15	144.74	145.0	7343941.0
2022-07-11 17:00:00	AAPL	Stock	145.0	145.0	144.87	144.9866	16033.0
2022-07-11 18:00:00	AAPL	Stock	145.0	145.0	144.71	144.77	128117.0
2022-07-11 19:00:00	AAPL	Stock	144.71	145.11	144.71	145.11	20235.0
2022-07-11 04:00:00	MSFT	Stock	265.3	265.69	265.22	265.5	4595.0
2022-07-11 05:00:00	MSFT	Stock	265.77	265.88	265.61	265.61	2374.0
2022-07-11 06:00:00	MSFT	Stock	265.9	266.0	265.73	265.89	3892.0
2022-07-11 07:00:00	MSFT	Stock	265.97	266.35	265.32	265.5	7108.0
2022-07-11 08:00:00	MSFT	Stock	266.3654	266.991	265.0312	265.5355	36387.0
2022-07-11 09:00:00	MSFT	Stock	265.76	265.9578	262.18	262.56	1499130.0
2022-07-11 10:00:00	MSFT	Stock	262.54	265.13	262.25	264.0198	1855359.0
2022-07-11 11:00:00	MSFT	Stock	264.0	265.01	263.89	264.7178	1303702.0
2022-07-11 12:00:00	MSFT	Stock	264.72	265.39	264.39	264.85	939647.0
2022-07-11 13:00:00	MSFT	Stock	264.85	266.53	264.8001	266.07	975916.0
2022-07-11 14:00:00	MSFT	Stock	266.0992	266.1077	264.66	264.66	898709.0
2022-07-11 15:00:00	MSFT	Stock	264.65	264.94	263.89	264.54	2353187.0
2022-07-11 16:00:00	MSFT	Stock	264.62	264.9464	264.46	264.55	3555456.0
2022-07-11 17:00:00	MSFT	Stock	264.55	264.69	264.5	264.5	1418.0
2022-07-11 18:00:00	MSFT	Stock	264.35	264.64	264.28	264.3	56056.0
2022-07-11 19:00:00	MSFT	Stock	264.03	264.74	264.03	264.74	3142.0
2022-07-11 04:00:00	NVDA	Stock	15.825	15.825	15.512	15.585	174590.0
2022-07-11 05:00:00	NVDA	Stock	15.56	15.582	15.56	15.575	19800.0
2022-07-11 06:00:00	NVDA	Stock	15.563	15.6	15.55	15.55	145350.0
2022-07-11 07:00:00	NVDA	Stock	15.55	15.598	15.532	15.542	391060.0
2022-07-11 08:00:00	NVDA	Stock	15.567	15.597	15.5332	15.59	617610.0
2022-07-11 09:00:00	NVDA	Stock	15.592	15.624	15.038	15.148	61917380.0
2022-07-11 10:00:00	NVDA	Stock	15.148	15.308	15.054	15.171	69677480.0
2022-07-11 11:00:00	NVDA	Stock	15.17	15.285	15.134	15.1833	39616000.0
2022-07-11 12:00:00	NVDA	Stock	15.183	15.277	15.142	15.234	26369250.0
2022-07-11 13:00:00	NVDA	Stock	15.232	15.3709	15.23	15.3265	35689770.0
2022-07-11 14:00:00	NVDA	Stock	15.328	15.335	15.147	15.15	33284250.0
2022-07-11 15:00:00	NVDA	Stock	15.1505	15.196	15.079	15.154	51697630.0
2022-07-11 16:00:00	NVDA	Stock	15.152	15.2114	15.102	15.142	21225840.0
2022-07-11 17:00:00	NVDA	Stock	15.1353	15.152	15.135	15.152	105320.0
2022-07-11 18:00:00	NVDA	Stock	15.145	15.169	15.138	15.139	399060.0
2022-07-11 19:00:00	NVDA	Stock	15.135	15.151	15.091	15.118	442590.0
2022-07-11 04:00:00	AMZN	Stock	114.45	114.81	114.2	114.46	17095.0
2022-07-11 05:00:00	AMZN	Stock	114.55	114.65	114.5	114.57	12012.0

> showing 50 of 60,887 rows — these rows as CSV

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