PREVIEW / stock_30min / 2016-09-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-09.parquet
  size:    1.6 MB
  rows:    84,004
  symbols: 3,251

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
2016-09-09 04:00:00	AAPL	Stock	26.3475	26.3575	26.325	26.3575	3896.0
2016-09-09 04:30:00	AAPL	Stock	26.3525	26.3525	26.35	26.35	2156.0
2016-09-09 05:00:00	AAPL	Stock	26.35	26.35	26.35	26.35	1744.0
2016-09-09 06:00:00	AAPL	Stock	26.3575	26.3575	26.3575	26.3575	7456.0
2016-09-09 06:30:00	AAPL	Stock	26.3375	26.3475	26.2925	26.3475	2400.0
2016-09-09 07:00:00	AAPL	Stock	26.32	26.325	26.275	26.285	25304.0
2016-09-09 07:30:00	AAPL	Stock	26.2875	26.305	26.2375	26.2875	108876.0
2016-09-09 08:00:00	AAPL	Stock	26.2675	26.3125	26.2275	26.25	382984.0
2016-09-09 08:30:00	AAPL	Stock	26.2425	26.25	26.2	26.22	347792.0
2016-09-09 09:00:00	AAPL	Stock	26.225	26.2675	26.1575	26.16	545888.0
2016-09-09 09:30:00	AAPL	Stock	26.16	26.43	26.1125	26.2812	26357992.0
2016-09-09 10:00:00	AAPL	Stock	26.2812	26.3325	26.2412	26.2925	10588296.0
2016-09-09 10:30:00	AAPL	Stock	26.29	26.3125	26.1775	26.2262	9335796.0
2016-09-09 11:00:00	AAPL	Stock	26.226	26.2375	26.1325	26.14	8555000.0
2016-09-09 11:30:00	AAPL	Stock	26.1375	26.165	26.0325	26.0562	11102144.0
2016-09-09 12:00:00	AAPL	Stock	26.055	26.06	25.895	25.9525	14591304.0
2016-09-09 12:30:00	AAPL	Stock	25.9538	25.9725	25.8875	25.9725	9229904.0
2016-09-09 13:00:00	AAPL	Stock	25.9712	25.9875	25.8855	25.926	6480056.0
2016-09-09 13:30:00	AAPL	Stock	25.925	25.9425	25.8375	25.8425	6933776.0
2016-09-09 14:00:00	AAPL	Stock	25.8428	25.905	25.7975	25.895	9727372.0
2016-09-09 14:30:00	AAPL	Stock	25.8975	25.9525	25.8675	25.935	9199800.0
2016-09-09 15:00:00	AAPL	Stock	25.935	26.005	25.885	25.97	10865164.0
2016-09-09 15:30:00	AAPL	Stock	25.9722	25.9788	25.785	25.785	20374684.0
2016-09-09 16:00:00	AAPL	Stock	25.785	25.8675	25.7775	25.815	16357124.0
2016-09-09 16:30:00	AAPL	Stock	25.8225	30.6338	25.8075	25.8075	121984.0
2016-09-09 17:00:00	AAPL	Stock	25.8075	25.835	25.79	25.81	172468.0
2016-09-09 17:30:00	AAPL	Stock	25.8075	25.8375	25.795	25.81	52588.0
2016-09-09 18:00:00	AAPL	Stock	25.8	25.81	25.7675	25.77	73116.0
2016-09-09 18:30:00	AAPL	Stock	25.775	25.7875	25.7675	25.7675	24992.0
2016-09-09 19:00:00	AAPL	Stock	25.765	25.7725	25.75	25.75	92112.0
2016-09-09 19:30:00	AAPL	Stock	25.75	25.75	25.7	25.7	79820.0
2016-09-09 07:30:00	MSFT	Stock	57.21	57.21	57.21	57.21	300.0
2016-09-09 08:00:00	MSFT	Stock	57.2	57.2	57.15	57.15	5964.0
2016-09-09 08:30:00	MSFT	Stock	57.1	57.14	57.05	57.05	16450.0
2016-09-09 09:00:00	MSFT	Stock	57.05	57.08	56.82	56.84	25242.0
2016-09-09 09:30:00	MSFT	Stock	56.83	57.27	56.73	57.261	3546048.0
2016-09-09 10:00:00	MSFT	Stock	57.28	57.52	57.26	57.38	1640018.0
2016-09-09 10:30:00	MSFT	Stock	57.38	57.461	57.11	57.18	1333393.0
2016-09-09 11:00:00	MSFT	Stock	57.18	57.27	57.12	57.25	1196082.0
2016-09-09 11:30:00	MSFT	Stock	57.24	57.28	56.95	56.985	1399611.0
2016-09-09 12:00:00	MSFT	Stock	56.985	57.065	56.82	56.92	1452663.0
2016-09-09 12:30:00	MSFT	Stock	56.91	57.02	56.825	56.91	1276628.0
2016-09-09 13:00:00	MSFT	Stock	56.915	56.94	56.77	56.8	1256687.0
2016-09-09 13:30:00	MSFT	Stock	56.806	56.81	56.66	56.71	1389162.0
2016-09-09 14:00:00	MSFT	Stock	56.715	56.737	56.55	56.737	1699515.0
2016-09-09 14:30:00	MSFT	Stock	56.73	56.78	56.44	56.66	2318477.0
2016-09-09 15:00:00	MSFT	Stock	56.67	56.72	56.48	56.69	2136771.0
2016-09-09 15:30:00	MSFT	Stock	56.699	56.7	56.21	56.22	5684529.0
2016-09-09 16:00:00	MSFT	Stock	56.22	56.4	56.21	56.38	5793000.0
2016-09-09 16:30:00	MSFT	Stock	56.36	56.39	56.23	56.23	573046.0

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

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