PREVIEW / stock_30min / 2011-08-11

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-08-11.parquet
  size:    1.5 MB
  rows:    80,582
  symbols: 3,542

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-08-11 04:00:00	AAPL	Stock	13.2621	13.2871	13.2607	13.2761	47600.0
2011-08-11 04:30:00	AAPL	Stock	13.2893	13.3021	13.2893	13.3021	21000.0
2011-08-11 05:00:00	AAPL	Stock	13.2539	13.2539	13.2539	13.2539	2800.0
2011-08-11 05:30:00	AAPL	Stock	13.2582	13.2854	13.1786	13.1786	51100.0
2011-08-11 06:00:00	AAPL	Stock	13.1589	13.1786	13.1139	13.175	71400.0
2011-08-11 06:30:00	AAPL	Stock	13.1536	13.2596	13.1529	13.2182	225736.0
2011-08-11 07:00:00	AAPL	Stock	13.2161	13.2282	13.1071	13.1079	497952.0
2011-08-11 07:30:00	AAPL	Stock	13.1071	13.1254	13.0107	13.0429	2844240.0
2011-08-11 08:00:00	AAPL	Stock	13.0361	13.1289	13.0036	13.0179	3490396.0
2011-08-11 08:30:00	AAPL	Stock	13.0268	13.1436	12.9811	13.1436	4764928.0
2011-08-11 09:00:00	AAPL	Stock	13.1307	13.2811	13.1179	13.2407	6326544.0
2011-08-11 09:30:00	AAPL	Stock	13.2329	13.25	13.0257	13.1101	103687556.0
2011-08-11 10:00:00	AAPL	Stock	13.1104	13.2318	13.0964	13.1754	65186744.0
2011-08-11 10:30:00	AAPL	Stock	13.18	13.2857	13.1568	13.2638	63558516.0
2011-08-11 11:00:00	AAPL	Stock	13.2657	13.2936	13.1986	13.2414	48323660.0
2011-08-11 11:30:00	AAPL	Stock	13.2406	13.3032	13.2136	13.2711	33507964.0
2011-08-11 12:00:00	AAPL	Stock	13.275	13.2882	13.2364	13.25	25002880.0
2011-08-11 12:30:00	AAPL	Stock	13.2493	13.3604	13.2489	13.3486	44826544.0
2011-08-11 13:00:00	AAPL	Stock	13.3493	13.3521	13.3107	13.3429	36244124.0
2011-08-11 13:30:00	AAPL	Stock	13.3429	13.3707	13.2986	13.3562	37366504.0
2011-08-11 14:00:00	AAPL	Stock	13.3571	13.3925	13.3425	13.3846	34740748.0
2011-08-11 14:30:00	AAPL	Stock	13.3857	13.3875	13.3143	13.3816	37351608.0
2011-08-11 15:00:00	AAPL	Stock	13.3796	13.4089	13.3261	13.35	55686848.0
2011-08-11 15:30:00	AAPL	Stock	13.3511	13.3886	13.2671	13.3457	90322120.0
2011-08-11 16:00:00	AAPL	Stock	13.3232	13.3584	13.2714	13.3275	27174252.0
2011-08-11 16:30:00	AAPL	Stock	13.3304	13.3921	13.325	13.325	5142424.0
2011-08-11 17:00:00	AAPL	Stock	13.325	13.3357	13.3032	13.3214	223804.0
2011-08-11 17:30:00	AAPL	Stock	13.3143	13.32	13.305	13.3171	240492.0
2011-08-11 18:00:00	AAPL	Stock	13.3171	13.3464	13.3021	13.3054	179480.0
2011-08-11 18:30:00	AAPL	Stock	13.3036	13.3086	13.2932	13.3036	137116.0
2011-08-11 19:00:00	AAPL	Stock	13.3071	13.3214	13.3071	13.3186	110600.0
2011-08-11 19:30:00	AAPL	Stock	13.3189	13.3189	13.3036	13.3107	148148.0
2011-08-11 04:00:00	MSFT	Stock	24.7	24.7	24.7	24.7	200.0
2011-08-11 04:30:00	MSFT	Stock	24.7	24.7	24.7	24.7	800.0
2011-08-11 07:00:00	MSFT	Stock	24.61	24.69	24.45	24.45	8900.0
2011-08-11 07:30:00	MSFT	Stock	24.49	24.49	24.21	24.28	8159.0
2011-08-11 08:00:00	MSFT	Stock	24.28	24.46	24.2	24.22	24847.0
2011-08-11 08:30:00	MSFT	Stock	24.25	24.5	24.15	24.45	58777.0
2011-08-11 09:00:00	MSFT	Stock	24.45	24.65	24.45	24.5	232416.0
2011-08-11 09:30:00	MSFT	Stock	24.48	24.77	24.4	24.55	9443373.0
2011-08-11 10:00:00	MSFT	Stock	24.56	24.95	24.5	24.871	6771354.0
2011-08-11 10:30:00	MSFT	Stock	24.87	25.15	24.8	24.9	5794497.0
2011-08-11 11:00:00	MSFT	Stock	24.9	25.0	24.68	24.84	6739062.0
2011-08-11 11:30:00	MSFT	Stock	24.84	24.98	24.82	24.894	3675589.0
2011-08-11 12:00:00	MSFT	Stock	24.9	24.98	24.8	24.86	2915449.0
2011-08-11 12:30:00	MSFT	Stock	24.86	25.17	24.84	25.127	4086234.0
2011-08-11 13:00:00	MSFT	Stock	25.125	25.14	24.962	25.08	4958434.0
2011-08-11 13:30:00	MSFT	Stock	25.09	25.12	24.915	25.1	3388038.0
2011-08-11 14:00:00	MSFT	Stock	25.1	25.22	25.04	25.18	3657210.0
2011-08-11 14:30:00	MSFT	Stock	25.18	25.18	24.945	25.11	3675353.0

> showing 50 of 80,582 rows — these rows as CSV

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