PREVIEW / stock_1hour / 2009-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-13.parquet
  size:    874 KB
  rows:    41,841
  symbols: 3,400

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-11-13 05:00:00	AAPL	Stock	7.2411	7.2411	7.1714	7.2071	34608.0
2009-11-13 06:00:00	AAPL	Stock	7.2146	7.2404	7.2146	7.2404	5600.0
2009-11-13 07:00:00	AAPL	Stock	7.2429	7.2429	7.2364	7.2364	14000.0
2009-11-13 08:00:00	AAPL	Stock	7.2321	7.2757	7.225	7.26	1904532.0
2009-11-13 09:00:00	AAPL	Stock	7.2607	7.2625	7.2168	7.2357	55704460.0
2009-11-13 10:00:00	AAPL	Stock	7.2343	7.2696	7.2282	7.2564	57002484.0
2009-11-13 11:00:00	AAPL	Stock	7.2568	7.2946	7.2529	7.285	49577528.0
2009-11-13 12:00:00	AAPL	Stock	7.2846	7.3154	7.2843	7.2939	32919880.0
2009-11-13 13:00:00	AAPL	Stock	7.2939	7.3021	7.2768	7.2796	24096100.0
2009-11-13 14:00:00	AAPL	Stock	7.2793	7.2964	7.2507	7.2536	38641960.0
2009-11-13 15:00:00	AAPL	Stock	7.2536	7.31	7.2432	7.3032	67567640.0
2009-11-13 16:00:00	AAPL	Stock	7.3036	7.3107	7.2719	7.3071	6304704.0
2009-11-13 17:00:00	AAPL	Stock	7.3054	7.3066	7.2964	7.3066	539560.0
2009-11-13 18:00:00	AAPL	Stock	7.3036	7.3036	7.3	7.3025	637672.0
2009-11-13 19:00:00	AAPL	Stock	7.3057	7.3089	7.3036	7.3064	149800.0
2009-11-13 06:00:00	MSFT	Stock	29.59	29.59	29.59	29.59	100.0
2009-11-13 07:00:00	MSFT	Stock	29.59	29.6	29.5	29.6	700.0
2009-11-13 08:00:00	MSFT	Stock	29.58	29.59	29.45	29.55	19952.0
2009-11-13 09:00:00	MSFT	Stock	29.55	29.59	29.39	29.42	6288735.0
2009-11-13 10:00:00	MSFT	Stock	29.42	29.55	29.37	29.5	7843637.0
2009-11-13 11:00:00	MSFT	Stock	29.5	29.71	29.48	29.68	7098329.0
2009-11-13 12:00:00	MSFT	Stock	29.68	29.79	29.65	29.745	5869969.0
2009-11-13 13:00:00	MSFT	Stock	29.75	29.79	29.64	29.68	6280857.0
2009-11-13 14:00:00	MSFT	Stock	29.67	29.74	29.58	29.58	7789432.0
2009-11-13 15:00:00	MSFT	Stock	29.58	29.69	29.58	29.63	9265980.0
2009-11-13 16:00:00	MSFT	Stock	29.63	29.74	29.588	29.6	1591305.0
2009-11-13 17:00:00	MSFT	Stock	29.36	29.7	29.36	29.6	4413.0
2009-11-13 18:00:00	MSFT	Stock	29.65	29.65	29.63	29.63	15586.0
2009-11-13 19:00:00	MSFT	Stock	29.63	29.63	29.6	29.62	2110.0
2009-11-13 08:00:00	NVDA	Stock	0.337	0.339	0.3368	0.339	64000.0
2009-11-13 09:00:00	NVDA	Stock	0.3362	0.3394	0.3355	0.3365	67290400.0
2009-11-13 10:00:00	NVDA	Stock	0.3365	0.3408	0.3348	0.3388	81951760.0
2009-11-13 11:00:00	NVDA	Stock	0.3388	0.3393	0.337	0.3373	53953760.0
2009-11-13 12:00:00	NVDA	Stock	0.3373	0.3408	0.337	0.339	50724960.0
2009-11-13 13:00:00	NVDA	Stock	0.3388	0.3408	0.338	0.34	30016880.0
2009-11-13 14:00:00	NVDA	Stock	0.3398	0.3405	0.337	0.3371	37863280.0
2009-11-13 15:00:00	NVDA	Stock	0.3375	0.3398	0.3373	0.339	59849240.0
2009-11-13 16:00:00	NVDA	Stock	0.3393	0.3395	0.338	0.339	4820640.0
2009-11-13 17:00:00	NVDA	Stock	0.3393	0.3393	0.3385	0.3385	132000.0
2009-11-13 05:00:00	AMZN	Stock	6.52	6.52	6.52	6.52	2000.0
2009-11-13 06:00:00	AMZN	Stock	6.5405	6.5405	6.5405	6.5405	2000.0
2009-11-13 07:00:00	AMZN	Stock	6.534	6.539	6.5335	6.539	8000.0
2009-11-13 08:00:00	AMZN	Stock	6.55	6.5625	6.546	6.561	135500.0
2009-11-13 09:00:00	AMZN	Stock	6.5545	6.5745	6.5105	6.5353	20235760.0
2009-11-13 10:00:00	AMZN	Stock	6.537	6.5475	6.4875	6.518	33437820.0
2009-11-13 11:00:00	AMZN	Stock	6.518	6.565	6.517	6.5445	16390480.0
2009-11-13 12:00:00	AMZN	Stock	6.5445	6.5865	6.5425	6.584	10756800.0
2009-11-13 13:00:00	AMZN	Stock	6.583	6.5945	6.57	6.5735	10276520.0
2009-11-13 14:00:00	AMZN	Stock	6.573	6.5865	6.5485	6.5515	12802520.0
2009-11-13 15:00:00	AMZN	Stock	6.551	6.6495	6.543	6.648	33584300.0

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

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