PREVIEW / stock_1hour / 2019-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-31.parquet
  size:    1.2 MB
  rows:    51,112
  symbols: 2,494

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-12-31 04:00:00	AAPL	Stock	72.85	72.85	72.75	72.75	1200.0
2019-12-31 05:00:00	AAPL	Stock	72.8225	72.85	72.8225	72.85	3200.0
2019-12-31 06:00:00	AAPL	Stock	72.825	72.825	72.75	72.75	1200.0
2019-12-31 07:00:00	AAPL	Stock	72.8125	72.825	72.625	72.675	115088.0
2019-12-31 08:00:00	AAPL	Stock	72.8	72.8125	72.52	72.575	247436.0
2019-12-31 09:00:00	AAPL	Stock	72.575	73.22	72.38	73.04	13637724.0
2019-12-31 10:00:00	AAPL	Stock	73.045	73.075	72.67	72.7675	13181108.0
2019-12-31 11:00:00	AAPL	Stock	72.7662	73.065	72.745	73.01	9712748.0
2019-12-31 12:00:00	AAPL	Stock	73.0125	73.1175	72.9325	73.015	6222212.0
2019-12-31 13:00:00	AAPL	Stock	73.01	73.075	72.97	73.0515	4968000.0
2019-12-31 14:00:00	AAPL	Stock	73.0525	73.1175	72.9975	73.09	5883284.0
2019-12-31 15:00:00	AAPL	Stock	73.0875	73.42	73.065	73.3425	20857252.0
2019-12-31 16:00:00	AAPL	Stock	73.3	73.4725	73.3	73.455	11474520.0
2019-12-31 17:00:00	AAPL	Stock	73.4425	73.46	73.425	73.425	119244.0
2019-12-31 18:00:00	AAPL	Stock	73.425	73.46	73.425	73.4525	56124.0
2019-12-31 19:00:00	AAPL	Stock	73.44	73.4575	73.275	73.42	128516.0
2019-12-31 07:00:00	MSFT	Stock	157.5	157.5	157.25	157.34	900.0
2019-12-31 08:00:00	MSFT	Stock	157.27	157.7	156.9	156.9	19955.0
2019-12-31 09:00:00	MSFT	Stock	157.0	157.63	156.49	157.25	1457756.0
2019-12-31 10:00:00	MSFT	Stock	157.25	157.36	156.68	156.85	1416517.0
2019-12-31 11:00:00	MSFT	Stock	156.85	157.02	156.45	156.883	1528522.0
2019-12-31 12:00:00	MSFT	Stock	156.89	157.0	156.68	156.9	784701.0
2019-12-31 13:00:00	MSFT	Stock	156.905	157.02	156.821	156.993	653537.0
2019-12-31 14:00:00	MSFT	Stock	156.995	157.32	156.76	157.284	952455.0
2019-12-31 15:00:00	MSFT	Stock	157.28	157.77	157.18	157.49	3472071.0
2019-12-31 16:00:00	MSFT	Stock	157.7	158.02	157.66	157.94	4622619.0
2019-12-31 17:00:00	MSFT	Stock	157.93	157.93	157.8	157.83	2393.0
2019-12-31 18:00:00	MSFT	Stock	157.83	157.88	157.81	157.88	2468.0
2019-12-31 19:00:00	MSFT	Stock	157.89	157.89	157.7	157.85	19708.0
2019-12-31 06:00:00	NVDA	Stock	5.808	5.808	5.808	5.808	14640.0
2019-12-31 07:00:00	NVDA	Stock	5.8	5.8013	5.7875	5.7875	77600.0
2019-12-31 08:00:00	NVDA	Stock	5.7863	5.8078	5.765	5.7675	604480.0
2019-12-31 09:00:00	NVDA	Stock	5.7662	5.8919	5.753	5.8738	38965000.0
2019-12-31 10:00:00	NVDA	Stock	5.8763	5.8775	5.8212	5.8258	28780760.0
2019-12-31 11:00:00	NVDA	Stock	5.8246	5.853	5.816	5.8475	18842400.0
2019-12-31 12:00:00	NVDA	Stock	5.8475	5.8822	5.8448	5.872	26441040.0
2019-12-31 13:00:00	NVDA	Stock	5.8716	5.8802	5.8602	5.8738	11064960.0
2019-12-31 14:00:00	NVDA	Stock	5.8752	5.8753	5.8575	5.8688	11814360.0
2019-12-31 15:00:00	NVDA	Stock	5.8675	5.8858	5.864	5.8838	37529360.0
2019-12-31 16:00:00	NVDA	Stock	5.8825	5.8875	5.8825	5.8832	12314000.0
2019-12-31 17:00:00	NVDA	Stock	5.8875	5.8938	5.884	5.8863	130880.0
2019-12-31 18:00:00	NVDA	Stock	5.8925	5.8925	5.8888	5.8888	14200.0
2019-12-31 19:00:00	NVDA	Stock	5.89	5.8938	5.8895	5.8895	161720.0
2019-12-31 07:00:00	AMZN	Stock	92.1	92.2055	92.1	92.2055	31520.0
2019-12-31 08:00:00	AMZN	Stock	92.225	92.325	92.15	92.2	93700.0
2019-12-31 09:00:00	AMZN	Stock	92.1255	92.663	91.6115	92.45	8842880.0
2019-12-31 10:00:00	AMZN	Stock	92.45	92.4775	91.8655	91.925	6214720.0
2019-12-31 11:00:00	AMZN	Stock	91.945	92.1805	91.8315	92.109	4382840.0
2019-12-31 12:00:00	AMZN	Stock	92.1	92.25	92.0265	92.1805	1963100.0
2019-12-31 13:00:00	AMZN	Stock	92.1773	92.2762	92.0547	92.2625	2202420.0

> showing 50 of 51,112 rows — these rows as CSV

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