PREVIEW / stock_1hour / 2005-03-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-08.parquet
  size:    540 KB
  rows:    25,292
  symbols: 1,934

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-03-08 08:00:00	AAPL	Stock	1.5143	1.5143	1.4857	1.4939	6907628.0
2005-03-08 09:00:00	AAPL	Stock	1.4918	1.5164	1.4764	1.4964	153025572.0
2005-03-08 10:00:00	AAPL	Stock	1.4964	1.4989	1.4321	1.4525	363328924.0
2005-03-08 11:00:00	AAPL	Stock	1.4529	1.4961	1.4436	1.4696	129630228.0
2005-03-08 12:00:00	AAPL	Stock	1.47	1.4707	1.4593	1.4629	69693624.0
2005-03-08 13:00:00	AAPL	Stock	1.4625	1.4757	1.4554	1.4554	72237984.0
2005-03-08 14:00:00	AAPL	Stock	1.4554	1.4646	1.4525	1.4607	92330616.0
2005-03-08 15:00:00	AAPL	Stock	1.4611	1.4929	1.4464	1.4464	114047668.0
2005-03-08 16:00:00	AAPL	Stock	1.4493	1.4554	1.4468	1.4518	7865284.0
2005-03-08 17:00:00	AAPL	Stock	1.4518	1.4536	1.4468	1.4482	807772.0
2005-03-08 18:00:00	AAPL	Stock	1.4479	1.4521	1.4479	1.4521	43400.0
2005-03-08 08:00:00	MSFT	Stock	25.42	25.47	25.41	25.42	9786.0
2005-03-08 09:00:00	MSFT	Stock	25.42	25.62	25.37	25.599	6724574.0
2005-03-08 10:00:00	MSFT	Stock	25.6	25.62	25.45	25.51	12976763.0
2005-03-08 11:00:00	MSFT	Stock	25.51	25.52	25.45	25.46	5446331.0
2005-03-08 12:00:00	MSFT	Stock	25.47	25.491	25.44	25.45	3776157.0
2005-03-08 13:00:00	MSFT	Stock	25.45	25.48	25.36	25.38	5216011.0
2005-03-08 14:00:00	MSFT	Stock	25.38	25.43	25.36	25.402	5892325.0
2005-03-08 15:00:00	MSFT	Stock	25.41	25.45	25.34	25.41	9432811.0
2005-03-08 16:00:00	MSFT	Stock	25.4	25.43	25.38	25.41	234727.0
2005-03-08 17:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	18968.0
2005-03-08 18:00:00	MSFT	Stock	25.4	25.4	25.38	25.38	50009.0
2005-03-08 08:00:00	NVDA	Stock	0.2312	0.2312	0.2312	0.2312	24000.0
2005-03-08 09:00:00	NVDA	Stock	0.2318	0.2321	0.2221	0.2232	288650040.0
2005-03-08 10:00:00	NVDA	Stock	0.2231	0.2237	0.2188	0.2212	337996440.0
2005-03-08 11:00:00	NVDA	Stock	0.2212	0.2311	0.2191	0.2217	159181320.0
2005-03-08 12:00:00	NVDA	Stock	0.2216	0.2224	0.2204	0.2224	84844560.0
2005-03-08 13:00:00	NVDA	Stock	0.2224	0.224	0.2208	0.2225	127586280.0
2005-03-08 14:00:00	NVDA	Stock	0.2226	0.223	0.2211	0.2216	94721400.0
2005-03-08 15:00:00	NVDA	Stock	0.2217	0.2218	0.2196	0.2198	217136880.0
2005-03-08 16:00:00	NVDA	Stock	0.2201	0.2216	0.2197	0.2212	11771760.0
2005-03-08 17:00:00	NVDA	Stock	0.2212	0.2212	0.221	0.2212	78000.0
2005-03-08 18:00:00	NVDA	Stock	0.2212	0.2212	0.2212	0.2212	120000.0
2005-03-08 08:00:00	AMZN	Stock	1.82	1.82	1.815	1.815	60600.0
2005-03-08 09:00:00	AMZN	Stock	1.816	1.8205	1.8125	1.8155	9027380.0
2005-03-08 10:00:00	AMZN	Stock	1.8155	1.8185	1.8105	1.8135	9355740.0
2005-03-08 11:00:00	AMZN	Stock	1.8135	1.8195	1.8105	1.8175	11995640.0
2005-03-08 12:00:00	AMZN	Stock	1.8175	1.8215	1.8135	1.814	9977440.0
2005-03-08 13:00:00	AMZN	Stock	1.814	1.817	1.8125	1.8125	11975960.0
2005-03-08 14:00:00	AMZN	Stock	1.812	1.8145	1.8095	1.81	10412700.0
2005-03-08 15:00:00	AMZN	Stock	1.81	1.81	1.7875	1.79	31100860.0
2005-03-08 16:00:00	AMZN	Stock	1.7895	1.7915	1.7895	1.7915	224060.0
2005-03-08 17:00:00	AMZN	Stock	1.7905	1.7935	1.7905	1.7935	15220.0
2005-03-08 09:00:00	CL	Stock	26.44	26.45	26.325	26.355	241000.0
2005-03-08 10:00:00	CL	Stock	26.355	26.4	26.34	26.4	381200.0
2005-03-08 11:00:00	CL	Stock	26.395	26.455	26.355	26.405	320400.0
2005-03-08 12:00:00	CL	Stock	26.395	26.455	26.36	26.435	241000.0
2005-03-08 13:00:00	CL	Stock	26.435	26.5	26.42	26.445	348000.0
2005-03-08 14:00:00	CL	Stock	26.44	26.485	26.4	26.415	279400.0
2005-03-08 15:00:00	CL	Stock	26.42	26.48	26.37	26.405	798400.0

> showing 50 of 25,292 rows — these rows as CSV

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