PREVIEW / stock_1hour / 2017-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-31.parquet
  size:    1.1 MB
  rows:    48,143
  symbols: 3,038

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
2017-05-31 04:00:00	AAPL	Stock	38.4375	38.4375	38.4375	38.4375	600.0
2017-05-31 05:00:00	AAPL	Stock	38.4125	38.4125	38.4125	38.4125	3548.0
2017-05-31 06:00:00	AAPL	Stock	38.4425	38.485	38.4425	38.475	19204.0
2017-05-31 07:00:00	AAPL	Stock	38.4625	38.525	38.4625	38.5	75652.0
2017-05-31 08:00:00	AAPL	Stock	38.485	38.525	38.46	38.505	140120.0
2017-05-31 09:00:00	AAPL	Stock	38.5125	38.55	38.24	38.25	10562624.0
2017-05-31 10:00:00	AAPL	Stock	38.245	38.2625	38.095	38.2325	15282912.0
2017-05-31 11:00:00	AAPL	Stock	38.23	38.3125	38.2175	38.2988	8112824.0
2017-05-31 12:00:00	AAPL	Stock	38.3	38.35	38.23	38.2362	5624340.0
2017-05-31 13:00:00	AAPL	Stock	38.24	38.3125	38.2025	38.2375	4256356.0
2017-05-31 14:00:00	AAPL	Stock	38.24	38.25	38.115	38.1725	6927732.0
2017-05-31 15:00:00	AAPL	Stock	38.175	38.2375	38.135	38.1925	14681492.0
2017-05-31 16:00:00	AAPL	Stock	38.1925	38.225	38.155	38.2225	19825876.0
2017-05-31 17:00:00	AAPL	Stock	38.225	38.235	38.205	38.205	18984.0
2017-05-31 18:00:00	AAPL	Stock	38.205	38.2325	38.2	38.23	8992.0
2017-05-31 19:00:00	AAPL	Stock	38.225	38.235	38.205	38.2125	32356.0
2017-05-31 06:00:00	MSFT	Stock	70.5	70.5	70.5	70.5	779.0
2017-05-31 07:00:00	MSFT	Stock	70.6	70.7	70.6	70.7	643.0
2017-05-31 08:00:00	MSFT	Stock	70.73	70.73	70.6	70.63	15818.0
2017-05-31 09:00:00	MSFT	Stock	70.62	70.74	70.32	70.34	2887617.0
2017-05-31 10:00:00	MSFT	Stock	70.34	70.44	69.97	70.15	4156627.0
2017-05-31 11:00:00	MSFT	Stock	70.15	70.27	69.865	69.99	2786477.0
2017-05-31 12:00:00	MSFT	Stock	69.99	70.12	69.92	69.98	1695600.0
2017-05-31 13:00:00	MSFT	Stock	69.98	70.13	69.98	70.06	1046695.0
2017-05-31 14:00:00	MSFT	Stock	70.07	70.07	69.83	69.92	2389781.0
2017-05-31 15:00:00	MSFT	Stock	69.92	70.04	69.81	69.87	5247772.0
2017-05-31 16:00:00	MSFT	Stock	69.86	70.0	69.834	70.0	6944266.0
2017-05-31 17:00:00	MSFT	Stock	70.1	70.1	70.0	70.05	1700.0
2017-05-31 18:00:00	MSFT	Stock	69.9	69.9	69.9	69.9	110.0
2017-05-31 19:00:00	MSFT	Stock	69.95	69.95	69.95	69.95	550.0
2017-05-31 04:00:00	NVDA	Stock	3.6488	3.6488	3.6488	3.6488	19600.0
2017-05-31 05:00:00	NVDA	Stock	3.6428	3.6428	3.6428	3.6428	4000.0
2017-05-31 06:00:00	NVDA	Stock	3.6475	3.6475	3.6325	3.6425	142720.0
2017-05-31 07:00:00	NVDA	Stock	3.6425	3.655	3.6362	3.6502	589880.0
2017-05-31 08:00:00	NVDA	Stock	3.6502	3.674	3.6362	3.67	6561400.0
2017-05-31 09:00:00	NVDA	Stock	3.67	3.6803	3.5763	3.5828	174029040.0
2017-05-31 10:00:00	NVDA	Stock	3.583	3.6128	3.5513	3.6095	198957040.0
2017-05-31 11:00:00	NVDA	Stock	3.609	3.6335	3.5955	3.6205	107813920.0
2017-05-31 12:00:00	NVDA	Stock	3.6205	3.6242	3.5895	3.5946	68585680.0
2017-05-31 13:00:00	NVDA	Stock	3.5952	3.612	3.5922	3.6057	35088680.0
2017-05-31 14:00:00	NVDA	Stock	3.6062	3.6087	3.5745	3.58	62579960.0
2017-05-31 15:00:00	NVDA	Stock	3.58	3.61	3.5782	3.6088	101424560.0
2017-05-31 16:00:00	NVDA	Stock	3.6088	3.624	3.608	3.6148	84663640.0
2017-05-31 17:00:00	NVDA	Stock	3.6148	3.6225	3.6118	3.622	753960.0
2017-05-31 18:00:00	NVDA	Stock	3.622	3.625	3.6212	3.625	2878360.0
2017-05-31 19:00:00	NVDA	Stock	3.6228	3.625	3.6212	3.623	350560.0
2017-05-31 06:00:00	AMZN	Stock	49.925	49.9585	49.925	49.9585	6000.0
2017-05-31 07:00:00	AMZN	Stock	49.945	50.015	49.945	49.95	75640.0
2017-05-31 08:00:00	AMZN	Stock	49.9675	50.025	49.9495	49.9875	241020.0
2017-05-31 09:00:00	AMZN	Stock	50.0	50.0375	49.4275	49.4595	14006840.0

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

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