PREVIEW / stock_1hour / 2017-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-21.parquet
  size:    1.1 MB
  rows:    49,388
  symbols: 3,122

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-02-21 04:00:00	AAPL	Stock	34.005	34.0875	34.0025	34.0875	61456.0
2017-02-21 05:00:00	AAPL	Stock	34.15	34.15	34.1125	34.1125	2436.0
2017-02-21 06:00:00	AAPL	Stock	34.1125	34.15	34.0675	34.125	39044.0
2017-02-21 07:00:00	AAPL	Stock	34.1225	34.145	34.0975	34.0975	152740.0
2017-02-21 08:00:00	AAPL	Stock	34.0975	34.1375	33.85	34.105	483744.0
2017-02-21 09:00:00	AAPL	Stock	34.11	34.155	33.995	34.0513	19155852.0
2017-02-21 10:00:00	AAPL	Stock	34.055	34.1225	34.0425	34.1075	12576248.0
2017-02-21 11:00:00	AAPL	Stock	34.1075	34.125	34.0175	34.0775	9104368.0
2017-02-21 12:00:00	AAPL	Stock	34.0775	34.0825	34.02	34.07	5638736.0
2017-02-21 13:00:00	AAPL	Stock	34.0675	34.1225	34.055	34.095	5743452.0
2017-02-21 14:00:00	AAPL	Stock	34.095	34.15	34.0875	34.1412	6448892.0
2017-02-21 15:00:00	AAPL	Stock	34.14	34.1875	34.13	34.1725	12696180.0
2017-02-21 16:00:00	AAPL	Stock	34.175	34.175	34.145	34.1725	12917656.0
2017-02-21 17:00:00	AAPL	Stock	34.1675	34.17	34.15	34.1575	45420.0
2017-02-21 18:00:00	AAPL	Stock	34.1725	34.1725	34.1575	34.1675	28636.0
2017-02-21 19:00:00	AAPL	Stock	34.17	34.1725	34.1575	34.17	34276.0
2017-02-21 05:00:00	MSFT	Stock	64.94	64.94	64.94	64.94	2360.0
2017-02-21 06:00:00	MSFT	Stock	64.88	64.88	64.8	64.8	4000.0
2017-02-21 07:00:00	MSFT	Stock	64.84	64.85	64.84	64.85	3500.0
2017-02-21 08:00:00	MSFT	Stock	64.86	64.87	64.65	64.73	8184.0
2017-02-21 09:00:00	MSFT	Stock	64.7	64.73	64.5	64.631	1945970.0
2017-02-21 10:00:00	MSFT	Stock	64.64	64.95	64.57	64.87	1901244.0
2017-02-21 11:00:00	MSFT	Stock	64.866	64.89	64.64	64.74	1512375.0
2017-02-21 12:00:00	MSFT	Stock	64.74	64.78	64.64	64.65	1280298.0
2017-02-21 13:00:00	MSFT	Stock	64.65	64.685	64.5	64.52	1404629.0
2017-02-21 14:00:00	MSFT	Stock	64.52	64.59	64.48	64.5	1902484.0
2017-02-21 15:00:00	MSFT	Stock	64.49	64.55	64.45	64.46	4806296.0
2017-02-21 16:00:00	MSFT	Stock	64.49	64.49	64.4	64.42	3030810.0
2017-02-21 17:00:00	MSFT	Stock	64.42	64.42	64.42	64.42	100.0
2017-02-21 18:00:00	MSFT	Stock	64.44	64.44	64.44	64.44	200.0
2017-02-21 19:00:00	MSFT	Stock	64.44	64.44	64.41	64.43	1994.0
2017-02-21 04:00:00	NVDA	Stock	2.683	2.6962	2.683	2.6962	28200.0
2017-02-21 05:00:00	NVDA	Stock	2.6962	2.7063	2.6962	2.7063	46000.0
2017-02-21 06:00:00	NVDA	Stock	2.7075	2.7125	2.7075	2.7075	90560.0
2017-02-21 07:00:00	NVDA	Stock	2.7028	2.7095	2.7012	2.7052	247760.0
2017-02-21 08:00:00	NVDA	Stock	2.7032	2.7063	2.6808	2.7005	2721080.0
2017-02-21 09:00:00	NVDA	Stock	2.7005	2.7595	2.7005	2.744	125063000.0
2017-02-21 10:00:00	NVDA	Stock	2.7438	2.7738	2.7348	2.757	99513280.0
2017-02-21 11:00:00	NVDA	Stock	2.7574	2.7634	2.7468	2.759	57749400.0
2017-02-21 12:00:00	NVDA	Stock	2.7595	2.7738	2.7538	2.7708	41002840.0
2017-02-21 13:00:00	NVDA	Stock	2.7705	2.7708	2.7593	2.7658	30522120.0
2017-02-21 14:00:00	NVDA	Stock	2.7654	2.7688	2.7553	2.765	39106600.0
2017-02-21 15:00:00	NVDA	Stock	2.7652	2.7808	2.7555	2.7768	94395880.0
2017-02-21 16:00:00	NVDA	Stock	2.7765	2.778	2.77	2.77	10056200.0
2017-02-21 17:00:00	NVDA	Stock	2.7748	2.775	2.7708	2.7748	106760.0
2017-02-21 18:00:00	NVDA	Stock	2.7718	2.7755	2.7708	2.7728	156040.0
2017-02-21 19:00:00	NVDA	Stock	2.7728	2.7755	2.7708	2.7755	207280.0
2017-02-21 04:00:00	AMZN	Stock	42.3365	42.5	42.3365	42.5	10080.0
2017-02-21 05:00:00	AMZN	Stock	42.469	42.469	42.469	42.469	2000.0
2017-02-21 06:00:00	AMZN	Stock	42.475	42.527	42.466	42.466	23780.0

> showing 50 of 49,388 rows — these rows as CSV

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