PREVIEW / stock_1hour / 2010-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-11.parquet
  size:    916 KB
  rows:    43,505
  symbols: 3,491

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
2010-11-11 04:00:00	AAPL	Stock	11.25	11.2982	11.25	11.2982	8400.0
2010-11-11 05:00:00	AAPL	Stock	11.2857	11.2893	11.2857	11.2893	5600.0
2010-11-11 06:00:00	AAPL	Stock	11.2954	11.2954	11.2664	11.2857	16800.0
2010-11-11 07:00:00	AAPL	Stock	11.2782	11.3179	11.2554	11.2571	214200.0
2010-11-11 08:00:00	AAPL	Stock	11.2607	11.2961	11.2571	11.2657	1596644.0
2010-11-11 09:00:00	AAPL	Stock	11.2675	11.3293	11.2232	11.3146	79709140.0
2010-11-11 10:00:00	AAPL	Stock	11.3143	11.3714	11.2921	11.3461	74986240.0
2010-11-11 11:00:00	AAPL	Stock	11.3475	11.3496	11.2982	11.3396	36123472.0
2010-11-11 12:00:00	AAPL	Stock	11.3382	11.3646	11.3218	11.3286	29933288.0
2010-11-11 13:00:00	AAPL	Stock	11.3279	11.3571	11.3039	11.3471	32263140.0
2010-11-11 14:00:00	AAPL	Stock	11.3475	11.3625	11.3182	11.3257	29758792.0
2010-11-11 15:00:00	AAPL	Stock	11.3252	11.3321	11.2911	11.305	61608092.0
2010-11-11 16:00:00	AAPL	Stock	11.3068	11.3289	11.259	11.3139	7279776.0
2010-11-11 17:00:00	AAPL	Stock	11.3111	11.3186	11.3082	11.3132	216664.0
2010-11-11 18:00:00	AAPL	Stock	11.3171	11.3171	11.3054	11.3089	133028.0
2010-11-11 19:00:00	AAPL	Stock	11.3089	11.3311	11.3057	11.3286	247716.0
2010-11-11 06:00:00	MSFT	Stock	26.74	26.74	26.74	26.74	1000.0
2010-11-11 07:00:00	MSFT	Stock	26.75	26.75	26.57	26.63	19538.0
2010-11-11 08:00:00	MSFT	Stock	26.6	26.65	26.56	26.61	55907.0
2010-11-11 09:00:00	MSFT	Stock	26.63	26.69	26.28	26.475	11894400.0
2010-11-11 10:00:00	MSFT	Stock	26.475	26.52	26.4	26.5	9872946.0
2010-11-11 11:00:00	MSFT	Stock	26.5	26.62	26.48	26.607	8844751.0
2010-11-11 12:00:00	MSFT	Stock	26.6	26.61	26.46	26.51	7218903.0
2010-11-11 13:00:00	MSFT	Stock	26.52	26.62	26.49	26.61	4978284.0
2010-11-11 14:00:00	MSFT	Stock	26.62	26.72	26.58	26.69	5605708.0
2010-11-11 15:00:00	MSFT	Stock	26.691	26.7	26.59	26.69	9543960.0
2010-11-11 16:00:00	MSFT	Stock	26.7	26.703	26.4	26.65	1362437.0
2010-11-11 17:00:00	MSFT	Stock	26.67	26.68	26.61	26.68	17524.0
2010-11-11 18:00:00	MSFT	Stock	26.68	26.68	26.6	26.6	17209.0
2010-11-11 19:00:00	MSFT	Stock	26.62	26.67	26.58	26.67	2388.0
2010-11-11 08:00:00	NVDA	Stock	0.3113	0.315	0.3113	0.3135	679480.0
2010-11-11 09:00:00	NVDA	Stock	0.3125	0.3135	0.3068	0.3108	131221920.0
2010-11-11 10:00:00	NVDA	Stock	0.3108	0.3155	0.3099	0.3123	137504200.0
2010-11-11 11:00:00	NVDA	Stock	0.3125	0.3128	0.3098	0.3118	105079880.0
2010-11-11 12:00:00	NVDA	Stock	0.3116	0.3158	0.3115	0.3138	107076320.0
2010-11-11 13:00:00	NVDA	Stock	0.3138	0.3163	0.313	0.3158	83903920.0
2010-11-11 14:00:00	NVDA	Stock	0.3158	0.3205	0.314	0.3165	197135680.0
2010-11-11 15:00:00	NVDA	Stock	0.3168	0.3193	0.313	0.3148	245409840.0
2010-11-11 16:00:00	NVDA	Stock	0.3153	0.3278	0.3	0.3248	43413480.0
2010-11-11 17:00:00	NVDA	Stock	0.3245	0.3288	0.3215	0.3275	15888320.0
2010-11-11 18:00:00	NVDA	Stock	0.3275	0.33	0.3275	0.3278	7037040.0
2010-11-11 19:00:00	NVDA	Stock	0.3283	0.3308	0.3275	0.3293	3155600.0
2010-11-11 05:00:00	AMZN	Stock	8.63	8.64	8.63	8.64	4000.0
2010-11-11 06:00:00	AMZN	Stock	8.635	8.635	8.635	8.635	2000.0
2010-11-11 07:00:00	AMZN	Stock	8.5975	8.5985	8.5745	8.575	92000.0
2010-11-11 08:00:00	AMZN	Stock	8.575	8.589	8.56	8.5665	318820.0
2010-11-11 09:00:00	AMZN	Stock	8.5675	8.6025	8.495	8.58	24292340.0
2010-11-11 10:00:00	AMZN	Stock	8.5785	8.5812	8.5225	8.548	21378160.0
2010-11-11 11:00:00	AMZN	Stock	8.549	8.5525	8.471	8.514	18734240.0
2010-11-11 12:00:00	AMZN	Stock	8.5155	8.5375	8.503	8.5105	9515860.0

> showing 50 of 43,505 rows — these rows as CSV

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