PREVIEW / stock_30min / 2014-12-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-01.parquet
  size:    1.6 MB
  rows:    85,607
  symbols: 3,561

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-12-01 04:00:00	AAPL	Stock	29.625	29.625	29.6	29.6225	10000.0
2014-12-01 04:30:00	AAPL	Stock	29.6	29.6575	29.6	29.6575	10000.0
2014-12-01 05:00:00	AAPL	Stock	29.67	29.67	29.65	29.65	8000.0
2014-12-01 05:30:00	AAPL	Stock	29.635	29.635	29.635	29.635	400.0
2014-12-01 06:30:00	AAPL	Stock	29.6375	29.6375	29.6375	29.6375	2000.0
2014-12-01 07:00:00	AAPL	Stock	29.6625	29.7625	29.6625	29.7	50048.0
2014-12-01 07:30:00	AAPL	Stock	29.68	29.6875	29.645	29.645	88680.0
2014-12-01 08:00:00	AAPL	Stock	29.6575	29.74	29.605	29.67	469568.0
2014-12-01 08:30:00	AAPL	Stock	29.67	29.7325	29.6275	29.64	363396.0
2014-12-01 09:00:00	AAPL	Stock	29.6475	29.73	29.635	29.705	244012.0
2014-12-01 09:30:00	AAPL	Stock	29.7025	29.8125	27.8175	28.955	92730808.0
2014-12-01 10:00:00	AAPL	Stock	28.9575	29.125	28.605	28.9912	49502620.0
2014-12-01 10:30:00	AAPL	Stock	28.9875	29.0725	28.775	28.8205	23574848.0
2014-12-01 11:00:00	AAPL	Stock	28.825	29.0575	28.8175	28.9938	17946696.0
2014-12-01 11:30:00	AAPL	Stock	28.995	29.0475	28.8925	28.8925	13256372.0
2014-12-01 12:00:00	AAPL	Stock	28.895	28.94	28.83	28.9098	10348384.0
2014-12-01 12:30:00	AAPL	Stock	28.9075	28.955	28.855	28.9225	8876636.0
2014-12-01 13:00:00	AAPL	Stock	28.9225	29.075	28.9225	29.0575	12000804.0
2014-12-01 13:30:00	AAPL	Stock	29.0575	29.1175	29.0175	29.045	9262176.0
2014-12-01 14:00:00	AAPL	Stock	29.045	29.0475	28.775	28.7988	12994032.0
2014-12-01 14:30:00	AAPL	Stock	28.7978	28.8275	28.6725	28.7925	15683996.0
2014-12-01 15:00:00	AAPL	Stock	28.7975	28.85	28.75	28.7688	10812100.0
2014-12-01 15:30:00	AAPL	Stock	28.7675	28.7925	28.6125	28.7675	27479420.0
2014-12-01 16:00:00	AAPL	Stock	28.7675	28.9332	28.7232	28.765	8908892.0
2014-12-01 16:30:00	AAPL	Stock	28.75	28.8632	28.7375	28.7575	603808.0
2014-12-01 17:00:00	AAPL	Stock	28.7575	28.7725	28.745	28.7475	200392.0
2014-12-01 17:30:00	AAPL	Stock	28.7475	28.7675	28.7325	28.7575	65392.0
2014-12-01 18:00:00	AAPL	Stock	28.76	28.7675	28.745	28.75	61968.0
2014-12-01 18:30:00	AAPL	Stock	28.7425	28.7675	28.7375	28.74	411096.0
2014-12-01 19:00:00	AAPL	Stock	28.7375	28.755	28.7325	28.7525	21140.0
2014-12-01 19:30:00	AAPL	Stock	28.7575	28.7725	28.745	28.75	43580.0
2014-12-01 04:00:00	MSFT	Stock	47.41	47.41	46.92	46.92	420.0
2014-12-01 04:30:00	MSFT	Stock	47.7	47.7	47.7	47.7	300.0
2014-12-01 07:00:00	MSFT	Stock	47.75	47.75	47.7	47.7	1300.0
2014-12-01 07:30:00	MSFT	Stock	47.7	47.71	47.7	47.71	800.0
2014-12-01 08:00:00	MSFT	Stock	47.76	47.76	47.7	47.7	2450.0
2014-12-01 09:00:00	MSFT	Stock	47.73	47.79	47.73	47.76	2795.0
2014-12-01 09:30:00	MSFT	Stock	47.79	48.27	47.71	48.0	4097931.0
2014-12-01 10:00:00	MSFT	Stock	48.0	48.5	47.91	48.36	2480623.0
2014-12-01 10:30:00	MSFT	Stock	48.36	48.375	48.22	48.33	1749434.0
2014-12-01 11:00:00	MSFT	Stock	48.33	48.385	48.23	48.38	1684835.0
2014-12-01 11:30:00	MSFT	Stock	48.38	48.43	48.35	48.39	843342.0
2014-12-01 12:00:00	MSFT	Stock	48.38	48.65	48.375	48.61	1522283.0
2014-12-01 12:30:00	MSFT	Stock	48.61	48.72	48.57	48.71	1248000.0
2014-12-01 13:00:00	MSFT	Stock	48.71	48.78	48.66	48.735	1224482.0
2014-12-01 13:30:00	MSFT	Stock	48.735	48.77	48.57	48.605	1109613.0
2014-12-01 14:00:00	MSFT	Stock	48.605	48.62	48.465	48.495	1050853.0
2014-12-01 14:30:00	MSFT	Stock	48.493	48.63	48.47	48.62	1174994.0
2014-12-01 15:00:00	MSFT	Stock	48.62	48.71	48.59	48.69	1696694.0
2014-12-01 15:30:00	MSFT	Stock	48.69	48.71	48.62	48.64	4404218.0

> showing 50 of 85,607 rows — these rows as CSV

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