PREVIEW / stock_1hour / 2016-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-31.parquet
  size:    1.0 MB
  rows:    48,833
  symbols: 3,318

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
2016-05-31 04:00:00	AAPL	Stock	25.0875	25.125	25.0675	25.1175	7640.0
2016-05-31 05:00:00	AAPL	Stock	25.0625	25.0875	25.035	25.0375	16004.0
2016-05-31 06:00:00	AAPL	Stock	25.0025	25.035	24.9925	24.9925	35688.0
2016-05-31 07:00:00	AAPL	Stock	24.985	25.02	24.925	24.9575	246900.0
2016-05-31 08:00:00	AAPL	Stock	24.9625	25.0	24.9275	24.9575	550988.0
2016-05-31 09:00:00	AAPL	Stock	24.9625	25.1	24.885	25.0413	22242200.0
2016-05-31 10:00:00	AAPL	Stock	25.0435	25.07	24.95	24.97	19284724.0
2016-05-31 11:00:00	AAPL	Stock	24.97	25.025	24.95	24.9705	13587956.0
2016-05-31 12:00:00	AAPL	Stock	24.97	24.97	24.8988	24.9513	14089208.0
2016-05-31 13:00:00	AAPL	Stock	24.9525	24.97	24.9175	24.9278	8036576.0
2016-05-31 14:00:00	AAPL	Stock	24.9275	24.9275	24.705	24.7375	18483640.0
2016-05-31 15:00:00	AAPL	Stock	24.74	24.995	24.7225	24.965	30697896.0
2016-05-31 16:00:00	AAPL	Stock	24.965	24.995	24.9288	24.9675	26677536.0
2016-05-31 17:00:00	AAPL	Stock	24.9575	24.9625	24.9425	24.9625	94360.0
2016-05-31 18:00:00	AAPL	Stock	24.965	24.9775	24.9625	24.9625	19800.0
2016-05-31 19:00:00	AAPL	Stock	24.9625	24.9875	24.9525	24.9875	36800.0
2016-05-31 04:00:00	MSFT	Stock	52.42	52.42	52.42	52.42	195.0
2016-05-31 07:00:00	MSFT	Stock	52.2	52.41	52.2	52.41	1861.0
2016-05-31 08:00:00	MSFT	Stock	52.4	52.42	52.4	52.42	1094.0
2016-05-31 09:00:00	MSFT	Stock	52.41	52.44	52.095	52.37	2204730.0
2016-05-31 10:00:00	MSFT	Stock	52.38	52.59	52.25	52.38	2501363.0
2016-05-31 11:00:00	MSFT	Stock	52.37	52.39	52.22	52.29	1717524.0
2016-05-31 12:00:00	MSFT	Stock	52.28	52.33	52.22	52.235	1871839.0
2016-05-31 13:00:00	MSFT	Stock	52.231	52.4	52.2	52.33	1077699.0
2016-05-31 14:00:00	MSFT	Stock	52.32	52.32	52.12	52.14	2523302.0
2016-05-31 15:00:00	MSFT	Stock	52.14	53.0	52.08	53.0	10101543.0
2016-05-31 16:00:00	MSFT	Stock	52.99	53.005	51.25	52.59	10631342.0
2016-05-31 17:00:00	MSFT	Stock	52.5	52.55	52.43	52.54	27349.0
2016-05-31 18:00:00	MSFT	Stock	52.69	52.69	52.66	52.66	500.0
2016-05-31 19:00:00	MSFT	Stock	52.52	52.64	52.52	52.64	2160.0
2016-05-31 07:00:00	NVDA	Stock	1.15	1.15	1.1488	1.1498	144000.0
2016-05-31 08:00:00	NVDA	Stock	1.15	1.1525	1.1488	1.1523	207240.0
2016-05-31 09:00:00	NVDA	Stock	1.1518	1.1685	1.1518	1.1668	53679920.0
2016-05-31 10:00:00	NVDA	Stock	1.1665	1.1682	1.159	1.1615	53237280.0
2016-05-31 11:00:00	NVDA	Stock	1.1613	1.1633	1.1573	1.1623	33592240.0
2016-05-31 12:00:00	NVDA	Stock	1.1624	1.1638	1.1615	1.1622	32582880.0
2016-05-31 13:00:00	NVDA	Stock	1.1625	1.17	1.162	1.1698	30290360.0
2016-05-31 14:00:00	NVDA	Stock	1.1698	1.17	1.1615	1.1642	25685840.0
2016-05-31 15:00:00	NVDA	Stock	1.1643	1.1704	1.1635	1.1682	87800840.0
2016-05-31 16:00:00	NVDA	Stock	1.168	1.1681	1.1658	1.168	37027320.0
2016-05-31 17:00:00	NVDA	Stock	1.168	1.168	1.167	1.168	433200.0
2016-05-31 18:00:00	NVDA	Stock	1.1665	1.1675	1.1638	1.165	44000.0
2016-05-31 19:00:00	NVDA	Stock	1.1675	1.168	1.1675	1.168	24000.0
2016-05-31 08:00:00	AMZN	Stock	35.665	35.71	35.658	35.696	87600.0
2016-05-31 09:00:00	AMZN	Stock	35.673	35.994	35.566	35.919	9918220.0
2016-05-31 10:00:00	AMZN	Stock	35.919	36.124	35.8785	36.1205	11851000.0
2016-05-31 11:00:00	AMZN	Stock	36.121	36.2115	36.0345	36.129	7470760.0
2016-05-31 12:00:00	AMZN	Stock	36.129	36.1542	36.041	36.094	5037300.0
2016-05-31 13:00:00	AMZN	Stock	36.0915	36.1155	36.0	36.013	4131920.0
2016-05-31 14:00:00	AMZN	Stock	36.0185	36.04	35.93	36.0136	6020260.0

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

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