PREVIEW / stock_1hour / 2012-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-02-21.parquet
  size:    966 KB
  rows:    45,583
  symbols: 3,558

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
2012-02-21 04:00:00	AAPL	Stock	18.1068	18.1089	18.0589	18.0589	116200.0
2012-02-21 05:00:00	AAPL	Stock	18.0543	18.0543	17.9704	17.9704	148456.0
2012-02-21 06:00:00	AAPL	Stock	17.9857	18.0268	17.9643	17.9643	135632.0
2012-02-21 07:00:00	AAPL	Stock	17.985	18.0175	17.945	17.9893	1207752.0
2012-02-21 08:00:00	AAPL	Stock	17.9982	18.125	17.9689	18.0829	4751068.0
2012-02-21 09:00:00	AAPL	Stock	18.0829	18.1314	18.0043	18.0614	82021688.0
2012-02-21 10:00:00	AAPL	Stock	18.0598	18.2857	18.0571	18.2854	104942712.0
2012-02-21 11:00:00	AAPL	Stock	18.2854	18.3361	18.2396	18.3297	77630308.0
2012-02-21 12:00:00	AAPL	Stock	18.3275	18.355	18.2321	18.2536	63290976.0
2012-02-21 13:00:00	AAPL	Stock	18.2554	18.2857	18.2089	18.2582	45566108.0
2012-02-21 14:00:00	AAPL	Stock	18.26	18.2679	18.0821	18.1632	83712076.0
2012-02-21 15:00:00	AAPL	Stock	18.1646	18.3875	18.1396	18.3771	105829696.0
2012-02-21 16:00:00	AAPL	Stock	18.3804	18.4389	18.206	18.4336	22465604.0
2012-02-21 17:00:00	AAPL	Stock	18.4321	18.4521	18.4075	18.4521	1038716.0
2012-02-21 18:00:00	AAPL	Stock	18.4543	18.4621	18.395	18.4036	1835092.0
2012-02-21 19:00:00	AAPL	Stock	18.4036	18.4036	18.3321	18.3404	1407952.0
2012-02-21 05:00:00	MSFT	Stock	31.49	31.49	31.49	31.49	175.0
2012-02-21 07:00:00	MSFT	Stock	31.27	31.27	31.26	31.26	3000.0
2012-02-21 08:00:00	MSFT	Stock	31.24	31.25	31.15	31.23	13100.0
2012-02-21 09:00:00	MSFT	Stock	31.23	31.26	31.15	31.22	5772684.0
2012-02-21 10:00:00	MSFT	Stock	31.22	31.5	31.2	31.43	10384722.0
2012-02-21 11:00:00	MSFT	Stock	31.42	31.5	31.38	31.5	4420075.0
2012-02-21 12:00:00	MSFT	Stock	31.49	31.52	31.31	31.37	5827871.0
2012-02-21 13:00:00	MSFT	Stock	31.38	31.405	31.29	31.324	4676380.0
2012-02-21 14:00:00	MSFT	Stock	31.325	31.35	31.25	31.3	5813290.0
2012-02-21 15:00:00	MSFT	Stock	31.31	31.45	31.25	31.438	9784000.0
2012-02-21 16:00:00	MSFT	Stock	31.44	31.45	31.31	31.376	2759987.0
2012-02-21 17:00:00	MSFT	Stock	31.44	31.44	31.4	31.4	12758.0
2012-02-21 18:00:00	MSFT	Stock	31.4	31.42	31.4	31.42	1248.0
2012-02-21 19:00:00	MSFT	Stock	31.41	31.41	31.37	31.37	2686.0
2012-02-21 08:00:00	NVDA	Stock	0.394	0.3998	0.394	0.3968	667200.0
2012-02-21 09:00:00	NVDA	Stock	0.3968	0.4032	0.3953	0.3984	118755760.0
2012-02-21 10:00:00	NVDA	Stock	0.3985	0.4068	0.398	0.4065	93255200.0
2012-02-21 11:00:00	NVDA	Stock	0.4065	0.408	0.4053	0.406	86025120.0
2012-02-21 12:00:00	NVDA	Stock	0.406	0.4078	0.4022	0.4025	39761440.0
2012-02-21 13:00:00	NVDA	Stock	0.4025	0.4043	0.3993	0.3993	38776520.0
2012-02-21 14:00:00	NVDA	Stock	0.3993	0.4	0.3973	0.3978	48674840.0
2012-02-21 15:00:00	NVDA	Stock	0.3978	0.3988	0.3962	0.3982	80229360.0
2012-02-21 16:00:00	NVDA	Stock	0.3981	0.4017	0.3975	0.3975	6772440.0
2012-02-21 19:00:00	NVDA	Stock	0.3975	0.3985	0.3975	0.3975	34400.0
2012-02-21 06:00:00	AMZN	Stock	9.17	9.17	9.17	9.17	2000.0
2012-02-21 07:00:00	AMZN	Stock	9.1935	9.196	9.17	9.1925	16000.0
2012-02-21 08:00:00	AMZN	Stock	9.1535	9.1635	9.13	9.152	163500.0
2012-02-21 09:00:00	AMZN	Stock	9.153	9.2375	9.099	9.1235	23655780.0
2012-02-21 10:00:00	AMZN	Stock	9.125	9.163	9.1105	9.116	15656780.0
2012-02-21 11:00:00	AMZN	Stock	9.1185	9.121	9.064	9.068	18691580.0
2012-02-21 12:00:00	AMZN	Stock	9.066	9.1295	9.066	9.075	13309360.0
2012-02-21 13:00:00	AMZN	Stock	9.076	9.092	9.0288	9.053	17101320.0
2012-02-21 14:00:00	AMZN	Stock	9.053	9.0595	9.0365	9.0535	20080100.0
2012-02-21 15:00:00	AMZN	Stock	9.0543	9.1175	9.0495	9.113	21873880.0

> showing 50 of 45,583 rows — these rows as CSV

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