PREVIEW / stock_1hour / 2010-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-11-22.parquet
  size:    915 KB
  rows:    43,676
  symbols: 3,521

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-22 05:00:00	AAPL	Stock	10.9857	11.0	10.9857	11.0	36400.0
2010-11-22 06:00:00	AAPL	Stock	10.9925	10.9925	10.9643	10.9643	39200.0
2010-11-22 07:00:00	AAPL	Stock	10.9639	10.9782	10.95	10.975	236040.0
2010-11-22 08:00:00	AAPL	Stock	10.975	11.0	10.9339	10.9418	1413496.0
2010-11-22 09:00:00	AAPL	Stock	10.9393	11.1018	10.9164	11.0907	61299840.0
2010-11-22 10:00:00	AAPL	Stock	11.0893	11.0939	10.9946	11.025	70609392.0
2010-11-22 11:00:00	AAPL	Stock	11.0227	11.06	10.9911	11.0534	33315660.0
2010-11-22 12:00:00	AAPL	Stock	11.053	11.0582	10.9721	11.0021	47829544.0
2010-11-22 13:00:00	AAPL	Stock	11.0021	11.0385	10.9804	11.0311	26264056.0
2010-11-22 14:00:00	AAPL	Stock	11.0293	11.0975	11.0236	11.0968	45030244.0
2010-11-22 15:00:00	AAPL	Stock	11.0975	11.1914	11.0732	11.1914	88155564.0
2010-11-22 16:00:00	AAPL	Stock	11.1914	11.2068	10.9405	11.2014	11784332.0
2010-11-22 17:00:00	AAPL	Stock	11.2014	11.2129	11.2011	11.2104	894600.0
2010-11-22 18:00:00	AAPL	Stock	11.2104	11.2104	11.1893	11.1943	788396.0
2010-11-22 19:00:00	AAPL	Stock	11.1957	11.1957	11.1857	11.1857	616616.0
2010-11-22 06:00:00	MSFT	Stock	25.85	25.91	25.65	25.91	1200.0
2010-11-22 08:00:00	MSFT	Stock	25.74	25.74	25.66	25.68	18105.0
2010-11-22 09:00:00	MSFT	Stock	25.67	25.7	25.51	25.67	4062885.0
2010-11-22 10:00:00	MSFT	Stock	25.67	25.72	25.55	25.58	7784844.0
2010-11-22 11:00:00	MSFT	Stock	25.58	25.615	25.52	25.61	6115323.0
2010-11-22 12:00:00	MSFT	Stock	25.605	25.61	25.49	25.5	8675312.0
2010-11-22 13:00:00	MSFT	Stock	25.5	25.56	25.44	25.55	6213822.0
2010-11-22 14:00:00	MSFT	Stock	25.55	25.7	25.53	25.665	5076032.0
2010-11-22 15:00:00	MSFT	Stock	25.67	25.74	25.59	25.74	9972419.0
2010-11-22 16:00:00	MSFT	Stock	25.74	25.93	25.587	25.77	3355852.0
2010-11-22 17:00:00	MSFT	Stock	25.78	25.78	25.76	25.78	7300.0
2010-11-22 18:00:00	MSFT	Stock	25.73	25.78	25.73	25.74	249023.0
2010-11-22 19:00:00	MSFT	Stock	25.75	25.78	25.75	25.77	3690.0
2010-11-22 08:00:00	NVDA	Stock	0.3475	0.3475	0.3413	0.3413	841800.0
2010-11-22 09:00:00	NVDA	Stock	0.3405	0.3438	0.3398	0.3428	57136400.0
2010-11-22 10:00:00	NVDA	Stock	0.343	0.346	0.3402	0.3425	110130840.0
2010-11-22 11:00:00	NVDA	Stock	0.3425	0.3435	0.3418	0.3435	46324280.0
2010-11-22 12:00:00	NVDA	Stock	0.3433	0.3435	0.3385	0.34	46381200.0
2010-11-22 13:00:00	NVDA	Stock	0.34	0.3425	0.3393	0.3418	38875960.0
2010-11-22 14:00:00	NVDA	Stock	0.3418	0.3442	0.341	0.3435	82512120.0
2010-11-22 15:00:00	NVDA	Stock	0.3438	0.3445	0.3425	0.3442	63196080.0
2010-11-22 16:00:00	NVDA	Stock	0.3445	0.3445	0.342	0.3425	7495240.0
2010-11-22 18:00:00	NVDA	Stock	0.344	0.344	0.344	0.344	1873280.0
2010-11-22 19:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	14000.0
2010-11-22 04:00:00	AMZN	Stock	8.305	8.319	8.305	8.319	8000.0
2010-11-22 05:00:00	AMZN	Stock	8.3385	8.3385	8.3385	8.3385	6000.0
2010-11-22 07:00:00	AMZN	Stock	8.3275	8.3275	8.276	8.278	40000.0
2010-11-22 08:00:00	AMZN	Stock	8.275	8.275	8.2285	8.247	159800.0
2010-11-22 09:00:00	AMZN	Stock	8.2465	8.4895	8.243	8.478	20766400.0
2010-11-22 10:00:00	AMZN	Stock	8.4815	8.498	8.4025	8.425	23014520.0
2010-11-22 11:00:00	AMZN	Stock	8.425	8.4485	8.39	8.4135	10792180.0
2010-11-22 12:00:00	AMZN	Stock	8.4125	8.42	8.327	8.3465	13013880.0
2010-11-22 13:00:00	AMZN	Stock	8.3455	8.4005	8.322	8.3855	9554300.0
2010-11-22 14:00:00	AMZN	Stock	8.3835	8.475	8.375	8.474	13764640.0
2010-11-22 15:00:00	AMZN	Stock	8.474	8.53	8.468	8.5205	28651840.0

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

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