PREVIEW / stock_1hour / 2017-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-07.parquet
  size:    1.1 MB
  rows:    48,991
  symbols: 2,949

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-07 04:00:00	AAPL	Stock	43.55	43.625	43.55	43.5875	15332.0
2017-11-07 05:00:00	AAPL	Stock	43.595	43.595	43.4675	43.4675	2000.0
2017-11-07 06:00:00	AAPL	Stock	43.5	43.575	43.5	43.55	26328.0
2017-11-07 07:00:00	AAPL	Stock	43.5125	43.5625	43.4725	43.485	124904.0
2017-11-07 08:00:00	AAPL	Stock	43.485	43.75	43.4775	43.5325	474948.0
2017-11-07 09:00:00	AAPL	Stock	43.515	43.8125	43.4	43.7225	21328548.0
2017-11-07 10:00:00	AAPL	Stock	43.725	43.7975	43.505	43.6475	16313460.0
2017-11-07 11:00:00	AAPL	Stock	43.65	43.785	43.59	43.6158	10805736.0
2017-11-07 12:00:00	AAPL	Stock	43.6248	43.6825	43.5075	43.6805	8929848.0
2017-11-07 13:00:00	AAPL	Stock	43.6775	43.7425	43.6125	43.6375	6533996.0
2017-11-07 14:00:00	AAPL	Stock	43.635	43.6675	43.565	43.646	5504416.0
2017-11-07 15:00:00	AAPL	Stock	43.6462	43.7025	43.6025	43.6975	9536712.0
2017-11-07 16:00:00	AAPL	Stock	43.7025	43.72	43.6612	43.6825	7637980.0
2017-11-07 17:00:00	AAPL	Stock	43.6875	43.7	43.655	43.655	46720.0
2017-11-07 18:00:00	AAPL	Stock	43.6525	43.6625	43.58	43.58	49396.0
2017-11-07 19:00:00	AAPL	Stock	43.59	43.625	43.5825	43.6	23076.0
2017-11-07 05:00:00	MSFT	Stock	84.89	84.93	84.89	84.93	2432.0
2017-11-07 06:00:00	MSFT	Stock	85.0	85.0	84.8	84.81	4226.0
2017-11-07 07:00:00	MSFT	Stock	84.82	84.82	84.7	84.7	7157.0
2017-11-07 08:00:00	MSFT	Stock	84.81	84.81	84.62	84.8	8987.0
2017-11-07 09:00:00	MSFT	Stock	84.75	84.9	84.33	84.33	1930403.0
2017-11-07 10:00:00	MSFT	Stock	84.33	84.48	84.07	84.13	2299911.0
2017-11-07 11:00:00	MSFT	Stock	84.14	84.24	83.98	84.0	1714041.0
2017-11-07 12:00:00	MSFT	Stock	84.0	84.175	83.93	84.14	1296197.0
2017-11-07 13:00:00	MSFT	Stock	84.14	84.276	84.02	84.027	1131379.0
2017-11-07 14:00:00	MSFT	Stock	84.025	84.125	83.97	83.98	1513975.0
2017-11-07 15:00:00	MSFT	Stock	83.985	84.27	83.96	84.26	3348880.0
2017-11-07 16:00:00	MSFT	Stock	84.27	84.27	84.03	84.04	2025149.0
2017-11-07 17:00:00	MSFT	Stock	84.08	84.08	84.06	84.06	5090.0
2017-11-07 18:00:00	MSFT	Stock	84.05	84.08	84.01	84.01	6250.0
2017-11-07 19:00:00	MSFT	Stock	84.08	84.08	83.97	83.97	4405.0
2017-11-07 04:00:00	NVDA	Stock	5.2623	5.2623	5.25	5.25	90840.0
2017-11-07 05:00:00	NVDA	Stock	5.2552	5.2552	5.2425	5.2468	77200.0
2017-11-07 06:00:00	NVDA	Stock	5.2455	5.257	5.2388	5.2525	301800.0
2017-11-07 07:00:00	NVDA	Stock	5.25	5.26	5.249	5.249	407320.0
2017-11-07 08:00:00	NVDA	Stock	5.2378	5.2608	5.2378	5.2575	1208760.0
2017-11-07 09:00:00	NVDA	Stock	5.2575	5.3095	5.2514	5.2895	86105440.0
2017-11-07 10:00:00	NVDA	Stock	5.2908	5.3075	5.2676	5.304	83905840.0
2017-11-07 11:00:00	NVDA	Stock	5.304	5.3225	5.2728	5.2788	62190560.0
2017-11-07 12:00:00	NVDA	Stock	5.2788	5.2895	5.2688	5.285	38756800.0
2017-11-07 13:00:00	NVDA	Stock	5.2842	5.3038	5.2818	5.3015	28820720.0
2017-11-07 14:00:00	NVDA	Stock	5.3016	5.3032	5.2828	5.2975	24018800.0
2017-11-07 15:00:00	NVDA	Stock	5.298	5.303	5.2768	5.3002	50060720.0
2017-11-07 16:00:00	NVDA	Stock	5.2888	5.3013	5.275	5.2902	19056840.0
2017-11-07 17:00:00	NVDA	Stock	5.2925	5.2993	5.2925	5.2925	242200.0
2017-11-07 18:00:00	NVDA	Stock	5.2988	5.2995	5.29	5.2938	275000.0
2017-11-07 19:00:00	NVDA	Stock	5.2925	5.295	5.285	5.2892	453480.0
2017-11-07 04:00:00	AMZN	Stock	56.099	56.1045	56.099	56.1045	16000.0
2017-11-07 05:00:00	AMZN	Stock	56.079	56.079	56.0125	56.0125	8080.0
2017-11-07 06:00:00	AMZN	Stock	56.021	56.021	56.021	56.021	2480.0

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

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