PREVIEW / stock_30min / 2011-07-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-25.parquet
  size:    1.4 MB
  rows:    74,924
  symbols: 3,539

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-07-25 05:00:00	AAPL	Stock	13.9536	13.9736	13.9464	13.9464	14000.0
2011-07-25 05:30:00	AAPL	Stock	13.9743	13.9743	13.9743	13.9743	14000.0
2011-07-25 07:00:00	AAPL	Stock	13.9411	13.9804	13.9311	13.9768	426048.0
2011-07-25 07:30:00	AAPL	Stock	13.9804	13.9932	13.9625	13.9661	267820.0
2011-07-25 08:00:00	AAPL	Stock	13.9686	13.9839	13.935	13.9839	1363348.0
2011-07-25 08:30:00	AAPL	Stock	13.9821	13.9846	13.9429	13.9482	1241184.0
2011-07-25 09:00:00	AAPL	Stock	13.9486	13.9771	13.9325	13.9407	2389800.0
2011-07-25 09:30:00	AAPL	Stock	13.935	14.0711	13.915	14.0539	90168904.0
2011-07-25 10:00:00	AAPL	Stock	14.0539	14.0939	14.0243	14.0771	41210008.0
2011-07-25 10:30:00	AAPL	Stock	14.0779	14.1093	14.0507	14.0743	34281576.0
2011-07-25 11:00:00	AAPL	Stock	14.0729	14.1782	14.0711	14.1768	38274040.0
2011-07-25 11:30:00	AAPL	Stock	14.1768	14.2393	14.1714	14.2293	51897832.0
2011-07-25 12:00:00	AAPL	Stock	14.2257	14.2782	14.219	14.2693	48410404.0
2011-07-25 12:30:00	AAPL	Stock	14.2683	14.2857	14.2614	14.2757	41536544.0
2011-07-25 13:00:00	AAPL	Stock	14.2757	14.2782	14.2396	14.2543	30234372.0
2011-07-25 13:30:00	AAPL	Stock	14.2539	14.2596	14.2214	14.2429	22089956.0
2011-07-25 14:00:00	AAPL	Stock	14.2432	14.2857	14.2393	14.2779	33580904.0
2011-07-25 14:30:00	AAPL	Stock	14.278	14.2821	14.2425	14.2614	29366512.0
2011-07-25 15:00:00	AAPL	Stock	14.2625	14.2664	14.1786	14.2336	50988140.0
2011-07-25 15:30:00	AAPL	Stock	14.2332	14.2668	14.2104	14.229	52623620.0
2011-07-25 16:00:00	AAPL	Stock	14.229	14.2608	14.0464	14.225	12260220.0
2011-07-25 16:30:00	AAPL	Stock	14.2204	14.2561	14.2196	14.2354	466116.0
2011-07-25 17:00:00	AAPL	Stock	14.235	14.2632	14.235	14.2518	659428.0
2011-07-25 17:30:00	AAPL	Stock	14.2571	14.2621	14.2525	14.2536	287644.0
2011-07-25 18:00:00	AAPL	Stock	14.2525	14.2571	14.2321	14.25	306292.0
2011-07-25 18:30:00	AAPL	Stock	14.2414	14.25	14.2321	14.2321	183624.0
2011-07-25 19:00:00	AAPL	Stock	14.2336	14.2389	14.225	14.2332	172340.0
2011-07-25 19:30:00	AAPL	Stock	14.2357	14.2454	14.2325	14.2396	245560.0
2011-07-25 06:30:00	MSFT	Stock	27.24	27.24	27.24	27.24	1000.0
2011-07-25 07:00:00	MSFT	Stock	27.2	27.31	27.15	27.31	1400.0
2011-07-25 07:30:00	MSFT	Stock	27.3	27.3	27.24	27.26	3600.0
2011-07-25 08:00:00	MSFT	Stock	27.3	27.33	27.15	27.23	29285.0
2011-07-25 08:30:00	MSFT	Stock	27.25	27.25	27.15	27.2	29500.0
2011-07-25 09:00:00	MSFT	Stock	27.19	27.28	27.19	27.26	31040.0
2011-07-25 09:30:00	MSFT	Stock	27.26	27.54	27.19	27.52	7486715.0
2011-07-25 10:00:00	MSFT	Stock	27.52	27.83	27.52	27.79	10152948.0
2011-07-25 10:30:00	MSFT	Stock	27.79	27.82	27.72	27.788	7723183.0
2011-07-25 11:00:00	MSFT	Stock	27.785	27.91	27.69	27.89	13202793.0
2011-07-25 11:30:00	MSFT	Stock	27.898	27.91	27.81	27.855	8702237.0
2011-07-25 12:00:00	MSFT	Stock	27.855	27.95	27.84	27.945	4476349.0
2011-07-25 12:30:00	MSFT	Stock	27.949	28.03	27.93	27.99	8840016.0
2011-07-25 13:00:00	MSFT	Stock	27.99	28.09	27.97	28.0	4399885.0
2011-07-25 13:30:00	MSFT	Stock	28.0	28.02	27.92	27.93	2735615.0
2011-07-25 14:00:00	MSFT	Stock	27.93	27.97	27.86	27.935	5756014.0
2011-07-25 14:30:00	MSFT	Stock	27.94	27.94	27.78	27.795	4376745.0
2011-07-25 15:00:00	MSFT	Stock	27.795	27.85	27.72	27.795	8302890.0
2011-07-25 15:30:00	MSFT	Stock	27.8	27.92	27.74	27.91	14423008.0
2011-07-25 16:00:00	MSFT	Stock	27.905	27.95	27.525	27.89	2331067.0
2011-07-25 16:30:00	MSFT	Stock	27.91	27.91	27.773	27.87	2180038.0
2011-07-25 17:00:00	MSFT	Stock	27.84	27.84	27.83	27.83	775.0

> showing 50 of 74,924 rows — these rows as CSV

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