PREVIEW / stock_1hour / 2011-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-16.parquet
  size:    929 KB
  rows:    44,156
  symbols: 3,509

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-08-16 04:00:00	AAPL	Stock	13.5539	13.5775	13.5536	13.5775	14000.0
2011-08-16 05:00:00	AAPL	Stock	13.5832	13.5832	13.5832	13.5832	2800.0
2011-08-16 06:00:00	AAPL	Stock	13.5714	13.5936	13.5714	13.5714	22400.0
2011-08-16 07:00:00	AAPL	Stock	13.5707	13.6071	13.5643	13.5804	519232.0
2011-08-16 08:00:00	AAPL	Stock	13.5804	13.5961	13.52	13.585	3347148.0
2011-08-16 09:00:00	AAPL	Stock	13.5832	13.6579	13.5729	13.6054	64790180.0
2011-08-16 10:00:00	AAPL	Stock	13.6014	13.6764	13.5764	13.6746	79598960.0
2011-08-16 11:00:00	AAPL	Stock	13.6739	13.6786	13.6286	13.6525	36071084.0
2011-08-16 12:00:00	AAPL	Stock	13.6525	13.6918	13.5246	13.5246	79261196.0
2011-08-16 13:00:00	AAPL	Stock	13.5229	13.5714	13.4307	13.5543	92796312.0
2011-08-16 14:00:00	AAPL	Stock	13.5561	13.5871	13.4875	13.5	50611092.0
2011-08-16 15:00:00	AAPL	Stock	13.4989	13.6343	13.4907	13.5857	75065116.0
2011-08-16 16:00:00	AAPL	Stock	13.5857	13.6006	13.5425	13.5821	14651364.0
2011-08-16 17:00:00	AAPL	Stock	13.5886	13.5886	13.5746	13.5746	257376.0
2011-08-16 18:00:00	AAPL	Stock	13.5768	13.5886	13.5554	13.5643	252672.0
2011-08-16 19:00:00	AAPL	Stock	13.5643	13.5714	13.5357	13.5607	129248.0
2011-08-16 04:00:00	MSFT	Stock	25.11	25.17	25.11	25.14	5400.0
2011-08-16 05:00:00	MSFT	Stock	25.17	25.17	25.13	25.13	2100.0
2011-08-16 07:00:00	MSFT	Stock	25.08	25.14	25.08	25.08	35000.0
2011-08-16 08:00:00	MSFT	Stock	25.09	25.18	25.08	25.12	32651.0
2011-08-16 09:00:00	MSFT	Stock	25.11	25.47	25.11	25.4	5171047.0
2011-08-16 10:00:00	MSFT	Stock	25.4	25.59	25.38	25.56	8703410.0
2011-08-16 11:00:00	MSFT	Stock	25.56	25.56	25.41	25.45	6598789.0
2011-08-16 12:00:00	MSFT	Stock	25.45	25.53	25.23	25.25	10617681.0
2011-08-16 13:00:00	MSFT	Stock	25.25	25.27	25.05	25.2	5695678.0
2011-08-16 14:00:00	MSFT	Stock	25.2	25.3	25.18	25.21	4019717.0
2011-08-16 15:00:00	MSFT	Stock	25.2	25.5	25.19	25.36	9399860.0
2011-08-16 16:00:00	MSFT	Stock	25.35	25.472	25.0	25.3	2765712.0
2011-08-16 17:00:00	MSFT	Stock	25.35	25.35	25.2	25.2	25626.0
2011-08-16 18:00:00	MSFT	Stock	25.2	25.35	25.16	25.25	53049.0
2011-08-16 19:00:00	MSFT	Stock	25.25	25.25	25.25	25.25	300.0
2011-08-16 07:00:00	NVDA	Stock	0.329	0.329	0.329	0.329	80000.0
2011-08-16 08:00:00	NVDA	Stock	0.332	0.332	0.3245	0.328	579800.0
2011-08-16 09:00:00	NVDA	Stock	0.3268	0.3333	0.3263	0.33	78472320.0
2011-08-16 10:00:00	NVDA	Stock	0.33	0.335	0.3283	0.3335	113447600.0
2011-08-16 11:00:00	NVDA	Stock	0.3335	0.3336	0.3295	0.3307	70966200.0
2011-08-16 12:00:00	NVDA	Stock	0.3305	0.3335	0.3215	0.3218	147781080.0
2011-08-16 13:00:00	NVDA	Stock	0.3218	0.3238	0.3188	0.3228	90378760.0
2011-08-16 14:00:00	NVDA	Stock	0.3228	0.3253	0.3208	0.3213	84575440.0
2011-08-16 15:00:00	NVDA	Stock	0.321	0.3273	0.321	0.3246	111307680.0
2011-08-16 16:00:00	NVDA	Stock	0.3245	0.3272	0.3245	0.3245	18053560.0
2011-08-16 17:00:00	NVDA	Stock	0.324	0.3245	0.324	0.3245	213040.0
2011-08-16 18:00:00	NVDA	Stock	0.3248	0.3248	0.3238	0.3238	207000.0
2011-08-16 19:00:00	NVDA	Stock	0.3233	0.3233	0.3213	0.3218	298400.0
2011-08-16 04:00:00	AMZN	Stock	10.1035	10.1035	10.0375	10.0375	4000.0
2011-08-16 07:00:00	AMZN	Stock	10.0375	10.0375	10.0125	10.0295	18000.0
2011-08-16 08:00:00	AMZN	Stock	10.01	10.03	9.9985	10.025	317020.0
2011-08-16 09:00:00	AMZN	Stock	10.025	10.0695	9.894	9.939	15481760.0
2011-08-16 10:00:00	AMZN	Stock	9.9439	10.0235	9.912	10.018	14247940.0
2011-08-16 11:00:00	AMZN	Stock	10.0185	10.022	9.914	9.95	10530560.0

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

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