PREVIEW / stock_1hour / 2016-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-14.parquet
  size:    1.1 MB
  rows:    49,912
  symbols: 3,183

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-14 04:00:00	AAPL	Stock	27.195	27.195	27.195	27.195	7540.0
2016-11-14 05:00:00	AAPL	Stock	27.2125	27.2125	27.1725	27.1725	6968.0
2016-11-14 06:00:00	AAPL	Stock	27.1425	27.1425	27.0325	27.0725	10732.0
2016-11-14 07:00:00	AAPL	Stock	27.055	27.11	27.05	27.11	27480.0
2016-11-14 08:00:00	AAPL	Stock	27.1	27.11	27.01	27.0125	322356.0
2016-11-14 09:00:00	AAPL	Stock	27.0125	27.03	26.5	26.51	24714452.0
2016-11-14 10:00:00	AAPL	Stock	26.5125	26.58	26.195	26.2125	46356176.0
2016-11-14 11:00:00	AAPL	Stock	26.215	26.39	26.02	26.3312	37251848.0
2016-11-14 12:00:00	AAPL	Stock	26.3362	26.36	26.14	26.315	17573532.0
2016-11-14 13:00:00	AAPL	Stock	26.3158	26.485	26.305	26.36	16400832.0
2016-11-14 14:00:00	AAPL	Stock	26.36	26.555	26.2775	26.55	16678104.0
2016-11-14 15:00:00	AAPL	Stock	26.55	26.575	26.35	26.425	21158228.0
2016-11-14 16:00:00	AAPL	Stock	26.425	26.4625	26.4025	26.4625	7026808.0
2016-11-14 17:00:00	AAPL	Stock	26.44	26.475	26.4275	26.4475	62748.0
2016-11-14 18:00:00	AAPL	Stock	26.4375	26.465	26.4125	26.4125	725780.0
2016-11-14 19:00:00	AAPL	Stock	26.42	26.4275	26.3375	26.375	91360.0
2016-11-14 04:00:00	MSFT	Stock	59.11	59.11	59.11	59.11	340.0
2016-11-14 06:00:00	MSFT	Stock	59.16	59.19	59.05	59.1	5200.0
2016-11-14 07:00:00	MSFT	Stock	59.1	59.15	59.08	59.08	4037.0
2016-11-14 08:00:00	MSFT	Stock	59.15	59.2	58.95	59.2	50516.0
2016-11-14 09:00:00	MSFT	Stock	59.17	59.2	58.36	58.41	3964228.0
2016-11-14 10:00:00	MSFT	Stock	58.4	58.665	57.69	57.69	7268910.0
2016-11-14 11:00:00	MSFT	Stock	57.7	58.136	57.28	57.965	6364587.0
2016-11-14 12:00:00	MSFT	Stock	57.97	58.015	57.62	57.82	3955326.0
2016-11-14 13:00:00	MSFT	Stock	57.83	58.075	57.74	57.945	3377500.0
2016-11-14 14:00:00	MSFT	Stock	57.945	58.26	57.9	58.26	3186449.0
2016-11-14 15:00:00	MSFT	Stock	58.255	58.35	58.03	58.12	6377795.0
2016-11-14 16:00:00	MSFT	Stock	58.13	58.192	58.05	58.19	2900677.0
2016-11-14 17:00:00	MSFT	Stock	58.12	58.19	58.08	58.19	387405.0
2016-11-14 18:00:00	MSFT	Stock	58.14	58.19	58.12	58.12	68153.0
2016-11-14 19:00:00	MSFT	Stock	58.12	58.15	58.08	58.15	3146.0
2016-11-14 04:00:00	NVDA	Stock	2.2125	2.22	2.2125	2.215	318960.0
2016-11-14 05:00:00	NVDA	Stock	2.215	2.215	2.2048	2.205	114400.0
2016-11-14 06:00:00	NVDA	Stock	2.2063	2.2063	2.1903	2.1903	296680.0
2016-11-14 07:00:00	NVDA	Stock	2.1908	2.2095	2.1908	2.204	785280.0
2016-11-14 08:00:00	NVDA	Stock	2.2095	2.21	2.1905	2.2087	8709640.0
2016-11-14 09:00:00	NVDA	Stock	2.21	2.2238	2.103	2.1088	216165960.0
2016-11-14 10:00:00	NVDA	Stock	2.1096	2.1395	2.0905	2.1125	207278360.0
2016-11-14 11:00:00	NVDA	Stock	2.1116	2.1315	2.1075	2.1205	306859320.0
2016-11-14 12:00:00	NVDA	Stock	2.121	2.1338	2.1185	2.1312	296207720.0
2016-11-14 13:00:00	NVDA	Stock	2.1313	2.1383	2.0985	2.1003	66279720.0
2016-11-14 14:00:00	NVDA	Stock	2.0997	2.1102	2.0933	2.108	72112040.0
2016-11-14 15:00:00	NVDA	Stock	2.1078	2.1088	2.0908	2.0915	94393480.0
2016-11-14 16:00:00	NVDA	Stock	2.0915	2.165	2.0888	2.0905	23112680.0
2016-11-14 17:00:00	NVDA	Stock	2.0905	2.0925	2.09	2.0925	110600.0
2016-11-14 18:00:00	NVDA	Stock	2.09	2.0933	2.0802	2.0875	248000.0
2016-11-14 19:00:00	NVDA	Stock	2.0875	2.0875	2.0837	2.0872	201080.0
2016-11-14 04:00:00	AMZN	Stock	37.1215	37.178	37.1215	37.178	6760.0
2016-11-14 05:00:00	AMZN	Stock	37.1575	37.1575	37.1575	37.1575	2000.0
2016-11-14 06:00:00	AMZN	Stock	37.0755	37.0755	36.975	36.975	11700.0

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

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