PREVIEW / stock_1hour / 2019-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-12-03.parquet
  size:    1.1 MB
  rows:    50,809
  symbols: 2,481

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-03 04:00:00	AAPL	Stock	66.2475	66.25	66.0375	66.0375	26912.0
2019-12-03 05:00:00	AAPL	Stock	66.02	66.0225	65.435	65.5025	123936.0
2019-12-03 06:00:00	AAPL	Stock	65.5025	65.67	65.4975	65.65	33016.0
2019-12-03 07:00:00	AAPL	Stock	65.635	65.6875	65.165	65.1825	393256.0
2019-12-03 08:00:00	AAPL	Stock	65.525	65.6375	64.6575	64.6825	1242220.0
2019-12-03 09:00:00	AAPL	Stock	64.6925	64.81	64.0725	64.44	24436424.0
2019-12-03 10:00:00	AAPL	Stock	64.44	64.6125	64.2025	64.2475	17478732.0
2019-12-03 11:00:00	AAPL	Stock	64.2525	64.485	64.12	64.395	10978400.0
2019-12-03 12:00:00	AAPL	Stock	64.393	64.5725	64.29	64.4925	7656936.0
2019-12-03 13:00:00	AAPL	Stock	64.495	64.8298	64.4775	64.639	9414376.0
2019-12-03 14:00:00	AAPL	Stock	64.6382	64.7375	64.465	64.61	6547412.0
2019-12-03 15:00:00	AAPL	Stock	64.62	64.8825	64.565	64.88	11669188.0
2019-12-03 16:00:00	AAPL	Stock	64.8625	64.95	64.8175	64.9375	9812856.0
2019-12-03 17:00:00	AAPL	Stock	64.9375	64.94	64.8975	64.925	70956.0
2019-12-03 18:00:00	AAPL	Stock	64.9125	64.9725	64.9	64.97	43772.0
2019-12-03 19:00:00	AAPL	Stock	64.96	64.98	64.6925	64.7725	122656.0
2019-12-03 04:00:00	MSFT	Stock	149.53	149.93	149.53	149.68	5169.0
2019-12-03 05:00:00	MSFT	Stock	149.8	149.8	148.71	148.79	8091.0
2019-12-03 06:00:00	MSFT	Stock	148.74	148.98	148.67	148.98	1578.0
2019-12-03 07:00:00	MSFT	Stock	148.89	148.91	147.91	148.1	60020.0
2019-12-03 08:00:00	MSFT	Stock	148.7	149.92	147.4	147.48	103496.0
2019-12-03 09:00:00	MSFT	Stock	147.46	147.963	146.65	147.8	3646537.0
2019-12-03 10:00:00	MSFT	Stock	147.81	148.41	147.39	147.93	3269387.0
2019-12-03 11:00:00	MSFT	Stock	147.96	148.23	147.77	148.205	1997223.0
2019-12-03 12:00:00	MSFT	Stock	148.21	148.4	147.95	148.26	1373367.0
2019-12-03 13:00:00	MSFT	Stock	148.26	148.89	148.2	148.57	1694339.0
2019-12-03 14:00:00	MSFT	Stock	148.56	148.71	148.28	148.54	1112923.0
2019-12-03 15:00:00	MSFT	Stock	148.56	149.43	148.37	149.32	3317450.0
2019-12-03 16:00:00	MSFT	Stock	149.31	149.61	148.3	149.23	3875786.0
2019-12-03 17:00:00	MSFT	Stock	149.3	149.45	149.3	149.3	9788.0
2019-12-03 18:00:00	MSFT	Stock	149.3	149.4	149.3	149.39	2784.0
2019-12-03 19:00:00	MSFT	Stock	149.44	149.5	149.09	149.12	4663.0
2019-12-03 04:00:00	NVDA	Stock	5.2368	5.2368	5.2245	5.225	239160.0
2019-12-03 05:00:00	NVDA	Stock	5.229	5.229	5.1325	5.1423	547720.0
2019-12-03 06:00:00	NVDA	Stock	5.1378	5.16	5.13	5.16	161400.0
2019-12-03 07:00:00	NVDA	Stock	5.1523	5.1638	5.0805	5.088	1635640.0
2019-12-03 08:00:00	NVDA	Stock	5.1266	5.1629	5.05	5.05	3853280.0
2019-12-03 09:00:00	NVDA	Stock	5.05	5.0848	5.0093	5.0508	108787160.0
2019-12-03 10:00:00	NVDA	Stock	5.05	5.135	5.048	5.098	78307800.0
2019-12-03 11:00:00	NVDA	Stock	5.0995	5.1225	5.0725	5.098	54035680.0
2019-12-03 12:00:00	NVDA	Stock	5.0988	5.1492	5.0908	5.1371	45356080.0
2019-12-03 13:00:00	NVDA	Stock	5.1375	5.1622	5.1348	5.1483	32234960.0
2019-12-03 14:00:00	NVDA	Stock	5.1481	5.1576	5.1348	5.1475	22745160.0
2019-12-03 15:00:00	NVDA	Stock	5.1485	5.1955	5.1438	5.1918	47057080.0
2019-12-03 16:00:00	NVDA	Stock	5.1915	5.1915	5.1828	5.1915	10678960.0
2019-12-03 17:00:00	NVDA	Stock	5.1833	5.193	5.182	5.193	263560.0
2019-12-03 18:00:00	NVDA	Stock	5.1915	5.1975	5.1915	5.1975	96200.0
2019-12-03 19:00:00	NVDA	Stock	5.1988	5.2	5.1812	5.188	447000.0
2019-12-03 04:00:00	AMZN	Stock	89.222	89.222	89.222	89.222	4000.0
2019-12-03 05:00:00	AMZN	Stock	89.2	89.2	88.654	88.8495	15460.0

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

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