PREVIEW / stock_30min / 2016-01-05

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-05.parquet
  size:    1.6 MB
  rows:    82,552
  symbols: 3,382

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-01-05 04:00:00	AAPL	Stock	26.37	26.37	26.3175	26.3175	800.0
2016-01-05 04:30:00	AAPL	Stock	26.3175	26.32	26.31	26.32	3896.0
2016-01-05 05:00:00	AAPL	Stock	26.3075	26.32	26.25	26.25	9728.0
2016-01-05 05:30:00	AAPL	Stock	26.25	26.25	26.225	26.225	1600.0
2016-01-05 06:00:00	AAPL	Stock	26.285	26.285	26.2375	26.2375	800.0
2016-01-05 06:30:00	AAPL	Stock	26.28	26.285	26.2625	26.2625	1600.0
2016-01-05 07:00:00	AAPL	Stock	26.2625	26.32	26.225	26.2625	45684.0
2016-01-05 07:30:00	AAPL	Stock	26.2525	26.255	26.175	26.255	86356.0
2016-01-05 08:00:00	AAPL	Stock	26.2475	26.37	26.1875	26.3	247036.0
2016-01-05 08:30:00	AAPL	Stock	26.3275	26.3625	26.2875	26.3375	321200.0
2016-01-05 09:00:00	AAPL	Stock	26.35	26.435	26.28	26.435	303792.0
2016-01-05 09:30:00	AAPL	Stock	26.4375	26.4625	26.025	26.0345	22159956.0
2016-01-05 10:00:00	AAPL	Stock	26.03	26.0925	25.9575	26.051	12397440.0
2016-01-05 10:30:00	AAPL	Stock	26.0517	26.2375	26.0475	26.1238	9975308.0
2016-01-05 11:00:00	AAPL	Stock	26.1238	26.1375	25.9675	25.98	8974756.0
2016-01-05 11:30:00	AAPL	Stock	25.9825	26.0725	25.9725	26.0225	5721660.0
2016-01-05 12:00:00	AAPL	Stock	26.0238	26.025	25.6025	25.7752	36209160.0
2016-01-05 12:30:00	AAPL	Stock	25.775	25.89	25.68	25.7562	15368828.0
2016-01-05 13:00:00	AAPL	Stock	25.76	25.8325	25.6875	25.7588	10345920.0
2016-01-05 13:30:00	AAPL	Stock	25.7588	25.9375	25.735	25.87	11785984.0
2016-01-05 14:00:00	AAPL	Stock	25.8712	25.935	25.8038	25.8888	10044640.0
2016-01-05 14:30:00	AAPL	Stock	25.8875	25.8925	25.7273	25.75	10299604.0
2016-01-05 15:00:00	AAPL	Stock	25.75	25.7725	25.6538	25.701	13884688.0
2016-01-05 15:30:00	AAPL	Stock	25.7025	25.735	25.65	25.6775	22094808.0
2016-01-05 16:00:00	AAPL	Stock	25.6775	25.705	25.6775	25.6875	12223628.0
2016-01-05 16:30:00	AAPL	Stock	25.6875	25.6975	25.6275	25.6275	1066884.0
2016-01-05 17:00:00	AAPL	Stock	25.6275	25.6275	25.5275	25.56	232820.0
2016-01-05 17:30:00	AAPL	Stock	25.56	25.6025	25.55	25.6025	80180.0
2016-01-05 18:00:00	AAPL	Stock	25.5925	25.635	25.59	25.595	52788.0
2016-01-05 18:30:00	AAPL	Stock	25.595	25.6175	25.5825	25.595	29736.0
2016-01-05 19:00:00	AAPL	Stock	25.595	25.595	25.5625	25.5725	72912.0
2016-01-05 19:30:00	AAPL	Stock	25.575	25.5825	25.5575	25.5625	76972.0
2016-01-05 04:00:00	MSFT	Stock	54.77	54.77	54.77	54.77	200.0
2016-01-05 06:00:00	MSFT	Stock	54.38	54.38	54.38	54.38	300.0
2016-01-05 06:30:00	MSFT	Stock	54.59	54.59	54.59	54.59	100.0
2016-01-05 07:00:00	MSFT	Stock	54.48	54.48	54.48	54.48	500.0
2016-01-05 07:30:00	MSFT	Stock	54.62	54.7	54.55	54.7	6151.0
2016-01-05 08:00:00	MSFT	Stock	54.7	55.05	54.7	54.9	51707.0
2016-01-05 08:30:00	MSFT	Stock	54.91	55.0	54.88	55.0	15307.0
2016-01-05 09:00:00	MSFT	Stock	54.96	55.07	54.8	54.93	27986.0
2016-01-05 09:30:00	MSFT	Stock	54.91	55.33	54.77	55.03	3540083.0
2016-01-05 10:00:00	MSFT	Stock	55.03	55.15	54.89	54.97	2320630.0
2016-01-05 10:30:00	MSFT	Stock	54.96	55.19	54.75	55.07	2087642.0
2016-01-05 11:00:00	MSFT	Stock	55.07	55.15	54.815	54.98	1801636.0
2016-01-05 11:30:00	MSFT	Stock	54.98	55.14	54.96	55.035	1596737.0
2016-01-05 12:00:00	MSFT	Stock	55.04	55.04	54.765	54.826	1850305.0
2016-01-05 12:30:00	MSFT	Stock	54.825	54.9	54.54	54.9	1691994.0
2016-01-05 13:00:00	MSFT	Stock	54.89	54.99	54.78	54.93	1479503.0
2016-01-05 13:30:00	MSFT	Stock	54.934	55.19	54.93	55.106	1523184.0
2016-01-05 14:00:00	MSFT	Stock	55.103	55.39	55.09	55.3	1793918.0

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

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