PREVIEW / stock_1hour / 2005-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-18.parquet
  size:    565 KB
  rows:    27,235
  symbols: 2,028

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-18 08:00:00	AAPL	Stock	1.4804	1.4821	1.475	1.4804	1334284.0
2005-07-18 09:00:00	AAPL	Stock	1.4793	1.5036	1.4775	1.4904	155372616.0
2005-07-18 10:00:00	AAPL	Stock	1.4904	1.4939	1.4825	1.4904	112801192.0
2005-07-18 11:00:00	AAPL	Stock	1.4904	1.4993	1.4893	1.4896	64728776.0
2005-07-18 12:00:00	AAPL	Stock	1.49	1.4946	1.4861	1.4943	61397924.0
2005-07-18 13:00:00	AAPL	Stock	1.4943	1.4946	1.4875	1.4895	42139132.0
2005-07-18 14:00:00	AAPL	Stock	1.4893	1.4921	1.4843	1.4857	47833240.0
2005-07-18 15:00:00	AAPL	Stock	1.4857	1.4886	1.4793	1.4814	88853296.0
2005-07-18 16:00:00	AAPL	Stock	1.4814	1.4904	1.48	1.4896	7118552.0
2005-07-18 17:00:00	AAPL	Stock	1.4896	1.4907	1.4817	1.4907	1304492.0
2005-07-18 18:00:00	AAPL	Stock	1.4896	1.4907	1.4893	1.4896	194152.0
2005-07-18 07:00:00	MSFT	Stock	25.71	25.71	25.71	25.71	1435.0
2005-07-18 08:00:00	MSFT	Stock	25.79	25.79	25.69	25.74	1054206.0
2005-07-18 09:00:00	MSFT	Stock	25.71	25.79	25.64	25.7	5091493.0
2005-07-18 10:00:00	MSFT	Stock	25.7	25.73	25.66	25.699	6419755.0
2005-07-18 11:00:00	MSFT	Stock	25.69	25.7	25.6	25.67	5320945.0
2005-07-18 12:00:00	MSFT	Stock	25.66	25.72	25.65	25.71	3086128.0
2005-07-18 13:00:00	MSFT	Stock	25.71	25.72	25.63	25.66	3545706.0
2005-07-18 14:00:00	MSFT	Stock	25.66	25.68	25.61	25.638	3612273.0
2005-07-18 15:00:00	MSFT	Stock	25.63	25.69	25.55	25.55	8838710.0
2005-07-18 16:00:00	MSFT	Stock	25.56	25.7	25.54	25.7	1329984.0
2005-07-18 17:00:00	MSFT	Stock	25.7	25.7	25.55	25.67	19601.0
2005-07-18 18:00:00	MSFT	Stock	25.7	25.7	25.67	25.67	26020.0
2005-07-18 09:00:00	NVDA	Stock	0.2234	0.2235	0.2169	0.2186	186640800.0
2005-07-18 10:00:00	NVDA	Stock	0.2186	0.2187	0.2162	0.2167	324732960.0
2005-07-18 11:00:00	NVDA	Stock	0.2166	0.2225	0.2166	0.2198	189582840.0
2005-07-18 12:00:00	NVDA	Stock	0.2198	0.2198	0.2181	0.2182	50208840.0
2005-07-18 13:00:00	NVDA	Stock	0.2182	0.219	0.2171	0.2175	51478200.0
2005-07-18 14:00:00	NVDA	Stock	0.2176	0.2184	0.2175	0.2181	50147880.0
2005-07-18 15:00:00	NVDA	Stock	0.2182	0.2197	0.2175	0.2183	182992560.0
2005-07-18 16:00:00	NVDA	Stock	0.2187	0.2196	0.2184	0.2196	522120.0
2005-07-18 17:00:00	NVDA	Stock	0.2197	0.22	0.2185	0.22	483240.0
2005-07-18 18:00:00	NVDA	Stock	0.22	0.2202	0.2197	0.2197	816000.0
2005-07-18 08:00:00	AMZN	Stock	1.8625	1.8625	1.8625	1.8625	20000.0
2005-07-18 09:00:00	AMZN	Stock	1.8575	1.8575	1.835	1.852	8233140.0
2005-07-18 10:00:00	AMZN	Stock	1.8515	1.859	1.847	1.852	9140100.0
2005-07-18 11:00:00	AMZN	Stock	1.852	1.8525	1.845	1.8485	7286780.0
2005-07-18 12:00:00	AMZN	Stock	1.8485	1.8495	1.845	1.8495	5384040.0
2005-07-18 13:00:00	AMZN	Stock	1.8495	1.8525	1.842	1.852	5993260.0
2005-07-18 14:00:00	AMZN	Stock	1.852	1.8575	1.8505	1.855	9545740.0
2005-07-18 15:00:00	AMZN	Stock	1.8555	1.8595	1.8545	1.8595	12206020.0
2005-07-18 16:00:00	AMZN	Stock	1.8595	1.86	1.855	1.858	141000.0
2005-07-18 17:00:00	AMZN	Stock	1.8615	1.8615	1.8595	1.8605	222080.0
2005-07-18 18:00:00	AMZN	Stock	1.8625	1.8675	1.8625	1.8675	22000.0
2005-07-18 09:00:00	CL	Stock	25.775	25.83	25.73	25.815	251400.0
2005-07-18 10:00:00	CL	Stock	25.815	25.89	25.79	25.865	558200.0
2005-07-18 11:00:00	CL	Stock	25.865	25.955	25.845	25.94	491200.0
2005-07-18 12:00:00	CL	Stock	25.925	25.94	25.875	25.905	445400.0
2005-07-18 13:00:00	CL	Stock	25.9	25.92	25.89	25.895	327400.0
2005-07-18 14:00:00	CL	Stock	25.895	25.925	25.825	25.835	461000.0

> showing 50 of 27,235 rows — these rows as CSV

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