PREVIEW / stock_1hour / 2019-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-13.parquet
  size:    1.1 MB
  rows:    50,322
  symbols: 2,644

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-03-13 04:00:00	AAPL	Stock	45.235	45.2625	45.235	45.25	4004.0
2019-03-13 05:00:00	AAPL	Stock	45.2775	45.2775	45.2775	45.2775	1592.0
2019-03-13 06:00:00	AAPL	Stock	45.34	45.35	45.325	45.325	8268.0
2019-03-13 07:00:00	AAPL	Stock	45.33	45.475	45.3275	45.46	124232.0
2019-03-13 08:00:00	AAPL	Stock	45.375	45.5	45.34	45.4325	363736.0
2019-03-13 09:00:00	AAPL	Stock	45.4125	45.825	45.3888	45.4275	16015916.0
2019-03-13 10:00:00	AAPL	Stock	45.4325	45.4875	45.23	45.405	16515548.0
2019-03-13 11:00:00	AAPL	Stock	45.41	45.5725	45.4075	45.4325	12549612.0
2019-03-13 12:00:00	AAPL	Stock	45.4325	45.5625	45.4275	45.535	6994628.0
2019-03-13 13:00:00	AAPL	Stock	45.5375	45.65	45.5025	45.65	7153328.0
2019-03-13 14:00:00	AAPL	Stock	45.65	45.7075	45.5575	45.6325	12545044.0
2019-03-13 15:00:00	AAPL	Stock	45.63	45.645	45.4	45.43	14224380.0
2019-03-13 16:00:00	AAPL	Stock	45.375	45.51	45.375	45.475	25139200.0
2019-03-13 17:00:00	AAPL	Stock	45.4675	45.57	45.4425	45.565	103408.0
2019-03-13 18:00:00	AAPL	Stock	45.5725	45.6875	45.4275	45.6375	184296.0
2019-03-13 19:00:00	AAPL	Stock	45.645	45.65	45.5625	45.615	78104.0
2019-03-13 04:00:00	MSFT	Stock	113.43	113.6	113.43	113.6	600.0
2019-03-13 06:00:00	MSFT	Stock	113.83	113.83	113.79	113.8	600.0
2019-03-13 07:00:00	MSFT	Stock	113.75	114.0	113.75	114.0	12469.0
2019-03-13 08:00:00	MSFT	Stock	113.85	114.19	113.82	113.95	27522.0
2019-03-13 09:00:00	MSFT	Stock	113.95	114.58	113.43	114.38	2753630.0
2019-03-13 10:00:00	MSFT	Stock	114.39	114.6	114.07	114.5	2903662.0
2019-03-13 11:00:00	MSFT	Stock	114.5	114.95	114.48	114.78	2329171.0
2019-03-13 12:00:00	MSFT	Stock	114.79	114.8	114.44	114.55	1939351.0
2019-03-13 13:00:00	MSFT	Stock	114.55	114.74	114.49	114.735	1523337.0
2019-03-13 14:00:00	MSFT	Stock	114.735	115.0	114.45	114.63	2895635.0
2019-03-13 15:00:00	MSFT	Stock	114.62	114.67	114.28	114.51	4502739.0
2019-03-13 16:00:00	MSFT	Stock	114.51	114.74	114.0	114.73	10483356.0
2019-03-13 17:00:00	MSFT	Stock	114.57	114.73	114.57	114.68	5170.0
2019-03-13 18:00:00	MSFT	Stock	114.66	114.85	114.5	114.62	50730.0
2019-03-13 19:00:00	MSFT	Stock	114.62	114.64	114.56	114.6	12543.0
2019-03-13 04:00:00	NVDA	Stock	4.0812	4.1025	4.0778	4.1025	31280.0
2019-03-13 05:00:00	NVDA	Stock	4.0908	4.091	4.0908	4.091	8000.0
2019-03-13 06:00:00	NVDA	Stock	4.077	4.077	4.0728	4.077	36000.0
2019-03-13 07:00:00	NVDA	Stock	4.082	4.0938	4.08	4.0918	515120.0
2019-03-13 08:00:00	NVDA	Stock	4.0812	4.0963	4.0804	4.0925	1783480.0
2019-03-13 09:00:00	NVDA	Stock	4.0945	4.1787	4.0928	4.1603	114461520.0
2019-03-13 10:00:00	NVDA	Stock	4.1612	4.2242	4.155	4.222	168007560.0
2019-03-13 11:00:00	NVDA	Stock	4.2213	4.245	4.215	4.2208	116009360.0
2019-03-13 12:00:00	NVDA	Stock	4.2208	4.2438	4.193	4.2082	80183640.0
2019-03-13 13:00:00	NVDA	Stock	4.2088	4.2338	4.208	4.2258	52747840.0
2019-03-13 14:00:00	NVDA	Stock	4.2265	4.2325	4.189	4.2098	67307880.0
2019-03-13 15:00:00	NVDA	Stock	4.2098	4.225	4.1895	4.2155	92772280.0
2019-03-13 16:00:00	NVDA	Stock	4.2155	4.2238	4.21	4.2185	10391720.0
2019-03-13 17:00:00	NVDA	Stock	4.2185	4.2222	4.2125	4.2195	363440.0
2019-03-13 18:00:00	NVDA	Stock	4.2158	4.225	4.215	4.2225	829240.0
2019-03-13 19:00:00	NVDA	Stock	4.225	4.2288	4.2205	4.2255	592600.0
2019-03-13 06:00:00	AMZN	Stock	83.655	83.75	83.655	83.75	6000.0
2019-03-13 07:00:00	AMZN	Stock	83.7555	83.991	83.7065	83.991	89300.0
2019-03-13 08:00:00	AMZN	Stock	83.725	84.05	83.725	83.9995	167060.0

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

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