PREVIEW / stock_30min / 2014-10-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-15.parquet
  size:    1.7 MB
  rows:    86,612
  symbols: 3,570

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-10-15 04:00:00	AAPL	Stock	24.7525	24.7525	24.675	24.675	6400.0
2014-10-15 04:30:00	AAPL	Stock	24.73	24.73	24.6925	24.7025	5560.0
2014-10-15 05:00:00	AAPL	Stock	24.7	24.7	24.6275	24.6275	5200.0
2014-10-15 05:30:00	AAPL	Stock	24.67	24.78	24.67	24.775	12444.0
2014-10-15 06:00:00	AAPL	Stock	24.7825	24.7825	24.7725	24.775	24188.0
2014-10-15 06:30:00	AAPL	Stock	24.7875	24.7925	24.7875	24.7925	1200.0
2014-10-15 07:00:00	AAPL	Stock	24.7625	24.82	24.6475	24.6775	195012.0
2014-10-15 07:30:00	AAPL	Stock	24.6775	24.7575	24.65	24.7375	578924.0
2014-10-15 08:00:00	AAPL	Stock	24.735	24.875	24.66	24.85	1069980.0
2014-10-15 08:30:00	AAPL	Stock	24.8275	24.8275	24.625	24.64	1349428.0
2014-10-15 09:00:00	AAPL	Stock	24.6425	24.6875	24.45	24.5025	1589276.0
2014-10-15 09:30:00	AAPL	Stock	24.5025	24.7325	24.45	24.575	44961176.0
2014-10-15 10:00:00	AAPL	Stock	24.575	24.7875	24.54	24.545	24063952.0
2014-10-15 10:30:00	AAPL	Stock	24.5425	24.6767	24.5175	24.62	18891284.0
2014-10-15 11:00:00	AAPL	Stock	24.615	24.6975	24.51	24.5175	15028936.0
2014-10-15 11:30:00	AAPL	Stock	24.52	24.575	24.415	24.54	17020912.0
2014-10-15 12:00:00	AAPL	Stock	24.5382	24.5425	24.3375	24.369	17144988.0
2014-10-15 12:30:00	AAPL	Stock	24.3725	24.4575	23.795	24.0	50065992.0
2014-10-15 13:00:00	AAPL	Stock	24.0	24.2	23.8125	23.883	36503532.0
2014-10-15 13:30:00	AAPL	Stock	23.8925	24.215	23.8725	24.0415	26710016.0
2014-10-15 14:00:00	AAPL	Stock	24.04	24.2325	23.9625	24.11	21144064.0
2014-10-15 14:30:00	AAPL	Stock	24.1125	24.3275	24.0875	24.2775	24306884.0
2014-10-15 15:00:00	AAPL	Stock	24.2788	24.3938	24.155	24.3865	25630316.0
2014-10-15 15:30:00	AAPL	Stock	24.387	24.515	24.29	24.39	35340076.0
2014-10-15 16:00:00	AAPL	Stock	24.385	24.6498	24.2025	24.2075	12194652.0
2014-10-15 16:30:00	AAPL	Stock	24.2225	24.593	24.2	24.2975	488636.0
2014-10-15 17:00:00	AAPL	Stock	24.2975	24.2975	22.8752	24.2625	81716.0
2014-10-15 17:30:00	AAPL	Stock	24.2625	24.2875	24.225	24.25	60580.0
2014-10-15 18:00:00	AAPL	Stock	24.385	24.385	24.25	24.2625	3441828.0
2014-10-15 18:30:00	AAPL	Stock	24.255	24.255	24.225	24.235	68884.0
2014-10-15 19:00:00	AAPL	Stock	24.2375	24.2625	24.225	24.25	68772.0
2014-10-15 19:30:00	AAPL	Stock	24.25	24.2625	24.23	24.2425	81264.0
2014-10-15 05:00:00	MSFT	Stock	43.8	43.8	43.8	43.8	300.0
2014-10-15 05:30:00	MSFT	Stock	43.73	43.73	43.72	43.72	400.0
2014-10-15 07:00:00	MSFT	Stock	43.7	43.7	43.59	43.6	11040.0
2014-10-15 07:30:00	MSFT	Stock	43.68	43.68	43.47	43.53	21224.0
2014-10-15 08:00:00	MSFT	Stock	43.53	43.58	43.46	43.58	8809.0
2014-10-15 08:30:00	MSFT	Stock	43.58	43.58	43.25	43.3	18929.0
2014-10-15 09:00:00	MSFT	Stock	43.3	43.73	42.89	42.99	91160.0
2014-10-15 09:30:00	MSFT	Stock	42.99	43.05	42.1	42.53	12047821.0
2014-10-15 10:00:00	MSFT	Stock	42.53	42.96	42.429	42.79	4584816.0
2014-10-15 10:30:00	MSFT	Stock	42.79	43.0	42.66	42.92	2777241.0
2014-10-15 11:00:00	MSFT	Stock	42.91	43.0	42.61	42.67	3309306.0
2014-10-15 11:30:00	MSFT	Stock	42.663	42.745	42.45	42.71	2559048.0
2014-10-15 12:00:00	MSFT	Stock	42.7	42.705	42.41	42.439	2195282.0
2014-10-15 12:30:00	MSFT	Stock	42.43	42.64	42.38	42.52	3094450.0
2014-10-15 13:00:00	MSFT	Stock	42.52	42.675	42.28	42.32	3066057.0
2014-10-15 13:30:00	MSFT	Stock	42.32	42.62	42.22	42.425	3362785.0
2014-10-15 14:00:00	MSFT	Stock	42.421	42.74	42.285	42.62	2646019.0
2014-10-15 14:30:00	MSFT	Stock	42.62	42.87	42.56	42.745	2400097.0

> showing 50 of 86,612 rows — these rows as CSV

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