PREVIEW / stock_30min / 2017-09-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-20.parquet
  size:    1.6 MB
  rows:    81,030
  symbols: 2,953

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
2017-09-20 04:00:00	AAPL	Stock	39.605	39.7575	39.605	39.75	4600.0
2017-09-20 04:30:00	AAPL	Stock	39.725	39.725	39.725	39.725	1684.0
2017-09-20 05:00:00	AAPL	Stock	39.7275	39.7275	39.7275	39.7275	800.0
2017-09-20 05:30:00	AAPL	Stock	39.7575	39.7575	39.75	39.75	1600.0
2017-09-20 06:00:00	AAPL	Stock	39.7875	39.7875	39.7175	39.7175	3192.0
2017-09-20 06:30:00	AAPL	Stock	39.715	39.715	39.685	39.685	1600.0
2017-09-20 07:00:00	AAPL	Stock	39.6975	39.75	39.6975	39.75	37512.0
2017-09-20 07:30:00	AAPL	Stock	39.75	39.75	39.635	39.6825	58748.0
2017-09-20 08:00:00	AAPL	Stock	39.7	39.75	39.59	39.605	117100.0
2017-09-20 08:30:00	AAPL	Stock	39.605	39.6125	39.5175	39.545	188564.0
2017-09-20 09:00:00	AAPL	Stock	39.5425	39.575	39.475	39.4975	221808.0
2017-09-20 09:30:00	AAPL	Stock	39.5	39.565	39.0125	39.0525	27436824.0
2017-09-20 10:00:00	AAPL	Stock	39.05	39.1625	38.9025	38.9468	17619176.0
2017-09-20 10:30:00	AAPL	Stock	38.9425	39.02	38.595	38.6215	21791900.0
2017-09-20 11:00:00	AAPL	Stock	38.625	38.76	38.4575	38.715	26526272.0
2017-09-20 11:30:00	AAPL	Stock	38.715	38.795	38.5972	38.6925	11254676.0
2017-09-20 12:00:00	AAPL	Stock	38.6952	38.945	38.6775	38.9375	8074984.0
2017-09-20 12:30:00	AAPL	Stock	38.9388	38.9762	38.88	38.92	6866100.0
2017-09-20 13:00:00	AAPL	Stock	38.9225	38.955	38.875	38.9275	4487512.0
2017-09-20 13:30:00	AAPL	Stock	38.93	39.0	38.8925	38.97	4715920.0
2017-09-20 14:00:00	AAPL	Stock	38.9688	39.015	38.7575	38.8075	9947484.0
2017-09-20 14:30:00	AAPL	Stock	38.805	38.9212	38.7175	38.86	8931552.0
2017-09-20 15:00:00	AAPL	Stock	38.8578	38.955	38.79	38.9535	6314052.0
2017-09-20 15:30:00	AAPL	Stock	38.955	39.0575	38.9025	39.0125	15669632.0
2017-09-20 16:00:00	AAPL	Stock	39.01	39.0175	38.685	39.015	13282812.0
2017-09-20 16:30:00	AAPL	Stock	39.0175	39.035	39.0125	39.025	186952.0
2017-09-20 17:00:00	AAPL	Stock	39.0125	39.015	38.9775	38.995	133688.0
2017-09-20 17:30:00	AAPL	Stock	38.995	39.0475	38.995	39.0425	296212.0
2017-09-20 18:00:00	AAPL	Stock	39.0425	39.0525	39.0025	39.0375	66932.0
2017-09-20 18:30:00	AAPL	Stock	39.0375	39.0375	39.0025	39.025	19236.0
2017-09-20 19:00:00	AAPL	Stock	39.02	39.02	39.0125	39.0125	3880.0
2017-09-20 19:30:00	AAPL	Stock	39.0125	39.0625	39.0125	39.0625	25852.0
2017-09-20 05:00:00	MSFT	Stock	75.46	75.46	75.46	75.46	107.0
2017-09-20 06:00:00	MSFT	Stock	75.45	75.45	75.45	75.45	200.0
2017-09-20 07:00:00	MSFT	Stock	75.35	75.35	75.3	75.3	7169.0
2017-09-20 07:30:00	MSFT	Stock	75.45	75.45	75.45	75.45	200.0
2017-09-20 08:00:00	MSFT	Stock	75.45	75.45	75.44	75.44	2300.0
2017-09-20 08:30:00	MSFT	Stock	75.31	75.35	75.31	75.31	1611.0
2017-09-20 09:00:00	MSFT	Stock	75.35	75.4	75.26	75.3	13533.0
2017-09-20 09:30:00	MSFT	Stock	75.35	75.55	75.115	75.181	2350923.0
2017-09-20 10:00:00	MSFT	Stock	75.19	75.335	75.13	75.165	1258259.0
2017-09-20 10:30:00	MSFT	Stock	75.16	75.21	74.85	74.86	1016691.0
2017-09-20 11:00:00	MSFT	Stock	74.86	74.95	74.72	74.79	1071588.0
2017-09-20 11:30:00	MSFT	Stock	74.8	75.09	74.79	75.06	641409.0
2017-09-20 12:00:00	MSFT	Stock	75.07	75.23	75.05	75.23	477307.0
2017-09-20 12:30:00	MSFT	Stock	75.23	75.25	75.13	75.144	347776.0
2017-09-20 13:00:00	MSFT	Stock	75.13	75.166	74.97	74.995	362547.0
2017-09-20 13:30:00	MSFT	Stock	74.99	75.13	74.945	75.1	553057.0
2017-09-20 14:00:00	MSFT	Stock	75.1	75.1	74.44	74.56	1518162.0
2017-09-20 14:30:00	MSFT	Stock	74.56	74.614	74.31	74.53	1746158.0

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

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