PREVIEW / stock_1hour / 2019-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-15.parquet
  size:    1.1 MB
  rows:    49,614
  symbols: 2,500

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-11-15 04:00:00	AAPL	Stock	65.86	65.9575	65.7675	65.9525	80764.0
2019-11-15 05:00:00	AAPL	Stock	65.9375	65.97	65.7825	65.8275	41736.0
2019-11-15 06:00:00	AAPL	Stock	65.8	65.9625	65.7875	65.9175	54756.0
2019-11-15 07:00:00	AAPL	Stock	65.8875	65.9625	65.875	65.9225	213964.0
2019-11-15 08:00:00	AAPL	Stock	65.934	65.9975	65.8725	65.9625	428688.0
2019-11-15 09:00:00	AAPL	Stock	65.9625	66.145	65.82	65.8415	16506620.0
2019-11-15 10:00:00	AAPL	Stock	65.8375	66.0625	65.7525	66.0238	12454280.0
2019-11-15 11:00:00	AAPL	Stock	66.025	66.1975	66.025	66.0525	10005404.0
2019-11-15 12:00:00	AAPL	Stock	66.0537	66.22	66.0188	66.11	6882588.0
2019-11-15 13:00:00	AAPL	Stock	66.115	66.27	66.06	66.22	7181088.0
2019-11-15 14:00:00	AAPL	Stock	66.2225	66.3075	66.1925	66.2675	7335656.0
2019-11-15 15:00:00	AAPL	Stock	66.2675	66.445	66.1775	66.4375	16999296.0
2019-11-15 16:00:00	AAPL	Stock	66.44	66.5	66.3775	66.475	9348628.0
2019-11-15 17:00:00	AAPL	Stock	66.4775	66.52	66.45	66.48	105632.0
2019-11-15 18:00:00	AAPL	Stock	66.4625	66.4775	66.45	66.465	60788.0
2019-11-15 19:00:00	AAPL	Stock	66.4725	66.525	66.4525	66.525	95220.0
2019-11-15 04:00:00	MSFT	Stock	148.48	148.77	148.48	148.77	710.0
2019-11-15 05:00:00	MSFT	Stock	148.75	148.83	148.46	148.67	5970.0
2019-11-15 06:00:00	MSFT	Stock	148.55	148.55	148.51	148.52	1918.0
2019-11-15 07:00:00	MSFT	Stock	148.79	148.79	148.5	148.51	12718.0
2019-11-15 08:00:00	MSFT	Stock	148.52	148.74	148.4	148.73	28133.0
2019-11-15 09:00:00	MSFT	Stock	148.72	149.4	148.27	148.73	3730792.0
2019-11-15 10:00:00	MSFT	Stock	148.72	149.56	148.66	149.55	2801537.0
2019-11-15 11:00:00	MSFT	Stock	149.55	149.81	149.47	149.56	2202526.0
2019-11-15 12:00:00	MSFT	Stock	149.574	149.85	149.52	149.64	1511413.0
2019-11-15 13:00:00	MSFT	Stock	149.635	149.71	149.46	149.49	953209.0
2019-11-15 14:00:00	MSFT	Stock	149.49	149.67	149.47	149.65	953345.0
2019-11-15 15:00:00	MSFT	Stock	149.657	149.99	149.33	149.95	3709184.0
2019-11-15 16:00:00	MSFT	Stock	149.97	150.1	149.86	149.99	5062742.0
2019-11-15 17:00:00	MSFT	Stock	150.0	150.09	149.96	150.02	11783.0
2019-11-15 18:00:00	MSFT	Stock	150.0	150.02	149.9	149.95	12393.0
2019-11-15 19:00:00	MSFT	Stock	149.9	149.97	149.85	149.93	11076.0
2019-11-15 04:00:00	NVDA	Stock	5.2165	5.2688	5.2125	5.2435	752160.0
2019-11-15 05:00:00	NVDA	Stock	5.2585	5.2588	5.225	5.225	215880.0
2019-11-15 06:00:00	NVDA	Stock	5.2308	5.2875	5.2308	5.2765	727120.0
2019-11-15 07:00:00	NVDA	Stock	5.2708	5.275	5.23	5.239	7561000.0
2019-11-15 08:00:00	NVDA	Stock	5.2438	5.2735	5.2262	5.2448	8515040.0
2019-11-15 09:00:00	NVDA	Stock	5.2492	5.2945	5.1038	5.1068	194803320.0
2019-11-15 10:00:00	NVDA	Stock	5.1078	5.1245	5.016	5.1006	224845560.0
2019-11-15 11:00:00	NVDA	Stock	5.101	5.1803	5.0988	5.15	135172920.0
2019-11-15 12:00:00	NVDA	Stock	5.1512	5.168	5.1018	5.1048	78299000.0
2019-11-15 13:00:00	NVDA	Stock	5.1038	5.125	5.0925	5.1172	62313240.0
2019-11-15 14:00:00	NVDA	Stock	5.116	5.1428	5.1125	5.1169	39390600.0
2019-11-15 15:00:00	NVDA	Stock	5.1169	5.1169	5.054	5.103	121287600.0
2019-11-15 16:00:00	NVDA	Stock	5.1048	5.1105	5.093	5.0975	34061400.0
2019-11-15 17:00:00	NVDA	Stock	5.0955	5.1048	5.0955	5.1	1910880.0
2019-11-15 18:00:00	NVDA	Stock	5.0982	5.1	5.0975	5.098	292920.0
2019-11-15 19:00:00	NVDA	Stock	5.098	5.1025	5.0963	5.101	226880.0
2019-11-15 04:00:00	AMZN	Stock	87.903	88.05	87.9	88.05	27200.0
2019-11-15 05:00:00	AMZN	Stock	88.011	88.011	88.011	88.011	2820.0

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

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