PREVIEW / stock_30min / 2016-06-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-07.parquet
  size:    1.6 MB
  rows:    82,981
  symbols: 3,315

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-06-07 04:00:00	AAPL	Stock	24.6925	24.745	24.6925	24.745	8000.0
2016-06-07 04:30:00	AAPL	Stock	24.7675	24.7675	24.7675	24.7675	400.0
2016-06-07 05:00:00	AAPL	Stock	24.7875	24.79	24.7875	24.79	3800.0
2016-06-07 05:30:00	AAPL	Stock	24.7975	24.8175	24.7975	24.8175	4124.0
2016-06-07 06:00:00	AAPL	Stock	24.84	24.84	24.8375	24.8375	4400.0
2016-06-07 06:30:00	AAPL	Stock	24.8025	24.8025	24.775	24.775	12836.0
2016-06-07 07:00:00	AAPL	Stock	24.7825	24.7875	24.765	24.7875	29160.0
2016-06-07 07:30:00	AAPL	Stock	24.785	24.7875	24.76	24.775	45628.0
2016-06-07 08:00:00	AAPL	Stock	24.7875	24.795	24.7575	24.775	135140.0
2016-06-07 08:30:00	AAPL	Stock	24.775	24.7775	24.745	24.7625	100360.0
2016-06-07 09:00:00	AAPL	Stock	24.7625	24.825	24.725	24.8125	148032.0
2016-06-07 09:30:00	AAPL	Stock	24.8125	24.95	24.8	24.9375	15143116.0
2016-06-07 10:00:00	AAPL	Stock	24.94	24.9675	24.885	24.945	7316876.0
2016-06-07 10:30:00	AAPL	Stock	24.9448	24.9675	24.8203	24.8425	7532256.0
2016-06-07 11:00:00	AAPL	Stock	24.8425	24.8925	24.8125	24.8825	6175488.0
2016-06-07 11:30:00	AAPL	Stock	24.885	24.8925	24.815	24.8282	4126496.0
2016-06-07 12:00:00	AAPL	Stock	24.8275	24.8625	24.8255	24.855	3667040.0
2016-06-07 12:30:00	AAPL	Stock	24.8538	24.875	24.835	24.8612	2808888.0
2016-06-07 13:00:00	AAPL	Stock	24.8625	24.865	24.8225	24.8475	2555708.0
2016-06-07 13:30:00	AAPL	Stock	24.845	24.8575	24.8225	24.8275	2933764.0
2016-06-07 14:00:00	AAPL	Stock	24.8275	24.8675	24.815	24.8588	3620016.0
2016-06-07 14:30:00	AAPL	Stock	24.8575	24.87	24.7725	24.7875	3358928.0
2016-06-07 15:00:00	AAPL	Stock	24.7875	24.825	24.7575	24.7838	5774028.0
2016-06-07 15:30:00	AAPL	Stock	24.7838	24.795	24.74	24.76	10023364.0
2016-06-07 16:00:00	AAPL	Stock	24.7575	24.9345	24.7575	24.775	6626880.0
2016-06-07 16:30:00	AAPL	Stock	24.7625	24.7725	24.7575	24.7575	12192.0
2016-06-07 17:00:00	AAPL	Stock	24.7575	24.76	24.75	24.75	35668.0
2016-06-07 17:30:00	AAPL	Stock	24.7475	24.75	24.745	24.75	9232.0
2016-06-07 18:00:00	AAPL	Stock	24.75	24.77	24.75	24.77	7260.0
2016-06-07 18:30:00	AAPL	Stock	24.7575	24.7575	24.755	24.7575	2280.0
2016-06-07 19:00:00	AAPL	Stock	24.7575	24.7725	24.745	24.7475	19048.0
2016-06-07 19:30:00	AAPL	Stock	24.745	24.75	24.7375	24.75	42952.0
2016-06-07 08:00:00	MSFT	Stock	52.41	52.41	52.41	52.41	100.0
2016-06-07 08:30:00	MSFT	Stock	52.3	52.3	52.29	52.29	2200.0
2016-06-07 09:00:00	MSFT	Stock	52.27	52.35	52.15	52.21	14390.0
2016-06-07 09:30:00	MSFT	Stock	52.27	52.62	52.22	52.575	1720368.0
2016-06-07 10:00:00	MSFT	Stock	52.58	52.69	52.48	52.55	1203394.0
2016-06-07 10:30:00	MSFT	Stock	52.56	52.7	52.545	52.685	1526534.0
2016-06-07 11:00:00	MSFT	Stock	52.68	52.73	52.62	52.645	1364051.0
2016-06-07 11:30:00	MSFT	Stock	52.644	52.644	52.405	52.445	692274.0
2016-06-07 12:00:00	MSFT	Stock	52.44	52.475	52.39	52.47	655333.0
2016-06-07 12:30:00	MSFT	Stock	52.47	52.52	52.444	52.51	630003.0
2016-06-07 13:00:00	MSFT	Stock	52.515	52.53	52.45	52.485	537993.0
2016-06-07 13:30:00	MSFT	Stock	52.48	52.49	52.38	52.395	860942.0
2016-06-07 14:00:00	MSFT	Stock	52.394	52.425	52.34	52.38	865212.0
2016-06-07 14:30:00	MSFT	Stock	52.385	52.42	52.27	52.321	792683.0
2016-06-07 15:00:00	MSFT	Stock	52.32	52.355	52.205	52.3	1150978.0
2016-06-07 15:30:00	MSFT	Stock	52.31	52.325	52.1	52.1	3931013.0
2016-06-07 16:00:00	MSFT	Stock	52.1	52.15	52.1	52.1	2817357.0
2016-06-07 16:30:00	MSFT	Stock	52.14	52.14	52.14	52.14	100.0

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

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