PREVIEW / stock_30min / 2011-11-09

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-09.parquet
  size:    1.4 MB
  rows:    76,921
  symbols: 3,500

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-09 04:00:00	AAPL	Stock	14.4643	14.4643	14.3925	14.3925	134400.0
2011-11-09 04:30:00	AAPL	Stock	14.3929	14.3975	14.3571	14.3571	33460.0
2011-11-09 05:00:00	AAPL	Stock	14.3804	14.3804	14.25	14.2857	122164.0
2011-11-09 05:30:00	AAPL	Stock	14.2875	14.2875	14.2143	14.2143	58856.0
2011-11-09 06:00:00	AAPL	Stock	14.25	14.25	14.25	14.25	5600.0
2011-11-09 06:30:00	AAPL	Stock	14.2293	14.25	14.2254	14.2343	99400.0
2011-11-09 07:00:00	AAPL	Stock	14.2486	14.3132	14.2143	14.2214	1120336.0
2011-11-09 07:30:00	AAPL	Stock	14.2232	14.2243	14.1864	14.2107	2680524.0
2011-11-09 08:00:00	AAPL	Stock	14.2139	14.3014	14.2004	14.2143	5734204.0
2011-11-09 08:30:00	AAPL	Stock	14.2161	14.2607	14.2036	14.2411	3319176.0
2011-11-09 09:00:00	AAPL	Stock	14.2439	14.2536	14.15	14.1721	5938268.0
2011-11-09 09:30:00	AAPL	Stock	14.1746	14.2318	14.1607	14.1929	110811680.0
2011-11-09 10:00:00	AAPL	Stock	14.1929	14.2125	14.1654	14.2021	48586944.0
2011-11-09 10:30:00	AAPL	Stock	14.2018	14.2596	14.1671	14.2418	46888240.0
2011-11-09 11:00:00	AAPL	Stock	14.2414	14.3175	14.2361	14.2771	34932436.0
2011-11-09 11:30:00	AAPL	Stock	14.2771	14.2918	14.2582	14.2679	19770632.0
2011-11-09 12:00:00	AAPL	Stock	14.2679	14.2736	14.2307	14.2364	15541624.0
2011-11-09 12:30:00	AAPL	Stock	14.2364	14.2793	14.2321	14.2636	13257076.0
2011-11-09 13:00:00	AAPL	Stock	14.2636	14.2764	14.2143	14.2239	13200880.0
2011-11-09 13:30:00	AAPL	Stock	14.225	14.2257	14.1696	14.1796	24443944.0
2011-11-09 14:00:00	AAPL	Stock	14.1796	14.1832	14.1075	14.1164	55282332.0
2011-11-09 14:30:00	AAPL	Stock	14.1179	14.1589	14.1107	14.1196	33365108.0
2011-11-09 15:00:00	AAPL	Stock	14.1193	14.15	14.1089	14.1196	35567308.0
2011-11-09 15:30:00	AAPL	Stock	14.1207	14.1389	14.0796	14.1182	64252972.0
2011-11-09 16:00:00	AAPL	Stock	14.1182	14.2343	14.1089	14.1214	17618496.0
2011-11-09 16:30:00	AAPL	Stock	14.1214	14.1243	14.0931	14.1179	2247196.0
2011-11-09 17:00:00	AAPL	Stock	14.1204	14.1214	14.1143	14.1214	111216.0
2011-11-09 17:30:00	AAPL	Stock	14.1161	14.1214	14.1079	14.1107	138796.0
2011-11-09 18:00:00	AAPL	Stock	14.1139	14.1175	14.0982	14.0989	244300.0
2011-11-09 18:30:00	AAPL	Stock	14.0986	14.0986	14.0357	14.0714	491540.0
2011-11-09 19:00:00	AAPL	Stock	14.0714	14.0714	14.0571	14.0714	49840.0
2011-11-09 19:30:00	AAPL	Stock	14.0661	14.0846	14.0571	14.0725	196840.0
2011-11-09 04:00:00	MSFT	Stock	26.95	26.95	26.95	26.95	300.0
2011-11-09 05:00:00	MSFT	Stock	26.66	26.66	26.65	26.65	12100.0
2011-11-09 05:30:00	MSFT	Stock	26.57	26.57	26.57	26.57	1000.0
2011-11-09 06:30:00	MSFT	Stock	26.5	26.5	26.5	26.5	500.0
2011-11-09 07:00:00	MSFT	Stock	26.6	26.74	26.6	26.6	9400.0
2011-11-09 07:30:00	MSFT	Stock	26.59	26.65	26.58	26.59	12776.0
2011-11-09 08:00:00	MSFT	Stock	26.65	26.75	26.6	26.65	43619.0
2011-11-09 08:30:00	MSFT	Stock	26.65	26.69	26.6	26.68	35396.0
2011-11-09 09:00:00	MSFT	Stock	26.68	26.69	26.6	26.6	35279.0
2011-11-09 09:30:00	MSFT	Stock	26.6	26.7	26.44	26.507	5285365.0
2011-11-09 10:00:00	MSFT	Stock	26.5	26.62	26.46	26.6	5069878.0
2011-11-09 10:30:00	MSFT	Stock	26.6	26.63	26.45	26.57	3580524.0
2011-11-09 11:00:00	MSFT	Stock	26.57	26.68	26.52	26.678	2837582.0
2011-11-09 11:30:00	MSFT	Stock	26.677	26.7	26.6	26.69	1892890.0
2011-11-09 12:00:00	MSFT	Stock	26.685	26.7	26.61	26.63	2103213.0
2011-11-09 12:30:00	MSFT	Stock	26.62	26.75	26.62	26.74	1858281.0
2011-11-09 13:00:00	MSFT	Stock	26.74	26.75	26.51	26.52	2715479.0
2011-11-09 13:30:00	MSFT	Stock	26.52	26.56	26.36	26.385	3081698.0

> showing 50 of 76,921 rows — these rows as CSV

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