PREVIEW / stock_1hour / 2013-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-16.parquet
  size:    1.0 MB
  rows:    48,411
  symbols: 3,554

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
2013-12-16 04:00:00	AAPL	Stock	19.75	19.8125	19.75	19.8125	47040.0
2013-12-16 05:00:00	AAPL	Stock	19.8511	19.8857	19.8396	19.8761	108024.0
2013-12-16 06:00:00	AAPL	Stock	19.8929	19.8964	19.8482	19.8661	139832.0
2013-12-16 07:00:00	AAPL	Stock	19.8661	19.9143	19.8571	19.9068	406756.0
2013-12-16 08:00:00	AAPL	Stock	19.9068	19.9068	19.85	19.8993	1697304.0
2013-12-16 09:00:00	AAPL	Stock	19.8993	20.0486	19.8143	20.0461	55477408.0
2013-12-16 10:00:00	AAPL	Stock	20.0461	20.0857	19.9971	20.0514	47423936.0
2013-12-16 11:00:00	AAPL	Stock	20.0471	20.0893	20.0233	20.0395	23873360.0
2013-12-16 12:00:00	AAPL	Stock	20.0364	20.0425	19.9721	19.9968	19465040.0
2013-12-16 13:00:00	AAPL	Stock	19.9968	20.0164	19.9354	19.9836	19662496.0
2013-12-16 14:00:00	AAPL	Stock	19.9829	19.9971	19.9446	19.9804	13590556.0
2013-12-16 15:00:00	AAPL	Stock	19.9804	19.9811	19.8643	19.9087	33954592.0
2013-12-16 16:00:00	AAPL	Stock	19.9083	19.9915	19.8939	19.9232	24402112.0
2013-12-16 17:00:00	AAPL	Stock	19.9243	19.925	19.9164	19.9179	22960.0
2013-12-16 18:00:00	AAPL	Stock	19.9179	19.925	19.9107	19.925	156044.0
2013-12-16 19:00:00	AAPL	Stock	19.9243	19.9246	19.9025	19.9161	111636.0
2013-12-16 07:00:00	MSFT	Stock	36.84	36.95	36.84	36.95	5923.0
2013-12-16 08:00:00	MSFT	Stock	36.91	36.94	36.89	36.89	17357.0
2013-12-16 09:00:00	MSFT	Stock	36.89	36.93	36.54	36.8	5287373.0
2013-12-16 10:00:00	MSFT	Stock	36.8	37.0	36.78	36.93	7377382.0
2013-12-16 11:00:00	MSFT	Stock	36.93	36.97	36.84	36.91	3076215.0
2013-12-16 12:00:00	MSFT	Stock	36.91	36.959	36.815	36.88	2377123.0
2013-12-16 13:00:00	MSFT	Stock	36.889	36.9	36.79	36.86	2052084.0
2013-12-16 14:00:00	MSFT	Stock	36.86	36.96	36.84	36.876	1854972.0
2013-12-16 15:00:00	MSFT	Stock	36.87	36.94	36.84	36.88	4143367.0
2013-12-16 16:00:00	MSFT	Stock	36.88	36.936	36.86	36.88	4327294.0
2013-12-16 17:00:00	MSFT	Stock	36.896	36.896	36.69	36.69	2691.0
2013-12-16 19:00:00	MSFT	Stock	36.9	36.9	36.9	36.9	100.0
2013-12-16 09:00:00	NVDA	Stock	0.378	0.38	0.3758	0.379	41291000.0
2013-12-16 10:00:00	NVDA	Stock	0.3788	0.3793	0.3765	0.3773	28383360.0
2013-12-16 11:00:00	NVDA	Stock	0.3773	0.3778	0.376	0.3771	26929000.0
2013-12-16 12:00:00	NVDA	Stock	0.3773	0.3778	0.3763	0.377	20864200.0
2013-12-16 13:00:00	NVDA	Stock	0.377	0.3775	0.3763	0.377	12552200.0
2013-12-16 14:00:00	NVDA	Stock	0.3769	0.377	0.3758	0.3765	13445840.0
2013-12-16 15:00:00	NVDA	Stock	0.3766	0.377	0.3755	0.3756	47351920.0
2013-12-16 16:00:00	NVDA	Stock	0.3758	0.376	0.3753	0.3759	45516720.0
2013-12-16 19:00:00	NVDA	Stock	0.377	0.377	0.377	0.377	160000.0
2013-12-16 04:00:00	AMZN	Stock	19.245	19.245	19.245	19.245	2000.0
2013-12-16 05:00:00	AMZN	Stock	19.336	19.336	19.336	19.336	2000.0
2013-12-16 06:00:00	AMZN	Stock	19.39	19.39	19.39	19.39	2000.0
2013-12-16 07:00:00	AMZN	Stock	19.387	19.387	19.387	19.387	2980.0
2013-12-16 08:00:00	AMZN	Stock	19.37	19.4	19.2675	19.3475	81280.0
2013-12-16 09:00:00	AMZN	Stock	19.34	19.56	19.235	19.5035	9441120.0
2013-12-16 10:00:00	AMZN	Stock	19.5023	19.585	19.4346	19.4505	7436700.0
2013-12-16 11:00:00	AMZN	Stock	19.4523	19.4805	19.4	19.4225	3862340.0
2013-12-16 12:00:00	AMZN	Stock	19.426	19.4285	19.341	19.3665	4857340.0
2013-12-16 13:00:00	AMZN	Stock	19.3715	19.422	19.314	19.4165	3813660.0
2013-12-16 14:00:00	AMZN	Stock	19.4045	19.444	19.4001	19.4195	2693400.0
2013-12-16 15:00:00	AMZN	Stock	19.4229	19.46	19.3927	19.4485	6995560.0
2013-12-16 16:00:00	AMZN	Stock	19.4485	19.4656	19.415	19.44	1951420.0

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

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