PREVIEW / stock_1hour / 2006-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-17.parquet
  size:    630 KB
  rows:    30,220
  symbols: 2,435

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-11-17 05:00:00	AAPL	Stock	3.0554	3.0554	3.0554	3.0554	14000.0
2006-11-17 07:00:00	AAPL	Stock	3.0511	3.0511	3.0475	3.0475	11200.0
2006-11-17 08:00:00	AAPL	Stock	3.0554	3.0586	3.0354	3.0375	1882804.0
2006-11-17 09:00:00	AAPL	Stock	3.0375	3.0643	3.0357	3.0607	99291836.0
2006-11-17 10:00:00	AAPL	Stock	3.0607	3.0621	3.0404	3.0404	69441092.0
2006-11-17 11:00:00	AAPL	Stock	3.0404	3.0518	3.0361	3.05	50867600.0
2006-11-17 12:00:00	AAPL	Stock	3.05	3.0693	3.0482	3.065	60445028.0
2006-11-17 13:00:00	AAPL	Stock	3.0646	3.0682	3.0396	3.0564	49008092.0
2006-11-17 14:00:00	AAPL	Stock	3.0561	3.0643	3.0482	3.0643	45977988.0
2006-11-17 15:00:00	AAPL	Stock	3.0639	3.0675	3.0554	3.0671	74899244.0
2006-11-17 16:00:00	AAPL	Stock	3.0675	3.0682	3.065	3.0671	1786932.0
2006-11-17 17:00:00	AAPL	Stock	3.0671	3.0711	3.0661	3.0711	402220.0
2006-11-17 18:00:00	AAPL	Stock	3.0711	3.0711	3.0671	3.0671	42196.0
2006-11-17 19:00:00	AAPL	Stock	3.0711	3.0711	3.065	3.065	194404.0
2006-11-17 07:00:00	MSFT	Stock	29.37	29.37	29.37	29.37	400.0
2006-11-17 08:00:00	MSFT	Stock	29.38	29.43	29.31	29.35	23615.0
2006-11-17 09:00:00	MSFT	Stock	29.33	29.48	29.26	29.48	9837809.0
2006-11-17 10:00:00	MSFT	Stock	29.48	29.54	29.39	29.4	7125444.0
2006-11-17 11:00:00	MSFT	Stock	29.4	29.44	29.37	29.4	3274772.0
2006-11-17 12:00:00	MSFT	Stock	29.4	29.52	29.4	29.46	3054926.0
2006-11-17 13:00:00	MSFT	Stock	29.46	29.5	29.38	29.4	3264471.0
2006-11-17 14:00:00	MSFT	Stock	29.4	29.41	29.38	29.4	3920098.0
2006-11-17 15:00:00	MSFT	Stock	29.4	29.45	29.32	29.39	9788549.0
2006-11-17 16:00:00	MSFT	Stock	29.4	29.45	29.39	29.39	350726.0
2006-11-17 17:00:00	MSFT	Stock	29.4	29.4	29.4	29.4	300.0
2006-11-17 18:00:00	MSFT	Stock	29.4	29.4	29.4	29.4	1116.0
2006-11-17 19:00:00	MSFT	Stock	29.42	29.42	29.42	29.42	100.0
2006-11-17 08:00:00	NVDA	Stock	0.6038	0.6038	0.6008	0.603	198000.0
2006-11-17 09:00:00	NVDA	Stock	0.6017	0.6058	0.5958	0.6055	69702180.0
2006-11-17 10:00:00	NVDA	Stock	0.6055	0.607	0.6013	0.6058	55259040.0
2006-11-17 11:00:00	NVDA	Stock	0.6058	0.6067	0.6017	0.6018	47473140.0
2006-11-17 12:00:00	NVDA	Stock	0.6017	0.6067	0.6017	0.6037	45057780.0
2006-11-17 13:00:00	NVDA	Stock	0.6037	0.6047	0.6027	0.6033	33817620.0
2006-11-17 14:00:00	NVDA	Stock	0.6033	0.6052	0.6023	0.6038	34769700.0
2006-11-17 15:00:00	NVDA	Stock	0.604	0.6053	0.6025	0.6053	58274160.0
2006-11-17 16:00:00	NVDA	Stock	0.6048	0.6055	0.6038	0.6043	1206180.0
2006-11-17 17:00:00	NVDA	Stock	0.6048	0.6048	0.6048	0.6048	30120.0
2006-11-17 19:00:00	NVDA	Stock	0.605	0.6053	0.605	0.6053	88500.0
2006-11-17 08:00:00	AMZN	Stock	2.131	2.141	2.125	2.128	264500.0
2006-11-17 09:00:00	AMZN	Stock	2.1275	2.1335	2.12	2.1225	25307020.0
2006-11-17 10:00:00	AMZN	Stock	2.1225	2.1235	2.113	2.117	26435200.0
2006-11-17 11:00:00	AMZN	Stock	2.117	2.1195	2.111	2.116	15577420.0
2006-11-17 12:00:00	AMZN	Stock	2.116	2.1275	2.116	2.1245	18145820.0
2006-11-17 13:00:00	AMZN	Stock	2.1245	2.1325	2.1235	2.126	10927900.0
2006-11-17 14:00:00	AMZN	Stock	2.1265	2.1305	2.123	2.1275	12961100.0
2006-11-17 15:00:00	AMZN	Stock	2.1275	2.131	2.1245	2.131	14798740.0
2006-11-17 16:00:00	AMZN	Stock	2.129	2.1315	2.1265	2.1265	854700.0
2006-11-17 18:00:00	AMZN	Stock	2.128	2.128	2.128	2.128	20000.0
2006-11-17 19:00:00	AMZN	Stock	2.128	2.128	2.125	2.125	90000.0
2006-11-17 09:00:00	CL	Stock	32.735	32.825	32.67	32.74	777800.0

> showing 50 of 30,220 rows — these rows as CSV

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