PREVIEW / stock_1hour / 2013-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-11.parquet
  size:    972 KB
  rows:    45,025
  symbols: 3,465

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-04-11 04:00:00	AAPL	Stock	15.5421	15.5714	15.5268	15.5714	25200.0
2013-04-11 05:00:00	AAPL	Stock	15.5504	15.5707	15.5489	15.5707	27076.0
2013-04-11 06:00:00	AAPL	Stock	15.5811	15.5811	15.5486	15.5486	62440.0
2013-04-11 07:00:00	AAPL	Stock	15.5414	15.5414	15.4179	15.4564	891800.0
2013-04-11 08:00:00	AAPL	Stock	15.4639	15.5361	15.4482	15.4693	2352840.0
2013-04-11 09:00:00	AAPL	Stock	15.4761	15.4975	15.4	15.4707	54598264.0
2013-04-11 10:00:00	AAPL	Stock	15.4707	15.6229	15.4154	15.6146	63670712.0
2013-04-11 11:00:00	AAPL	Stock	15.6168	15.6425	15.5032	15.5254	62513528.0
2013-04-11 12:00:00	AAPL	Stock	15.5268	15.5357	15.4575	15.5061	34787676.0
2013-04-11 13:00:00	AAPL	Stock	15.5071	15.5839	15.5071	15.5104	30289756.0
2013-04-11 14:00:00	AAPL	Stock	15.5139	15.5493	15.4734	15.5425	25569768.0
2013-04-11 15:00:00	AAPL	Stock	15.5436	15.5536	15.4821	15.5132	38913420.0
2013-04-11 16:00:00	AAPL	Stock	15.5143	15.5271	15.4647	15.5143	6500396.0
2013-04-11 17:00:00	AAPL	Stock	15.5211	15.5225	15.5071	15.5143	62832.0
2013-04-11 18:00:00	AAPL	Stock	15.5168	15.5171	15.5061	15.5125	92904.0
2013-04-11 19:00:00	AAPL	Stock	15.5161	15.5211	15.5071	15.5132	228956.0
2013-04-11 04:00:00	MSFT	Stock	29.3	29.38	29.17	29.3	4150.0
2013-04-11 05:00:00	MSFT	Stock	29.31	29.31	29.26	29.26	900.0
2013-04-11 06:00:00	MSFT	Stock	29.25	29.4	29.23	29.35	21175.0
2013-04-11 07:00:00	MSFT	Stock	29.39	29.45	29.18	29.25	545113.0
2013-04-11 08:00:00	MSFT	Stock	29.25	30.15	29.05	29.22	1191863.0
2013-04-11 09:00:00	MSFT	Stock	29.23	29.3	28.76	28.831	29575477.0
2013-04-11 10:00:00	MSFT	Stock	28.84	29.0	28.76	28.81	21190096.0
2013-04-11 11:00:00	MSFT	Stock	28.819	28.84	28.75	28.8	13277159.0
2013-04-11 12:00:00	MSFT	Stock	28.8	28.82	28.73	28.78	13870852.0
2013-04-11 13:00:00	MSFT	Stock	28.79	28.86	28.74	28.76	10680754.0
2013-04-11 14:00:00	MSFT	Stock	28.76	28.83	28.74	28.77	10643152.0
2013-04-11 15:00:00	MSFT	Stock	28.779	28.98	28.74	28.98	20670918.0
2013-04-11 16:00:00	MSFT	Stock	28.98	29.02	28.76	29.0	6131180.0
2013-04-11 17:00:00	MSFT	Stock	29.0	29.02	28.935	28.97	104273.0
2013-04-11 18:00:00	MSFT	Stock	28.97	29.0	28.97	28.97	7294.0
2013-04-11 19:00:00	MSFT	Stock	28.99	29.0	28.97	28.99	12030.0
2013-04-11 08:00:00	NVDA	Stock	0.3178	0.3188	0.3138	0.3163	446000.0
2013-04-11 09:00:00	NVDA	Stock	0.3165	0.3184	0.3148	0.3155	57489320.0
2013-04-11 10:00:00	NVDA	Stock	0.3155	0.3173	0.3134	0.3143	84082240.0
2013-04-11 11:00:00	NVDA	Stock	0.3143	0.3153	0.3113	0.3144	128487120.0
2013-04-11 12:00:00	NVDA	Stock	0.3144	0.3144	0.3075	0.3118	195143920.0
2013-04-11 13:00:00	NVDA	Stock	0.312	0.3213	0.31	0.318	198555040.0
2013-04-11 14:00:00	NVDA	Stock	0.318	0.3213	0.3145	0.3164	140461480.0
2013-04-11 15:00:00	NVDA	Stock	0.3163	0.3205	0.316	0.3191	145202040.0
2013-04-11 16:00:00	NVDA	Stock	0.319	0.32	0.3148	0.319	13375040.0
2013-04-11 17:00:00	NVDA	Stock	0.3205	0.3218	0.3205	0.3218	240000.0
2013-04-11 18:00:00	NVDA	Stock	0.3213	0.3225	0.3213	0.3225	24000.0
2013-04-11 19:00:00	NVDA	Stock	0.3225	0.3225	0.3225	0.3225	4000.0
2013-04-11 04:00:00	AMZN	Stock	13.2125	13.2125	13.2075	13.2075	4000.0
2013-04-11 05:00:00	AMZN	Stock	13.221	13.221	13.221	13.221	6000.0
2013-04-11 06:00:00	AMZN	Stock	13.237	13.237	13.237	13.237	4000.0
2013-04-11 08:00:00	AMZN	Stock	13.233	13.233	13.175	13.194	154900.0
2013-04-11 09:00:00	AMZN	Stock	13.194	13.4115	13.1875	13.3625	8730100.0
2013-04-11 10:00:00	AMZN	Stock	13.3644	13.4695	13.353	13.465	9176560.0

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

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