PREVIEW / stock_1hour / 2011-02-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-23.parquet
  size:    970 KB
  rows:    46,368
  symbols: 3,538

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-02-23 04:00:00	AAPL	Stock	12.0964	12.0964	12.0964	12.0964	28000.0
2011-02-23 05:00:00	AAPL	Stock	12.0986	12.1139	12.0986	12.1082	8400.0
2011-02-23 06:00:00	AAPL	Stock	12.1021	12.1604	12.1	12.1604	61320.0
2011-02-23 07:00:00	AAPL	Stock	12.1696	12.2307	12.1696	12.2014	815024.0
2011-02-23 08:00:00	AAPL	Stock	12.2018	12.2096	12.1429	12.1786	3793888.0
2011-02-23 09:00:00	AAPL	Stock	12.1793	12.2475	12.0932	12.1461	97818700.0
2011-02-23 10:00:00	AAPL	Stock	12.1461	12.2214	12.1114	12.1968	99173368.0
2011-02-23 11:00:00	AAPL	Stock	12.1964	12.2757	12.1804	12.1854	112112588.0
2011-02-23 12:00:00	AAPL	Stock	12.1855	12.1882	12.1211	12.1761	75867260.0
2011-02-23 13:00:00	AAPL	Stock	12.1761	12.1871	12.1082	12.1714	67548656.0
2011-02-23 14:00:00	AAPL	Stock	12.1718	12.26	12.1704	12.2577	65941260.0
2011-02-23 15:00:00	AAPL	Stock	12.2571	12.3086	12.2357	12.2364	109777668.0
2011-02-23 16:00:00	AAPL	Stock	12.24	12.2943	12.0905	12.2429	13196176.0
2011-02-23 17:00:00	AAPL	Stock	12.2411	12.2479	12.2364	12.2464	845628.0
2011-02-23 18:00:00	AAPL	Stock	12.2471	12.2675	12.2364	12.2589	499828.0
2011-02-23 19:00:00	AAPL	Stock	12.2639	12.2714	12.2611	12.2679	280280.0
2011-02-23 04:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	400.0
2011-02-23 07:00:00	MSFT	Stock	26.6	26.67	26.6	26.67	3400.0
2011-02-23 08:00:00	MSFT	Stock	26.63	26.65	26.58	26.62	30348.0
2011-02-23 09:00:00	MSFT	Stock	26.62	26.86	26.5	26.52	7209371.0
2011-02-23 10:00:00	MSFT	Stock	26.52	26.705	26.51	26.655	7405593.0
2011-02-23 11:00:00	MSFT	Stock	26.65	26.665	26.43	26.55	5860556.0
2011-02-23 12:00:00	MSFT	Stock	26.55	26.71	26.505	26.698	7571917.0
2011-02-23 13:00:00	MSFT	Stock	26.69	26.74	26.56	26.66	5822482.0
2011-02-23 14:00:00	MSFT	Stock	26.66	26.74	26.57	26.659	6013730.0
2011-02-23 15:00:00	MSFT	Stock	26.65	26.71	26.585	26.59	9894250.0
2011-02-23 16:00:00	MSFT	Stock	26.59	26.667	26.587	26.61	3206652.0
2011-02-23 17:00:00	MSFT	Stock	26.62	26.64	26.59	26.6	6657525.0
2011-02-23 18:00:00	MSFT	Stock	26.61	26.61	26.59	26.61	16199.0
2011-02-23 19:00:00	MSFT	Stock	26.61	26.61	26.57	26.57	6435.0
2011-02-23 07:00:00	NVDA	Stock	0.5848	0.5895	0.5848	0.5888	503400.0
2011-02-23 08:00:00	NVDA	Stock	0.5888	0.59	0.585	0.5855	1775800.0
2011-02-23 09:00:00	NVDA	Stock	0.5865	0.5865	0.5668	0.568	169502520.0
2011-02-23 10:00:00	NVDA	Stock	0.5685	0.572	0.5588	0.5685	359439280.0
2011-02-23 11:00:00	NVDA	Stock	0.5685	0.5698	0.5595	0.5595	146566600.0
2011-02-23 12:00:00	NVDA	Stock	0.5595	0.5595	0.5502	0.5512	171205880.0
2011-02-23 13:00:00	NVDA	Stock	0.5512	0.5528	0.5445	0.5522	195477560.0
2011-02-23 14:00:00	NVDA	Stock	0.5522	0.5585	0.5495	0.5585	164745040.0
2011-02-23 15:00:00	NVDA	Stock	0.5585	0.5612	0.5525	0.5528	258881320.0
2011-02-23 16:00:00	NVDA	Stock	0.5532	0.5802	0.5512	0.5512	4919440.0
2011-02-23 17:00:00	NVDA	Stock	0.552	0.5552	0.552	0.5552	1128760.0
2011-02-23 18:00:00	NVDA	Stock	0.554	0.5558	0.5532	0.555	422000.0
2011-02-23 19:00:00	NVDA	Stock	0.5548	0.5558	0.554	0.5545	252920.0
2011-02-23 07:00:00	AMZN	Stock	9.05	9.05	9.05	9.05	2000.0
2011-02-23 08:00:00	AMZN	Stock	9.0275	9.095	9.0005	9.045	123200.0
2011-02-23 09:00:00	AMZN	Stock	9.0475	9.0575	8.9366	8.962	13671680.0
2011-02-23 10:00:00	AMZN	Stock	8.9685	8.9775	8.851	8.87	17482100.0
2011-02-23 11:00:00	AMZN	Stock	8.8725	8.885	8.7635	8.7768	18027140.0
2011-02-23 12:00:00	AMZN	Stock	8.7804	8.7815	8.7195	8.7474	15218080.0
2011-02-23 13:00:00	AMZN	Stock	8.7475	8.843	8.732	8.825	10604660.0

> showing 50 of 46,368 rows — these rows as CSV

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