PREVIEW / stock_1hour / 2014-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-27.parquet
  size:    1.1 MB
  rows:    49,165
  symbols: 3,528

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
2014-03-27 05:00:00	AAPL	Stock	19.25	19.25	19.25	19.25	12600.0
2014-03-27 07:00:00	AAPL	Stock	19.3129	19.3136	19.28	19.2821	122192.0
2014-03-27 08:00:00	AAPL	Stock	19.3146	19.3146	19.2264	19.2643	835352.0
2014-03-27 09:00:00	AAPL	Stock	19.2696	19.33	19.1607	19.2639	34419056.0
2014-03-27 10:00:00	AAPL	Stock	19.2607	19.3393	19.1907	19.2496	34215608.0
2014-03-27 11:00:00	AAPL	Stock	19.25	19.2679	19.1393	19.1641	20739740.0
2014-03-27 12:00:00	AAPL	Stock	19.1682	19.1961	19.1225	19.1504	19413772.0
2014-03-27 13:00:00	AAPL	Stock	19.1518	19.1993	19.1282	19.1507	15796340.0
2014-03-27 14:00:00	AAPL	Stock	19.1504	19.2386	19.1114	19.1859	21976808.0
2014-03-27 15:00:00	AAPL	Stock	19.1868	19.2311	19.1518	19.1937	27711432.0
2014-03-27 16:00:00	AAPL	Stock	19.195	19.2071	19.1804	19.1911	8135904.0
2014-03-27 17:00:00	AAPL	Stock	19.195	19.2064	19.195	19.195	346444.0
2014-03-27 18:00:00	AAPL	Stock	19.2043	19.2054	19.195	19.2054	248528.0
2014-03-27 19:00:00	AAPL	Stock	19.2068	19.2236	19.2068	19.2236	65100.0
2014-03-27 07:00:00	MSFT	Stock	39.97	39.97	39.81	39.88	9100.0
2014-03-27 08:00:00	MSFT	Stock	39.94	39.94	39.71	39.78	20587.0
2014-03-27 09:00:00	MSFT	Stock	39.79	39.97	39.58	39.875	4340066.0
2014-03-27 10:00:00	MSFT	Stock	39.87	39.88	39.61	39.71	4251512.0
2014-03-27 11:00:00	MSFT	Stock	39.705	39.73	39.4	39.57	3405494.0
2014-03-27 12:00:00	MSFT	Stock	39.58	39.69	39.44	39.608	3101414.0
2014-03-27 13:00:00	MSFT	Stock	39.6	39.745	39.42	39.45	5253073.0
2014-03-27 14:00:00	MSFT	Stock	39.45	39.56	39.36	39.425	3766456.0
2014-03-27 15:00:00	MSFT	Stock	39.42	39.54	39.34	39.36	8000640.0
2014-03-27 16:00:00	MSFT	Stock	39.36	39.569	39.3	39.3	1776842.0
2014-03-27 17:00:00	MSFT	Stock	39.3	39.66	39.26	39.61	166839.0
2014-03-27 18:00:00	MSFT	Stock	39.62	39.64	39.52	39.59	7848.0
2014-03-27 19:00:00	MSFT	Stock	39.56	39.62	39.55	39.55	13560.0
2014-03-27 08:00:00	NVDA	Stock	0.453	0.455	0.4512	0.4512	44000.0
2014-03-27 09:00:00	NVDA	Stock	0.4505	0.4535	0.449	0.4498	46467520.0
2014-03-27 10:00:00	NVDA	Stock	0.4498	0.4512	0.4442	0.4445	93615520.0
2014-03-27 11:00:00	NVDA	Stock	0.4448	0.4455	0.4396	0.4428	62947040.0
2014-03-27 12:00:00	NVDA	Stock	0.4428	0.4438	0.4416	0.4429	71453240.0
2014-03-27 13:00:00	NVDA	Stock	0.4428	0.4438	0.4418	0.4432	52470240.0
2014-03-27 14:00:00	NVDA	Stock	0.4435	0.4468	0.4425	0.4462	107885080.0
2014-03-27 15:00:00	NVDA	Stock	0.4462	0.4465	0.4448	0.4449	84840800.0
2014-03-27 16:00:00	NVDA	Stock	0.4448	0.4458	0.4446	0.4446	12263560.0
2014-03-27 17:00:00	NVDA	Stock	0.445	0.445	0.4448	0.4448	2719360.0
2014-03-27 19:00:00	NVDA	Stock	0.443	0.443	0.443	0.443	8000.0
2014-03-27 05:00:00	AMZN	Stock	17.1245	17.1245	17.1235	17.1235	4000.0
2014-03-27 07:00:00	AMZN	Stock	17.1895	17.2845	17.18	17.18	52280.0
2014-03-27 08:00:00	AMZN	Stock	17.19	17.1945	17.09	17.1025	263020.0
2014-03-27 09:00:00	AMZN	Stock	17.1025	17.2	16.544	16.9495	27935760.0
2014-03-27 10:00:00	AMZN	Stock	16.9275	17.1995	16.8745	16.975	17959960.0
2014-03-27 11:00:00	AMZN	Stock	16.9845	17.0405	16.6575	16.805	19003300.0
2014-03-27 12:00:00	AMZN	Stock	16.8078	17.0585	16.739	16.9635	11273880.0
2014-03-27 13:00:00	AMZN	Stock	16.9595	17.0687	16.9405	16.9813	5996200.0
2014-03-27 14:00:00	AMZN	Stock	16.9915	17.05	16.908	16.923	4607080.0
2014-03-27 15:00:00	AMZN	Stock	16.931	16.9545	16.76	16.921	17551040.0
2014-03-27 16:00:00	AMZN	Stock	16.9235	17.1705	16.8749	16.9945	627480.0
2014-03-27 17:00:00	AMZN	Stock	16.95	16.9875	16.9234	16.9235	91480.0

> showing 50 of 49,165 rows — these rows as CSV

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