PREVIEW / stock_1hour / 2007-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-24.parquet
  size:    756 KB
  rows:    36,622
  symbols: 3,012

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
2007-05-24 09:00:00	AAPL	Stock	4.0289	4.0657	4.0125	4.055	95418064.0
2007-05-24 10:00:00	AAPL	Stock	4.055	4.0879	4.0289	4.0349	161603540.0
2007-05-24 11:00:00	AAPL	Stock	4.0354	4.0425	4.0075	4.0325	116869676.0
2007-05-24 12:00:00	AAPL	Stock	4.0321	4.0418	3.9789	3.9979	106605464.0
2007-05-24 13:00:00	AAPL	Stock	3.9975	4.0082	3.9768	3.9929	92099588.0
2007-05-24 14:00:00	AAPL	Stock	3.9928	3.9975	3.9429	3.96	133671384.0
2007-05-24 15:00:00	AAPL	Stock	3.9604	3.9657	3.9418	3.9543	147029204.0
2007-05-24 16:00:00	AAPL	Stock	3.9525	3.9532	3.9525	3.9532	10297952.0
2007-05-24 09:00:00	MSFT	Stock	30.54	30.65	30.52	30.62	3770927.0
2007-05-24 10:00:00	MSFT	Stock	30.63	30.8	30.46	30.55	9002842.0
2007-05-24 11:00:00	MSFT	Stock	30.55	30.6	30.34	30.42	7421645.0
2007-05-24 12:00:00	MSFT	Stock	30.41	30.43	30.25	30.34	5876876.0
2007-05-24 13:00:00	MSFT	Stock	30.34	30.39	30.26	30.3	5064073.0
2007-05-24 14:00:00	MSFT	Stock	30.305	30.32	30.15	30.16	7635411.0
2007-05-24 15:00:00	MSFT	Stock	30.16	30.5	29.96	30.18	21981903.0
2007-05-24 16:00:00	MSFT	Stock	30.19	30.19	30.17	30.17	1130535.0
2007-05-24 08:00:00	NVDA	Stock	0.575	0.5792	0.5733	0.5792	120000.0
2007-05-24 09:00:00	NVDA	Stock	0.575	0.5773	0.5655	0.5682	40859460.0
2007-05-24 10:00:00	NVDA	Stock	0.5685	0.5737	0.5625	0.563	124069140.0
2007-05-24 11:00:00	NVDA	Stock	0.5632	0.5637	0.5555	0.5608	110654280.0
2007-05-24 12:00:00	NVDA	Stock	0.5608	0.5612	0.553	0.5548	69263340.0
2007-05-24 13:00:00	NVDA	Stock	0.555	0.559	0.5547	0.5563	48407280.0
2007-05-24 14:00:00	NVDA	Stock	0.5563	0.5568	0.5518	0.5525	82124760.0
2007-05-24 15:00:00	NVDA	Stock	0.5527	0.5548	0.55	0.5528	111886080.0
2007-05-24 16:00:00	NVDA	Stock	0.5523	0.5538	0.5523	0.5538	12913320.0
2007-05-24 17:00:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	6000.0
2007-05-24 18:00:00	NVDA	Stock	0.5538	0.5538	0.5538	0.5538	12000.0
2007-05-24 07:00:00	AMZN	Stock	3.464	3.4645	3.464	3.4645	14800.0
2007-05-24 08:00:00	AMZN	Stock	3.475	3.475	3.4275	3.4425	3279940.0
2007-05-24 09:00:00	AMZN	Stock	3.4415	3.521	3.4265	3.499	74745080.0
2007-05-24 10:00:00	AMZN	Stock	3.499	3.5145	3.411	3.417	101529000.0
2007-05-24 11:00:00	AMZN	Stock	3.417	3.4435	3.3855	3.4275	68517060.0
2007-05-24 12:00:00	AMZN	Stock	3.4275	3.4275	3.388	3.418	42732540.0
2007-05-24 13:00:00	AMZN	Stock	3.4175	3.4895	3.4055	3.4795	59390700.0
2007-05-24 14:00:00	AMZN	Stock	3.4795	3.48	3.4375	3.4442	56481900.0
2007-05-24 15:00:00	AMZN	Stock	3.444	3.4715	3.4385	3.468	57731500.0
2007-05-24 16:00:00	AMZN	Stock	3.4695	3.4735	3.4675	3.47	3432540.0
2007-05-24 17:00:00	AMZN	Stock	3.4705	3.4705	3.4635	3.465	68000.0
2007-05-24 18:00:00	AMZN	Stock	3.465	3.4695	3.4635	3.4695	68000.0
2007-05-24 19:00:00	AMZN	Stock	3.4655	3.4735	3.4645	3.473	98020.0
2007-05-24 09:00:00	TLT	Stock	86.46	86.52	86.33	86.35	251000.0
2007-05-24 10:00:00	TLT	Stock	86.34	86.34	85.96	86.17	718100.0
2007-05-24 11:00:00	TLT	Stock	86.16	86.28	86.09	86.23	268800.0
2007-05-24 12:00:00	TLT	Stock	86.26	86.4	86.22	86.3	119000.0
2007-05-24 13:00:00	TLT	Stock	86.3	86.36	86.27	86.34	49200.0
2007-05-24 14:00:00	TLT	Stock	86.32	86.44	86.3	86.38	97700.0
2007-05-24 15:00:00	TLT	Stock	86.43	86.59	86.42	86.57	82700.0
2007-05-24 09:00:00	CL	Stock	33.49	33.49	33.365	33.39	282200.0
2007-05-24 10:00:00	CL	Stock	33.4	33.505	33.25	33.325	1086000.0
2007-05-24 11:00:00	CL	Stock	33.32	33.44	33.305	33.35	558800.0

> showing 50 of 36,622 rows — these rows as CSV

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