PREVIEW / stock_1hour / 2021-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-29.parquet
  size:    1.4 MB
  rows:    66,366
  symbols: 2,918

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
2021-06-29 04:00:00	AAPL	Stock	134.62	134.65	134.21	134.28	7592.0
2021-06-29 05:00:00	AAPL	Stock	134.39	134.5	134.35	134.5	2673.0
2021-06-29 06:00:00	AAPL	Stock	134.5	134.57	134.46	134.57	3567.0
2021-06-29 07:00:00	AAPL	Stock	134.59	134.75	134.45	134.52	44355.0
2021-06-29 08:00:00	AAPL	Stock	134.65	134.72	134.444	134.57	187938.0
2021-06-29 09:00:00	AAPL	Stock	134.58	135.62	134.35	135.47	9171459.0
2021-06-29 10:00:00	AAPL	Stock	135.47	136.08	135.2	136.0043	9840090.0
2021-06-29 11:00:00	AAPL	Stock	136.0025	136.17	135.78	136.03	6898033.0
2021-06-29 12:00:00	AAPL	Stock	136.04	136.475	136.005	136.43	5563964.0
2021-06-29 13:00:00	AAPL	Stock	136.43	136.49	136.11	136.385	4306993.0
2021-06-29 14:00:00	AAPL	Stock	136.38	136.48	136.09	136.4422	5035536.0
2021-06-29 15:00:00	AAPL	Stock	136.445	136.48	136.16	136.33	8612550.0
2021-06-29 16:00:00	AAPL	Stock	136.3201	136.47	136.25	136.42	3731917.0
2021-06-29 17:00:00	AAPL	Stock	136.41	136.44	136.33	136.35	30376.0
2021-06-29 18:00:00	AAPL	Stock	136.35	136.4	136.27	136.29	68606.0
2021-06-29 19:00:00	AAPL	Stock	136.29	136.42	136.28	136.42	61590.0
2021-06-29 04:00:00	MSFT	Stock	268.46	268.6	268.16	268.6	5595.0
2021-06-29 05:00:00	MSFT	Stock	268.6	268.91	268.6	268.91	1050.0
2021-06-29 06:00:00	MSFT	Stock	268.9	268.93	268.8	268.93	345.0
2021-06-29 07:00:00	MSFT	Stock	269.08	269.19	268.6	268.6	4209.0
2021-06-29 08:00:00	MSFT	Stock	268.97	269.391	268.32	268.62	16537.0
2021-06-29 09:00:00	MSFT	Stock	268.595	269.89	267.98	269.37	2056250.0
2021-06-29 10:00:00	MSFT	Stock	269.37	269.9	268.995	269.76	1830468.0
2021-06-29 11:00:00	MSFT	Stock	269.76	269.94	269.3601	269.84	1167034.0
2021-06-29 12:00:00	MSFT	Stock	269.85	271.02	269.74	270.91	1672474.0
2021-06-29 13:00:00	MSFT	Stock	270.9	271.14	270.73	271.13	1163124.0
2021-06-29 14:00:00	MSFT	Stock	271.13	271.58	271.06	271.5601	1585844.0
2021-06-29 15:00:00	MSFT	Stock	271.57	271.65	271.195	271.4	2937181.0
2021-06-29 16:00:00	MSFT	Stock	271.4	271.75	270.7	271.14	2288574.0
2021-06-29 17:00:00	MSFT	Stock	271.1	271.27	271.1	271.27	532.0
2021-06-29 18:00:00	MSFT	Stock	271.27	271.27	270.08	270.7	17316.0
2021-06-29 19:00:00	MSFT	Stock	270.7	271.39	270.7	271.38	5790.0
2021-06-29 04:00:00	NVDA	Stock	19.9725	20.0	19.9725	20.0	35040.0
2021-06-29 05:00:00	NVDA	Stock	20.015	20.07	20.015	20.0525	42960.0
2021-06-29 06:00:00	NVDA	Stock	20.047	20.0572	20.047	20.05	49920.0
2021-06-29 07:00:00	NVDA	Stock	20.0388	20.0388	19.8225	19.87	1477080.0
2021-06-29 08:00:00	NVDA	Stock	19.922	19.9375	19.8188	19.868	1610200.0
2021-06-29 09:00:00	NVDA	Stock	19.8533	19.9988	19.7528	19.8006	47869680.0
2021-06-29 10:00:00	NVDA	Stock	19.8022	19.9453	19.6569	19.8737	49630120.0
2021-06-29 11:00:00	NVDA	Stock	19.8732	19.8894	19.7528	19.8708	25073240.0
2021-06-29 12:00:00	NVDA	Stock	19.8708	19.9295	19.8233	19.8778	17760080.0
2021-06-29 13:00:00	NVDA	Stock	19.8785	19.8964	19.8118	19.863	11341960.0
2021-06-29 14:00:00	NVDA	Stock	19.8602	19.8885	19.8135	19.888	13266040.0
2021-06-29 15:00:00	NVDA	Stock	19.891	20.0988	19.8792	20.0342	51879560.0
2021-06-29 16:00:00	NVDA	Stock	20.0268	20.0488	20.0098	20.0098	9877640.0
2021-06-29 17:00:00	NVDA	Stock	20.0102	20.0282	20.01	20.0282	196240.0
2021-06-29 18:00:00	NVDA	Stock	20.0255	20.0338	20.02	20.025	95320.0
2021-06-29 19:00:00	NVDA	Stock	20.025	20.0462	20.0175	20.0375	415440.0
2021-06-29 07:00:00	AMZN	Stock	172.45	172.45	172.15	172.156	15120.0
2021-06-29 08:00:00	AMZN	Stock	172.05	172.174	172.05	172.1305	55380.0

> showing 50 of 66,366 rows — these rows as CSV

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