PREVIEW / stock_1hour / 2007-04-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-13.parquet
  size:    682 KB
  rows:    32,070
  symbols: 2,577

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-13 06:00:00	AAPL	Stock	3.2318	3.2421	3.2318	3.2421	30800.0
2007-04-13 07:00:00	AAPL	Stock	3.2296	3.2411	3.2293	3.2375	1040200.0
2007-04-13 08:00:00	AAPL	Stock	3.2393	3.2532	3.225	3.2446	14642684.0
2007-04-13 09:00:00	AAPL	Stock	3.2454	3.2643	3.2321	3.2482	145939976.0
2007-04-13 10:00:00	AAPL	Stock	3.2482	3.2571	3.2339	3.2464	140942116.0
2007-04-13 11:00:00	AAPL	Stock	3.247	3.25	3.235	3.2404	77051296.0
2007-04-13 12:00:00	AAPL	Stock	3.2404	3.2421	3.2307	3.2361	49816648.0
2007-04-13 13:00:00	AAPL	Stock	3.2361	3.2382	3.2196	3.2232	82627300.0
2007-04-13 14:00:00	AAPL	Stock	3.2229	3.2407	3.2164	3.2336	87114440.0
2007-04-13 15:00:00	AAPL	Stock	3.2339	3.2389	3.2179	3.2232	106706040.0
2007-04-13 16:00:00	AAPL	Stock	3.2232	3.225	3.2179	3.2229	4134424.0
2007-04-13 17:00:00	AAPL	Stock	3.2229	3.2243	3.2218	3.2232	471688.0
2007-04-13 18:00:00	AAPL	Stock	3.2232	3.2246	3.2229	3.2229	206108.0
2007-04-13 19:00:00	AAPL	Stock	3.2232	3.2243	3.2225	3.2229	138320.0
2007-04-13 05:00:00	MSFT	Stock	28.49	28.49	28.49	28.49	200.0
2007-04-13 07:00:00	MSFT	Stock	28.57	28.57	28.47	28.47	600.0
2007-04-13 08:00:00	MSFT	Stock	28.5	28.54	28.48	28.48	7060.0
2007-04-13 09:00:00	MSFT	Stock	28.53	28.54	28.28	28.31	3045793.0
2007-04-13 10:00:00	MSFT	Stock	28.31	28.43	28.1	28.392	7881385.0
2007-04-13 11:00:00	MSFT	Stock	28.39	28.45	28.339	28.41	3506990.0
2007-04-13 12:00:00	MSFT	Stock	28.402	28.486	28.35	28.45	4236479.0
2007-04-13 13:00:00	MSFT	Stock	28.45	28.52	28.38	28.44	3951914.0
2007-04-13 14:00:00	MSFT	Stock	28.44	28.7	28.38	28.52	3950967.0
2007-04-13 15:00:00	MSFT	Stock	28.52	28.66	28.51	28.62	7658198.0
2007-04-13 16:00:00	MSFT	Stock	28.62	28.65	28.39	28.61	164297.0
2007-04-13 17:00:00	MSFT	Stock	28.61	28.62	28.61	28.62	5750.0
2007-04-13 18:00:00	MSFT	Stock	28.63	28.64	28.63	28.64	2480.0
2007-04-13 19:00:00	MSFT	Stock	28.59	28.59	28.59	28.59	1900.0
2007-04-13 08:00:00	NVDA	Stock	0.504	0.505	0.504	0.505	382800.0
2007-04-13 09:00:00	NVDA	Stock	0.504	0.507	0.5008	0.5025	70873980.0
2007-04-13 10:00:00	NVDA	Stock	0.5022	0.5038	0.498	0.5033	87164820.0
2007-04-13 11:00:00	NVDA	Stock	0.5033	0.5035	0.4985	0.4992	62103900.0
2007-04-13 12:00:00	NVDA	Stock	0.4992	0.5005	0.4977	0.499	71469840.0
2007-04-13 13:00:00	NVDA	Stock	0.499	0.5012	0.499	0.5012	41464440.0
2007-04-13 14:00:00	NVDA	Stock	0.501	0.5055	0.4992	0.5043	73644540.0
2007-04-13 15:00:00	NVDA	Stock	0.5043	0.5107	0.5033	0.5097	204502800.0
2007-04-13 16:00:00	NVDA	Stock	0.51	0.5102	0.5083	0.5097	9684480.0
2007-04-13 17:00:00	NVDA	Stock	0.5098	0.5098	0.509	0.509	48000.0
2007-04-13 18:00:00	NVDA	Stock	0.5092	0.5092	0.5092	0.5092	60000.0
2007-04-13 19:00:00	NVDA	Stock	0.5097	0.5097	0.5097	0.5097	24000.0
2007-04-13 08:00:00	AMZN	Stock	2.1005	2.116	2.1005	2.116	25400.0
2007-04-13 09:00:00	AMZN	Stock	2.115	2.125	2.109	2.119	9293960.0
2007-04-13 10:00:00	AMZN	Stock	2.1185	2.12	2.108	2.1094	12363180.0
2007-04-13 11:00:00	AMZN	Stock	2.109	2.1105	2.1	2.103	13615940.0
2007-04-13 12:00:00	AMZN	Stock	2.1025	2.1095	2.0965	2.1065	7657260.0
2007-04-13 13:00:00	AMZN	Stock	2.107	2.118	2.106	2.118	6093860.0
2007-04-13 14:00:00	AMZN	Stock	2.1175	2.121	2.11	2.1195	7315160.0
2007-04-13 15:00:00	AMZN	Stock	2.1195	2.124	2.1175	2.1205	12831140.0
2007-04-13 16:00:00	AMZN	Stock	2.12	2.1205	2.12	2.1205	1696360.0
2007-04-13 17:00:00	AMZN	Stock	2.121	2.121	2.121	2.121	10000.0

> showing 50 of 32,070 rows — these rows as CSV

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