PREVIEW / stock_30min / 2013-05-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-30.parquet
  size:    1.5 MB
  rows:    78,734
  symbols: 3,508

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-05-30 04:00:00	AAPL	Stock	15.875	15.875	15.875	15.875	3920.0
2013-05-30 05:00:00	AAPL	Stock	15.8929	15.8929	15.8929	15.8929	2800.0
2013-05-30 06:30:00	AAPL	Stock	15.8839	15.91	15.8839	15.91	6272.0
2013-05-30 07:00:00	AAPL	Stock	15.9196	16.0354	15.9196	15.9893	208320.0
2013-05-30 07:30:00	AAPL	Stock	15.9861	16.0	15.9286	15.9304	271516.0
2013-05-30 08:00:00	AAPL	Stock	15.9379	16.0004	15.9107	15.9429	316092.0
2013-05-30 08:30:00	AAPL	Stock	15.9464	15.9786	15.9393	15.9511	735840.0
2013-05-30 09:00:00	AAPL	Stock	15.9471	15.9493	15.88	15.9161	1462160.0
2013-05-30 09:30:00	AAPL	Stock	15.9057	15.9946	15.8754	15.9917	50277332.0
2013-05-30 10:00:00	AAPL	Stock	15.9886	15.9993	15.9236	15.9432	33595492.0
2013-05-30 10:30:00	AAPL	Stock	15.9482	15.9693	15.9036	15.9643	19363288.0
2013-05-30 11:00:00	AAPL	Stock	15.9682	15.9871	15.9529	15.9757	18721192.0
2013-05-30 11:30:00	AAPL	Stock	15.9745	16.0621	15.9668	16.054	24617320.0
2013-05-30 12:00:00	AAPL	Stock	16.0571	16.0632	16.0186	16.0321	13206844.0
2013-05-30 12:30:00	AAPL	Stock	16.0304	16.0875	16.0157	16.0837	19023760.0
2013-05-30 13:00:00	AAPL	Stock	16.0846	16.1239	16.0696	16.1192	21550032.0
2013-05-30 13:30:00	AAPL	Stock	16.12	16.1646	16.1182	16.153	26451040.0
2013-05-30 14:00:00	AAPL	Stock	16.1554	16.1675	16.1164	16.1536	19202596.0
2013-05-30 14:30:00	AAPL	Stock	16.1536	16.1845	16.1182	16.1806	19335596.0
2013-05-30 15:00:00	AAPL	Stock	16.1764	16.2321	16.1586	16.1889	28832692.0
2013-05-30 15:30:00	AAPL	Stock	16.1875	16.2059	16.125	16.1282	35940380.0
2013-05-30 16:00:00	AAPL	Stock	16.1282	16.1357	16.0576	16.1282	16108148.0
2013-05-30 16:30:00	AAPL	Stock	16.1193	16.1878	16.1111	16.1179	252196.0
2013-05-30 17:00:00	AAPL	Stock	16.1225	16.1232	15.953	16.1211	102676.0
2013-05-30 17:30:00	AAPL	Stock	16.1239	16.1304	16.1193	16.1286	91420.0
2013-05-30 18:00:00	AAPL	Stock	16.1279	16.1279	16.1196	16.1268	47600.0
2013-05-30 18:30:00	AAPL	Stock	16.1268	16.1268	16.1214	16.1214	5600.0
2013-05-30 19:00:00	AAPL	Stock	16.125	16.125	16.1136	16.1164	37856.0
2013-05-30 19:30:00	AAPL	Stock	16.1264	16.1357	16.1246	16.125	105448.0
2013-05-30 07:00:00	MSFT	Stock	35.16	35.16	35.16	35.16	300.0
2013-05-30 07:30:00	MSFT	Stock	34.99	35.05	34.99	35.0	7250.0
2013-05-30 08:00:00	MSFT	Stock	34.99	35.1	34.9	34.94	13242.0
2013-05-30 08:30:00	MSFT	Stock	34.9	35.0	34.89	34.9	2800.0
2013-05-30 09:00:00	MSFT	Stock	34.89	34.99	34.89	34.89	3000.0
2013-05-30 09:30:00	MSFT	Stock	34.85	35.19	34.813	35.085	5226099.0
2013-05-30 10:00:00	MSFT	Stock	35.07	35.11	34.96	34.995	5992874.0
2013-05-30 10:30:00	MSFT	Stock	34.995	35.08	34.98	35.075	3044256.0
2013-05-30 11:00:00	MSFT	Stock	35.075	35.09	35.02	35.05	2259574.0
2013-05-30 11:30:00	MSFT	Stock	35.045	35.06	34.98	34.999	2165650.0
2013-05-30 12:00:00	MSFT	Stock	35.0	35.02	34.98	35.0	1999684.0
2013-05-30 12:30:00	MSFT	Stock	35.0	35.01	34.92	34.932	1556075.0
2013-05-30 13:00:00	MSFT	Stock	34.94	34.98	34.88	34.98	2427078.0
2013-05-30 13:30:00	MSFT	Stock	34.975	35.11	34.972	35.1	2135834.0
2013-05-30 14:00:00	MSFT	Stock	35.09	35.14	35.08	35.13	1309236.0
2013-05-30 14:30:00	MSFT	Stock	35.125	35.21	35.11	35.196	3097291.0
2013-05-30 15:00:00	MSFT	Stock	35.194	35.25	35.18	35.21	3256322.0
2013-05-30 15:30:00	MSFT	Stock	35.21	35.23	35.02	35.03	6842116.0
2013-05-30 16:00:00	MSFT	Stock	35.03	35.2	34.89	35.04	6000522.0
2013-05-30 16:30:00	MSFT	Stock	35.02	35.02	35.02	35.02	200.0
2013-05-30 17:00:00	MSFT	Stock	35.033	35.11	35.02	35.02	23600.0

> showing 50 of 78,734 rows — these rows as CSV

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