PREVIEW / stock_1hour / 2007-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-14.parquet
  size:    755 KB
  rows:    37,019
  symbols: 3,028

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-14 09:00:00	AAPL	Stock	4.1857	4.2604	4.1579	4.2475	221092592.0
2007-06-14 10:00:00	AAPL	Stock	4.2475	4.2554	4.2171	4.2214	192818892.0
2007-06-14 11:00:00	AAPL	Stock	4.2218	4.2443	4.2171	4.2225	103818960.0
2007-06-14 12:00:00	AAPL	Stock	4.2225	4.2471	4.2211	4.2418	65271752.0
2007-06-14 13:00:00	AAPL	Stock	4.2418	4.2661	4.2315	4.2464	113907864.0
2007-06-14 14:00:00	AAPL	Stock	4.2461	4.2571	4.2375	4.2489	85601656.0
2007-06-14 15:00:00	AAPL	Stock	4.2489	4.2625	4.2371	4.2454	139749400.0
2007-06-14 16:00:00	AAPL	Stock	4.2457	4.2464	4.2411	4.2411	27281240.0
2007-06-14 09:00:00	MSFT	Stock	30.35	30.56	30.3	30.56	4565545.0
2007-06-14 10:00:00	MSFT	Stock	30.56	30.69	30.54	30.62	9601750.0
2007-06-14 11:00:00	MSFT	Stock	30.63	30.65	30.57	30.58	4711169.0
2007-06-14 12:00:00	MSFT	Stock	30.58	30.7	30.56	30.611	5380030.0
2007-06-14 13:00:00	MSFT	Stock	30.62	30.71	30.6	30.67	5152579.0
2007-06-14 14:00:00	MSFT	Stock	30.675	30.69	30.57	30.63	8821664.0
2007-06-14 15:00:00	MSFT	Stock	30.63	30.7	30.5	30.56	14948889.0
2007-06-14 16:00:00	MSFT	Stock	30.56	30.56	30.52	30.52	1941876.0
2007-06-14 08:00:00	NVDA	Stock	0.62	0.62	0.6158	0.6158	148200.0
2007-06-14 09:00:00	NVDA	Stock	0.6202	0.6257	0.6158	0.6253	60123780.0
2007-06-14 10:00:00	NVDA	Stock	0.6252	0.6253	0.6178	0.6222	62056860.0
2007-06-14 11:00:00	NVDA	Stock	0.6222	0.6247	0.6208	0.6245	52980000.0
2007-06-14 12:00:00	NVDA	Stock	0.6247	0.6315	0.6245	0.6305	93283320.0
2007-06-14 13:00:00	NVDA	Stock	0.6305	0.6328	0.6292	0.6322	44995440.0
2007-06-14 14:00:00	NVDA	Stock	0.6322	0.6322	0.6288	0.6312	51831480.0
2007-06-14 15:00:00	NVDA	Stock	0.631	0.6327	0.6292	0.6308	86459580.0
2007-06-14 16:00:00	NVDA	Stock	0.6307	0.6308	0.6266	0.6278	8765700.0
2007-06-14 17:00:00	NVDA	Stock	0.6292	0.6292	0.628	0.6292	126000.0
2007-06-14 18:00:00	NVDA	Stock	0.6292	0.6292	0.6292	0.6292	60000.0
2007-06-14 19:00:00	NVDA	Stock	0.6282	0.6282	0.6282	0.6282	72000.0
2007-06-14 07:00:00	AMZN	Stock	3.511	3.5375	3.5105	3.537	49200.0
2007-06-14 08:00:00	AMZN	Stock	3.5345	3.54	3.5255	3.5315	131320.0
2007-06-14 09:00:00	AMZN	Stock	3.525	3.587	3.523	3.5835	25902520.0
2007-06-14 10:00:00	AMZN	Stock	3.583	3.5895	3.5655	3.579	24030780.0
2007-06-14 11:00:00	AMZN	Stock	3.579	3.581	3.5555	3.5596	18848960.0
2007-06-14 12:00:00	AMZN	Stock	3.5605	3.606	3.559	3.5885	20959660.0
2007-06-14 13:00:00	AMZN	Stock	3.5885	3.5975	3.5825	3.587	12838840.0
2007-06-14 14:00:00	AMZN	Stock	3.587	3.5985	3.5765	3.588	18396700.0
2007-06-14 15:00:00	AMZN	Stock	3.588	3.6025	3.5855	3.6005	33388500.0
2007-06-14 16:00:00	AMZN	Stock	3.6	3.603	3.5965	3.5975	7332460.0
2007-06-14 17:00:00	AMZN	Stock	3.6	3.604	3.6	3.6025	31000.0
2007-06-14 18:00:00	AMZN	Stock	3.601	3.604	3.5975	3.604	66000.0
2007-06-14 19:00:00	AMZN	Stock	3.605	3.605	3.605	3.605	4000.0
2007-06-14 09:00:00	TLT	Stock	83.14	83.53	83.13	83.51	379820.0
2007-06-14 10:00:00	TLT	Stock	83.52	83.71	83.33	83.65	1351500.0
2007-06-14 11:00:00	TLT	Stock	83.64	83.64	83.1	83.25	502900.0
2007-06-14 12:00:00	TLT	Stock	83.27	83.37	83.19	83.29	232400.0
2007-06-14 13:00:00	TLT	Stock	83.3	83.33	83.14	83.29	125200.0
2007-06-14 14:00:00	TLT	Stock	83.27	83.28	83.13	83.15	223500.0
2007-06-14 15:00:00	TLT	Stock	83.15	83.18	83.05	83.08	489800.0
2007-06-14 16:00:00	TLT	Stock	83.11	83.13	83.09	83.12	11500.0
2007-06-14 08:00:00	CL	Stock	33.395	33.5	33.395	33.5	600.0

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

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