PREVIEW / stock_1hour / 2010-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-15.parquet
  size:    903 KB
  rows:    42,818
  symbols: 3,461

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-10-15 05:00:00	AAPL	Stock	10.8882	10.8929	10.8786	10.8875	36988.0
2010-10-15 06:00:00	AAPL	Stock	10.8721	10.8929	10.8643	10.8643	41412.0
2010-10-15 07:00:00	AAPL	Stock	10.8643	10.8929	10.8214	10.8439	824320.0
2010-10-15 08:00:00	AAPL	Stock	10.8429	10.9546	10.8321	10.925	10547964.0
2010-10-15 09:00:00	AAPL	Stock	10.925	10.9804	10.8896	10.9614	171040548.0
2010-10-15 10:00:00	AAPL	Stock	10.9636	10.9932	10.9018	10.9886	134685852.0
2010-10-15 11:00:00	AAPL	Stock	10.9886	11.0882	10.975	11.0521	157160948.0
2010-10-15 12:00:00	AAPL	Stock	11.0521	11.075	11.0393	11.0507	70917644.0
2010-10-15 13:00:00	AAPL	Stock	11.0507	11.0807	11.05	11.0785	53891236.0
2010-10-15 14:00:00	AAPL	Stock	11.0771	11.1025	11.0625	11.0996	77478828.0
2010-10-15 15:00:00	AAPL	Stock	11.0993	11.25	11.0768	11.2489	200274256.0
2010-10-15 16:00:00	AAPL	Stock	11.25	11.2854	10.9867	11.2821	30766652.0
2010-10-15 17:00:00	AAPL	Stock	11.2836	11.2886	11.1183	11.2661	3749592.0
2010-10-15 18:00:00	AAPL	Stock	11.265	11.3018	11.2407	11.3004	3256680.0
2010-10-15 19:00:00	AAPL	Stock	11.3018	11.3132	11.2879	11.3	867776.0
2010-10-15 07:00:00	MSFT	Stock	25.27	25.27	25.25	25.27	2300.0
2010-10-15 08:00:00	MSFT	Stock	25.27	25.45	25.17	25.35	71390.0
2010-10-15 09:00:00	MSFT	Stock	25.31	25.49	25.25	25.43	13612161.0
2010-10-15 10:00:00	MSFT	Stock	25.435	25.47	25.27	25.32	11055161.0
2010-10-15 11:00:00	MSFT	Stock	25.325	25.44	25.25	25.28	9626355.0
2010-10-15 12:00:00	MSFT	Stock	25.28	25.32	25.23	25.3	4391703.0
2010-10-15 13:00:00	MSFT	Stock	25.295	25.37	25.27	25.335	5461012.0
2010-10-15 14:00:00	MSFT	Stock	25.33	25.49	25.3	25.46	5202245.0
2010-10-15 15:00:00	MSFT	Stock	25.47	25.55	25.41	25.54	13481125.0
2010-10-15 16:00:00	MSFT	Stock	25.55	25.59	25.23	25.54	4527336.0
2010-10-15 17:00:00	MSFT	Stock	25.44	25.56	25.44	25.55	28505.0
2010-10-15 18:00:00	MSFT	Stock	25.55	25.58	25.54	25.58	32040.0
2010-10-15 19:00:00	MSFT	Stock	25.56	25.58	25.55	25.57	2700.0
2010-10-15 08:00:00	NVDA	Stock	0.2812	0.2825	0.2808	0.2812	691440.0
2010-10-15 09:00:00	NVDA	Stock	0.2818	0.2868	0.281	0.2832	136804600.0
2010-10-15 10:00:00	NVDA	Stock	0.2833	0.285	0.279	0.2808	105866000.0
2010-10-15 11:00:00	NVDA	Stock	0.2805	0.2828	0.2795	0.2814	100710560.0
2010-10-15 12:00:00	NVDA	Stock	0.2812	0.284	0.2799	0.283	87976000.0
2010-10-15 13:00:00	NVDA	Stock	0.283	0.2842	0.2818	0.2825	41929240.0
2010-10-15 14:00:00	NVDA	Stock	0.2825	0.283	0.2818	0.2825	43276640.0
2010-10-15 15:00:00	NVDA	Stock	0.2828	0.2835	0.281	0.2822	105816080.0
2010-10-15 16:00:00	NVDA	Stock	0.2822	0.2828	0.282	0.2828	12392760.0
2010-10-15 17:00:00	NVDA	Stock	0.2821	0.285	0.2821	0.2832	2100000.0
2010-10-15 18:00:00	NVDA	Stock	0.283	0.283	0.2828	0.2828	52000.0
2010-10-15 19:00:00	NVDA	Stock	0.2828	0.2828	0.2828	0.2828	12000.0
2010-10-15 08:00:00	AMZN	Stock	7.8825	7.933	7.88	7.9075	564960.0
2010-10-15 09:00:00	AMZN	Stock	7.907	7.9725	7.8375	7.878	29427960.0
2010-10-15 10:00:00	AMZN	Stock	7.883	7.91	7.8555	7.897	15583400.0
2010-10-15 11:00:00	AMZN	Stock	7.9005	8.0795	7.895	8.0294	36320060.0
2010-10-15 12:00:00	AMZN	Stock	8.027	8.107	8.0085	8.0825	23282520.0
2010-10-15 13:00:00	AMZN	Stock	8.0805	8.105	8.058	8.076	13910380.0
2010-10-15 14:00:00	AMZN	Stock	8.075	8.15	8.0545	8.1425	23714480.0
2010-10-15 15:00:00	AMZN	Stock	8.142	8.244	8.1075	8.2355	54282460.0
2010-10-15 16:00:00	AMZN	Stock	8.232	8.25	7.7765	8.25	4741560.0
2010-10-15 17:00:00	AMZN	Stock	8.1344	8.2615	8.1344	8.2575	216840.0

> showing 50 of 42,818 rows — these rows as CSV

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