PREVIEW / stock_1hour / 2005-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-07.parquet
  size:    558 KB
  rows:    26,546
  symbols: 2,069

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-09-07 08:00:00	AAPL	Stock	1.7518	1.7575	1.7411	1.7507	3411156.0
2005-09-07 09:00:00	AAPL	Stock	1.7518	1.7643	1.7261	1.7364	155820420.0
2005-09-07 10:00:00	AAPL	Stock	1.7364	1.7482	1.73	1.7379	126576436.0
2005-09-07 11:00:00	AAPL	Stock	1.7382	1.7414	1.7339	1.7343	52045448.0
2005-09-07 12:00:00	AAPL	Stock	1.7343	1.7354	1.7114	1.7225	130161444.0
2005-09-07 13:00:00	AAPL	Stock	1.7225	1.7343	1.7175	1.7264	113716288.0
2005-09-07 14:00:00	AAPL	Stock	1.7264	1.7614	1.7232	1.7496	233137408.0
2005-09-07 15:00:00	AAPL	Stock	1.7496	1.7554	1.7329	1.7371	134084328.0
2005-09-07 16:00:00	AAPL	Stock	1.7379	1.7396	1.7304	1.7361	3534412.0
2005-09-07 17:00:00	AAPL	Stock	1.7346	1.7429	1.7336	1.7429	803040.0
2005-09-07 18:00:00	AAPL	Stock	1.7429	1.7446	1.7371	1.7443	257600.0
2005-09-07 08:00:00	MSFT	Stock	27.05	27.05	26.92	26.96	35912.0
2005-09-07 09:00:00	MSFT	Stock	26.94	27.11	26.91	26.91	6643167.0
2005-09-07 10:00:00	MSFT	Stock	26.91	26.93	26.82	26.93	7444460.0
2005-09-07 11:00:00	MSFT	Stock	26.93	26.975	26.85	26.91	3787866.0
2005-09-07 12:00:00	MSFT	Stock	26.92	26.94	26.86	26.92	3795791.0
2005-09-07 13:00:00	MSFT	Stock	26.92	26.97	26.83	26.861	5389590.0
2005-09-07 14:00:00	MSFT	Stock	26.86	26.91	26.82	26.892	5897951.0
2005-09-07 15:00:00	MSFT	Stock	26.89	26.93	26.83	26.85	9241287.0
2005-09-07 16:00:00	MSFT	Stock	26.85	26.88	26.82	26.86	1387213.0
2005-09-07 17:00:00	MSFT	Stock	26.86	26.86	26.83	26.85	131931.0
2005-09-07 18:00:00	MSFT	Stock	26.85	26.85	26.85	26.85	28100.0
2005-09-07 09:00:00	NVDA	Stock	0.2537	0.257	0.253	0.254	50574720.0
2005-09-07 10:00:00	NVDA	Stock	0.254	0.2578	0.2527	0.2576	79038000.0
2005-09-07 11:00:00	NVDA	Stock	0.2576	0.2582	0.2559	0.2578	43684680.0
2005-09-07 12:00:00	NVDA	Stock	0.2579	0.2594	0.2575	0.2582	78653400.0
2005-09-07 13:00:00	NVDA	Stock	0.2582	0.2624	0.2572	0.2622	123197760.0
2005-09-07 14:00:00	NVDA	Stock	0.2622	0.2624	0.2604	0.2612	85648440.0
2005-09-07 15:00:00	NVDA	Stock	0.2612	0.2621	0.2605	0.2617	120068280.0
2005-09-07 16:00:00	NVDA	Stock	0.2617	0.2622	0.2617	0.2622	738240.0
2005-09-07 17:00:00	NVDA	Stock	0.2591	0.2591	0.2591	0.2591	972000.0
2005-09-07 18:00:00	NVDA	Stock	0.2591	0.2591	0.2591	0.2591	10476000.0
2005-09-07 08:00:00	AMZN	Stock	2.175	2.175	2.161	2.1725	8000.0
2005-09-07 09:00:00	AMZN	Stock	2.1725	2.215	2.1675	2.2005	30877540.0
2005-09-07 10:00:00	AMZN	Stock	2.2005	2.207	2.19	2.196	18886560.0
2005-09-07 11:00:00	AMZN	Stock	2.1955	2.198	2.1805	2.1855	11068940.0
2005-09-07 12:00:00	AMZN	Stock	2.1855	2.1865	2.176	2.1775	5898860.0
2005-09-07 13:00:00	AMZN	Stock	2.1775	2.1995	2.175	2.1975	13866960.0
2005-09-07 14:00:00	AMZN	Stock	2.1975	2.2065	2.185	2.189	17350720.0
2005-09-07 15:00:00	AMZN	Stock	2.1895	2.1945	2.1835	2.185	17340180.0
2005-09-07 16:00:00	AMZN	Stock	2.1865	2.1875	2.1865	2.1865	187640.0
2005-09-07 17:00:00	AMZN	Stock	2.1845	2.1845	2.1845	2.1845	4000.0
2005-09-07 09:00:00	CL	Stock	26.755	27.15	26.755	26.945	800400.0
2005-09-07 10:00:00	CL	Stock	26.95	26.97	26.78	26.895	757600.0
2005-09-07 11:00:00	CL	Stock	26.895	27.005	26.89	26.94	827600.0
2005-09-07 12:00:00	CL	Stock	26.94	26.995	26.9	26.92	710600.0
2005-09-07 13:00:00	CL	Stock	26.925	26.975	26.885	26.94	413800.0
2005-09-07 14:00:00	CL	Stock	26.935	27.03	26.925	27.025	553200.0
2005-09-07 15:00:00	CL	Stock	27.03	27.055	27.0	27.04	1031800.0
2005-09-07 17:00:00	CL	Stock	27.03	27.03	27.03	27.03	400.0

> showing 50 of 26,546 rows — these rows as CSV

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