PREVIEW / stock_1hour / 2012-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-01.parquet
  size:    954 KB
  rows:    44,918
  symbols: 3,517

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-03-01 04:00:00	AAPL	Stock	19.4286	19.5107	19.4286	19.4671	197680.0
2012-03-01 05:00:00	AAPL	Stock	19.5	19.5179	19.4786	19.4821	141876.0
2012-03-01 06:00:00	AAPL	Stock	19.4786	19.5	19.4786	19.4893	100380.0
2012-03-01 07:00:00	AAPL	Stock	19.4821	19.5118	19.4393	19.4839	1115212.0
2012-03-01 08:00:00	AAPL	Stock	19.4786	19.5357	19.4643	19.5314	7703444.0
2012-03-01 09:00:00	AAPL	Stock	19.5257	19.5868	19.3321	19.4325	145829236.0
2012-03-01 10:00:00	AAPL	Stock	19.432	19.46	19.3075	19.3754	151540900.0
2012-03-01 11:00:00	AAPL	Stock	19.3746	19.4018	19.2418	19.3608	116645844.0
2012-03-01 12:00:00	AAPL	Stock	19.3625	19.4289	19.3311	19.4096	49263508.0
2012-03-01 13:00:00	AAPL	Stock	19.4097	19.4557	19.3857	19.4375	39201820.0
2012-03-01 14:00:00	AAPL	Stock	19.4393	19.4621	19.4	19.4232	52824240.0
2012-03-01 15:00:00	AAPL	Stock	19.4214	19.4607	19.3596	19.4382	100834412.0
2012-03-01 16:00:00	AAPL	Stock	19.4371	19.4686	19.3992	19.4568	8038828.0
2012-03-01 17:00:00	AAPL	Stock	19.4511	19.4611	19.4429	19.4611	711760.0
2012-03-01 18:00:00	AAPL	Stock	19.4618	19.4643	19.4589	19.4629	269696.0
2012-03-01 19:00:00	AAPL	Stock	19.4629	19.4768	19.4554	19.475	459144.0
2012-03-01 07:00:00	MSFT	Stock	31.94	31.94	31.85	31.85	6010.0
2012-03-01 08:00:00	MSFT	Stock	31.85	31.85	31.8	31.83	29902.0
2012-03-01 09:00:00	MSFT	Stock	31.82	32.1	31.78	31.975	12709431.0
2012-03-01 10:00:00	MSFT	Stock	31.98	32.05	31.86	31.91	15739223.0
2012-03-01 11:00:00	MSFT	Stock	31.91	32.205	31.85	32.2	8348668.0
2012-03-01 12:00:00	MSFT	Stock	32.194	32.25	32.07	32.235	7327991.0
2012-03-01 13:00:00	MSFT	Stock	32.235	32.39	32.22	32.318	8093020.0
2012-03-01 14:00:00	MSFT	Stock	32.31	32.37	32.26	32.278	6195488.0
2012-03-01 15:00:00	MSFT	Stock	32.275	32.37	32.1	32.28	13153345.0
2012-03-01 16:00:00	MSFT	Stock	32.3	32.36	31.924	32.36	2625627.0
2012-03-01 17:00:00	MSFT	Stock	32.38	32.38	32.24	32.37	41880.0
2012-03-01 18:00:00	MSFT	Stock	32.38	32.38	31.98	32.37	13444.0
2012-03-01 19:00:00	MSFT	Stock	32.38	32.39	32.37	32.39	3587.0
2012-03-01 08:00:00	NVDA	Stock	0.38	0.384	0.3788	0.3813	228840.0
2012-03-01 09:00:00	NVDA	Stock	0.382	0.3858	0.3788	0.384	47284480.0
2012-03-01 10:00:00	NVDA	Stock	0.3838	0.3838	0.3793	0.3808	82382840.0
2012-03-01 11:00:00	NVDA	Stock	0.3809	0.3825	0.3793	0.381	54382320.0
2012-03-01 12:00:00	NVDA	Stock	0.381	0.3815	0.38	0.381	34681680.0
2012-03-01 13:00:00	NVDA	Stock	0.381	0.382	0.3808	0.3815	37497360.0
2012-03-01 14:00:00	NVDA	Stock	0.3816	0.382	0.3808	0.3815	46737000.0
2012-03-01 15:00:00	NVDA	Stock	0.3814	0.3819	0.3788	0.381	124803040.0
2012-03-01 16:00:00	NVDA	Stock	0.381	0.3827	0.3804	0.381	5745920.0
2012-03-01 17:00:00	NVDA	Stock	0.3813	0.382	0.3813	0.382	2501000.0
2012-03-01 18:00:00	NVDA	Stock	0.3825	0.3825	0.3813	0.3813	12280.0
2012-03-01 19:00:00	NVDA	Stock	0.3825	0.3825	0.3825	0.3825	20000.0
2012-03-01 06:00:00	AMZN	Stock	9.0175	9.0175	9.0115	9.0115	4000.0
2012-03-01 07:00:00	AMZN	Stock	8.998	8.998	8.998	8.998	14000.0
2012-03-01 08:00:00	AMZN	Stock	9.0055	9.025	8.9845	9.01	551480.0
2012-03-01 09:00:00	AMZN	Stock	9.0098	9.0375	8.829	8.915	22154500.0
2012-03-01 10:00:00	AMZN	Stock	8.914	8.9405	8.854	8.902	18853580.0
2012-03-01 11:00:00	AMZN	Stock	8.901	8.993	8.901	8.99	14886420.0
2012-03-01 12:00:00	AMZN	Stock	8.9894	9.007	8.9516	8.9925	8445260.0
2012-03-01 13:00:00	AMZN	Stock	8.9925	9.0245	8.9735	9.012	9046020.0
2012-03-01 14:00:00	AMZN	Stock	9.012	9.014	8.95	8.975	7146280.0

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

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