PREVIEW / stock_1hour / 2011-04-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-20.parquet
  size:    982 KB
  rows:    47,167
  symbols: 3,546

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-20 04:00:00	AAPL	Stock	12.1393	12.2346	12.1393	12.2346	77840.0
2011-04-20 05:00:00	AAPL	Stock	12.2464	12.2679	12.2346	12.2639	86520.0
2011-04-20 06:00:00	AAPL	Stock	12.2529	12.3114	12.2529	12.2857	256424.0
2011-04-20 07:00:00	AAPL	Stock	12.2857	12.2857	12.2261	12.2357	1201508.0
2011-04-20 08:00:00	AAPL	Stock	12.2364	12.2721	12.2061	12.2518	4511696.0
2011-04-20 09:00:00	AAPL	Stock	12.2525	12.2825	12.1964	12.2625	95928728.0
2011-04-20 10:00:00	AAPL	Stock	12.2625	12.3482	12.26	12.3129	115445176.0
2011-04-20 11:00:00	AAPL	Stock	12.3118	12.3186	12.2654	12.2904	51025548.0
2011-04-20 12:00:00	AAPL	Stock	12.2904	12.3107	12.2843	12.2993	37308320.0
2011-04-20 13:00:00	AAPL	Stock	12.2989	12.3214	12.2964	12.315	40887196.0
2011-04-20 14:00:00	AAPL	Stock	12.3143	12.3193	12.2857	12.2864	44398480.0
2011-04-20 15:00:00	AAPL	Stock	12.2864	12.2884	12.2107	12.2271	134385160.0
2011-04-20 16:00:00	AAPL	Stock	12.2318	12.6211	12.2143	12.5321	102652844.0
2011-04-20 17:00:00	AAPL	Stock	12.5318	12.7668	12.2293	12.7257	46466280.0
2011-04-20 18:00:00	AAPL	Stock	12.7254	12.7429	12.2289	12.6418	7191296.0
2011-04-20 19:00:00	AAPL	Stock	12.6425	12.6604	12.6071	12.6079	4470816.0
2011-04-20 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	400.0
2011-04-20 05:00:00	MSFT	Stock	25.45	25.54	25.45	25.52	2600.0
2011-04-20 06:00:00	MSFT	Stock	25.53	25.58	25.51	25.57	2600.0
2011-04-20 07:00:00	MSFT	Stock	25.58	25.75	25.5	25.6	53777.0
2011-04-20 08:00:00	MSFT	Stock	25.6	25.6	25.52	25.55	106938.0
2011-04-20 09:00:00	MSFT	Stock	25.56	25.75	25.51	25.715	8970540.0
2011-04-20 10:00:00	MSFT	Stock	25.71	25.94	25.67	25.93	11490985.0
2011-04-20 11:00:00	MSFT	Stock	25.92	26.0	25.83	25.97	7013162.0
2011-04-20 12:00:00	MSFT	Stock	25.96	26.0	25.88	25.91	5646077.0
2011-04-20 13:00:00	MSFT	Stock	25.9	25.93	25.79	25.85	5831175.0
2011-04-20 14:00:00	MSFT	Stock	25.85	25.86	25.71	25.81	6202404.0
2011-04-20 15:00:00	MSFT	Stock	25.815	25.9	25.74	25.74	12424516.0
2011-04-20 16:00:00	MSFT	Stock	25.75	26.01	25.7	25.85	2387769.0
2011-04-20 17:00:00	MSFT	Stock	25.85	25.89	25.74	25.89	153983.0
2011-04-20 18:00:00	MSFT	Stock	25.86	25.9	25.76	25.9	15103.0
2011-04-20 19:00:00	MSFT	Stock	25.95	25.96	25.87	25.93	16159.0
2011-04-20 07:00:00	NVDA	Stock	0.4582	0.4582	0.4582	0.4582	8000.0
2011-04-20 08:00:00	NVDA	Stock	0.461	0.462	0.4582	0.4608	1701600.0
2011-04-20 09:00:00	NVDA	Stock	0.4608	0.4738	0.4608	0.467	150435000.0
2011-04-20 10:00:00	NVDA	Stock	0.4668	0.4698	0.4643	0.4654	127015040.0
2011-04-20 11:00:00	NVDA	Stock	0.4655	0.466	0.4628	0.4635	58324480.0
2011-04-20 12:00:00	NVDA	Stock	0.4636	0.4638	0.4595	0.4595	62616080.0
2011-04-20 13:00:00	NVDA	Stock	0.4595	0.4608	0.4568	0.4595	66064320.0
2011-04-20 14:00:00	NVDA	Stock	0.4598	0.4638	0.4592	0.463	59289800.0
2011-04-20 15:00:00	NVDA	Stock	0.4633	0.465	0.4628	0.4645	100486000.0
2011-04-20 16:00:00	NVDA	Stock	0.4658	0.4662	0.4594	0.4662	11324040.0
2011-04-20 17:00:00	NVDA	Stock	0.4643	0.467	0.4643	0.467	1630960.0
2011-04-20 18:00:00	NVDA	Stock	0.4688	0.4702	0.4685	0.47	773000.0
2011-04-20 19:00:00	NVDA	Stock	0.4692	0.4713	0.4692	0.4713	603440.0
2011-04-20 05:00:00	AMZN	Stock	9.0	9.0	9.0	9.0	2000.0
2011-04-20 07:00:00	AMZN	Stock	9.04	9.18	9.04	9.13	180160.0
2011-04-20 08:00:00	AMZN	Stock	9.0775	9.1645	9.0615	9.075	241040.0
2011-04-20 09:00:00	AMZN	Stock	9.075	9.184	9.075	9.1805	12050680.0
2011-04-20 10:00:00	AMZN	Stock	9.18	9.2485	9.159	9.2165	19605840.0

> showing 50 of 47,167 rows — these rows as CSV

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