PREVIEW / stock_1hour / 2005-12-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-06.parquet
  size:    594 KB
  rows:    27,954
  symbols: 2,114

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-12-06 05:00:00	AAPL	Stock	2.5829	2.5829	2.5829	2.5829	2800.0
2005-12-06 06:00:00	AAPL	Stock	2.5893	2.5893	2.5857	2.5857	39200.0
2005-12-06 07:00:00	AAPL	Stock	2.5861	2.6054	2.5861	2.6036	142800.0
2005-12-06 08:00:00	AAPL	Stock	2.6071	2.6325	2.565	2.6321	15810228.0
2005-12-06 09:00:00	AAPL	Stock	2.6311	2.6479	2.6196	2.6293	157446492.0
2005-12-06 10:00:00	AAPL	Stock	2.6293	2.6579	2.6264	2.6493	178543568.0
2005-12-06 11:00:00	AAPL	Stock	2.6489	2.6618	2.6379	2.6561	99769964.0
2005-12-06 12:00:00	AAPL	Stock	2.6561	2.6704	2.655	2.6575	88374664.0
2005-12-06 13:00:00	AAPL	Stock	2.6572	2.6725	2.6529	2.6671	64527008.0
2005-12-06 14:00:00	AAPL	Stock	2.6671	2.6704	2.6546	2.6661	67725952.0
2005-12-06 15:00:00	AAPL	Stock	2.6657	2.6686	2.6332	2.6443	170525068.0
2005-12-06 16:00:00	AAPL	Stock	2.6454	2.6502	2.6443	2.6468	4384520.0
2005-12-06 17:00:00	AAPL	Stock	2.6464	2.6496	2.6446	2.6489	789628.0
2005-12-06 18:00:00	AAPL	Stock	2.6489	2.6493	2.6464	2.6486	114688.0
2005-12-06 07:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	1000.0
2005-12-06 08:00:00	MSFT	Stock	27.85	27.96	27.84	27.9	50979.0
2005-12-06 09:00:00	MSFT	Stock	27.85	27.921	27.71	27.75	5179230.0
2005-12-06 10:00:00	MSFT	Stock	27.75	27.87	27.74	27.82	6698532.0
2005-12-06 11:00:00	MSFT	Stock	27.82	27.832	27.69	27.77	7151789.0
2005-12-06 12:00:00	MSFT	Stock	27.78	27.84	27.72	27.78	4842915.0
2005-12-06 13:00:00	MSFT	Stock	27.78	27.84	27.75	27.81	8986267.0
2005-12-06 14:00:00	MSFT	Stock	27.81	27.84	27.78	27.83	8577855.0
2005-12-06 15:00:00	MSFT	Stock	27.84	27.84	27.68	27.71	18237661.0
2005-12-06 16:00:00	MSFT	Stock	27.69	27.73	27.67	27.71	1306537.0
2005-12-06 17:00:00	MSFT	Stock	27.72	27.72	27.69	27.71	2893.0
2005-12-06 18:00:00	MSFT	Stock	27.71	27.72	27.71	27.72	2100.0
2005-12-06 08:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	48000.0
2005-12-06 09:00:00	NVDA	Stock	0.2998	0.3022	0.2995	0.3002	37017000.0
2005-12-06 10:00:00	NVDA	Stock	0.3	0.3008	0.2993	0.3	36982320.0
2005-12-06 11:00:00	NVDA	Stock	0.3	0.3012	0.2996	0.3003	50061120.0
2005-12-06 12:00:00	NVDA	Stock	0.3003	0.3025	0.3002	0.3025	32410920.0
2005-12-06 13:00:00	NVDA	Stock	0.3025	0.304	0.3017	0.3038	52311840.0
2005-12-06 14:00:00	NVDA	Stock	0.3038	0.3046	0.3032	0.3038	47435160.0
2005-12-06 15:00:00	NVDA	Stock	0.3039	0.3042	0.2997	0.3004	78583560.0
2005-12-06 16:00:00	NVDA	Stock	0.3005	0.3012	0.2997	0.3005	23856600.0
2005-12-06 08:00:00	AMZN	Stock	2.445	2.4575	2.435	2.4575	809920.0
2005-12-06 09:00:00	AMZN	Stock	2.4575	2.488	2.4475	2.47	23322460.0
2005-12-06 10:00:00	AMZN	Stock	2.47	2.495	2.463	2.4775	32453880.0
2005-12-06 11:00:00	AMZN	Stock	2.477	2.4945	2.47	2.4885	18037400.0
2005-12-06 12:00:00	AMZN	Stock	2.4885	2.495	2.4805	2.484	20795620.0
2005-12-06 13:00:00	AMZN	Stock	2.4845	2.4895	2.48	2.4895	15152120.0
2005-12-06 14:00:00	AMZN	Stock	2.4895	2.494	2.481	2.4845	17559240.0
2005-12-06 15:00:00	AMZN	Stock	2.485	2.49	2.4625	2.463	44505020.0
2005-12-06 16:00:00	AMZN	Stock	2.4655	2.47	2.461	2.4655	2956200.0
2005-12-06 18:00:00	AMZN	Stock	2.4725	2.4725	2.469	2.47	80000.0
2005-12-06 08:00:00	CL	Stock	27.625	27.625	27.625	27.625	2800.0
2005-12-06 09:00:00	CL	Stock	27.695	27.745	27.63	27.74	327000.0
2005-12-06 10:00:00	CL	Stock	27.72	27.79	27.64	27.7	495400.0
2005-12-06 11:00:00	CL	Stock	27.72	27.72	27.6	27.685	312400.0
2005-12-06 12:00:00	CL	Stock	27.685	27.79	27.68	27.76	373200.0

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

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