PREVIEW / stock_1hour / 2006-01-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-01-09.parquet
  size:    591 KB
  rows:    28,149
  symbols: 2,176

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-09 08:00:00	AAPL	Stock	2.7357	2.7554	2.725	2.7471	5007352.0
2006-01-09 09:00:00	AAPL	Stock	2.7471	2.7571	2.7311	2.7379	116224192.0
2006-01-09 10:00:00	AAPL	Stock	2.7375	2.7464	2.7196	2.7407	130446764.0
2006-01-09 11:00:00	AAPL	Stock	2.7407	2.7418	2.725	2.73	67707192.0
2006-01-09 12:00:00	AAPL	Stock	2.73	2.7496	2.7189	2.7421	80654140.0
2006-01-09 13:00:00	AAPL	Stock	2.7421	2.7457	2.7329	2.7332	55135388.0
2006-01-09 14:00:00	AAPL	Stock	2.7332	2.7357	2.705	2.7118	100199092.0
2006-01-09 15:00:00	AAPL	Stock	2.7114	2.7196	2.7057	2.7154	104850396.0
2006-01-09 16:00:00	AAPL	Stock	2.7157	2.7182	2.71	2.7164	4316508.0
2006-01-09 17:00:00	AAPL	Stock	2.7171	2.7171	2.7136	2.7161	414932.0
2006-01-09 18:00:00	AAPL	Stock	2.7171	2.7171	2.7118	2.7136	402052.0
2006-01-09 06:00:00	MSFT	Stock	26.85	26.85	26.85	26.85	1000.0
2006-01-09 07:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	4500.0
2006-01-09 08:00:00	MSFT	Stock	26.99	27.04	26.91	26.99	36935.0
2006-01-09 09:00:00	MSFT	Stock	26.95	26.98	26.82	26.842	9646907.0
2006-01-09 10:00:00	MSFT	Stock	26.84	26.96	26.76	26.93	7970148.0
2006-01-09 11:00:00	MSFT	Stock	26.93	27.01	26.9	27.0	6045054.0
2006-01-09 12:00:00	MSFT	Stock	27.0	27.07	26.96	27.01	6325400.0
2006-01-09 13:00:00	MSFT	Stock	27.0	27.03	26.96	26.99	6511602.0
2006-01-09 14:00:00	MSFT	Stock	26.99	27.02	26.91	26.91	6869035.0
2006-01-09 15:00:00	MSFT	Stock	26.91	26.93	26.82	26.86	9639752.0
2006-01-09 16:00:00	MSFT	Stock	26.88	26.89	26.82	26.86	525222.0
2006-01-09 17:00:00	MSFT	Stock	26.86	26.88	26.85	26.87	663.0
2006-01-09 18:00:00	MSFT	Stock	26.85	26.87	26.85	26.87	2790.0
2006-01-09 08:00:00	NVDA	Stock	0.335	0.3355	0.335	0.3355	156000.0
2006-01-09 09:00:00	NVDA	Stock	0.3387	0.3457	0.3385	0.3444	67468680.0
2006-01-09 10:00:00	NVDA	Stock	0.3441	0.3481	0.3427	0.3475	84772200.0
2006-01-09 11:00:00	NVDA	Stock	0.3475	0.349	0.3466	0.349	56453040.0
2006-01-09 12:00:00	NVDA	Stock	0.349	0.3492	0.3475	0.3492	66149520.0
2006-01-09 13:00:00	NVDA	Stock	0.3492	0.3513	0.3483	0.3508	55643280.0
2006-01-09 14:00:00	NVDA	Stock	0.3508	0.3517	0.3468	0.3472	88110120.0
2006-01-09 15:00:00	NVDA	Stock	0.3472	0.3501	0.3462	0.3496	114842640.0
2006-01-09 16:00:00	NVDA	Stock	0.3498	0.3498	0.3486	0.3496	382200.0
2006-01-09 06:00:00	AMZN	Stock	2.325	2.325	2.325	2.325	4000.0
2006-01-09 07:00:00	AMZN	Stock	2.3225	2.3225	2.306	2.32	355300.0
2006-01-09 08:00:00	AMZN	Stock	2.3225	2.34	2.32	2.326	1219620.0
2006-01-09 09:00:00	AMZN	Stock	2.3255	2.3465	2.3215	2.3295	38892860.0
2006-01-09 10:00:00	AMZN	Stock	2.328	2.355	2.32	2.336	37032000.0
2006-01-09 11:00:00	AMZN	Stock	2.3365	2.35	2.331	2.343	19965460.0
2006-01-09 12:00:00	AMZN	Stock	2.343	2.35	2.336	2.3415	13525060.0
2006-01-09 13:00:00	AMZN	Stock	2.341	2.349	2.332	2.3445	14765320.0
2006-01-09 14:00:00	AMZN	Stock	2.3445	2.346	2.326	2.3305	17647920.0
2006-01-09 15:00:00	AMZN	Stock	2.3295	2.355	2.328	2.353	30859000.0
2006-01-09 16:00:00	AMZN	Stock	2.354	2.358	2.3418	2.3525	954200.0
2006-01-09 17:00:00	AMZN	Stock	2.3525	2.3525	2.3405	2.3405	19540.0
2006-01-09 18:00:00	AMZN	Stock	2.35	2.3515	2.35	2.3515	38480.0
2006-01-09 09:00:00	CL	Stock	27.34	27.5	27.31	27.465	272000.0
2006-01-09 10:00:00	CL	Stock	27.465	27.525	27.41	27.515	436000.0
2006-01-09 11:00:00	CL	Stock	27.52	27.58	27.465	27.565	565600.0
2006-01-09 12:00:00	CL	Stock	27.57	27.575	27.495	27.55	370000.0

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

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