PREVIEW / stock_1hour / 2007-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-01.parquet
  size:    720 KB
  rows:    33,819
  symbols: 2,677

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-01 09:00:00	AAPL	Stock	3.5568	3.5839	3.5475	3.5579	73521420.0
2007-05-01 10:00:00	AAPL	Stock	3.5579	3.5607	3.5196	3.5311	131455828.0
2007-05-01 11:00:00	AAPL	Stock	3.5304	3.5836	3.525	3.5418	68989536.0
2007-05-01 12:00:00	AAPL	Stock	3.5414	3.5464	3.5272	3.5286	38687376.0
2007-05-01 13:00:00	AAPL	Stock	3.5286	3.55	3.5214	3.5482	64246560.0
2007-05-01 14:00:00	AAPL	Stock	3.5482	3.5664	3.5414	3.5565	63771792.0
2007-05-01 15:00:00	AAPL	Stock	3.5564	3.5614	3.5446	3.5525	69124216.0
2007-05-01 16:00:00	AAPL	Stock	3.5525	3.5525	3.55	3.5525	5500572.0
2007-05-01 09:00:00	MSFT	Stock	29.94	30.08	29.9	30.06	7843812.0
2007-05-01 10:00:00	MSFT	Stock	30.06	30.27	29.96	30.25	14074636.0
2007-05-01 11:00:00	MSFT	Stock	30.25	30.29	30.19	30.192	8077628.0
2007-05-01 12:00:00	MSFT	Stock	30.2	30.26	30.08	30.11	6301771.0
2007-05-01 13:00:00	MSFT	Stock	30.11	30.21	30.1	30.17	5789049.0
2007-05-01 14:00:00	MSFT	Stock	30.16	30.32	30.14	30.31	8881096.0
2007-05-01 15:00:00	MSFT	Stock	30.31	30.42	30.18	30.41	16225728.0
2007-05-01 16:00:00	MSFT	Stock	30.4	30.42	30.4	30.4	1126750.0
2007-05-01 09:00:00	NVDA	Stock	0.5558	0.5592	0.5525	0.5553	71948160.0
2007-05-01 10:00:00	NVDA	Stock	0.555	0.5575	0.5495	0.5573	118045860.0
2007-05-01 11:00:00	NVDA	Stock	0.5575	0.5618	0.5533	0.5543	65817780.0
2007-05-01 12:00:00	NVDA	Stock	0.5545	0.5565	0.553	0.5552	56217600.0
2007-05-01 13:00:00	NVDA	Stock	0.5552	0.5563	0.5502	0.5555	60877320.0
2007-05-01 14:00:00	NVDA	Stock	0.5557	0.561	0.5538	0.5575	63969060.0
2007-05-01 15:00:00	NVDA	Stock	0.5577	0.5588	0.5527	0.5542	93740580.0
2007-05-01 16:00:00	NVDA	Stock	0.5542	0.557	0.554	0.557	6975780.0
2007-05-01 17:00:00	NVDA	Stock	0.556	0.556	0.556	0.556	30000.0
2007-05-01 18:00:00	NVDA	Stock	0.5567	0.5567	0.556	0.556	37200.0
2007-05-01 19:00:00	NVDA	Stock	0.5567	0.5567	0.556	0.556	160800.0
2007-05-01 07:00:00	AMZN	Stock	3.0575	3.071	3.0335	3.071	118000.0
2007-05-01 08:00:00	AMZN	Stock	3.065	3.0775	3.0625	3.0625	1650160.0
2007-05-01 09:00:00	AMZN	Stock	3.061	3.0885	3.0375	3.0475	45013140.0
2007-05-01 10:00:00	AMZN	Stock	3.0475	3.075	3.0305	3.068	75091940.0
2007-05-01 11:00:00	AMZN	Stock	3.0675	3.0795	3.052	3.058	37846780.0
2007-05-01 12:00:00	AMZN	Stock	3.058	3.0595	3.038	3.047	26771340.0
2007-05-01 13:00:00	AMZN	Stock	3.047	3.0625	3.014	3.0485	51395320.0
2007-05-01 14:00:00	AMZN	Stock	3.0495	3.0875	3.0455	3.073	48543640.0
2007-05-01 15:00:00	AMZN	Stock	3.0735	3.102	3.064	3.102	69207180.0
2007-05-01 16:00:00	AMZN	Stock	3.102	3.109	3.1015	3.105	10071160.0
2007-05-01 17:00:00	AMZN	Stock	3.1045	3.105	3.102	3.103	210720.0
2007-05-01 18:00:00	AMZN	Stock	3.103	3.105	3.1015	3.1015	154780.0
2007-05-01 19:00:00	AMZN	Stock	3.1015	3.104	3.1015	3.104	192940.0
2007-05-01 09:00:00	CL	Stock	33.925	33.94	33.6	33.905	642800.0
2007-05-01 10:00:00	CL	Stock	33.93	33.975	33.755	33.785	872182.0
2007-05-01 11:00:00	CL	Stock	33.785	33.965	33.765	33.95	694844.0
2007-05-01 12:00:00	CL	Stock	33.95	33.98	33.895	33.92	575000.0
2007-05-01 13:00:00	CL	Stock	33.915	33.99	33.83	33.965	497600.0
2007-05-01 14:00:00	CL	Stock	33.965	34.015	33.96	33.9805	637800.0
2007-05-01 15:00:00	CL	Stock	33.985	34.055	33.96	34.025	786000.0
2007-05-01 16:00:00	CL	Stock	34.05	34.05	34.05	34.05	33000.0

> showing 48 of 33,819 rows — these rows as CSV

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