PREVIEW / stock_1hour / 2005-07-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-15.parquet
  size:    551 KB
  rows:    26,246
  symbols: 2,018

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-07-15 04:00:00	AAPL	Stock	1.4607	1.4607	1.4607	1.4607	22400.0
2005-07-15 08:00:00	AAPL	Stock	1.45	1.4514	1.4446	1.4461	1165248.0
2005-07-15 09:00:00	AAPL	Stock	1.4461	1.4643	1.445	1.45	128651460.0
2005-07-15 10:00:00	AAPL	Stock	1.45	1.4643	1.4461	1.4611	103359956.0
2005-07-15 11:00:00	AAPL	Stock	1.4611	1.4836	1.4607	1.4814	157403092.0
2005-07-15 12:00:00	AAPL	Stock	1.4814	1.4829	1.475	1.4782	71616468.0
2005-07-15 13:00:00	AAPL	Stock	1.4786	1.4814	1.4761	1.4789	34905388.0
2005-07-15 14:00:00	AAPL	Stock	1.4793	1.4825	1.4746	1.4814	66312288.0
2005-07-15 15:00:00	AAPL	Stock	1.4818	1.4846	1.4738	1.4843	111032600.0
2005-07-15 16:00:00	AAPL	Stock	1.4846	1.4911	1.4807	1.49	4793124.0
2005-07-15 17:00:00	AAPL	Stock	1.4893	1.49	1.4857	1.4857	251160.0
2005-07-15 18:00:00	AAPL	Stock	1.4857	1.4911	1.485	1.4857	182756.0
2005-07-15 08:00:00	MSFT	Stock	25.94	25.95	25.88	25.92	89736.0
2005-07-15 09:00:00	MSFT	Stock	25.93	26.1	25.92	26.03	11754580.0
2005-07-15 10:00:00	MSFT	Stock	26.03	26.05	25.77	25.82	10811881.0
2005-07-15 11:00:00	MSFT	Stock	25.83	25.89	25.8	25.852	6348988.0
2005-07-15 12:00:00	MSFT	Stock	25.852	25.86	25.75	25.77	4896457.0
2005-07-15 13:00:00	MSFT	Stock	25.77	26.022	25.75	25.8	4454236.0
2005-07-15 14:00:00	MSFT	Stock	25.8	25.93	25.78	25.91	6619555.0
2005-07-15 15:00:00	MSFT	Stock	25.918	25.92	25.76	25.77	9122241.0
2005-07-15 16:00:00	MSFT	Stock	25.76	25.79	25.74	25.78	694728.0
2005-07-15 17:00:00	MSFT	Stock	25.75	25.78	25.75	25.76	8260.0
2005-07-15 18:00:00	MSFT	Stock	25.76	25.77	25.75	25.77	2760.0
2005-07-15 08:00:00	NVDA	Stock	0.2262	0.2267	0.2262	0.2267	144000.0
2005-07-15 09:00:00	NVDA	Stock	0.2267	0.2271	0.2222	0.2242	276226080.0
2005-07-15 10:00:00	NVDA	Stock	0.2242	0.2247	0.2213	0.2222	218516520.0
2005-07-15 11:00:00	NVDA	Stock	0.2222	0.223	0.2202	0.2219	130170120.0
2005-07-15 12:00:00	NVDA	Stock	0.2218	0.2235	0.221	0.2233	94424280.0
2005-07-15 13:00:00	NVDA	Stock	0.2232	0.2235	0.222	0.2222	57015720.0
2005-07-15 14:00:00	NVDA	Stock	0.2223	0.2252	0.2217	0.2251	185767560.0
2005-07-15 15:00:00	NVDA	Stock	0.2252	0.2258	0.2233	0.2239	234569520.0
2005-07-15 16:00:00	NVDA	Stock	0.2239	0.224	0.2193	0.2229	11536800.0
2005-07-15 17:00:00	NVDA	Stock	0.2227	0.2227	0.2217	0.2217	84000.0
2005-07-15 18:00:00	NVDA	Stock	0.2221	0.2221	0.2221	0.2221	12000.0
2005-07-15 08:00:00	AMZN	Stock	1.8595	1.865	1.8595	1.865	71340.0
2005-07-15 09:00:00	AMZN	Stock	1.8645	1.875	1.863	1.8635	17822360.0
2005-07-15 10:00:00	AMZN	Stock	1.8635	1.8635	1.848	1.85	21073200.0
2005-07-15 11:00:00	AMZN	Stock	1.85	1.865	1.8465	1.8475	10444000.0
2005-07-15 12:00:00	AMZN	Stock	1.8475	1.8475	1.8375	1.8405	10358440.0
2005-07-15 13:00:00	AMZN	Stock	1.8405	1.8415	1.84	1.841	6799220.0
2005-07-15 14:00:00	AMZN	Stock	1.841	1.8565	1.8385	1.854	15017600.0
2005-07-15 15:00:00	AMZN	Stock	1.854	1.86	1.853	1.857	20430980.0
2005-07-15 16:00:00	AMZN	Stock	1.857	1.858	1.8555	1.858	897580.0
2005-07-15 17:00:00	AMZN	Stock	1.858	1.8585	1.858	1.8585	126000.0
2005-07-15 18:00:00	AMZN	Stock	1.8585	1.8585	1.856	1.856	108580.0
2005-07-15 09:00:00	CL	Stock	25.59	25.715	25.5505	25.64	507200.0
2005-07-15 10:00:00	CL	Stock	25.64	25.73	25.635	25.675	365200.0
2005-07-15 11:00:00	CL	Stock	25.675	25.74	25.675	25.68	263200.0
2005-07-15 12:00:00	CL	Stock	25.68	25.7	25.625	25.655	380200.0
2005-07-15 13:00:00	CL	Stock	25.66	25.75	25.65	25.74	335200.0

> showing 50 of 26,246 rows — these rows as CSV

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