PREVIEW / stock_1hour / 2011-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-07.parquet
  size:    930 KB
  rows:    43,639
  symbols: 3,512

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-04-07 06:00:00	AAPL	Stock	12.0857	12.0932	12.0857	12.0932	16800.0
2011-04-07 07:00:00	AAPL	Stock	12.0775	12.1171	12.0771	12.1125	390376.0
2011-04-07 08:00:00	AAPL	Stock	12.1111	12.1339	12.0879	12.0946	1275148.0
2011-04-07 09:00:00	AAPL	Stock	12.0989	12.1582	12.0454	12.1511	65586360.0
2011-04-07 10:00:00	AAPL	Stock	12.1504	12.1575	12.0011	12.0568	89070016.0
2011-04-07 11:00:00	AAPL	Stock	12.0582	12.0929	12.0179	12.0557	59003336.0
2011-04-07 12:00:00	AAPL	Stock	12.0566	12.1046	12.0411	12.1021	31419920.0
2011-04-07 13:00:00	AAPL	Stock	12.1004	12.1025	12.0357	12.0493	25532164.0
2011-04-07 14:00:00	AAPL	Stock	12.05	12.0679	12.0225	12.0461	29423660.0
2011-04-07 15:00:00	AAPL	Stock	12.0457	12.0786	12.0214	12.0743	52799152.0
2011-04-07 16:00:00	AAPL	Stock	12.0743	12.0781	12.0524	12.0661	14202468.0
2011-04-07 17:00:00	AAPL	Stock	12.0657	12.0729	12.0657	12.0718	75152.0
2011-04-07 18:00:00	AAPL	Stock	12.0729	12.0743	12.0682	12.0682	184128.0
2011-04-07 19:00:00	AAPL	Stock	12.0711	12.0714	12.0571	12.0661	131768.0
2011-04-07 06:00:00	MSFT	Stock	26.3	26.3	26.28	26.29	2000.0
2011-04-07 07:00:00	MSFT	Stock	26.2	26.24	26.16	26.2	16350.0
2011-04-07 08:00:00	MSFT	Stock	26.2	26.25	26.17	26.21	44114.0
2011-04-07 09:00:00	MSFT	Stock	26.21	26.26	26.13	26.22	6186293.0
2011-04-07 10:00:00	MSFT	Stock	26.224	26.25	25.97	26.13	10477457.0
2011-04-07 11:00:00	MSFT	Stock	26.13	26.17	25.97	26.01	7263391.0
2011-04-07 12:00:00	MSFT	Stock	26.01	26.25	25.99	26.2	4294895.0
2011-04-07 13:00:00	MSFT	Stock	26.2	26.22	26.11	26.19	4713841.0
2011-04-07 14:00:00	MSFT	Stock	26.19	26.2	26.07	26.2	3958322.0
2011-04-07 15:00:00	MSFT	Stock	26.2	26.2	26.11	26.19	6157135.0
2011-04-07 16:00:00	MSFT	Stock	26.19	26.22	26.141	26.21	2698442.0
2011-04-07 17:00:00	MSFT	Stock	26.21	26.21	26.19	26.19	700.0
2011-04-07 18:00:00	MSFT	Stock	26.2	26.22	26.2	26.21	71495.0
2011-04-07 19:00:00	MSFT	Stock	26.24	26.24	26.2	26.24	2035.0
2011-04-07 06:00:00	NVDA	Stock	0.44	0.44	0.44	0.44	4000.0
2011-04-07 07:00:00	NVDA	Stock	0.4402	0.4402	0.44	0.4402	24000.0
2011-04-07 08:00:00	NVDA	Stock	0.4378	0.4402	0.4345	0.4402	1892760.0
2011-04-07 09:00:00	NVDA	Stock	0.4398	0.4485	0.4358	0.4483	172057760.0
2011-04-07 10:00:00	NVDA	Stock	0.4485	0.4552	0.4458	0.451	349997320.0
2011-04-07 11:00:00	NVDA	Stock	0.451	0.4526	0.4483	0.4525	128524040.0
2011-04-07 12:00:00	NVDA	Stock	0.4525	0.455	0.4508	0.4543	68027000.0
2011-04-07 13:00:00	NVDA	Stock	0.4545	0.4548	0.4505	0.4512	64999880.0
2011-04-07 14:00:00	NVDA	Stock	0.4512	0.453	0.4498	0.4528	66017800.0
2011-04-07 15:00:00	NVDA	Stock	0.4528	0.4535	0.4505	0.4522	142231400.0
2011-04-07 16:00:00	NVDA	Stock	0.4515	0.454	0.4365	0.4528	25060760.0
2011-04-07 17:00:00	NVDA	Stock	0.453	0.453	0.4522	0.4525	418760.0
2011-04-07 18:00:00	NVDA	Stock	0.452	0.4525	0.452	0.4522	143200.0
2011-04-07 19:00:00	NVDA	Stock	0.4522	0.4522	0.45	0.45	390080.0
2011-04-07 07:00:00	AMZN	Stock	9.165	9.165	9.165	9.165	10000.0
2011-04-07 08:00:00	AMZN	Stock	9.175	9.179	9.15	9.15	121200.0
2011-04-07 09:00:00	AMZN	Stock	9.136	9.2585	9.1165	9.224	11818620.0
2011-04-07 10:00:00	AMZN	Stock	9.2235	9.2325	9.09	9.193	19125940.0
2011-04-07 11:00:00	AMZN	Stock	9.1905	9.2005	9.088	9.171	12810440.0
2011-04-07 12:00:00	AMZN	Stock	9.171	9.2405	9.162	9.2225	10319560.0
2011-04-07 13:00:00	AMZN	Stock	9.2225	9.229	9.155	9.1815	7082080.0
2011-04-07 14:00:00	AMZN	Stock	9.1815	9.242	9.175	9.231	9353400.0

> showing 50 of 43,639 rows — these rows as CSV

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