PREVIEW / stock_30min / 2015-01-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-27.parquet
  size:    1.6 MB
  rows:    83,621
  symbols: 3,506

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
2015-01-27 04:00:00	AAPL	Stock	28.4	28.4625	28.4	28.4	8400.0
2015-01-27 04:30:00	AAPL	Stock	28.4575	28.4575	28.425	28.4375	17512.0
2015-01-27 05:00:00	AAPL	Stock	28.445	28.445	28.375	28.375	27764.0
2015-01-27 05:30:00	AAPL	Stock	28.4	28.425	28.39	28.42	10600.0
2015-01-27 06:00:00	AAPL	Stock	28.3925	28.43	28.385	28.385	17040.0
2015-01-27 06:30:00	AAPL	Stock	28.42	28.4225	28.3375	28.3725	22424.0
2015-01-27 07:00:00	AAPL	Stock	28.3725	28.4175	28.305	28.38	168692.0
2015-01-27 07:30:00	AAPL	Stock	28.3825	28.4	28.2	28.24	466956.0
2015-01-27 08:00:00	AAPL	Stock	28.24	28.42	28.085	28.1	1728464.0
2015-01-27 08:30:00	AAPL	Stock	28.0975	28.14	28.005	28.1375	1433524.0
2015-01-27 09:00:00	AAPL	Stock	28.13	28.175	27.9375	28.0975	2152804.0
2015-01-27 09:30:00	AAPL	Stock	28.1075	28.12	27.635	27.7752	43400024.0
2015-01-27 10:00:00	AAPL	Stock	27.775	27.835	27.6875	27.6888	18748748.0
2015-01-27 10:30:00	AAPL	Stock	27.69	27.6975	27.4375	27.5325	26641752.0
2015-01-27 11:00:00	AAPL	Stock	27.5348	27.6325	27.5225	27.5925	16337100.0
2015-01-27 11:30:00	AAPL	Stock	27.5925	27.7325	27.5625	27.625	15831872.0
2015-01-27 12:00:00	AAPL	Stock	27.6225	27.76	27.5775	27.7585	11973868.0
2015-01-27 12:30:00	AAPL	Stock	27.76	27.85	27.7575	27.8025	14198820.0
2015-01-27 13:00:00	AAPL	Stock	27.8025	27.8775	27.7975	27.8675	12500340.0
2015-01-27 13:30:00	AAPL	Stock	27.8675	27.9025	27.675	27.6788	15019752.0
2015-01-27 14:00:00	AAPL	Stock	27.6775	27.8	27.67	27.7975	13412024.0
2015-01-27 14:30:00	AAPL	Stock	27.7975	27.85	27.7325	27.745	13728424.0
2015-01-27 15:00:00	AAPL	Stock	27.75	27.8	27.5875	27.6125	20265796.0
2015-01-27 15:30:00	AAPL	Stock	27.61	27.6375	27.2575	27.2875	47664208.0
2015-01-27 16:00:00	AAPL	Stock	27.2875	28.102	27.2775	27.6	16565380.0
2015-01-27 16:30:00	AAPL	Stock	27.62	29.115	27.285	28.66	45444464.0
2015-01-27 17:00:00	AAPL	Stock	28.655	28.7225	27.285	28.585	10351648.0
2015-01-27 17:30:00	AAPL	Stock	28.5875	28.7	28.5	28.65	4098076.0
2015-01-27 18:00:00	AAPL	Stock	28.6525	28.845	28.65	28.825	3445260.0
2015-01-27 18:30:00	AAPL	Stock	28.825	28.875	28.79	28.86	2190524.0
2015-01-27 19:00:00	AAPL	Stock	28.8625	28.87	28.825	28.8375	778664.0
2015-01-27 19:30:00	AAPL	Stock	28.8375	28.85	28.7825	28.85	1041320.0
2015-01-27 04:00:00	MSFT	Stock	45.01	45.48	45.0	45.3	11103.0
2015-01-27 04:30:00	MSFT	Stock	45.29	45.3	45.2	45.24	1400.0
2015-01-27 05:00:00	MSFT	Stock	45.24	45.3	44.72	44.74	23101.0
2015-01-27 05:30:00	MSFT	Stock	44.8	44.8	44.52	44.52	13770.0
2015-01-27 06:00:00	MSFT	Stock	44.6	44.69	43.77	43.84	72980.0
2015-01-27 06:30:00	MSFT	Stock	43.8	43.93	43.36	43.6	119006.0
2015-01-27 07:00:00	MSFT	Stock	43.62	43.85	43.55	43.55	438346.0
2015-01-27 07:30:00	MSFT	Stock	43.55	43.8	43.3	43.4	973147.0
2015-01-27 08:00:00	MSFT	Stock	43.65	43.85	43.01	43.1	3851724.0
2015-01-27 08:30:00	MSFT	Stock	43.1	45.0	42.85	42.95	2464543.0
2015-01-27 09:00:00	MSFT	Stock	42.96	43.32	42.88	42.96	2801776.0
2015-01-27 09:30:00	MSFT	Stock	42.95	43.08	42.105	42.5	38379468.0
2015-01-27 10:00:00	MSFT	Stock	42.5	42.63	42.2	42.325	16483633.0
2015-01-27 10:30:00	MSFT	Stock	42.325	42.39	42.2	42.345	13461623.0
2015-01-27 11:00:00	MSFT	Stock	42.34	42.49	42.29	42.36	10354614.0
2015-01-27 11:30:00	MSFT	Stock	42.355	42.78	42.34	42.58	12661548.0
2015-01-27 12:00:00	MSFT	Stock	42.58	43.02	42.56	42.955	9702557.0
2015-01-27 12:30:00	MSFT	Stock	42.96	43.0	42.66	42.764	6703764.0

> showing 50 of 83,621 rows — these rows as CSV

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