PREVIEW / stock_1hour / 2018-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-02.parquet
  size:    1.1 MB
  rows:    49,350
  symbols: 2,881

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
2018-04-02 04:00:00	AAPL	Stock	41.9	41.9775	41.85	41.95	29544.0
2018-04-02 05:00:00	AAPL	Stock	41.95	41.95	41.925	41.9375	30760.0
2018-04-02 06:00:00	AAPL	Stock	42.0175	42.0475	41.975	41.975	27676.0
2018-04-02 07:00:00	AAPL	Stock	42.0	42.0	41.79	41.8	216336.0
2018-04-02 08:00:00	AAPL	Stock	41.8125	41.975	41.8025	41.9625	266264.0
2018-04-02 09:00:00	AAPL	Stock	41.925	42.235	41.8325	41.9725	16663068.0
2018-04-02 10:00:00	AAPL	Stock	41.9855	42.0	41.71	41.7425	14747708.0
2018-04-02 11:00:00	AAPL	Stock	41.7425	41.7825	41.2	41.335	19578344.0
2018-04-02 12:00:00	AAPL	Stock	41.3325	41.64	41.1875	41.43	15063480.0
2018-04-02 13:00:00	AAPL	Stock	41.425	41.4825	41.2125	41.3	12177784.0
2018-04-02 14:00:00	AAPL	Stock	41.3	41.5325	41.1175	41.525	17045716.0
2018-04-02 15:00:00	AAPL	Stock	41.525	41.765	41.33	41.67	25505456.0
2018-04-02 16:00:00	AAPL	Stock	41.6575	41.67	41.3128	41.625	12891116.0
2018-04-02 17:00:00	AAPL	Stock	41.65	41.65	41.5625	41.5775	95188.0
2018-04-02 18:00:00	AAPL	Stock	41.58	41.65	41.58	41.6125	64460.0
2018-04-02 19:00:00	AAPL	Stock	41.62	41.65	41.5875	41.645	93836.0
2018-04-02 04:00:00	MSFT	Stock	91.38	91.38	91.3	91.3	340.0
2018-04-02 06:00:00	MSFT	Stock	90.8	90.8	90.5	90.5	300.0
2018-04-02 07:00:00	MSFT	Stock	91.0	91.0	90.35	90.5	8808.0
2018-04-02 08:00:00	MSFT	Stock	90.5	91.27	90.35	91.27	29837.0
2018-04-02 09:00:00	MSFT	Stock	90.85	90.94	90.3	90.45	2986314.0
2018-04-02 10:00:00	MSFT	Stock	90.45	90.47	89.3	89.5	4128220.0
2018-04-02 11:00:00	MSFT	Stock	89.49	89.52	88.17	88.36	5392070.0
2018-04-02 12:00:00	MSFT	Stock	88.36	89.29	88.02	88.85	4461574.0
2018-04-02 13:00:00	MSFT	Stock	88.85	88.985	87.92	88.05	5055665.0
2018-04-02 14:00:00	MSFT	Stock	88.05	88.31	87.51	88.14	5108363.0
2018-04-02 15:00:00	MSFT	Stock	88.13	88.77	87.69	88.67	10815710.0
2018-04-02 16:00:00	MSFT	Stock	88.67	88.75	88.29	88.7	6228873.0
2018-04-02 17:00:00	MSFT	Stock	88.7	88.95	88.52	88.65	67849.0
2018-04-02 18:00:00	MSFT	Stock	88.63	88.79	88.58	88.79	13521.0
2018-04-02 19:00:00	MSFT	Stock	88.65	88.95	88.65	88.95	9988.0
2018-04-02 07:00:00	NVDA	Stock	5.8042	5.8042	5.682	5.7125	1430480.0
2018-04-02 08:00:00	NVDA	Stock	5.6938	5.8125	5.6825	5.7318	2226600.0
2018-04-02 09:00:00	NVDA	Stock	5.728	5.8663	5.6918	5.7208	138077000.0
2018-04-02 10:00:00	NVDA	Stock	5.7228	5.7245	5.5478	5.5545	198426480.0
2018-04-02 11:00:00	NVDA	Stock	5.5535	5.6153	5.53	5.5717	114447840.0
2018-04-02 12:00:00	NVDA	Stock	5.571	5.645	5.5478	5.6062	89645080.0
2018-04-02 13:00:00	NVDA	Stock	5.6062	5.6222	5.5058	5.517	75928120.0
2018-04-02 14:00:00	NVDA	Stock	5.5155	5.5276	5.4375	5.4938	120561600.0
2018-04-02 15:00:00	NVDA	Stock	5.494	5.55	5.4631	5.5263	141559240.0
2018-04-02 16:00:00	NVDA	Stock	5.5263	5.5355	5.5025	5.53	14426440.0
2018-04-02 17:00:00	NVDA	Stock	5.5348	5.5355	5.503	5.5125	403560.0
2018-04-02 18:00:00	NVDA	Stock	5.5193	5.525	5.5132	5.525	352840.0
2018-04-02 19:00:00	NVDA	Stock	5.525	5.5362	5.525	5.5303	395200.0
2018-04-02 04:00:00	AMZN	Stock	71.8065	71.8065	71.8065	71.8065	2180.0
2018-04-02 07:00:00	AMZN	Stock	71.25	71.6895	70.95	71.15	254000.0
2018-04-02 08:00:00	AMZN	Stock	71.0014	71.625	71.0014	71.15	556660.0
2018-04-02 09:00:00	AMZN	Stock	71.15	71.15	69.125	69.479	30024440.0
2018-04-02 10:00:00	AMZN	Stock	69.473	70.05	69.0	69.0465	23133520.0
2018-04-02 11:00:00	AMZN	Stock	69.0235	69.25	68.05	68.939	25820680.0

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

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