PREVIEW / stock_1hour / 2019-04-05

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-05.parquet
  size:    1.1 MB
  rows:    49,571
  symbols: 2,651

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-05 04:00:00	AAPL	Stock	49.05	49.17	49.05	49.075	4132.0
2019-04-05 05:00:00	AAPL	Stock	49.075	49.205	49.075	49.075	10216.0
2019-04-05 06:00:00	AAPL	Stock	49.02	49.02	49.02	49.02	400.0
2019-04-05 07:00:00	AAPL	Stock	49.0625	49.0625	49.0	49.0175	89388.0
2019-04-05 08:00:00	AAPL	Stock	49.06	49.175	48.98	49.1225	190108.0
2019-04-05 09:00:00	AAPL	Stock	49.1028	49.275	48.9825	49.1525	13967384.0
2019-04-05 10:00:00	AAPL	Stock	49.155	49.205	49.0175	49.1025	10319632.0
2019-04-05 11:00:00	AAPL	Stock	49.1075	49.1438	49.035	49.1225	6897256.0
2019-04-05 12:00:00	AAPL	Stock	49.125	49.23	49.0918	49.1325	6375180.0
2019-04-05 13:00:00	AAPL	Stock	49.1358	49.1725	49.1075	49.1725	3881084.0
2019-04-05 14:00:00	AAPL	Stock	49.1725	49.24	49.15	49.18	5839516.0
2019-04-05 15:00:00	AAPL	Stock	49.1775	49.2675	49.1625	49.2425	10323648.0
2019-04-05 16:00:00	AAPL	Stock	49.26	49.2625	49.21	49.2375	6684872.0
2019-04-05 17:00:00	AAPL	Stock	49.2375	49.25	49.2225	49.2375	72056.0
2019-04-05 18:00:00	AAPL	Stock	49.2375	49.25	49.23	49.2475	43360.0
2019-04-05 19:00:00	AAPL	Stock	49.23	49.25	49.2225	49.225	44720.0
2019-04-05 04:00:00	MSFT	Stock	119.5	119.5	119.5	119.5	300.0
2019-04-05 06:00:00	MSFT	Stock	119.5	119.5	119.5	119.5	100.0
2019-04-05 07:00:00	MSFT	Stock	119.6	119.6	119.5	119.58	5027.0
2019-04-05 08:00:00	MSFT	Stock	119.57	119.95	119.53	119.85	11822.0
2019-04-05 09:00:00	MSFT	Stock	119.76	120.091	119.2	119.95	2606377.0
2019-04-05 10:00:00	MSFT	Stock	119.95	120.23	119.75	119.88	2078336.0
2019-04-05 11:00:00	MSFT	Stock	119.88	120.04	119.68	119.877	1750692.0
2019-04-05 12:00:00	MSFT	Stock	119.87	120.03	119.71	119.78	936055.0
2019-04-05 13:00:00	MSFT	Stock	119.775	119.86	119.67	119.74	746318.0
2019-04-05 14:00:00	MSFT	Stock	119.73	119.77	119.53	119.675	1029492.0
2019-04-05 15:00:00	MSFT	Stock	119.68	120.0	119.675	119.88	2184545.0
2019-04-05 16:00:00	MSFT	Stock	119.89	119.99	119.81	119.97	1240946.0
2019-04-05 17:00:00	MSFT	Stock	119.9	119.99	119.9	119.99	3621.0
2019-04-05 18:00:00	MSFT	Stock	119.98	119.99	119.94	119.94	1898.0
2019-04-05 19:00:00	MSFT	Stock	119.99	120.0	119.99	120.0	5505.0
2019-04-05 04:00:00	NVDA	Stock	4.733	4.733	4.733	4.733	16000.0
2019-04-05 05:00:00	NVDA	Stock	4.7265	4.7265	4.7265	4.7265	16080.0
2019-04-05 06:00:00	NVDA	Stock	4.7265	4.7265	4.7262	4.7262	28000.0
2019-04-05 07:00:00	NVDA	Stock	4.7265	4.7275	4.7142	4.7213	450160.0
2019-04-05 08:00:00	NVDA	Stock	4.725	4.7625	4.7175	4.7513	3104960.0
2019-04-05 09:00:00	NVDA	Stock	4.755	4.775	4.7172	4.7311	85694120.0
2019-04-05 10:00:00	NVDA	Stock	4.7319	4.7465	4.7133	4.7333	56344280.0
2019-04-05 11:00:00	NVDA	Stock	4.7348	4.7715	4.7288	4.7685	55738200.0
2019-04-05 12:00:00	NVDA	Stock	4.769	4.7913	4.7682	4.7742	61243640.0
2019-04-05 13:00:00	NVDA	Stock	4.7736	4.7885	4.7658	4.7842	30631720.0
2019-04-05 14:00:00	NVDA	Stock	4.7838	4.7888	4.7745	4.7745	32812040.0
2019-04-05 15:00:00	NVDA	Stock	4.7745	4.7835	4.7652	4.7738	59994360.0
2019-04-05 16:00:00	NVDA	Stock	4.7738	4.7788	4.7688	4.777	9914080.0
2019-04-05 17:00:00	NVDA	Stock	4.7738	4.7775	4.7725	4.7775	63160.0
2019-04-05 18:00:00	NVDA	Stock	4.7775	4.7782	4.7725	4.7738	211600.0
2019-04-05 19:00:00	NVDA	Stock	4.775	4.7782	4.7725	4.776	444320.0
2019-04-05 04:00:00	AMZN	Stock	91.1	91.1875	91.1	91.1875	6200.0
2019-04-05 05:00:00	AMZN	Stock	91.225	91.225	91.225	91.225	6920.0
2019-04-05 07:00:00	AMZN	Stock	91.1585	91.3	91.1205	91.251	161400.0

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

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