PREVIEW / stock_1hour / 2014-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-12.parquet
  size:    1.1 MB
  rows:    49,646
  symbols: 3,550

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
2014-12-12 04:00:00	AAPL	Stock	27.7775	27.7775	27.63	27.655	30024.0
2014-12-12 05:00:00	AAPL	Stock	27.6925	27.7025	27.6625	27.675	20660.0
2014-12-12 06:00:00	AAPL	Stock	27.6525	27.675	27.6375	27.675	100884.0
2014-12-12 07:00:00	AAPL	Stock	27.6625	27.8275	27.6625	27.7825	176960.0
2014-12-12 08:00:00	AAPL	Stock	27.79	27.83	27.6325	27.7075	859488.0
2014-12-12 09:00:00	AAPL	Stock	27.7	27.9675	27.57	27.8525	26819348.0
2014-12-12 10:00:00	AAPL	Stock	27.85	27.8825	27.5725	27.5862	28581876.0
2014-12-12 11:00:00	AAPL	Stock	27.5875	27.6875	27.51	27.5575	27969656.0
2014-12-12 12:00:00	AAPL	Stock	27.5625	27.6725	27.5275	27.615	17251364.0
2014-12-12 13:00:00	AAPL	Stock	27.6125	27.8525	27.5775	27.725	20187444.0
2014-12-12 14:00:00	AAPL	Stock	27.725	27.7575	27.535	27.5625	17281688.0
2014-12-12 15:00:00	AAPL	Stock	27.5612	27.615	27.395	27.43	48873480.0
2014-12-12 16:00:00	AAPL	Stock	27.4325	27.6538	27.4232	27.4375	16442132.0
2014-12-12 17:00:00	AAPL	Stock	27.4375	27.45	27.415	27.42	542872.0
2014-12-12 18:00:00	AAPL	Stock	27.415	27.4825	27.4125	27.4698	317312.0
2014-12-12 19:00:00	AAPL	Stock	27.465	27.47	27.425	27.4375	125568.0
2014-12-12 04:00:00	MSFT	Stock	47.38	47.38	46.59	46.59	1900.0
2014-12-12 05:00:00	MSFT	Stock	46.72	46.72	46.72	46.72	300.0
2014-12-12 06:00:00	MSFT	Stock	46.71	46.83	46.71	46.82	4100.0
2014-12-12 07:00:00	MSFT	Stock	46.8	46.88	46.8	46.82	4700.0
2014-12-12 08:00:00	MSFT	Stock	46.96	46.97	46.84	46.86	13175.0
2014-12-12 09:00:00	MSFT	Stock	46.86	47.73	46.64	47.64	4846562.0
2014-12-12 10:00:00	MSFT	Stock	47.64	47.675	47.23	47.26	4687509.0
2014-12-12 11:00:00	MSFT	Stock	47.26	47.38	47.12	47.2	3509508.0
2014-12-12 12:00:00	MSFT	Stock	47.2	47.395	47.15	47.255	2132123.0
2014-12-12 13:00:00	MSFT	Stock	47.26	47.71	47.25	47.65	2645728.0
2014-12-12 14:00:00	MSFT	Stock	47.64	47.65	47.32	47.41	2457833.0
2014-12-12 15:00:00	MSFT	Stock	47.405	47.45	46.9	46.94	8374916.0
2014-12-12 16:00:00	MSFT	Stock	46.95	47.306	46.81	46.9	4174450.0
2014-12-12 17:00:00	MSFT	Stock	46.95	46.95	46.94	46.95	71935.0
2014-12-12 18:00:00	MSFT	Stock	46.949	46.95	46.949	46.95	700.0
2014-12-12 09:00:00	NVDA	Stock	0.5018	0.5043	0.4995	0.502	30482800.0
2014-12-12 10:00:00	NVDA	Stock	0.5022	0.5032	0.4965	0.4968	59571320.0
2014-12-12 11:00:00	NVDA	Stock	0.497	0.498	0.495	0.4963	54146520.0
2014-12-12 12:00:00	NVDA	Stock	0.4965	0.4982	0.4963	0.4965	16615600.0
2014-12-12 13:00:00	NVDA	Stock	0.4964	0.4998	0.4959	0.4988	20701880.0
2014-12-12 14:00:00	NVDA	Stock	0.4986	0.5	0.4954	0.4965	30254360.0
2014-12-12 15:00:00	NVDA	Stock	0.4965	0.4972	0.4902	0.4909	82051440.0
2014-12-12 16:00:00	NVDA	Stock	0.4908	0.4931	0.4908	0.4908	4195240.0
2014-12-12 17:00:00	NVDA	Stock	0.4908	0.4908	0.4908	0.4908	173160.0
2014-12-12 19:00:00	NVDA	Stock	0.4923	0.4923	0.4923	0.4923	8000.0
2014-12-12 06:00:00	AMZN	Stock	15.2285	15.23	15.2285	15.23	4000.0
2014-12-12 07:00:00	AMZN	Stock	15.2375	15.275	15.2375	15.275	24100.0
2014-12-12 08:00:00	AMZN	Stock	15.2675	15.368	15.238	15.25	95940.0
2014-12-12 09:00:00	AMZN	Stock	15.27	15.425	15.1505	15.3925	7632140.0
2014-12-12 10:00:00	AMZN	Stock	15.3912	15.419	15.3	15.325	7708600.0
2014-12-12 11:00:00	AMZN	Stock	15.325	15.5035	15.2955	15.4385	9505860.0
2014-12-12 12:00:00	AMZN	Stock	15.4385	15.4625	15.39	15.422	4653420.0
2014-12-12 13:00:00	AMZN	Stock	15.421	15.532	15.401	15.4974	7361480.0
2014-12-12 14:00:00	AMZN	Stock	15.4984	15.5124	15.4595	15.5035	5299860.0

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

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