PREVIEW / stock_30min / 2013-09-10

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-10.parquet
  size:    1.6 MB
  rows:    83,854
  symbols: 3,533

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-09-10 04:00:00	AAPL	Stock	18.0714	18.1857	18.0714	18.1786	47096.0
2013-09-10 04:30:00	AAPL	Stock	18.1875	18.1929	18.1714	18.1929	102368.0
2013-09-10 05:00:00	AAPL	Stock	18.1714	18.1714	18.1429	18.1518	143220.0
2013-09-10 05:30:00	AAPL	Stock	18.1429	18.1557	18.1304	18.1304	47600.0
2013-09-10 06:00:00	AAPL	Stock	18.1368	18.1607	18.1368	18.1607	74872.0
2013-09-10 06:30:00	AAPL	Stock	18.1607	18.1732	18.16	18.1607	94696.0
2013-09-10 07:00:00	AAPL	Stock	18.1468	18.1743	18.125	18.1589	430332.0
2013-09-10 07:30:00	AAPL	Stock	18.1536	18.1929	18.145	18.1804	842772.0
2013-09-10 08:00:00	AAPL	Stock	18.1804	18.1943	18.125	18.1571	2353820.0
2013-09-10 08:30:00	AAPL	Stock	18.1589	18.1604	18.0932	18.1214	1755180.0
2013-09-10 09:00:00	AAPL	Stock	18.13	18.13	18.0586	18.0732	2326940.0
2013-09-10 09:30:00	AAPL	Stock	18.0786	18.0857	17.8858	17.9234	75122936.0
2013-09-10 10:00:00	AAPL	Stock	17.9225	17.9811	17.9204	17.9369	22003156.0
2013-09-10 10:30:00	AAPL	Stock	17.9364	18.0036	17.9218	17.9661	20571404.0
2013-09-10 11:00:00	AAPL	Stock	17.9711	17.9907	17.9464	17.9836	12014800.0
2013-09-10 11:30:00	AAPL	Stock	17.9839	18.0214	17.9761	18.0086	15930068.0
2013-09-10 12:00:00	AAPL	Stock	18.0114	18.0161	17.9107	17.945	17347848.0
2013-09-10 12:30:00	AAPL	Stock	17.9454	17.9493	17.815	17.9414	35677628.0
2013-09-10 13:00:00	AAPL	Stock	17.9407	18.1232	17.8618	18.0546	90689368.0
2013-09-10 13:30:00	AAPL	Stock	18.0479	18.0675	17.9025	17.9756	54821872.0
2013-09-10 14:00:00	AAPL	Stock	17.9721	18.0664	17.7393	17.7514	101306408.0
2013-09-10 14:30:00	AAPL	Stock	17.7589	17.7629	17.4821	17.7039	131240060.0
2013-09-10 15:00:00	AAPL	Stock	17.7029	17.8164	17.6993	17.7358	60776268.0
2013-09-10 15:30:00	AAPL	Stock	17.7384	17.7416	17.5671	17.6634	75869696.0
2013-09-10 16:00:00	AAPL	Stock	17.6661	17.9722	17.6254	17.6336	11151140.0
2013-09-10 16:30:00	AAPL	Stock	17.6286	17.6696	17.6114	17.6146	788536.0
2013-09-10 17:00:00	AAPL	Stock	17.6211	17.6661	17.6143	17.6257	1603728.0
2013-09-10 17:30:00	AAPL	Stock	17.6261	17.6475	17.6257	17.6475	420588.0
2013-09-10 18:00:00	AAPL	Stock	17.6493	17.65	17.6332	17.6379	207424.0
2013-09-10 18:30:00	AAPL	Stock	17.6364	17.6482	17.6357	17.6364	264544.0
2013-09-10 19:00:00	AAPL	Stock	17.6368	17.6368	17.6175	17.6211	217056.0
2013-09-10 19:30:00	AAPL	Stock	17.6211	17.6425	17.6211	17.6275	528724.0
2013-09-10 05:00:00	MSFT	Stock	31.83	31.95	31.83	31.95	3141.0
2013-09-10 05:30:00	MSFT	Stock	31.94	31.94	31.94	31.94	300.0
2013-09-10 06:00:00	MSFT	Stock	31.91	31.91	31.91	31.91	471.0
2013-09-10 06:30:00	MSFT	Stock	31.94	32.0	31.94	31.95	7900.0
2013-09-10 07:00:00	MSFT	Stock	31.95	31.95	31.92	31.92	26000.0
2013-09-10 07:30:00	MSFT	Stock	31.93	31.94	31.9	31.9	32914.0
2013-09-10 08:00:00	MSFT	Stock	31.91	31.95	31.8	31.84	35930.0
2013-09-10 08:30:00	MSFT	Stock	31.84	31.88	31.81	31.87	40400.0
2013-09-10 09:00:00	MSFT	Stock	31.87	31.94	31.83	31.89	88207.0
2013-09-10 09:30:00	MSFT	Stock	31.89	32.37	31.79	32.3	7730348.0
2013-09-10 10:00:00	MSFT	Stock	32.3	32.34	32.105	32.17	4525647.0
2013-09-10 10:30:00	MSFT	Stock	32.17	32.32	32.16	32.165	4353247.0
2013-09-10 11:00:00	MSFT	Stock	32.17	32.33	32.15	32.33	3566217.0
2013-09-10 11:30:00	MSFT	Stock	32.33	32.34	32.16	32.225	2752328.0
2013-09-10 12:00:00	MSFT	Stock	32.225	32.27	32.19	32.194	1304871.0
2013-09-10 12:30:00	MSFT	Stock	32.195	32.21	32.17	32.2	1712638.0
2013-09-10 13:00:00	MSFT	Stock	32.195	32.24	32.14	32.24	2466062.0
2013-09-10 13:30:00	MSFT	Stock	32.23	32.35	32.23	32.329	2229900.0

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

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