PREVIEW / stock_1hour / 2004-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-04-14.parquet
  size:    502 KB
  rows:    23,444
  symbols: 1,757

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
2004-04-14 08:00:00	AAPL	Stock	0.4793	0.4793	0.4766	0.4766	280000.0
2004-04-14 09:00:00	AAPL	Stock	0.4766	0.4816	0.4739	0.4775	18924136.0
2004-04-14 10:00:00	AAPL	Stock	0.4773	0.483	0.4764	0.4821	37967832.0
2004-04-14 11:00:00	AAPL	Stock	0.482	0.4834	0.4791	0.4796	27952624.0
2004-04-14 12:00:00	AAPL	Stock	0.4796	0.4818	0.4764	0.4791	36652560.0
2004-04-14 13:00:00	AAPL	Stock	0.4789	0.4804	0.4754	0.4759	62796720.0
2004-04-14 14:00:00	AAPL	Stock	0.4759	0.4777	0.4698	0.4763	65670472.0
2004-04-14 15:00:00	AAPL	Stock	0.4764	0.4779	0.4734	0.4757	84982968.0
2004-04-14 16:00:00	AAPL	Stock	0.4768	0.5204	0.4754	0.517	113039136.0
2004-04-14 17:00:00	AAPL	Stock	0.517	0.5232	0.5089	0.5191	49089880.0
2004-04-14 18:00:00	AAPL	Stock	0.5193	0.5213	0.5161	0.5207	4967816.0
2004-04-14 08:00:00	MSFT	Stock	25.4	25.63	25.35	25.36	49753.0
2004-04-14 09:00:00	MSFT	Stock	25.35	25.59	25.35	25.57	2211709.0
2004-04-14 10:00:00	MSFT	Stock	25.58	25.68	25.51	25.6	4341701.0
2004-04-14 11:00:00	MSFT	Stock	25.6	25.68	25.54	25.6	5105104.0
2004-04-14 12:00:00	MSFT	Stock	25.59	25.6	25.46	25.48	3925850.0
2004-04-14 13:00:00	MSFT	Stock	25.479	25.5	25.41	25.48	5116809.0
2004-04-14 14:00:00	MSFT	Stock	25.48	25.501	25.41	25.48	5935610.0
2004-04-14 15:00:00	MSFT	Stock	25.48	25.54	25.4	25.52	7908155.0
2004-04-14 16:00:00	MSFT	Stock	25.52	25.66	25.49	25.6	10104395.0
2004-04-14 17:00:00	MSFT	Stock	25.61	25.62	25.61	25.61	15960.0
2004-04-14 18:00:00	MSFT	Stock	25.61	25.61	25.6	25.61	7240.0
2004-04-14 08:00:00	NVDA	Stock	0.2136	0.2137	0.2125	0.2125	11115600.0
2004-04-14 09:00:00	NVDA	Stock	0.2125	0.2168	0.2101	0.2168	42245880.0
2004-04-14 10:00:00	NVDA	Stock	0.2169	0.2187	0.2158	0.2158	58639200.0
2004-04-14 11:00:00	NVDA	Stock	0.2158	0.2177	0.2158	0.2172	42666120.0
2004-04-14 12:00:00	NVDA	Stock	0.2172	0.2181	0.2171	0.218	33896160.0
2004-04-14 13:00:00	NVDA	Stock	0.218	0.2181	0.2152	0.2159	47204880.0
2004-04-14 14:00:00	NVDA	Stock	0.216	0.2161	0.2139	0.2158	34648440.0
2004-04-14 15:00:00	NVDA	Stock	0.2158	0.2158	0.2128	0.2146	56240880.0
2004-04-14 16:00:00	NVDA	Stock	0.2146	0.2152	0.2142	0.2142	4937160.0
2004-04-14 17:00:00	NVDA	Stock	0.2142	0.2142	0.2137	0.2137	648000.0
2004-04-14 08:00:00	AMZN	Stock	2.325	2.325	2.3125	2.3125	52000.0
2004-04-14 09:00:00	AMZN	Stock	2.305	2.3685	2.295	2.364	14281200.0
2004-04-14 10:00:00	AMZN	Stock	2.364	2.3645	2.347	2.3485	9692180.0
2004-04-14 11:00:00	AMZN	Stock	2.3495	2.377	2.348	2.376	10212300.0
2004-04-14 12:00:00	AMZN	Stock	2.3755	2.383	2.368	2.3715	7337280.0
2004-04-14 13:00:00	AMZN	Stock	2.3715	2.379	2.362	2.366	9297020.0
2004-04-14 14:00:00	AMZN	Stock	2.366	2.366	2.34	2.358	11995600.0
2004-04-14 15:00:00	AMZN	Stock	2.358	2.358	2.335	2.347	12972500.0
2004-04-14 16:00:00	AMZN	Stock	2.348	2.362	2.3345	2.3395	2132720.0
2004-04-14 17:00:00	AMZN	Stock	2.3455	2.353	2.3455	2.35	32000.0
2004-04-14 18:00:00	AMZN	Stock	2.3475	2.353	2.34	2.353	70000.0
2004-04-14 09:00:00	CL	Stock	26.75	26.955	26.705	26.875	692800.0
2004-04-14 10:00:00	CL	Stock	26.88	27.05	26.875	26.985	808800.0
2004-04-14 11:00:00	CL	Stock	26.99	27.095	26.975	27.08	519800.0
2004-04-14 12:00:00	CL	Stock	27.08	27.265	27.075	27.265	673600.0
2004-04-14 13:00:00	CL	Stock	27.27	27.28	27.18	27.26	1066400.0
2004-04-14 14:00:00	CL	Stock	27.265	27.335	27.165	27.335	941600.0
2004-04-14 15:00:00	CL	Stock	27.335	27.485	27.29	27.41	1451000.0

> showing 50 of 23,444 rows — these rows as CSV

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