PREVIEW / stock_1hour / 2005-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-15.parquet
  size:    590 KB
  rows:    27,841
  symbols: 2,111

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
2005-11-15 08:00:00	AAPL	Stock	2.1911	2.1961	2.1886	2.1961	343140.0
2005-11-15 09:00:00	AAPL	Stock	2.1929	2.2496	2.19	2.2443	124455016.0
2005-11-15 10:00:00	AAPL	Stock	2.2443	2.2529	2.23	2.2421	118981324.0
2005-11-15 11:00:00	AAPL	Stock	2.2421	2.2461	2.2296	2.2418	39784192.0
2005-11-15 12:00:00	AAPL	Stock	2.2425	2.2471	2.2339	2.2443	40756744.0
2005-11-15 13:00:00	AAPL	Stock	2.2439	2.2482	2.2214	2.2261	58117276.0
2005-11-15 14:00:00	AAPL	Stock	2.2261	2.2368	2.2196	2.2201	70070056.0
2005-11-15 15:00:00	AAPL	Stock	2.2204	2.2279	2.215	2.2239	77587580.0
2005-11-15 16:00:00	AAPL	Stock	2.2246	2.2319	2.2221	2.2225	919352.0
2005-11-15 17:00:00	AAPL	Stock	2.225	2.225	2.2232	2.2232	92372.0
2005-11-15 18:00:00	AAPL	Stock	2.2232	2.225	2.2232	2.2243	29400.0
2005-11-15 07:00:00	MSFT	Stock	27.32	27.32	27.32	27.32	381.0
2005-11-15 08:00:00	MSFT	Stock	27.35	27.35	27.3	27.33	42935.0
2005-11-15 09:00:00	MSFT	Stock	27.33	27.4	27.28	27.33	7916885.0
2005-11-15 10:00:00	MSFT	Stock	27.32	27.43	27.25	27.37	11281808.0
2005-11-15 11:00:00	MSFT	Stock	27.37	27.45	27.35	27.39	5248918.0
2005-11-15 12:00:00	MSFT	Stock	27.39	27.47	27.34	27.45	4844946.0
2005-11-15 13:00:00	MSFT	Stock	27.45	27.47	27.33	27.35	5259770.0
2005-11-15 14:00:00	MSFT	Stock	27.34	27.43	27.33	27.39	7869762.0
2005-11-15 15:00:00	MSFT	Stock	27.4	27.54	27.36	27.49	18613521.0
2005-11-15 16:00:00	MSFT	Stock	27.5	27.55	27.39	27.49	193404.0
2005-11-15 17:00:00	MSFT	Stock	27.49	27.53	27.49	27.49	1812384.0
2005-11-15 18:00:00	MSFT	Stock	27.49	27.497	27.49	27.497	1104.0
2005-11-15 09:00:00	NVDA	Stock	0.2902	0.2917	0.2894	0.2904	61134000.0
2005-11-15 10:00:00	NVDA	Stock	0.2904	0.2942	0.2902	0.2929	95253840.0
2005-11-15 11:00:00	NVDA	Stock	0.2929	0.2929	0.2907	0.2925	47849520.0
2005-11-15 12:00:00	NVDA	Stock	0.2924	0.2928	0.2913	0.2918	44959440.0
2005-11-15 13:00:00	NVDA	Stock	0.2918	0.2926	0.2907	0.2907	49886160.0
2005-11-15 14:00:00	NVDA	Stock	0.2908	0.2925	0.2907	0.291	92287080.0
2005-11-15 15:00:00	NVDA	Stock	0.2911	0.2919	0.2895	0.2903	80155200.0
2005-11-15 16:00:00	NVDA	Stock	0.2903	0.2917	0.29	0.2917	946920.0
2005-11-15 17:00:00	NVDA	Stock	0.2902	0.2902	0.2902	0.2902	42000.0
2005-11-15 18:00:00	NVDA	Stock	0.2912	0.2912	0.2912	0.2912	12000.0
2005-11-15 07:00:00	AMZN	Stock	2.2625	2.2675	2.255	2.26	713180.0
2005-11-15 08:00:00	AMZN	Stock	2.26	2.295	2.2575	2.2825	30355720.0
2005-11-15 09:00:00	AMZN	Stock	2.2825	2.2825	2.248	2.2605	119266140.0
2005-11-15 10:00:00	AMZN	Stock	2.2605	2.261	2.238	2.2475	73291080.0
2005-11-15 11:00:00	AMZN	Stock	2.248	2.2545	2.243	2.249	30340920.0
2005-11-15 12:00:00	AMZN	Stock	2.249	2.2615	2.2475	2.2595	24000160.0
2005-11-15 13:00:00	AMZN	Stock	2.2595	2.266	2.253	2.253	27342860.0
2005-11-15 14:00:00	AMZN	Stock	2.2535	2.2555	2.2425	2.244	39329120.0
2005-11-15 15:00:00	AMZN	Stock	2.244	2.2495	2.2215	2.2225	75811920.0
2005-11-15 16:00:00	AMZN	Stock	2.2225	2.2578	2.2225	2.2225	2481720.0
2005-11-15 17:00:00	AMZN	Stock	2.2245	2.227	2.2245	2.227	12000.0
2005-11-15 09:00:00	CL	Stock	26.76	26.875	26.615	26.625	460000.0
2005-11-15 10:00:00	CL	Stock	26.625	26.735	26.575	26.63	292200.0
2005-11-15 11:00:00	CL	Stock	26.625	26.65	26.585	26.645	294400.0
2005-11-15 12:00:00	CL	Stock	26.635	26.685	26.575	26.68	334600.0
2005-11-15 13:00:00	CL	Stock	26.685	26.745	26.67	26.7	414400.0
2005-11-15 14:00:00	CL	Stock	26.705	26.745	26.63	26.665	509600.0

> showing 50 of 27,841 rows — these rows as CSV

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