PREVIEW / stock_30min / 2010-09-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-23.parquet
  size:    1.4 MB
  rows:    74,402
  symbols: 3,458

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-09-23 04:30:00	AAPL	Stock	10.2411	10.2411	10.2411	10.2411	2800.0
2010-09-23 05:30:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 06:30:00	AAPL	Stock	10.2286	10.2286	10.2286	10.2286	2800.0
2010-09-23 07:00:00	AAPL	Stock	10.2321	10.2411	10.2157	10.2321	205800.0
2010-09-23 07:30:00	AAPL	Stock	10.2268	10.2357	10.2232	10.2289	138460.0
2010-09-23 08:00:00	AAPL	Stock	10.2343	10.2625	10.2268	10.25	2035432.0
2010-09-23 08:30:00	AAPL	Stock	10.2454	10.2564	10.2232	10.2321	4282180.0
2010-09-23 09:00:00	AAPL	Stock	10.2321	10.2511	10.2214	10.2339	2771524.0
2010-09-23 09:30:00	AAPL	Stock	10.235	10.3029	10.2143	10.2793	95134536.0
2010-09-23 10:00:00	AAPL	Stock	10.2804	10.3486	10.2782	10.3471	74429628.0
2010-09-23 10:30:00	AAPL	Stock	10.3481	10.4057	10.3425	10.3696	74859848.0
2010-09-23 11:00:00	AAPL	Stock	10.3689	10.4364	10.3636	10.4357	51991128.0
2010-09-23 11:30:00	AAPL	Stock	10.436	10.4557	10.3886	10.4107	61981276.0
2010-09-23 12:00:00	AAPL	Stock	10.4107	10.4335	10.4039	10.4134	33821088.0
2010-09-23 12:30:00	AAPL	Stock	10.4143	10.4364	10.4114	10.4225	25778984.0
2010-09-23 13:00:00	AAPL	Stock	10.4218	10.4357	10.4164	10.4217	16923480.0
2010-09-23 13:30:00	AAPL	Stock	10.4218	10.4375	10.4182	10.4286	24564148.0
2010-09-23 14:00:00	AAPL	Stock	10.4293	10.4454	10.425	10.4396	26195820.0
2010-09-23 14:30:00	AAPL	Stock	10.4399	10.4461	10.3304	10.3414	76337912.0
2010-09-23 15:00:00	AAPL	Stock	10.3414	10.3461	10.2611	10.2646	108214372.0
2010-09-23 15:30:00	AAPL	Stock	10.2661	10.3186	10.2571	10.3186	93346764.0
2010-09-23 16:00:00	AAPL	Stock	10.3148	10.4279	10.2843	10.351	6406904.0
2010-09-23 16:30:00	AAPL	Stock	10.3179	10.3634	10.2222	10.3214	1070020.0
2010-09-23 17:00:00	AAPL	Stock	10.4186	10.4186	10.3179	10.3357	699328.0
2010-09-23 17:30:00	AAPL	Stock	10.3379	10.3393	10.3289	10.3321	239512.0
2010-09-23 18:00:00	AAPL	Stock	10.3357	10.3375	10.3164	10.3204	348628.0
2010-09-23 18:30:00	AAPL	Stock	10.3204	10.3204	10.3129	10.3129	110992.0
2010-09-23 19:00:00	AAPL	Stock	10.3132	10.3189	10.3129	10.3189	47600.0
2010-09-23 19:30:00	AAPL	Stock	10.3214	10.3311	10.3196	10.3225	531888.0
2010-09-23 04:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	200.0
2010-09-23 07:30:00	MSFT	Stock	24.56	24.56	24.56	24.56	200.0
2010-09-23 08:00:00	MSFT	Stock	24.54	24.55	24.5	24.54	18363.0
2010-09-23 08:30:00	MSFT	Stock	24.53	24.53	24.45	24.48	75146.0
2010-09-23 09:00:00	MSFT	Stock	24.45	24.55	24.45	24.49	51872.0
2010-09-23 09:30:00	MSFT	Stock	24.52	24.52	24.385	24.39	5003139.0
2010-09-23 10:00:00	MSFT	Stock	24.385	24.49	24.38	24.48	3257965.0
2010-09-23 10:30:00	MSFT	Stock	24.48	24.59	24.47	24.53	4438384.0
2010-09-23 11:00:00	MSFT	Stock	24.538	24.56	24.51	24.55	2848656.0
2010-09-23 11:30:00	MSFT	Stock	24.545	24.55	24.51	24.522	3305485.0
2010-09-23 12:00:00	MSFT	Stock	24.53	24.54	24.51	24.54	1237551.0
2010-09-23 12:30:00	MSFT	Stock	24.54	24.55	24.45	24.46	2110207.0
2010-09-23 13:00:00	MSFT	Stock	24.46	24.48	24.4	24.439	2148882.0
2010-09-23 13:30:00	MSFT	Stock	24.44	24.48	24.41	24.45	2706039.0
2010-09-23 14:00:00	MSFT	Stock	24.45	24.49	24.45	24.45	1755869.0
2010-09-23 14:30:00	MSFT	Stock	24.45	24.48	24.4	24.42	3445400.0
2010-09-23 15:00:00	MSFT	Stock	24.415	24.45	24.38	24.39	5768680.0
2010-09-23 15:30:00	MSFT	Stock	24.39	24.45	24.36	24.43	6210565.0
2010-09-23 16:00:00	MSFT	Stock	24.425	24.54	24.42	24.462	1195296.0
2010-09-23 16:30:00	MSFT	Stock	24.427	24.47	24.38	24.45	152636.0
2010-09-23 17:00:00	MSFT	Stock	24.41	24.45	24.41	24.44	4024.0

> showing 50 of 74,402 rows — these rows as CSV

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