PREVIEW / stock_1hour / 2019-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-26.parquet
  size:    1.1 MB
  rows:    49,013
  symbols: 2,506

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-09-26 04:00:00	AAPL	Stock	55.25	55.375	55.2425	55.37	18176.0
2019-09-26 05:00:00	AAPL	Stock	55.3	55.3	55.175	55.175	14812.0
2019-09-26 06:00:00	AAPL	Stock	55.205	55.205	55.125	55.175	26456.0
2019-09-26 07:00:00	AAPL	Stock	55.175	55.2325	55.15	55.23	50684.0
2019-09-26 08:00:00	AAPL	Stock	55.1775	55.2325	55.0275	55.1075	299944.0
2019-09-26 09:00:00	AAPL	Stock	55.0775	55.1	54.7075	54.8075	9143080.0
2019-09-26 10:00:00	AAPL	Stock	54.8088	55.205	54.7775	55.0112	11033420.0
2019-09-26 11:00:00	AAPL	Stock	55.01	55.04	54.8008	54.99	8376164.0
2019-09-26 12:00:00	AAPL	Stock	54.9925	55.1075	54.9025	54.9675	4868264.0
2019-09-26 13:00:00	AAPL	Stock	54.9675	55.04	54.9125	55.0375	4156876.0
2019-09-26 14:00:00	AAPL	Stock	55.04	55.1725	54.995	55.0138	4948176.0
2019-09-26 15:00:00	AAPL	Stock	55.012	55.235	54.87	54.9725	9932024.0
2019-09-26 16:00:00	AAPL	Stock	54.98	54.98	54.865	54.8825	8780472.0
2019-09-26 17:00:00	AAPL	Stock	54.9	54.9725	54.8875	54.925	38604.0
2019-09-26 18:00:00	AAPL	Stock	54.92	54.9625	54.92	54.9375	8472.0
2019-09-26 19:00:00	AAPL	Stock	54.9375	54.96	54.9075	54.925	24580.0
2019-09-26 04:00:00	MSFT	Stock	139.23	139.63	139.23	139.63	1911.0
2019-09-26 05:00:00	MSFT	Stock	139.67	139.67	139.65	139.65	588.0
2019-09-26 06:00:00	MSFT	Stock	139.65	139.65	139.65	139.65	1587.0
2019-09-26 07:00:00	MSFT	Stock	139.65	139.65	139.49	139.5	12609.0
2019-09-26 08:00:00	MSFT	Stock	139.77	139.77	139.2	139.5	26034.0
2019-09-26 09:00:00	MSFT	Stock	139.38	139.79	138.89	139.27	1687000.0
2019-09-26 10:00:00	MSFT	Stock	139.265	139.89	139.07	139.35	2025406.0
2019-09-26 11:00:00	MSFT	Stock	139.35	139.395	138.44	138.75	1713316.0
2019-09-26 12:00:00	MSFT	Stock	138.75	139.41	138.59	139.1	977230.0
2019-09-26 13:00:00	MSFT	Stock	139.1	139.28	138.73	139.27	1069419.0
2019-09-26 14:00:00	MSFT	Stock	139.28	139.96	139.28	139.63	1497685.0
2019-09-26 15:00:00	MSFT	Stock	139.637	140.18	139.39	139.57	2784570.0
2019-09-26 16:00:00	MSFT	Stock	139.54	139.73	139.26	139.43	2738105.0
2019-09-26 17:00:00	MSFT	Stock	139.48	139.54	139.42	139.53	16890.0
2019-09-26 18:00:00	MSFT	Stock	139.53	139.67	139.47	139.47	1980.0
2019-09-26 19:00:00	MSFT	Stock	139.54	139.54	139.41	139.41	7133.0
2019-09-26 04:00:00	NVDA	Stock	4.4608	4.4625	4.4608	4.4625	20000.0
2019-09-26 05:00:00	NVDA	Stock	4.467	4.467	4.4655	4.4655	12000.0
2019-09-26 07:00:00	NVDA	Stock	4.4668	4.4745	4.4668	4.4713	105280.0
2019-09-26 08:00:00	NVDA	Stock	4.4713	4.4728	4.4425	4.453	530000.0
2019-09-26 09:00:00	NVDA	Stock	4.4562	4.4575	4.4028	4.4142	34806400.0
2019-09-26 10:00:00	NVDA	Stock	4.4139	4.4513	4.389	4.4221	40788200.0
2019-09-26 11:00:00	NVDA	Stock	4.421	4.4242	4.3822	4.3998	28641440.0
2019-09-26 12:00:00	NVDA	Stock	4.4012	4.4215	4.3943	4.4114	19692280.0
2019-09-26 13:00:00	NVDA	Stock	4.412	4.4176	4.3915	4.4042	15349840.0
2019-09-26 14:00:00	NVDA	Stock	4.4045	4.4265	4.4045	4.414	17603000.0
2019-09-26 15:00:00	NVDA	Stock	4.4145	4.449	4.4133	4.4343	37369800.0
2019-09-26 16:00:00	NVDA	Stock	4.4335	4.4487	4.375	4.3995	8875640.0
2019-09-26 17:00:00	NVDA	Stock	4.3875	4.4335	4.365	4.3675	1693520.0
2019-09-26 18:00:00	NVDA	Stock	4.3653	4.375	4.3653	4.375	331440.0
2019-09-26 19:00:00	NVDA	Stock	4.373	4.373	4.36	4.36	158200.0
2019-09-26 07:00:00	AMZN	Stock	88.565	88.5745	88.5	88.5	25220.0
2019-09-26 08:00:00	AMZN	Stock	88.4665	88.5745	88.066	88.2	287320.0
2019-09-26 09:00:00	AMZN	Stock	88.15	88.1685	87.1	87.2207	10837440.0

> showing 50 of 49,013 rows — these rows as CSV

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