PREVIEW / stock_1hour / 2010-03-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-25.parquet
  size:    917 KB
  rows:    43,744
  symbols: 3,493

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
2010-03-25 05:00:00	AAPL	Stock	8.2054	8.2054	8.2054	8.2054	3052.0
2010-03-25 06:00:00	AAPL	Stock	8.2014	8.2014	8.2014	8.2014	8400.0
2010-03-25 07:00:00	AAPL	Stock	8.2282	8.2346	8.225	8.2279	306404.0
2010-03-25 08:00:00	AAPL	Stock	8.2261	8.2507	8.2229	8.2364	2519692.0
2010-03-25 09:00:00	AAPL	Stock	8.2364	8.2518	8.2057	8.21	81534432.0
2010-03-25 10:00:00	AAPL	Stock	8.2093	8.2304	8.195	8.2107	83629308.0
2010-03-25 11:00:00	AAPL	Stock	8.2089	8.2468	8.2071	8.2458	64439788.0
2010-03-25 12:00:00	AAPL	Stock	8.2461	8.2464	8.2182	8.2214	35435064.0
2010-03-25 13:00:00	AAPL	Stock	8.2221	8.2318	8.1793	8.1954	56788760.0
2010-03-25 14:00:00	AAPL	Stock	8.1954	8.1964	8.1257	8.1604	83834968.0
2010-03-25 15:00:00	AAPL	Stock	8.1596	8.1879	8.0804	8.0975	111090700.0
2010-03-25 16:00:00	AAPL	Stock	8.1018	8.245	8.0904	8.102	12962852.0
2010-03-25 17:00:00	AAPL	Stock	8.1918	8.1918	8.0893	8.0921	901348.0
2010-03-25 18:00:00	AAPL	Stock	8.0982	8.105	8.0911	8.105	308336.0
2010-03-25 19:00:00	AAPL	Stock	8.1061	8.1132	8.1	8.1071	840588.0
2010-03-25 07:00:00	MSFT	Stock	29.7	29.75	29.7	29.75	1809.0
2010-03-25 08:00:00	MSFT	Stock	29.75	29.75	29.7	29.7	64321.0
2010-03-25 09:00:00	MSFT	Stock	29.74	30.17	29.74	30.14	9591462.0
2010-03-25 10:00:00	MSFT	Stock	30.134	30.26	30.08	30.25	13050281.0
2010-03-25 11:00:00	MSFT	Stock	30.25	30.57	30.23	30.479	12474644.0
2010-03-25 12:00:00	MSFT	Stock	30.48	30.53	30.4	30.47	6158387.0
2010-03-25 13:00:00	MSFT	Stock	30.47	30.5	30.23	30.3	7549780.0
2010-03-25 14:00:00	MSFT	Stock	30.3	30.33	30.16	30.235	6483016.0
2010-03-25 15:00:00	MSFT	Stock	30.24	30.34	30.01	30.01	13017234.0
2010-03-25 16:00:00	MSFT	Stock	30.01	30.47	29.97	30.006	2397600.0
2010-03-25 17:00:00	MSFT	Stock	29.65	30.01	29.65	29.94	27426.0
2010-03-25 18:00:00	MSFT	Stock	29.96	30.02	29.96	29.98	4972.0
2010-03-25 19:00:00	MSFT	Stock	29.98	30.02	29.95	29.95	3000.0
2010-03-25 08:00:00	NVDA	Stock	0.4362	0.4395	0.4362	0.439	534480.0
2010-03-25 09:00:00	NVDA	Stock	0.4395	0.4395	0.4341	0.4342	46337000.0
2010-03-25 10:00:00	NVDA	Stock	0.4345	0.4368	0.4325	0.4361	82590800.0
2010-03-25 11:00:00	NVDA	Stock	0.436	0.4412	0.4358	0.441	71514120.0
2010-03-25 12:00:00	NVDA	Stock	0.441	0.441	0.438	0.4395	45167320.0
2010-03-25 13:00:00	NVDA	Stock	0.4395	0.4408	0.4365	0.4372	47798920.0
2010-03-25 14:00:00	NVDA	Stock	0.4371	0.438	0.435	0.4365	70340880.0
2010-03-25 15:00:00	NVDA	Stock	0.4365	0.4385	0.4335	0.4335	117815880.0
2010-03-25 16:00:00	NVDA	Stock	0.4335	0.4371	0.4325	0.4338	5944120.0
2010-03-25 17:00:00	NVDA	Stock	0.4348	0.4375	0.4335	0.4355	420000.0
2010-03-25 19:00:00	NVDA	Stock	0.433	0.433	0.4325	0.4325	26000.0
2010-03-25 08:00:00	AMZN	Stock	6.4	6.475	6.4	6.475	339920.0
2010-03-25 09:00:00	AMZN	Stock	6.475	6.6274	6.457	6.6004	40522940.0
2010-03-25 10:00:00	AMZN	Stock	6.6015	6.7685	6.6	6.73	74626740.0
2010-03-25 11:00:00	AMZN	Stock	6.73	6.845	6.719	6.8125	47994480.0
2010-03-25 12:00:00	AMZN	Stock	6.8125	6.831	6.765	6.774	28736260.0
2010-03-25 13:00:00	AMZN	Stock	6.775	6.828	6.745	6.758	29469620.0
2010-03-25 14:00:00	AMZN	Stock	6.7575	6.7785	6.715	6.7505	32964720.0
2010-03-25 15:00:00	AMZN	Stock	6.75	6.8455	6.736	6.7365	63995960.0
2010-03-25 16:00:00	AMZN	Stock	6.736	6.7537	6.7315	6.735	4706240.0
2010-03-25 17:00:00	AMZN	Stock	6.735	6.7485	6.73	6.7485	45880.0
2010-03-25 18:00:00	AMZN	Stock	6.7365	6.7365	6.7365	6.7365	326220.0

> showing 50 of 43,744 rows — these rows as CSV

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