PREVIEW / stock_1hour / 2021-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-07.parquet
  size:    1.4 MB
  rows:    65,175
  symbols: 2,869

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-07-07 04:00:00	AAPL	Stock	142.41	143.15	142.41	142.66	64290.0
2021-07-07 05:00:00	AAPL	Stock	142.7	143.04	142.7	142.85	13337.0
2021-07-07 06:00:00	AAPL	Stock	142.85	142.96	142.73	142.81	11394.0
2021-07-07 07:00:00	AAPL	Stock	142.78	143.24	142.75	143.2	213855.0
2021-07-07 08:00:00	AAPL	Stock	142.9	143.4	142.82	143.4	631408.0
2021-07-07 09:00:00	AAPL	Stock	143.39	144.44	142.66	144.14	18634770.0
2021-07-07 10:00:00	AAPL	Stock	144.15	144.5	142.84	143.44	18836711.0
2021-07-07 11:00:00	AAPL	Stock	143.43	144.26	142.87	143.91	9746604.0
2021-07-07 12:00:00	AAPL	Stock	143.91	144.1	143.72	143.95	5791502.0
2021-07-07 13:00:00	AAPL	Stock	143.945	144.4	143.56	144.36	7493827.0
2021-07-07 14:00:00	AAPL	Stock	144.37	144.89	144.08	144.355	11845713.0
2021-07-07 15:00:00	AAPL	Stock	144.3501	144.68	144.24	144.59	11741812.0
2021-07-07 16:00:00	AAPL	Stock	144.57	144.86	144.53	144.71	9497250.0
2021-07-07 17:00:00	AAPL	Stock	144.715	144.72	144.54	144.59	75502.0
2021-07-07 18:00:00	AAPL	Stock	144.59	144.72	144.57	144.72	64223.0
2021-07-07 19:00:00	AAPL	Stock	144.71	144.8	144.65	144.76	79495.0
2021-07-07 04:00:00	MSFT	Stock	279.29	279.29	278.34	278.89	10080.0
2021-07-07 05:00:00	MSFT	Stock	278.98	279.2	278.98	279.2	2424.0
2021-07-07 06:00:00	MSFT	Stock	279.16	279.25	278.71	279.25	5966.0
2021-07-07 07:00:00	MSFT	Stock	279.03	279.34	278.82	279.0	27545.0
2021-07-07 08:00:00	MSFT	Stock	279.09	279.3499	278.67	278.87	41768.0
2021-07-07 09:00:00	MSFT	Stock	278.99	279.95	278.1	279.1	2443271.0
2021-07-07 10:00:00	MSFT	Stock	279.11	280.5	278.52	279.24	3853392.0
2021-07-07 11:00:00	MSFT	Stock	279.24	279.98	277.15	279.69	1861155.0
2021-07-07 12:00:00	MSFT	Stock	279.705	280.24	279.52	279.985	1446933.0
2021-07-07 13:00:00	MSFT	Stock	279.985	280.14	279.36	279.87	1274262.0
2021-07-07 14:00:00	MSFT	Stock	279.895	280.6945	279.78	280.28	1728778.0
2021-07-07 15:00:00	MSFT	Stock	280.29	280.5	279.7	280.0	2346365.0
2021-07-07 16:00:00	MSFT	Stock	279.93	280.14	279.93	280.1	2926255.0
2021-07-07 17:00:00	MSFT	Stock	280.0	280.1	280.0	280.0999	835.0
2021-07-07 18:00:00	MSFT	Stock	280.0	280.12	280.0	280.06	2723.0
2021-07-07 19:00:00	MSFT	Stock	280.0	280.4	280.0	280.4	17547.0
2021-07-07 04:00:00	NVDA	Stock	20.785	20.827	20.785	20.8	59160.0
2021-07-07 05:00:00	NVDA	Stock	20.8375	20.8413	20.8375	20.8413	17920.0
2021-07-07 06:00:00	NVDA	Stock	20.8175	20.8213	20.8175	20.8188	20800.0
2021-07-07 07:00:00	NVDA	Stock	20.825	20.9188	20.825	20.8748	765360.0
2021-07-07 08:00:00	NVDA	Stock	20.8568	20.925	20.825	20.8625	1642240.0
2021-07-07 09:00:00	NVDA	Stock	20.8658	20.875	20.4652	20.57	57423440.0
2021-07-07 10:00:00	NVDA	Stock	20.569	20.6187	20.3321	20.5028	59752280.0
2021-07-07 11:00:00	NVDA	Stock	20.5015	20.5355	20.3692	20.5164	29152440.0
2021-07-07 12:00:00	NVDA	Stock	20.5275	20.5766	20.4436	20.4535	21110680.0
2021-07-07 13:00:00	NVDA	Stock	20.4562	20.4822	20.3945	20.4575	15793920.0
2021-07-07 14:00:00	NVDA	Stock	20.4535	20.5315	20.3968	20.5186	20224440.0
2021-07-07 15:00:00	NVDA	Stock	20.518	20.5281	20.3588	20.3715	28924280.0
2021-07-07 16:00:00	NVDA	Stock	20.3718	20.3748	20.3653	20.3653	28926000.0
2021-07-07 17:00:00	NVDA	Stock	20.367	20.3688	20.3538	20.3625	190640.0
2021-07-07 18:00:00	NVDA	Stock	20.353	20.37	20.353	20.37	60280.0
2021-07-07 19:00:00	NVDA	Stock	20.3675	20.37	20.355	20.36	180440.0
2021-07-07 04:00:00	AMZN	Stock	185.1	185.1	185.1	185.1	4480.0
2021-07-07 05:00:00	AMZN	Stock	184.9975	185.3475	184.9975	185.15	26220.0

> showing 50 of 65,175 rows — these rows as CSV

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