PREVIEW / stock_1hour / 2019-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-24.parquet
  size:    1.1 MB
  rows:    49,868
  symbols: 2,591

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-07-24 04:00:00	AAPL	Stock	51.95	51.95	51.7475	51.755	5996.0
2019-07-24 05:00:00	AAPL	Stock	51.8225	51.885	51.77	51.77	27452.0
2019-07-24 06:00:00	AAPL	Stock	51.83	51.9875	51.8075	51.93	9852.0
2019-07-24 07:00:00	AAPL	Stock	51.945	52.035	51.9	51.9625	80616.0
2019-07-24 08:00:00	AAPL	Stock	51.8925	52.03	51.8925	51.9375	254936.0
2019-07-24 09:00:00	AAPL	Stock	51.93	52.2875	51.845	52.175	8395260.0
2019-07-24 10:00:00	AAPL	Stock	52.1725	52.2675	51.945	51.98	8277624.0
2019-07-24 11:00:00	AAPL	Stock	51.9775	52.045	51.8925	51.9525	5742632.0
2019-07-24 12:00:00	AAPL	Stock	51.95	52.055	51.9412	52.0425	3765516.0
2019-07-24 13:00:00	AAPL	Stock	52.0462	52.049	51.8205	51.85	3737380.0
2019-07-24 14:00:00	AAPL	Stock	51.8515	52.02	51.7925	52.0175	5054384.0
2019-07-24 15:00:00	AAPL	Stock	52.015	52.1875	51.9912	52.1675	8959920.0
2019-07-24 16:00:00	AAPL	Stock	52.1675	52.28	52.0798	52.115	5743260.0
2019-07-24 17:00:00	AAPL	Stock	52.105	52.25	52.07	52.2025	144056.0
2019-07-24 18:00:00	AAPL	Stock	52.2025	52.2475	52.2025	52.205	36316.0
2019-07-24 19:00:00	AAPL	Stock	52.23	52.2525	52.215	52.2475	28340.0
2019-07-24 04:00:00	MSFT	Stock	139.0	139.0	138.77	138.9	2510.0
2019-07-24 05:00:00	MSFT	Stock	138.89	139.15	138.75	138.8	6555.0
2019-07-24 06:00:00	MSFT	Stock	138.88	138.9	138.85	138.9	948.0
2019-07-24 07:00:00	MSFT	Stock	138.96	139.0	138.82	138.95	8667.0
2019-07-24 08:00:00	MSFT	Stock	138.89	139.16	138.82	138.96	22625.0
2019-07-24 09:00:00	MSFT	Stock	138.9	139.91	138.85	139.76	2374925.0
2019-07-24 10:00:00	MSFT	Stock	139.76	139.86	139.46	139.695	2182145.0
2019-07-24 11:00:00	MSFT	Stock	139.69	139.88	139.53	139.81	1158090.0
2019-07-24 12:00:00	MSFT	Stock	139.821	140.185	139.79	140.126	1862651.0
2019-07-24 13:00:00	MSFT	Stock	140.13	140.148	139.88	140.02	1048084.0
2019-07-24 14:00:00	MSFT	Stock	140.025	140.226	139.76	140.22	1482914.0
2019-07-24 15:00:00	MSFT	Stock	140.23	140.74	140.174	140.72	3460795.0
2019-07-24 16:00:00	MSFT	Stock	140.72	140.93	140.06	140.5	2739724.0
2019-07-24 17:00:00	MSFT	Stock	140.5	140.62	140.3	140.62	22296.0
2019-07-24 18:00:00	MSFT	Stock	140.5	140.6	140.5	140.6	2358.0
2019-07-24 19:00:00	MSFT	Stock	140.51	140.62	140.51	140.62	5864.0
2019-07-24 04:00:00	NVDA	Stock	4.4438	4.4453	4.4438	4.4438	31840.0
2019-07-24 05:00:00	NVDA	Stock	4.4432	4.4432	4.4325	4.4388	58040.0
2019-07-24 06:00:00	NVDA	Stock	4.4425	4.461	4.44	4.4518	36760.0
2019-07-24 07:00:00	NVDA	Stock	4.4518	4.4645	4.4487	4.4487	641680.0
2019-07-24 08:00:00	NVDA	Stock	4.4596	4.4675	4.4325	4.4325	1006960.0
2019-07-24 09:00:00	NVDA	Stock	4.435	4.4412	4.3585	4.3992	79459920.0
2019-07-24 10:00:00	NVDA	Stock	4.3995	4.4458	4.3868	4.43	58701880.0
2019-07-24 11:00:00	NVDA	Stock	4.4298	4.444	4.4145	4.4195	30652000.0
2019-07-24 12:00:00	NVDA	Stock	4.4196	4.4375	4.4096	4.4345	23138760.0
2019-07-24 13:00:00	NVDA	Stock	4.4348	4.4355	4.4215	4.4305	12763680.0
2019-07-24 14:00:00	NVDA	Stock	4.43	4.4492	4.4218	4.4472	20478200.0
2019-07-24 15:00:00	NVDA	Stock	4.4472	4.4722	4.444	4.4675	59166080.0
2019-07-24 16:00:00	NVDA	Stock	4.4665	4.4718	4.4	4.4125	17338680.0
2019-07-24 17:00:00	NVDA	Stock	4.4062	4.42	4.3875	4.4032	1336320.0
2019-07-24 18:00:00	NVDA	Stock	4.4118	4.4148	4.4062	4.4098	327960.0
2019-07-24 19:00:00	NVDA	Stock	4.4098	4.421	4.408	4.4138	435120.0
2019-07-24 04:00:00	AMZN	Stock	98.725	98.813	98.725	98.813	4640.0
2019-07-24 06:00:00	AMZN	Stock	98.8	98.83	98.8	98.83	6000.0

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

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