PREVIEW / stock_1hour / 2010-01-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-11.parquet
  size:    909 KB
  rows:    43,275
  symbols: 3,441

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
2010-01-11 04:00:00	AAPL	Stock	7.6446	7.6554	7.6446	7.6554	33600.0
2010-01-11 05:00:00	AAPL	Stock	7.6554	7.6554	7.6518	7.6518	14000.0
2010-01-11 06:00:00	AAPL	Stock	7.6511	7.6511	7.6214	7.6214	71008.0
2010-01-11 07:00:00	AAPL	Stock	7.6179	7.625	7.6075	7.6125	394716.0
2010-01-11 08:00:00	AAPL	Stock	7.6125	7.6243	7.5914	7.6064	2384536.0
2010-01-11 09:00:00	AAPL	Stock	7.6068	7.6071	7.5268	7.5293	83515012.0
2010-01-11 10:00:00	AAPL	Stock	7.5307	7.55	7.4861	7.51	86676772.0
2010-01-11 11:00:00	AAPL	Stock	7.5089	7.5229	7.4786	7.5075	54321708.0
2010-01-11 12:00:00	AAPL	Stock	7.5079	7.5175	7.4825	7.4857	33982424.0
2010-01-11 13:00:00	AAPL	Stock	7.4857	7.4993	7.4714	7.4721	37352336.0
2010-01-11 14:00:00	AAPL	Stock	7.4721	7.4768	7.4446	7.4636	67657940.0
2010-01-11 15:00:00	AAPL	Stock	7.4625	7.5196	7.4618	7.5025	82481168.0
2010-01-11 16:00:00	AAPL	Stock	7.5189	7.5189	7.4832	7.4857	11210892.0
2010-01-11 17:00:00	AAPL	Stock	7.4825	7.4857	7.4821	7.4854	117320.0
2010-01-11 18:00:00	AAPL	Stock	7.4839	7.5039	7.4768	7.4821	529396.0
2010-01-11 19:00:00	AAPL	Stock	7.4854	7.4879	7.4764	7.4764	148624.0
2010-01-11 04:00:00	MSFT	Stock	31.18	31.18	30.89	30.93	600.0
2010-01-11 07:00:00	MSFT	Stock	30.95	30.95	30.89	30.89	8678.0
2010-01-11 08:00:00	MSFT	Stock	30.84	30.89	30.72	30.72	18022.0
2010-01-11 09:00:00	MSFT	Stock	30.73	30.8	30.5	30.54	8993922.0
2010-01-11 10:00:00	MSFT	Stock	30.54	30.59	30.3	30.4	10400595.0
2010-01-11 11:00:00	MSFT	Stock	30.41	30.41	30.12	30.39	7646420.0
2010-01-11 12:00:00	MSFT	Stock	30.39	30.45	30.23	30.24	6329179.0
2010-01-11 13:00:00	MSFT	Stock	30.24	30.24	30.14	30.21	6049809.0
2010-01-11 14:00:00	MSFT	Stock	30.2	30.23	30.16	30.195	4883604.0
2010-01-11 15:00:00	MSFT	Stock	30.19	30.34	30.18	30.28	17881087.0
2010-01-11 16:00:00	MSFT	Stock	30.28	30.53	30.16	30.24	4988444.0
2010-01-11 17:00:00	MSFT	Stock	30.091	30.416	30.091	30.27	5454.0
2010-01-11 18:00:00	MSFT	Stock	30.27	30.27	30.25	30.25	1828.0
2010-01-11 19:00:00	MSFT	Stock	30.25	30.25	30.15	30.15	8625.0
2010-01-11 09:00:00	NVDA	Stock	0.4662	0.4683	0.4585	0.4593	67731920.0
2010-01-11 10:00:00	NVDA	Stock	0.4593	0.4595	0.4525	0.4538	127806960.0
2010-01-11 11:00:00	NVDA	Stock	0.454	0.46	0.4508	0.4595	114046640.0
2010-01-11 12:00:00	NVDA	Stock	0.4595	0.4608	0.4558	0.458	38553480.0
2010-01-11 13:00:00	NVDA	Stock	0.458	0.458	0.4552	0.4565	31711080.0
2010-01-11 14:00:00	NVDA	Stock	0.4565	0.4581	0.4552	0.4555	84369240.0
2010-01-11 15:00:00	NVDA	Stock	0.4552	0.4585	0.455	0.4572	77771440.0
2010-01-11 16:00:00	NVDA	Stock	0.4575	0.4588	0.4568	0.4588	3961960.0
2010-01-11 04:00:00	AMZN	Stock	6.675	6.6875	6.675	6.6875	8000.0
2010-01-11 05:00:00	AMZN	Stock	6.6995	6.6995	6.6995	6.6995	2000.0
2010-01-11 06:00:00	AMZN	Stock	6.6995	6.6995	6.6995	6.6995	2000.0
2010-01-11 07:00:00	AMZN	Stock	6.71	6.71	6.7	6.7	36400.0
2010-01-11 08:00:00	AMZN	Stock	6.7015	6.7065	6.655	6.6625	269280.0
2010-01-11 09:00:00	AMZN	Stock	6.6625	6.6625	6.48	6.4839	42343300.0
2010-01-11 10:00:00	AMZN	Stock	6.484	6.51	6.4605	6.4895	37965700.0
2010-01-11 11:00:00	AMZN	Stock	6.49	6.5345	6.475	6.526	20300300.0
2010-01-11 12:00:00	AMZN	Stock	6.526	6.54	6.4825	6.4955	15789340.0
2010-01-11 13:00:00	AMZN	Stock	6.4945	6.523	6.485	6.488	11898700.0
2010-01-11 14:00:00	AMZN	Stock	6.4885	6.497	6.466	6.4935	17919840.0
2010-01-11 15:00:00	AMZN	Stock	6.493	6.525	6.4895	6.517	26554480.0

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

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