PREVIEW / stock_1hour / 2007-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-27.parquet
  size:    770 KB
  rows:    37,362
  symbols: 3,050

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-06-27 09:00:00	AAPL	Stock	4.3075	4.3375	4.2746	4.305	169015980.0
2007-06-27 10:00:00	AAPL	Stock	4.3046	4.3121	4.2593	4.2796	197606640.0
2007-06-27 11:00:00	AAPL	Stock	4.2796	4.3214	4.2679	4.2939	119746788.0
2007-06-27 12:00:00	AAPL	Stock	4.2936	4.3125	4.2936	4.31	63140868.0
2007-06-27 13:00:00	AAPL	Stock	4.3104	4.3179	4.2782	4.2839	85419068.0
2007-06-27 14:00:00	AAPL	Stock	4.2836	4.3357	4.2807	4.3186	124445860.0
2007-06-27 15:00:00	AAPL	Stock	4.3186	4.3586	4.3143	4.3568	167812540.0
2007-06-27 16:00:00	AAPL	Stock	4.3568	4.3568	4.3532	4.3532	8557528.0
2007-06-27 09:00:00	MSFT	Stock	29.36	29.71	29.36	29.63	4874868.0
2007-06-27 10:00:00	MSFT	Stock	29.63	29.72	29.58	29.62	6932436.0
2007-06-27 11:00:00	MSFT	Stock	29.62	29.72	29.57	29.595	4508387.0
2007-06-27 12:00:00	MSFT	Stock	29.59	29.71	29.59	29.65	4289796.0
2007-06-27 13:00:00	MSFT	Stock	29.66	29.7	29.62	29.69	4552582.0
2007-06-27 14:00:00	MSFT	Stock	29.69	29.89	29.685	29.86	6129996.0
2007-06-27 15:00:00	MSFT	Stock	29.85	29.95	29.8	29.88	10373961.0
2007-06-27 16:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	1679194.0
2007-06-27 08:00:00	NVDA	Stock	0.6748	0.6748	0.6748	0.6748	1266480.0
2007-06-27 09:00:00	NVDA	Stock	0.6742	0.684	0.6715	0.682	66586500.0
2007-06-27 10:00:00	NVDA	Stock	0.682	0.6933	0.6805	0.683	125310060.0
2007-06-27 11:00:00	NVDA	Stock	0.683	0.6902	0.681	0.6848	102505200.0
2007-06-27 12:00:00	NVDA	Stock	0.6847	0.691	0.6847	0.6885	54461640.0
2007-06-27 13:00:00	NVDA	Stock	0.6887	0.6887	0.6817	0.6858	47568060.0
2007-06-27 14:00:00	NVDA	Stock	0.6857	0.6915	0.6855	0.6905	65266320.0
2007-06-27 15:00:00	NVDA	Stock	0.6905	0.694	0.6901	0.6935	116286720.0
2007-06-27 16:00:00	NVDA	Stock	0.6937	0.703	0.6932	0.695	11542320.0
2007-06-27 17:00:00	NVDA	Stock	0.695	0.695	0.6947	0.6947	60000.0
2007-06-27 18:00:00	NVDA	Stock	0.6947	0.6947	0.6947	0.6947	24000.0
2007-06-27 19:00:00	NVDA	Stock	0.6947	0.6947	0.6937	0.6937	12000.0
2007-06-27 08:00:00	AMZN	Stock	3.3565	3.3565	3.344	3.35	367760.0
2007-06-27 09:00:00	AMZN	Stock	3.35	3.377	3.3355	3.364	28358400.0
2007-06-27 10:00:00	AMZN	Stock	3.364	3.3865	3.3605	3.3705	29135440.0
2007-06-27 11:00:00	AMZN	Stock	3.37	3.38	3.362	3.3705	18133980.0
2007-06-27 12:00:00	AMZN	Stock	3.3705	3.394	3.3705	3.3827	18566780.0
2007-06-27 13:00:00	AMZN	Stock	3.3825	3.386	3.358	3.3695	16318560.0
2007-06-27 14:00:00	AMZN	Stock	3.37	3.4	3.366	3.393	15899360.0
2007-06-27 15:00:00	AMZN	Stock	3.393	3.4105	3.386	3.4075	32277100.0
2007-06-27 16:00:00	AMZN	Stock	3.407	3.407	3.404	3.404	3261100.0
2007-06-27 17:00:00	AMZN	Stock	3.404	3.4045	3.404	3.4045	10000.0
2007-06-27 18:00:00	AMZN	Stock	3.4045	3.4045	3.4045	3.4045	14360.0
2007-06-27 09:00:00	TLT	Stock	84.61	84.74	84.54	84.56	155800.0
2007-06-27 10:00:00	TLT	Stock	84.59	84.66	84.53	84.59	211300.0
2007-06-27 11:00:00	TLT	Stock	84.6	84.63	84.46	84.53	98700.0
2007-06-27 12:00:00	TLT	Stock	84.53	84.59	84.5	84.56	167400.0
2007-06-27 13:00:00	TLT	Stock	84.56	84.71	84.54	84.57	101400.0
2007-06-27 14:00:00	TLT	Stock	84.56	84.63	84.44	84.51	2499700.0
2007-06-27 15:00:00	TLT	Stock	84.5	84.5	84.2	84.26	2557400.0
2007-06-27 16:00:00	TLT	Stock	84.27	84.32	84.27	84.32	10300.0
2007-06-27 09:00:00	CL	Stock	32.335	32.45	32.255	32.325	442400.0
2007-06-27 10:00:00	CL	Stock	32.34	32.405	32.25	32.36	903170.0
2007-06-27 11:00:00	CL	Stock	32.36	32.415	32.27	32.325	486600.0

> showing 50 of 37,362 rows — these rows as CSV

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