PREVIEW / stock_1hour / 2007-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-12.parquet
  size:    754 KB
  rows:    37,513
  symbols: 3,114

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-09-12 09:00:00	AAPL	Stock	4.8571	4.9071	4.8482	4.8986	126175812.0
2007-09-12 10:00:00	AAPL	Stock	4.8986	4.9568	4.8971	4.9414	205650312.0
2007-09-12 11:00:00	AAPL	Stock	4.9411	4.9786	4.9321	4.9446	127321992.0
2007-09-12 12:00:00	AAPL	Stock	4.9446	4.9525	4.9111	4.9318	105937020.0
2007-09-12 13:00:00	AAPL	Stock	4.9315	4.9414	4.9075	4.935	87592820.0
2007-09-12 14:00:00	AAPL	Stock	4.935	4.9464	4.9007	4.9196	105605360.0
2007-09-12 15:00:00	AAPL	Stock	4.9193	4.92	4.875	4.8868	153224988.0
2007-09-12 16:00:00	AAPL	Stock	4.8857	4.8889	4.8857	4.8875	8705200.0
2007-09-12 09:00:00	MSFT	Stock	28.81	28.99	28.8	28.99	2401950.0
2007-09-12 10:00:00	MSFT	Stock	28.98	28.99	28.9	28.98	4042415.0
2007-09-12 11:00:00	MSFT	Stock	28.99	29.17	28.96	29.04	4849114.0
2007-09-12 12:00:00	MSFT	Stock	29.049	29.11	28.99	29.05	3607181.0
2007-09-12 13:00:00	MSFT	Stock	29.05	29.14	28.94	29.11	4044496.0
2007-09-12 14:00:00	MSFT	Stock	29.1	29.13	29.019	29.06	3289796.0
2007-09-12 15:00:00	MSFT	Stock	29.07	29.08	28.88	28.91	7952403.0
2007-09-12 16:00:00	MSFT	Stock	28.9	28.93	28.9	28.93	1764537.0
2007-09-12 08:00:00	NVDA	Stock	0.8625	0.8658	0.8625	0.8658	74160.0
2007-09-12 09:00:00	NVDA	Stock	0.8658	0.8742	0.8625	0.8688	43291120.0
2007-09-12 10:00:00	NVDA	Stock	0.8688	0.8735	0.8612	0.871	63760560.0
2007-09-12 11:00:00	NVDA	Stock	0.8712	0.878	0.8708	0.8765	46862800.0
2007-09-12 12:00:00	NVDA	Stock	0.8765	0.8768	0.8672	0.8695	47091560.0
2007-09-12 13:00:00	NVDA	Stock	0.8692	0.87	0.8608	0.8615	52625520.0
2007-09-12 14:00:00	NVDA	Stock	0.8612	0.8658	0.8302	0.832	94546720.0
2007-09-12 15:00:00	NVDA	Stock	0.8315	0.8375	0.822	0.831	164066640.0
2007-09-12 16:00:00	NVDA	Stock	0.831	0.8325	0.8302	0.831	14766560.0
2007-09-12 17:00:00	NVDA	Stock	0.8312	0.8398	0.83	0.8352	228360.0
2007-09-12 18:00:00	NVDA	Stock	0.8352	0.8375	0.831	0.831	137600.0
2007-09-12 19:00:00	NVDA	Stock	0.8355	0.8358	0.8312	0.8358	59400.0
2007-09-12 07:00:00	AMZN	Stock	4.275	4.285	4.275	4.285	4000.0
2007-09-12 08:00:00	AMZN	Stock	4.2875	4.302	4.27	4.286	278100.0
2007-09-12 09:00:00	AMZN	Stock	4.291	4.4125	4.2875	4.3965	30415020.0
2007-09-12 10:00:00	AMZN	Stock	4.396	4.425	4.373	4.3905	34730620.0
2007-09-12 11:00:00	AMZN	Stock	4.3906	4.4445	4.39	4.4307	22108820.0
2007-09-12 12:00:00	AMZN	Stock	4.431	4.4355	4.3905	4.3939	14305580.0
2007-09-12 13:00:00	AMZN	Stock	4.3935	4.396	4.3705	4.378	15752880.0
2007-09-12 14:00:00	AMZN	Stock	4.3785	4.3935	4.362	4.387	17898340.0
2007-09-12 15:00:00	AMZN	Stock	4.3875	4.3925	4.347	4.3655	26508200.0
2007-09-12 16:00:00	AMZN	Stock	4.3655	4.37	4.3615	4.3675	1023160.0
2007-09-12 17:00:00	AMZN	Stock	4.3645	4.37	4.363	4.363	16000.0
2007-09-12 18:00:00	AMZN	Stock	4.372	4.3865	4.372	4.3865	176000.0
2007-09-12 19:00:00	AMZN	Stock	4.38	4.38	4.375	4.375	27000.0
2007-09-12 09:00:00	TLT	Stock	90.9	90.94	90.74	90.83	238800.0
2007-09-12 10:00:00	TLT	Stock	90.82	90.88	90.62	90.71	173600.0
2007-09-12 11:00:00	TLT	Stock	90.73	90.73	90.45	90.56	164300.0
2007-09-12 12:00:00	TLT	Stock	90.55	90.67	90.5	90.64	1823650.0
2007-09-12 13:00:00	TLT	Stock	90.64	90.75	90.57	90.6	1200200.0
2007-09-12 14:00:00	TLT	Stock	90.59	90.61	90.42	90.47	643000.0
2007-09-12 15:00:00	TLT	Stock	90.46	90.57	90.46	90.57	155100.0
2007-09-12 16:00:00	TLT	Stock	90.5	90.59	90.5	90.59	1100.0
2007-09-12 09:00:00	CL	Stock	33.61	33.69	33.395	33.55	322400.0

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

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