PREVIEW / stock_30min / 2015-11-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-16.parquet
  size:    1.6 MB
  rows:    81,085
  symbols: 3,397

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-11-16 04:00:00	AAPL	Stock	27.97	28.1375	27.97	28.0725	82396.0
2015-11-16 04:30:00	AAPL	Stock	28.0625	28.105	28.05	28.0925	29992.0
2015-11-16 05:00:00	AAPL	Stock	28.0475	28.1475	28.0475	28.1125	39580.0
2015-11-16 05:30:00	AAPL	Stock	28.1125	28.12	28.1125	28.12	4660.0
2015-11-16 06:00:00	AAPL	Stock	28.11	28.11	28.0375	28.055	29788.0
2015-11-16 06:30:00	AAPL	Stock	28.0025	28.055	28.0	28.05	31008.0
2015-11-16 07:00:00	AAPL	Stock	28.0275	28.085	27.9675	27.975	61896.0
2015-11-16 07:30:00	AAPL	Stock	27.99	27.9975	27.9625	27.965	36032.0
2015-11-16 08:00:00	AAPL	Stock	27.965	28.05	27.4975	27.73	1108224.0
2015-11-16 08:30:00	AAPL	Stock	27.7375	27.765	27.6875	27.725	617792.0
2015-11-16 09:00:00	AAPL	Stock	27.7175	27.8475	27.695	27.8475	453504.0
2015-11-16 09:30:00	AAPL	Stock	27.845	28.285	27.75	28.2625	27044556.0
2015-11-16 10:00:00	AAPL	Stock	28.26	28.3925	28.18	28.3638	14224444.0
2015-11-16 10:30:00	AAPL	Stock	28.3625	28.3675	28.1875	28.205	10631436.0
2015-11-16 11:00:00	AAPL	Stock	28.205	28.2525	28.1125	28.13	9196960.0
2015-11-16 11:30:00	AAPL	Stock	28.13	28.2475	28.11	28.215	7276444.0
2015-11-16 12:00:00	AAPL	Stock	28.22	28.375	28.21	28.35	7692000.0
2015-11-16 12:30:00	AAPL	Stock	28.35	28.4475	28.2975	28.3425	8013084.0
2015-11-16 13:00:00	AAPL	Stock	28.345	28.4325	28.2992	28.3775	5249600.0
2015-11-16 13:30:00	AAPL	Stock	28.38	28.4775	28.3675	28.465	6026512.0
2015-11-16 14:00:00	AAPL	Stock	28.465	28.5575	28.4418	28.51	7388444.0
2015-11-16 14:30:00	AAPL	Stock	28.51	28.545	28.4425	28.475	6345660.0
2015-11-16 15:00:00	AAPL	Stock	28.474	28.56	28.4725	28.5375	8006100.0
2015-11-16 15:30:00	AAPL	Stock	28.54	28.555	28.485	28.545	12226736.0
2015-11-16 16:00:00	AAPL	Stock	28.5438	28.5475	28.5	28.525	9666648.0
2015-11-16 16:30:00	AAPL	Stock	28.51	28.53	28.1625	28.52	344436.0
2015-11-16 17:00:00	AAPL	Stock	28.52	28.535	28.5125	28.5125	17180.0
2015-11-16 17:30:00	AAPL	Stock	28.515	28.53	28.51	28.5125	44240.0
2015-11-16 18:00:00	AAPL	Stock	28.5125	28.5125	28.4625	28.5	45844.0
2015-11-16 18:30:00	AAPL	Stock	28.4875	28.5438	28.475	28.5075	283292.0
2015-11-16 19:00:00	AAPL	Stock	28.51	28.51	28.4825	28.495	23724.0
2015-11-16 19:30:00	AAPL	Stock	28.485	28.5125	28.485	28.5125	26872.0
2015-11-16 04:00:00	MSFT	Stock	52.78	52.94	52.78	52.94	4036.0
2015-11-16 04:30:00	MSFT	Stock	52.87	52.87	52.87	52.87	100.0
2015-11-16 06:30:00	MSFT	Stock	52.93	52.93	52.93	52.93	500.0
2015-11-16 07:00:00	MSFT	Stock	52.86	52.94	52.86	52.88	7788.0
2015-11-16 07:30:00	MSFT	Stock	52.88	52.88	52.82	52.82	2030.0
2015-11-16 08:00:00	MSFT	Stock	52.9	53.05	52.84	52.87	10370.0
2015-11-16 08:30:00	MSFT	Stock	52.87	52.9	52.8	52.8	11107.0
2015-11-16 09:00:00	MSFT	Stock	52.79	53.0	52.71	53.0	17609.0
2015-11-16 09:30:00	MSFT	Stock	53.05	53.46	52.85	53.074	3807274.0
2015-11-16 10:00:00	MSFT	Stock	53.07	53.31	52.895	53.18	2098668.0
2015-11-16 10:30:00	MSFT	Stock	53.18	53.185	52.97	53.035	1583978.0
2015-11-16 11:00:00	MSFT	Stock	53.03	53.345	53.0	53.195	1640406.0
2015-11-16 11:30:00	MSFT	Stock	53.19	53.45	53.19	53.43	1339216.0
2015-11-16 12:00:00	MSFT	Stock	53.44	53.545	53.36	53.5	1175186.0
2015-11-16 12:30:00	MSFT	Stock	53.494	53.64	53.36	53.44	1345718.0
2015-11-16 13:00:00	MSFT	Stock	53.43	53.76	53.36	53.69	1586502.0
2015-11-16 13:30:00	MSFT	Stock	53.69	53.8	53.54	53.79	1494137.0
2015-11-16 14:00:00	MSFT	Stock	53.79	53.84	53.69	53.785	1692510.0

> showing 50 of 81,085 rows — these rows as CSV

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