PREVIEW / stock_1hour / 2011-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-18.parquet
  size:    951 KB
  rows:    45,564
  symbols: 3,532

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-04-18 04:00:00	AAPL	Stock	11.7143	11.7143	11.6964	11.6964	11200.0
2011-04-18 06:00:00	AAPL	Stock	11.6964	11.6964	11.6521	11.6521	14000.0
2011-04-18 07:00:00	AAPL	Stock	11.6796	11.7421	11.6796	11.7268	299124.0
2011-04-18 08:00:00	AAPL	Stock	11.725	11.7675	11.7179	11.7375	1520204.0
2011-04-18 09:00:00	AAPL	Stock	11.7379	11.7429	11.4432	11.4929	153057016.0
2011-04-18 10:00:00	AAPL	Stock	11.4907	11.5143	11.4343	11.4636	117118204.0
2011-04-18 11:00:00	AAPL	Stock	11.4629	11.5839	11.4464	11.5786	67965772.0
2011-04-18 12:00:00	AAPL	Stock	11.5789	11.6064	11.5568	11.5857	41449436.0
2011-04-18 13:00:00	AAPL	Stock	11.5885	11.6464	11.5486	11.6382	39710104.0
2011-04-18 14:00:00	AAPL	Stock	11.6386	11.7607	11.6171	11.7354	66502492.0
2011-04-18 15:00:00	AAPL	Stock	11.7354	11.8654	11.6964	11.8518	106429512.0
2011-04-18 16:00:00	AAPL	Stock	11.8518	11.86	11.4821	11.8318	8074976.0
2011-04-18 17:00:00	AAPL	Stock	11.8321	11.8357	11.825	11.8321	370104.0
2011-04-18 18:00:00	AAPL	Stock	11.8321	11.8518	11.8321	11.8393	258552.0
2011-04-18 19:00:00	AAPL	Stock	11.8332	11.8429	11.8161	11.8339	469140.0
2011-04-18 04:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	200.0
2011-04-18 07:00:00	MSFT	Stock	25.35	25.35	25.26	25.32	2500.0
2011-04-18 08:00:00	MSFT	Stock	25.31	25.32	25.27	25.3	15512.0
2011-04-18 09:00:00	MSFT	Stock	25.3	25.3	25.01	25.025	6287942.0
2011-04-18 10:00:00	MSFT	Stock	25.02	25.03	24.72	24.84	18703943.0
2011-04-18 11:00:00	MSFT	Stock	24.845	24.96	24.82	24.891	4277509.0
2011-04-18 12:00:00	MSFT	Stock	24.895	25.03	24.89	25.03	3879817.0
2011-04-18 13:00:00	MSFT	Stock	25.03	25.28	24.97	25.28	6677210.0
2011-04-18 14:00:00	MSFT	Stock	25.27	25.28	25.12	25.2	4624383.0
2011-04-18 15:00:00	MSFT	Stock	25.2	25.23	25.07	25.09	9642380.0
2011-04-18 16:00:00	MSFT	Stock	25.09	25.38	24.74	25.08	2960642.0
2011-04-18 17:00:00	MSFT	Stock	25.08	25.08	25.03	25.03	5400.0
2011-04-18 18:00:00	MSFT	Stock	25.08	25.13	25.01	25.03	10813.0
2011-04-18 19:00:00	MSFT	Stock	25.03	25.08	25.03	25.08	1200.0
2011-04-18 08:00:00	NVDA	Stock	0.4638	0.464	0.4633	0.4638	368000.0
2011-04-18 09:00:00	NVDA	Stock	0.4635	0.4638	0.4532	0.4545	115700800.0
2011-04-18 10:00:00	NVDA	Stock	0.4544	0.4544	0.445	0.4475	212103960.0
2011-04-18 11:00:00	NVDA	Stock	0.4472	0.453	0.4468	0.451	106629760.0
2011-04-18 12:00:00	NVDA	Stock	0.451	0.4525	0.4492	0.4512	57580800.0
2011-04-18 13:00:00	NVDA	Stock	0.451	0.4522	0.4484	0.4522	49616280.0
2011-04-18 14:00:00	NVDA	Stock	0.452	0.455	0.4508	0.4532	68502240.0
2011-04-18 15:00:00	NVDA	Stock	0.4532	0.455	0.4505	0.4522	118443960.0
2011-04-18 16:00:00	NVDA	Stock	0.4518	0.4542	0.45	0.4502	5556040.0
2011-04-18 17:00:00	NVDA	Stock	0.4512	0.4548	0.451	0.4548	568000.0
2011-04-18 18:00:00	NVDA	Stock	0.4538	0.454	0.4512	0.4512	357200.0
2011-04-18 06:00:00	AMZN	Stock	8.959	8.959	8.934	8.934	4000.0
2011-04-18 07:00:00	AMZN	Stock	8.933	8.933	8.933	8.933	2000.0
2011-04-18 08:00:00	AMZN	Stock	8.9735	8.9745	8.9455	8.9745	68940.0
2011-04-18 09:00:00	AMZN	Stock	8.972	8.972	8.8345	8.838	20157380.0
2011-04-18 10:00:00	AMZN	Stock	8.836	8.9165	8.7685	8.831	24278620.0
2011-04-18 11:00:00	AMZN	Stock	8.8325	8.88	8.8125	8.8632	9178940.0
2011-04-18 12:00:00	AMZN	Stock	8.864	8.867	8.83	8.8315	6473020.0
2011-04-18 13:00:00	AMZN	Stock	8.832	8.867	8.8	8.8605	6245580.0
2011-04-18 14:00:00	AMZN	Stock	8.8595	8.904	8.842	8.892	7285520.0
2011-04-18 15:00:00	AMZN	Stock	8.892	8.929	8.8645	8.9175	14033020.0

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

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