PREVIEW / stock_1hour / 2020-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-04.parquet
  size:    1.2 MB
  rows:    52,455
  symbols: 2,414

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-03-04 04:00:00	AAPL	Stock	73.675	74.025	73.45	73.9625	119012.0
2020-03-04 05:00:00	AAPL	Stock	73.9725	74.105	73.85	73.9525	54264.0
2020-03-04 06:00:00	AAPL	Stock	73.9975	74.125	73.75	74.075	90136.0
2020-03-04 07:00:00	AAPL	Stock	74.0975	74.6225	73.95	74.3	1148932.0
2020-03-04 08:00:00	AAPL	Stock	74.325	74.6225	73.75	74.1	1629332.0
2020-03-04 09:00:00	AAPL	Stock	74.125	74.62	73.2825	73.6825	27415224.0
2020-03-04 10:00:00	AAPL	Stock	73.705	74.545	73.59	73.7975	30263760.0
2020-03-04 11:00:00	AAPL	Stock	73.805	74.3575	73.585	73.8475	17073112.0
2020-03-04 12:00:00	AAPL	Stock	73.8625	74.7475	73.8325	74.735	14132888.0
2020-03-04 13:00:00	AAPL	Stock	74.73	75.185	74.635	74.7345	22615344.0
2020-03-04 14:00:00	AAPL	Stock	74.74	75.0475	74.455	74.774	17432604.0
2020-03-04 15:00:00	AAPL	Stock	74.77	75.85	74.5925	75.69	36995796.0
2020-03-04 16:00:00	AAPL	Stock	75.6625	75.7275	73.8398	75.4	13889008.0
2020-03-04 17:00:00	AAPL	Stock	75.3775	75.4475	75.3675	75.415	81428.0
2020-03-04 18:00:00	AAPL	Stock	75.4125	75.435	75.1275	75.2525	206200.0
2020-03-04 19:00:00	AAPL	Stock	75.2225	75.2475	75.0	75.075	273216.0
2020-03-04 04:00:00	MSFT	Stock	167.9	168.41	167.64	168.2	18517.0
2020-03-04 05:00:00	MSFT	Stock	168.3	168.93	168.2	168.75	9596.0
2020-03-04 06:00:00	MSFT	Stock	168.5	168.66	167.9	168.46	10280.0
2020-03-04 07:00:00	MSFT	Stock	168.3	169.1	167.75	168.5	135712.0
2020-03-04 08:00:00	MSFT	Stock	168.43	169.1	167.25	167.84	221213.0
2020-03-04 09:00:00	MSFT	Stock	167.85	169.28	165.94	167.36	6079580.0
2020-03-04 10:00:00	MSFT	Stock	167.34	168.9	166.45	166.87	5055190.0
2020-03-04 11:00:00	MSFT	Stock	166.89	167.65	165.62	166.01	3916919.0
2020-03-04 12:00:00	MSFT	Stock	166.039	168.02	166.039	168.02	2936151.0
2020-03-04 13:00:00	MSFT	Stock	168.01	168.8	167.6	167.95	3257598.0
2020-03-04 14:00:00	MSFT	Stock	167.95	168.64	167.3	167.866	3651942.0
2020-03-04 15:00:00	MSFT	Stock	167.86	170.7	167.57	170.54	9817492.0
2020-03-04 16:00:00	MSFT	Stock	170.49	170.7	168.87	169.58	7248755.0
2020-03-04 17:00:00	MSFT	Stock	169.51	170.18	169.51	169.65	23172.0
2020-03-04 18:00:00	MSFT	Stock	169.86	169.86	169.2	169.45	26006.0
2020-03-04 19:00:00	MSFT	Stock	169.43	169.64	168.86	169.0	47139.0
2020-03-04 04:00:00	NVDA	Stock	6.7675	6.825	6.7675	6.817	155720.0
2020-03-04 05:00:00	NVDA	Stock	6.823	6.825	6.81	6.8125	57960.0
2020-03-04 06:00:00	NVDA	Stock	6.8125	6.823	6.795	6.823	61960.0
2020-03-04 07:00:00	NVDA	Stock	6.81	6.8373	6.774	6.8172	2578880.0
2020-03-04 08:00:00	NVDA	Stock	6.797	6.8373	6.775	6.79	3239200.0
2020-03-04 09:00:00	NVDA	Stock	6.796	6.8038	6.68	6.7352	61869280.0
2020-03-04 10:00:00	NVDA	Stock	6.7314	6.9038	6.7081	6.8397	117626440.0
2020-03-04 11:00:00	NVDA	Stock	6.8378	6.901	6.803	6.8705	54803400.0
2020-03-04 12:00:00	NVDA	Stock	6.8686	6.983	6.8686	6.9782	64553080.0
2020-03-04 13:00:00	NVDA	Stock	6.9788	7.016	6.9502	6.998	52680080.0
2020-03-04 14:00:00	NVDA	Stock	6.9963	7.0105	6.928	6.9626	46862880.0
2020-03-04 15:00:00	NVDA	Stock	6.9598	7.1222	6.9582	7.114	99291200.0
2020-03-04 16:00:00	NVDA	Stock	7.1128	7.1128	7.0665	7.0795	4525560.0
2020-03-04 17:00:00	NVDA	Stock	7.0758	7.0908	7.075	7.0855	327880.0
2020-03-04 18:00:00	NVDA	Stock	7.075	7.075	7.0538	7.07	525200.0
2020-03-04 19:00:00	NVDA	Stock	7.0625	7.0795	7.0498	7.0795	637400.0
2020-03-04 04:00:00	AMZN	Stock	97.047	97.047	96.995	96.995	4000.0
2020-03-04 05:00:00	AMZN	Stock	97.35	97.35	97.35	97.35	2000.0

> showing 50 of 52,455 rows — these rows as CSV

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