PREVIEW / stock_1hour / 2005-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-08.parquet
  size:    592 KB
  rows:    27,543
  symbols: 2,087

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-08 07:00:00	AAPL	Stock	2.625	2.6293	2.6214	2.6232	106400.0
2005-12-08 08:00:00	AAPL	Stock	2.6218	2.6318	2.5946	2.6114	10994564.0
2005-12-08 09:00:00	AAPL	Stock	2.6121	2.6218	2.5929	2.6125	135403184.0
2005-12-08 10:00:00	AAPL	Stock	2.6125	2.6489	2.6118	2.6386	186236260.0
2005-12-08 11:00:00	AAPL	Stock	2.6382	2.6425	2.62	2.6296	76094144.0
2005-12-08 12:00:00	AAPL	Stock	2.6296	2.6342	2.6168	2.6214	53864412.0
2005-12-08 13:00:00	AAPL	Stock	2.6218	2.6407	2.6079	2.6154	73308088.0
2005-12-08 14:00:00	AAPL	Stock	2.6157	2.6336	2.5982	2.6146	92191988.0
2005-12-08 15:00:00	AAPL	Stock	2.615	2.6461	2.6143	2.6461	147649292.0
2005-12-08 16:00:00	AAPL	Stock	2.645	2.6475	2.623	2.6368	6082496.0
2005-12-08 17:00:00	AAPL	Stock	2.6375	2.6464	2.6361	2.6368	469140.0
2005-12-08 18:00:00	AAPL	Stock	2.6371	2.6371	2.6242	2.6368	3333960.0
2005-12-08 06:00:00	MSFT	Stock	27.47	27.47	27.47	27.47	100.0
2005-12-08 08:00:00	MSFT	Stock	27.75	27.76	27.64	27.7	12300.0
2005-12-08 09:00:00	MSFT	Stock	27.7	27.79	27.66	27.71	5016857.0
2005-12-08 10:00:00	MSFT	Stock	27.7	27.81	27.68	27.79	6946452.0
2005-12-08 11:00:00	MSFT	Stock	27.78	27.8	27.7	27.728	9206555.0
2005-12-08 12:00:00	MSFT	Stock	27.72	27.74	27.67	27.721	10248146.0
2005-12-08 13:00:00	MSFT	Stock	27.72	27.73	27.67	27.71	9150141.0
2005-12-08 14:00:00	MSFT	Stock	27.7	27.723	27.6	27.69	9141262.0
2005-12-08 15:00:00	MSFT	Stock	27.69	27.79	27.64	27.68	11896883.0
2005-12-08 16:00:00	MSFT	Stock	27.68	27.74	27.62	27.62	173178.0
2005-12-08 17:00:00	MSFT	Stock	27.65	27.709	27.63	27.64	24986.0
2005-12-08 18:00:00	MSFT	Stock	27.711	27.711	27.63	27.699	712008.0
2005-12-08 09:00:00	NVDA	Stock	0.3	0.3033	0.2992	0.3011	29151960.0
2005-12-08 10:00:00	NVDA	Stock	0.3012	0.3027	0.2991	0.3002	75062520.0
2005-12-08 11:00:00	NVDA	Stock	0.3002	0.3029	0.2999	0.3022	46762560.0
2005-12-08 12:00:00	NVDA	Stock	0.3026	0.3026	0.2997	0.3	35305800.0
2005-12-08 13:00:00	NVDA	Stock	0.3	0.3008	0.297	0.2979	46129440.0
2005-12-08 14:00:00	NVDA	Stock	0.2979	0.3011	0.2952	0.2962	53829960.0
2005-12-08 15:00:00	NVDA	Stock	0.2962	0.2993	0.2958	0.2987	68725200.0
2005-12-08 16:00:00	NVDA	Stock	0.2986	0.2993	0.2957	0.298	6469440.0
2005-12-08 17:00:00	NVDA	Stock	0.2985	0.2986	0.2985	0.2985	463800.0
2005-12-08 18:00:00	NVDA	Stock	0.2993	0.2993	0.2993	0.2993	11304000.0
2005-12-08 08:00:00	AMZN	Stock	2.4375	2.4375	2.42	2.4245	67000.0
2005-12-08 09:00:00	AMZN	Stock	2.4345	2.4495	2.413	2.42	16342600.0
2005-12-08 10:00:00	AMZN	Stock	2.4195	2.45	2.4165	2.45	23645640.0
2005-12-08 11:00:00	AMZN	Stock	2.45	2.455	2.435	2.439	15236520.0
2005-12-08 12:00:00	AMZN	Stock	2.439	2.44	2.4135	2.42	8801360.0
2005-12-08 13:00:00	AMZN	Stock	2.42	2.42	2.403	2.4075	20614180.0
2005-12-08 14:00:00	AMZN	Stock	2.407	2.4075	2.393	2.3995	22367100.0
2005-12-08 15:00:00	AMZN	Stock	2.4	2.4195	2.394	2.4175	29357860.0
2005-12-08 16:00:00	AMZN	Stock	2.419	2.4195	2.4075	2.4125	1339700.0
2005-12-08 17:00:00	AMZN	Stock	2.417	2.4185	2.4075	2.4174	57860.0
2005-12-08 18:00:00	AMZN	Stock	2.4187	2.4187	2.4187	2.4187	2622000.0
2005-12-08 09:00:00	CL	Stock	27.455	27.725	27.4	27.725	349600.0
2005-12-08 10:00:00	CL	Stock	27.725	27.75	27.53	27.725	624400.0
2005-12-08 11:00:00	CL	Stock	27.735	27.75	27.66	27.75	377600.0
2005-12-08 12:00:00	CL	Stock	27.745	27.75	27.66	27.72	538000.0
2005-12-08 13:00:00	CL	Stock	27.72	27.75	27.652	27.74	378600.0

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

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