PREVIEW / stock_1hour / 2017-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-19.parquet
  size:    1.1 MB
  rows:    50,720
  symbols: 3,032

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-06-19 04:00:00	AAPL	Stock	35.775	35.945	35.775	35.945	10148.0
2017-06-19 05:00:00	AAPL	Stock	35.95	35.95	35.9225	35.925	8956.0
2017-06-19 06:00:00	AAPL	Stock	35.915	35.955	35.85	35.9	74860.0
2017-06-19 07:00:00	AAPL	Stock	35.89	35.915	35.86	35.915	79264.0
2017-06-19 08:00:00	AAPL	Stock	35.9125	35.965	35.84	35.85	571932.0
2017-06-19 09:00:00	AAPL	Stock	35.8625	36.2848	35.8525	36.227	22112752.0
2017-06-19 10:00:00	AAPL	Stock	36.225	36.5475	36.2148	36.47	24673992.0
2017-06-19 11:00:00	AAPL	Stock	36.469	36.5175	36.4025	36.455	9482172.0
2017-06-19 12:00:00	AAPL	Stock	36.4575	36.4922	36.4075	36.484	7005052.0
2017-06-19 13:00:00	AAPL	Stock	36.485	36.685	36.4775	36.6375	11563984.0
2017-06-19 14:00:00	AAPL	Stock	36.635	36.655	36.495	36.5125	9622464.0
2017-06-19 15:00:00	AAPL	Stock	36.51	36.635	36.4825	36.585	18490660.0
2017-06-19 16:00:00	AAPL	Stock	36.6	36.63	36.5625	36.585	12010788.0
2017-06-19 17:00:00	AAPL	Stock	36.585	36.6225	36.585	36.62	1353512.0
2017-06-19 18:00:00	AAPL	Stock	36.6225	36.665	36.615	36.665	84408.0
2017-06-19 19:00:00	AAPL	Stock	36.665	36.6825	36.6075	36.6775	72968.0
2017-06-19 05:00:00	MSFT	Stock	70.15	70.15	70.15	70.15	1000.0
2017-06-19 06:00:00	MSFT	Stock	70.22	70.22	70.22	70.22	100.0
2017-06-19 07:00:00	MSFT	Stock	70.46	70.5	70.4	70.49	7090.0
2017-06-19 08:00:00	MSFT	Stock	70.49	70.6	70.44	70.44	14781.0
2017-06-19 09:00:00	MSFT	Stock	70.5	70.945	70.44	70.61	3041841.0
2017-06-19 10:00:00	MSFT	Stock	70.61	70.83	70.35	70.57	3675359.0
2017-06-19 11:00:00	MSFT	Stock	70.56	70.6	70.47	70.53	1720664.0
2017-06-19 12:00:00	MSFT	Stock	70.54	70.66	70.5	70.53	1464146.0
2017-06-19 13:00:00	MSFT	Stock	70.54	70.8	70.525	70.73	1647191.0
2017-06-19 14:00:00	MSFT	Stock	70.736	70.76	70.59	70.67	1502730.0
2017-06-19 15:00:00	MSFT	Stock	70.68	70.9	70.6	70.87	4787050.0
2017-06-19 16:00:00	MSFT	Stock	70.87	70.87	70.685	70.84	4023268.0
2017-06-19 17:00:00	MSFT	Stock	70.86	70.87	70.84	70.87	407497.0
2017-06-19 18:00:00	MSFT	Stock	70.82	70.87	70.82	70.87	3045.0
2017-06-19 19:00:00	MSFT	Stock	70.87	70.87	70.83	70.86	2902.0
2017-06-19 04:00:00	NVDA	Stock	3.831	3.8612	3.831	3.8612	157680.0
2017-06-19 06:00:00	NVDA	Stock	3.8343	3.835	3.8275	3.8288	249000.0
2017-06-19 07:00:00	NVDA	Stock	3.8292	3.8338	3.825	3.8325	382600.0
2017-06-19 08:00:00	NVDA	Stock	3.83	3.8368	3.8135	3.832	4307120.0
2017-06-19 09:00:00	NVDA	Stock	3.8312	3.897	3.8252	3.8855	161923040.0
2017-06-19 10:00:00	NVDA	Stock	3.8852	3.9228	3.8852	3.9098	154211080.0
2017-06-19 11:00:00	NVDA	Stock	3.911	3.936	3.895	3.9058	97241200.0
2017-06-19 12:00:00	NVDA	Stock	3.907	3.9142	3.8782	3.909	75093000.0
2017-06-19 13:00:00	NVDA	Stock	3.9092	3.9278	3.9018	3.9135	55840920.0
2017-06-19 14:00:00	NVDA	Stock	3.9122	3.9198	3.8882	3.8938	60331560.0
2017-06-19 15:00:00	NVDA	Stock	3.8958	3.9382	3.889	3.9333	116126240.0
2017-06-19 16:00:00	NVDA	Stock	3.934	3.94	3.93	3.9368	35817560.0
2017-06-19 17:00:00	NVDA	Stock	3.9362	3.9382	3.933	3.9382	1710600.0
2017-06-19 18:00:00	NVDA	Stock	3.935	3.947	3.935	3.9438	1855720.0
2017-06-19 19:00:00	NVDA	Stock	3.9412	3.9572	3.9412	3.9528	1651640.0
2017-06-19 04:00:00	AMZN	Stock	49.7	49.965	49.7	49.95	15760.0
2017-06-19 05:00:00	AMZN	Stock	49.923	49.923	49.835	49.8505	48840.0
2017-06-19 06:00:00	AMZN	Stock	49.8205	49.8745	49.815	49.815	13640.0
2017-06-19 07:00:00	AMZN	Stock	49.785	49.87	49.785	49.8525	143700.0

> showing 50 of 50,720 rows — these rows as CSV

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