PREVIEW / stock_1hour / 2017-02-22

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-22.parquet
  size:    1.1 MB
  rows:    48,632
  symbols: 3,113

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-22 04:00:00	AAPL	Stock	34.1625	34.1625	34.1375	34.1375	4984.0
2017-02-22 05:00:00	AAPL	Stock	34.1275	34.1475	34.1075	34.1075	4552.0
2017-02-22 06:00:00	AAPL	Stock	34.135	34.145	34.0825	34.0825	19808.0
2017-02-22 07:00:00	AAPL	Stock	34.0925	34.1125	34.075	34.0975	59012.0
2017-02-22 08:00:00	AAPL	Stock	34.1075	34.135	34.075	34.11	127872.0
2017-02-22 09:00:00	AAPL	Stock	34.11	34.15	34.0275	34.087	11813368.0
2017-02-22 10:00:00	AAPL	Stock	34.0875	34.145	34.0825	34.1125	8906360.0
2017-02-22 11:00:00	AAPL	Stock	34.115	34.1675	34.0895	34.12	7297228.0
2017-02-22 12:00:00	AAPL	Stock	34.1175	34.1725	34.11	34.1712	3902920.0
2017-02-22 13:00:00	AAPL	Stock	34.17	34.28	34.1675	34.2425	8081208.0
2017-02-22 14:00:00	AAPL	Stock	34.2425	34.265	34.1625	34.1625	6273852.0
2017-02-22 15:00:00	AAPL	Stock	34.1625	34.2775	34.14	34.275	12624956.0
2017-02-22 16:00:00	AAPL	Stock	34.265	34.3	34.2625	34.275	12138092.0
2017-02-22 17:00:00	AAPL	Stock	34.275	34.3525	34.255	34.3125	167004.0
2017-02-22 18:00:00	AAPL	Stock	34.2875	34.305	34.2775	34.2925	36296.0
2017-02-22 19:00:00	AAPL	Stock	34.2875	34.335	34.275	34.2975	77288.0
2017-02-22 06:00:00	MSFT	Stock	64.5	64.5	64.5	64.5	1905.0
2017-02-22 07:00:00	MSFT	Stock	64.3	64.3	64.3	64.3	185.0
2017-02-22 08:00:00	MSFT	Stock	64.43	64.5	64.36	64.36	12096.0
2017-02-22 09:00:00	MSFT	Stock	64.4	64.43	64.1	64.22	2057191.0
2017-02-22 10:00:00	MSFT	Stock	64.215	64.35	64.17	64.185	2183152.0
2017-02-22 11:00:00	MSFT	Stock	64.19	64.22	64.05	64.17	2464320.0
2017-02-22 12:00:00	MSFT	Stock	64.17	64.31	64.16	64.28	1392571.0
2017-02-22 13:00:00	MSFT	Stock	64.275	64.32	64.2	64.21	974410.0
2017-02-22 14:00:00	MSFT	Stock	64.22	64.245	64.11	64.174	1736157.0
2017-02-22 15:00:00	MSFT	Stock	64.17	64.37	64.14	64.36	4412993.0
2017-02-22 16:00:00	MSFT	Stock	64.36	64.36	64.14	64.23	2627356.0
2017-02-22 17:00:00	MSFT	Stock	64.17	64.32	64.17	64.32	2930.0
2017-02-22 18:00:00	MSFT	Stock	64.32	64.32	64.26	64.26	650.0
2017-02-22 19:00:00	MSFT	Stock	64.28	64.32	64.28	64.28	3859.0
2017-02-22 06:00:00	NVDA	Stock	2.7775	2.7802	2.7775	2.78	28000.0
2017-02-22 07:00:00	NVDA	Stock	2.7775	2.7775	2.7638	2.775	239840.0
2017-02-22 08:00:00	NVDA	Stock	2.7738	2.7812	2.7688	2.7743	2039360.0
2017-02-22 09:00:00	NVDA	Stock	2.775	2.795	2.7498	2.777	112923120.0
2017-02-22 10:00:00	NVDA	Stock	2.7773	2.778	2.761	2.7663	73034280.0
2017-02-22 11:00:00	NVDA	Stock	2.7663	2.787	2.7605	2.779	47203680.0
2017-02-22 12:00:00	NVDA	Stock	2.7788	2.7795	2.7652	2.7705	27580880.0
2017-02-22 13:00:00	NVDA	Stock	2.77	2.7738	2.7645	2.7692	21168800.0
2017-02-22 14:00:00	NVDA	Stock	2.7698	2.7703	2.7508	2.756	44422960.0
2017-02-22 15:00:00	NVDA	Stock	2.756	2.7705	2.7535	2.769	57381480.0
2017-02-22 16:00:00	NVDA	Stock	2.769	2.7748	2.7052	2.7175	22038920.0
2017-02-22 17:00:00	NVDA	Stock	2.7163	2.7175	2.6832	2.695	6874120.0
2017-02-22 18:00:00	NVDA	Stock	2.697	2.71	2.6918	2.7068	2666280.0
2017-02-22 19:00:00	NVDA	Stock	2.705	2.7063	2.695	2.7025	1427000.0
2017-02-22 04:00:00	AMZN	Stock	42.895	42.895	42.883	42.883	6800.0
2017-02-22 06:00:00	AMZN	Stock	42.905	42.905	42.883	42.883	34080.0
2017-02-22 07:00:00	AMZN	Stock	42.8275	42.8475	42.8215	42.8225	96120.0
2017-02-22 08:00:00	AMZN	Stock	42.845	42.845	42.8075	42.8223	137540.0
2017-02-22 09:00:00	AMZN	Stock	42.8268	42.894	42.632	42.6665	8045960.0
2017-02-22 10:00:00	AMZN	Stock	42.6675	42.768	42.609	42.739	9072240.0

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

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