PREVIEW / stock_30min / 2015-09-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-18.parquet
  size:    1.6 MB
  rows:    84,450
  symbols: 3,459

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-09-18 04:00:00	AAPL	Stock	28.525	28.575	28.4975	28.54	5220.0
2015-09-18 04:30:00	AAPL	Stock	28.5425	28.5425	28.5	28.5	11040.0
2015-09-18 05:00:00	AAPL	Stock	28.5	28.5	28.475	28.5	36800.0
2015-09-18 05:30:00	AAPL	Stock	28.5475	28.5475	28.45	28.45	11460.0
2015-09-18 06:00:00	AAPL	Stock	28.455	28.47	28.375	28.375	36680.0
2015-09-18 06:30:00	AAPL	Stock	28.3825	28.4	28.275	28.31	50284.0
2015-09-18 07:00:00	AAPL	Stock	28.31	28.3175	28.2025	28.2025	111268.0
2015-09-18 07:30:00	AAPL	Stock	28.205	28.275	28.205	28.24	149512.0
2015-09-18 08:00:00	AAPL	Stock	28.2475	28.4425	28.2	28.205	458800.0
2015-09-18 08:30:00	AAPL	Stock	28.205	28.2875	28.19	28.235	516820.0
2015-09-18 09:00:00	AAPL	Stock	28.235	28.2625	27.955	27.96	1546356.0
2015-09-18 09:30:00	AAPL	Stock	27.96	28.3275	27.96	28.3225	67456288.0
2015-09-18 10:00:00	AAPL	Stock	28.3175	28.575	28.29	28.4775	22058764.0
2015-09-18 10:30:00	AAPL	Stock	28.475	28.495	28.3225	28.385	13361008.0
2015-09-18 11:00:00	AAPL	Stock	28.385	28.525	28.3825	28.4325	11794464.0
2015-09-18 11:30:00	AAPL	Stock	28.43	28.575	28.4	28.5075	10688432.0
2015-09-18 12:00:00	AAPL	Stock	28.51	28.52	28.335	28.425	10970264.0
2015-09-18 12:30:00	AAPL	Stock	28.425	28.4575	28.355	28.3775	7003972.0
2015-09-18 13:00:00	AAPL	Stock	28.3708	28.5208	28.3525	28.4638	11172788.0
2015-09-18 13:30:00	AAPL	Stock	28.4625	28.485	28.3238	28.3512	9311712.0
2015-09-18 14:00:00	AAPL	Stock	28.35	28.4875	28.325	28.4625	9096104.0
2015-09-18 14:30:00	AAPL	Stock	28.465	28.525	28.3875	28.485	9369988.0
2015-09-18 15:00:00	AAPL	Stock	28.485	28.5225	28.385	28.455	12567500.0
2015-09-18 15:30:00	AAPL	Stock	28.455	28.47	28.33	28.3725	25336640.0
2015-09-18 16:00:00	AAPL	Stock	28.3625	28.4125	28.3125	28.4	41436556.0
2015-09-18 16:30:00	AAPL	Stock	28.3775	28.3875	28.3625	28.38	59196.0
2015-09-18 17:00:00	AAPL	Stock	28.385	28.385	28.359	28.3775	316988.0
2015-09-18 17:30:00	AAPL	Stock	28.38	28.3925	28.3775	28.3925	30452.0
2015-09-18 18:00:00	AAPL	Stock	28.38	28.38	28.3625	28.3625	31748.0
2015-09-18 18:30:00	AAPL	Stock	28.3675	28.3775	28.3625	28.3775	11308.0
2015-09-18 19:00:00	AAPL	Stock	28.38	28.38	28.3625	28.375	908200.0
2015-09-18 19:30:00	AAPL	Stock	28.375	28.3775	28.3625	28.3625	51428.0
2015-09-18 06:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	500.0
2015-09-18 06:30:00	MSFT	Stock	43.98	43.98	43.98	43.98	100.0
2015-09-18 07:30:00	MSFT	Stock	43.7	43.78	43.7	43.7	2400.0
2015-09-18 08:00:00	MSFT	Stock	43.7	43.75	43.7	43.7	8870.0
2015-09-18 08:30:00	MSFT	Stock	43.65	43.75	43.65	43.75	11280.0
2015-09-18 09:00:00	MSFT	Stock	43.7	43.7	43.43	43.57	590011.0
2015-09-18 09:30:00	MSFT	Stock	43.5	43.79	43.45	43.509	17946049.0
2015-09-18 10:00:00	MSFT	Stock	43.51	43.75	43.44	43.675	2563972.0
2015-09-18 10:30:00	MSFT	Stock	43.68	43.71	43.53	43.69	1756910.0
2015-09-18 11:00:00	MSFT	Stock	43.69	43.89	43.68	43.742	1420038.0
2015-09-18 11:30:00	MSFT	Stock	43.74	43.99	43.71	43.85	1130311.0
2015-09-18 12:00:00	MSFT	Stock	43.85	43.86	43.53	43.6	1256997.0
2015-09-18 12:30:00	MSFT	Stock	43.59	43.62	43.44	43.54	1313750.0
2015-09-18 13:00:00	MSFT	Stock	43.545	43.63	43.37	43.48	1105064.0
2015-09-18 13:30:00	MSFT	Stock	43.48	43.55	43.33	43.37	1544968.0
2015-09-18 14:00:00	MSFT	Stock	43.37	43.64	43.33	43.59	1295376.0
2015-09-18 14:30:00	MSFT	Stock	43.59	43.7	43.49	43.62	1270222.0
2015-09-18 15:00:00	MSFT	Stock	43.63	43.68	43.41	43.48	1908543.0

> showing 50 of 84,450 rows — these rows as CSV

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