PREVIEW / stock_1hour / 2007-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-23.parquet
  size:    797 KB
  rows:    39,320
  symbols: 3,153

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-10-23 04:00:00	AAPL	Stock	6.6436	6.6486	6.6257	6.6257	182000.0
2007-10-23 06:00:00	AAPL	Stock	6.6393	6.6925	6.6393	6.6925	325024.0
2007-10-23 07:00:00	AAPL	Stock	6.6857	6.7275	6.6636	6.7125	7684684.0
2007-10-23 08:00:00	AAPL	Stock	6.7071	7.0575	6.6721	6.7061	35328860.0
2007-10-23 09:00:00	AAPL	Stock	6.705	6.7768	6.5271	6.6357	533578332.0
2007-10-23 10:00:00	AAPL	Stock	6.6368	6.6743	6.62	6.6436	349640284.0
2007-10-23 11:00:00	AAPL	Stock	6.6425	6.65	6.6018	6.6271	220710896.0
2007-10-23 12:00:00	AAPL	Stock	6.6271	6.6443	6.6179	6.6311	104554296.0
2007-10-23 13:00:00	AAPL	Stock	6.6307	6.6321	6.605	6.6254	100558668.0
2007-10-23 14:00:00	AAPL	Stock	6.6254	6.6986	6.6211	6.6857	186193812.0
2007-10-23 15:00:00	AAPL	Stock	6.6857	6.7089	6.6304	6.6486	247356620.0
2007-10-23 16:00:00	AAPL	Stock	6.6471	6.7257	6.2271	6.5946	14833812.0
2007-10-23 17:00:00	AAPL	Stock	6.5979	6.6415	6.2211	6.5911	2801204.0
2007-10-23 18:00:00	AAPL	Stock	6.5929	6.6	6.5589	6.5589	1608992.0
2007-10-23 19:00:00	AAPL	Stock	6.5625	6.5714	6.5554	6.5711	1224328.0
2007-10-23 04:00:00	MSFT	Stock	30.6	30.66	30.6	30.66	200.0
2007-10-23 05:00:00	MSFT	Stock	30.69	30.7	30.69	30.7	500.0
2007-10-23 08:00:00	MSFT	Stock	30.76	30.78	30.71	30.73	60227.0
2007-10-23 09:00:00	MSFT	Stock	30.73	30.91	30.65	30.84	7013878.0
2007-10-23 10:00:00	MSFT	Stock	30.84	31.12	30.78	30.879	11619353.0
2007-10-23 11:00:00	MSFT	Stock	30.88	31.0	30.74	30.98	6363822.0
2007-10-23 12:00:00	MSFT	Stock	30.98	30.98	30.779	30.85	4020074.0
2007-10-23 13:00:00	MSFT	Stock	30.85	30.92	30.84	30.85	3165028.0
2007-10-23 14:00:00	MSFT	Stock	30.85	30.94	30.81	30.86	6257748.0
2007-10-23 15:00:00	MSFT	Stock	30.86	30.92	30.78	30.9	9052446.0
2007-10-23 16:00:00	MSFT	Stock	30.9	30.91	30.335	30.85	2399483.0
2007-10-23 17:00:00	MSFT	Stock	30.81	30.85	30.55	30.8	46326.0
2007-10-23 18:00:00	MSFT	Stock	30.8	30.82	30.78	30.8	31424.0
2007-10-23 19:00:00	MSFT	Stock	30.8	30.9	30.79	30.85	25606.0
2007-10-23 07:00:00	NVDA	Stock	0.9825	0.9825	0.9825	0.9825	8000.0
2007-10-23 08:00:00	NVDA	Stock	0.9925	1.0	0.979	0.9975	1797680.0
2007-10-23 09:00:00	NVDA	Stock	0.9972	0.9972	0.9652	0.9675	51301960.0
2007-10-23 10:00:00	NVDA	Stock	0.9675	0.975	0.96	0.9685	41032600.0
2007-10-23 11:00:00	NVDA	Stock	0.9682	0.9688	0.959	0.9648	32824920.0
2007-10-23 12:00:00	NVDA	Stock	0.9648	0.9685	0.957	0.9652	26106120.0
2007-10-23 13:00:00	NVDA	Stock	0.9652	0.9668	0.9598	0.9638	33352400.0
2007-10-23 14:00:00	NVDA	Stock	0.964	0.9768	0.9628	0.9745	43308120.0
2007-10-23 15:00:00	NVDA	Stock	0.974	0.9838	0.973	0.9838	50991640.0
2007-10-23 16:00:00	NVDA	Stock	0.9838	0.9838	0.9698	0.9838	12941280.0
2007-10-23 17:00:00	NVDA	Stock	0.9718	0.9792	0.9602	0.9662	861680.0
2007-10-23 18:00:00	NVDA	Stock	0.9675	0.9725	0.9675	0.9725	48000.0
2007-10-23 19:00:00	NVDA	Stock	0.9728	0.9738	0.969	0.97	168000.0
2007-10-23 05:00:00	AMZN	Stock	4.7	4.7	4.7	4.7	2000.0
2007-10-23 06:00:00	AMZN	Stock	4.675	4.675	4.675	4.675	6000.0
2007-10-23 07:00:00	AMZN	Stock	4.7	4.712	4.6755	4.692	206200.0
2007-10-23 08:00:00	AMZN	Stock	4.691	4.75	4.6795	4.73	3952060.0
2007-10-23 09:00:00	AMZN	Stock	4.7335	4.772	4.7105	4.7315	66344240.0
2007-10-23 10:00:00	AMZN	Stock	4.7325	4.746	4.7185	4.729	53827140.0
2007-10-23 11:00:00	AMZN	Stock	4.729	4.7495	4.7205	4.74	59061860.0
2007-10-23 12:00:00	AMZN	Stock	4.74	4.7465	4.737	4.7415	42091400.0

> showing 50 of 39,320 rows — these rows as CSV

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