PREVIEW / stock_30min / 2014-10-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-10.parquet
  size:    1.6 MB
  rows:    83,956
  symbols: 3,547

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-10 04:00:00	AAPL	Stock	25.2275	25.2275	25.2	25.205	6040.0
2014-10-10 04:30:00	AAPL	Stock	25.2225	25.2225	25.1225	25.1225	11916.0
2014-10-10 05:00:00	AAPL	Stock	25.125	25.1375	25.0275	25.03	56048.0
2014-10-10 05:30:00	AAPL	Stock	25.0925	25.0925	25.035	25.0625	48716.0
2014-10-10 06:00:00	AAPL	Stock	25.0875	25.0875	25.01	25.01	40016.0
2014-10-10 06:30:00	AAPL	Stock	25.0225	25.08	25.0125	25.0625	16596.0
2014-10-10 07:00:00	AAPL	Stock	25.0575	25.1175	25.04	25.075	226656.0
2014-10-10 07:30:00	AAPL	Stock	25.075	25.145	25.0375	25.1	214432.0
2014-10-10 08:00:00	AAPL	Stock	25.1	25.2	25.05	25.07	535172.0
2014-10-10 08:30:00	AAPL	Stock	25.0625	25.2225	25.0625	25.2225	313456.0
2014-10-10 09:00:00	AAPL	Stock	25.22	25.225	25.125	25.175	384052.0
2014-10-10 09:30:00	AAPL	Stock	25.175	25.4725	25.125	25.3962	36032684.0
2014-10-10 10:00:00	AAPL	Stock	25.395	25.425	25.105	25.12	28483776.0
2014-10-10 10:30:00	AAPL	Stock	25.1188	25.3875	25.075	25.3588	23813648.0
2014-10-10 11:00:00	AAPL	Stock	25.3575	25.45	25.2775	25.3425	18420328.0
2014-10-10 11:30:00	AAPL	Stock	25.3425	25.4275	25.3025	25.36	10416772.0
2014-10-10 12:00:00	AAPL	Stock	25.3612	25.4675	25.36	25.4175	14647992.0
2014-10-10 12:30:00	AAPL	Stock	25.4163	25.4825	25.4	25.4325	12311816.0
2014-10-10 13:00:00	AAPL	Stock	25.43	25.4475	25.36	25.3775	9948608.0
2014-10-10 13:30:00	AAPL	Stock	25.38	25.4675	25.3675	25.46	8764060.0
2014-10-10 14:00:00	AAPL	Stock	25.4575	25.5075	25.425	25.4575	14832276.0
2014-10-10 14:30:00	AAPL	Stock	25.455	25.465	25.3875	25.4225	9776596.0
2014-10-10 15:00:00	AAPL	Stock	25.425	25.4425	25.29	25.3225	14232580.0
2014-10-10 15:30:00	AAPL	Stock	25.3225	25.34	25.1825	25.1825	31422312.0
2014-10-10 16:00:00	AAPL	Stock	25.185	25.421	25.175	25.1875	16149416.0
2014-10-10 16:30:00	AAPL	Stock	25.185	25.29	21.9815	25.1625	648756.0
2014-10-10 17:00:00	AAPL	Stock	25.1825	25.1875	25.1525	25.175	854772.0
2014-10-10 17:30:00	AAPL	Stock	25.1775	25.1975	25.1775	25.19	71232.0
2014-10-10 18:00:00	AAPL	Stock	25.1925	25.2	25.1825	25.195	49844.0
2014-10-10 18:30:00	AAPL	Stock	25.195	25.1975	25.1925	25.195	17508.0
2014-10-10 19:00:00	AAPL	Stock	25.1975	25.1975	25.1925	25.195	45312.0
2014-10-10 19:30:00	AAPL	Stock	25.1925	25.2225	25.1925	25.2125	120400.0
2014-10-10 04:00:00	MSFT	Stock	45.77	45.77	45.69	45.69	600.0
2014-10-10 04:30:00	MSFT	Stock	45.67	45.67	45.67	45.67	300.0
2014-10-10 05:00:00	MSFT	Stock	45.57	45.57	45.54	45.54	400.0
2014-10-10 05:30:00	MSFT	Stock	45.5	45.5	45.5	45.5	132.0
2014-10-10 06:00:00	MSFT	Stock	45.46	45.46	45.4	45.4	200.0
2014-10-10 06:30:00	MSFT	Stock	45.43	45.46	45.43	45.46	800.0
2014-10-10 07:00:00	MSFT	Stock	45.43	45.46	45.43	45.46	3600.0
2014-10-10 07:30:00	MSFT	Stock	45.46	45.5	45.46	45.5	400.0
2014-10-10 08:00:00	MSFT	Stock	45.58	45.6	45.46	45.52	23268.0
2014-10-10 08:30:00	MSFT	Stock	45.53	45.78	45.53	45.78	33898.0
2014-10-10 09:00:00	MSFT	Stock	45.8	45.8	45.65	45.65	27350.0
2014-10-10 09:30:00	MSFT	Stock	45.64	46.12	45.55	45.77	4391257.0
2014-10-10 10:00:00	MSFT	Stock	45.76	45.76	45.43	45.59	2904565.0
2014-10-10 10:30:00	MSFT	Stock	45.59	45.76	45.46	45.54	2828844.0
2014-10-10 11:00:00	MSFT	Stock	45.54	45.58	45.19	45.25	3198513.0
2014-10-10 11:30:00	MSFT	Stock	45.25	45.315	45.06	45.115	2797795.0
2014-10-10 12:00:00	MSFT	Stock	45.115	45.36	45.099	45.205	2312493.0
2014-10-10 12:30:00	MSFT	Stock	45.21	45.37	45.01	45.013	2136290.0

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

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