PREVIEW / stock_1hour / 2008-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-19.parquet
  size:    832 KB
  rows:    39,945
  symbols: 3,323

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
2008-06-19 05:00:00	AAPL	Stock	6.3857	6.3857	6.3857	6.3857	33600.0
2008-06-19 06:00:00	AAPL	Stock	6.3868	6.3893	6.3868	6.3893	56224.0
2008-06-19 07:00:00	AAPL	Stock	6.3893	6.4214	6.3839	6.4107	278600.0
2008-06-19 08:00:00	AAPL	Stock	6.4107	6.4125	6.3679	6.3679	2270016.0
2008-06-19 09:00:00	AAPL	Stock	6.3711	6.4279	6.3482	6.403	94439520.0
2008-06-19 10:00:00	AAPL	Stock	6.4032	6.4325	6.3143	6.4243	145495196.0
2008-06-19 11:00:00	AAPL	Stock	6.4243	6.4414	6.3529	6.4057	97120940.0
2008-06-19 12:00:00	AAPL	Stock	6.4054	6.4864	6.4025	6.452	114124136.0
2008-06-19 13:00:00	AAPL	Stock	6.4514	6.48	6.4157	6.4457	71151528.0
2008-06-19 14:00:00	AAPL	Stock	6.4457	6.5086	6.43	6.4979	113026480.0
2008-06-19 15:00:00	AAPL	Stock	6.4979	6.5121	6.4532	6.4636	116771032.0
2008-06-19 16:00:00	AAPL	Stock	6.4636	6.4845	6.4314	6.4629	7695968.0
2008-06-19 17:00:00	AAPL	Stock	6.4661	6.4696	6.465	6.4682	279916.0
2008-06-19 18:00:00	AAPL	Stock	6.47	6.4707	6.4668	6.4696	383264.0
2008-06-19 19:00:00	AAPL	Stock	6.4696	6.4696	6.4639	6.4639	381948.0
2008-06-19 08:00:00	MSFT	Stock	28.6	28.64	28.46	28.55	29877.0
2008-06-19 09:00:00	MSFT	Stock	28.54	28.76	28.5	28.57	3856743.0
2008-06-19 10:00:00	MSFT	Stock	28.56	28.62	28.33	28.51	10573727.0
2008-06-19 11:00:00	MSFT	Stock	28.51	28.755	28.47	28.74	6668408.0
2008-06-19 12:00:00	MSFT	Stock	28.74	28.97	28.72	28.912	8950348.0
2008-06-19 13:00:00	MSFT	Stock	28.91	29.0	28.83	28.92	6204178.0
2008-06-19 14:00:00	MSFT	Stock	28.91	29.19	28.86	29.115	9052228.0
2008-06-19 15:00:00	MSFT	Stock	29.11	29.18	28.85	28.95	12952744.0
2008-06-19 16:00:00	MSFT	Stock	28.95	29.085	28.532	28.95	2158726.0
2008-06-19 17:00:00	MSFT	Stock	28.99	29.01	28.803	29.0	38861.0
2008-06-19 18:00:00	MSFT	Stock	28.94	28.94	28.94	28.94	153.0
2008-06-19 19:00:00	MSFT	Stock	28.97	28.97	28.95	28.95	9850.0
2008-06-19 08:00:00	NVDA	Stock	0.4998	0.5025	0.4975	0.5	174000.0
2008-06-19 09:00:00	NVDA	Stock	0.5	0.5005	0.489	0.49	78725760.0
2008-06-19 10:00:00	NVDA	Stock	0.49	0.4988	0.4845	0.4982	179949800.0
2008-06-19 11:00:00	NVDA	Stock	0.498	0.502	0.4938	0.4975	85592680.0
2008-06-19 12:00:00	NVDA	Stock	0.4975	0.5075	0.4972	0.5003	108532200.0
2008-06-19 13:00:00	NVDA	Stock	0.5003	0.5038	0.4982	0.4985	55078920.0
2008-06-19 14:00:00	NVDA	Stock	0.4988	0.5048	0.4968	0.5018	89145720.0
2008-06-19 15:00:00	NVDA	Stock	0.5015	0.5022	0.4948	0.496	164719280.0
2008-06-19 16:00:00	NVDA	Stock	0.497	0.5008	0.4948	0.4982	4669640.0
2008-06-19 17:00:00	NVDA	Stock	0.4982	0.4982	0.4955	0.4955	60000.0
2008-06-19 18:00:00	NVDA	Stock	0.4975	0.4978	0.4975	0.4978	4122000.0
2008-06-19 19:00:00	NVDA	Stock	0.4955	0.4992	0.4955	0.4975	63600.0
2008-06-19 09:00:00	AMZN	Stock	4.082	4.1735	4.082	4.135	9530380.0
2008-06-19 10:00:00	AMZN	Stock	4.129	4.145	4.0795	4.1315	17174680.0
2008-06-19 11:00:00	AMZN	Stock	4.1315	4.1425	4.075	4.1085	28424200.0
2008-06-19 12:00:00	AMZN	Stock	4.1085	4.168	4.099	4.1235	22683740.0
2008-06-19 13:00:00	AMZN	Stock	4.1235	4.16	4.123	4.159	10774360.0
2008-06-19 14:00:00	AMZN	Stock	4.159	4.206	4.143	4.1975	14181000.0
2008-06-19 15:00:00	AMZN	Stock	4.1971	4.2235	4.1905	4.213	25583120.0
2008-06-19 16:00:00	AMZN	Stock	4.213	4.2225	4.1459	4.2225	2122140.0
2008-06-19 17:00:00	AMZN	Stock	4.2235	4.2325	4.21	4.21	60080.0
2008-06-19 18:00:00	AMZN	Stock	4.208	4.208	4.208	4.208	2000.0
2008-06-19 08:00:00	TLT	Stock	89.4	89.4	89.4	89.4	150.0

> showing 50 of 39,945 rows — these rows as CSV

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