PREVIEW / stock_30min / 2016-05-31

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-31.parquet
  size:    1.6 MB
  rows:    82,326
  symbols: 3,318

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-05-31 04:00:00	AAPL	Stock	25.0875	25.125	25.0675	25.1175	7640.0
2016-05-31 05:00:00	AAPL	Stock	25.0625	25.0875	25.0625	25.0875	840.0
2016-05-31 05:30:00	AAPL	Stock	25.0875	25.0875	25.035	25.0375	15164.0
2016-05-31 06:00:00	AAPL	Stock	25.0025	25.035	25.0	25.025	13980.0
2016-05-31 06:30:00	AAPL	Stock	25.0325	25.035	24.9925	24.9925	21708.0
2016-05-31 07:00:00	AAPL	Stock	24.985	25.02	24.95	24.955	146260.0
2016-05-31 07:30:00	AAPL	Stock	24.945	24.9625	24.925	24.9575	100640.0
2016-05-31 08:00:00	AAPL	Stock	24.9625	25.0	24.9275	24.95	414424.0
2016-05-31 08:30:00	AAPL	Stock	24.9475	24.965	24.94	24.9575	136564.0
2016-05-31 09:00:00	AAPL	Stock	24.9625	24.965	24.8975	24.8975	309004.0
2016-05-31 09:30:00	AAPL	Stock	24.9	25.1	24.885	25.0413	21933196.0
2016-05-31 10:00:00	AAPL	Stock	25.0435	25.07	24.95	24.9725	9738048.0
2016-05-31 10:30:00	AAPL	Stock	24.975	25.0025	24.95	24.97	9546676.0
2016-05-31 11:00:00	AAPL	Stock	24.97	25.025	24.95	24.9925	9592492.0
2016-05-31 11:30:00	AAPL	Stock	24.99	25.01	24.9575	24.9705	3995464.0
2016-05-31 12:00:00	AAPL	Stock	24.97	24.97	24.8988	24.9062	8523428.0
2016-05-31 12:30:00	AAPL	Stock	24.9075	24.9513	24.9025	24.9513	5565780.0
2016-05-31 13:00:00	AAPL	Stock	24.9525	24.96	24.9175	24.9575	4482608.0
2016-05-31 13:30:00	AAPL	Stock	24.96	24.97	24.925	24.9278	3553968.0
2016-05-31 14:00:00	AAPL	Stock	24.9275	24.9275	24.815	24.84	9049944.0
2016-05-31 14:30:00	AAPL	Stock	24.8425	24.8425	24.705	24.7375	9433696.0
2016-05-31 15:00:00	AAPL	Stock	24.74	24.7875	24.7225	24.785	8236840.0
2016-05-31 15:30:00	AAPL	Stock	24.7825	24.995	24.7825	24.965	22461056.0
2016-05-31 16:00:00	AAPL	Stock	24.965	24.995	24.9288	24.9725	26581188.0
2016-05-31 16:30:00	AAPL	Stock	24.9725	24.98	24.9675	24.9675	96348.0
2016-05-31 17:00:00	AAPL	Stock	24.9575	24.96	24.9425	24.95	35532.0
2016-05-31 17:30:00	AAPL	Stock	24.955	24.9625	24.945	24.9625	58828.0
2016-05-31 18:00:00	AAPL	Stock	24.965	24.9775	24.9625	24.9725	12400.0
2016-05-31 18:30:00	AAPL	Stock	24.965	24.965	24.9625	24.9625	7400.0
2016-05-31 19:00:00	AAPL	Stock	24.9625	24.9675	24.9525	24.9525	9600.0
2016-05-31 19:30:00	AAPL	Stock	24.965	24.9875	24.9625	24.9875	27200.0
2016-05-31 04:30:00	MSFT	Stock	52.42	52.42	52.42	52.42	195.0
2016-05-31 07:00:00	MSFT	Stock	52.2	52.32	52.2	52.32	1361.0
2016-05-31 07:30:00	MSFT	Stock	52.34	52.41	52.34	52.41	500.0
2016-05-31 08:00:00	MSFT	Stock	52.4	52.42	52.4	52.42	1094.0
2016-05-31 09:00:00	MSFT	Stock	52.41	52.43	52.13	52.13	7359.0
2016-05-31 09:30:00	MSFT	Stock	52.16	52.44	52.095	52.37	2197371.0
2016-05-31 10:00:00	MSFT	Stock	52.38	52.5	52.334	52.47	1118755.0
2016-05-31 10:30:00	MSFT	Stock	52.47	52.59	52.25	52.38	1382608.0
2016-05-31 11:00:00	MSFT	Stock	52.37	52.39	52.28	52.315	848488.0
2016-05-31 11:30:00	MSFT	Stock	52.31	52.38	52.22	52.29	869036.0
2016-05-31 12:00:00	MSFT	Stock	52.28	52.33	52.22	52.23	963769.0
2016-05-31 12:30:00	MSFT	Stock	52.234	52.32	52.22	52.235	908070.0
2016-05-31 13:00:00	MSFT	Stock	52.231	52.31	52.2	52.3	527766.0
2016-05-31 13:30:00	MSFT	Stock	52.3	52.4	52.29	52.33	549933.0
2016-05-31 14:00:00	MSFT	Stock	52.32	52.32	52.12	52.24	1585973.0
2016-05-31 14:30:00	MSFT	Stock	52.23	52.26	52.14	52.14	937329.0
2016-05-31 15:00:00	MSFT	Stock	52.14	52.207	52.08	52.13	1884272.0
2016-05-31 15:30:00	MSFT	Stock	52.12	53.0	52.12	53.0	8217271.0
2016-05-31 16:00:00	MSFT	Stock	52.99	53.005	51.25	52.5	10626721.0

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

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