PREVIEW / stock_1hour / 2006-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-27.parquet
  size:    644 KB
  rows:    30,338
  symbols: 2,457

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-27 06:00:00	AAPL	Stock	3.2725	3.2857	3.2725	3.2857	87080.0
2006-11-27 07:00:00	AAPL	Stock	3.2857	3.3039	3.2857	3.2993	832132.0
2006-11-27 08:00:00	AAPL	Stock	3.3032	3.3157	3.2946	3.3	10130540.0
2006-11-27 09:00:00	AAPL	Stock	3.3	3.3271	3.2918	3.3054	159134920.0
2006-11-27 10:00:00	AAPL	Stock	3.3061	3.3061	3.2554	3.2804	232535912.0
2006-11-27 11:00:00	AAPL	Stock	3.28	3.2839	3.2357	3.2393	149427964.0
2006-11-27 12:00:00	AAPL	Stock	3.2389	3.2514	3.2075	3.2096	145882156.0
2006-11-27 13:00:00	AAPL	Stock	3.2093	3.2257	3.2029	3.2221	114009672.0
2006-11-27 14:00:00	AAPL	Stock	3.2225	3.2304	3.2057	3.2114	102031608.0
2006-11-27 15:00:00	AAPL	Stock	3.2111	3.2186	3.1964	3.1964	145263776.0
2006-11-27 16:00:00	AAPL	Stock	3.1964	3.1975	3.19	3.1939	2625980.0
2006-11-27 17:00:00	AAPL	Stock	3.1939	3.1979	3.1929	3.1979	357700.0
2006-11-27 18:00:00	AAPL	Stock	3.1979	3.1996	3.1929	3.1979	430248.0
2006-11-27 19:00:00	AAPL	Stock	3.1979	3.2007	3.1964	3.2004	251860.0
2006-11-27 07:00:00	MSFT	Stock	29.7	29.7	29.7	29.7	100.0
2006-11-27 08:00:00	MSFT	Stock	29.7	29.76	29.67	29.68	15042.0
2006-11-27 09:00:00	MSFT	Stock	29.7	29.74	29.59	29.66	5291452.0
2006-11-27 10:00:00	MSFT	Stock	29.66	29.7	29.47	29.51	11285016.0
2006-11-27 11:00:00	MSFT	Stock	29.51	29.52	29.33	29.44	12071188.0
2006-11-27 12:00:00	MSFT	Stock	29.441	29.58	29.41	29.48	7112846.0
2006-11-27 13:00:00	MSFT	Stock	29.48	29.56	29.42	29.492	7520691.0
2006-11-27 14:00:00	MSFT	Stock	29.5	29.69	29.44	29.53	6125796.0
2006-11-27 15:00:00	MSFT	Stock	29.52	29.53	29.45	29.47	11166289.0
2006-11-27 16:00:00	MSFT	Stock	29.47	29.58	29.42	29.43	198601.0
2006-11-27 17:00:00	MSFT	Stock	29.43	29.43	29.42	29.43	1480.0
2006-11-27 18:00:00	MSFT	Stock	29.44	29.5	29.44	29.5	600.0
2006-11-27 19:00:00	MSFT	Stock	29.47	29.47	29.44	29.44	1810.0
2006-11-27 08:00:00	NVDA	Stock	0.6163	0.6165	0.6163	0.6165	60000.0
2006-11-27 09:00:00	NVDA	Stock	0.6163	0.6208	0.6107	0.6127	52380840.0
2006-11-27 10:00:00	NVDA	Stock	0.6122	0.615	0.6033	0.6067	92027940.0
2006-11-27 11:00:00	NVDA	Stock	0.607	0.6072	0.6012	0.6027	59883360.0
2006-11-27 12:00:00	NVDA	Stock	0.6025	0.6033	0.5972	0.5978	67145880.0
2006-11-27 13:00:00	NVDA	Stock	0.5978	0.5983	0.587	0.5873	101098320.0
2006-11-27 14:00:00	NVDA	Stock	0.5875	0.5932	0.5862	0.5882	106481460.0
2006-11-27 15:00:00	NVDA	Stock	0.588	0.5892	0.5843	0.5882	91365840.0
2006-11-27 16:00:00	NVDA	Stock	0.588	0.5887	0.5877	0.5885	792000.0
2006-11-27 17:00:00	NVDA	Stock	0.5878	0.5885	0.5878	0.588	66000.0
2006-11-27 08:00:00	AMZN	Stock	2.1225	2.1225	2.1225	2.1225	9000.0
2006-11-27 09:00:00	AMZN	Stock	2.12	2.14	2.109	2.1185	16809540.0
2006-11-27 10:00:00	AMZN	Stock	2.12	2.12	2.055	2.0776	46065120.0
2006-11-27 11:00:00	AMZN	Stock	2.0776	2.078	2.0575	2.069	18780540.0
2006-11-27 12:00:00	AMZN	Stock	2.069	2.08	2.046	2.0475	19672880.0
2006-11-27 13:00:00	AMZN	Stock	2.048	2.0575	2.0435	2.0554	20477780.0
2006-11-27 14:00:00	AMZN	Stock	2.0554	2.0555	2.0425	2.044	15808580.0
2006-11-27 15:00:00	AMZN	Stock	2.044	2.0455	2.036	2.0425	36255480.0
2006-11-27 16:00:00	AMZN	Stock	2.0425	2.0435	2.041	2.0435	104600.0
2006-11-27 17:00:00	AMZN	Stock	2.0405	2.0475	2.038	2.0475	106000.0
2006-11-27 18:00:00	AMZN	Stock	2.038	2.038	2.0375	2.0375	30000.0
2006-11-27 09:00:00	CL	Stock	32.815	32.86	32.645	32.665	448600.0
2006-11-27 10:00:00	CL	Stock	32.655	32.66	32.52	32.575	782000.0

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

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