PREVIEW / stock_1hour / 2011-06-17

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-17.parquet
  size:    972 KB
  rows:    45,711
  symbols: 3,578

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-06-17 06:00:00	AAPL	Stock	11.65	11.7057	11.65	11.695	103600.0
2011-06-17 07:00:00	AAPL	Stock	11.6946	11.7379	11.6946	11.7321	509460.0
2011-06-17 08:00:00	AAPL	Stock	11.73	11.73	11.6879	11.7096	1528324.0
2011-06-17 09:00:00	AAPL	Stock	11.7107	11.7589	11.577	11.5786	73774372.0
2011-06-17 10:00:00	AAPL	Stock	11.5791	11.6106	11.445	11.5221	128391536.0
2011-06-17 11:00:00	AAPL	Stock	11.5214	11.555	11.4911	11.5236	54771192.0
2011-06-17 12:00:00	AAPL	Stock	11.5236	11.5479	11.4493	11.4575	52643920.0
2011-06-17 13:00:00	AAPL	Stock	11.4579	11.4975	11.4286	11.4679	54007100.0
2011-06-17 14:00:00	AAPL	Stock	11.4682	11.4907	11.4464	11.4686	40904080.0
2011-06-17 15:00:00	AAPL	Stock	11.4707	11.4771	11.4057	11.4396	107842812.0
2011-06-17 16:00:00	AAPL	Stock	11.4368	11.4946	11.4254	11.4286	46708648.0
2011-06-17 17:00:00	AAPL	Stock	11.4289	11.4321	11.4232	11.4321	298788.0
2011-06-17 18:00:00	AAPL	Stock	11.4336	11.4429	11.4296	11.4393	297024.0
2011-06-17 19:00:00	AAPL	Stock	11.4325	11.4332	11.4218	11.4321	200760.0
2011-06-17 04:00:00	MSFT	Stock	23.96	23.96	23.96	23.96	500.0
2011-06-17 06:00:00	MSFT	Stock	24.05	24.1	24.05	24.1	1000.0
2011-06-17 07:00:00	MSFT	Stock	24.14	24.15	24.06	24.15	5150.0
2011-06-17 08:00:00	MSFT	Stock	24.14	24.15	24.08	24.13	34821.0
2011-06-17 09:00:00	MSFT	Stock	24.12	24.3	24.1	24.25	5685128.0
2011-06-17 10:00:00	MSFT	Stock	24.25	24.28	24.07	24.07	7999455.0
2011-06-17 11:00:00	MSFT	Stock	24.07	24.11	23.98	24.04	4816852.0
2011-06-17 12:00:00	MSFT	Stock	24.04	24.18	24.04	24.11	5761354.0
2011-06-17 13:00:00	MSFT	Stock	24.115	24.2	24.08	24.135	6082059.0
2011-06-17 14:00:00	MSFT	Stock	24.135	24.27	24.13	24.21	6729656.0
2011-06-17 15:00:00	MSFT	Stock	24.21	24.29	24.07	24.26	19464674.0
2011-06-17 16:00:00	MSFT	Stock	24.26	24.28	24.168	24.23	11315169.0
2011-06-17 17:00:00	MSFT	Stock	24.271	24.271	24.23	24.23	3575.0
2011-06-17 18:00:00	MSFT	Stock	24.26	24.26	24.24	24.24	29174.0
2011-06-17 19:00:00	MSFT	Stock	24.24	24.3	24.24	24.28	3393.0
2011-06-17 05:00:00	NVDA	Stock	0.3978	0.3978	0.3978	0.3978	4000.0
2011-06-17 07:00:00	NVDA	Stock	0.408	0.4102	0.408	0.4102	112000.0
2011-06-17 08:00:00	NVDA	Stock	0.408	0.4095	0.407	0.409	226840.0
2011-06-17 09:00:00	NVDA	Stock	0.4088	0.4098	0.396	0.396	182531960.0
2011-06-17 10:00:00	NVDA	Stock	0.3962	0.3975	0.3828	0.3898	406287280.0
2011-06-17 11:00:00	NVDA	Stock	0.3898	0.3975	0.3898	0.3973	139907880.0
2011-06-17 12:00:00	NVDA	Stock	0.3973	0.402	0.3973	0.4003	154452800.0
2011-06-17 13:00:00	NVDA	Stock	0.4005	0.402	0.3975	0.3998	98631320.0
2011-06-17 14:00:00	NVDA	Stock	0.3998	0.4	0.3965	0.3984	106062240.0
2011-06-17 15:00:00	NVDA	Stock	0.3982	0.399	0.395	0.3954	203556080.0
2011-06-17 16:00:00	NVDA	Stock	0.3958	0.398	0.3953	0.3968	69778360.0
2011-06-17 17:00:00	NVDA	Stock	0.3955	0.3965	0.395	0.395	64080.0
2011-06-17 18:00:00	NVDA	Stock	0.395	0.3965	0.395	0.3965	18000.0
2011-06-17 19:00:00	NVDA	Stock	0.3962	0.3975	0.3962	0.3975	84040.0
2011-06-17 07:00:00	AMZN	Stock	9.315	9.315	9.315	9.315	2000.0
2011-06-17 08:00:00	AMZN	Stock	9.2525	9.3025	9.2525	9.3	188540.0
2011-06-17 09:00:00	AMZN	Stock	9.289	9.3695	9.2725	9.301	35332800.0
2011-06-17 10:00:00	AMZN	Stock	9.307	9.3625	9.232	9.287	25058480.0
2011-06-17 11:00:00	AMZN	Stock	9.287	9.3565	9.2495	9.3525	13369000.0
2011-06-17 12:00:00	AMZN	Stock	9.352	9.356	9.2755	9.2995	7704840.0
2011-06-17 13:00:00	AMZN	Stock	9.2956	9.3245	9.27	9.2895	7776920.0

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

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