PREVIEW / stock_1hour / 2009-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-09.parquet
  size:    840 KB
  rows:    41,242
  symbols: 3,364

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-04-09 07:00:00	AAPL	Stock	4.1643	4.1643	4.1643	4.1643	2800.0
2009-04-09 08:00:00	AAPL	Stock	4.1779	4.245	4.1779	4.2429	3167080.0
2009-04-09 09:00:00	AAPL	Stock	4.2443	4.2671	4.2129	4.2586	87047268.0
2009-04-09 10:00:00	AAPL	Stock	4.2589	4.2814	4.2482	4.2661	87166324.0
2009-04-09 11:00:00	AAPL	Stock	4.2664	4.2739	4.25	4.265	56363384.0
2009-04-09 12:00:00	AAPL	Stock	4.2643	4.2721	4.2518	4.2632	42456820.0
2009-04-09 13:00:00	AAPL	Stock	4.2632	4.2782	4.2625	4.2771	42054600.0
2009-04-09 14:00:00	AAPL	Stock	4.2771	4.2857	4.2668	4.2793	63250852.0
2009-04-09 15:00:00	AAPL	Stock	4.2793	4.2857	4.2607	4.2729	118506836.0
2009-04-09 16:00:00	AAPL	Stock	4.2714	4.28	4.2659	4.2667	15949500.0
2009-04-09 17:00:00	AAPL	Stock	4.2732	4.2779	4.2693	4.2779	405160.0
2009-04-09 18:00:00	AAPL	Stock	4.2704	4.2775	4.2704	4.2754	720692.0
2009-04-09 19:00:00	AAPL	Stock	4.2754	4.2754	4.2714	4.2754	71204.0
2009-04-09 07:00:00	MSFT	Stock	19.36	19.36	19.36	19.36	250.0
2009-04-09 08:00:00	MSFT	Stock	19.3	19.62	19.3	19.57	58631.0
2009-04-09 09:00:00	MSFT	Stock	19.57	19.69	19.25	19.67	6492736.0
2009-04-09 10:00:00	MSFT	Stock	19.66	19.7	19.38	19.39	9820390.0
2009-04-09 11:00:00	MSFT	Stock	19.4	19.478	19.22	19.39	5874911.0
2009-04-09 12:00:00	MSFT	Stock	19.39	19.45	19.35	19.402	3189224.0
2009-04-09 13:00:00	MSFT	Stock	19.402	19.57	19.4	19.55	4246128.0
2009-04-09 14:00:00	MSFT	Stock	19.55	19.59	19.44	19.535	4472799.0
2009-04-09 15:00:00	MSFT	Stock	19.54	19.68	19.51	19.67	15534589.0
2009-04-09 16:00:00	MSFT	Stock	19.67	19.68	19.354	19.65	3045433.0
2009-04-09 17:00:00	MSFT	Stock	19.62	19.65	19.6	19.6	4330.0
2009-04-09 18:00:00	MSFT	Stock	19.65	19.68	19.59	19.66	131026.0
2009-04-09 19:00:00	MSFT	Stock	19.66	19.68	19.57	19.64	3324.0
2009-04-09 08:00:00	NVDA	Stock	0.2828	0.3	0.2828	0.2928	302800.0
2009-04-09 09:00:00	NVDA	Stock	0.2922	0.2975	0.2875	0.2975	119051880.0
2009-04-09 10:00:00	NVDA	Stock	0.2975	0.3008	0.2932	0.294	194744680.0
2009-04-09 11:00:00	NVDA	Stock	0.294	0.2962	0.2928	0.296	99494360.0
2009-04-09 12:00:00	NVDA	Stock	0.2962	0.3012	0.2958	0.3002	90884040.0
2009-04-09 13:00:00	NVDA	Stock	0.3002	0.3014	0.297	0.2991	69819280.0
2009-04-09 14:00:00	NVDA	Stock	0.2992	0.302	0.299	0.3005	89705200.0
2009-04-09 15:00:00	NVDA	Stock	0.3002	0.301	0.2985	0.3008	220156440.0
2009-04-09 16:00:00	NVDA	Stock	0.301	0.301	0.2974	0.3008	15818600.0
2009-04-09 17:00:00	NVDA	Stock	0.2998	0.3	0.2985	0.2995	128000.0
2009-04-09 19:00:00	NVDA	Stock	0.2985	0.2985	0.2985	0.2985	4000.0
2009-04-09 08:00:00	AMZN	Stock	3.857	3.9	3.835	3.895	285140.0
2009-04-09 09:00:00	AMZN	Stock	3.895	3.9345	3.863	3.9276	19595160.0
2009-04-09 10:00:00	AMZN	Stock	3.9285	3.9625	3.9195	3.9335	25021340.0
2009-04-09 11:00:00	AMZN	Stock	3.9335	3.954	3.927	3.937	12832640.0
2009-04-09 12:00:00	AMZN	Stock	3.9365	3.94	3.9245	3.9275	8314400.0
2009-04-09 13:00:00	AMZN	Stock	3.9279	3.95	3.9195	3.9455	13802520.0
2009-04-09 14:00:00	AMZN	Stock	3.9465	3.97	3.9325	3.9645	17063600.0
2009-04-09 15:00:00	AMZN	Stock	3.965	4.0	3.9585	3.9925	37050280.0
2009-04-09 16:00:00	AMZN	Stock	3.9925	4.0	3.9457	3.9624	4646440.0
2009-04-09 17:00:00	AMZN	Stock	3.9885	3.9885	3.9775	3.9885	30760.0
2009-04-09 18:00:00	AMZN	Stock	3.9885	3.9885	3.985	3.985	6000.0
2009-04-09 19:00:00	AMZN	Stock	3.985	3.985	3.9825	3.9825	11000.0
2009-04-09 08:00:00	TLT	Stock	103.03	103.1	102.52	102.52	4700.0

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

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