PREVIEW / stock_1hour / 2006-11-29

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-29.parquet
  size:    646 KB
  rows:    30,479
  symbols: 2,460

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
2006-11-29 07:00:00	AAPL	Stock	3.3021	3.3536	3.3021	3.3357	3080280.0
2006-11-29 08:00:00	AAPL	Stock	3.3339	3.3357	3.3164	3.3346	9036216.0
2006-11-29 09:00:00	AAPL	Stock	3.335	3.3357	3.295	3.2996	141645224.0
2006-11-29 10:00:00	AAPL	Stock	3.2999	3.3175	3.2804	3.2943	226325064.0
2006-11-29 11:00:00	AAPL	Stock	3.2936	3.3011	3.2582	3.2593	166231912.0
2006-11-29 12:00:00	AAPL	Stock	3.2593	3.2771	3.2461	3.2696	127738380.0
2006-11-29 13:00:00	AAPL	Stock	3.2693	3.2857	3.2232	3.2396	158683476.0
2006-11-29 14:00:00	AAPL	Stock	3.2393	3.2857	3.2289	3.2746	130794832.0
2006-11-29 15:00:00	AAPL	Stock	3.2729	3.2957	3.2725	3.2786	177171820.0
2006-11-29 16:00:00	AAPL	Stock	3.2768	3.2818	3.2714	3.2818	4043368.0
2006-11-29 17:00:00	AAPL	Stock	3.2818	3.2854	3.2818	3.2825	781872.0
2006-11-29 18:00:00	AAPL	Stock	3.2814	3.2829	3.2786	3.2786	226240.0
2006-11-29 19:00:00	AAPL	Stock	3.2814	3.2821	3.2786	3.2811	817376.0
2006-11-29 07:00:00	MSFT	Stock	29.46	29.47	29.46	29.47	900.0
2006-11-29 08:00:00	MSFT	Stock	29.4	29.52	29.4	29.48	78964.0
2006-11-29 09:00:00	MSFT	Stock	29.5	29.55	29.4	29.55	6513850.0
2006-11-29 10:00:00	MSFT	Stock	29.54	29.69	29.49	29.59	11096142.0
2006-11-29 11:00:00	MSFT	Stock	29.6	29.7	29.59	29.679	6446301.0
2006-11-29 12:00:00	MSFT	Stock	29.67	29.69	29.59	29.6	4164600.0
2006-11-29 13:00:00	MSFT	Stock	29.61	29.61	29.46	29.55	7236385.0
2006-11-29 14:00:00	MSFT	Stock	29.54	29.6	29.51	29.58	6727332.0
2006-11-29 15:00:00	MSFT	Stock	29.57	29.78	29.5	29.58	7843994.0
2006-11-29 16:00:00	MSFT	Stock	29.58	29.6	29.56	29.58	2411583.0
2006-11-29 17:00:00	MSFT	Stock	29.59	29.59	29.59	29.59	100.0
2006-11-29 18:00:00	MSFT	Stock	29.59	29.59	29.569	29.59	891.0
2006-11-29 19:00:00	MSFT	Stock	29.6	29.6	29.58	29.58	1840.0
2006-11-29 08:00:00	NVDA	Stock	0.605	0.6065	0.605	0.6065	192000.0
2006-11-29 09:00:00	NVDA	Stock	0.6052	0.6157	0.5995	0.6148	99755040.0
2006-11-29 10:00:00	NVDA	Stock	0.6147	0.615	0.6058	0.6085	120323280.0
2006-11-29 11:00:00	NVDA	Stock	0.6088	0.6128	0.6088	0.6117	47152980.0
2006-11-29 12:00:00	NVDA	Stock	0.6117	0.6122	0.6092	0.611	63713760.0
2006-11-29 13:00:00	NVDA	Stock	0.611	0.6118	0.6027	0.6042	114023520.0
2006-11-29 14:00:00	NVDA	Stock	0.604	0.6098	0.6028	0.6082	52603080.0
2006-11-29 15:00:00	NVDA	Stock	0.608	0.6098	0.6065	0.6083	60181440.0
2006-11-29 16:00:00	NVDA	Stock	0.6078	0.6083	0.6073	0.6082	450000.0
2006-11-29 17:00:00	NVDA	Stock	0.6082	0.6083	0.6073	0.6073	75000.0
2006-11-29 18:00:00	NVDA	Stock	0.6082	0.6083	0.6082	0.6083	102000.0
2006-11-29 19:00:00	NVDA	Stock	0.6073	0.6083	0.6073	0.6083	105000.0
2006-11-29 08:00:00	AMZN	Stock	2.055	2.055	2.055	2.055	83280.0
2006-11-29 09:00:00	AMZN	Stock	2.0457	2.055	2.0115	2.04	29262500.0
2006-11-29 10:00:00	AMZN	Stock	2.0396	2.0425	2.0265	2.0315	21158520.0
2006-11-29 11:00:00	AMZN	Stock	2.0315	2.055	2.031	2.0395	17042540.0
2006-11-29 12:00:00	AMZN	Stock	2.0395	2.0445	2.0205	2.022	11994620.0
2006-11-29 13:00:00	AMZN	Stock	2.0215	2.0216	2.0025	2.0095	22485280.0
2006-11-29 14:00:00	AMZN	Stock	2.0095	2.0195	2.0	2.017	23066480.0
2006-11-29 15:00:00	AMZN	Stock	2.0174	2.036	2.0165	2.0315	27405580.0
2006-11-29 16:00:00	AMZN	Stock	2.03	2.0325	2.0295	2.0325	74760.0
2006-11-29 19:00:00	AMZN	Stock	2.0325	2.0325	2.0325	2.0325	4000.0
2006-11-29 08:00:00	CL	Stock	32.54	32.54	32.54	32.54	400.0
2006-11-29 09:00:00	CL	Stock	32.5	32.525	32.31	32.525	201800.0

> showing 50 of 30,479 rows — these rows as CSV

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