PREVIEW / stock_30min / 2014-05-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-19.parquet
  size:    1.5 MB
  rows:    80,606
  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
2014-05-19 04:00:00	AAPL	Stock	21.3036	21.3036	21.2536	21.2536	112000.0
2014-05-19 04:30:00	AAPL	Stock	21.2579	21.2679	21.25	21.25	11200.0
2014-05-19 05:00:00	AAPL	Stock	21.2539	21.2539	21.2539	21.2539	2800.0
2014-05-19 05:30:00	AAPL	Stock	21.2579	21.2657	21.2489	21.2657	44800.0
2014-05-19 06:00:00	AAPL	Stock	21.2657	21.2657	21.2589	21.2589	15904.0
2014-05-19 06:30:00	AAPL	Stock	21.2857	21.3	21.2857	21.2864	63196.0
2014-05-19 07:00:00	AAPL	Stock	21.2864	21.3125	21.2821	21.3036	154280.0
2014-05-19 07:30:00	AAPL	Stock	21.3036	21.3464	21.3036	21.3214	199752.0
2014-05-19 08:00:00	AAPL	Stock	21.3293	21.3304	21.2889	21.3268	396172.0
2014-05-19 08:30:00	AAPL	Stock	21.3286	21.3382	21.3089	21.3257	477680.0
2014-05-19 09:00:00	AAPL	Stock	21.3264	21.3661	21.3264	21.3411	1333416.0
2014-05-19 09:30:00	AAPL	Stock	21.3518	21.63	21.3332	21.5704	75969320.0
2014-05-19 10:00:00	AAPL	Stock	21.5704	21.6411	21.5554	21.5946	29907472.0
2014-05-19 10:30:00	AAPL	Stock	21.5943	21.6307	21.5732	21.6014	15456084.0
2014-05-19 11:00:00	AAPL	Stock	21.6021	21.6675	21.5975	21.6461	19719980.0
2014-05-19 11:30:00	AAPL	Stock	21.6479	21.6811	21.6407	21.6743	13624100.0
2014-05-19 12:00:00	AAPL	Stock	21.6727	21.6904	21.6446	21.6715	10817464.0
2014-05-19 12:30:00	AAPL	Stock	21.6714	21.6753	21.6332	21.6596	9103892.0
2014-05-19 13:00:00	AAPL	Stock	21.6618	21.6679	21.6179	21.6446	8174684.0
2014-05-19 13:30:00	AAPL	Stock	21.645	21.665	21.6304	21.6525	6474412.0
2014-05-19 14:00:00	AAPL	Stock	21.6521	21.6632	21.6379	21.6606	6735960.0
2014-05-19 14:30:00	AAPL	Stock	21.6589	21.6604	21.6111	21.6236	8478204.0
2014-05-19 15:00:00	AAPL	Stock	21.6239	21.628	21.5371	21.59	18346552.0
2014-05-19 15:30:00	AAPL	Stock	21.5904	21.6254	21.5846	21.5857	22902656.0
2014-05-19 16:00:00	AAPL	Stock	21.5925	21.6116	21.586	21.5925	10269952.0
2014-05-19 16:30:00	AAPL	Stock	21.5925	21.6144	21.5893	21.5929	401632.0
2014-05-19 17:00:00	AAPL	Stock	21.5911	21.5929	21.5857	21.5929	154504.0
2014-05-19 17:30:00	AAPL	Stock	21.5925	21.5925	21.5732	21.5768	1982736.0
2014-05-19 18:00:00	AAPL	Stock	21.5732	21.5925	21.5732	21.5925	51688.0
2014-05-19 18:30:00	AAPL	Stock	21.5793	21.5804	21.5782	21.5786	91616.0
2014-05-19 19:00:00	AAPL	Stock	21.5796	21.5804	21.5768	21.5768	67396.0
2014-05-19 19:30:00	AAPL	Stock	21.5746	21.5779	21.5714	21.5714	156436.0
2014-05-19 07:00:00	MSFT	Stock	39.81	39.81	39.81	39.81	100.0
2014-05-19 08:00:00	MSFT	Stock	39.88	39.88	39.81	39.81	500.0
2014-05-19 08:30:00	MSFT	Stock	39.74	39.74	39.74	39.74	500.0
2014-05-19 09:00:00	MSFT	Stock	39.79	39.8	39.65	39.65	8830.0
2014-05-19 09:30:00	MSFT	Stock	39.61	39.75	39.46	39.67	3635513.0
2014-05-19 10:00:00	MSFT	Stock	39.66	39.71	39.52	39.605	1779718.0
2014-05-19 10:30:00	MSFT	Stock	39.61	39.62	39.55	39.585	1204798.0
2014-05-19 11:00:00	MSFT	Stock	39.585	39.665	39.56	39.64	1523238.0
2014-05-19 11:30:00	MSFT	Stock	39.64	39.68	39.62	39.66	803940.0
2014-05-19 12:00:00	MSFT	Stock	39.66	39.67	39.605	39.65	590284.0
2014-05-19 12:30:00	MSFT	Stock	39.65	39.66	39.63	39.65	742387.0
2014-05-19 13:00:00	MSFT	Stock	39.645	39.67	39.6	39.64	635831.0
2014-05-19 13:30:00	MSFT	Stock	39.635	39.73	39.6	39.72	1167502.0
2014-05-19 14:00:00	MSFT	Stock	39.73	39.82	39.72	39.759	1011089.0
2014-05-19 14:30:00	MSFT	Stock	39.755	39.77	39.73	39.736	648689.0
2014-05-19 15:00:00	MSFT	Stock	39.74	39.78	39.7	39.73	1027869.0
2014-05-19 15:30:00	MSFT	Stock	39.725	39.81	39.725	39.74	2312664.0
2014-05-19 16:00:00	MSFT	Stock	39.75	39.796	39.608	39.75	4017984.0

> showing 50 of 80,606 rows — these rows as CSV

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