PREVIEW / stock_1hour / 2006-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-05.parquet
  size:    600 KB
  rows:    28,512
  symbols: 2,169

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
2006-01-05 07:00:00	AAPL	Stock	2.6775	2.6775	2.6775	2.6775	2800.0
2006-01-05 08:00:00	AAPL	Stock	2.6775	2.6775	2.6621	2.6625	970564.0
2006-01-05 09:00:00	AAPL	Stock	2.6654	2.675	2.6427	2.6489	68543888.0
2006-01-05 10:00:00	AAPL	Stock	2.6429	2.675	2.6428	2.6536	95272240.0
2006-01-05 11:00:00	AAPL	Stock	2.6536	2.6629	2.6518	2.6579	46942056.0
2006-01-05 12:00:00	AAPL	Stock	2.6579	2.66	2.6339	2.6346	58788968.0
2006-01-05 13:00:00	AAPL	Stock	2.6339	2.6571	2.6339	2.6486	50968484.0
2006-01-05 14:00:00	AAPL	Stock	2.6486	2.65	2.6382	2.6493	46417224.0
2006-01-05 15:00:00	AAPL	Stock	2.65	2.66	2.6464	2.6564	68466412.0
2006-01-05 16:00:00	AAPL	Stock	2.6532	2.6571	2.6504	2.6543	1705928.0
2006-01-05 17:00:00	AAPL	Stock	2.655	2.6554	2.6525	2.6536	75068.0
2006-01-05 18:00:00	AAPL	Stock	2.6532	2.655	2.6525	2.655	152936.0
2006-01-05 07:00:00	MSFT	Stock	27.04	27.04	26.87	26.87	270.0
2006-01-05 08:00:00	MSFT	Stock	27.0	27.03	26.95	26.95	7668.0
2006-01-05 09:00:00	MSFT	Stock	26.95	27.12	26.9	27.02	5036210.0
2006-01-05 10:00:00	MSFT	Stock	27.02	27.13	27.01	27.04	7358893.0
2006-01-05 11:00:00	MSFT	Stock	27.03	27.09	27.02	27.06	5165408.0
2006-01-05 12:00:00	MSFT	Stock	27.06	27.1	26.96	27.002	8246273.0
2006-01-05 13:00:00	MSFT	Stock	27.0	27.07	26.95	27.02	6039129.0
2006-01-05 14:00:00	MSFT	Stock	27.01	27.07	26.99	27.04	4923483.0
2006-01-05 15:00:00	MSFT	Stock	27.03	27.05	26.94	27.0	9696497.0
2006-01-05 16:00:00	MSFT	Stock	26.99	27.04	26.97	27.01	164503.0
2006-01-05 17:00:00	MSFT	Stock	27.01	27.01	27.01	27.01	500.0
2006-01-05 18:00:00	MSFT	Stock	27.01	27.01	26.99	27.0	2061.0
2006-01-05 08:00:00	NVDA	Stock	0.3274	0.3274	0.3257	0.3257	48000.0
2006-01-05 09:00:00	NVDA	Stock	0.3271	0.3346	0.3269	0.3314	111558480.0
2006-01-05 10:00:00	NVDA	Stock	0.3316	0.3342	0.3298	0.3324	143948040.0
2006-01-05 11:00:00	NVDA	Stock	0.3324	0.3342	0.3323	0.3339	64738200.0
2006-01-05 12:00:00	NVDA	Stock	0.3338	0.3342	0.3322	0.3322	65997600.0
2006-01-05 13:00:00	NVDA	Stock	0.3323	0.3338	0.3322	0.3336	49842120.0
2006-01-05 14:00:00	NVDA	Stock	0.3335	0.3342	0.3318	0.3323	77168160.0
2006-01-05 15:00:00	NVDA	Stock	0.3323	0.3354	0.3322	0.3346	96043920.0
2006-01-05 16:00:00	NVDA	Stock	0.3348	0.3348	0.3295	0.3328	3543960.0
2006-01-05 17:00:00	NVDA	Stock	0.3348	0.3348	0.333	0.333	1085040.0
2006-01-05 08:00:00	AMZN	Stock	2.3625	2.3625	2.3525	2.3525	48000.0
2006-01-05 09:00:00	AMZN	Stock	2.3625	2.373	2.3555	2.3605	10756520.0
2006-01-05 10:00:00	AMZN	Stock	2.3605	2.381	2.3605	2.374	22930320.0
2006-01-05 11:00:00	AMZN	Stock	2.374	2.3985	2.374	2.3975	17840800.0
2006-01-05 12:00:00	AMZN	Stock	2.3975	2.41	2.3725	2.376	23174600.0
2006-01-05 13:00:00	AMZN	Stock	2.3765	2.408	2.3735	2.386	6212580.0
2006-01-05 14:00:00	AMZN	Stock	2.3865	2.3865	2.373	2.384	9545760.0
2006-01-05 15:00:00	AMZN	Stock	2.3835	2.387	2.38	2.384	15147420.0
2006-01-05 16:00:00	AMZN	Stock	2.3825	2.3885	2.3825	2.387	285560.0
2006-01-05 17:00:00	AMZN	Stock	2.387	2.3895	2.3755	2.3825	66000.0
2006-01-05 09:00:00	CL	Stock	27.855	27.971	27.695	27.695	251000.0
2006-01-05 10:00:00	CL	Stock	27.695	27.855	27.575	27.575	502200.0
2006-01-05 11:00:00	CL	Stock	27.575	27.62	27.5	27.515	509000.0
2006-01-05 12:00:00	CL	Stock	27.51	27.53	27.4	27.42	633400.0
2006-01-05 13:00:00	CL	Stock	27.415	27.465	27.35	27.4	526400.0
2006-01-05 14:00:00	CL	Stock	27.4	27.44	27.35	27.4	507000.0

> showing 50 of 28,512 rows — these rows as CSV

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