PREVIEW / stock_1hour / 2020-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-11-11.parquet
  size:    1.3 MB
  rows:    57,559
  symbols: 2,514

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-11-11 04:00:00	AAPL	Stock	117.67	117.67	116.85	117.16	51143.0
2020-11-11 05:00:00	AAPL	Stock	117.16	117.2	116.66	117.17	20996.0
2020-11-11 06:00:00	AAPL	Stock	117.17	117.5	116.85	117.2	49027.0
2020-11-11 07:00:00	AAPL	Stock	117.18	117.61	116.95	117.54	349030.0
2020-11-11 08:00:00	AAPL	Stock	117.1	117.91	116.93	117.331	647622.0
2020-11-11 09:00:00	AAPL	Stock	117.4	118.08	116.44	117.71	15319194.0
2020-11-11 10:00:00	AAPL	Stock	117.705	118.5	117.64	118.18	15772472.0
2020-11-11 11:00:00	AAPL	Stock	118.17	118.78	117.835	118.776	9690719.0
2020-11-11 12:00:00	AAPL	Stock	118.775	119.48	118.53	119.23	11311117.0
2020-11-11 13:00:00	AAPL	Stock	119.22	119.56	119.04	119.12	8705448.0
2020-11-11 14:00:00	AAPL	Stock	119.11	119.54	118.71	118.925	9551172.0
2020-11-11 15:00:00	AAPL	Stock	118.93	119.63	118.81	119.495	13012704.0
2020-11-11 16:00:00	AAPL	Stock	119.49	119.73	119.47	119.59	6095778.0
2020-11-11 17:00:00	AAPL	Stock	119.59	120.07	119.0	119.57	654544.0
2020-11-11 18:00:00	AAPL	Stock	119.5	119.71	119.35	119.61	150831.0
2020-11-11 19:00:00	AAPL	Stock	119.64	119.64	119.35	119.35	121383.0
2020-11-11 04:00:00	MSFT	Stock	212.69	213.88	212.69	213.7	6388.0
2020-11-11 05:00:00	MSFT	Stock	213.9	214.2	213.2	213.44	7568.0
2020-11-11 06:00:00	MSFT	Stock	213.4	214.26	213.34	214.25	14472.0
2020-11-11 07:00:00	MSFT	Stock	213.92	214.19	213.23	213.92	48797.0
2020-11-11 08:00:00	MSFT	Stock	213.31	214.5	213.0	213.15	158210.0
2020-11-11 09:00:00	MSFT	Stock	213.1	215.69	212.2	215.37	3436622.0
2020-11-11 10:00:00	MSFT	Stock	215.38	216.68	214.7	215.64	3530127.0
2020-11-11 11:00:00	MSFT	Stock	215.62	216.93	215.15	216.915	2101604.0
2020-11-11 12:00:00	MSFT	Stock	216.928	217.41	216.38	216.98	1835277.0
2020-11-11 13:00:00	MSFT	Stock	216.99	217.51	216.449	217.26	1690826.0
2020-11-11 14:00:00	MSFT	Stock	217.28	218.04	216.19	216.32	1994549.0
2020-11-11 15:00:00	MSFT	Stock	216.27	217.16	216.031	216.4	2992434.0
2020-11-11 16:00:00	MSFT	Stock	216.55	217.3	216.528	216.98	3257652.0
2020-11-11 17:00:00	MSFT	Stock	216.77	216.9	216.77	216.8	3417.0
2020-11-11 18:00:00	MSFT	Stock	216.8	216.87	216.6	216.7	11165.0
2020-11-11 19:00:00	MSFT	Stock	216.7	216.73	216.4	216.4	9735.0
2020-11-11 04:00:00	NVDA	Stock	13.0175	13.035	12.975	13.035	77000.0
2020-11-11 05:00:00	NVDA	Stock	13.0462	13.05	13.0462	13.05	30760.0
2020-11-11 06:00:00	NVDA	Stock	13.0752	13.1125	13.0752	13.1125	24000.0
2020-11-11 07:00:00	NVDA	Stock	13.073	13.0975	13.0205	13.0378	603600.0
2020-11-11 08:00:00	NVDA	Stock	13.0325	13.08	12.8018	13.0363	2020200.0
2020-11-11 09:00:00	NVDA	Stock	13.035	13.2713	12.9482	13.225	68946200.0
2020-11-11 10:00:00	NVDA	Stock	13.2278	13.3017	13.088	13.175	61489200.0
2020-11-11 11:00:00	NVDA	Stock	13.1728	13.3688	13.1329	13.3602	35581320.0
2020-11-11 12:00:00	NVDA	Stock	13.3585	13.3873	13.2502	13.277	22761680.0
2020-11-11 13:00:00	NVDA	Stock	13.278	13.3773	13.2645	13.3189	25137440.0
2020-11-11 14:00:00	NVDA	Stock	13.3225	13.3795	13.2968	13.3118	27183080.0
2020-11-11 15:00:00	NVDA	Stock	13.3079	13.4349	13.3066	13.418	41619880.0
2020-11-11 16:00:00	NVDA	Stock	13.418	13.512	13.4	13.4625	18578320.0
2020-11-11 17:00:00	NVDA	Stock	13.45	13.45	13.4198	13.4362	710720.0
2020-11-11 18:00:00	NVDA	Stock	13.4408	13.4502	13.4372	13.4502	56960.0
2020-11-11 19:00:00	NVDA	Stock	13.4442	13.4613	13.4375	13.445	460760.0
2020-11-11 04:00:00	AMZN	Stock	153.7005	153.8995	153.5	153.875	20300.0
2020-11-11 05:00:00	AMZN	Stock	153.945	154.0	153.945	154.0	11480.0

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

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