PREVIEW / stock_1hour / 2017-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-16.parquet
  size:    1.1 MB
  rows:    49,175
  symbols: 2,943

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-16 04:00:00	AAPL	Stock	42.515	42.6025	42.515	42.6025	4332.0
2017-11-16 05:00:00	AAPL	Stock	42.62	42.6625	42.62	42.645	32120.0
2017-11-16 06:00:00	AAPL	Stock	42.6475	42.6475	42.5625	42.6025	62672.0
2017-11-16 07:00:00	AAPL	Stock	42.5925	42.7075	42.5775	42.6925	409332.0
2017-11-16 08:00:00	AAPL	Stock	42.6875	42.75	42.58	42.69	553952.0
2017-11-16 09:00:00	AAPL	Stock	42.69	42.845	42.575	42.6368	15265064.0
2017-11-16 10:00:00	AAPL	Stock	42.635	42.765	42.6075	42.7225	12455128.0
2017-11-16 11:00:00	AAPL	Stock	42.7212	42.8525	42.71	42.825	8070340.0
2017-11-16 12:00:00	AAPL	Stock	42.825	42.935	42.815	42.8775	7445576.0
2017-11-16 13:00:00	AAPL	Stock	42.875	42.955	42.8575	42.94	5977696.0
2017-11-16 14:00:00	AAPL	Stock	42.94	42.9675	42.855	42.8862	7444924.0
2017-11-16 15:00:00	AAPL	Stock	42.8862	42.905	42.7725	42.775	13065176.0
2017-11-16 16:00:00	AAPL	Stock	42.775	42.8375	42.775	42.795	8783376.0
2017-11-16 17:00:00	AAPL	Stock	42.7875	42.825	42.7875	42.8125	59596.0
2017-11-16 18:00:00	AAPL	Stock	42.815	42.82	42.8025	42.805	12304.0
2017-11-16 19:00:00	AAPL	Stock	42.805	42.8175	42.8	42.81	73404.0
2017-11-16 04:00:00	MSFT	Stock	83.23	83.38	83.23	83.38	2620.0
2017-11-16 06:00:00	MSFT	Stock	83.3	83.35	83.3	83.35	966.0
2017-11-16 07:00:00	MSFT	Stock	83.35	83.5	83.35	83.5	6277.0
2017-11-16 08:00:00	MSFT	Stock	83.3	83.5	83.3	83.33	42737.0
2017-11-16 09:00:00	MSFT	Stock	83.34	83.43	83.02	83.12	2417815.0
2017-11-16 10:00:00	MSFT	Stock	83.125	83.245	82.94	83.01	2244842.0
2017-11-16 11:00:00	MSFT	Stock	83.01	83.19	82.99	83.14	1953711.0
2017-11-16 12:00:00	MSFT	Stock	83.135	83.335	83.135	83.3	1989664.0
2017-11-16 13:00:00	MSFT	Stock	83.295	83.405	83.19	83.23	1923935.0
2017-11-16 14:00:00	MSFT	Stock	83.23	83.31	83.18	83.255	2043434.0
2017-11-16 15:00:00	MSFT	Stock	83.25	83.35	83.14	83.19	3650892.0
2017-11-16 16:00:00	MSFT	Stock	83.2	83.2	83.13	83.2	2916148.0
2017-11-16 17:00:00	MSFT	Stock	83.19	83.21	83.16	83.21	3994.0
2017-11-16 18:00:00	MSFT	Stock	83.25	83.25	83.25	83.25	100.0
2017-11-16 19:00:00	MSFT	Stock	83.14	83.24	83.14	83.24	1409.0
2017-11-16 04:00:00	NVDA	Stock	5.2872	5.2872	5.2872	5.2872	20000.0
2017-11-16 05:00:00	NVDA	Stock	5.2875	5.3	5.2875	5.2988	107760.0
2017-11-16 06:00:00	NVDA	Stock	5.3	5.3	5.29	5.2955	121920.0
2017-11-16 07:00:00	NVDA	Stock	5.2945	5.3115	5.292	5.3108	766080.0
2017-11-16 08:00:00	NVDA	Stock	5.3072	5.3123	5.29	5.3025	1955760.0
2017-11-16 09:00:00	NVDA	Stock	5.3008	5.355	5.2998	5.3275	89564880.0
2017-11-16 10:00:00	NVDA	Stock	5.3275	5.345	5.31	5.34	68087560.0
2017-11-16 11:00:00	NVDA	Stock	5.3401	5.3472	5.3255	5.3278	35096480.0
2017-11-16 12:00:00	NVDA	Stock	5.3275	5.3343	5.3162	5.3218	32447320.0
2017-11-16 13:00:00	NVDA	Stock	5.3212	5.3295	5.3112	5.3278	25853480.0
2017-11-16 14:00:00	NVDA	Stock	5.3272	5.3362	5.3024	5.3032	36116080.0
2017-11-16 15:00:00	NVDA	Stock	5.3032	5.3148	5.2812	5.2898	72597560.0
2017-11-16 16:00:00	NVDA	Stock	5.2902	5.3188	5.285	5.3008	50893560.0
2017-11-16 17:00:00	NVDA	Stock	5.3008	5.3175	5.3008	5.3162	584000.0
2017-11-16 18:00:00	NVDA	Stock	5.315	5.322	5.3075	5.322	839400.0
2017-11-16 19:00:00	NVDA	Stock	5.3223	5.3303	5.32	5.3303	876920.0
2017-11-16 06:00:00	AMZN	Stock	56.6885	56.6885	56.6885	56.6885	2800.0
2017-11-16 07:00:00	AMZN	Stock	56.55	56.687	56.55	56.65	71580.0
2017-11-16 08:00:00	AMZN	Stock	56.65	56.671	56.5	56.604	292920.0

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

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