PREVIEW / stock_1hour / 2005-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-05.parquet
  size:    579 KB
  rows:    27,516
  symbols: 2,109

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-12-05 04:00:00	AAPL	Stock	2.5936	2.5936	2.5936	2.5936	5600.0
2005-12-05 07:00:00	AAPL	Stock	2.6	2.6	2.5932	2.6	118608.0
2005-12-05 08:00:00	AAPL	Stock	2.5946	2.6025	2.5761	2.5761	2173920.0
2005-12-05 09:00:00	AAPL	Stock	2.5743	2.5868	2.5618	2.5758	102681852.0
2005-12-05 10:00:00	AAPL	Stock	2.5764	2.5832	2.5532	2.5582	126853356.0
2005-12-05 11:00:00	AAPL	Stock	2.5586	2.5736	2.5536	2.5661	64747676.0
2005-12-05 12:00:00	AAPL	Stock	2.5662	2.5782	2.5632	2.5764	45191384.0
2005-12-05 13:00:00	AAPL	Stock	2.5768	2.5904	2.5736	2.5754	69254612.0
2005-12-05 14:00:00	AAPL	Stock	2.575	2.5846	2.5714	2.5789	56420448.0
2005-12-05 15:00:00	AAPL	Stock	2.5782	2.5786	2.5632	2.5643	91926044.0
2005-12-05 16:00:00	AAPL	Stock	2.565	2.5754	2.5629	2.5746	2225524.0
2005-12-05 17:00:00	AAPL	Stock	2.5725	2.5757	2.569	2.5714	191800.0
2005-12-05 18:00:00	AAPL	Stock	2.5682	2.5686	2.5618	2.565	830172.0
2005-12-05 08:00:00	MSFT	Stock	28.04	28.04	28.0	28.0	2950.0
2005-12-05 09:00:00	MSFT	Stock	27.99	28.02	27.9	27.931	5078208.0
2005-12-05 10:00:00	MSFT	Stock	27.93	27.97	27.72	27.74	7418479.0
2005-12-05 11:00:00	MSFT	Stock	27.74	27.83	27.71	27.81	6315179.0
2005-12-05 12:00:00	MSFT	Stock	27.8	27.83	27.77	27.81	5052188.0
2005-12-05 13:00:00	MSFT	Stock	27.8	27.81	27.75	27.77	4352087.0
2005-12-05 14:00:00	MSFT	Stock	27.77	27.802	27.74	27.79	6090482.0
2005-12-05 15:00:00	MSFT	Stock	27.78	27.87	27.75	27.85	9796824.0
2005-12-05 16:00:00	MSFT	Stock	27.84	27.87	27.81	27.86	127133.0
2005-12-05 18:00:00	MSFT	Stock	27.82	27.85	27.82	27.84	423800.0
2005-12-05 08:00:00	NVDA	Stock	0.305	0.305	0.305	0.305	72000.0
2005-12-05 09:00:00	NVDA	Stock	0.305	0.3062	0.3011	0.3021	25090080.0
2005-12-05 10:00:00	NVDA	Stock	0.3021	0.3029	0.2984	0.2998	48457320.0
2005-12-05 11:00:00	NVDA	Stock	0.2997	0.3001	0.2987	0.2992	23631480.0
2005-12-05 12:00:00	NVDA	Stock	0.2992	0.301	0.2989	0.2993	33506040.0
2005-12-05 13:00:00	NVDA	Stock	0.2993	0.3016	0.2986	0.2998	75839760.0
2005-12-05 14:00:00	NVDA	Stock	0.2997	0.3	0.2982	0.2992	68731920.0
2005-12-05 15:00:00	NVDA	Stock	0.2992	0.3008	0.2984	0.2992	79003440.0
2005-12-05 16:00:00	NVDA	Stock	0.2992	0.2994	0.2991	0.2993	1626600.0
2005-12-05 17:00:00	NVDA	Stock	0.2993	0.2993	0.2993	0.2993	753600.0
2005-12-05 18:00:00	NVDA	Stock	0.2992	0.2992	0.2992	0.2992	98400.0
2005-12-05 08:00:00	AMZN	Stock	2.4375	2.45	2.4375	2.45	60200.0
2005-12-05 09:00:00	AMZN	Stock	2.4405	2.4675	2.44	2.4605	14235000.0
2005-12-05 10:00:00	AMZN	Stock	2.461	2.465	2.438	2.447	18712280.0
2005-12-05 11:00:00	AMZN	Stock	2.4475	2.4625	2.445	2.458	11779700.0
2005-12-05 12:00:00	AMZN	Stock	2.458	2.467	2.452	2.4635	6861920.0
2005-12-05 13:00:00	AMZN	Stock	2.4635	2.465	2.4455	2.447	9524040.0
2005-12-05 14:00:00	AMZN	Stock	2.447	2.4515	2.44	2.4445	15850720.0
2005-12-05 15:00:00	AMZN	Stock	2.444	2.4485	2.4375	2.44	24590700.0
2005-12-05 16:00:00	AMZN	Stock	2.4405	2.4415	2.4395	2.441	281800.0
2005-12-05 17:00:00	AMZN	Stock	2.445	2.445	2.445	2.445	18700.0
2005-12-05 09:00:00	CL	Stock	27.485	27.595	27.45	27.595	394600.0
2005-12-05 10:00:00	CL	Stock	27.62	27.65	27.5205	27.565	424000.0
2005-12-05 11:00:00	CL	Stock	27.565	27.575	27.505	27.54	435200.0
2005-12-05 12:00:00	CL	Stock	27.545	27.55	27.4905	27.495	324800.0
2005-12-05 13:00:00	CL	Stock	27.495	27.58	27.475	27.545	309000.0
2005-12-05 14:00:00	CL	Stock	27.55	27.575	27.53	27.57	413600.0

> showing 50 of 27,516 rows — these rows as CSV

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