PREVIEW / stock_1hour / 2006-03-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-03.parquet
  size:    612 KB
  rows:    28,829
  symbols: 2,191

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
2006-03-03 04:00:00	AAPL	Stock	2.4839	2.4839	2.4839	2.4839	28000.0
2006-03-03 07:00:00	AAPL	Stock	2.48	2.48	2.48	2.48	2800.0
2006-03-03 08:00:00	AAPL	Stock	2.4854	2.4907	2.4804	2.4818	1668324.0
2006-03-03 09:00:00	AAPL	Stock	2.4818	2.4968	2.4679	2.4818	76468588.0
2006-03-03 10:00:00	AAPL	Stock	2.4821	2.4889	2.4654	2.4707	83056036.0
2006-03-03 11:00:00	AAPL	Stock	2.4707	2.4743	2.4614	2.4721	71680700.0
2006-03-03 12:00:00	AAPL	Stock	2.4721	2.4818	2.4686	2.4764	60090576.0
2006-03-03 13:00:00	AAPL	Stock	2.4764	2.4768	2.4589	2.4625	72920820.0
2006-03-03 14:00:00	AAPL	Stock	2.4625	2.4679	2.4254	2.4346	157037832.0
2006-03-03 15:00:00	AAPL	Stock	2.4346	2.4593	2.4118	2.4182	203247492.0
2006-03-03 16:00:00	AAPL	Stock	2.4182	2.4214	2.4154	2.4157	2512020.0
2006-03-03 17:00:00	AAPL	Stock	2.4157	2.4186	2.4089	2.4186	1459556.0
2006-03-03 18:00:00	AAPL	Stock	2.4132	2.4179	2.4132	2.4143	145600.0
2006-03-03 06:00:00	MSFT	Stock	26.97	26.97	26.97	26.97	1000.0
2006-03-03 08:00:00	MSFT	Stock	26.95	26.95	26.93	26.93	10150.0
2006-03-03 09:00:00	MSFT	Stock	26.91	26.92	26.75	26.78	5936216.0
2006-03-03 10:00:00	MSFT	Stock	26.79	26.91	26.74	26.88	7465768.0
2006-03-03 11:00:00	MSFT	Stock	26.88	26.95	26.75	26.89	4917251.0
2006-03-03 12:00:00	MSFT	Stock	26.882	27.04	26.85	27.03	5051767.0
2006-03-03 13:00:00	MSFT	Stock	27.02	27.16	26.95	27.08	5687928.0
2006-03-03 14:00:00	MSFT	Stock	27.09	27.12	27.02	27.09	4394696.0
2006-03-03 15:00:00	MSFT	Stock	27.08	27.09	26.87	26.93	10532785.0
2006-03-03 16:00:00	MSFT	Stock	26.93	27.1	26.89	26.91	212244.0
2006-03-03 17:00:00	MSFT	Stock	26.91	26.92	26.89	26.92	25700.0
2006-03-03 18:00:00	MSFT	Stock	26.91	26.92	26.91	26.91	15300.0
2006-03-03 09:00:00	NVDA	Stock	0.4042	0.4127	0.403	0.4096	100469400.0
2006-03-03 10:00:00	NVDA	Stock	0.4094	0.4133	0.4058	0.4107	86282760.0
2006-03-03 11:00:00	NVDA	Stock	0.4106	0.4132	0.4092	0.4119	57796920.0
2006-03-03 12:00:00	NVDA	Stock	0.4118	0.4147	0.4102	0.4132	52973160.0
2006-03-03 13:00:00	NVDA	Stock	0.4132	0.4152	0.4123	0.414	33836040.0
2006-03-03 14:00:00	NVDA	Stock	0.414	0.4167	0.4124	0.4157	101505960.0
2006-03-03 15:00:00	NVDA	Stock	0.4158	0.416	0.4095	0.4098	149341080.0
2006-03-03 16:00:00	NVDA	Stock	0.4097	0.4101	0.4092	0.4098	1294560.0
2006-03-03 17:00:00	NVDA	Stock	0.4092	0.4092	0.4092	0.4092	12000.0
2006-03-03 08:00:00	AMZN	Stock	1.862	1.8645	1.856	1.856	124000.0
2006-03-03 09:00:00	AMZN	Stock	1.856	1.8625	1.8335	1.8425	15106760.0
2006-03-03 10:00:00	AMZN	Stock	1.8435	1.8765	1.835	1.8616	26702180.0
2006-03-03 11:00:00	AMZN	Stock	1.8615	1.8665	1.8555	1.8645	10703980.0
2006-03-03 12:00:00	AMZN	Stock	1.865	1.8795	1.8605	1.875	11149100.0
2006-03-03 13:00:00	AMZN	Stock	1.875	1.8915	1.87	1.884	19364900.0
2006-03-03 14:00:00	AMZN	Stock	1.884	1.8885	1.87	1.877	8806940.0
2006-03-03 15:00:00	AMZN	Stock	1.877	1.8775	1.855	1.8605	26036500.0
2006-03-03 16:00:00	AMZN	Stock	1.863	1.867	1.8605	1.8645	263260.0
2006-03-03 17:00:00	AMZN	Stock	1.8605	1.8605	1.8605	1.8605	3000.0
2006-03-03 18:00:00	AMZN	Stock	1.864	1.864	1.864	1.864	2000.0
2006-03-03 09:00:00	CL	Stock	27.18	27.35	27.17	27.285	208800.0
2006-03-03 10:00:00	CL	Stock	27.295	27.41	27.275	27.395	538600.0
2006-03-03 11:00:00	CL	Stock	27.39	27.395	27.305	27.375	239600.0
2006-03-03 12:00:00	CL	Stock	27.385	27.52	27.35	27.48	368200.0
2006-03-03 13:00:00	CL	Stock	27.48	27.645	27.475	27.612	344200.0

> showing 50 of 28,829 rows — these rows as CSV

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