PREVIEW / stock_1hour / 2019-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-02-04.parquet
  size:    1.1 MB
  rows:    49,699
  symbols: 2,657

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-02-04 04:00:00	AAPL	Stock	41.725	41.74	41.725	41.74	1008.0
2019-02-04 05:00:00	AAPL	Stock	41.7575	41.79	41.75	41.75	7928.0
2019-02-04 06:00:00	AAPL	Stock	41.76	41.79	41.7575	41.7675	6800.0
2019-02-04 07:00:00	AAPL	Stock	41.7875	41.7875	41.7275	41.775	103816.0
2019-02-04 08:00:00	AAPL	Stock	41.76	41.83	41.6875	41.825	300088.0
2019-02-04 09:00:00	AAPL	Stock	41.825	42.455	41.7975	42.4425	18010968.0
2019-02-04 10:00:00	AAPL	Stock	42.4457	42.675	42.34	42.5575	25506136.0
2019-02-04 11:00:00	AAPL	Stock	42.5625	42.8425	42.515	42.7675	16263624.0
2019-02-04 12:00:00	AAPL	Stock	42.7725	42.795	42.6425	42.715	9263688.0
2019-02-04 13:00:00	AAPL	Stock	42.715	42.8825	42.7038	42.8625	8634044.0
2019-02-04 14:00:00	AAPL	Stock	42.87	42.9138	42.7375	42.8103	7624052.0
2019-02-04 15:00:00	AAPL	Stock	42.81	42.8375	42.6815	42.8175	14202828.0
2019-02-04 16:00:00	AAPL	Stock	42.8125	42.8225	42.7075	42.7975	12544828.0
2019-02-04 17:00:00	AAPL	Stock	42.78	42.8125	42.7125	42.745	179584.0
2019-02-04 18:00:00	AAPL	Stock	42.7425	42.775	42.7175	42.75	45420.0
2019-02-04 19:00:00	AAPL	Stock	42.73	42.8	42.725	42.725	98828.0
2019-02-04 04:00:00	MSFT	Stock	102.92	103.1	102.92	103.1	887.0
2019-02-04 05:00:00	MSFT	Stock	103.06	103.06	103.06	103.06	100.0
2019-02-04 06:00:00	MSFT	Stock	103.06	103.2	103.0	103.0	1944.0
2019-02-04 07:00:00	MSFT	Stock	103.0	103.12	102.88	102.9	15395.0
2019-02-04 08:00:00	MSFT	Stock	103.0	103.2	102.61	102.82	37646.0
2019-02-04 09:00:00	MSFT	Stock	102.95	104.29	102.75	104.215	3835398.0
2019-02-04 10:00:00	MSFT	Stock	104.22	105.36	104.06	105.36	5355962.0
2019-02-04 11:00:00	MSFT	Stock	105.36	105.67	105.18	105.5	3405726.0
2019-02-04 12:00:00	MSFT	Stock	105.504	105.64	105.29	105.36	1873827.0
2019-02-04 13:00:00	MSFT	Stock	105.36	105.43	105.09	105.42	1671758.0
2019-02-04 14:00:00	MSFT	Stock	105.418	105.63	105.37	105.62	1712102.0
2019-02-04 15:00:00	MSFT	Stock	105.61	105.8	105.33	105.79	4711581.0
2019-02-04 16:00:00	MSFT	Stock	105.74	105.75	105.21	105.69	5137791.0
2019-02-04 17:00:00	MSFT	Stock	105.53	105.74	105.51	105.55	5899.0
2019-02-04 18:00:00	MSFT	Stock	105.64	105.65	105.5	105.51	5366.0
2019-02-04 19:00:00	MSFT	Stock	105.51	105.7	105.5	105.53	10537.0
2019-02-04 04:00:00	NVDA	Stock	3.6212	3.6212	3.6212	3.6212	10200.0
2019-02-04 05:00:00	NVDA	Stock	3.6438	3.6462	3.6438	3.6462	21080.0
2019-02-04 06:00:00	NVDA	Stock	3.64	3.654	3.6388	3.6388	89800.0
2019-02-04 07:00:00	NVDA	Stock	3.6325	3.6595	3.6325	3.655	690800.0
2019-02-04 08:00:00	NVDA	Stock	3.6403	3.66	3.6272	3.639	1681440.0
2019-02-04 09:00:00	NVDA	Stock	3.6436	3.69	3.612	3.674	90773600.0
2019-02-04 10:00:00	NVDA	Stock	3.677	3.7408	3.6645	3.726	91577600.0
2019-02-04 11:00:00	NVDA	Stock	3.726	3.7495	3.724	3.744	57843960.0
2019-02-04 12:00:00	NVDA	Stock	3.7458	3.767	3.7413	3.744	61271600.0
2019-02-04 13:00:00	NVDA	Stock	3.7438	3.755	3.7348	3.7534	33856720.0
2019-02-04 14:00:00	NVDA	Stock	3.7528	3.763	3.7315	3.7358	38931760.0
2019-02-04 15:00:00	NVDA	Stock	3.7352	3.7495	3.7228	3.7298	59441840.0
2019-02-04 16:00:00	NVDA	Stock	3.7295	3.732	3.7088	3.7238	18046400.0
2019-02-04 17:00:00	NVDA	Stock	3.7238	3.7238	3.7112	3.7163	508040.0
2019-02-04 18:00:00	NVDA	Stock	3.7112	3.7148	3.71	3.7148	92640.0
2019-02-04 19:00:00	NVDA	Stock	3.7138	3.7175	3.7098	3.7098	644720.0
2019-02-04 04:00:00	AMZN	Stock	81.375	81.375	81.375	81.375	2000.0
2019-02-04 07:00:00	AMZN	Stock	81.3	81.3	81.05	81.115	276860.0

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

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