PREVIEW / stock_30min / 2013-08-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-19.parquet
  size:    1.6 MB
  rows:    83,906
  symbols: 3,547

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
2013-08-19 04:00:00	AAPL	Stock	18.0696	18.0696	18.0393	18.0604	47740.0
2013-08-19 04:30:00	AAPL	Stock	18.0464	18.0464	18.0214	18.0214	19600.0
2013-08-19 05:00:00	AAPL	Stock	18.0196	18.0232	18.0189	18.0204	23716.0
2013-08-19 05:30:00	AAPL	Stock	18.0511	18.0511	18.0275	18.0275	30856.0
2013-08-19 06:00:00	AAPL	Stock	18.0357	18.0357	18.035	18.035	23604.0
2013-08-19 06:30:00	AAPL	Stock	18.0268	18.0518	18.0089	18.0232	250600.0
2013-08-19 07:00:00	AAPL	Stock	18.0239	18.0464	18.0089	18.0161	224924.0
2013-08-19 07:30:00	AAPL	Stock	18.0143	18.0393	18.0004	18.0179	210756.0
2013-08-19 08:00:00	AAPL	Stock	18.0039	18.0482	17.9404	18.0	1401484.0
2013-08-19 08:30:00	AAPL	Stock	18.0061	18.0318	17.9832	18.0286	1169924.0
2013-08-19 09:00:00	AAPL	Stock	18.0254	18.0521	18.0107	18.0214	1720936.0
2013-08-19 09:30:00	AAPL	Stock	18.0204	18.2039	18.0	18.1807	93847656.0
2013-08-19 10:00:00	AAPL	Stock	18.1818	18.2921	18.1607	18.2536	63051100.0
2013-08-19 10:30:00	AAPL	Stock	18.2536	18.3479	18.2325	18.3189	37952264.0
2013-08-19 11:00:00	AAPL	Stock	18.3189	18.3443	18.2886	18.3311	30442020.0
2013-08-19 11:30:00	AAPL	Stock	18.3307	18.3307	18.2575	18.2946	28467516.0
2013-08-19 12:00:00	AAPL	Stock	18.295	18.3036	18.2446	18.2964	19878012.0
2013-08-19 12:30:00	AAPL	Stock	18.2964	18.3257	18.2543	18.3089	17781736.0
2013-08-19 13:00:00	AAPL	Stock	18.3068	18.3411	18.3036	18.3357	15430660.0
2013-08-19 13:30:00	AAPL	Stock	18.3364	18.3379	18.2679	18.2929	18303292.0
2013-08-19 14:00:00	AAPL	Stock	18.2911	18.315	18.2304	18.2519	24699780.0
2013-08-19 14:30:00	AAPL	Stock	18.2518	18.3054	18.1857	18.2761	37207828.0
2013-08-19 15:00:00	AAPL	Stock	18.2764	18.2804	18.1875	18.2	30046912.0
2013-08-19 15:30:00	AAPL	Stock	18.2	18.226	18.1329	18.1382	40600784.0
2013-08-19 16:00:00	AAPL	Stock	18.1382	18.2464	18.1271	18.1389	41233220.0
2013-08-19 16:30:00	AAPL	Stock	18.1364	18.2027	18.1286	18.1407	584136.0
2013-08-19 17:00:00	AAPL	Stock	18.1393	18.1929	18.1336	18.18	931784.0
2013-08-19 17:30:00	AAPL	Stock	18.18	18.18	18.1689	18.1768	276360.0
2013-08-19 18:00:00	AAPL	Stock	18.1768	18.1814	18.1696	18.175	217168.0
2013-08-19 18:30:00	AAPL	Stock	18.1689	18.1757	18.1621	18.1621	82964.0
2013-08-19 19:00:00	AAPL	Stock	18.1643	18.1771	18.1643	18.1646	104776.0
2013-08-19 19:30:00	AAPL	Stock	18.1714	18.1896	18.1707	18.175	198828.0
2013-08-19 07:00:00	MSFT	Stock	31.81	31.81	31.81	31.81	100.0
2013-08-19 07:30:00	MSFT	Stock	31.81	31.83	31.75	31.8	800.0
2013-08-19 08:00:00	MSFT	Stock	31.74	31.74	31.74	31.74	200.0
2013-08-19 09:00:00	MSFT	Stock	31.77	31.78	31.72	31.75	9675.0
2013-08-19 09:30:00	MSFT	Stock	31.77	31.77	31.51	31.7	4746069.0
2013-08-19 10:00:00	MSFT	Stock	31.7	31.97	31.695	31.76	3057642.0
2013-08-19 10:30:00	MSFT	Stock	31.756	31.84	31.738	31.8	1566344.0
2013-08-19 11:00:00	MSFT	Stock	31.8	31.83	31.735	31.76	1716967.0
2013-08-19 11:30:00	MSFT	Stock	31.755	31.77	31.66	31.67	1426656.0
2013-08-19 12:00:00	MSFT	Stock	31.675	31.755	31.655	31.67	1019125.0
2013-08-19 12:30:00	MSFT	Stock	31.675	31.79	31.64	31.75	839286.0
2013-08-19 13:00:00	MSFT	Stock	31.75	31.76	31.69	31.72	756980.0
2013-08-19 13:30:00	MSFT	Stock	31.73	31.75	31.68	31.74	883225.0
2013-08-19 14:00:00	MSFT	Stock	31.74	31.75	31.66	31.68	1085647.0
2013-08-19 14:30:00	MSFT	Stock	31.685	31.69	31.55	31.58	1519472.0
2013-08-19 15:00:00	MSFT	Stock	31.585	31.59	31.5	31.5	1867609.0
2013-08-19 15:30:00	MSFT	Stock	31.51	31.56	31.38	31.4	4690865.0
2013-08-19 16:00:00	MSFT	Stock	31.41	31.685	31.3	31.41	1370059.0

> showing 50 of 83,906 rows — these rows as CSV

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