PREVIEW / stock_1hour / 2019-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-06-14.parquet
  size:    1.1 MB
  rows:    48,904
  symbols: 2,597

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-06-14 04:00:00	AAPL	Stock	48.1625	48.1625	47.7925	47.7925	24972.0
2019-06-14 05:00:00	AAPL	Stock	47.7925	47.7925	47.6625	47.775	45532.0
2019-06-14 06:00:00	AAPL	Stock	47.7625	47.7625	47.53	47.6675	35572.0
2019-06-14 07:00:00	AAPL	Stock	47.72	48.1	47.72	48.0775	380024.0
2019-06-14 08:00:00	AAPL	Stock	47.8125	48.0875	47.685	47.915	391000.0
2019-06-14 09:00:00	AAPL	Stock	47.9148	48.037	47.575	47.6612	12828096.0
2019-06-14 10:00:00	AAPL	Stock	47.66	48.185	47.62	48.1325	11426256.0
2019-06-14 11:00:00	AAPL	Stock	48.1325	48.1675	47.8388	48.0775	8209272.0
2019-06-14 12:00:00	AAPL	Stock	48.075	48.155	48.02	48.1175	3628332.0
2019-06-14 13:00:00	AAPL	Stock	48.115	48.235	48.095	48.15	3256460.0
2019-06-14 14:00:00	AAPL	Stock	48.15	48.2725	48.1425	48.2537	5154912.0
2019-06-14 15:00:00	AAPL	Stock	48.25	48.3965	48.17	48.185	11070552.0
2019-06-14 16:00:00	AAPL	Stock	48.185	48.235	48.1325	48.15	5477944.0
2019-06-14 17:00:00	AAPL	Stock	48.1575	48.185	48.145	48.185	167292.0
2019-06-14 18:00:00	AAPL	Stock	48.1575	48.175	48.1575	48.175	5000.0
2019-06-14 19:00:00	AAPL	Stock	48.175	48.215	48.16	48.215	15368.0
2019-06-14 06:00:00	MSFT	Stock	131.8	131.8	131.73	131.73	2102.0
2019-06-14 07:00:00	MSFT	Stock	131.96	132.2	131.76	132.1	8348.0
2019-06-14 08:00:00	MSFT	Stock	131.76	132.14	131.76	132.1	17140.0
2019-06-14 09:00:00	MSFT	Stock	132.01	132.28	131.64	132.08	1683451.0
2019-06-14 10:00:00	MSFT	Stock	132.07	132.91	131.94	132.6	2412090.0
2019-06-14 11:00:00	MSFT	Stock	132.61	132.83	132.08	132.51	1764778.0
2019-06-14 12:00:00	MSFT	Stock	132.508	132.85	132.43	132.78	838417.0
2019-06-14 13:00:00	MSFT	Stock	132.783	132.9	132.52	132.53	878363.0
2019-06-14 14:00:00	MSFT	Stock	132.535	133.79	132.5	132.925	1764491.0
2019-06-14 15:00:00	MSFT	Stock	132.92	133.27	132.42	132.47	3052311.0
2019-06-14 16:00:00	MSFT	Stock	132.45	132.57	132.19	132.25	2971461.0
2019-06-14 17:00:00	MSFT	Stock	132.39	132.48	132.39	132.45	57922.0
2019-06-14 18:00:00	MSFT	Stock	132.45	132.45	132.45	132.45	800.0
2019-06-14 19:00:00	MSFT	Stock	132.46	132.46	132.38	132.38	2768.0
2019-06-14 04:00:00	NVDA	Stock	3.625	3.625	3.6008	3.6092	283160.0
2019-06-14 05:00:00	NVDA	Stock	3.604	3.604	3.576	3.5825	148800.0
2019-06-14 06:00:00	NVDA	Stock	3.5805	3.5875	3.5805	3.5852	62880.0
2019-06-14 07:00:00	NVDA	Stock	3.5978	3.6185	3.5858	3.6055	492520.0
2019-06-14 08:00:00	NVDA	Stock	3.6	3.6175	3.5875	3.612	2646280.0
2019-06-14 09:00:00	NVDA	Stock	3.6125	3.6372	3.5715	3.5788	76188560.0
2019-06-14 10:00:00	NVDA	Stock	3.5768	3.6145	3.5709	3.6	73245000.0
2019-06-14 11:00:00	NVDA	Stock	3.6005	3.6058	3.5815	3.5895	46121840.0
2019-06-14 12:00:00	NVDA	Stock	3.5898	3.6	3.5865	3.5975	25703040.0
2019-06-14 13:00:00	NVDA	Stock	3.5975	3.6078	3.5895	3.6007	26377720.0
2019-06-14 14:00:00	NVDA	Stock	3.6008	3.6165	3.6008	3.611	28734680.0
2019-06-14 15:00:00	NVDA	Stock	3.6105	3.6258	3.6102	3.6145	56610720.0
2019-06-14 16:00:00	NVDA	Stock	3.616	3.616	3.5988	3.6012	7857520.0
2019-06-14 17:00:00	NVDA	Stock	3.6022	3.616	3.6	3.616	758320.0
2019-06-14 18:00:00	NVDA	Stock	3.602	3.6045	3.6	3.6022	169440.0
2019-06-14 19:00:00	NVDA	Stock	3.6002	3.6025	3.5962	3.5962	490400.0
2019-06-14 05:00:00	AMZN	Stock	92.925	92.925	92.925	92.925	2000.0
2019-06-14 06:00:00	AMZN	Stock	92.97	92.97	92.933	92.933	18000.0
2019-06-14 07:00:00	AMZN	Stock	92.9325	93.5	92.9325	93.4485	53040.0
2019-06-14 08:00:00	AMZN	Stock	93.05	93.7485	92.896	93.4095	200660.0

> showing 50 of 48,904 rows — these rows as CSV

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