PREVIEW / stock_1hour / 2010-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-28.parquet
  size:    915 KB
  rows:    43,959
  symbols: 3,525

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-12-28 04:00:00	AAPL	Stock	11.6686	11.6686	11.6686	11.6686	2800.0
2010-12-28 06:00:00	AAPL	Stock	11.6964	11.6982	11.67	11.67	28000.0
2010-12-28 07:00:00	AAPL	Stock	11.6579	11.6782	11.6511	11.6511	151200.0
2010-12-28 08:00:00	AAPL	Stock	11.65	11.6539	11.6189	11.6436	1693272.0
2010-12-28 09:00:00	AAPL	Stock	11.6432	11.6664	11.6118	11.6371	39755744.0
2010-12-28 10:00:00	AAPL	Stock	11.6371	11.6482	11.6093	11.6354	34859608.0
2010-12-28 11:00:00	AAPL	Stock	11.6346	11.65	11.6218	11.6229	23955008.0
2010-12-28 12:00:00	AAPL	Stock	11.6236	11.6311	11.6107	11.6225	13449492.0
2010-12-28 13:00:00	AAPL	Stock	11.6225	11.6264	11.6114	11.6239	11213692.0
2010-12-28 14:00:00	AAPL	Stock	11.6239	11.6296	11.6179	11.6279	13513164.0
2010-12-28 15:00:00	AAPL	Stock	11.6279	11.635	11.6125	11.6239	27403908.0
2010-12-28 16:00:00	AAPL	Stock	11.6239	11.6339	11.6204	11.6218	8545516.0
2010-12-28 17:00:00	AAPL	Stock	11.6239	11.6304	11.6221	11.6304	75376.0
2010-12-28 18:00:00	AAPL	Stock	11.6282	11.6314	11.6239	11.6307	177996.0
2010-12-28 19:00:00	AAPL	Stock	11.6271	11.6321	11.6264	11.6321	151760.0
2010-12-28 04:00:00	MSFT	Stock	28.14	28.14	28.14	28.14	100.0
2010-12-28 06:00:00	MSFT	Stock	28.14	28.23	28.14	28.23	1300.0
2010-12-28 07:00:00	MSFT	Stock	28.13	28.13	28.13	28.13	550.0
2010-12-28 08:00:00	MSFT	Stock	28.14	28.15	28.08	28.15	6215.0
2010-12-28 09:00:00	MSFT	Stock	28.13	28.18	27.96	28.07	3102687.0
2010-12-28 10:00:00	MSFT	Stock	28.05	28.16	28.02	28.11	3423929.0
2010-12-28 11:00:00	MSFT	Stock	28.11	28.15	28.01	28.06	2472483.0
2010-12-28 12:00:00	MSFT	Stock	28.06	28.08	28.03	28.056	1834180.0
2010-12-28 13:00:00	MSFT	Stock	28.051	28.06	28.0	28.05	2503930.0
2010-12-28 14:00:00	MSFT	Stock	28.05	28.08	27.99	28.071	2662290.0
2010-12-28 15:00:00	MSFT	Stock	28.079	28.11	28.01	28.02	4276871.0
2010-12-28 16:00:00	MSFT	Stock	28.02	28.07	28.01	28.07	1915485.0
2010-12-28 17:00:00	MSFT	Stock	28.05	28.05	28.05	28.05	500.0
2010-12-28 18:00:00	MSFT	Stock	28.01	28.06	28.01	28.06	4741.0
2010-12-28 19:00:00	MSFT	Stock	28.14	28.14	28.0	28.0	5400.0
2010-12-28 08:00:00	NVDA	Stock	0.3725	0.3768	0.3725	0.374	118000.0
2010-12-28 09:00:00	NVDA	Stock	0.3768	0.3775	0.3733	0.377	28176600.0
2010-12-28 10:00:00	NVDA	Stock	0.3773	0.3775	0.3749	0.3753	45257880.0
2010-12-28 11:00:00	NVDA	Stock	0.3751	0.3755	0.373	0.3733	22587800.0
2010-12-28 12:00:00	NVDA	Stock	0.373	0.3731	0.3713	0.3729	21089320.0
2010-12-28 13:00:00	NVDA	Stock	0.373	0.3749	0.3728	0.3748	21122880.0
2010-12-28 14:00:00	NVDA	Stock	0.3748	0.3748	0.373	0.374	14452320.0
2010-12-28 15:00:00	NVDA	Stock	0.374	0.3743	0.3733	0.3733	33544520.0
2010-12-28 16:00:00	NVDA	Stock	0.3735	0.3746	0.3735	0.3738	7447200.0
2010-12-28 07:00:00	AMZN	Stock	9.1265	9.1265	9.1265	9.1265	2000.0
2010-12-28 08:00:00	AMZN	Stock	9.1275	9.148	9.104	9.104	59740.0
2010-12-28 09:00:00	AMZN	Stock	9.106	9.1385	9.081	9.104	5355040.0
2010-12-28 10:00:00	AMZN	Stock	9.1055	9.124	9.054	9.068	7594200.0
2010-12-28 11:00:00	AMZN	Stock	9.067	9.094	9.063	9.079	3353840.0
2010-12-28 12:00:00	AMZN	Stock	9.0775	9.0895	9.0525	9.0855	3265360.0
2010-12-28 13:00:00	AMZN	Stock	9.0855	9.0875	9.057	9.0635	2847460.0
2010-12-28 14:00:00	AMZN	Stock	9.0635	9.079	9.055	9.076	3694320.0
2010-12-28 15:00:00	AMZN	Stock	9.0745	9.09	9.0555	9.0555	7941780.0
2010-12-28 16:00:00	AMZN	Stock	9.0555	9.0784	9.045	9.045	4397120.0
2010-12-28 17:00:00	AMZN	Stock	9.04	9.052	9.04	9.0465	24000.0

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

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