PREVIEW / stock_30min / 2014-08-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-11.parquet
  size:    1.6 MB
  rows:    82,767
  symbols: 3,575

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-08-11 04:00:00	AAPL	Stock	23.8875	23.8875	23.7775	23.8225	24500.0
2014-08-11 04:30:00	AAPL	Stock	23.8025	23.8025	23.7975	23.7975	3920.0
2014-08-11 05:00:00	AAPL	Stock	23.7975	23.8125	23.79	23.8125	2880.0
2014-08-11 05:30:00	AAPL	Stock	23.8025	23.8025	23.8	23.8	5384.0
2014-08-11 06:00:00	AAPL	Stock	23.795	23.8375	23.79	23.8225	14196.0
2014-08-11 06:30:00	AAPL	Stock	23.8225	23.8625	23.8225	23.8625	16424.0
2014-08-11 07:00:00	AAPL	Stock	23.8525	23.8625	23.8375	23.86	67304.0
2014-08-11 07:30:00	AAPL	Stock	23.8425	23.8475	23.8125	23.825	109656.0
2014-08-11 08:00:00	AAPL	Stock	23.84	23.8625	23.7825	23.8225	441608.0
2014-08-11 08:30:00	AAPL	Stock	23.8225	23.8325	23.81	23.825	238644.0
2014-08-11 09:00:00	AAPL	Stock	23.83	23.8375	23.8025	23.8225	232820.0
2014-08-11 09:30:00	AAPL	Stock	23.8225	23.8675	23.709	23.855	22407044.0
2014-08-11 10:00:00	AAPL	Stock	23.8575	23.955	23.855	23.9475	16315056.0
2014-08-11 10:30:00	AAPL	Stock	23.9488	24.02	23.94	23.975	13436652.0
2014-08-11 11:00:00	AAPL	Stock	23.975	24.0	23.9675	23.9775	9797456.0
2014-08-11 11:30:00	AAPL	Stock	23.98	23.9925	23.9425	23.96	6998992.0
2014-08-11 12:00:00	AAPL	Stock	23.9587	23.9875	23.915	23.969	6306356.0
2014-08-11 12:30:00	AAPL	Stock	23.9688	23.9975	23.96	23.9625	5509440.0
2014-08-11 13:00:00	AAPL	Stock	23.9625	23.9925	23.95	23.9575	4437728.0
2014-08-11 13:30:00	AAPL	Stock	23.9587	23.975	23.93	23.9525	4289924.0
2014-08-11 14:00:00	AAPL	Stock	23.9525	23.97	23.9	23.9475	7439488.0
2014-08-11 14:30:00	AAPL	Stock	23.9475	23.9725	23.9175	23.9625	4621680.0
2014-08-11 15:00:00	AAPL	Stock	23.9638	23.9925	23.96	23.9825	6427096.0
2014-08-11 15:30:00	AAPL	Stock	23.9812	24.0125	23.9525	23.995	16461104.0
2014-08-11 16:00:00	AAPL	Stock	23.9975	24.0125	23.9382	24.0025	10290696.0
2014-08-11 16:30:00	AAPL	Stock	24.0025	24.015	23.9775	24.015	198180.0
2014-08-11 17:00:00	AAPL	Stock	24.0125	24.0175	23.9975	24.01	107708.0
2014-08-11 17:30:00	AAPL	Stock	24.005	24.01	23.9975	24.005	24132.0
2014-08-11 18:00:00	AAPL	Stock	24.01	24.03	24.01	24.03	66268.0
2014-08-11 18:30:00	AAPL	Stock	24.0175	24.0375	23.9975	24.0375	146748.0
2014-08-11 19:00:00	AAPL	Stock	24.0425	24.0575	24.0325	24.0575	77992.0
2014-08-11 19:30:00	AAPL	Stock	24.0575	24.0575	23.9975	24.0525	101072.0
2014-08-11 05:30:00	MSFT	Stock	43.36	43.36	43.36	43.36	100.0
2014-08-11 06:00:00	MSFT	Stock	43.36	43.36	43.36	43.36	300.0
2014-08-11 06:30:00	MSFT	Stock	43.42	43.42	43.42	43.42	100.0
2014-08-11 07:30:00	MSFT	Stock	43.38	43.45	43.38	43.45	249.0
2014-08-11 08:00:00	MSFT	Stock	43.4	43.49	43.4	43.49	1449.0
2014-08-11 08:30:00	MSFT	Stock	43.43	43.49	43.42	43.43	4747.0
2014-08-11 09:00:00	MSFT	Stock	43.45	43.45	43.22	43.27	17900.0
2014-08-11 09:30:00	MSFT	Stock	43.26	43.3	43.03	43.12	2595890.0
2014-08-11 10:00:00	MSFT	Stock	43.12	43.17	43.04	43.045	1487820.0
2014-08-11 10:30:00	MSFT	Stock	43.04	43.16	43.02	43.08	1253280.0
2014-08-11 11:00:00	MSFT	Stock	43.07	43.34	43.04	43.32	1564730.0
2014-08-11 11:30:00	MSFT	Stock	43.32	43.435	43.31	43.366	1390197.0
2014-08-11 12:00:00	MSFT	Stock	43.36	43.45	43.34	43.38	929159.0
2014-08-11 12:30:00	MSFT	Stock	43.375	43.375	43.27	43.28	684259.0
2014-08-11 13:00:00	MSFT	Stock	43.28	43.29	43.195	43.23	573738.0
2014-08-11 13:30:00	MSFT	Stock	43.235	43.25	43.1	43.1	852697.0
2014-08-11 14:00:00	MSFT	Stock	43.1	43.18	43.06	43.165	1232732.0
2014-08-11 14:30:00	MSFT	Stock	43.16	43.21	43.14	43.16	897298.0

> showing 50 of 82,767 rows — these rows as CSV

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