PREVIEW / stock_1hour / 2012-12-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-10.parquet
  size:    939 KB
  rows:    44,383
  symbols: 3,504

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
2012-12-10 04:00:00	AAPL	Stock	19.1071	19.1071	19.0607	19.0607	37184.0
2012-12-10 05:00:00	AAPL	Stock	19.0193	19.0314	18.9696	18.9696	43400.0
2012-12-10 06:00:00	AAPL	Stock	18.9696	18.9821	18.9375	18.9643	89600.0
2012-12-10 07:00:00	AAPL	Stock	18.9571	18.9943	18.875	18.9554	840056.0
2012-12-10 08:00:00	AAPL	Stock	18.9643	18.9964	18.7607	18.8161	5535964.0
2012-12-10 09:00:00	AAPL	Stock	18.8282	19.0486	18.6279	18.8979	139592236.0
2012-12-10 10:00:00	AAPL	Stock	18.9029	19.1914	18.7975	19.1818	115439016.0
2012-12-10 11:00:00	AAPL	Stock	19.1736	19.2325	18.9825	19.0107	81048884.0
2012-12-10 12:00:00	AAPL	Stock	19.0095	19.0954	18.8679	18.9143	57657740.0
2012-12-10 13:00:00	AAPL	Stock	18.9157	18.9643	18.8071	18.88	48624128.0
2012-12-10 14:00:00	AAPL	Stock	18.88	19.0889	18.84	19.0654	63047292.0
2012-12-10 15:00:00	AAPL	Stock	19.0661	19.0714	18.8957	18.9196	73665060.0
2012-12-10 16:00:00	AAPL	Stock	18.9211	19.0894	18.8986	18.9464	29077636.0
2012-12-10 17:00:00	AAPL	Stock	18.9464	18.9643	18.9221	18.9643	366212.0
2012-12-10 18:00:00	AAPL	Stock	18.9539	18.9661	18.9504	18.9661	65268.0
2012-12-10 19:00:00	AAPL	Stock	18.965	18.9657	18.9464	18.9632	246176.0
2012-12-10 04:00:00	MSFT	Stock	26.36	26.4	26.36	26.4	1200.0
2012-12-10 07:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	2500.0
2012-12-10 08:00:00	MSFT	Stock	26.41	26.48	26.32	26.48	19750.0
2012-12-10 09:00:00	MSFT	Stock	26.45	26.81	26.45	26.805	5934462.0
2012-12-10 10:00:00	MSFT	Stock	26.81	26.95	26.785	26.94	9263206.0
2012-12-10 11:00:00	MSFT	Stock	26.95	26.97	26.88	26.92	5596948.0
2012-12-10 12:00:00	MSFT	Stock	26.915	26.92	26.87	26.91	3144255.0
2012-12-10 13:00:00	MSFT	Stock	26.91	26.92	26.75	26.86	3965972.0
2012-12-10 14:00:00	MSFT	Stock	26.865	26.9	26.75	26.815	4344266.0
2012-12-10 15:00:00	MSFT	Stock	26.815	26.97	26.8	26.92	10843981.0
2012-12-10 16:00:00	MSFT	Stock	26.92	26.96	26.801	26.95	2289539.0
2012-12-10 17:00:00	MSFT	Stock	26.94	26.94	26.93	26.94	108205.0
2012-12-10 18:00:00	MSFT	Stock	26.94	26.97	26.94	26.95	3392.0
2012-12-10 19:00:00	MSFT	Stock	26.97	26.97	26.94	26.94	3865.0
2012-12-10 04:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	4000.0
2012-12-10 09:00:00	NVDA	Stock	0.2992	0.3025	0.2982	0.302	36218240.0
2012-12-10 10:00:00	NVDA	Stock	0.302	0.3058	0.3012	0.3055	61345800.0
2012-12-10 11:00:00	NVDA	Stock	0.3055	0.3055	0.3042	0.3045	37326560.0
2012-12-10 12:00:00	NVDA	Stock	0.3046	0.3085	0.3045	0.3078	114586200.0
2012-12-10 13:00:00	NVDA	Stock	0.3078	0.309	0.3065	0.3086	60279480.0
2012-12-10 14:00:00	NVDA	Stock	0.3085	0.3098	0.3078	0.3095	68160480.0
2012-12-10 15:00:00	NVDA	Stock	0.3094	0.3113	0.309	0.3091	112061880.0
2012-12-10 16:00:00	NVDA	Stock	0.3093	0.31	0.307	0.31	21322000.0
2012-12-10 17:00:00	NVDA	Stock	0.309	0.309	0.3088	0.3088	22000.0
2012-12-10 18:00:00	NVDA	Stock	0.309	0.309	0.309	0.309	24000.0
2012-12-10 19:00:00	NVDA	Stock	0.309	0.309	0.309	0.309	4000.0
2012-12-10 08:00:00	AMZN	Stock	12.6145	12.6555	12.6145	12.64	286900.0
2012-12-10 09:00:00	AMZN	Stock	12.645	12.739	12.597	12.661	8702820.0
2012-12-10 10:00:00	AMZN	Stock	12.6625	12.6725	12.5415	12.5975	12837360.0
2012-12-10 11:00:00	AMZN	Stock	12.595	12.6125	12.526	12.529	7971560.0
2012-12-10 12:00:00	AMZN	Stock	12.529	12.5325	12.4615	12.4825	5937680.0
2012-12-10 13:00:00	AMZN	Stock	12.482	12.495	12.4705	12.473	3890960.0
2012-12-10 14:00:00	AMZN	Stock	12.473	12.4746	12.3855	12.4125	11212000.0
2012-12-10 15:00:00	AMZN	Stock	12.4122	12.43	12.365	12.3875	15174400.0

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

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