PREVIEW / stock_1hour / 2004-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-18.parquet
  size:    527 KB
  rows:    24,837
  symbols: 1,786

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-06-18 08:00:00	AAPL	Stock	0.5839	0.5839	0.5813	0.5821	431200.0
2004-06-18 09:00:00	AAPL	Stock	0.5839	0.5856	0.5791	0.5805	37040304.0
2004-06-18 10:00:00	AAPL	Stock	0.5807	0.5904	0.5805	0.5882	53494840.0
2004-06-18 11:00:00	AAPL	Stock	0.588	0.5913	0.5879	0.5886	46680592.0
2004-06-18 12:00:00	AAPL	Stock	0.5888	0.5896	0.5884	0.5886	29467200.0
2004-06-18 13:00:00	AAPL	Stock	0.5886	0.5938	0.5875	0.5911	35187992.0
2004-06-18 14:00:00	AAPL	Stock	0.5913	0.5966	0.5871	0.5886	39693920.0
2004-06-18 15:00:00	AAPL	Stock	0.5886	0.5898	0.5859	0.5879	81123840.0
2004-06-18 16:00:00	AAPL	Stock	0.5879	0.5893	0.5873	0.5877	36409072.0
2004-06-18 17:00:00	AAPL	Stock	0.5875	0.5902	0.5875	0.5875	3856328.0
2004-06-18 18:00:00	AAPL	Stock	0.5877	0.592	0.5877	0.592	128128.0
2004-06-18 08:00:00	MSFT	Stock	27.83	27.84	27.72	27.73	61780.0
2004-06-18 09:00:00	MSFT	Stock	27.74	27.98	27.7	27.89	16644305.0
2004-06-18 10:00:00	MSFT	Stock	27.9	28.06	27.86	27.97	18794455.0
2004-06-18 11:00:00	MSFT	Stock	27.96	28.03	27.94	27.98	12327395.0
2004-06-18 12:00:00	MSFT	Stock	27.98	28.07	27.95	28.06	10266642.0
2004-06-18 13:00:00	MSFT	Stock	28.06	28.11	28.01	28.09	9594902.0
2004-06-18 14:00:00	MSFT	Stock	28.1	28.39	28.06	28.31	23199671.0
2004-06-18 15:00:00	MSFT	Stock	28.31	28.5	28.21	28.24	30416074.0
2004-06-18 16:00:00	MSFT	Stock	28.23	28.4	28.0871	28.35	3966426.0
2004-06-18 17:00:00	MSFT	Stock	28.3	28.36	28.29	28.3	278572.0
2004-06-18 18:00:00	MSFT	Stock	28.28	28.35	28.27	28.3	2932.0
2004-06-18 08:00:00	NVDA	Stock	0.1644	0.1648	0.1639	0.1648	1948560.0
2004-06-18 09:00:00	NVDA	Stock	0.1653	0.1662	0.1625	0.1657	85784160.0
2004-06-18 10:00:00	NVDA	Stock	0.1657	0.1692	0.1657	0.1672	118379160.0
2004-06-18 11:00:00	NVDA	Stock	0.1672	0.1675	0.1657	0.1662	34117680.0
2004-06-18 12:00:00	NVDA	Stock	0.1662	0.1662	0.1647	0.1651	31355400.0
2004-06-18 13:00:00	NVDA	Stock	0.1651	0.1654	0.1643	0.1644	25901400.0
2004-06-18 14:00:00	NVDA	Stock	0.1643	0.1648	0.1629	0.1637	41202840.0
2004-06-18 15:00:00	NVDA	Stock	0.1637	0.1667	0.1637	0.1647	124674480.0
2004-06-18 16:00:00	NVDA	Stock	0.1647	0.1647	0.1645	0.1647	24281160.0
2004-06-18 17:00:00	NVDA	Stock	0.1647	0.1647	0.1645	0.1646	5063280.0
2004-06-18 08:00:00	AMZN	Stock	2.488	2.488	2.484	2.484	26000.0
2004-06-18 09:00:00	AMZN	Stock	2.484	2.5	2.47	2.4925	8636180.0
2004-06-18 10:00:00	AMZN	Stock	2.493	2.514	2.49	2.509	15311540.0
2004-06-18 11:00:00	AMZN	Stock	2.5095	2.5115	2.4975	2.503	6363040.0
2004-06-18 12:00:00	AMZN	Stock	2.503	2.504	2.495	2.4985	4045880.0
2004-06-18 13:00:00	AMZN	Stock	2.4985	2.505	2.496	2.4995	4090200.0
2004-06-18 14:00:00	AMZN	Stock	2.4995	2.5005	2.489	2.4895	7921680.0
2004-06-18 15:00:00	AMZN	Stock	2.4895	2.503	2.48	2.484	32965800.0
2004-06-18 16:00:00	AMZN	Stock	2.484	2.4895	2.4785	2.48	4411960.0
2004-06-18 17:00:00	AMZN	Stock	2.4795	2.4875	2.4795	2.4875	683180.0
2004-06-18 18:00:00	AMZN	Stock	2.48	2.48	2.48	2.48	62880.0
2004-06-18 09:00:00	CL	Stock	29.18	29.18	29.085	29.105	347600.0
2004-06-18 10:00:00	CL	Stock	29.105	29.295	29.085	29.235	212600.0
2004-06-18 11:00:00	CL	Stock	29.24	29.36	29.235	29.335	172000.0
2004-06-18 12:00:00	CL	Stock	29.325	29.34	29.26	29.26	66600.0
2004-06-18 13:00:00	CL	Stock	29.26	29.26	29.19	29.2	144400.0
2004-06-18 14:00:00	CL	Stock	29.2	29.21	29.09	29.11	135000.0
2004-06-18 15:00:00	CL	Stock	29.105	29.2	29.075	29.175	399600.0

> showing 50 of 24,837 rows — these rows as CSV

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