PREVIEW / stock_1hour / 2017-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-05.parquet
  size:    1.0 MB
  rows:    48,080
  symbols: 3,006

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-07-05 04:00:00	AAPL	Stock	35.895	35.895	35.77	35.77	9080.0
2017-07-05 05:00:00	AAPL	Stock	35.7875	35.7875	35.755	35.755	1376.0
2017-07-05 06:00:00	AAPL	Stock	35.7525	35.84	35.7525	35.825	8328.0
2017-07-05 07:00:00	AAPL	Stock	35.8325	35.885	35.7875	35.885	33096.0
2017-07-05 08:00:00	AAPL	Stock	35.815	36.0375	35.7875	36.0	244640.0
2017-07-05 09:00:00	AAPL	Stock	35.99	36.0995	35.89	35.915	11530900.0
2017-07-05 10:00:00	AAPL	Stock	35.9125	35.955	35.681	35.8725	14545324.0
2017-07-05 11:00:00	AAPL	Stock	35.8725	36.0375	35.865	36.0375	7592660.0
2017-07-05 12:00:00	AAPL	Stock	36.0375	36.1975	36.02	36.1475	8542644.0
2017-07-05 13:00:00	AAPL	Stock	36.1488	36.1775	36.04	36.0475	5589844.0
2017-07-05 14:00:00	AAPL	Stock	36.0452	36.1525	35.9725	36.0495	7174248.0
2017-07-05 15:00:00	AAPL	Stock	36.0475	36.0925	35.9715	36.0225	10154768.0
2017-07-05 16:00:00	AAPL	Stock	36.0225	36.0425	36.0	36.03	13120184.0
2017-07-05 17:00:00	AAPL	Stock	36.005	36.025	36.0025	36.005	16028.0
2017-07-05 18:00:00	AAPL	Stock	36.005	36.0225	36.005	36.0225	15284.0
2017-07-05 19:00:00	AAPL	Stock	36.03	36.03	36.0	36.0	20248.0
2017-07-05 04:00:00	MSFT	Stock	68.0	68.0	68.0	68.0	100.0
2017-07-05 06:00:00	MSFT	Stock	68.13	68.13	68.13	68.13	1600.0
2017-07-05 07:00:00	MSFT	Stock	67.9	68.0	67.8	68.0	11760.0
2017-07-05 08:00:00	MSFT	Stock	68.0	68.35	68.0	68.2	17880.0
2017-07-05 09:00:00	MSFT	Stock	68.25	68.725	68.19	68.48	3789134.0
2017-07-05 10:00:00	MSFT	Stock	68.47	68.89	68.42	68.87	3038366.0
2017-07-05 11:00:00	MSFT	Stock	68.87	69.23	68.82	69.185	1776655.0
2017-07-05 12:00:00	MSFT	Stock	69.19	69.31	69.115	69.305	1528603.0
2017-07-05 13:00:00	MSFT	Stock	69.31	69.44	69.1	69.12	1199564.0
2017-07-05 14:00:00	MSFT	Stock	69.13	69.34	69.02	69.11	1692816.0
2017-07-05 15:00:00	MSFT	Stock	69.11	69.22	68.97	69.09	3042160.0
2017-07-05 16:00:00	MSFT	Stock	69.08	69.08	69.0	69.0	3163085.0
2017-07-05 17:00:00	MSFT	Stock	69.08	69.08	68.95	68.96	1139.0
2017-07-05 18:00:00	MSFT	Stock	69.08	69.08	69.08	69.08	692.0
2017-07-05 19:00:00	MSFT	Stock	69.08	69.08	69.0	69.0	425.0
2017-07-05 04:00:00	NVDA	Stock	3.4775	3.4838	3.4625	3.4625	267920.0
2017-07-05 05:00:00	NVDA	Stock	3.475	3.48	3.4565	3.4665	112560.0
2017-07-05 06:00:00	NVDA	Stock	3.46	3.4802	3.4575	3.4802	123880.0
2017-07-05 07:00:00	NVDA	Stock	3.475	3.49	3.4625	3.49	840520.0
2017-07-05 08:00:00	NVDA	Stock	3.485	3.533	3.465	3.5312	8278480.0
2017-07-05 09:00:00	NVDA	Stock	3.53	3.6055	3.5275	3.567	202628280.0
2017-07-05 10:00:00	NVDA	Stock	3.567	3.596	3.5312	3.571	168227600.0
2017-07-05 11:00:00	NVDA	Stock	3.571	3.5845	3.5558	3.5759	76831960.0
2017-07-05 12:00:00	NVDA	Stock	3.5755	3.5822	3.5615	3.5775	51089880.0
2017-07-05 13:00:00	NVDA	Stock	3.5775	3.5985	3.572	3.5723	66831320.0
2017-07-05 14:00:00	NVDA	Stock	3.5725	3.602	3.571	3.5798	75748040.0
2017-07-05 15:00:00	NVDA	Stock	3.5791	3.5848	3.5612	3.5758	102923880.0
2017-07-05 16:00:00	NVDA	Stock	3.5772	3.5792	3.5698	3.5738	13648840.0
2017-07-05 17:00:00	NVDA	Stock	3.5738	3.5738	3.5625	3.5638	295800.0
2017-07-05 18:00:00	NVDA	Stock	3.568	3.5748	3.564	3.5738	590400.0
2017-07-05 19:00:00	NVDA	Stock	3.5735	3.5735	3.5675	3.5712	311440.0
2017-07-05 04:00:00	AMZN	Stock	47.624	47.624	47.624	47.624	7040.0
2017-07-05 06:00:00	AMZN	Stock	47.545	47.545	47.545	47.545	3120.0
2017-07-05 07:00:00	AMZN	Stock	47.558	47.65	47.545	47.65	36060.0

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

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