PREVIEW / stock_1hour / 2020-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-01.parquet
  size:    1.2 MB
  rows:    56,661
  symbols: 2,440

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-07-01 04:00:00	AAPL	Stock	91.035	91.115	91.0025	91.03	4748.0
2020-07-01 05:00:00	AAPL	Stock	91.0525	91.0525	91.0	91.0	6300.0
2020-07-01 06:00:00	AAPL	Stock	91.0325	91.0325	90.7075	90.7075	30184.0
2020-07-01 07:00:00	AAPL	Stock	90.765	90.9375	90.57	90.7	161804.0
2020-07-01 08:00:00	AAPL	Stock	90.57	91.3	90.5325	91.3	364820.0
2020-07-01 09:00:00	AAPL	Stock	91.3025	91.8375	91.15	91.4925	14231416.0
2020-07-01 10:00:00	AAPL	Stock	91.4975	91.7425	91.38	91.695	12785268.0
2020-07-01 11:00:00	AAPL	Stock	91.7	91.8025	91.5325	91.5575	9942780.0
2020-07-01 12:00:00	AAPL	Stock	91.5625	91.84	91.47	91.66	8974432.0
2020-07-01 13:00:00	AAPL	Stock	91.6725	91.685	91.385	91.615	6216512.0
2020-07-01 14:00:00	AAPL	Stock	91.6075	91.72	90.9775	91.275	13413748.0
2020-07-01 15:00:00	AAPL	Stock	91.275	91.425	91.0	91.0025	15995944.0
2020-07-01 16:00:00	AAPL	Stock	91.0275	91.055	90.9075	90.91	5276608.0
2020-07-01 17:00:00	AAPL	Stock	90.91	90.95	90.875	90.9475	52504.0
2020-07-01 18:00:00	AAPL	Stock	90.9475	90.9975	90.9	90.9875	63588.0
2020-07-01 19:00:00	AAPL	Stock	90.9975	91.15	90.9775	91.0275	84264.0
2020-07-01 04:00:00	MSFT	Stock	203.32	203.32	203.26	203.26	200.0
2020-07-01 05:00:00	MSFT	Stock	203.3	203.3	203.0	203.0	1557.0
2020-07-01 06:00:00	MSFT	Stock	203.32	203.38	202.4	202.4	4803.0
2020-07-01 07:00:00	MSFT	Stock	202.48	202.99	202.03	202.16	24260.0
2020-07-01 08:00:00	MSFT	Stock	202.701	203.51	202.04	203.22	58075.0
2020-07-01 09:00:00	MSFT	Stock	203.26	203.77	201.77	202.73	3766502.0
2020-07-01 10:00:00	MSFT	Stock	202.73	204.515	202.59	204.49	3637295.0
2020-07-01 11:00:00	MSFT	Stock	204.53	205.32	204.28	204.9	3209603.0
2020-07-01 12:00:00	MSFT	Stock	204.906	205.34	204.49	204.76	2200198.0
2020-07-01 13:00:00	MSFT	Stock	204.76	205.41	204.01	205.33	2407595.0
2020-07-01 14:00:00	MSFT	Stock	205.32	205.965	205.12	205.604	2727379.0
2020-07-01 15:00:00	MSFT	Stock	205.61	206.35	204.48	204.66	4327342.0
2020-07-01 16:00:00	MSFT	Stock	204.7	204.79	204.37	204.55	2888599.0
2020-07-01 17:00:00	MSFT	Stock	204.5	204.64	204.47	204.47	3986.0
2020-07-01 18:00:00	MSFT	Stock	204.41	204.94	204.2	204.8	8830.0
2020-07-01 19:00:00	MSFT	Stock	204.58	204.79	204.5	204.5	13484.0
2020-07-01 06:00:00	NVDA	Stock	9.475	9.4762	9.4718	9.475	32000.0
2020-07-01 07:00:00	NVDA	Stock	9.45	9.45	9.4	9.4382	410360.0
2020-07-01 08:00:00	NVDA	Stock	9.4251	9.5	9.4	9.5	505000.0
2020-07-01 09:00:00	NVDA	Stock	9.5062	9.5375	9.413	9.4675	47360160.0
2020-07-01 10:00:00	NVDA	Stock	9.4662	9.5757	9.4438	9.5328	66326640.0
2020-07-01 11:00:00	NVDA	Stock	9.534	9.5665	9.5196	9.5448	29725360.0
2020-07-01 12:00:00	NVDA	Stock	9.5455	9.5537	9.4897	9.5239	24678360.0
2020-07-01 13:00:00	NVDA	Stock	9.5225	9.5345	9.4855	9.5215	21627400.0
2020-07-01 14:00:00	NVDA	Stock	9.5203	9.534	9.4948	9.5308	23336520.0
2020-07-01 15:00:00	NVDA	Stock	9.531	9.5678	9.5222	9.5225	44190040.0
2020-07-01 16:00:00	NVDA	Stock	9.53	9.5348	9.5125	9.5272	5510160.0
2020-07-01 17:00:00	NVDA	Stock	9.525	9.5253	9.5238	9.5253	32640.0
2020-07-01 18:00:00	NVDA	Stock	9.53	9.53	9.523	9.5275	124480.0
2020-07-01 19:00:00	NVDA	Stock	9.5188	9.535	9.5188	9.535	77840.0
2020-07-01 05:00:00	AMZN	Stock	137.975	137.975	137.9375	137.9375	7560.0
2020-07-01 06:00:00	AMZN	Stock	137.75	137.75	137.75	137.75	2000.0
2020-07-01 07:00:00	AMZN	Stock	137.563	137.563	137.4	137.55	191820.0
2020-07-01 08:00:00	AMZN	Stock	137.401	138.3065	137.401	138.0	312120.0

> showing 50 of 56,661 rows — these rows as CSV

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