PREVIEW / stock_1hour / 2007-05-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-30.parquet
  size:    759 KB
  rows:    37,131
  symbols: 3,019

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-30 09:00:00	AAPL	Stock	4.0821	4.1068	4.0546	4.1018	192121692.0
2007-05-30 10:00:00	AAPL	Stock	4.1021	4.145	4.0982	4.1182	295224188.0
2007-05-30 11:00:00	AAPL	Stock	4.1181	4.1443	4.1132	4.1296	133958888.0
2007-05-30 12:00:00	AAPL	Stock	4.1298	4.1846	4.1254	4.1846	155233876.0
2007-05-30 13:00:00	AAPL	Stock	4.1843	4.2096	4.1607	4.1986	199342164.0
2007-05-30 14:00:00	AAPL	Stock	4.1986	4.2057	4.1711	4.2021	206001684.0
2007-05-30 15:00:00	AAPL	Stock	4.2021	4.2457	4.1929	4.2429	236697076.0
2007-05-30 16:00:00	AAPL	Stock	4.2436	4.2436	4.2411	4.2418	9606940.0
2007-05-30 09:00:00	MSFT	Stock	30.55	30.79	30.51	30.63	6849941.0
2007-05-30 10:00:00	MSFT	Stock	30.64	30.9	30.57	30.79	11055840.0
2007-05-30 11:00:00	MSFT	Stock	30.79	30.93	30.79	30.84	4926652.0
2007-05-30 12:00:00	MSFT	Stock	30.84	30.9	30.81	30.86	3850129.0
2007-05-30 13:00:00	MSFT	Stock	30.86	30.88	30.79	30.8	3687929.0
2007-05-30 14:00:00	MSFT	Stock	30.802	30.94	30.75	30.93	7866271.0
2007-05-30 15:00:00	MSFT	Stock	30.93	31.13	30.887	31.12	13060895.0
2007-05-30 16:00:00	MSFT	Stock	31.12	31.12	31.11	31.11	1281506.0
2007-05-30 07:00:00	NVDA	Stock	0.5655	0.5655	0.5655	0.5655	12000.0
2007-05-30 08:00:00	NVDA	Stock	0.5518	0.5583	0.5518	0.5583	168000.0
2007-05-30 09:00:00	NVDA	Stock	0.5543	0.5617	0.5533	0.5613	34334760.0
2007-05-30 10:00:00	NVDA	Stock	0.5613	0.566	0.5605	0.5625	60158280.0
2007-05-30 11:00:00	NVDA	Stock	0.5627	0.5638	0.561	0.5629	34698000.0
2007-05-30 12:00:00	NVDA	Stock	0.563	0.5658	0.562	0.562	22339920.0
2007-05-30 13:00:00	NVDA	Stock	0.562	0.5632	0.5595	0.5602	18852720.0
2007-05-30 14:00:00	NVDA	Stock	0.56	0.567	0.5568	0.5668	64300620.0
2007-05-30 15:00:00	NVDA	Stock	0.5668	0.5683	0.5652	0.5678	73466640.0
2007-05-30 16:00:00	NVDA	Stock	0.5678	0.5684	0.5678	0.5682	14749500.0
2007-05-30 17:00:00	NVDA	Stock	0.5673	0.5683	0.5673	0.5683	144000.0
2007-05-30 18:00:00	NVDA	Stock	0.5683	0.5683	0.5683	0.5683	120000.0
2007-05-30 06:00:00	AMZN	Stock	3.465	3.465	3.465	3.465	2700.0
2007-05-30 08:00:00	AMZN	Stock	3.463	3.4775	3.445	3.448	732060.0
2007-05-30 09:00:00	AMZN	Stock	3.4475	3.49	3.4425	3.4702	27971880.0
2007-05-30 10:00:00	AMZN	Stock	3.469	3.482	3.445	3.4685	31627000.0
2007-05-30 11:00:00	AMZN	Stock	3.4685	3.4825	3.4565	3.469	26334300.0
2007-05-30 12:00:00	AMZN	Stock	3.47	3.485	3.464	3.4755	20533700.0
2007-05-30 13:00:00	AMZN	Stock	3.4755	3.477	3.458	3.4655	14535120.0
2007-05-30 14:00:00	AMZN	Stock	3.4645	3.504	3.445	3.5015	39149220.0
2007-05-30 15:00:00	AMZN	Stock	3.5015	3.5025	3.483	3.4925	44186440.0
2007-05-30 16:00:00	AMZN	Stock	3.493	3.495	3.49	3.49	1051500.0
2007-05-30 17:00:00	AMZN	Stock	3.493	3.495	3.493	3.495	50000.0
2007-05-30 18:00:00	AMZN	Stock	3.4955	3.497	3.4935	3.497	121000.0
2007-05-30 19:00:00	AMZN	Stock	3.4935	3.4975	3.4935	3.4975	29400.0
2007-05-30 09:00:00	TLT	Stock	86.79	86.79	86.63	86.64	61800.0
2007-05-30 10:00:00	TLT	Stock	86.63	86.65	86.56	86.59	86500.0
2007-05-30 11:00:00	TLT	Stock	86.59	86.64	86.52	86.53	47700.0
2007-05-30 12:00:00	TLT	Stock	86.52	86.52	86.45	86.5	53100.0
2007-05-30 13:00:00	TLT	Stock	86.51	86.51	86.43	86.48	106500.0
2007-05-30 14:00:00	TLT	Stock	86.49	86.59	86.39	86.49	190600.0
2007-05-30 15:00:00	TLT	Stock	86.5	86.57	86.47	86.54	63100.0
2007-05-30 09:00:00	CL	Stock	33.29	33.375	33.225	33.25	400524.0
2007-05-30 10:00:00	CL	Stock	33.255	33.355	33.205	33.265	1196200.0

> showing 50 of 37,131 rows — these rows as CSV

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