PREVIEW / stock_1hour / 2012-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-09-07.parquet
  size:    936 KB
  rows:    44,270
  symbols: 3,459

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-09-07 04:00:00	AAPL	Stock	24.2489	24.25	24.2321	24.2411	17500.0
2012-09-07 05:00:00	AAPL	Stock	24.2371	24.2375	24.2371	24.2375	5600.0
2012-09-07 06:00:00	AAPL	Stock	24.25	24.2679	24.2475	24.2475	22316.0
2012-09-07 07:00:00	AAPL	Stock	24.2443	24.2464	24.2179	24.225	362292.0
2012-09-07 08:00:00	AAPL	Stock	24.2286	24.2429	24.1507	24.1525	3562216.0
2012-09-07 09:00:00	AAPL	Stock	24.1525	24.2746	24.1296	24.2414	61170872.0
2012-09-07 10:00:00	AAPL	Stock	24.2451	24.3393	24.2371	24.2771	74860856.0
2012-09-07 11:00:00	AAPL	Stock	24.2775	24.3146	24.2393	24.285	36655892.0
2012-09-07 12:00:00	AAPL	Stock	24.285	24.3632	24.2718	24.3536	35323316.0
2012-09-07 13:00:00	AAPL	Stock	24.3564	24.3743	24.3011	24.307	30792664.0
2012-09-07 14:00:00	AAPL	Stock	24.3051	24.355	24.2943	24.3409	21623000.0
2012-09-07 15:00:00	AAPL	Stock	24.3418	24.3421	24.2804	24.2996	49285012.0
2012-09-07 16:00:00	AAPL	Stock	24.2982	24.3133	24.2821	24.2886	7933660.0
2012-09-07 17:00:00	AAPL	Stock	24.2886	24.3036	24.2843	24.2982	721868.0
2012-09-07 18:00:00	AAPL	Stock	24.2954	24.3	24.2893	24.2893	323456.0
2012-09-07 19:00:00	AAPL	Stock	24.2893	24.2921	24.2839	24.2857	241080.0
2012-09-07 05:00:00	MSFT	Stock	31.43	31.43	31.43	31.43	100.0
2012-09-07 07:00:00	MSFT	Stock	31.39	31.4	31.39	31.4	2100.0
2012-09-07 08:00:00	MSFT	Stock	31.35	31.36	31.03	31.16	115320.0
2012-09-07 09:00:00	MSFT	Stock	31.15	31.16	30.69	30.835	7836354.0
2012-09-07 10:00:00	MSFT	Stock	30.83	30.97	30.81	30.95	6553093.0
2012-09-07 11:00:00	MSFT	Stock	30.942	30.96	30.83	30.852	3829589.0
2012-09-07 12:00:00	MSFT	Stock	30.86	30.89	30.76	30.8	4215725.0
2012-09-07 13:00:00	MSFT	Stock	30.795	30.83	30.73	30.742	4197256.0
2012-09-07 14:00:00	MSFT	Stock	30.74	30.91	30.74	30.87	4807965.0
2012-09-07 15:00:00	MSFT	Stock	30.88	30.96	30.83	30.94	7456456.0
2012-09-07 16:00:00	MSFT	Stock	30.95	30.96	30.842	30.95	2344526.0
2012-09-07 17:00:00	MSFT	Stock	30.95	30.95	30.94	30.95	2807.0
2012-09-07 18:00:00	MSFT	Stock	30.96	30.96	30.93	30.93	6650.0
2012-09-07 19:00:00	MSFT	Stock	30.94	30.95	30.94	30.95	250.0
2012-09-07 07:00:00	NVDA	Stock	0.34	0.34	0.3398	0.34	88000.0
2012-09-07 08:00:00	NVDA	Stock	0.3375	0.338	0.3353	0.3368	906200.0
2012-09-07 09:00:00	NVDA	Stock	0.3368	0.337	0.3238	0.3277	202245120.0
2012-09-07 10:00:00	NVDA	Stock	0.3278	0.3318	0.3263	0.3273	115989080.0
2012-09-07 11:00:00	NVDA	Stock	0.3274	0.3283	0.3263	0.328	70388040.0
2012-09-07 12:00:00	NVDA	Stock	0.3283	0.3322	0.328	0.3322	70242440.0
2012-09-07 13:00:00	NVDA	Stock	0.3322	0.334	0.331	0.3334	83020920.0
2012-09-07 14:00:00	NVDA	Stock	0.3333	0.3373	0.3333	0.337	84514080.0
2012-09-07 15:00:00	NVDA	Stock	0.3373	0.3373	0.334	0.3348	124170520.0
2012-09-07 16:00:00	NVDA	Stock	0.335	0.3353	0.331	0.3353	2777600.0
2012-09-07 18:00:00	NVDA	Stock	0.3353	0.3353	0.3338	0.3338	126800.0
2012-09-07 19:00:00	NVDA	Stock	0.3333	0.3333	0.3333	0.3333	8000.0
2012-09-07 04:00:00	AMZN	Stock	12.6265	12.6265	12.6265	12.6265	11400.0
2012-09-07 05:00:00	AMZN	Stock	12.6265	12.6265	12.605	12.605	8380.0
2012-09-07 06:00:00	AMZN	Stock	12.615	12.6265	12.615	12.6265	19480.0
2012-09-07 07:00:00	AMZN	Stock	12.624	12.694	12.618	12.694	134460.0
2012-09-07 08:00:00	AMZN	Stock	12.658	12.6735	12.55	12.6325	623820.0
2012-09-07 09:00:00	AMZN	Stock	12.6255	12.824	12.625	12.7825	20879660.0
2012-09-07 10:00:00	AMZN	Stock	12.7805	12.9595	12.7805	12.932	26239580.0
2012-09-07 11:00:00	AMZN	Stock	12.9353	12.971	12.8975	12.928	10719720.0

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

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