PREVIEW / stock_30min / 2012-05-02

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-05-02.parquet
  size:    1.4 MB
  rows:    77,594
  symbols: 3,552

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
2012-05-02 04:00:00	AAPL	Stock	20.8214	20.8214	20.7643	20.7839	37800.0
2012-05-02 04:30:00	AAPL	Stock	20.7861	20.7861	20.7611	20.7611	16800.0
2012-05-02 05:00:00	AAPL	Stock	20.7939	20.7939	20.7679	20.7679	8400.0
2012-05-02 05:30:00	AAPL	Stock	20.7571	20.7571	20.7571	20.7571	2800.0
2012-05-02 06:30:00	AAPL	Stock	20.75	20.7704	20.75	20.7704	11200.0
2012-05-02 07:00:00	AAPL	Stock	20.7268	20.83	20.7268	20.8214	89012.0
2012-05-02 07:30:00	AAPL	Stock	20.8161	20.83	20.7768	20.8179	126616.0
2012-05-02 08:00:00	AAPL	Stock	20.8196	20.8214	20.7232	20.7857	1574776.0
2012-05-02 08:30:00	AAPL	Stock	20.7821	20.8214	20.7375	20.7446	1575896.0
2012-05-02 09:00:00	AAPL	Stock	20.7446	20.75	20.67	20.7318	3111220.0
2012-05-02 09:30:00	AAPL	Stock	20.7229	20.9786	20.6736	20.8929	93219924.0
2012-05-02 10:00:00	AAPL	Stock	20.8918	20.9121	20.7143	20.7307	55803748.0
2012-05-02 10:30:00	AAPL	Stock	20.7307	20.875	20.6964	20.8696	41962060.0
2012-05-02 11:00:00	AAPL	Stock	20.8647	20.9261	20.8236	20.905	29006656.0
2012-05-02 11:30:00	AAPL	Stock	20.9054	20.9643	20.8418	20.8604	36374044.0
2012-05-02 12:00:00	AAPL	Stock	20.865	20.935	20.8407	20.9068	18049472.0
2012-05-02 12:30:00	AAPL	Stock	20.9089	20.9107	20.8293	20.8596	13309828.0
2012-05-02 13:00:00	AAPL	Stock	20.8604	20.8768	20.7893	20.7904	13018236.0
2012-05-02 13:30:00	AAPL	Stock	20.7893	20.8957	20.7893	20.8664	16284324.0
2012-05-02 14:00:00	AAPL	Stock	20.8664	20.9325	20.8479	20.9257	19063912.0
2012-05-02 14:30:00	AAPL	Stock	20.9261	20.9295	20.8475	20.8625	17628744.0
2012-05-02 15:00:00	AAPL	Stock	20.865	20.8861	20.8161	20.8711	15674120.0
2012-05-02 15:30:00	AAPL	Stock	20.8693	20.93	20.8332	20.9286	32257288.0
2012-05-02 16:00:00	AAPL	Stock	20.9282	20.9439	20.7904	20.9436	9244284.0
2012-05-02 16:30:00	AAPL	Stock	20.9439	20.9539	20.8715	20.9464	1068620.0
2012-05-02 17:00:00	AAPL	Stock	20.9432	20.9521	20.8781	20.9457	243740.0
2012-05-02 17:30:00	AAPL	Stock	20.9446	20.9446	20.9279	20.9396	240352.0
2012-05-02 18:00:00	AAPL	Stock	20.9418	20.9464	20.94	20.9429	46480.0
2012-05-02 18:30:00	AAPL	Stock	20.9382	20.9457	20.9325	20.9457	51660.0
2012-05-02 19:00:00	AAPL	Stock	20.9429	20.9468	20.9429	20.9432	77896.0
2012-05-02 19:30:00	AAPL	Stock	20.9432	20.9546	20.9432	20.9546	115668.0
2012-05-02 07:00:00	MSFT	Stock	31.9	31.9	31.86	31.86	800.0
2012-05-02 07:30:00	MSFT	Stock	31.95	31.95	31.95	31.95	500.0
2012-05-02 08:00:00	MSFT	Stock	31.91	31.91	31.8	31.87	10358.0
2012-05-02 08:30:00	MSFT	Stock	31.85	31.87	31.81	31.86	2054.0
2012-05-02 09:00:00	MSFT	Stock	31.81	31.85	31.79	31.82	34933.0
2012-05-02 09:30:00	MSFT	Stock	31.82	31.925	31.78	31.79	4257721.0
2012-05-02 10:00:00	MSFT	Stock	31.785	31.85	31.71	31.73	4001332.0
2012-05-02 10:30:00	MSFT	Stock	31.725	31.75	31.64	31.698	3288398.0
2012-05-02 11:00:00	MSFT	Stock	31.7	31.72	31.65	31.69	2031296.0
2012-05-02 11:30:00	MSFT	Stock	31.691	31.77	31.69	31.74	1622727.0
2012-05-02 12:00:00	MSFT	Stock	31.74	31.8	31.69	31.771	1330515.0
2012-05-02 12:30:00	MSFT	Stock	31.78	31.79	31.74	31.75	1506821.0
2012-05-02 13:00:00	MSFT	Stock	31.76	31.78	31.68	31.68	1555996.0
2012-05-02 13:30:00	MSFT	Stock	31.68	31.76	31.68	31.745	1247227.0
2012-05-02 14:00:00	MSFT	Stock	31.74	31.82	31.74	31.81	1777847.0
2012-05-02 14:30:00	MSFT	Stock	31.807	31.81	31.7	31.705	1712087.0
2012-05-02 15:00:00	MSFT	Stock	31.705	31.72	31.66	31.71	3875129.0
2012-05-02 15:30:00	MSFT	Stock	31.71	31.81	31.69	31.8	5788701.0
2012-05-02 16:00:00	MSFT	Stock	31.79	32.01	31.725	31.8	2911021.0

> showing 50 of 77,594 rows — these rows as CSV

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