PREVIEW / stock_1hour / 2020-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-04-13.parquet
  size:    1.2 MB
  rows:    54,633
  symbols: 2,382

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
2020-04-13 04:00:00	AAPL	Stock	66.375	66.45	66.125	66.125	18004.0
2020-04-13 05:00:00	AAPL	Stock	66.5125	66.625	66.425	66.4525	3612.0
2020-04-13 06:00:00	AAPL	Stock	66.5	66.605	66.475	66.605	4672.0
2020-04-13 07:00:00	AAPL	Stock	66.6	67.0375	66.475	67.0	301116.0
2020-04-13 08:00:00	AAPL	Stock	66.7032	67.275	66.5625	67.0825	515948.0
2020-04-13 09:00:00	AAPL	Stock	67.0132	67.43	66.7525	66.825	13944300.0
2020-04-13 10:00:00	AAPL	Stock	66.8325	67.286	66.6375	66.705	14413396.0
2020-04-13 11:00:00	AAPL	Stock	66.7025	67.25	66.4575	66.9525	14808380.0
2020-04-13 12:00:00	AAPL	Stock	66.9525	67.275	66.9025	67.0945	9963548.0
2020-04-13 13:00:00	AAPL	Stock	67.09	67.395	66.8525	67.366	7536708.0
2020-04-13 14:00:00	AAPL	Stock	67.3675	67.5	67.1875	67.47	10947564.0
2020-04-13 15:00:00	AAPL	Stock	67.465	68.425	67.2305	68.3075	26713832.0
2020-04-13 16:00:00	AAPL	Stock	68.3072	68.3525	68.185	68.3475	7090220.0
2020-04-13 17:00:00	AAPL	Stock	68.335	68.3875	68.2775	68.3875	123588.0
2020-04-13 18:00:00	AAPL	Stock	68.3875	68.695	68.385	68.6325	182728.0
2020-04-13 19:00:00	AAPL	Stock	68.65	68.7375	68.575	68.6625	172420.0
2020-04-13 04:00:00	MSFT	Stock	163.84	163.84	163.0	163.21	3286.0
2020-04-13 05:00:00	MSFT	Stock	163.38	163.79	163.0	163.79	3165.0
2020-04-13 06:00:00	MSFT	Stock	163.83	164.13	163.41	164.08	2394.0
2020-04-13 07:00:00	MSFT	Stock	163.95	164.9	163.5	164.73	41991.0
2020-04-13 08:00:00	MSFT	Stock	164.0	165.14	163.5	164.6	76116.0
2020-04-13 09:00:00	MSFT	Stock	164.75	165.5	163.35	163.555	5105431.0
2020-04-13 10:00:00	MSFT	Stock	163.58	164.55	162.89	163.37	5267843.0
2020-04-13 11:00:00	MSFT	Stock	163.36	163.4	162.3	163.004	4063702.0
2020-04-13 12:00:00	MSFT	Stock	163.01	163.49	162.53	162.71	3403219.0
2020-04-13 13:00:00	MSFT	Stock	162.72	163.58	162.48	163.265	3102881.0
2020-04-13 14:00:00	MSFT	Stock	163.245	163.69	162.5	163.14	3551179.0
2020-04-13 15:00:00	MSFT	Stock	163.13	165.57	162.6	165.51	7451920.0
2020-04-13 16:00:00	MSFT	Stock	165.51	165.7	165.15	165.66	4530323.0
2020-04-13 17:00:00	MSFT	Stock	165.62	165.89	165.51	165.82	25680.0
2020-04-13 18:00:00	MSFT	Stock	165.9	166.47	165.8	166.14	38394.0
2020-04-13 19:00:00	MSFT	Stock	166.2	166.49	166.18	166.19	42396.0
2020-04-13 04:00:00	NVDA	Stock	6.5008	6.5008	6.462	6.475	37800.0
2020-04-13 07:00:00	NVDA	Stock	6.527	6.5513	6.4752	6.535	942320.0
2020-04-13 08:00:00	NVDA	Stock	6.5455	6.569	6.5025	6.5275	1290040.0
2020-04-13 09:00:00	NVDA	Stock	6.5315	6.5825	6.425	6.5128	45994320.0
2020-04-13 10:00:00	NVDA	Stock	6.5166	6.6278	6.5063	6.5866	68594000.0
2020-04-13 11:00:00	NVDA	Stock	6.5832	6.6375	6.5426	6.6075	44461200.0
2020-04-13 12:00:00	NVDA	Stock	6.6068	6.665	6.5865	6.614	45080520.0
2020-04-13 13:00:00	NVDA	Stock	6.6132	6.672	6.5887	6.6514	30335240.0
2020-04-13 14:00:00	NVDA	Stock	6.6495	6.692	6.633	6.6859	35614840.0
2020-04-13 15:00:00	NVDA	Stock	6.6855	6.755	6.6573	6.7475	81560120.0
2020-04-13 16:00:00	NVDA	Stock	6.7463	6.7582	6.7375	6.7428	3926000.0
2020-04-13 17:00:00	NVDA	Stock	6.7428	6.7625	6.7422	6.7625	814360.0
2020-04-13 18:00:00	NVDA	Stock	6.7588	6.7878	6.75	6.7875	529160.0
2020-04-13 19:00:00	NVDA	Stock	6.7918	6.8048	6.7725	6.8048	481480.0
2020-04-13 05:00:00	AMZN	Stock	101.65	101.65	101.65	101.65	4000.0
2020-04-13 06:00:00	AMZN	Stock	101.715	101.7505	101.715	101.75	8000.0
2020-04-13 07:00:00	AMZN	Stock	101.818	102.125	101.818	102.125	53420.0
2020-04-13 08:00:00	AMZN	Stock	101.9995	102.344	101.9995	102.174	111120.0

> showing 50 of 54,633 rows — these rows as CSV

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