PREVIEW / stock_1hour / 2012-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-13.parquet
  size:    962 KB
  rows:    45,478
  symbols: 3,532

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-13 04:00:00	AAPL	Stock	19.7357	19.8393	19.7357	19.8393	103320.0
2012-03-13 05:00:00	AAPL	Stock	19.85	19.85	19.8393	19.85	22652.0
2012-03-13 06:00:00	AAPL	Stock	19.8571	19.8682	19.8571	19.8571	109480.0
2012-03-13 07:00:00	AAPL	Stock	19.8436	19.9036	19.8393	19.8893	1234576.0
2012-03-13 08:00:00	AAPL	Stock	19.8868	19.9196	19.8743	19.8829	3692416.0
2012-03-13 09:00:00	AAPL	Stock	19.88	19.9414	19.8571	19.8765	72595544.0
2012-03-13 10:00:00	AAPL	Stock	19.8811	19.9946	19.8482	19.9872	108293276.0
2012-03-13 11:00:00	AAPL	Stock	19.9871	20.0671	19.9507	20.0304	92795080.0
2012-03-13 12:00:00	AAPL	Stock	20.0307	20.1468	20.0157	20.1273	91396592.0
2012-03-13 13:00:00	AAPL	Stock	20.1293	20.1314	20.0607	20.1032	54807676.0
2012-03-13 14:00:00	AAPL	Stock	20.1025	20.1589	20.0793	20.1396	88982180.0
2012-03-13 15:00:00	AAPL	Stock	20.1404	20.2921	20.1364	20.2886	148843212.0
2012-03-13 16:00:00	AAPL	Stock	20.2893	20.2993	20.0087	20.2961	18776688.0
2012-03-13 17:00:00	AAPL	Stock	20.2921	20.2946	20.2468	20.2511	1956248.0
2012-03-13 18:00:00	AAPL	Stock	20.25	20.2804	20.25	20.2761	594020.0
2012-03-13 19:00:00	AAPL	Stock	20.2775	20.3107	20.2721	20.3018	1036448.0
2012-03-13 06:00:00	MSFT	Stock	32.25	32.25	32.25	32.25	100.0
2012-03-13 07:00:00	MSFT	Stock	32.25	32.25	32.2	32.2	8909.0
2012-03-13 08:00:00	MSFT	Stock	32.2	32.21	32.04	32.2	11284.0
2012-03-13 09:00:00	MSFT	Stock	32.19	32.28	32.15	32.22	4116300.0
2012-03-13 10:00:00	MSFT	Stock	32.21	32.36	32.17	32.31	6104044.0
2012-03-13 11:00:00	MSFT	Stock	32.31	32.49	32.28	32.47	10382572.0
2012-03-13 12:00:00	MSFT	Stock	32.465	32.48	32.42	32.472	3134967.0
2012-03-13 13:00:00	MSFT	Stock	32.47	32.49	32.42	32.445	2955967.0
2012-03-13 14:00:00	MSFT	Stock	32.45	32.5	32.41	32.45	3853555.0
2012-03-13 15:00:00	MSFT	Stock	32.445	32.69	32.44	32.67	13037940.0
2012-03-13 16:00:00	MSFT	Stock	32.67	32.7	32.04	32.67	4067843.0
2012-03-13 17:00:00	MSFT	Stock	32.67	32.68	32.59	32.59	332707.0
2012-03-13 18:00:00	MSFT	Stock	32.65	32.65	32.65	32.65	900.0
2012-03-13 19:00:00	MSFT	Stock	32.65	32.66	32.65	32.66	540.0
2012-03-13 09:00:00	NVDA	Stock	0.3665	0.3695	0.366	0.3665	55494760.0
2012-03-13 10:00:00	NVDA	Stock	0.3662	0.3705	0.3645	0.3695	128512720.0
2012-03-13 11:00:00	NVDA	Stock	0.3696	0.3718	0.3688	0.3692	56213960.0
2012-03-13 12:00:00	NVDA	Stock	0.3692	0.3695	0.3672	0.3685	36180600.0
2012-03-13 13:00:00	NVDA	Stock	0.3688	0.3698	0.3682	0.3695	31704600.0
2012-03-13 14:00:00	NVDA	Stock	0.3692	0.3701	0.3675	0.3675	53762920.0
2012-03-13 15:00:00	NVDA	Stock	0.3678	0.3695	0.3672	0.3695	161503680.0
2012-03-13 16:00:00	NVDA	Stock	0.3693	0.3704	0.3661	0.369	14629240.0
2012-03-13 17:00:00	NVDA	Stock	0.3698	0.3703	0.369	0.3703	1253240.0
2012-03-13 18:00:00	NVDA	Stock	0.3705	0.3705	0.37	0.3705	112000.0
2012-03-13 19:00:00	NVDA	Stock	0.369	0.369	0.369	0.369	12000.0
2012-03-13 04:00:00	AMZN	Stock	9.1695	9.1695	9.1695	9.1695	2000.0
2012-03-13 07:00:00	AMZN	Stock	9.22	9.22	9.22	9.22	2000.0
2012-03-13 08:00:00	AMZN	Stock	9.2115	9.225	9.145	9.2125	76440.0
2012-03-13 09:00:00	AMZN	Stock	9.215	9.2435	9.1012	9.1025	10340700.0
2012-03-13 10:00:00	AMZN	Stock	9.1028	9.1705	9.0385	9.144	19584180.0
2012-03-13 11:00:00	AMZN	Stock	9.146	9.1755	9.1085	9.1585	10714340.0
2012-03-13 12:00:00	AMZN	Stock	9.1582	9.197	9.148	9.1715	6185760.0
2012-03-13 13:00:00	AMZN	Stock	9.1685	9.18	9.135	9.162	5018180.0
2012-03-13 14:00:00	AMZN	Stock	9.1605	9.1625	9.0865	9.112	10033840.0

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

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