PREVIEW / stock_30min / 2016-07-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-13.parquet
  size:    1.6 MB
  rows:    81,509
  symbols: 3,242

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
2016-07-13 04:00:00	AAPL	Stock	24.3775	24.4325	24.37	24.375	5200.0
2016-07-13 04:30:00	AAPL	Stock	24.3775	24.4325	24.3775	24.39	3040.0
2016-07-13 06:00:00	AAPL	Stock	24.4475	24.455	24.42	24.42	3876.0
2016-07-13 06:30:00	AAPL	Stock	24.45	24.47	24.45	24.46	3268.0
2016-07-13 07:00:00	AAPL	Stock	24.4425	24.4575	24.4	24.4	6084.0
2016-07-13 07:30:00	AAPL	Stock	24.4125	24.4125	24.4	24.405	15300.0
2016-07-13 08:00:00	AAPL	Stock	24.4	24.405	24.365	24.3875	91228.0
2016-07-13 08:30:00	AAPL	Stock	24.3875	24.4125	24.3775	24.4075	96660.0
2016-07-13 09:00:00	AAPL	Stock	24.4025	24.405	24.3425	24.3475	233632.0
2016-07-13 09:30:00	AAPL	Stock	24.3525	24.4175	24.295	24.3175	14691704.0
2016-07-13 10:00:00	AAPL	Stock	24.3175	24.3525	24.295	24.325	7723560.0
2016-07-13 10:30:00	AAPL	Stock	24.3275	24.37	24.308	24.3382	5661712.0
2016-07-13 11:00:00	AAPL	Stock	24.3375	24.3638	24.265	24.295	6191080.0
2016-07-13 11:30:00	AAPL	Stock	24.295	24.31	24.26	24.2675	4587740.0
2016-07-13 12:00:00	AAPL	Stock	24.27	24.2875	24.2325	24.2478	5115640.0
2016-07-13 12:30:00	AAPL	Stock	24.25	24.2975	24.235	24.285	3526764.0
2016-07-13 13:00:00	AAPL	Stock	24.2825	24.313	24.2625	24.2625	3614840.0
2016-07-13 13:30:00	AAPL	Stock	24.2625	24.3175	24.26	24.2908	3690368.0
2016-07-13 14:00:00	AAPL	Stock	24.2925	24.3225	24.2775	24.315	4395164.0
2016-07-13 14:30:00	AAPL	Stock	24.3175	24.32	24.2425	24.2472	5378712.0
2016-07-13 15:00:00	AAPL	Stock	24.245	24.2625	24.21	24.2512	7204624.0
2016-07-13 15:30:00	AAPL	Stock	24.25	24.275	24.2125	24.2175	9763796.0
2016-07-13 16:00:00	AAPL	Stock	24.2175	24.242	24.2025	24.225	12644832.0
2016-07-13 16:30:00	AAPL	Stock	24.2175	24.2325	24.2125	24.2125	18876.0
2016-07-13 17:00:00	AAPL	Stock	24.2125	24.2175	24.2075	24.2175	874640.0
2016-07-13 17:30:00	AAPL	Stock	24.2175	24.225	24.2075	24.2075	6900.0
2016-07-13 18:00:00	AAPL	Stock	24.21	24.21	24.1875	24.1875	1300.0
2016-07-13 18:30:00	AAPL	Stock	24.2	24.2	24.1775	24.19	17476.0
2016-07-13 19:00:00	AAPL	Stock	24.1975	24.1975	24.1825	24.1875	5104.0
2016-07-13 19:30:00	AAPL	Stock	24.21	24.21	24.2	24.2	12880.0
2016-07-13 04:00:00	MSFT	Stock	53.28	53.28	53.28	53.28	260.0
2016-07-13 05:30:00	MSFT	Stock	53.48	53.48	53.48	53.48	260.0
2016-07-13 06:30:00	MSFT	Stock	53.47	53.47	53.47	53.47	120.0
2016-07-13 08:00:00	MSFT	Stock	53.4	53.42	53.37	53.42	6457.0
2016-07-13 08:30:00	MSFT	Stock	53.4	53.4	53.4	53.4	3156.0
2016-07-13 09:00:00	MSFT	Stock	53.35	53.53	53.35	53.53	9911.0
2016-07-13 09:30:00	MSFT	Stock	53.56	53.56	53.18	53.49	2379150.0
2016-07-13 10:00:00	MSFT	Stock	53.49	53.6	53.41	53.45	1572502.0
2016-07-13 10:30:00	MSFT	Stock	53.45	53.63	53.43	53.54	1331581.0
2016-07-13 11:00:00	MSFT	Stock	53.54	53.58	53.47	53.52	1314622.0
2016-07-13 11:30:00	MSFT	Stock	53.525	53.585	53.475	53.57	1671366.0
2016-07-13 12:00:00	MSFT	Stock	53.57	53.66	53.565	53.63	960016.0
2016-07-13 12:30:00	MSFT	Stock	53.625	53.63	53.52	53.595	1000297.0
2016-07-13 13:00:00	MSFT	Stock	53.59	53.65	53.56	53.565	767659.0
2016-07-13 13:30:00	MSFT	Stock	53.56	53.72	53.53	53.62	1026936.0
2016-07-13 14:00:00	MSFT	Stock	53.615	53.79	53.6	53.765	1166406.0
2016-07-13 14:30:00	MSFT	Stock	53.77	53.8	53.665	53.76	1237733.0
2016-07-13 15:00:00	MSFT	Stock	53.755	53.86	53.64	53.64	1987453.0
2016-07-13 15:30:00	MSFT	Stock	53.64	53.73	53.5	53.511	4764828.0
2016-07-13 16:00:00	MSFT	Stock	53.51	53.62	53.191	53.52	2800213.0

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

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