PREVIEW / stock_1hour / 2019-11-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-26.parquet
  size:    1.1 MB
  rows:    50,745
  symbols: 2,500

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-11-26 04:00:00	AAPL	Stock	66.5125	66.55	66.5	66.55	4248.0
2019-11-26 05:00:00	AAPL	Stock	66.565	66.565	66.5375	66.55	8540.0
2019-11-26 06:00:00	AAPL	Stock	66.565	66.65	66.565	66.615	25556.0
2019-11-26 07:00:00	AAPL	Stock	66.625	66.73	66.6125	66.6875	137932.0
2019-11-26 08:00:00	AAPL	Stock	66.6875	66.7725	66.6	66.7025	342600.0
2019-11-26 09:00:00	AAPL	Stock	66.7025	66.79	66.3085	66.505	9859076.0
2019-11-26 10:00:00	AAPL	Stock	66.5125	66.6225	66.375	66.5878	9569716.0
2019-11-26 11:00:00	AAPL	Stock	66.59	66.64	66.4325	66.6038	5093904.0
2019-11-26 12:00:00	AAPL	Stock	66.6028	66.675	66.5387	66.65	3995064.0
2019-11-26 13:00:00	AAPL	Stock	66.6575	66.6975	66.57	66.605	3609804.0
2019-11-26 14:00:00	AAPL	Stock	66.61	66.6575	66.5325	66.6125	3457416.0
2019-11-26 15:00:00	AAPL	Stock	66.6125	66.6762	65.625	66.025	14372748.0
2019-11-26 16:00:00	AAPL	Stock	66.0325	66.3	66.0325	66.2025	31569184.0
2019-11-26 17:00:00	AAPL	Stock	66.2	66.2475	66.0725	66.2475	659272.0
2019-11-26 18:00:00	AAPL	Stock	66.24	66.25	66.0725	66.2475	88300.0
2019-11-26 19:00:00	AAPL	Stock	66.24	66.25	66.1875	66.19	41372.0
2019-11-26 04:00:00	MSFT	Stock	151.43	151.43	151.3	151.38	300.0
2019-11-26 06:00:00	MSFT	Stock	151.19	151.39	151.1	151.39	547.0
2019-11-26 07:00:00	MSFT	Stock	151.35	151.43	151.3	151.37	3258.0
2019-11-26 08:00:00	MSFT	Stock	151.33	151.46	151.272	151.33	17535.0
2019-11-26 09:00:00	MSFT	Stock	151.32	152.197	151.25	151.94	2379356.0
2019-11-26 10:00:00	MSFT	Stock	151.95	152.14	151.75	151.99	1945444.0
2019-11-26 11:00:00	MSFT	Stock	151.99	152.185	151.87	151.98	1276225.0
2019-11-26 12:00:00	MSFT	Stock	151.98	152.1	151.93	152.044	909370.0
2019-11-26 13:00:00	MSFT	Stock	152.05	152.17	151.905	151.975	808790.0
2019-11-26 14:00:00	MSFT	Stock	151.99	152.13	151.86	152.067	951454.0
2019-11-26 15:00:00	MSFT	Stock	152.065	152.42	151.93	152.0	3108928.0
2019-11-26 16:00:00	MSFT	Stock	152.0	152.22	151.95	152.1	8216324.0
2019-11-26 17:00:00	MSFT	Stock	152.2	152.2	152.03	152.138	322288.0
2019-11-26 18:00:00	MSFT	Stock	152.07	152.13	152.03	152.13	10126.0
2019-11-26 19:00:00	MSFT	Stock	152.15	152.44	152.14	152.14	6935.0
2019-11-26 04:00:00	NVDA	Stock	5.525	5.525	5.5145	5.5145	61280.0
2019-11-26 05:00:00	NVDA	Stock	5.5153	5.5153	5.5125	5.5125	19800.0
2019-11-26 06:00:00	NVDA	Stock	5.516	5.516	5.516	5.516	4000.0
2019-11-26 07:00:00	NVDA	Stock	5.5235	5.5395	5.5235	5.5342	776600.0
2019-11-26 08:00:00	NVDA	Stock	5.523	5.5413	5.5165	5.5252	1093080.0
2019-11-26 09:00:00	NVDA	Stock	5.5253	5.5275	5.4375	5.46	71232680.0
2019-11-26 10:00:00	NVDA	Stock	5.4619	5.4648	5.4185	5.4533	63516760.0
2019-11-26 11:00:00	NVDA	Stock	5.454	5.4638	5.4382	5.4612	29589920.0
2019-11-26 12:00:00	NVDA	Stock	5.4612	5.4745	5.4525	5.4674	27248240.0
2019-11-26 13:00:00	NVDA	Stock	5.4675	5.469	5.4458	5.4496	12145120.0
2019-11-26 14:00:00	NVDA	Stock	5.4495	5.4518	5.4278	5.4343	22368120.0
2019-11-26 15:00:00	NVDA	Stock	5.4343	5.4516	5.4213	5.427	59557680.0
2019-11-26 16:00:00	NVDA	Stock	5.425	5.435	5.4248	5.435	13858320.0
2019-11-26 17:00:00	NVDA	Stock	5.435	5.4375	5.425	5.435	243240.0
2019-11-26 18:00:00	NVDA	Stock	5.436	5.4388	5.425	5.4385	177600.0
2019-11-26 19:00:00	NVDA	Stock	5.4385	5.44	5.4325	5.4325	226320.0
2019-11-26 06:00:00	AMZN	Stock	88.642	88.642	88.642	88.642	4000.0
2019-11-26 07:00:00	AMZN	Stock	88.692	88.8	88.692	88.8	65260.0
2019-11-26 08:00:00	AMZN	Stock	88.75	88.9485	88.75	88.869	188820.0

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

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