PREVIEW / stock_1hour / 2009-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-20.parquet
  size:    851 KB
  rows:    41,114
  symbols: 3,358

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
2009-07-20 05:00:00	AAPL	Stock	5.4536	5.4536	5.4536	5.4536	7700.0
2009-07-20 07:00:00	AAPL	Stock	5.4536	5.5029	5.4536	5.5018	898716.0
2009-07-20 08:00:00	AAPL	Stock	5.4893	5.5007	5.4643	5.4725	4045160.0
2009-07-20 09:00:00	AAPL	Stock	5.4725	5.5257	5.4546	5.5243	92054200.0
2009-07-20 10:00:00	AAPL	Stock	5.525	5.5314	5.4796	5.5017	109707920.0
2009-07-20 11:00:00	AAPL	Stock	5.5018	5.537	5.5018	5.5212	69963460.0
2009-07-20 12:00:00	AAPL	Stock	5.5211	5.5318	5.5043	5.5086	41362384.0
2009-07-20 13:00:00	AAPL	Stock	5.5085	5.5143	5.4664	5.4832	77350476.0
2009-07-20 14:00:00	AAPL	Stock	5.4832	5.4857	5.3889	5.4021	164425828.0
2009-07-20 15:00:00	AAPL	Stock	5.4012	5.4632	5.4012	5.4625	152227376.0
2009-07-20 16:00:00	AAPL	Stock	5.4625	5.4796	5.4479	5.4643	14953652.0
2009-07-20 17:00:00	AAPL	Stock	5.4679	5.4879	5.4661	5.4761	1198344.0
2009-07-20 18:00:00	AAPL	Stock	5.475	5.4782	5.4611	5.4775	1808716.0
2009-07-20 19:00:00	AAPL	Stock	5.4775	5.5021	5.4754	5.4932	1452864.0
2009-07-20 04:00:00	MSFT	Stock	24.34	24.34	24.34	24.34	100.0
2009-07-20 07:00:00	MSFT	Stock	24.47	24.49	24.41	24.41	2572.0
2009-07-20 08:00:00	MSFT	Stock	24.42	24.5	24.35	24.35	25726.0
2009-07-20 09:00:00	MSFT	Stock	24.36	24.48	24.32	24.39	5517811.0
2009-07-20 10:00:00	MSFT	Stock	24.38	24.42	24.16	24.19	7160713.0
2009-07-20 11:00:00	MSFT	Stock	24.18	24.3	24.15	24.26	3157363.0
2009-07-20 12:00:00	MSFT	Stock	24.269	24.35	24.26	24.282	3016497.0
2009-07-20 13:00:00	MSFT	Stock	24.29	24.31	24.23	24.28	2953680.0
2009-07-20 14:00:00	MSFT	Stock	24.275	24.37	24.19	24.335	8654126.0
2009-07-20 15:00:00	MSFT	Stock	24.34	24.53	24.33	24.53	11301751.0
2009-07-20 16:00:00	MSFT	Stock	24.52	24.56	24.357	24.53	5303461.0
2009-07-20 17:00:00	MSFT	Stock	24.5	24.56	24.5	24.55	19328.0
2009-07-20 18:00:00	MSFT	Stock	24.55	24.56	24.51	24.51	18487.0
2009-07-20 19:00:00	MSFT	Stock	24.56	24.57	24.54	24.54	36009.0
2009-07-20 07:00:00	NVDA	Stock	0.3048	0.305	0.3025	0.3025	127000.0
2009-07-20 08:00:00	NVDA	Stock	0.3025	0.305	0.3025	0.3048	682000.0
2009-07-20 09:00:00	NVDA	Stock	0.3048	0.3088	0.3025	0.3065	115689040.0
2009-07-20 10:00:00	NVDA	Stock	0.3065	0.307	0.3002	0.3038	167593560.0
2009-07-20 11:00:00	NVDA	Stock	0.3036	0.3062	0.3005	0.3012	112663880.0
2009-07-20 12:00:00	NVDA	Stock	0.3012	0.3032	0.301	0.3022	70822080.0
2009-07-20 13:00:00	NVDA	Stock	0.3022	0.3032	0.301	0.3025	64896640.0
2009-07-20 14:00:00	NVDA	Stock	0.3025	0.304	0.3018	0.3038	60131240.0
2009-07-20 15:00:00	NVDA	Stock	0.3037	0.3062	0.3035	0.3055	99550720.0
2009-07-20 16:00:00	NVDA	Stock	0.3055	0.307	0.3027	0.3055	57450800.0
2009-07-20 17:00:00	NVDA	Stock	0.3012	0.3018	0.3002	0.3002	38000.0
2009-07-20 19:00:00	NVDA	Stock	0.3012	0.3012	0.3012	0.3012	4000.0
2009-07-20 06:00:00	AMZN	Stock	4.305	4.305	4.305	4.305	14000.0
2009-07-20 07:00:00	AMZN	Stock	4.305	4.305	4.305	4.305	2000.0
2009-07-20 08:00:00	AMZN	Stock	4.305	4.325	4.305	4.313	45900.0
2009-07-20 09:00:00	AMZN	Stock	4.32	4.3975	4.31	4.38	17207060.0
2009-07-20 10:00:00	AMZN	Stock	4.3795	4.396	4.3615	4.3814	17359700.0
2009-07-20 11:00:00	AMZN	Stock	4.382	4.4135	4.3785	4.4118	11784080.0
2009-07-20 12:00:00	AMZN	Stock	4.4115	4.444	4.4105	4.4325	13556840.0
2009-07-20 13:00:00	AMZN	Stock	4.4325	4.4325	4.4	4.4252	11162100.0
2009-07-20 14:00:00	AMZN	Stock	4.426	4.4345	4.3935	4.3935	14537120.0
2009-07-20 15:00:00	AMZN	Stock	4.394	4.4225	4.388	4.414	28181500.0

> showing 50 of 41,114 rows — these rows as CSV

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