PREVIEW / stock_1hour / 2011-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-30.parquet
  size:    946 KB
  rows:    44,700
  symbols: 3,549

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
2011-06-30 07:00:00	AAPL	Stock	11.9639	11.9732	11.9464	11.9607	120960.0
2011-06-30 08:00:00	AAPL	Stock	11.9482	11.96	11.9357	11.955	428960.0
2011-06-30 09:00:00	AAPL	Stock	11.9625	11.9643	11.8871	11.9146	52206476.0
2011-06-30 10:00:00	AAPL	Stock	11.9171	12.0046	11.9136	11.9546	84316568.0
2011-06-30 11:00:00	AAPL	Stock	11.9554	11.996	11.9518	11.9704	40795468.0
2011-06-30 12:00:00	AAPL	Stock	11.9708	11.9796	11.9525	11.9639	21857108.0
2011-06-30 13:00:00	AAPL	Stock	11.9643	11.9911	11.9607	11.9836	27028204.0
2011-06-30 14:00:00	AAPL	Stock	11.9854	11.9894	11.9611	11.9646	22985256.0
2011-06-30 15:00:00	AAPL	Stock	11.9657	11.9882	11.9611	11.9857	50376872.0
2011-06-30 16:00:00	AAPL	Stock	11.9882	11.9883	11.9627	11.9821	18927636.0
2011-06-30 17:00:00	AAPL	Stock	11.93	11.985	11.93	11.9839	314384.0
2011-06-30 18:00:00	AAPL	Stock	11.9839	11.9882	11.9825	11.9825	146552.0
2011-06-30 19:00:00	AAPL	Stock	11.9854	11.9886	11.9821	11.9868	183372.0
2011-06-30 07:00:00	MSFT	Stock	25.65	25.7	25.65	25.7	7500.0
2011-06-30 08:00:00	MSFT	Stock	25.68	25.69	25.66	25.69	3414.0
2011-06-30 09:00:00	MSFT	Stock	25.69	25.84	25.66	25.77	4223895.0
2011-06-30 10:00:00	MSFT	Stock	25.76	25.9	25.74	25.869	8484330.0
2011-06-30 11:00:00	MSFT	Stock	25.865	26.0	25.86	25.93	9013800.0
2011-06-30 12:00:00	MSFT	Stock	25.925	25.94	25.86	25.868	3260125.0
2011-06-30 13:00:00	MSFT	Stock	25.865	25.89	25.81	25.84	4065205.0
2011-06-30 14:00:00	MSFT	Stock	25.831	25.93	25.83	25.9	4190794.0
2011-06-30 15:00:00	MSFT	Stock	25.905	26.0	25.9	25.98	13217170.0
2011-06-30 16:00:00	MSFT	Stock	26.0	26.002	25.742	25.96	5008898.0
2011-06-30 17:00:00	MSFT	Stock	25.62	25.98	25.62	25.97	6300.0
2011-06-30 18:00:00	MSFT	Stock	25.99	26.0	25.99	26.0	23941.0
2011-06-30 19:00:00	MSFT	Stock	25.99	25.99	25.94	25.94	510.0
2011-06-30 07:00:00	NVDA	Stock	0.3962	0.3962	0.395	0.3955	47600.0
2011-06-30 08:00:00	NVDA	Stock	0.3975	0.3975	0.392	0.392	483360.0
2011-06-30 09:00:00	NVDA	Stock	0.3925	0.4028	0.3885	0.3995	122669440.0
2011-06-30 10:00:00	NVDA	Stock	0.3995	0.401	0.3958	0.3975	143358240.0
2011-06-30 11:00:00	NVDA	Stock	0.3974	0.4018	0.3973	0.4	87561880.0
2011-06-30 12:00:00	NVDA	Stock	0.4003	0.4013	0.398	0.399	47864480.0
2011-06-30 13:00:00	NVDA	Stock	0.3993	0.4	0.3965	0.3982	53088800.0
2011-06-30 14:00:00	NVDA	Stock	0.3982	0.4	0.3978	0.3993	49575800.0
2011-06-30 15:00:00	NVDA	Stock	0.399	0.3998	0.397	0.3985	112769040.0
2011-06-30 16:00:00	NVDA	Stock	0.3988	0.3988	0.3975	0.3975	10743440.0
2011-06-30 18:00:00	NVDA	Stock	0.3985	0.3993	0.3985	0.3993	37840.0
2011-06-30 07:00:00	AMZN	Stock	10.176	10.176	10.1625	10.165	34000.0
2011-06-30 08:00:00	AMZN	Stock	10.1595	10.1625	10.1015	10.155	232140.0
2011-06-30 09:00:00	AMZN	Stock	10.152	10.152	9.9875	10.0775	18971040.0
2011-06-30 10:00:00	AMZN	Stock	10.0775	10.16	10.0775	10.1215	13740140.0
2011-06-30 11:00:00	AMZN	Stock	10.1216	10.26	10.1215	10.2455	13957220.0
2011-06-30 12:00:00	AMZN	Stock	10.245	10.2475	10.1864	10.2298	7757740.0
2011-06-30 13:00:00	AMZN	Stock	10.231	10.2355	10.1725	10.2195	7150980.0
2011-06-30 14:00:00	AMZN	Stock	10.2195	10.2365	10.1995	10.2175	7235560.0
2011-06-30 15:00:00	AMZN	Stock	10.22	10.2425	10.19	10.23	14462020.0
2011-06-30 16:00:00	AMZN	Stock	10.2245	10.2335	10.133	10.225	4972600.0
2011-06-30 17:00:00	AMZN	Stock	10.232	10.232	10.21	10.21	36000.0
2011-06-30 18:00:00	AMZN	Stock	10.2245	10.23	10.2225	10.2295	72860.0
2011-06-30 19:00:00	AMZN	Stock	10.23	10.23	10.23	10.23	4000.0

> showing 50 of 44,700 rows — these rows as CSV

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