PREVIEW / stock_1hour / 2019-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-20.parquet
  size:    1.1 MB
  rows:    50,376
  symbols: 2,551

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-09-20 04:00:00	AAPL	Stock	55.3225	55.41	55.3225	55.3375	6408.0
2019-09-20 05:00:00	AAPL	Stock	55.35	55.4025	55.3375	55.4025	12644.0
2019-09-20 06:00:00	AAPL	Stock	55.3875	55.3875	55.315	55.335	8400.0
2019-09-20 07:00:00	AAPL	Stock	55.3625	55.445	55.2875	55.4375	178016.0
2019-09-20 08:00:00	AAPL	Stock	55.3275	55.4875	55.325	55.4625	401928.0
2019-09-20 09:00:00	AAPL	Stock	55.4625	55.64	55.3425	55.4725	32181640.0
2019-09-20 10:00:00	AAPL	Stock	55.475	55.61	55.3962	55.4875	11439500.0
2019-09-20 11:00:00	AAPL	Stock	55.485	55.5338	55.215	55.28	8992196.0
2019-09-20 12:00:00	AAPL	Stock	55.2788	55.3075	55.025	55.0675	5824768.0
2019-09-20 13:00:00	AAPL	Stock	55.0652	55.1475	54.3682	54.628	16482036.0
2019-09-20 14:00:00	AAPL	Stock	54.6325	54.9925	54.5725	54.8575	9746596.0
2019-09-20 15:00:00	AAPL	Stock	54.86	54.9475	54.4025	54.4225	20920280.0
2019-09-20 16:00:00	AAPL	Stock	54.5475	54.7925	54.385	54.4775	69795020.0
2019-09-20 17:00:00	AAPL	Stock	54.5	54.53	54.4325	54.4925	114800.0
2019-09-20 18:00:00	AAPL	Stock	54.5	54.55	54.445	54.5	75624.0
2019-09-20 19:00:00	AAPL	Stock	54.5	54.5	54.42	54.4375	45272.0
2019-09-20 04:00:00	MSFT	Stock	141.3	141.35	141.3	141.35	508.0
2019-09-20 05:00:00	MSFT	Stock	141.4	141.47	141.4	141.47	791.0
2019-09-20 06:00:00	MSFT	Stock	141.41	141.59	141.38	141.38	2261.0
2019-09-20 07:00:00	MSFT	Stock	141.44	141.5	141.3	141.4	15278.0
2019-09-20 08:00:00	MSFT	Stock	141.49	141.55	141.26	141.44	46428.0
2019-09-20 09:00:00	MSFT	Stock	141.46	141.73	140.81	140.97	12211608.0
2019-09-20 10:00:00	MSFT	Stock	140.97	141.25	140.435	140.53	2761949.0
2019-09-20 11:00:00	MSFT	Stock	140.523	140.63	139.56	140.085	2636202.0
2019-09-20 12:00:00	MSFT	Stock	140.07	140.1	139.16	139.455	1974519.0
2019-09-20 13:00:00	MSFT	Stock	139.46	139.56	138.25	138.94	3168114.0
2019-09-20 14:00:00	MSFT	Stock	138.96	139.52	138.89	139.255	1849996.0
2019-09-20 15:00:00	MSFT	Stock	139.255	139.7	139.095	139.28	3404002.0
2019-09-20 16:00:00	MSFT	Stock	139.44	139.45	139.06	139.1	4568891.0
2019-09-20 17:00:00	MSFT	Stock	139.1	139.28	139.1	139.2	2815.0
2019-09-20 18:00:00	MSFT	Stock	139.1	139.44	139.05	139.05	13179.0
2019-09-20 19:00:00	MSFT	Stock	139.1	139.14	139.0	139.02	8079.0
2019-09-20 04:00:00	NVDA	Stock	4.4255	4.4335	4.4255	4.4335	64000.0
2019-09-20 06:00:00	NVDA	Stock	4.4458	4.4458	4.4458	4.4458	12120.0
2019-09-20 07:00:00	NVDA	Stock	4.4412	4.442	4.43	4.4358	82640.0
2019-09-20 08:00:00	NVDA	Stock	4.44	4.445	4.4312	4.4338	413480.0
2019-09-20 09:00:00	NVDA	Stock	4.44	4.4525	4.4018	4.4024	65229320.0
2019-09-20 10:00:00	NVDA	Stock	4.4034	4.4232	4.3863	4.392	36412480.0
2019-09-20 11:00:00	NVDA	Stock	4.391	4.397	4.3662	4.3768	27997600.0
2019-09-20 12:00:00	NVDA	Stock	4.3775	4.3933	4.372	4.3813	19333280.0
2019-09-20 13:00:00	NVDA	Stock	4.381	4.3852	4.307	4.3265	53859800.0
2019-09-20 14:00:00	NVDA	Stock	4.3265	4.3425	4.3105	4.3367	33120240.0
2019-09-20 15:00:00	NVDA	Stock	4.3368	4.3422	4.3148	4.3155	48442200.0
2019-09-20 16:00:00	NVDA	Stock	4.3173	4.3318	4.31	4.3173	7480280.0
2019-09-20 17:00:00	NVDA	Stock	4.3125	4.313	4.3028	4.3068	175680.0
2019-09-20 18:00:00	NVDA	Stock	4.309	4.3125	4.3042	4.3075	377040.0
2019-09-20 19:00:00	NVDA	Stock	4.305	4.3088	4.3	4.3065	236400.0
2019-09-20 07:00:00	AMZN	Stock	91.2	91.2525	91.2	91.2525	7540.0
2019-09-20 08:00:00	AMZN	Stock	91.3	91.3	91.15	91.25	131480.0
2019-09-20 09:00:00	AMZN	Stock	91.2625	91.5315	91.0785	91.176	17267740.0

> showing 50 of 50,376 rows — these rows as CSV

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