PREVIEW / stock_1hour / 2006-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-20.parquet
  size:    599 KB
  rows:    29,139
  symbols: 2,281

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-06-20 07:00:00	AAPL	Stock	2.0482	2.0511	2.0464	2.0464	64400.0
2006-06-20 08:00:00	AAPL	Stock	2.0468	2.0596	2.0443	2.0571	2156420.0
2006-06-20 09:00:00	AAPL	Stock	2.0554	2.0721	2.0461	2.0543	96836740.0
2006-06-20 10:00:00	AAPL	Stock	2.0546	2.0639	2.0464	2.0539	99837164.0
2006-06-20 11:00:00	AAPL	Stock	2.0539	2.0839	2.0529	2.0787	158997384.0
2006-06-20 12:00:00	AAPL	Stock	2.0789	2.0804	2.0646	2.065	69291348.0
2006-06-20 13:00:00	AAPL	Stock	2.065	2.0686	2.0536	2.0586	68712168.0
2006-06-20 14:00:00	AAPL	Stock	2.0582	2.0657	2.0507	2.0636	72629872.0
2006-06-20 15:00:00	AAPL	Stock	2.0636	2.065	2.0479	2.0521	95114908.0
2006-06-20 16:00:00	AAPL	Stock	2.0536	2.0564	2.05	2.055	1280692.0
2006-06-20 17:00:00	AAPL	Stock	2.0543	2.0546	2.0518	2.0518	570388.0
2006-06-20 18:00:00	AAPL	Stock	2.0536	2.0546	2.0504	2.0504	49504.0
2006-06-20 08:00:00	MSFT	Stock	22.53	22.55	22.52	22.54	7400.0
2006-06-20 09:00:00	MSFT	Stock	22.54	22.76	22.53	22.65	12459387.0
2006-06-20 10:00:00	MSFT	Stock	22.64	22.66	22.51	22.6	15998100.0
2006-06-20 11:00:00	MSFT	Stock	22.61	22.74	22.55	22.65	14518913.0
2006-06-20 12:00:00	MSFT	Stock	22.65	22.7	22.62	22.68	7134812.0
2006-06-20 13:00:00	MSFT	Stock	22.69	22.69	22.6	22.603	5961723.0
2006-06-20 14:00:00	MSFT	Stock	22.6	22.68	22.58	22.65	11447347.0
2006-06-20 15:00:00	MSFT	Stock	22.64	22.68	22.5	22.58	18294184.0
2006-06-20 16:00:00	MSFT	Stock	22.57	22.65	22.55	22.64	277757.0
2006-06-20 17:00:00	MSFT	Stock	22.63	22.65	22.56	22.63	47454.0
2006-06-20 18:00:00	MSFT	Stock	22.63	22.63	22.6	22.6	5012.0
2006-06-20 08:00:00	NVDA	Stock	0.346	0.3467	0.336	0.3427	1469100.0
2006-06-20 09:00:00	NVDA	Stock	0.3427	0.3458	0.3392	0.3407	68085840.0
2006-06-20 10:00:00	NVDA	Stock	0.3407	0.3445	0.34	0.3443	65409000.0
2006-06-20 11:00:00	NVDA	Stock	0.3443	0.3525	0.3433	0.3493	79400040.0
2006-06-20 12:00:00	NVDA	Stock	0.3495	0.3522	0.3482	0.3485	43674060.0
2006-06-20 13:00:00	NVDA	Stock	0.3485	0.3492	0.345	0.346	56281080.0
2006-06-20 14:00:00	NVDA	Stock	0.346	0.3467	0.34	0.3428	99210900.0
2006-06-20 15:00:00	NVDA	Stock	0.343	0.3457	0.3428	0.3447	102698040.0
2006-06-20 16:00:00	NVDA	Stock	0.3443	0.345	0.3442	0.3443	640620.0
2006-06-20 17:00:00	NVDA	Stock	0.345	0.345	0.3447	0.345	410340.0
2006-06-20 18:00:00	NVDA	Stock	0.347	0.347	0.347	0.347	6000.0
2006-06-20 09:00:00	AMZN	Stock	1.752	1.7625	1.744	1.76	9861820.0
2006-06-20 10:00:00	AMZN	Stock	1.76	1.773	1.7565	1.7645	13150360.0
2006-06-20 11:00:00	AMZN	Stock	1.7645	1.7825	1.7608	1.778	18867940.0
2006-06-20 12:00:00	AMZN	Stock	1.778	1.778	1.764	1.7685	6818880.0
2006-06-20 13:00:00	AMZN	Stock	1.7685	1.7705	1.7605	1.7645	5597720.0
2006-06-20 14:00:00	AMZN	Stock	1.7645	1.769	1.7575	1.7648	8493200.0
2006-06-20 15:00:00	AMZN	Stock	1.765	1.7765	1.7565	1.7735	25082720.0
2006-06-20 16:00:00	AMZN	Stock	1.7735	1.7785	1.7715	1.7715	82580.0
2006-06-20 17:00:00	AMZN	Stock	1.771	1.774	1.7665	1.774	147340.0
2006-06-20 09:00:00	CL	Stock	30.165	30.25	30.1	30.215	405400.0
2006-06-20 10:00:00	CL	Stock	30.225	30.315	30.175	30.25	637000.0
2006-06-20 11:00:00	CL	Stock	30.25	30.3	30.185	30.24	1080200.0
2006-06-20 12:00:00	CL	Stock	30.24	30.29	30.205	30.29	448600.0
2006-06-20 13:00:00	CL	Stock	30.285	30.325	30.215	30.235	355800.0
2006-06-20 14:00:00	CL	Stock	30.235	30.27	30.15	30.165	578600.0
2006-06-20 15:00:00	CL	Stock	30.165	30.2	30.045	30.085	1013600.0

> showing 50 of 29,139 rows — these rows as CSV

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