PREVIEW / stock_30min / 2015-08-13

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-13.parquet
  size:    1.6 MB
  rows:    81,124
  symbols: 3,456

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-08-13 04:00:00	AAPL	Stock	28.9	29.0975	28.9	28.965	61504.0
2015-08-13 04:30:00	AAPL	Stock	28.9425	28.9775	28.935	28.975	15468.0
2015-08-13 05:00:00	AAPL	Stock	28.98	28.9875	28.9525	28.975	26060.0
2015-08-13 05:30:00	AAPL	Stock	28.9825	28.9825	28.925	28.925	11180.0
2015-08-13 06:00:00	AAPL	Stock	28.97	29.045	28.97	29.025	54080.0
2015-08-13 06:30:00	AAPL	Stock	29.0325	29.035	29.0125	29.025	14964.0
2015-08-13 07:00:00	AAPL	Stock	29.0125	29.02	28.975	29.005	104232.0
2015-08-13 07:30:00	AAPL	Stock	29.025	29.025	28.9675	28.9925	134412.0
2015-08-13 08:00:00	AAPL	Stock	28.9975	29.025	28.95	28.95	639152.0
2015-08-13 08:30:00	AAPL	Stock	28.95	28.9725	28.8525	28.8725	773608.0
2015-08-13 09:00:00	AAPL	Stock	28.86	29.055	28.825	28.995	1011456.0
2015-08-13 09:30:00	AAPL	Stock	29.01	29.1	28.635	28.73	38814088.0
2015-08-13 10:00:00	AAPL	Stock	28.7288	28.7975	28.6525	28.784	18286560.0
2015-08-13 10:30:00	AAPL	Stock	28.7825	29.035	28.7175	28.8525	20045052.0
2015-08-13 11:00:00	AAPL	Stock	28.8588	28.995	28.7925	28.916	11891448.0
2015-08-13 11:30:00	AAPL	Stock	28.9175	29.0	28.9125	28.975	9884296.0
2015-08-13 12:00:00	AAPL	Stock	28.9738	28.98	28.8775	28.9525	9842236.0
2015-08-13 12:30:00	AAPL	Stock	28.9525	28.985	28.9	28.9385	6282332.0
2015-08-13 13:00:00	AAPL	Stock	28.94	29.05	28.935	29.005	8268320.0
2015-08-13 13:30:00	AAPL	Stock	29.0075	29.034	28.95	28.9835	6074336.0
2015-08-13 14:00:00	AAPL	Stock	28.9838	29.075	28.9638	29.075	7392696.0
2015-08-13 14:30:00	AAPL	Stock	29.0725	29.0925	29.015	29.05	9768784.0
2015-08-13 15:00:00	AAPL	Stock	29.0475	29.05	28.88	28.901	11354464.0
2015-08-13 15:30:00	AAPL	Stock	28.9025	28.91	28.78	28.7925	17086336.0
2015-08-13 16:00:00	AAPL	Stock	28.7875	28.8075	28.6615	28.7775	5100368.0
2015-08-13 16:30:00	AAPL	Stock	28.7825	28.7875	28.77	28.77	87416.0
2015-08-13 17:00:00	AAPL	Stock	28.7692	28.775	28.725	28.725	193584.0
2015-08-13 17:30:00	AAPL	Stock	28.725	28.73	28.655	28.68	153228.0
2015-08-13 18:00:00	AAPL	Stock	28.6925	28.72	28.675	28.7	96164.0
2015-08-13 18:30:00	AAPL	Stock	28.6782	28.7175	28.6782	28.705	66228.0
2015-08-13 19:00:00	AAPL	Stock	28.6925	28.7125	28.6875	28.6875	37216.0
2015-08-13 19:30:00	AAPL	Stock	28.675	28.68	28.635	28.6475	56564.0
2015-08-13 04:00:00	MSFT	Stock	47.11	47.13	47.11	47.13	400.0
2015-08-13 05:30:00	MSFT	Stock	47.2	47.2	47.2	47.2	2000.0
2015-08-13 06:00:00	MSFT	Stock	47.2	47.28	47.2	47.25	2800.0
2015-08-13 06:30:00	MSFT	Stock	47.27	47.27	47.27	47.27	500.0
2015-08-13 07:00:00	MSFT	Stock	47.27	47.27	47.27	47.27	100.0
2015-08-13 07:30:00	MSFT	Stock	47.26	47.26	47.25	47.25	1500.0
2015-08-13 08:00:00	MSFT	Stock	47.27	47.4	47.21	47.4	8170.0
2015-08-13 08:30:00	MSFT	Stock	47.25	47.25	47.15	47.15	4100.0
2015-08-13 09:00:00	MSFT	Stock	47.11	47.2	47.04	47.08	188393.0
2015-08-13 09:30:00	MSFT	Stock	47.06	47.1	46.656	46.71	2969869.0
2015-08-13 10:00:00	MSFT	Stock	46.7	46.725	46.51	46.56	1540336.0
2015-08-13 10:30:00	MSFT	Stock	46.55	46.89	46.49	46.77	1734526.0
2015-08-13 11:00:00	MSFT	Stock	46.78	46.81	46.61	46.64	1602692.0
2015-08-13 11:30:00	MSFT	Stock	46.64	46.72	46.56	46.65	951303.0
2015-08-13 12:00:00	MSFT	Stock	46.65	46.83	46.57	46.82	1917935.0
2015-08-13 12:30:00	MSFT	Stock	46.82	46.966	46.8	46.925	940955.0
2015-08-13 13:00:00	MSFT	Stock	46.92	47.04	46.92	46.97	872939.0
2015-08-13 13:30:00	MSFT	Stock	46.97	46.99	46.84	46.89	804427.0

> showing 50 of 81,124 rows — these rows as CSV

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