PREVIEW / stock_1hour / 2007-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-11.parquet
  size:    719 KB
  rows:    34,820
  symbols: 2,730

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
2007-05-11 09:00:00	AAPL	Stock	3.8479	3.8675	3.8096	3.8314	44411024.0
2007-05-11 10:00:00	AAPL	Stock	3.8318	3.8614	3.8136	3.8543	133314440.0
2007-05-11 11:00:00	AAPL	Stock	3.8546	3.8711	3.8486	3.8571	88234580.0
2007-05-11 12:00:00	AAPL	Stock	3.8571	3.875	3.8482	3.8728	79537668.0
2007-05-11 13:00:00	AAPL	Stock	3.8729	3.8839	3.8686	3.8804	77846636.0
2007-05-11 14:00:00	AAPL	Stock	3.8804	3.8811	3.8632	3.8761	65430372.0
2007-05-11 15:00:00	AAPL	Stock	3.8761	3.8975	3.8704	3.8857	122361540.0
2007-05-11 16:00:00	AAPL	Stock	3.8839	3.8843	3.8836	3.8836	3552892.0
2007-05-11 09:00:00	MSFT	Stock	30.57	30.82	30.56	30.75	2008551.0
2007-05-11 10:00:00	MSFT	Stock	30.75	30.91	30.69	30.89	6541068.0
2007-05-11 11:00:00	MSFT	Stock	30.89	30.93	30.85	30.88	5026400.0
2007-05-11 12:00:00	MSFT	Stock	30.89	30.91	30.84	30.89	3128247.0
2007-05-11 13:00:00	MSFT	Stock	30.89	30.93	30.85	30.88	3117524.0
2007-05-11 14:00:00	MSFT	Stock	30.88	30.95	30.85	30.94	4073662.0
2007-05-11 15:00:00	MSFT	Stock	30.93	30.98	30.84	30.9	12734922.0
2007-05-11 16:00:00	MSFT	Stock	30.9	30.91	30.89	30.89	812221.0
2007-05-11 04:00:00	NVDA	Stock	0.565	0.565	0.565	0.565	7200.0
2007-05-11 07:00:00	NVDA	Stock	0.5748	0.575	0.5745	0.575	1794840.0
2007-05-11 08:00:00	NVDA	Stock	0.575	0.58	0.572	0.5733	16180440.0
2007-05-11 09:00:00	NVDA	Stock	0.574	0.5817	0.5678	0.5785	221371800.0
2007-05-11 10:00:00	NVDA	Stock	0.5785	0.5913	0.5683	0.5858	495666000.0
2007-05-11 11:00:00	NVDA	Stock	0.5858	0.5883	0.5808	0.585	217167120.0
2007-05-11 12:00:00	NVDA	Stock	0.585	0.5872	0.5817	0.5858	96613800.0
2007-05-11 13:00:00	NVDA	Stock	0.5858	0.5862	0.5845	0.5852	85800600.0
2007-05-11 14:00:00	NVDA	Stock	0.5853	0.5867	0.5845	0.5853	86624160.0
2007-05-11 15:00:00	NVDA	Stock	0.5855	0.5888	0.5837	0.5863	248565540.0
2007-05-11 16:00:00	NVDA	Stock	0.5857	0.5865	0.5855	0.5857	6017340.0
2007-05-11 17:00:00	NVDA	Stock	0.5852	0.5863	0.585	0.5863	519420.0
2007-05-11 18:00:00	NVDA	Stock	0.5855	0.5863	0.5855	0.5862	252000.0
2007-05-11 19:00:00	NVDA	Stock	0.5855	0.5862	0.5855	0.5855	54000.0
2007-05-11 06:00:00	AMZN	Stock	3.044	3.044	3.044	3.044	2000.0
2007-05-11 07:00:00	AMZN	Stock	3.044	3.044	3.044	3.044	2000.0
2007-05-11 08:00:00	AMZN	Stock	3.054	3.065	3.0445	3.0615	90280.0
2007-05-11 09:00:00	AMZN	Stock	3.0615	3.0675	3.0365	3.046	12365460.0
2007-05-11 10:00:00	AMZN	Stock	3.0464	3.05	3.028	3.044	29337760.0
2007-05-11 11:00:00	AMZN	Stock	3.0435	3.0795	3.041	3.066	30393300.0
2007-05-11 12:00:00	AMZN	Stock	3.0665	3.0725	3.052	3.071	17620680.0
2007-05-11 13:00:00	AMZN	Stock	3.071	3.073	3.051	3.056	15503120.0
2007-05-11 14:00:00	AMZN	Stock	3.0565	3.063	3.046	3.0485	14949040.0
2007-05-11 15:00:00	AMZN	Stock	3.0485	3.08	3.0465	3.0765	29375900.0
2007-05-11 16:00:00	AMZN	Stock	3.078	3.081	3.0765	3.079	2512280.0
2007-05-11 17:00:00	AMZN	Stock	3.079	3.08	3.079	3.0795	26300.0
2007-05-11 18:00:00	AMZN	Stock	3.0795	3.0795	3.0775	3.0795	18300.0
2007-05-11 19:00:00	AMZN	Stock	3.0795	3.0835	3.0795	3.0795	36920.0
2007-05-11 09:00:00	TLT	Stock	88.64	88.68	88.62	88.67	54300.0
2007-05-11 10:00:00	TLT	Stock	88.67	88.7	88.6	88.62	72100.0
2007-05-11 11:00:00	TLT	Stock	88.6	88.61	88.5	88.5	29100.0
2007-05-11 12:00:00	TLT	Stock	88.5	88.5	88.29	88.31	45300.0
2007-05-11 13:00:00	TLT	Stock	88.29	88.31	88.13	88.23	256700.0
2007-05-11 14:00:00	TLT	Stock	88.22	88.24	88.15	88.23	63700.0

> showing 50 of 34,820 rows — these rows as CSV

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