PREVIEW / stock_1hour / 2013-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-01.parquet
  size:    989 KB
  rows:    45,992
  symbols: 3,479

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-05-01 05:00:00	AAPL	Stock	15.8332	15.8332	15.8332	15.8332	12180.0
2013-05-01 06:00:00	AAPL	Stock	15.855	15.855	15.855	15.855	2800.0
2013-05-01 07:00:00	AAPL	Stock	15.8429	15.9421	15.8429	15.9086	1131340.0
2013-05-01 08:00:00	AAPL	Stock	15.9107	15.9286	15.8196	15.8279	4172084.0
2013-05-01 09:00:00	AAPL	Stock	15.8321	15.8904	15.6575	15.7054	100009812.0
2013-05-01 10:00:00	AAPL	Stock	15.7054	15.75	15.5139	15.6971	128129204.0
2013-05-01 11:00:00	AAPL	Stock	15.695	15.725	15.6107	15.6582	52433836.0
2013-05-01 12:00:00	AAPL	Stock	15.6564	15.6911	15.6198	15.6336	26313840.0
2013-05-01 13:00:00	AAPL	Stock	15.6332	15.6425	15.5682	15.6175	34342672.0
2013-05-01 14:00:00	AAPL	Stock	15.6161	15.7857	15.6145	15.7796	67477452.0
2013-05-01 15:00:00	AAPL	Stock	15.7761	15.7814	15.6461	15.6939	69523104.0
2013-05-01 16:00:00	AAPL	Stock	15.6939	15.6939	15.6671	15.6818	14909692.0
2013-05-01 17:00:00	AAPL	Stock	15.6889	15.6889	15.6779	15.6875	279580.0
2013-05-01 18:00:00	AAPL	Stock	15.6943	15.6943	15.6807	15.6875	108780.0
2013-05-01 19:00:00	AAPL	Stock	15.6836	15.6946	15.6821	15.6943	165060.0
2013-05-01 07:00:00	MSFT	Stock	33.0	33.0	33.0	33.0	2500.0
2013-05-01 08:00:00	MSFT	Stock	32.99	33.08	32.95	32.95	14525.0
2013-05-01 09:00:00	MSFT	Stock	32.94	33.1	32.6	32.748	10774099.0
2013-05-01 10:00:00	MSFT	Stock	32.76	32.86	32.61	32.705	10031236.0
2013-05-01 11:00:00	MSFT	Stock	32.7	32.95	32.63	32.92	5531409.0
2013-05-01 12:00:00	MSFT	Stock	32.913	32.95	32.8	32.811	4272759.0
2013-05-01 13:00:00	MSFT	Stock	32.81	32.83	32.72	32.76	4078970.0
2013-05-01 14:00:00	MSFT	Stock	32.764	32.94	32.76	32.83	5782912.0
2013-05-01 15:00:00	MSFT	Stock	32.83	32.875	32.6	32.74	10579945.0
2013-05-01 16:00:00	MSFT	Stock	32.72	33.1	32.64	32.69	1983798.0
2013-05-01 17:00:00	MSFT	Stock	32.69	32.72	32.65	32.66	4206.0
2013-05-01 18:00:00	MSFT	Stock	32.69	32.7	32.67	32.67	4154.0
2013-05-01 19:00:00	MSFT	Stock	32.67	32.69	32.67	32.68	3875.0
2013-05-01 09:00:00	NVDA	Stock	0.3445	0.3448	0.3411	0.3429	59518480.0
2013-05-01 10:00:00	NVDA	Stock	0.343	0.346	0.342	0.3453	45829480.0
2013-05-01 11:00:00	NVDA	Stock	0.3453	0.3465	0.344	0.3454	26150960.0
2013-05-01 12:00:00	NVDA	Stock	0.3455	0.3455	0.3418	0.344	31859680.0
2013-05-01 13:00:00	NVDA	Stock	0.3442	0.3453	0.3435	0.3435	12474720.0
2013-05-01 14:00:00	NVDA	Stock	0.3435	0.345	0.3424	0.3433	39246960.0
2013-05-01 15:00:00	NVDA	Stock	0.3433	0.3434	0.34	0.3413	113984120.0
2013-05-01 16:00:00	NVDA	Stock	0.3413	0.3415	0.3412	0.3412	3331120.0
2013-05-01 08:00:00	AMZN	Stock	12.6585	12.687	12.6555	12.6555	30000.0
2013-05-01 09:00:00	AMZN	Stock	12.6175	12.71	12.576	12.604	9721300.0
2013-05-01 10:00:00	AMZN	Stock	12.6075	12.623	12.351	12.433	21607640.0
2013-05-01 11:00:00	AMZN	Stock	12.4345	12.4715	12.327	12.3855	12570940.0
2013-05-01 12:00:00	AMZN	Stock	12.3805	12.3855	12.2875	12.3185	8023060.0
2013-05-01 13:00:00	AMZN	Stock	12.3175	12.413	12.301	12.404	11975000.0
2013-05-01 14:00:00	AMZN	Stock	12.4065	12.445	12.3745	12.383	7580100.0
2013-05-01 15:00:00	AMZN	Stock	12.383	12.4145	12.338	12.414	14158480.0
2013-05-01 16:00:00	AMZN	Stock	12.4115	12.6905	12.3435	12.4175	549720.0
2013-05-01 17:00:00	AMZN	Stock	12.4115	12.4175	12.4055	12.41	183840.0
2013-05-01 18:00:00	AMZN	Stock	12.415	12.415	12.4045	12.405	8000.0
2013-05-01 19:00:00	AMZN	Stock	12.4075	12.4225	12.4075	12.4125	10000.0
2013-05-01 06:00:00	META	Stock	27.74	27.74	27.7	27.7	700.0
2013-05-01 07:00:00	META	Stock	27.9	28.04	27.88	27.97	69752.0

> showing 50 of 45,992 rows — these rows as CSV

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