PREVIEW / stock_1hour / 2016-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-04.parquet
  size:    1.0 MB
  rows:    47,994
  symbols: 3,176

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
2016-11-04 04:00:00	AAPL	Stock	27.4575	27.5025	27.415	27.415	6132.0
2016-11-04 05:00:00	AAPL	Stock	27.4175	27.4175	27.325	27.325	7280.0
2016-11-04 06:00:00	AAPL	Stock	27.35	27.375	27.325	27.375	12376.0
2016-11-04 07:00:00	AAPL	Stock	27.37	27.4075	27.37	27.4075	21948.0
2016-11-04 08:00:00	AAPL	Stock	27.395	27.46	27.33	27.435	216740.0
2016-11-04 09:00:00	AAPL	Stock	27.4175	27.4575	26.9275	27.1425	27918612.0
2016-11-04 10:00:00	AAPL	Stock	27.145	27.4075	27.14	27.3475	17532140.0
2016-11-04 11:00:00	AAPL	Stock	27.3475	27.4788	27.3375	27.4598	10706152.0
2016-11-04 12:00:00	AAPL	Stock	27.4588	27.49	27.4338	27.4645	7501464.0
2016-11-04 13:00:00	AAPL	Stock	27.465	27.5625	27.455	27.49	8767500.0
2016-11-04 14:00:00	AAPL	Stock	27.49	27.49	27.32	27.355	9174432.0
2016-11-04 15:00:00	AAPL	Stock	27.355	27.355	27.185	27.21	22911544.0
2016-11-04 16:00:00	AAPL	Stock	27.21	27.2375	27.1925	27.2375	8031172.0
2016-11-04 17:00:00	AAPL	Stock	27.2375	27.2375	27.175	27.175	72656.0
2016-11-04 18:00:00	AAPL	Stock	27.175	27.2	27.1625	27.1875	68784.0
2016-11-04 19:00:00	AAPL	Stock	27.175	27.2075	27.165	27.2	34892.0
2016-11-04 08:00:00	MSFT	Stock	59.11	59.21	59.11	59.19	4914.0
2016-11-04 09:00:00	MSFT	Stock	59.15	59.21	58.33	58.665	6714154.0
2016-11-04 10:00:00	MSFT	Stock	58.67	59.24	58.67	59.17	3227577.0
2016-11-04 11:00:00	MSFT	Stock	59.17	59.28	59.06	59.1	2625501.0
2016-11-04 12:00:00	MSFT	Stock	59.1	59.22	59.09	59.145	1792444.0
2016-11-04 13:00:00	MSFT	Stock	59.14	59.2	59.04	59.1	1670768.0
2016-11-04 14:00:00	MSFT	Stock	59.1	59.19	58.99	59.03	2239606.0
2016-11-04 15:00:00	MSFT	Stock	59.03	59.04	58.71	58.71	4945756.0
2016-11-04 16:00:00	MSFT	Stock	58.71	58.8	58.7	58.79	4311634.0
2016-11-04 17:00:00	MSFT	Stock	58.75	58.75	58.7	58.7	2204.0
2016-11-04 18:00:00	MSFT	Stock	58.61	58.62	58.61	58.62	639.0
2016-11-04 19:00:00	MSFT	Stock	58.65	58.7	58.65	58.7	250.0
2016-11-04 05:00:00	NVDA	Stock	1.7012	1.7012	1.7008	1.7008	53600.0
2016-11-04 06:00:00	NVDA	Stock	1.694	1.6942	1.694	1.694	13800.0
2016-11-04 07:00:00	NVDA	Stock	1.6875	1.6875	1.6875	1.6875	60000.0
2016-11-04 08:00:00	NVDA	Stock	1.6875	1.7008	1.6872	1.7008	235840.0
2016-11-04 09:00:00	NVDA	Stock	1.6988	1.699	1.6644	1.6695	37271240.0
2016-11-04 10:00:00	NVDA	Stock	1.6692	1.695	1.669	1.6926	47713280.0
2016-11-04 11:00:00	NVDA	Stock	1.6922	1.7158	1.6922	1.7052	64286680.0
2016-11-04 12:00:00	NVDA	Stock	1.7052	1.7178	1.703	1.7147	31730240.0
2016-11-04 13:00:00	NVDA	Stock	1.7145	1.7183	1.7034	1.705	27172320.0
2016-11-04 14:00:00	NVDA	Stock	1.705	1.7052	1.6882	1.6918	26283840.0
2016-11-04 15:00:00	NVDA	Stock	1.6918	1.6946	1.687	1.6892	52535640.0
2016-11-04 16:00:00	NVDA	Stock	1.6892	1.6962	1.6882	1.6962	14843000.0
2016-11-04 17:00:00	NVDA	Stock	1.695	1.695	1.6918	1.695	96000.0
2016-11-04 18:00:00	NVDA	Stock	1.6895	1.705	1.6895	1.695	251920.0
2016-11-04 19:00:00	NVDA	Stock	1.6928	1.6988	1.6928	1.6988	8800.0
2016-11-04 05:00:00	AMZN	Stock	38.254	38.254	38.254	38.254	3000.0
2016-11-04 06:00:00	AMZN	Stock	38.254	38.3	38.254	38.3	14000.0
2016-11-04 07:00:00	AMZN	Stock	38.3	38.3	38.3	38.3	5000.0
2016-11-04 08:00:00	AMZN	Stock	38.344	38.4325	38.322	38.4	267480.0
2016-11-04 09:00:00	AMZN	Stock	38.365	38.365	37.6615	37.725	22405960.0
2016-11-04 10:00:00	AMZN	Stock	37.741	38.1665	37.7277	38.0695	17563840.0
2016-11-04 11:00:00	AMZN	Stock	38.0708	38.125	37.9255	37.9476	10024100.0

> showing 50 of 47,994 rows — these rows as CSV

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