PREVIEW / stock_1hour / 2011-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-21.parquet
  size:    957 KB
  rows:    45,746
  symbols: 3,526

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-01-21 04:00:00	AAPL	Stock	11.9118	11.9118	11.9064	11.9064	11200.0
2011-01-21 05:00:00	AAPL	Stock	11.9064	11.9536	11.9064	11.9429	22400.0
2011-01-21 06:00:00	AAPL	Stock	11.9429	11.9536	11.9429	11.9536	35000.0
2011-01-21 07:00:00	AAPL	Stock	11.9507	11.9507	11.9286	11.9464	537964.0
2011-01-21 08:00:00	AAPL	Stock	11.9429	11.9993	11.9329	11.9643	4548432.0
2011-01-21 09:00:00	AAPL	Stock	11.9643	11.9711	11.8954	11.9246	129687040.0
2011-01-21 10:00:00	AAPL	Stock	11.9236	11.94	11.815	11.8282	115687740.0
2011-01-21 11:00:00	AAPL	Stock	11.8282	11.8493	11.7643	11.7982	88890480.0
2011-01-21 12:00:00	AAPL	Stock	11.7986	11.8153	11.7093	11.7321	86054780.0
2011-01-21 13:00:00	AAPL	Stock	11.7321	11.7368	11.69	11.7316	78232364.0
2011-01-21 14:00:00	AAPL	Stock	11.7318	11.7982	11.7186	11.7786	86674560.0
2011-01-21 15:00:00	AAPL	Stock	11.7796	11.7829	11.6654	11.6686	140855456.0
2011-01-21 16:00:00	AAPL	Stock	11.6664	11.9646	11.6557	11.665	11832716.0
2011-01-21 17:00:00	AAPL	Stock	11.6654	11.6693	11.6571	11.6664	1339576.0
2011-01-21 18:00:00	AAPL	Stock	11.6668	11.6686	11.6525	11.6525	639128.0
2011-01-21 19:00:00	AAPL	Stock	11.6521	11.6589	11.65	11.6579	285012.0
2011-01-21 06:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	1800.0
2011-01-21 07:00:00	MSFT	Stock	28.33	28.33	28.33	28.33	100.0
2011-01-21 08:00:00	MSFT	Stock	28.4	28.41	28.33	28.41	9584.0
2011-01-21 09:00:00	MSFT	Stock	28.43	28.54	28.16	28.25	11888796.0
2011-01-21 10:00:00	MSFT	Stock	28.25	28.26	28.11	28.14	7971746.0
2011-01-21 11:00:00	MSFT	Stock	28.14	28.25	28.08	28.16	6889728.0
2011-01-21 12:00:00	MSFT	Stock	28.16	28.25	28.1	28.1	5550970.0
2011-01-21 13:00:00	MSFT	Stock	28.1	28.16	28.08	28.1	4783029.0
2011-01-21 14:00:00	MSFT	Stock	28.1	28.135	28.06	28.093	6010199.0
2011-01-21 15:00:00	MSFT	Stock	28.095	28.13	28.02	28.03	9976209.0
2011-01-21 16:00:00	MSFT	Stock	28.025	28.243	27.96	28.0	2364203.0
2011-01-21 17:00:00	MSFT	Stock	28.0	28.33	28.0	28.0	5858.0
2011-01-21 18:00:00	MSFT	Stock	28.01	28.03	28.0	28.02	27281.0
2011-01-21 19:00:00	MSFT	Stock	28.01	28.02	27.99	28.02	24358.0
2011-01-21 06:00:00	NVDA	Stock	0.5602	0.5602	0.5602	0.5602	7960.0
2011-01-21 07:00:00	NVDA	Stock	0.5605	0.565	0.5605	0.565	68000.0
2011-01-21 08:00:00	NVDA	Stock	0.5652	0.57	0.5625	0.57	1301920.0
2011-01-21 09:00:00	NVDA	Stock	0.57	0.5735	0.5628	0.5715	127372360.0
2011-01-21 10:00:00	NVDA	Stock	0.5715	0.5748	0.5642	0.5648	132171920.0
2011-01-21 11:00:00	NVDA	Stock	0.5648	0.5655	0.5555	0.557	145244560.0
2011-01-21 12:00:00	NVDA	Stock	0.5572	0.563	0.5565	0.5629	101037600.0
2011-01-21 13:00:00	NVDA	Stock	0.5628	0.5632	0.5592	0.5618	43618800.0
2011-01-21 14:00:00	NVDA	Stock	0.5618	0.5618	0.5575	0.5582	46709120.0
2011-01-21 15:00:00	NVDA	Stock	0.5582	0.5595	0.5545	0.5552	122420960.0
2011-01-21 16:00:00	NVDA	Stock	0.5555	0.5632	0.5525	0.5555	11673960.0
2011-01-21 17:00:00	NVDA	Stock	0.5562	0.5562	0.5562	0.5562	160000.0
2011-01-21 18:00:00	NVDA	Stock	0.5535	0.5535	0.5535	0.5535	4000.0
2011-01-21 19:00:00	NVDA	Stock	0.5538	0.5548	0.5535	0.554	181600.0
2011-01-21 04:00:00	AMZN	Stock	9.0785	9.105	9.075	9.105	6000.0
2011-01-21 07:00:00	AMZN	Stock	9.1585	9.166	9.1585	9.166	8000.0
2011-01-21 08:00:00	AMZN	Stock	9.166	9.2125	9.138	9.2	628340.0
2011-01-21 09:00:00	AMZN	Stock	9.205	9.218	9.042	9.074	26908980.0
2011-01-21 10:00:00	AMZN	Stock	9.0745	9.11	9.044	9.062	16833440.0
2011-01-21 11:00:00	AMZN	Stock	9.063	9.0684	8.9775	8.996	12742980.0

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

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