PREVIEW / stock_1hour / 2005-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-03.parquet
  size:    578 KB
  rows:    27,080
  symbols: 2,095

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
2005-11-03 08:00:00	AAPL	Stock	2.1557	2.1754	2.1518	2.1711	7568540.0
2005-11-03 09:00:00	AAPL	Stock	2.1711	2.205	2.1454	2.1982	166531876.0
2005-11-03 10:00:00	AAPL	Stock	2.1986	2.2218	2.1946	2.2061	179710972.0
2005-11-03 11:00:00	AAPL	Stock	2.2064	2.2182	2.2	2.2071	108221120.0
2005-11-03 12:00:00	AAPL	Stock	2.2071	2.2257	2.2042	2.2121	120371020.0
2005-11-03 13:00:00	AAPL	Stock	2.2124	2.2171	2.2043	2.2079	66779972.0
2005-11-03 14:00:00	AAPL	Stock	2.2075	2.2118	2.1839	2.2032	112427280.0
2005-11-03 15:00:00	AAPL	Stock	2.2029	2.2129	2.1911	2.2089	108730944.0
2005-11-03 16:00:00	AAPL	Stock	2.2096	2.2136	2.2075	2.2125	3965472.0
2005-11-03 17:00:00	AAPL	Stock	2.2114	2.2132	2.2086	2.2086	606312.0
2005-11-03 18:00:00	AAPL	Stock	2.2086	2.2104	2.2071	2.2104	183260.0
2005-11-03 08:00:00	MSFT	Stock	26.46	26.68	26.45	26.62	115481.0
2005-11-03 09:00:00	MSFT	Stock	26.62	26.7	26.32	26.36	8997327.0
2005-11-03 10:00:00	MSFT	Stock	26.37	26.47	26.25	26.43	13163285.0
2005-11-03 11:00:00	MSFT	Stock	26.43	26.5	26.35	26.46	12993170.0
2005-11-03 12:00:00	MSFT	Stock	26.46	26.551	26.41	26.46	7309777.0
2005-11-03 13:00:00	MSFT	Stock	26.462	26.51	26.35	26.48	6822967.0
2005-11-03 14:00:00	MSFT	Stock	26.48	26.52	26.43	26.46	7628924.0
2005-11-03 15:00:00	MSFT	Stock	26.46	26.53	26.39	26.46	12170113.0
2005-11-03 16:00:00	MSFT	Stock	26.44	26.5	26.37	26.4	563513.0
2005-11-03 17:00:00	MSFT	Stock	26.4	26.44	26.38	26.4	30156.0
2005-11-03 18:00:00	MSFT	Stock	26.38	26.4	26.38	26.4	2975.0
2005-11-03 08:00:00	NVDA	Stock	0.2937	0.2946	0.2922	0.2946	576240.0
2005-11-03 09:00:00	NVDA	Stock	0.2927	0.2958	0.2893	0.2939	88684920.0
2005-11-03 10:00:00	NVDA	Stock	0.2938	0.2953	0.2922	0.2925	103835400.0
2005-11-03 11:00:00	NVDA	Stock	0.2925	0.2927	0.2907	0.2918	50410920.0
2005-11-03 12:00:00	NVDA	Stock	0.2917	0.2937	0.2915	0.2925	37531080.0
2005-11-03 13:00:00	NVDA	Stock	0.2925	0.2927	0.2884	0.2889	37932840.0
2005-11-03 14:00:00	NVDA	Stock	0.2887	0.2916	0.2867	0.2879	69347040.0
2005-11-03 15:00:00	NVDA	Stock	0.2881	0.289	0.2864	0.2887	66236880.0
2005-11-03 16:00:00	NVDA	Stock	0.2886	0.2887	0.2879	0.2887	991560.0
2005-11-03 08:00:00	AMZN	Stock	2.0435	2.05	2.0435	2.05	94000.0
2005-11-03 09:00:00	AMZN	Stock	2.05	2.0735	2.0425	2.051	19411380.0
2005-11-03 10:00:00	AMZN	Stock	2.051	2.085	2.051	2.0675	16946040.0
2005-11-03 11:00:00	AMZN	Stock	2.0675	2.0825	2.0635	2.066	12779060.0
2005-11-03 12:00:00	AMZN	Stock	2.066	2.081	2.066	2.0765	13860840.0
2005-11-03 13:00:00	AMZN	Stock	2.0765	2.1	2.0635	2.0655	29665000.0
2005-11-03 14:00:00	AMZN	Stock	2.065	2.0735	2.056	2.071	21018300.0
2005-11-03 15:00:00	AMZN	Stock	2.0705	2.079	2.062	2.075	22212760.0
2005-11-03 16:00:00	AMZN	Stock	2.073	2.078	2.0725	2.078	512880.0
2005-11-03 17:00:00	AMZN	Stock	2.0825	2.0825	2.0825	2.0825	4000.0
2005-11-03 08:00:00	CL	Stock	26.145	26.145	26.145	26.145	28000.0
2005-11-03 09:00:00	CL	Stock	26.15	26.3	26.145	26.205	524000.0
2005-11-03 10:00:00	CL	Stock	26.15	26.205	25.945	25.97	960000.0
2005-11-03 11:00:00	CL	Stock	25.97	26.064	25.915	25.98	707400.0
2005-11-03 12:00:00	CL	Stock	25.98	26.045	25.975	25.991	1116000.0
2005-11-03 13:00:00	CL	Stock	25.99	25.995	25.905	25.905	973200.0
2005-11-03 14:00:00	CL	Stock	25.905	25.99	25.875	25.905	1019800.0
2005-11-03 15:00:00	CL	Stock	25.905	26.04	25.875	26.0	931000.0

> showing 49 of 27,080 rows — these rows as CSV

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