PREVIEW / stock_1hour / 2019-08-06

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-06.parquet
  size:    1.1 MB
  rows:    50,304
  symbols: 2,562

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-08-06 04:00:00	AAPL	Stock	48.175	48.67	48.085	48.5225	212632.0
2019-08-06 05:00:00	AAPL	Stock	48.5	48.6975	48.435	48.565	108544.0
2019-08-06 06:00:00	AAPL	Stock	48.5625	48.625	48.45	48.48	95196.0
2019-08-06 07:00:00	AAPL	Stock	48.5	49.075	48.4375	49.075	1170380.0
2019-08-06 08:00:00	AAPL	Stock	48.465	49.1625	48.4275	48.965	1579580.0
2019-08-06 09:00:00	AAPL	Stock	48.9575	49.5168	48.895	49.2875	28512060.0
2019-08-06 10:00:00	AAPL	Stock	49.2825	49.38	48.6875	48.895	24290768.0
2019-08-06 11:00:00	AAPL	Stock	48.8975	48.9125	48.51	48.8342	12963332.0
2019-08-06 12:00:00	AAPL	Stock	48.8308	48.9438	48.675	48.765	8015024.0
2019-08-06 13:00:00	AAPL	Stock	48.766	49.245	48.765	49.13	10528568.0
2019-08-06 14:00:00	AAPL	Stock	49.1287	49.3575	48.9375	49.1175	12916204.0
2019-08-06 15:00:00	AAPL	Stock	49.125	49.3025	49.08	49.245	14349660.0
2019-08-06 16:00:00	AAPL	Stock	49.32	49.32	48.7588	49.2125	9018192.0
2019-08-06 17:00:00	AAPL	Stock	49.205	49.2375	49.15	49.2225	34936.0
2019-08-06 18:00:00	AAPL	Stock	49.2375	49.25	49.21	49.2125	19468.0
2019-08-06 19:00:00	AAPL	Stock	49.2	49.2375	48.9875	48.9875	68876.0
2019-08-06 04:00:00	MSFT	Stock	132.0	133.85	131.9	133.6	31100.0
2019-08-06 05:00:00	MSFT	Stock	133.41	133.82	133.39	133.4	4431.0
2019-08-06 06:00:00	MSFT	Stock	133.31	133.51	133.05	133.12	11044.0
2019-08-06 07:00:00	MSFT	Stock	133.3	134.13	133.0	133.66	74131.0
2019-08-06 08:00:00	MSFT	Stock	133.05	134.1	132.92	133.3	109709.0
2019-08-06 09:00:00	MSFT	Stock	133.28	134.94	133.22	134.822	4722428.0
2019-08-06 10:00:00	MSFT	Stock	134.835	135.68	133.96	134.35	4351627.0
2019-08-06 11:00:00	MSFT	Stock	134.35	134.39	133.21	133.95	2763933.0
2019-08-06 12:00:00	MSFT	Stock	133.96	134.24	133.22	133.37	2048946.0
2019-08-06 13:00:00	MSFT	Stock	133.38	134.48	133.37	134.33	1646329.0
2019-08-06 14:00:00	MSFT	Stock	134.34	135.11	133.86	134.41	2350041.0
2019-08-06 15:00:00	MSFT	Stock	134.43	134.96	134.21	134.66	3810283.0
2019-08-06 16:00:00	MSFT	Stock	134.69	134.74	133.475	134.5	3773673.0
2019-08-06 17:00:00	MSFT	Stock	134.55	134.66	134.49	134.49	10291.0
2019-08-06 18:00:00	MSFT	Stock	134.64	134.69	134.45	134.68	6929.0
2019-08-06 19:00:00	MSFT	Stock	134.48	134.64	134.02	134.39	11709.0
2019-08-06 04:00:00	NVDA	Stock	3.7625	3.815	3.7625	3.8098	151200.0
2019-08-06 05:00:00	NVDA	Stock	3.8098	3.83	3.8088	3.8265	201760.0
2019-08-06 06:00:00	NVDA	Stock	3.8228	3.8228	3.8	3.8172	129600.0
2019-08-06 07:00:00	NVDA	Stock	3.8118	3.8292	3.7938	3.8188	1375160.0
2019-08-06 08:00:00	NVDA	Stock	3.82	3.845	3.7905	3.8212	3664200.0
2019-08-06 09:00:00	NVDA	Stock	3.82	3.8908	3.8	3.8278	66902800.0
2019-08-06 10:00:00	NVDA	Stock	3.8252	3.8378	3.772	3.797	52946080.0
2019-08-06 11:00:00	NVDA	Stock	3.7968	3.7978	3.7608	3.7942	32002120.0
2019-08-06 12:00:00	NVDA	Stock	3.794	3.801	3.7755	3.776	16668480.0
2019-08-06 13:00:00	NVDA	Stock	3.7768	3.8066	3.7758	3.7918	22572720.0
2019-08-06 14:00:00	NVDA	Stock	3.7908	3.8225	3.7778	3.8078	30555920.0
2019-08-06 15:00:00	NVDA	Stock	3.808	3.8165	3.7945	3.8085	44538760.0
2019-08-06 16:00:00	NVDA	Stock	3.8088	3.815	3.796	3.815	15598480.0
2019-08-06 17:00:00	NVDA	Stock	3.8125	3.8125	3.8095	3.8095	12000.0
2019-08-06 18:00:00	NVDA	Stock	3.81	3.8182	3.81	3.8182	73280.0
2019-08-06 19:00:00	NVDA	Stock	3.8125	3.8142	3.7938	3.8075	422880.0
2019-08-06 04:00:00	AMZN	Stock	88.165	89.1	88.165	89.048	34400.0
2019-08-06 05:00:00	AMZN	Stock	89.101	89.5	88.9585	89.275	38540.0

> showing 50 of 50,304 rows — these rows as CSV

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