PREVIEW / stock_1hour / 2015-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-11.parquet
  size:    1.0 MB
  rows:    48,307
  symbols: 3,519

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
2015-02-11 04:00:00	AAPL	Stock	30.505	30.555	30.495	30.55	54252.0
2015-02-11 05:00:00	AAPL	Stock	30.575	30.6225	30.5625	30.595	71220.0
2015-02-11 06:00:00	AAPL	Stock	30.5875	30.6225	30.575	30.59	139080.0
2015-02-11 07:00:00	AAPL	Stock	30.59	30.63	30.5625	30.5725	247920.0
2015-02-11 08:00:00	AAPL	Stock	30.5625	30.6375	30.56	30.62	1451132.0
2015-02-11 09:00:00	AAPL	Stock	30.62	30.92	30.5925	30.919	52078924.0
2015-02-11 10:00:00	AAPL	Stock	30.9175	31.0325	30.8525	30.9625	49444632.0
2015-02-11 11:00:00	AAPL	Stock	30.96	31.09	30.9525	31.0725	29325224.0
2015-02-11 12:00:00	AAPL	Stock	31.0725	31.1075	30.99	31.0402	27936440.0
2015-02-11 13:00:00	AAPL	Stock	31.0425	31.0875	30.9125	31.0562	26175344.0
2015-02-11 14:00:00	AAPL	Stock	31.0575	31.19	31.055	31.1775	31330264.0
2015-02-11 15:00:00	AAPL	Stock	31.1775	31.23	31.1125	31.2175	47553204.0
2015-02-11 16:00:00	AAPL	Stock	31.22	31.3125	30.8292	31.295	9530176.0
2015-02-11 17:00:00	AAPL	Stock	31.2875	31.3125	31.22	31.3	1359688.0
2015-02-11 18:00:00	AAPL	Stock	31.3	31.305	31.22	31.2875	583672.0
2015-02-11 19:00:00	AAPL	Stock	31.2875	31.305	31.285	31.2975	314404.0
2015-02-11 08:00:00	MSFT	Stock	42.56	42.6	42.51	42.56	36355.0
2015-02-11 09:00:00	MSFT	Stock	42.56	42.65	42.31	42.4	4690983.0
2015-02-11 10:00:00	MSFT	Stock	42.39	42.44	42.27	42.325	3369704.0
2015-02-11 11:00:00	MSFT	Stock	42.32	42.59	42.32	42.5	4626908.0
2015-02-11 12:00:00	MSFT	Stock	42.5	42.53	42.36	42.395	2778457.0
2015-02-11 13:00:00	MSFT	Stock	42.395	42.45	42.21	42.32	3428210.0
2015-02-11 14:00:00	MSFT	Stock	42.325	42.395	42.21	42.315	3170502.0
2015-02-11 15:00:00	MSFT	Stock	42.32	42.415	42.22	42.37	9174943.0
2015-02-11 16:00:00	MSFT	Stock	42.37	42.535	42.25	42.38	1852638.0
2015-02-11 17:00:00	MSFT	Stock	42.49	42.5	42.38	42.43	25831.0
2015-02-11 18:00:00	MSFT	Stock	42.43	42.43	42.41	42.42	2051.0
2015-02-11 19:00:00	MSFT	Stock	42.46	42.48	42.43	42.43	2079.0
2015-02-11 08:00:00	NVDA	Stock	0.5268	0.5272	0.5268	0.5272	37200.0
2015-02-11 09:00:00	NVDA	Stock	0.525	0.525	0.5197	0.5226	26789200.0
2015-02-11 10:00:00	NVDA	Stock	0.5226	0.5242	0.5213	0.5225	43708920.0
2015-02-11 11:00:00	NVDA	Stock	0.5225	0.5235	0.5213	0.5228	29780440.0
2015-02-11 12:00:00	NVDA	Stock	0.5229	0.5229	0.52	0.52	17351920.0
2015-02-11 13:00:00	NVDA	Stock	0.52	0.5213	0.5168	0.52	37232080.0
2015-02-11 14:00:00	NVDA	Stock	0.5198	0.522	0.5178	0.5205	35646440.0
2015-02-11 15:00:00	NVDA	Stock	0.5205	0.522	0.5185	0.5202	86862600.0
2015-02-11 16:00:00	NVDA	Stock	0.5202	0.5672	0.5202	0.5432	31140840.0
2015-02-11 17:00:00	NVDA	Stock	0.5445	0.5448	0.5395	0.5448	579000.0
2015-02-11 18:00:00	NVDA	Stock	0.545	0.545	0.5402	0.544	131200.0
2015-02-11 19:00:00	NVDA	Stock	0.544	0.545	0.5412	0.5412	506480.0
2015-02-11 06:00:00	AMZN	Stock	18.621	18.621	18.621	18.621	7420.0
2015-02-11 08:00:00	AMZN	Stock	18.575	18.595	18.575	18.575	21600.0
2015-02-11 09:00:00	AMZN	Stock	18.55	18.71	18.55	18.673	6286000.0
2015-02-11 10:00:00	AMZN	Stock	18.665	18.84	18.602	18.781	17926360.0
2015-02-11 11:00:00	AMZN	Stock	18.784	18.855	18.713	18.735	6350680.0
2015-02-11 12:00:00	AMZN	Stock	18.739	18.797	18.7165	18.7255	5324920.0
2015-02-11 13:00:00	AMZN	Stock	18.725	18.76	18.678	18.743	3795040.0
2015-02-11 14:00:00	AMZN	Stock	18.747	18.765	18.702	18.7135	3204020.0
2015-02-11 15:00:00	AMZN	Stock	18.7185	18.8055	18.709	18.7575	6710740.0
2015-02-11 16:00:00	AMZN	Stock	18.7414	18.833	18.7035	18.833	508180.0

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

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