PREVIEW / stock_1hour / 2007-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-10.parquet
  size:    676 KB
  rows:    31,835
  symbols: 2,579

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-04-10 08:00:00	AAPL	Stock	3.3471	3.3479	3.3411	3.3479	439908.0
2007-04-10 09:00:00	AAPL	Stock	3.3461	3.36	3.3407	3.3514	47654012.0
2007-04-10 10:00:00	AAPL	Stock	3.3511	3.3557	3.3432	3.3464	52722824.0
2007-04-10 11:00:00	AAPL	Stock	3.3468	3.3486	3.3393	3.3421	48743660.0
2007-04-10 12:00:00	AAPL	Stock	3.3418	3.3475	3.3396	3.3396	37265760.0
2007-04-10 13:00:00	AAPL	Stock	3.3393	3.3475	3.3361	3.3443	42806988.0
2007-04-10 14:00:00	AAPL	Stock	3.3439	3.3482	3.3429	3.3446	32985792.0
2007-04-10 15:00:00	AAPL	Stock	3.345	3.3664	3.3411	3.3657	81262944.0
2007-04-10 16:00:00	AAPL	Stock	3.3661	3.3664	3.3475	3.365	5155416.0
2007-04-10 17:00:00	AAPL	Stock	3.365	3.3654	3.3643	3.3654	143276.0
2007-04-10 18:00:00	AAPL	Stock	3.3654	3.3679	3.3654	3.3679	116424.0
2007-04-10 19:00:00	AAPL	Stock	3.3671	3.3671	3.3639	3.3643	58800.0
2007-04-10 06:00:00	MSFT	Stock	28.57	28.57	28.57	28.57	500.0
2007-04-10 07:00:00	MSFT	Stock	28.57	28.57	28.47	28.47	6500.0
2007-04-10 08:00:00	MSFT	Stock	28.47	28.6	28.47	28.52	8895.0
2007-04-10 09:00:00	MSFT	Stock	28.51	28.58	28.44	28.53	5831083.0
2007-04-10 10:00:00	MSFT	Stock	28.532	28.64	28.52	28.54	4410874.0
2007-04-10 11:00:00	MSFT	Stock	28.54	28.599	28.39	28.49	5595093.0
2007-04-10 12:00:00	MSFT	Stock	28.49	28.5	28.39	28.39	2790003.0
2007-04-10 13:00:00	MSFT	Stock	28.39	28.44	28.28	28.3	4388598.0
2007-04-10 14:00:00	MSFT	Stock	28.298	28.4	28.22	28.25	5541508.0
2007-04-10 15:00:00	MSFT	Stock	28.24	28.43	28.24	28.39	6879591.0
2007-04-10 16:00:00	MSFT	Stock	28.39	28.41	28.37	28.39	246008.0
2007-04-10 17:00:00	MSFT	Stock	28.42	28.42	28.4	28.4	2201370.0
2007-04-10 18:00:00	MSFT	Stock	28.42	28.42	28.38	28.4	865.0
2007-04-10 19:00:00	MSFT	Stock	28.38	28.38	28.38	28.38	1000.0
2007-04-10 08:00:00	NVDA	Stock	0.506	0.5062	0.505	0.5062	162000.0
2007-04-10 09:00:00	NVDA	Stock	0.5082	0.5083	0.5013	0.5078	111305820.0
2007-04-10 10:00:00	NVDA	Stock	0.5078	0.5108	0.5052	0.5085	132118500.0
2007-04-10 11:00:00	NVDA	Stock	0.5085	0.5087	0.5035	0.5042	73566420.0
2007-04-10 12:00:00	NVDA	Stock	0.5042	0.5052	0.501	0.5017	61370040.0
2007-04-10 13:00:00	NVDA	Stock	0.5017	0.5017	0.4998	0.5003	96815280.0
2007-04-10 14:00:00	NVDA	Stock	0.5003	0.5012	0.4995	0.5008	98517420.0
2007-04-10 15:00:00	NVDA	Stock	0.5007	0.5015	0.5	0.5005	137121600.0
2007-04-10 16:00:00	NVDA	Stock	0.5005	0.5007	0.5005	0.5005	1913880.0
2007-04-10 17:00:00	NVDA	Stock	0.5007	0.5012	0.5005	0.5012	111300.0
2007-04-10 18:00:00	NVDA	Stock	0.5012	0.5012	0.5012	0.5012	48000.0
2007-04-10 08:00:00	AMZN	Stock	2.0825	2.0825	2.0705	2.0705	10000.0
2007-04-10 09:00:00	AMZN	Stock	2.079	2.096	2.073	2.092	7738360.0
2007-04-10 10:00:00	AMZN	Stock	2.0915	2.098	2.085	2.089	9599080.0
2007-04-10 11:00:00	AMZN	Stock	2.0895	2.09	2.0775	2.0785	8690080.0
2007-04-10 12:00:00	AMZN	Stock	2.078	2.0895	2.075	2.083	7060760.0
2007-04-10 13:00:00	AMZN	Stock	2.083	2.09	2.0815	2.0825	5478260.0
2007-04-10 14:00:00	AMZN	Stock	2.0825	2.087	2.0775	2.085	7864320.0
2007-04-10 15:00:00	AMZN	Stock	2.085	2.0975	2.0845	2.092	16575340.0
2007-04-10 16:00:00	AMZN	Stock	2.092	2.0955	2.087	2.095	1345020.0
2007-04-10 17:00:00	AMZN	Stock	2.093	2.093	2.093	2.093	20000.0
2007-04-10 19:00:00	AMZN	Stock	2.0925	2.0925	2.0925	2.0925	3000.0
2007-04-10 09:00:00	CL	Stock	33.325	33.455	33.265	33.41	237600.0
2007-04-10 10:00:00	CL	Stock	33.405	33.405	33.235	33.255	724018.0

> showing 50 of 31,835 rows — these rows as CSV

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