PREVIEW / stock_1hour / 2007-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-13.parquet
  size:    758 KB
  rows:    37,171
  symbols: 3,023

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-13 09:00:00	AAPL	Stock	4.3268	4.3282	4.2632	4.2875	135999836.0
2007-06-13 10:00:00	AAPL	Stock	4.2871	4.2993	4.2475	4.2536	198027424.0
2007-06-13 11:00:00	AAPL	Stock	4.2536	4.2675	4.1696	4.1825	369275928.0
2007-06-13 12:00:00	AAPL	Stock	4.1825	4.1868	4.1214	4.1421	295710324.0
2007-06-13 13:00:00	AAPL	Stock	4.1421	4.1704	4.1268	4.165	163797536.0
2007-06-13 14:00:00	AAPL	Stock	4.165	4.2129	4.1354	4.1471	247544584.0
2007-06-13 15:00:00	AAPL	Stock	4.1468	4.1968	4.1404	4.1961	265627964.0
2007-06-13 16:00:00	AAPL	Stock	4.1964	4.1968	4.195	4.1964	8638700.0
2007-06-13 09:00:00	MSFT	Stock	29.97	30.13	29.85	30.09	4216600.0
2007-06-13 10:00:00	MSFT	Stock	30.092	30.13	29.99	30.04	12390159.0
2007-06-13 11:00:00	MSFT	Stock	30.04	30.1	29.97	30.058	4893120.0
2007-06-13 12:00:00	MSFT	Stock	30.055	30.13	30.01	30.05	5344344.0
2007-06-13 13:00:00	MSFT	Stock	30.05	30.12	29.96	30.1	5908489.0
2007-06-13 14:00:00	MSFT	Stock	30.092	30.25	30.09	30.24	9708451.0
2007-06-13 15:00:00	MSFT	Stock	30.24	30.41	30.103	30.39	19340587.0
2007-06-13 16:00:00	MSFT	Stock	30.39	30.39	30.39	30.39	1305955.0
2007-06-13 08:00:00	NVDA	Stock	0.6083	0.6117	0.6083	0.611	335100.0
2007-06-13 09:00:00	NVDA	Stock	0.6108	0.6133	0.605	0.6082	36037860.0
2007-06-13 10:00:00	NVDA	Stock	0.6082	0.6153	0.6038	0.613	109437960.0
2007-06-13 11:00:00	NVDA	Stock	0.6128	0.6133	0.6113	0.6117	50713740.0
2007-06-13 12:00:00	NVDA	Stock	0.6117	0.6128	0.6105	0.6113	52977420.0
2007-06-13 13:00:00	NVDA	Stock	0.6113	0.6123	0.6103	0.611	59659320.0
2007-06-13 14:00:00	NVDA	Stock	0.611	0.6167	0.6108	0.6162	107869740.0
2007-06-13 15:00:00	NVDA	Stock	0.6162	0.6197	0.6153	0.6195	138452460.0
2007-06-13 16:00:00	NVDA	Stock	0.6195	0.6195	0.6158	0.6158	9690000.0
2007-06-13 18:00:00	NVDA	Stock	0.617	0.617	0.616	0.616	143220.0
2007-06-13 19:00:00	NVDA	Stock	0.6173	0.6173	0.6173	0.6173	66000.0
2007-06-13 07:00:00	AMZN	Stock	3.51	3.51	3.51	3.51	4000.0
2007-06-13 08:00:00	AMZN	Stock	3.5235	3.53	3.5025	3.5275	207180.0
2007-06-13 09:00:00	AMZN	Stock	3.5295	3.572	3.519	3.554	29913460.0
2007-06-13 10:00:00	AMZN	Stock	3.5545	3.5945	3.537	3.5814	44014900.0
2007-06-13 11:00:00	AMZN	Stock	3.5812	3.584	3.5345	3.5415	30672780.0
2007-06-13 12:00:00	AMZN	Stock	3.5425	3.5485	3.514	3.5325	23305720.0
2007-06-13 13:00:00	AMZN	Stock	3.5325	3.534	3.4625	3.497	34077680.0
2007-06-13 14:00:00	AMZN	Stock	3.4985	3.5425	3.49	3.538	30331120.0
2007-06-13 15:00:00	AMZN	Stock	3.5382	3.5702	3.5225	3.545	32639180.0
2007-06-13 16:00:00	AMZN	Stock	3.545	3.5625	3.542	3.545	2057100.0
2007-06-13 17:00:00	AMZN	Stock	3.542	3.5435	3.542	3.543	59000.0
2007-06-13 18:00:00	AMZN	Stock	3.5445	3.547	3.543	3.544	219380.0
2007-06-13 19:00:00	AMZN	Stock	3.5445	3.561	3.5445	3.561	54400.0
2007-06-13 09:00:00	TLT	Stock	82.7	82.98	82.65	82.79	1320300.0
2007-06-13 10:00:00	TLT	Stock	82.78	83.23	82.71	83.04	2124200.0
2007-06-13 11:00:00	TLT	Stock	83.03	83.14	82.89	83.02	961600.0
2007-06-13 12:00:00	TLT	Stock	83.01	83.28	82.94	83.15	754800.0
2007-06-13 13:00:00	TLT	Stock	83.14	83.76	82.94	83.17	1007000.0
2007-06-13 14:00:00	TLT	Stock	83.17	83.39	83.11	83.38	712400.0
2007-06-13 15:00:00	TLT	Stock	83.38	83.4	83.13	83.21	989000.0
2007-06-13 16:00:00	TLT	Stock	83.14	83.33	83.14	83.33	14600.0
2007-06-13 08:00:00	CL	Stock	33.5	33.5	33.5	33.5	200.0
2007-06-13 09:00:00	CL	Stock	33.765	33.895	33.745	33.84	522800.0

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

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