PREVIEW / stock_30min / 2014-06-17

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-17.parquet
  size:    1.6 MB
  rows:    82,150
  symbols: 3,553

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-06-17 04:00:00	AAPL	Stock	23.0825	23.1875	23.0825	23.1225	31056.0
2014-06-17 04:30:00	AAPL	Stock	23.1325	23.145	23.125	23.145	8160.0
2014-06-17 05:00:00	AAPL	Stock	23.125	23.1475	23.125	23.125	7992.0
2014-06-17 05:30:00	AAPL	Stock	23.13	23.1475	23.13	23.1475	5104.0
2014-06-17 06:00:00	AAPL	Stock	23.1325	23.1475	23.125	23.145	29392.0
2014-06-17 06:30:00	AAPL	Stock	23.1375	23.1375	23.135	23.135	840.0
2014-06-17 07:00:00	AAPL	Stock	23.1325	23.2	23.125	23.185	137156.0
2014-06-17 07:30:00	AAPL	Stock	23.1875	23.195	23.1	23.15	125092.0
2014-06-17 08:00:00	AAPL	Stock	23.1475	23.1975	23.125	23.16	414448.0
2014-06-17 08:30:00	AAPL	Stock	23.1525	23.1575	23.075	23.0825	418108.0
2014-06-17 09:00:00	AAPL	Stock	23.0875	23.125	23.0725	23.0925	200076.0
2014-06-17 09:30:00	AAPL	Stock	23.0775	23.175	22.965	23.0722	21862068.0
2014-06-17 10:00:00	AAPL	Stock	23.0725	23.1	23.0275	23.065	9178400.0
2014-06-17 10:30:00	AAPL	Stock	23.065	23.085	23.0125	23.0208	6651236.0
2014-06-17 11:00:00	AAPL	Stock	23.02	23.05	22.95	22.9825	7935572.0
2014-06-17 11:30:00	AAPL	Stock	22.985	23.06	22.975	23.0455	6803888.0
2014-06-17 12:00:00	AAPL	Stock	23.045	23.085	23.02	23.0602	5770232.0
2014-06-17 12:30:00	AAPL	Stock	23.0625	23.0825	23.03	23.0638	4595692.0
2014-06-17 13:00:00	AAPL	Stock	23.0625	23.0675	23.0375	23.0443	3361116.0
2014-06-17 13:30:00	AAPL	Stock	23.045	23.105	23.04	23.09	4909336.0
2014-06-17 14:00:00	AAPL	Stock	23.0925	23.0925	23.0325	23.0625	5515976.0
2014-06-17 14:30:00	AAPL	Stock	23.06	23.0675	23.04	23.0425	3601180.0
2014-06-17 15:00:00	AAPL	Stock	23.045	23.05	22.9825	22.9962	6930936.0
2014-06-17 15:30:00	AAPL	Stock	22.9975	23.065	22.9925	23.02	12829784.0
2014-06-17 16:00:00	AAPL	Stock	23.02	23.088	23.005	23.0125	5866320.0
2014-06-17 16:30:00	AAPL	Stock	23.0175	23.0825	23.005	23.0825	50124.0
2014-06-17 17:00:00	AAPL	Stock	23.01	23.05	23.0075	23.0425	52140.0
2014-06-17 17:30:00	AAPL	Stock	23.0425	23.0425	23.02	23.02	14596.0
2014-06-17 18:00:00	AAPL	Stock	23.02	23.035	23.02	23.025	32156.0
2014-06-17 18:30:00	AAPL	Stock	23.025	23.0375	23.025	23.025	29760.0
2014-06-17 19:00:00	AAPL	Stock	23.015	23.025	23.015	23.0225	16092.0
2014-06-17 19:30:00	AAPL	Stock	23.0225	23.0225	22.995	23.0	61184.0
2014-06-17 05:30:00	MSFT	Stock	41.55	41.55	41.55	41.55	465.0
2014-06-17 07:00:00	MSFT	Stock	41.39	41.39	41.39	41.39	100.0
2014-06-17 08:00:00	MSFT	Stock	41.55	41.55	41.5	41.5	1203.0
2014-06-17 08:30:00	MSFT	Stock	41.5	41.5	41.5	41.5	300.0
2014-06-17 09:00:00	MSFT	Stock	41.45	41.47	41.24	41.32	26208.0
2014-06-17 09:30:00	MSFT	Stock	41.29	41.65	41.2	41.615	2750906.0
2014-06-17 10:00:00	MSFT	Stock	41.62	41.77	41.61	41.71	2231702.0
2014-06-17 10:30:00	MSFT	Stock	41.705	41.84	41.64	41.68	2073090.0
2014-06-17 11:00:00	MSFT	Stock	41.68	41.69	41.54	41.63	1384002.0
2014-06-17 11:30:00	MSFT	Stock	41.63	41.74	41.6	41.735	849559.0
2014-06-17 12:00:00	MSFT	Stock	41.73	41.74	41.68	41.703	527707.0
2014-06-17 12:30:00	MSFT	Stock	41.7	41.82	41.379	41.785	1009629.0
2014-06-17 13:00:00	MSFT	Stock	41.79	41.82	41.74	41.8	849331.0
2014-06-17 13:30:00	MSFT	Stock	41.8	41.91	41.782	41.795	1143783.0
2014-06-17 14:00:00	MSFT	Stock	41.8	41.85	41.76	41.82	736669.0
2014-06-17 14:30:00	MSFT	Stock	41.82	41.85	41.81	41.82	662875.0
2014-06-17 15:00:00	MSFT	Stock	41.83	41.83	40.335	41.7	1843606.0
2014-06-17 15:30:00	MSFT	Stock	41.7	41.76	41.66	41.68	3246515.0

> showing 50 of 82,150 rows — these rows as CSV

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