PREVIEW / stock_1hour / 2018-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-26.parquet
  size:    1.1 MB
  rows:    49,479
  symbols: 2,895

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-02-26 04:00:00	AAPL	Stock	44.0	44.05	44.0	44.025	23700.0
2018-02-26 05:00:00	AAPL	Stock	44.02	44.045	43.9825	44.0125	26560.0
2018-02-26 06:00:00	AAPL	Stock	44.0	44.05	43.9775	44.02	75768.0
2018-02-26 07:00:00	AAPL	Stock	44.0	44.1075	43.99	44.1075	386540.0
2018-02-26 08:00:00	AAPL	Stock	44.11	44.15	44.0175	44.075	576228.0
2018-02-26 09:00:00	AAPL	Stock	44.0675	44.5	44.0525	44.4312	23898152.0
2018-02-26 10:00:00	AAPL	Stock	44.4312	44.6025	44.325	44.4125	24293976.0
2018-02-26 11:00:00	AAPL	Stock	44.415	44.75	44.3998	44.7075	18912552.0
2018-02-26 12:00:00	AAPL	Stock	44.7075	44.785	44.585	44.635	15184196.0
2018-02-26 13:00:00	AAPL	Stock	44.6338	44.75	44.6275	44.7362	8089624.0
2018-02-26 14:00:00	AAPL	Stock	44.7368	44.8475	44.5162	44.7537	12869804.0
2018-02-26 15:00:00	AAPL	Stock	44.7525	44.825	44.625	44.745	20971896.0
2018-02-26 16:00:00	AAPL	Stock	44.7425	44.775	44.5625	44.75	9193696.0
2018-02-26 17:00:00	AAPL	Stock	44.7625	44.775	44.725	44.75	2072760.0
2018-02-26 18:00:00	AAPL	Stock	44.7425	44.7575	44.7375	44.7575	50712.0
2018-02-26 19:00:00	AAPL	Stock	44.7575	44.775	44.7275	44.7625	79268.0
2018-02-26 04:00:00	MSFT	Stock	94.2	94.49	94.2	94.49	350.0
2018-02-26 05:00:00	MSFT	Stock	94.49	94.49	94.49	94.49	1000.0
2018-02-26 07:00:00	MSFT	Stock	94.23	94.58	94.23	94.51	43136.0
2018-02-26 08:00:00	MSFT	Stock	94.21	94.6	94.21	94.5	27014.0
2018-02-26 09:00:00	MSFT	Stock	94.53	94.98	94.22	94.91	3330254.0
2018-02-26 10:00:00	MSFT	Stock	94.91	95.22	94.715	94.83	4234626.0
2018-02-26 11:00:00	MSFT	Stock	94.83	95.24	94.77	94.87	2727982.0
2018-02-26 12:00:00	MSFT	Stock	94.86	95.01	94.79	94.93	2390830.0
2018-02-26 13:00:00	MSFT	Stock	94.93	95.12	94.929	95.0	2115140.0
2018-02-26 14:00:00	MSFT	Stock	95.0	95.25	94.95	94.99	2523796.0
2018-02-26 15:00:00	MSFT	Stock	94.99	95.45	94.96	95.43	4984184.0
2018-02-26 16:00:00	MSFT	Stock	95.42	95.5	95.31	95.46	5049125.0
2018-02-26 17:00:00	MSFT	Stock	95.48	95.49	95.44	95.46	5303.0
2018-02-26 18:00:00	MSFT	Stock	95.49	95.5	95.45	95.45	7812.0
2018-02-26 19:00:00	MSFT	Stock	95.45	95.48	95.44	95.45	1739.0
2018-02-26 04:00:00	NVDA	Stock	6.175	6.1965	6.175	6.18	114240.0
2018-02-26 05:00:00	NVDA	Stock	6.1865	6.1865	6.1778	6.186	12000.0
2018-02-26 06:00:00	NVDA	Stock	6.1812	6.1873	6.1808	6.1828	369280.0
2018-02-26 07:00:00	NVDA	Stock	6.1828	6.206	6.1788	6.1918	1163000.0
2018-02-26 08:00:00	NVDA	Stock	6.1788	6.2063	6.1612	6.1925	2476560.0
2018-02-26 09:00:00	NVDA	Stock	6.1875	6.1995	6.142	6.169	80992240.0
2018-02-26 10:00:00	NVDA	Stock	6.1698	6.1835	6.12	6.127	74681320.0
2018-02-26 11:00:00	NVDA	Stock	6.1255	6.1375	6.1015	6.1178	48664160.0
2018-02-26 12:00:00	NVDA	Stock	6.1172	6.1388	6.1088	6.1242	32700840.0
2018-02-26 13:00:00	NVDA	Stock	6.1268	6.1352	6.1068	6.1208	31175360.0
2018-02-26 14:00:00	NVDA	Stock	6.1212	6.161	6.1198	6.15	48526640.0
2018-02-26 15:00:00	NVDA	Stock	6.1513	6.1668	6.1475	6.1625	61227200.0
2018-02-26 16:00:00	NVDA	Stock	6.1615	6.1663	6.1578	6.165	25147440.0
2018-02-26 17:00:00	NVDA	Stock	6.165	6.166	6.1642	6.1645	241240.0
2018-02-26 18:00:00	NVDA	Stock	6.1645	6.1672	6.1642	6.1642	1627320.0
2018-02-26 19:00:00	NVDA	Stock	6.1663	6.1675	6.1628	6.165	394080.0
2018-02-26 04:00:00	AMZN	Stock	75.25	75.426	75.25	75.426	19780.0
2018-02-26 05:00:00	AMZN	Stock	75.4	75.425	75.4	75.4	28540.0
2018-02-26 06:00:00	AMZN	Stock	75.4485	75.4485	75.29	75.29	46380.0

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

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