PREVIEW / stock_30min / 2016-07-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-21.parquet
  size:    1.6 MB
  rows:    81,654
  symbols: 3,249

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-07-21 05:00:00	AAPL	Stock	25.0	25.0	25.0	25.0	1056.0
2016-07-21 06:00:00	AAPL	Stock	25.07	25.07	25.07	25.07	2496.0
2016-07-21 06:30:00	AAPL	Stock	25.07	25.07	25.0225	25.0225	5760.0
2016-07-21 07:00:00	AAPL	Stock	25.05	25.05	25.025	25.025	9200.0
2016-07-21 07:30:00	AAPL	Stock	25.025	25.0375	25.025	25.03	19204.0
2016-07-21 08:00:00	AAPL	Stock	25.0125	25.045	25.0125	25.035	105080.0
2016-07-21 08:30:00	AAPL	Stock	25.0375	25.0575	25.03	25.0325	81512.0
2016-07-21 09:00:00	AAPL	Stock	25.035	25.0625	24.955	24.955	166064.0
2016-07-21 09:30:00	AAPL	Stock	24.955	25.25	24.955	25.1688	24192420.0
2016-07-21 10:00:00	AAPL	Stock	25.17	25.21	25.075	25.1045	10336544.0
2016-07-21 10:30:00	AAPL	Stock	25.105	25.1125	25.0125	25.02	9492532.0
2016-07-21 11:00:00	AAPL	Stock	25.018	25.06	25.0175	25.0435	4590804.0
2016-07-21 11:30:00	AAPL	Stock	25.045	25.045	24.9275	24.9575	7697496.0
2016-07-21 12:00:00	AAPL	Stock	24.955	24.9675	24.895	24.9278	5811608.0
2016-07-21 12:30:00	AAPL	Stock	24.9275	24.9325	24.85	24.885	6975292.0
2016-07-21 13:00:00	AAPL	Stock	24.885	24.935	24.865	24.925	3552912.0
2016-07-21 13:30:00	AAPL	Stock	24.9275	24.93	24.87	24.8925	5270116.0
2016-07-21 14:00:00	AAPL	Stock	24.8912	24.9	24.845	24.895	5049948.0
2016-07-21 14:30:00	AAPL	Stock	24.8945	24.9025	24.8425	24.8475	4482808.0
2016-07-21 15:00:00	AAPL	Stock	24.8475	24.8725	24.7825	24.865	8602108.0
2016-07-21 15:30:00	AAPL	Stock	24.8675	24.875	24.8288	24.855	10945516.0
2016-07-21 16:00:00	AAPL	Stock	24.8575	24.9015	24.7725	24.775	9055776.0
2016-07-21 16:30:00	AAPL	Stock	24.7725	24.8575	24.75	24.79	405696.0
2016-07-21 17:00:00	AAPL	Stock	24.7925	24.795	24.75	24.75	193620.0
2016-07-21 17:30:00	AAPL	Stock	24.79	24.79	24.7175	24.7375	132308.0
2016-07-21 18:00:00	AAPL	Stock	24.7275	24.785	24.7275	24.7575	38676.0
2016-07-21 18:30:00	AAPL	Stock	24.765	24.775	24.7625	24.7625	12332.0
2016-07-21 19:00:00	AAPL	Stock	24.775	24.7875	24.75	24.765	31136.0
2016-07-21 19:30:00	AAPL	Stock	24.7525	24.775	24.75	24.7725	37600.0
2016-07-21 04:00:00	MSFT	Stock	56.2	56.2	56.2	56.2	100.0
2016-07-21 04:30:00	MSFT	Stock	56.06	56.06	56.06	56.06	1000.0
2016-07-21 07:00:00	MSFT	Stock	56.05	56.06	56.05	56.05	4224.0
2016-07-21 07:30:00	MSFT	Stock	55.99	56.15	55.99	56.12	9400.0
2016-07-21 08:00:00	MSFT	Stock	56.09	56.12	55.8	56.04	15953.0
2016-07-21 08:30:00	MSFT	Stock	56.02	56.05	55.91	55.96	25004.0
2016-07-21 09:00:00	MSFT	Stock	55.92	56.04	55.91	56.04	11258.0
2016-07-21 09:30:00	MSFT	Stock	55.98	56.23	55.77	55.85	4818560.0
2016-07-21 10:00:00	MSFT	Stock	55.82	56.2	55.76	56.085	2953296.0
2016-07-21 10:30:00	MSFT	Stock	56.09	56.13	56.0	56.064	1574901.0
2016-07-21 11:00:00	MSFT	Stock	56.07	56.09	55.96	56.045	1483688.0
2016-07-21 11:30:00	MSFT	Stock	56.049	56.07	55.875	56.01	1682467.0
2016-07-21 12:00:00	MSFT	Stock	56.007	56.02	55.88	55.945	1182459.0
2016-07-21 12:30:00	MSFT	Stock	55.94	56.0	55.875	55.925	1760093.0
2016-07-21 13:00:00	MSFT	Stock	55.925	56.04	55.92	56.005	1616154.0
2016-07-21 13:30:00	MSFT	Stock	56.01	56.05	55.96	56.045	1285343.0
2016-07-21 14:00:00	MSFT	Stock	56.04	56.05	55.96	55.975	1314612.0
2016-07-21 14:30:00	MSFT	Stock	55.975	56.015	55.91	55.965	1122259.0
2016-07-21 15:00:00	MSFT	Stock	55.96	55.965	55.85	55.86	2344097.0
2016-07-21 15:30:00	MSFT	Stock	55.86	55.93	55.77	55.81	5796566.0
2016-07-21 16:00:00	MSFT	Stock	55.8	55.976	55.77	55.79	2196520.0

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

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