PREVIEW / stock_1hour / 2017-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-21.parquet
  size:    1.1 MB
  rows:    50,072
  symbols: 2,972

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-11-21 04:00:00	AAPL	Stock	42.58	42.58	42.4775	42.4775	900.0
2017-11-21 05:00:00	AAPL	Stock	42.6	42.6225	42.595	42.6225	6000.0
2017-11-21 06:00:00	AAPL	Stock	42.6225	42.625	42.57	42.6125	15492.0
2017-11-21 07:00:00	AAPL	Stock	42.6225	42.6675	42.58	42.65	76524.0
2017-11-21 08:00:00	AAPL	Stock	42.6375	42.7125	42.62	42.675	311548.0
2017-11-21 09:00:00	AAPL	Stock	42.6725	43.215	42.64	43.2125	17435976.0
2017-11-21 10:00:00	AAPL	Stock	43.2112	43.425	43.195	43.318	19221908.0
2017-11-21 11:00:00	AAPL	Stock	43.315	43.4125	43.305	43.3812	8847612.0
2017-11-21 12:00:00	AAPL	Stock	43.38	43.4	43.28	43.2925	6161316.0
2017-11-21 13:00:00	AAPL	Stock	43.294	43.3075	43.235	43.2782	5319048.0
2017-11-21 14:00:00	AAPL	Stock	43.28	43.285	43.17	43.2412	6509232.0
2017-11-21 15:00:00	AAPL	Stock	43.2412	43.3075	43.1725	43.2825	11621464.0
2017-11-21 16:00:00	AAPL	Stock	43.285	43.3	43.2375	43.2575	9027564.0
2017-11-21 17:00:00	AAPL	Stock	43.2625	43.2725	43.25	43.2725	61840.0
2017-11-21 18:00:00	AAPL	Stock	43.2725	43.2875	43.265	43.2875	58488.0
2017-11-21 19:00:00	AAPL	Stock	43.2875	43.2875	43.2525	43.2625	37900.0
2017-11-21 06:00:00	MSFT	Stock	82.98	82.98	82.98	82.98	200.0
2017-11-21 07:00:00	MSFT	Stock	82.84	82.99	82.83	82.95	2644.0
2017-11-21 08:00:00	MSFT	Stock	82.99	82.99	82.74	82.74	10490.0
2017-11-21 09:00:00	MSFT	Stock	82.9	83.46	82.74	83.41	2196996.0
2017-11-21 10:00:00	MSFT	Stock	83.41	83.77	83.35	83.74	3049666.0
2017-11-21 11:00:00	MSFT	Stock	83.74	83.84	83.61	83.644	1967578.0
2017-11-21 12:00:00	MSFT	Stock	83.65	83.685	83.57	83.63	1135566.0
2017-11-21 13:00:00	MSFT	Stock	83.635	83.78	83.59	83.745	1080624.0
2017-11-21 14:00:00	MSFT	Stock	83.74	83.76	83.64	83.71	1137888.0
2017-11-21 15:00:00	MSFT	Stock	83.7	83.78	83.61	83.73	3717740.0
2017-11-21 16:00:00	MSFT	Stock	83.72	83.78	83.61	83.61	4262422.0
2017-11-21 17:00:00	MSFT	Stock	83.61	83.61	83.61	83.61	442.0
2017-11-21 19:00:00	MSFT	Stock	83.72	83.72	83.72	83.72	110.0
2017-11-21 04:00:00	NVDA	Stock	5.3648	5.3648	5.3498	5.3498	19640.0
2017-11-21 06:00:00	NVDA	Stock	5.3565	5.3875	5.3565	5.38	48440.0
2017-11-21 07:00:00	NVDA	Stock	5.3625	5.3848	5.3625	5.3808	573040.0
2017-11-21 08:00:00	NVDA	Stock	5.3813	5.3848	5.3638	5.3815	4289520.0
2017-11-21 09:00:00	NVDA	Stock	5.3813	5.398	5.36	5.3835	90649200.0
2017-11-21 10:00:00	NVDA	Stock	5.3822	5.413	5.3778	5.394	86028840.0
2017-11-21 11:00:00	NVDA	Stock	5.3935	5.4025	5.3813	5.3843	34123560.0
2017-11-21 12:00:00	NVDA	Stock	5.3842	5.392	5.3708	5.3792	32052320.0
2017-11-21 13:00:00	NVDA	Stock	5.3792	5.399	5.3782	5.3932	36556320.0
2017-11-21 14:00:00	NVDA	Stock	5.3928	5.3983	5.3878	5.3938	20915280.0
2017-11-21 15:00:00	NVDA	Stock	5.394	5.4025	5.386	5.4002	46251760.0
2017-11-21 16:00:00	NVDA	Stock	5.4013	5.4013	5.3895	5.3943	19256320.0
2017-11-21 17:00:00	NVDA	Stock	5.3972	5.404	5.3972	5.404	380600.0
2017-11-21 18:00:00	NVDA	Stock	5.404	5.4053	5.4002	5.4053	281480.0
2017-11-21 19:00:00	NVDA	Stock	5.4053	5.4053	5.4002	5.403	342200.0
2017-11-21 04:00:00	AMZN	Stock	56.33	56.33	56.33	56.33	2220.0
2017-11-21 05:00:00	AMZN	Stock	56.33	56.33	56.33	56.33	20000.0
2017-11-21 06:00:00	AMZN	Stock	56.482	56.4925	56.482	56.4915	11800.0
2017-11-21 07:00:00	AMZN	Stock	56.4625	56.65	56.4625	56.605	197260.0
2017-11-21 08:00:00	AMZN	Stock	56.4675	56.6295	56.4675	56.6085	117480.0
2017-11-21 09:00:00	AMZN	Stock	56.5875	56.709	56.41	56.675	8746160.0

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

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