PREVIEW / stock_1hour / 2007-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-20.parquet
  size:    759 KB
  rows:    37,173
  symbols: 3,022

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-20 09:00:00	AAPL	Stock	4.4239	4.4521	4.3964	4.4021	120087240.0
2007-06-20 10:00:00	AAPL	Stock	4.4021	4.4082	4.3607	4.4011	188710564.0
2007-06-20 11:00:00	AAPL	Stock	4.4008	4.4025	4.3714	4.3964	116475072.0
2007-06-20 12:00:00	AAPL	Stock	4.3964	4.41	4.3839	4.3886	73204180.0
2007-06-20 13:00:00	AAPL	Stock	4.3882	4.4061	4.3511	4.3889	121196852.0
2007-06-20 14:00:00	AAPL	Stock	4.3889	4.3986	4.3775	4.3886	93255820.0
2007-06-20 15:00:00	AAPL	Stock	4.3886	4.39	4.3393	4.3404	142664200.0
2007-06-20 16:00:00	AAPL	Stock	4.3432	4.3436	4.34	4.3411	7348516.0
2007-06-20 09:00:00	MSFT	Stock	30.44	30.51	30.34	30.34	3971995.0
2007-06-20 10:00:00	MSFT	Stock	30.34	30.41	30.2	30.36	6243429.0
2007-06-20 11:00:00	MSFT	Stock	30.36	30.38	30.23	30.26	4032845.0
2007-06-20 12:00:00	MSFT	Stock	30.25	30.38	30.2	30.27	3549265.0
2007-06-20 13:00:00	MSFT	Stock	30.26	30.29	30.12	30.21	4751414.0
2007-06-20 14:00:00	MSFT	Stock	30.21	30.26	30.11	30.22	4787721.0
2007-06-20 15:00:00	MSFT	Stock	30.22	30.23	29.96	30.05	12251564.0
2007-06-20 16:00:00	MSFT	Stock	30.01	30.01	30.01	30.01	1263855.0
2007-06-20 08:00:00	NVDA	Stock	0.67	0.6728	0.6683	0.6692	420000.0
2007-06-20 09:00:00	NVDA	Stock	0.67	0.67	0.6598	0.666	93957660.0
2007-06-20 10:00:00	NVDA	Stock	0.666	0.6692	0.6618	0.668	120735180.0
2007-06-20 11:00:00	NVDA	Stock	0.6678	0.67	0.6663	0.6667	81343140.0
2007-06-20 12:00:00	NVDA	Stock	0.6667	0.6697	0.6656	0.6682	75531540.0
2007-06-20 13:00:00	NVDA	Stock	0.6682	0.6683	0.6633	0.666	117415620.0
2007-06-20 14:00:00	NVDA	Stock	0.666	0.6695	0.6638	0.6688	113576280.0
2007-06-20 15:00:00	NVDA	Stock	0.6688	0.669	0.6613	0.6645	168174180.0
2007-06-20 16:00:00	NVDA	Stock	0.6643	0.6673	0.6635	0.6635	36578220.0
2007-06-20 17:00:00	NVDA	Stock	0.6642	0.6642	0.6602	0.6602	56400.0
2007-06-20 18:00:00	NVDA	Stock	0.666	0.666	0.666	0.666	6000.0
2007-06-20 19:00:00	NVDA	Stock	0.666	0.666	0.665	0.665	42000.0
2007-06-20 08:00:00	AMZN	Stock	3.5135	3.5135	3.492	3.5045	206000.0
2007-06-20 09:00:00	AMZN	Stock	3.505	3.524	3.4675	3.4745	29618380.0
2007-06-20 10:00:00	AMZN	Stock	3.4745	3.525	3.4625	3.519	32422000.0
2007-06-20 11:00:00	AMZN	Stock	3.5185	3.5195	3.493	3.503	21782600.0
2007-06-20 12:00:00	AMZN	Stock	3.503	3.5225	3.4995	3.5185	13928960.0
2007-06-20 13:00:00	AMZN	Stock	3.519	3.5195	3.485	3.505	17418820.0
2007-06-20 14:00:00	AMZN	Stock	3.505	3.5125	3.485	3.4945	17898020.0
2007-06-20 15:00:00	AMZN	Stock	3.4955	3.4965	3.4525	3.4565	37192720.0
2007-06-20 16:00:00	AMZN	Stock	3.455	3.522	3.455	3.4625	3250120.0
2007-06-20 17:00:00	AMZN	Stock	3.465	3.4675	3.46	3.4675	39240.0
2007-06-20 18:00:00	AMZN	Stock	3.4625	3.4625	3.461	3.461	11500.0
2007-06-20 19:00:00	AMZN	Stock	3.4615	3.4625	3.4615	3.4625	30300.0
2007-06-20 09:00:00	TLT	Stock	84.02	84.08	83.76	83.76	685800.0
2007-06-20 10:00:00	TLT	Stock	83.78	84.01	83.76	83.83	864500.0
2007-06-20 11:00:00	TLT	Stock	83.84	84.01	83.84	83.93	402000.0
2007-06-20 12:00:00	TLT	Stock	83.92	83.96	83.83	83.85	81500.0
2007-06-20 13:00:00	TLT	Stock	83.84	83.84	83.64	83.7	237900.0
2007-06-20 14:00:00	TLT	Stock	83.7	83.9	83.69	83.84	169200.0
2007-06-20 15:00:00	TLT	Stock	83.84	83.84	83.59	83.69	440600.0
2007-06-20 16:00:00	TLT	Stock	83.62	83.62	83.62	83.62	200.0
2007-06-20 08:00:00	CL	Stock	33.11	33.25	32.86	33.25	13200.0
2007-06-20 09:00:00	CL	Stock	32.86	33.37	32.86	33.295	1328000.0

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

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