PREVIEW / stock_1hour / 2019-04-15

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-15.parquet
  size:    1.1 MB
  rows:    49,461
  symbols: 2,631

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-04-15 04:00:00	AAPL	Stock	49.695	49.7	49.61	49.68	2508.0
2019-04-15 07:00:00	AAPL	Stock	49.68	49.7325	49.5725	49.575	55268.0
2019-04-15 08:00:00	AAPL	Stock	49.7295	49.8425	49.5375	49.655	113304.0
2019-04-15 09:00:00	AAPL	Stock	49.65	49.9625	49.6	49.76	11045100.0
2019-04-15 10:00:00	AAPL	Stock	49.76	49.7862	49.5025	49.651	9912560.0
2019-04-15 11:00:00	AAPL	Stock	49.65	49.845	49.625	49.6545	7337112.0
2019-04-15 12:00:00	AAPL	Stock	49.65	49.7125	49.625	49.68	4662880.0
2019-04-15 13:00:00	AAPL	Stock	49.6775	49.7525	49.6725	49.715	3904832.0
2019-04-15 14:00:00	AAPL	Stock	49.715	49.79	49.7025	49.7775	4904128.0
2019-04-15 15:00:00	AAPL	Stock	49.7775	49.8325	49.725	49.8075	8832612.0
2019-04-15 16:00:00	AAPL	Stock	49.8075	49.8075	49.755	49.7752	10415620.0
2019-04-15 17:00:00	AAPL	Stock	49.775	49.7875	49.7575	49.7575	18640.0
2019-04-15 18:00:00	AAPL	Stock	49.7725	49.795	49.7575	49.795	10736.0
2019-04-15 19:00:00	AAPL	Stock	49.8	49.8375	49.8	49.825	30524.0
2019-04-15 06:00:00	MSFT	Stock	121.2	121.2	121.11	121.11	1300.0
2019-04-15 07:00:00	MSFT	Stock	121.07	121.1	120.98	121.0	5654.0
2019-04-15 08:00:00	MSFT	Stock	121.132	121.132	120.93	120.98	8037.0
2019-04-15 09:00:00	MSFT	Stock	120.98	121.58	120.81	121.32	1956922.0
2019-04-15 10:00:00	MSFT	Stock	121.32	121.35	120.57	120.85	1885093.0
2019-04-15 11:00:00	MSFT	Stock	120.85	121.065	120.73	120.92	1403657.0
2019-04-15 12:00:00	MSFT	Stock	120.925	120.95	120.75	120.825	1027058.0
2019-04-15 13:00:00	MSFT	Stock	120.825	120.995	120.78	120.945	1056239.0
2019-04-15 14:00:00	MSFT	Stock	120.94	121.14	120.93	121.104	1590645.0
2019-04-15 15:00:00	MSFT	Stock	121.11	121.26	121.02	121.06	2206544.0
2019-04-15 16:00:00	MSFT	Stock	121.05	121.1	120.91	120.91	2337410.0
2019-04-15 17:00:00	MSFT	Stock	121.05	121.08	121.0	121.05	2494.0
2019-04-15 18:00:00	MSFT	Stock	121.05	121.1	121.05	121.1	1406.0
2019-04-15 19:00:00	MSFT	Stock	121.1	121.15	121.05	121.05	5244.0
2019-04-15 05:00:00	NVDA	Stock	4.7442	4.7442	4.7442	4.7442	14840.0
2019-04-15 06:00:00	NVDA	Stock	4.7472	4.7472	4.7412	4.745	47920.0
2019-04-15 07:00:00	NVDA	Stock	4.742	4.742	4.728	4.7375	91960.0
2019-04-15 08:00:00	NVDA	Stock	4.7377	4.7625	4.726	4.7325	734640.0
2019-04-15 09:00:00	NVDA	Stock	4.7325	4.7475	4.656	4.6697	68027600.0
2019-04-15 10:00:00	NVDA	Stock	4.6695	4.6702	4.5775	4.6042	110092880.0
2019-04-15 11:00:00	NVDA	Stock	4.6048	4.6285	4.6018	4.6238	44660360.0
2019-04-15 12:00:00	NVDA	Stock	4.624	4.6269	4.5985	4.6158	36198200.0
2019-04-15 13:00:00	NVDA	Stock	4.6159	4.635	4.6153	4.6218	28421040.0
2019-04-15 14:00:00	NVDA	Stock	4.622	4.6285	4.6098	4.6206	26306680.0
2019-04-15 15:00:00	NVDA	Stock	4.621	4.6238	4.598	4.6175	63513960.0
2019-04-15 16:00:00	NVDA	Stock	4.6175	4.618	4.6062	4.6138	24240200.0
2019-04-15 17:00:00	NVDA	Stock	4.6154	4.6162	4.6088	4.6128	209120.0
2019-04-15 18:00:00	NVDA	Stock	4.613	4.615	4.6108	4.6115	143720.0
2019-04-15 19:00:00	NVDA	Stock	4.612	4.615	4.6108	4.6108	207840.0
2019-04-15 05:00:00	AMZN	Stock	92.25	92.25	92.25	92.25	2000.0
2019-04-15 07:00:00	AMZN	Stock	92.1915	92.1915	92.05	92.05	9300.0
2019-04-15 08:00:00	AMZN	Stock	92.0341	92.1314	92.015	92.085	77160.0
2019-04-15 09:00:00	AMZN	Stock	92.095	92.1495	91.655	91.8	6448560.0
2019-04-15 10:00:00	AMZN	Stock	91.8075	91.835	90.945	91.15	9728120.0
2019-04-15 11:00:00	AMZN	Stock	91.1715	91.6795	91.1025	91.5735	5081680.0
2019-04-15 12:00:00	AMZN	Stock	91.568	91.742	91.4645	91.65	2983020.0

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

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