PREVIEW / stock_1hour / 2009-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-20.parquet
  size:    860 KB
  rows:    41,554
  symbols: 3,354

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-05-20 04:00:00	AAPL	Stock	4.5911	4.5911	4.5911	4.5911	2800.0
2009-05-20 07:00:00	AAPL	Stock	4.5632	4.5946	4.5632	4.5911	34440.0
2009-05-20 08:00:00	AAPL	Stock	4.5871	4.5875	4.5636	4.5711	705824.0
2009-05-20 09:00:00	AAPL	Stock	4.5714	4.5793	4.5182	4.5446	63395864.0
2009-05-20 10:00:00	AAPL	Stock	4.5475	4.6146	4.5446	4.5918	64929032.0
2009-05-20 11:00:00	AAPL	Stock	4.5911	4.6007	4.55	4.5541	40173784.0
2009-05-20 12:00:00	AAPL	Stock	4.5539	4.5668	4.5039	4.51	38198496.0
2009-05-20 13:00:00	AAPL	Stock	4.51	4.5454	4.4907	4.5425	44422364.0
2009-05-20 14:00:00	AAPL	Stock	4.5433	4.5618	4.5214	4.5464	49440440.0
2009-05-20 15:00:00	AAPL	Stock	4.5461	4.5462	4.475	4.4961	78137948.0
2009-05-20 16:00:00	AAPL	Stock	4.495	4.5499	4.4851	4.495	5763240.0
2009-05-20 17:00:00	AAPL	Stock	4.4954	4.5443	4.4857	4.4879	322280.0
2009-05-20 18:00:00	AAPL	Stock	4.4954	4.4964	4.4911	4.4964	799428.0
2009-05-20 19:00:00	AAPL	Stock	4.4957	4.4957	4.4929	4.4929	23856.0
2009-05-20 05:00:00	MSFT	Stock	20.48	20.48	20.48	20.48	1800.0
2009-05-20 07:00:00	MSFT	Stock	20.48	20.48	20.48	20.48	1000.0
2009-05-20 08:00:00	MSFT	Stock	20.36	20.42	20.36	20.41	2362.0
2009-05-20 09:00:00	MSFT	Stock	20.42	20.47	20.22	20.424	5490432.0
2009-05-20 10:00:00	MSFT	Stock	20.42	20.63	20.42	20.58	7392561.0
2009-05-20 11:00:00	MSFT	Stock	20.58	20.69	20.47	20.48	8939443.0
2009-05-20 12:00:00	MSFT	Stock	20.47	20.69	20.43	20.44	3698959.0
2009-05-20 13:00:00	MSFT	Stock	20.44	20.67	20.4	20.62	4563337.0
2009-05-20 14:00:00	MSFT	Stock	20.62	20.67	20.53	20.606	4939611.0
2009-05-20 15:00:00	MSFT	Stock	20.608	20.62	20.34	20.39	9949111.0
2009-05-20 16:00:00	MSFT	Stock	20.39	20.767	20.34	20.4	1704187.0
2009-05-20 17:00:00	MSFT	Stock	20.42	20.44	20.4	20.42	1546.0
2009-05-20 18:00:00	MSFT	Stock	20.39	20.5	20.39	20.42	11770.0
2009-05-20 19:00:00	MSFT	Stock	20.4	20.4	20.4	20.4	800.0
2009-05-20 08:00:00	NVDA	Stock	0.237	0.239	0.2345	0.2385	1102800.0
2009-05-20 09:00:00	NVDA	Stock	0.2398	0.25	0.2395	0.2477	188104000.0
2009-05-20 10:00:00	NVDA	Stock	0.2475	0.2563	0.2475	0.2527	384016520.0
2009-05-20 11:00:00	NVDA	Stock	0.2527	0.2538	0.2465	0.2473	182854120.0
2009-05-20 12:00:00	NVDA	Stock	0.2473	0.248	0.2432	0.2438	164336040.0
2009-05-20 13:00:00	NVDA	Stock	0.2435	0.2475	0.2425	0.2468	83944240.0
2009-05-20 14:00:00	NVDA	Stock	0.2468	0.2485	0.244	0.2475	82272120.0
2009-05-20 15:00:00	NVDA	Stock	0.2475	0.2478	0.242	0.2432	181492640.0
2009-05-20 16:00:00	NVDA	Stock	0.2432	0.248	0.2422	0.2461	14904000.0
2009-05-20 17:00:00	NVDA	Stock	0.244	0.248	0.2432	0.2432	1812000.0
2009-05-20 18:00:00	NVDA	Stock	0.2438	0.244	0.2438	0.2438	51200.0
2009-05-20 19:00:00	NVDA	Stock	0.2438	0.2438	0.2435	0.2435	51400.0
2009-05-20 08:00:00	AMZN	Stock	3.9125	3.95	3.91	3.9295	29000.0
2009-05-20 09:00:00	AMZN	Stock	3.93	3.9904	3.905	3.977	25397980.0
2009-05-20 10:00:00	AMZN	Stock	3.977	4.0555	3.977	4.024	33288760.0
2009-05-20 11:00:00	AMZN	Stock	4.023	4.0335	3.9795	3.9831	14938780.0
2009-05-20 12:00:00	AMZN	Stock	3.983	3.9925	3.9115	3.9185	14630260.0
2009-05-20 13:00:00	AMZN	Stock	3.918	3.953	3.8875	3.9465	16057580.0
2009-05-20 14:00:00	AMZN	Stock	3.9475	3.9735	3.9225	3.9595	14940620.0
2009-05-20 15:00:00	AMZN	Stock	3.9585	3.9595	3.871	3.899	24661340.0
2009-05-20 16:00:00	AMZN	Stock	3.8975	3.9644	3.8895	3.9	2389440.0
2009-05-20 17:00:00	AMZN	Stock	3.9	3.9015	3.9	3.9	34000.0

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

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