PREVIEW / stock_1hour / 2009-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-02.parquet
  size:    850 KB
  rows:    41,519
  symbols: 3,334

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-02 04:00:00	AAPL	Stock	3.9321	3.9321	3.9321	3.9321	2800.0
2009-04-02 05:00:00	AAPL	Stock	3.9321	3.9796	3.9321	3.9796	36148.0
2009-04-02 06:00:00	AAPL	Stock	3.9582	3.9821	3.9582	3.9646	23800.0
2009-04-02 07:00:00	AAPL	Stock	3.9646	3.9646	3.9371	3.9371	87920.0
2009-04-02 08:00:00	AAPL	Stock	3.9411	3.9518	3.8818	3.9375	3956120.0
2009-04-02 09:00:00	AAPL	Stock	3.9364	3.9732	3.9207	3.9732	90357176.0
2009-04-02 10:00:00	AAPL	Stock	3.9732	4.0171	3.9694	4.0154	137636716.0
2009-04-02 11:00:00	AAPL	Stock	4.0157	4.0536	4.0136	4.0489	104960296.0
2009-04-02 12:00:00	AAPL	Stock	4.0496	4.0982	4.0421	4.0668	110976348.0
2009-04-02 13:00:00	AAPL	Stock	4.0668	4.0675	4.0296	4.0469	104512828.0
2009-04-02 14:00:00	AAPL	Stock	4.0467	4.0761	4.0411	4.0557	71893192.0
2009-04-02 15:00:00	AAPL	Stock	4.0561	4.0671	3.995	4.025	143765048.0
2009-04-02 16:00:00	AAPL	Stock	4.025	4.1411	4.0052	4.1182	30054416.0
2009-04-02 17:00:00	AAPL	Stock	4.1193	4.1232	4.1071	4.1125	1229648.0
2009-04-02 18:00:00	AAPL	Stock	4.1125	4.1161	4.1075	4.1079	1606920.0
2009-04-02 19:00:00	AAPL	Stock	4.1079	4.1118	4.1071	4.1089	301728.0
2009-04-02 05:00:00	MSFT	Stock	19.4	19.4	19.4	19.4	2000.0
2009-04-02 06:00:00	MSFT	Stock	19.58	19.66	19.58	19.66	3500.0
2009-04-02 07:00:00	MSFT	Stock	19.66	19.68	19.64	19.64	4558.0
2009-04-02 08:00:00	MSFT	Stock	19.6	19.6	19.31	19.5	723139.0
2009-04-02 09:00:00	MSFT	Stock	19.51	19.77	19.38	19.67	12105006.0
2009-04-02 10:00:00	MSFT	Stock	19.66	19.88	19.658	19.73	16840082.0
2009-04-02 11:00:00	MSFT	Stock	19.72	19.81	19.57	19.66	11418961.0
2009-04-02 12:00:00	MSFT	Stock	19.66	19.89	19.63	19.63	8247268.0
2009-04-02 13:00:00	MSFT	Stock	19.63	19.67	19.3	19.38	14507665.0
2009-04-02 14:00:00	MSFT	Stock	19.37	19.55	19.36	19.41	8612628.0
2009-04-02 15:00:00	MSFT	Stock	19.415	19.49	19.0	19.25	20609866.0
2009-04-02 16:00:00	MSFT	Stock	19.23	19.73	19.12	19.34	3579839.0
2009-04-02 17:00:00	MSFT	Stock	19.36	19.446	19.34	19.37	29698.0
2009-04-02 18:00:00	MSFT	Stock	19.4	19.44	19.35	19.35	6379.0
2009-04-02 19:00:00	MSFT	Stock	19.35	19.4	19.33	19.35	17135.0
2009-04-02 08:00:00	NVDA	Stock	0.2527	0.2618	0.2527	0.2618	2033160.0
2009-04-02 09:00:00	NVDA	Stock	0.2618	0.2632	0.26	0.2625	102542920.0
2009-04-02 10:00:00	NVDA	Stock	0.2625	0.2648	0.2585	0.2628	188146160.0
2009-04-02 11:00:00	NVDA	Stock	0.2628	0.2648	0.2618	0.2624	116771400.0
2009-04-02 12:00:00	NVDA	Stock	0.2625	0.2672	0.2623	0.2644	80155160.0
2009-04-02 13:00:00	NVDA	Stock	0.2643	0.2645	0.2598	0.261	74311960.0
2009-04-02 14:00:00	NVDA	Stock	0.261	0.268	0.2603	0.2678	189415040.0
2009-04-02 15:00:00	NVDA	Stock	0.2678	0.2692	0.2618	0.264	217445480.0
2009-04-02 16:00:00	NVDA	Stock	0.264	0.2663	0.2637	0.2645	5771360.0
2009-04-02 17:00:00	NVDA	Stock	0.2645	0.267	0.2645	0.267	42800.0
2009-04-02 18:00:00	NVDA	Stock	0.267	0.2675	0.2655	0.2655	938000.0
2009-04-02 19:00:00	NVDA	Stock	0.2645	0.2645	0.2645	0.2645	52000.0
2009-04-02 06:00:00	AMZN	Stock	3.772	3.772	3.725	3.725	4000.0
2009-04-02 07:00:00	AMZN	Stock	3.74	3.7595	3.71	3.7175	122000.0
2009-04-02 08:00:00	AMZN	Stock	3.7195	3.7195	3.635	3.65	1503240.0
2009-04-02 09:00:00	AMZN	Stock	3.654	3.736	3.6405	3.6935	32946140.0
2009-04-02 10:00:00	AMZN	Stock	3.6935	3.8	3.681	3.785	42317400.0
2009-04-02 11:00:00	AMZN	Stock	3.788	3.8205	3.767	3.815	24150800.0
2009-04-02 12:00:00	AMZN	Stock	3.8153	3.862	3.806	3.835	23623240.0

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

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