PREVIEW / stock_30min / 2015-03-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-20.parquet
  size:    1.7 MB
  rows:    86,417
  symbols: 3,528

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
2015-03-20 04:00:00	AAPL	Stock	31.92	32.045	31.92	31.9625	18000.0
2015-03-20 04:30:00	AAPL	Stock	31.9975	31.9975	31.9975	31.9975	680.0
2015-03-20 05:00:00	AAPL	Stock	31.9975	32.025	31.9975	32.0125	6640.0
2015-03-20 05:30:00	AAPL	Stock	32.0225	32.05	32.0	32.045	65560.0
2015-03-20 06:00:00	AAPL	Stock	32.0	32.0	31.955	31.9775	38400.0
2015-03-20 06:30:00	AAPL	Stock	31.9775	32.0	31.975	31.9875	14532.0
2015-03-20 07:00:00	AAPL	Stock	31.985	32.0125	31.975	32.0	55264.0
2015-03-20 07:30:00	AAPL	Stock	32.0	32.0375	31.99	32.025	86376.0
2015-03-20 08:00:00	AAPL	Stock	32.0025	32.0375	31.875	32.0225	302664.0
2015-03-20 08:30:00	AAPL	Stock	32.03	32.0625	32.0225	32.055	294316.0
2015-03-20 09:00:00	AAPL	Stock	32.0575	32.0825	31.975	32.0725	1037648.0
2015-03-20 09:30:00	AAPL	Stock	32.0725	32.1	31.9125	31.9825	51327200.0
2015-03-20 10:00:00	AAPL	Stock	31.985	32.0025	31.9275	31.96	10165824.0
2015-03-20 10:30:00	AAPL	Stock	31.96	32.005	31.93	31.9375	9922856.0
2015-03-20 11:00:00	AAPL	Stock	31.9375	32.0	31.9375	31.9825	6823220.0
2015-03-20 11:30:00	AAPL	Stock	31.9825	32.0	31.89	31.9025	6890532.0
2015-03-20 12:00:00	AAPL	Stock	31.9	31.96	31.8962	31.9275	5909796.0
2015-03-20 12:30:00	AAPL	Stock	31.925	31.96	31.915	31.935	5713544.0
2015-03-20 13:00:00	AAPL	Stock	31.9375	32.0125	31.9375	31.995	7007904.0
2015-03-20 13:30:00	AAPL	Stock	31.995	32.0325	31.9775	31.985	6225736.0
2015-03-20 14:00:00	AAPL	Stock	31.9862	32.0075	31.95	31.975	5517084.0
2015-03-20 14:30:00	AAPL	Stock	31.975	32.0215	31.9625	32.0178	6855308.0
2015-03-20 15:00:00	AAPL	Stock	32.02	32.03	31.925	31.9488	9302384.0
2015-03-20 15:30:00	AAPL	Stock	31.949	31.975	31.29	31.4875	56832152.0
2015-03-20 16:00:00	AAPL	Stock	31.475	31.9748	31.4718	31.635	71099824.0
2015-03-20 16:30:00	AAPL	Stock	31.6375	31.9738	31.4742	31.63	1495592.0
2015-03-20 17:00:00	AAPL	Stock	31.63	31.6725	31.475	31.635	526920.0
2015-03-20 17:30:00	AAPL	Stock	31.6325	31.65	31.475	31.6375	201340.0
2015-03-20 18:00:00	AAPL	Stock	31.635	31.6375	31.475	31.615	193840.0
2015-03-20 18:30:00	AAPL	Stock	31.6175	31.62	31.475	31.6075	71440.0
2015-03-20 19:00:00	AAPL	Stock	31.475	31.6325	31.475	31.625	40500.0
2015-03-20 19:30:00	AAPL	Stock	31.6275	31.6625	31.625	31.625	123344.0
2015-03-20 04:00:00	MSFT	Stock	42.47	42.47	42.4	42.4	200.0
2015-03-20 06:00:00	MSFT	Stock	42.4	42.4	42.4	42.4	100.0
2015-03-20 08:00:00	MSFT	Stock	42.539	42.55	42.539	42.55	1787.0
2015-03-20 08:30:00	MSFT	Stock	42.59	42.77	42.59	42.77	8771.0
2015-03-20 09:00:00	MSFT	Stock	42.77	42.78	42.56	42.56	397924.0
2015-03-20 09:30:00	MSFT	Stock	42.56	42.79	42.49	42.73	17461630.0
2015-03-20 10:00:00	MSFT	Stock	42.729	42.91	42.695	42.84	2999519.0
2015-03-20 10:30:00	MSFT	Stock	42.845	42.98	42.764	42.833	2275703.0
2015-03-20 11:00:00	MSFT	Stock	42.84	42.9	42.72	42.83	1439909.0
2015-03-20 11:30:00	MSFT	Stock	42.84	42.95	42.82	42.888	1964015.0
2015-03-20 12:00:00	MSFT	Stock	42.88	42.885	42.75	42.76	1307910.0
2015-03-20 12:30:00	MSFT	Stock	42.761	42.86	42.75	42.845	1513997.0
2015-03-20 13:00:00	MSFT	Stock	42.845	42.91	42.81	42.84	1954232.0
2015-03-20 13:30:00	MSFT	Stock	42.84	42.9	42.83	42.855	942840.0
2015-03-20 14:00:00	MSFT	Stock	42.85	42.91	42.84	42.89	1237518.0
2015-03-20 14:30:00	MSFT	Stock	42.89	42.92	42.86	42.914	2124724.0
2015-03-20 15:00:00	MSFT	Stock	42.92	42.95	42.74	42.75	2131065.0
2015-03-20 15:30:00	MSFT	Stock	42.755	42.8	42.65	42.76	6392207.0

> showing 50 of 86,417 rows — these rows as CSV

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