PREVIEW / stock_1hour / 2010-01-07

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-07.parquet
  size:    914 KB
  rows:    43,851
  symbols: 3,444

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-07 06:00:00	AAPL	Stock	7.5357	7.5361	7.5357	7.5361	5600.0
2010-01-07 07:00:00	AAPL	Stock	7.5532	7.5532	7.5414	7.5414	324520.0
2010-01-07 08:00:00	AAPL	Stock	7.5496	7.5961	7.5354	7.5761	3107832.0
2010-01-07 09:00:00	AAPL	Stock	7.5754	7.5846	7.4836	7.5068	104587140.0
2010-01-07 10:00:00	AAPL	Stock	7.5093	7.5518	7.4743	7.5379	104816908.0
2010-01-07 11:00:00	AAPL	Stock	7.5382	7.5464	7.5071	7.5225	41197380.0
2010-01-07 12:00:00	AAPL	Stock	7.5232	7.5457	7.5129	7.515	32893812.0
2010-01-07 13:00:00	AAPL	Stock	7.5146	7.5179	7.4821	7.4864	39472580.0
2010-01-07 14:00:00	AAPL	Stock	7.4854	7.5107	7.4661	7.5077	62981436.0
2010-01-07 15:00:00	AAPL	Stock	7.5079	7.5218	7.4843	7.5207	70562576.0
2010-01-07 16:00:00	AAPL	Stock	7.5211	7.5261	7.5107	7.5261	9101120.0
2010-01-07 17:00:00	AAPL	Stock	7.5207	7.5207	7.5071	7.5071	492380.0
2010-01-07 18:00:00	AAPL	Stock	7.5089	7.5243	7.5089	7.5161	379568.0
2010-01-07 19:00:00	AAPL	Stock	7.5143	7.5239	7.5143	7.5239	142716.0
2010-01-07 07:00:00	MSFT	Stock	30.64	30.69	30.63	30.69	2400.0
2010-01-07 08:00:00	MSFT	Stock	30.68	30.72	30.64	30.67	10241.0
2010-01-07 09:00:00	MSFT	Stock	30.67	30.72	30.4	30.42	5479543.0
2010-01-07 10:00:00	MSFT	Stock	30.43	30.58	30.41	30.49	6805409.0
2010-01-07 11:00:00	MSFT	Stock	30.49	30.51	30.19	30.21	7957335.0
2010-01-07 12:00:00	MSFT	Stock	30.21	30.35	30.19	30.268	5883061.0
2010-01-07 13:00:00	MSFT	Stock	30.265	30.44	30.26	30.385	4528346.0
2010-01-07 14:00:00	MSFT	Stock	30.39	30.4	30.26	30.305	5146990.0
2010-01-07 15:00:00	MSFT	Stock	30.3	30.48	30.21	30.48	9524196.0
2010-01-07 16:00:00	MSFT	Stock	30.48	30.5	30.241	30.45	4516637.0
2010-01-07 17:00:00	MSFT	Stock	30.44	30.77	30.44	30.5	5350.0
2010-01-07 18:00:00	MSFT	Stock	30.46	30.46	30.4	30.4	2804.0
2010-01-07 19:00:00	MSFT	Stock	30.41	30.42	30.41	30.41	1800.0
2010-01-07 08:00:00	NVDA	Stock	0.4692	0.4692	0.4692	0.4692	40000.0
2010-01-07 09:00:00	NVDA	Stock	0.4705	0.4715	0.4622	0.463	55211480.0
2010-01-07 10:00:00	NVDA	Stock	0.463	0.4668	0.46	0.4635	151599560.0
2010-01-07 11:00:00	NVDA	Stock	0.4638	0.4652	0.4609	0.4612	57995960.0
2010-01-07 12:00:00	NVDA	Stock	0.4612	0.463	0.4593	0.4609	72212920.0
2010-01-07 13:00:00	NVDA	Stock	0.461	0.4643	0.461	0.4627	32623040.0
2010-01-07 14:00:00	NVDA	Stock	0.4628	0.464	0.4618	0.4621	57309080.0
2010-01-07 15:00:00	NVDA	Stock	0.4622	0.4633	0.4608	0.4628	106120960.0
2010-01-07 16:00:00	NVDA	Stock	0.4628	0.4633	0.4608	0.4633	11990160.0
2010-01-07 17:00:00	NVDA	Stock	0.472	0.472	0.4628	0.4628	71120.0
2010-01-07 08:00:00	AMZN	Stock	6.6105	6.6115	6.57	6.605	264980.0
2010-01-07 09:00:00	AMZN	Stock	6.6095	6.616	6.495	6.529	41897400.0
2010-01-07 10:00:00	AMZN	Stock	6.529	6.5845	6.5	6.5006	44647400.0
2010-01-07 11:00:00	AMZN	Stock	6.5005	6.5355	6.475	6.477	31804980.0
2010-01-07 12:00:00	AMZN	Stock	6.477	6.5125	6.465	6.469	20239480.0
2010-01-07 13:00:00	AMZN	Stock	6.4685	6.4713	6.44	6.447	21048580.0
2010-01-07 14:00:00	AMZN	Stock	6.448	6.521	6.445	6.507	25897380.0
2010-01-07 15:00:00	AMZN	Stock	6.5075	6.5075	6.465	6.5	29456680.0
2010-01-07 16:00:00	AMZN	Stock	6.5	6.507	6.4882	6.4975	1022320.0
2010-01-07 17:00:00	AMZN	Stock	6.499	6.6125	6.494	6.494	81000.0
2010-01-07 18:00:00	AMZN	Stock	6.494	6.5	6.494	6.5	274360.0
2010-01-07 19:00:00	AMZN	Stock	6.5	6.5	6.496	6.496	45920.0
2010-01-07 08:00:00	TLT	Stock	89.11	89.48	89.01	89.01	12520.0

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

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