PREVIEW / stock_1hour / 2020-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-01.parquet
  size:    1.2 MB
  rows:    57,170
  symbols: 2,497

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-10-01 04:00:00	AAPL	Stock	116.71	117.19	116.51	116.71	44918.0
2020-10-01 05:00:00	AAPL	Stock	116.81	117.48	116.77	117.47	51737.0
2020-10-01 06:00:00	AAPL	Stock	117.38	117.6	117.14	117.49	37257.0
2020-10-01 07:00:00	AAPL	Stock	117.35	117.7	117.16	117.54	253970.0
2020-10-01 08:00:00	AAPL	Stock	117.53	118.1	117.2	117.7	966651.0
2020-10-01 09:00:00	AAPL	Stock	117.7	117.8	116.16	116.42	16087978.0
2020-10-01 10:00:00	AAPL	Stock	116.41	117.02	116.28	116.765	15803787.0
2020-10-01 11:00:00	AAPL	Stock	116.765	116.9	116.14	116.315	10859714.0
2020-10-01 12:00:00	AAPL	Stock	116.315	116.45	115.83	116.33	11380116.0
2020-10-01 13:00:00	AAPL	Stock	116.33	116.92	116.22	116.43	8771102.0
2020-10-01 14:00:00	AAPL	Stock	116.46	116.93	115.91	116.75	13444491.0
2020-10-01 15:00:00	AAPL	Stock	116.75	117.03	116.12	116.8	16129760.0
2020-10-01 16:00:00	AAPL	Stock	116.79	117.0	116.7	116.77	11221220.0
2020-10-01 17:00:00	AAPL	Stock	116.76	116.84	116.66	116.84	90492.0
2020-10-01 18:00:00	AAPL	Stock	116.85	117.1	116.64	116.93	225923.0
2020-10-01 19:00:00	AAPL	Stock	116.93	117.0	116.7	116.8	118942.0
2020-10-01 04:00:00	MSFT	Stock	211.88	211.99	211.11	211.4	2335.0
2020-10-01 05:00:00	MSFT	Stock	211.54	212.8	211.54	212.79	4940.0
2020-10-01 06:00:00	MSFT	Stock	212.8	213.45	212.5	212.92	15283.0
2020-10-01 07:00:00	MSFT	Stock	212.95	213.2	212.42	213.2	34862.0
2020-10-01 08:00:00	MSFT	Stock	213.19	213.65	209.81	212.9	121750.0
2020-10-01 09:00:00	MSFT	Stock	213.0	213.99	211.995	212.514	3180840.0
2020-10-01 10:00:00	MSFT	Stock	212.51	212.99	211.81	212.19	2498044.0
2020-10-01 11:00:00	MSFT	Stock	212.19	213.12	211.32	212.38	2271266.0
2020-10-01 12:00:00	MSFT	Stock	212.38	212.62	211.73	212.35	1688888.0
2020-10-01 13:00:00	MSFT	Stock	212.34	212.99	211.85	212.35	1722507.0
2020-10-01 14:00:00	MSFT	Stock	212.37	213.48	211.6	213.35	2369439.0
2020-10-01 15:00:00	MSFT	Stock	213.38	213.55	211.97	212.46	3018835.0
2020-10-01 16:00:00	MSFT	Stock	212.46	212.89	212.2	212.44	5559708.0
2020-10-01 17:00:00	MSFT	Stock	212.37	212.53	212.3	212.53	8605.0
2020-10-01 18:00:00	MSFT	Stock	212.5	213.5	212.11	212.72	32162.0
2020-10-01 19:00:00	MSFT	Stock	212.94	212.94	212.25	212.28	7706.0
2020-10-01 04:00:00	NVDA	Stock	13.7	13.7465	13.6775	13.725	217880.0
2020-10-01 05:00:00	NVDA	Stock	13.7475	13.815	13.747	13.815	96000.0
2020-10-01 06:00:00	NVDA	Stock	13.865	13.8718	13.823	13.823	314920.0
2020-10-01 07:00:00	NVDA	Stock	13.8238	13.8242	13.7538	13.7755	1361200.0
2020-10-01 08:00:00	NVDA	Stock	13.7773	13.8248	13.7532	13.7595	2402680.0
2020-10-01 09:00:00	NVDA	Stock	13.7748	13.7748	13.5875	13.6425	71323360.0
2020-10-01 10:00:00	NVDA	Stock	13.6308	13.7098	13.5473	13.5978	91203720.0
2020-10-01 11:00:00	NVDA	Stock	13.5952	13.614	13.4608	13.5831	78007920.0
2020-10-01 12:00:00	NVDA	Stock	13.5834	13.597	13.5159	13.5877	42537080.0
2020-10-01 13:00:00	NVDA	Stock	13.5895	13.6622	13.5665	13.5831	43799680.0
2020-10-01 14:00:00	NVDA	Stock	13.5865	13.6415	13.51	13.6232	53076800.0
2020-10-01 15:00:00	NVDA	Stock	13.625	13.6488	13.5363	13.6173	52608960.0
2020-10-01 16:00:00	NVDA	Stock	13.6145	13.621	13.5875	13.61	23079080.0
2020-10-01 17:00:00	NVDA	Stock	13.6125	13.6125	13.5942	13.6	209760.0
2020-10-01 18:00:00	NVDA	Stock	13.6038	13.6288	13.5915	13.6238	812640.0
2020-10-01 19:00:00	NVDA	Stock	13.6155	13.6155	13.5825	13.594	249240.0
2020-10-01 04:00:00	AMZN	Stock	159.25	159.25	158.97	158.97	7100.0
2020-10-01 07:00:00	AMZN	Stock	160.15	160.15	159.7	160.0495	294260.0

> showing 50 of 57,170 rows — these rows as CSV

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