PREVIEW / stock_1hour / 2005-08-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-24.parquet
  size:    553 KB
  rows:    26,195
  symbols: 2,064

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-08-24 08:00:00	AAPL	Stock	1.625	1.6336	1.6232	1.6336	971824.0
2005-08-24 09:00:00	AAPL	Stock	1.6254	1.6539	1.6232	1.6511	79838612.0
2005-08-24 10:00:00	AAPL	Stock	1.6511	1.6771	1.6457	1.6711	119077896.0
2005-08-24 11:00:00	AAPL	Stock	1.6711	1.6768	1.6664	1.6764	73545248.0
2005-08-24 12:00:00	AAPL	Stock	1.6761	1.6829	1.6714	1.6782	64726872.0
2005-08-24 13:00:00	AAPL	Stock	1.6768	1.6786	1.6625	1.6671	50238440.0
2005-08-24 14:00:00	AAPL	Stock	1.6671	1.67	1.6532	1.6536	55690572.0
2005-08-24 15:00:00	AAPL	Stock	1.6536	1.6557	1.6296	1.635	117531204.0
2005-08-24 16:00:00	AAPL	Stock	1.6368	1.6382	1.6316	1.6379	3103352.0
2005-08-24 17:00:00	AAPL	Stock	1.6361	1.6393	1.6361	1.6361	221620.0
2005-08-24 18:00:00	AAPL	Stock	1.6393	1.6393	1.6375	1.6375	99540.0
2005-08-24 08:00:00	MSFT	Stock	26.8	26.87	26.76	26.87	2303664.0
2005-08-24 09:00:00	MSFT	Stock	26.78	27.0	26.78	26.98	4063497.0
2005-08-24 10:00:00	MSFT	Stock	26.98	27.12	26.96	27.09	8509072.0
2005-08-24 11:00:00	MSFT	Stock	27.09	27.16	27.01	27.15	6262632.0
2005-08-24 12:00:00	MSFT	Stock	27.14	27.15	27.08	27.081	3399689.0
2005-08-24 13:00:00	MSFT	Stock	27.08	27.13	27.03	27.112	6289626.0
2005-08-24 14:00:00	MSFT	Stock	27.12	27.13	26.93	26.96	6708710.0
2005-08-24 15:00:00	MSFT	Stock	26.96	27.06	26.78	26.81	18750647.0
2005-08-24 16:00:00	MSFT	Stock	26.81	26.82	26.78	26.81	537634.0
2005-08-24 17:00:00	MSFT	Stock	26.78	26.81	26.78	26.81	957400.0
2005-08-24 18:00:00	MSFT	Stock	26.81	26.86	26.8	26.81	3000.0
2005-08-24 08:00:00	NVDA	Stock	0.2429	0.2429	0.2397	0.2429	12348480.0
2005-08-24 09:00:00	NVDA	Stock	0.2416	0.2422	0.2402	0.2419	38132520.0
2005-08-24 10:00:00	NVDA	Stock	0.2419	0.2452	0.2415	0.2448	97062960.0
2005-08-24 11:00:00	NVDA	Stock	0.2448	0.2458	0.2442	0.2454	54717840.0
2005-08-24 12:00:00	NVDA	Stock	0.2455	0.2482	0.245	0.2472	56309520.0
2005-08-24 13:00:00	NVDA	Stock	0.2472	0.2473	0.2458	0.2466	34301640.0
2005-08-24 14:00:00	NVDA	Stock	0.2466	0.2472	0.2452	0.2457	70402200.0
2005-08-24 15:00:00	NVDA	Stock	0.2457	0.2462	0.2425	0.243	112854720.0
2005-08-24 16:00:00	NVDA	Stock	0.2429	0.245	0.2429	0.245	14041440.0
2005-08-24 09:00:00	AMZN	Stock	2.1685	2.1695	2.13	2.1445	16343200.0
2005-08-24 10:00:00	AMZN	Stock	2.145	2.1615	2.136	2.154	19616800.0
2005-08-24 11:00:00	AMZN	Stock	2.1535	2.1575	2.1535	2.155	6348840.0
2005-08-24 12:00:00	AMZN	Stock	2.155	2.156	2.149	2.15	8923080.0
2005-08-24 13:00:00	AMZN	Stock	2.15	2.15	2.138	2.141	10821380.0
2005-08-24 14:00:00	AMZN	Stock	2.141	2.149	2.1355	2.143	10225960.0
2005-08-24 15:00:00	AMZN	Stock	2.143	2.1435	2.1135	2.117	41347120.0
2005-08-24 16:00:00	AMZN	Stock	2.115	2.1435	2.115	2.1185	1996700.0
2005-08-24 17:00:00	AMZN	Stock	2.12	2.12	2.1175	2.1175	50000.0
2005-08-24 09:00:00	CL	Stock	26.48	26.495	26.255	26.255	290800.0
2005-08-24 10:00:00	CL	Stock	26.255	26.325	26.1215	26.18	919200.0
2005-08-24 11:00:00	CL	Stock	26.185	26.39	26.135	26.385	661000.0
2005-08-24 12:00:00	CL	Stock	26.375	26.635	26.31	26.505	1550000.0
2005-08-24 13:00:00	CL	Stock	26.505	26.57	26.465	26.535	359800.0
2005-08-24 14:00:00	CL	Stock	26.535	26.57	26.52	26.535	603800.0
2005-08-24 15:00:00	CL	Stock	26.535	26.54	26.3	26.345	1110400.0
2005-08-24 16:00:00	CL	Stock	26.325	26.325	26.325	26.325	18600.0
2005-08-24 17:00:00	CL	Stock	26.33	26.33	26.33	26.33	46600.0

> showing 49 of 26,195 rows — these rows as CSV

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