PREVIEW / stock_1hour / 2020-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-11.parquet
  size:    1.2 MB
  rows:    55,349
  symbols: 2,473

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-09-11 04:00:00	AAPL	Stock	115.1	116.35	115.1	115.9	83818.0
2020-09-11 05:00:00	AAPL	Stock	115.88	116.33	115.77	116.05	27381.0
2020-09-11 06:00:00	AAPL	Stock	116.12	116.12	114.8	115.15	109779.0
2020-09-11 07:00:00	AAPL	Stock	115.1	115.46	114.56	115.33	577205.0
2020-09-11 08:00:00	AAPL	Stock	114.858	115.45	113.96	114.0	1220102.0
2020-09-11 09:00:00	AAPL	Stock	114.0	115.23	112.26	112.72	19220525.0
2020-09-11 10:00:00	AAPL	Stock	112.727	113.66	110.0	112.58	27261312.0
2020-09-11 11:00:00	AAPL	Stock	112.57	113.87	111.5	111.54	19105190.0
2020-09-11 12:00:00	AAPL	Stock	111.55	112.42	110.71	110.748	17021429.0
2020-09-11 13:00:00	AAPL	Stock	110.745	111.364	110.03	110.412	22828713.0
2020-09-11 14:00:00	AAPL	Stock	110.42	112.22	110.28	111.31	18617030.0
2020-09-11 15:00:00	AAPL	Stock	111.31	112.55	110.7	112.01	24633427.0
2020-09-11 16:00:00	AAPL	Stock	112.01	112.23	111.77	112.11	7931750.0
2020-09-11 17:00:00	AAPL	Stock	112.12	112.2	111.75	112.08	299610.0
2020-09-11 18:00:00	AAPL	Stock	112.07	112.07	111.87	111.98	112518.0
2020-09-11 19:00:00	AAPL	Stock	111.98	112.02	111.85	111.99	194498.0
2020-09-11 04:00:00	MSFT	Stock	207.82	209.88	207.66	209.05	8227.0
2020-09-11 05:00:00	MSFT	Stock	209.05	209.05	208.65	208.85	2139.0
2020-09-11 06:00:00	MSFT	Stock	208.51	208.51	207.72	207.8	10242.0
2020-09-11 07:00:00	MSFT	Stock	208.1	208.5	207.02	208.45	38521.0
2020-09-11 08:00:00	MSFT	Stock	207.3	208.5	206.06	206.39	94711.0
2020-09-11 09:00:00	MSFT	Stock	206.38	208.63	205.284	205.595	2671455.0
2020-09-11 10:00:00	MSFT	Stock	205.57	208.23	204.77	207.51	3458091.0
2020-09-11 11:00:00	MSFT	Stock	207.51	208.54	205.03	205.106	2364922.0
2020-09-11 12:00:00	MSFT	Stock	205.06	205.73	202.93	202.97	2923595.0
2020-09-11 13:00:00	MSFT	Stock	202.95	203.375	201.24	201.5	3577920.0
2020-09-11 14:00:00	MSFT	Stock	201.54	204.15	201.35	203.28	2596283.0
2020-09-11 15:00:00	MSFT	Stock	203.285	205.124	202.05	204.04	4118479.0
2020-09-11 16:00:00	MSFT	Stock	204.03	204.6	203.37	203.49	3112386.0
2020-09-11 17:00:00	MSFT	Stock	203.5	203.74	203.49	203.69	17320.0
2020-09-11 18:00:00	MSFT	Stock	203.64	203.64	203.28	203.45	21588.0
2020-09-11 19:00:00	MSFT	Stock	203.44	203.52	203.28	203.5	17377.0
2020-09-11 04:00:00	NVDA	Stock	12.5725	12.6812	12.5725	12.625	163160.0
2020-09-11 05:00:00	NVDA	Stock	12.6238	12.6375	12.6	12.6248	142920.0
2020-09-11 06:00:00	NVDA	Stock	12.6248	12.6248	12.465	12.525	214840.0
2020-09-11 07:00:00	NVDA	Stock	12.525	12.5845	12.4825	12.5375	1485000.0
2020-09-11 08:00:00	NVDA	Stock	12.5245	12.572	12.375	12.375	3141720.0
2020-09-11 09:00:00	NVDA	Stock	12.3813	12.6525	12.3635	12.3848	85009760.0
2020-09-11 10:00:00	NVDA	Stock	12.381	12.5294	12.3335	12.4	86983160.0
2020-09-11 11:00:00	NVDA	Stock	12.4034	12.468	12.2255	12.2325	47918120.0
2020-09-11 12:00:00	NVDA	Stock	12.2327	12.285	12.0543	12.071	59885680.0
2020-09-11 13:00:00	NVDA	Stock	12.0664	12.1033	11.8958	12.0235	105321600.0
2020-09-11 14:00:00	NVDA	Stock	12.0248	12.2095	12.0	12.1363	74455720.0
2020-09-11 15:00:00	NVDA	Stock	12.1288	12.192	12.0315	12.1674	86395840.0
2020-09-11 16:00:00	NVDA	Stock	12.1645	12.18	12.1125	12.15	4342240.0
2020-09-11 17:00:00	NVDA	Stock	12.1525	12.1598	12.1375	12.1438	175520.0
2020-09-11 18:00:00	NVDA	Stock	12.1382	12.1382	12.1105	12.12	143080.0
2020-09-11 19:00:00	NVDA	Stock	12.13	12.135	12.121	12.1285	94360.0
2020-09-11 04:00:00	AMZN	Stock	160.9805	161.4495	160.9805	161.4495	14000.0
2020-09-11 05:00:00	AMZN	Stock	161.5	161.5	161.5	161.5	2300.0

> showing 50 of 55,349 rows — these rows as CSV

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