PREVIEW / stock_30min / 2011-11-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-25.parquet
  size:    877 KB
  rows:    43,008
  symbols: 3,359

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
2011-11-25 04:00:00	AAPL	Stock	13.0571	13.0571	13.0093	13.0093	11200.0
2011-11-25 04:30:00	AAPL	Stock	13.0089	13.0089	12.9964	12.9964	23772.0
2011-11-25 06:30:00	AAPL	Stock	13.0179	13.0179	13.0179	13.0179	12740.0
2011-11-25 07:00:00	AAPL	Stock	13.0554	13.0604	13.0357	13.0604	22120.0
2011-11-25 07:30:00	AAPL	Stock	13.0536	13.0554	13.0536	13.0554	11200.0
2011-11-25 08:00:00	AAPL	Stock	13.0707	13.1161	13.0493	13.1118	774424.0
2011-11-25 08:30:00	AAPL	Stock	13.125	13.1893	13.1071	13.1821	1572900.0
2011-11-25 09:00:00	AAPL	Stock	13.1757	13.2354	13.1468	13.1468	4114404.0
2011-11-25 09:30:00	AAPL	Stock	13.1529	13.2554	13.1468	13.1746	44900632.0
2011-11-25 10:00:00	AAPL	Stock	13.1718	13.2096	13.1418	13.1418	22617644.0
2011-11-25 10:30:00	AAPL	Stock	13.1418	13.1546	13.0986	13.1021	26804764.0
2011-11-25 11:00:00	AAPL	Stock	13.1018	13.1214	13.0714	13.0814	23777740.0
2011-11-25 11:30:00	AAPL	Stock	13.0836	13.0957	12.9757	13.0332	43083936.0
2011-11-25 12:00:00	AAPL	Stock	13.0332	13.0621	13.0055	13.0596	21136276.0
2011-11-25 12:30:00	AAPL	Stock	13.0596	13.0736	12.9839	12.9854	39029956.0
2011-11-25 13:00:00	AAPL	Stock	12.9911	13.1161	12.9821	13.1143	9905224.0
2011-11-25 13:30:00	AAPL	Stock	13.0071	13.06	12.9846	13.0429	1741292.0
2011-11-25 14:00:00	AAPL	Stock	13.0414	13.0446	13.0357	13.0357	389844.0
2011-11-25 14:30:00	AAPL	Stock	13.0357	13.0446	13.0357	13.0446	153496.0
2011-11-25 15:00:00	AAPL	Stock	13.0429	13.0436	13.0357	13.0357	219184.0
2011-11-25 15:30:00	AAPL	Stock	13.0357	13.0357	13.0321	13.0321	84812.0
2011-11-25 16:00:00	AAPL	Stock	13.0261	13.0429	13.025	13.0364	118692.0
2011-11-25 16:30:00	AAPL	Stock	13.0375	13.0432	13.0357	13.0432	54572.0
2011-11-25 04:00:00	MSFT	Stock	24.44	24.44	24.25	24.25	900.0
2011-11-25 06:30:00	MSFT	Stock	24.37	24.37	24.37	24.37	150.0
2011-11-25 07:30:00	MSFT	Stock	24.32	24.33	24.29	24.3	3763.0
2011-11-25 08:00:00	MSFT	Stock	24.32	24.44	24.29	24.39	25535.0
2011-11-25 08:30:00	MSFT	Stock	24.38	24.4	24.35	24.4	5000.0
2011-11-25 09:00:00	MSFT	Stock	24.37	24.48	24.32	24.38	137127.0
2011-11-25 09:30:00	MSFT	Stock	24.39	24.67	24.32	24.515	4572387.0
2011-11-25 10:00:00	MSFT	Stock	24.515	24.605	24.49	24.52	3685468.0
2011-11-25 10:30:00	MSFT	Stock	24.52	24.54	24.47	24.508	2274170.0
2011-11-25 11:00:00	MSFT	Stock	24.508	24.54	24.47	24.49	2117361.0
2011-11-25 11:30:00	MSFT	Stock	24.49	24.54	24.37	24.39	2193633.0
2011-11-25 12:00:00	MSFT	Stock	24.385	24.39	24.3	24.39	1667558.0
2011-11-25 12:30:00	MSFT	Stock	24.385	24.45	24.3	24.3	5650500.0
2011-11-25 13:00:00	MSFT	Stock	24.3	24.472	24.27	24.315	1348642.0
2011-11-25 13:30:00	MSFT	Stock	24.3	24.466	24.29	24.3	281560.0
2011-11-25 14:00:00	MSFT	Stock	24.34	24.35	24.33	24.35	900.0
2011-11-25 14:30:00	MSFT	Stock	24.35	24.35	24.33	24.33	2200.0
2011-11-25 15:00:00	MSFT	Stock	24.35	24.35	24.35	24.35	900.0
2011-11-25 15:30:00	MSFT	Stock	24.35	24.35	24.3	24.3	2180.0
2011-11-25 16:00:00	MSFT	Stock	24.29	24.29	24.27	24.27	1400.0
2011-11-25 16:30:00	MSFT	Stock	24.27	24.27	24.27	24.27	200.0
2011-11-25 04:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	8000.0
2011-11-25 08:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	6000.0
2011-11-25 08:30:00	NVDA	Stock	0.36	0.361	0.36	0.361	111560.0
2011-11-25 09:00:00	NVDA	Stock	0.3612	0.3612	0.3565	0.3585	312000.0
2011-11-25 09:30:00	NVDA	Stock	0.3562	0.3632	0.3542	0.3588	94153480.0
2011-11-25 10:00:00	NVDA	Stock	0.3589	0.3645	0.3585	0.3596	65933760.0

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

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