PREVIEW / stock_1hour / 2019-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-11.parquet
  size:    1.1 MB
  rows:    49,633
  symbols: 2,526

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
2019-10-11 04:00:00	AAPL	Stock	57.8525	58.25	57.8525	58.175	60184.0
2019-10-11 05:00:00	AAPL	Stock	58.275	58.375	58.2325	58.235	42708.0
2019-10-11 06:00:00	AAPL	Stock	58.2375	58.2975	58.1775	58.195	50208.0
2019-10-11 07:00:00	AAPL	Stock	58.2275	58.3	58.15	58.2375	367928.0
2019-10-11 08:00:00	AAPL	Stock	58.175	58.2975	57.38	58.2025	681212.0
2019-10-11 09:00:00	AAPL	Stock	58.2025	58.455	58.077	58.4175	19527464.0
2019-10-11 10:00:00	AAPL	Stock	58.425	58.6	58.415	58.485	18027336.0
2019-10-11 11:00:00	AAPL	Stock	58.4875	58.8	58.4825	58.62	17866152.0
2019-10-11 12:00:00	AAPL	Stock	58.6235	58.7175	58.27	58.7072	11251908.0
2019-10-11 13:00:00	AAPL	Stock	58.705	58.8575	58.6192	58.825	10538556.0
2019-10-11 14:00:00	AAPL	Stock	58.8262	59.14	58.7275	59.1225	15862616.0
2019-10-11 15:00:00	AAPL	Stock	59.1225	59.41	58.96	59.055	40012916.0
2019-10-11 16:00:00	AAPL	Stock	59.0025	59.2	58.955	59.0875	10212428.0
2019-10-11 17:00:00	AAPL	Stock	59.085	59.2125	59.075	59.1825	203624.0
2019-10-11 18:00:00	AAPL	Stock	59.195	59.25	59.19	59.2375	66164.0
2019-10-11 19:00:00	AAPL	Stock	59.2325	59.3125	59.2	59.3125	110428.0
2019-10-11 04:00:00	MSFT	Stock	139.84	140.7	139.84	140.7	2908.0
2019-10-11 05:00:00	MSFT	Stock	140.73	140.98	140.73	140.78	3743.0
2019-10-11 06:00:00	MSFT	Stock	140.75	140.75	140.55	140.72	300.0
2019-10-11 07:00:00	MSFT	Stock	140.58	140.95	140.11	140.72	35686.0
2019-10-11 08:00:00	MSFT	Stock	140.62	140.9	139.44	140.408	52794.0
2019-10-11 09:00:00	MSFT	Stock	140.32	141.03	140.06	140.57	3321968.0
2019-10-11 10:00:00	MSFT	Stock	140.58	141.0	140.5	140.58	2813150.0
2019-10-11 11:00:00	MSFT	Stock	140.58	140.95	140.24	140.395	2589212.0
2019-10-11 12:00:00	MSFT	Stock	140.4	140.51	139.58	140.455	2000979.0
2019-10-11 13:00:00	MSFT	Stock	140.44	140.73	140.12	140.62	2087481.0
2019-10-11 14:00:00	MSFT	Stock	140.62	140.8	140.33	140.699	1541933.0
2019-10-11 15:00:00	MSFT	Stock	140.69	140.75	139.5	139.61	4642138.0
2019-10-11 16:00:00	MSFT	Stock	139.68	139.95	139.5	139.8	3237389.0
2019-10-11 17:00:00	MSFT	Stock	139.87	139.87	139.71	139.84	13002.0
2019-10-11 18:00:00	MSFT	Stock	139.85	139.95	139.84	139.95	4015.0
2019-10-11 19:00:00	MSFT	Stock	139.97	140.0	139.94	139.99	7076.0
2019-10-11 04:00:00	NVDA	Stock	4.6238	4.6238	4.6057	4.6083	39320.0
2019-10-11 05:00:00	NVDA	Stock	4.6462	4.661	4.6462	4.65	57800.0
2019-10-11 06:00:00	NVDA	Stock	4.6535	4.6562	4.6535	4.655	73240.0
2019-10-11 07:00:00	NVDA	Stock	4.6585	4.674	4.6445	4.67	1528800.0
2019-10-11 08:00:00	NVDA	Stock	4.645	4.69	4.6438	4.6755	2086440.0
2019-10-11 09:00:00	NVDA	Stock	4.6728	4.7335	4.6595	4.72	92109320.0
2019-10-11 10:00:00	NVDA	Stock	4.7215	4.7292	4.6882	4.702	70317400.0
2019-10-11 11:00:00	NVDA	Stock	4.702	4.7125	4.6695	4.6778	39416880.0
2019-10-11 12:00:00	NVDA	Stock	4.677	4.6858	4.6412	4.6835	32005480.0
2019-10-11 13:00:00	NVDA	Stock	4.6838	4.7084	4.6802	4.7022	35289120.0
2019-10-11 14:00:00	NVDA	Stock	4.7025	4.7055	4.6835	4.6932	36667040.0
2019-10-11 15:00:00	NVDA	Stock	4.6928	4.7088	4.6465	4.6488	83989240.0
2019-10-11 16:00:00	NVDA	Stock	4.6498	4.6625	4.6375	4.6498	28216520.0
2019-10-11 17:00:00	NVDA	Stock	4.65	4.6722	4.6495	4.6722	518520.0
2019-10-11 18:00:00	NVDA	Stock	4.667	4.6688	4.6628	4.6672	175960.0
2019-10-11 19:00:00	NVDA	Stock	4.666	4.6688	4.663	4.6638	150040.0
2019-10-11 04:00:00	AMZN	Stock	86.8035	86.8035	86.8035	86.8035	18360.0
2019-10-11 05:00:00	AMZN	Stock	86.9995	86.9995	86.9545	86.9545	21060.0

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

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