PREVIEW / stock_30min / 2015-03-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-06.parquet
  size:    1.6 MB
  rows:    84,709
  symbols: 3,516

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-03-06 04:00:00	AAPL	Stock	31.5625	31.65	31.5625	31.6325	18000.0
2015-03-06 04:30:00	AAPL	Stock	31.6375	31.6375	31.625	31.625	2000.0
2015-03-06 05:00:00	AAPL	Stock	31.6425	31.65	31.625	31.65	23832.0
2015-03-06 05:30:00	AAPL	Stock	31.685	31.685	31.63	31.63	2000.0
2015-03-06 06:00:00	AAPL	Stock	31.63	31.665	31.625	31.6375	67012.0
2015-03-06 06:30:00	AAPL	Stock	31.6375	31.6475	31.6225	31.625	5880.0
2015-03-06 07:00:00	AAPL	Stock	31.625	31.775	31.625	31.72	192328.0
2015-03-06 07:30:00	AAPL	Stock	31.725	31.8675	31.7075	31.825	221436.0
2015-03-06 08:00:00	AAPL	Stock	31.815	31.85	31.625	31.785	706492.0
2015-03-06 08:30:00	AAPL	Stock	31.7772	31.81	31.675	31.7825	1010080.0
2015-03-06 09:00:00	AAPL	Stock	31.7875	32.4625	31.7875	32.0775	11289164.0
2015-03-06 09:30:00	AAPL	Stock	32.1225	32.3425	31.8725	32.3013	54321580.0
2015-03-06 10:00:00	AAPL	Stock	32.3025	32.3425	32.1525	32.165	29949448.0
2015-03-06 10:30:00	AAPL	Stock	32.165	32.2325	32.0775	32.155	18030916.0
2015-03-06 11:00:00	AAPL	Stock	32.1528	32.155	31.94	31.9625	17336336.0
2015-03-06 11:30:00	AAPL	Stock	31.9675	31.9675	31.83	31.946	18225820.0
2015-03-06 12:00:00	AAPL	Stock	31.9472	32.0422	31.865	31.9075	14637952.0
2015-03-06 12:30:00	AAPL	Stock	31.905	31.9722	31.85	31.882	9294228.0
2015-03-06 13:00:00	AAPL	Stock	31.8838	31.915	31.7025	31.7755	13033204.0
2015-03-06 13:30:00	AAPL	Stock	31.775	31.8125	31.7275	31.775	8422144.0
2015-03-06 14:00:00	AAPL	Stock	31.7725	31.91	31.7375	31.7625	13355084.0
2015-03-06 14:30:00	AAPL	Stock	31.76	31.795	31.6825	31.69	11299552.0
2015-03-06 15:00:00	AAPL	Stock	31.6918	31.8175	31.63	31.6458	13433076.0
2015-03-06 15:30:00	AAPL	Stock	31.6475	31.68	31.565	31.6475	27073452.0
2015-03-06 16:00:00	AAPL	Stock	31.65	31.6875	31.63	31.6875	11131248.0
2015-03-06 16:30:00	AAPL	Stock	31.6925	31.967	31.6462	31.7175	1558028.0
2015-03-06 17:00:00	AAPL	Stock	31.7225	31.9205	31.65	31.71	337544.0
2015-03-06 17:30:00	AAPL	Stock	31.6975	31.7375	31.6875	31.72	119760.0
2015-03-06 18:00:00	AAPL	Stock	31.725	31.7575	31.725	31.7575	118584.0
2015-03-06 18:30:00	AAPL	Stock	31.75	31.7675	31.7425	31.7675	119564.0
2015-03-06 19:00:00	AAPL	Stock	31.7625	31.77	31.755	31.7675	53772.0
2015-03-06 19:30:00	AAPL	Stock	31.765	31.7775	31.745	31.7625	103684.0
2015-03-06 08:00:00	MSFT	Stock	43.02	43.06	43.02	43.06	1350.0
2015-03-06 08:30:00	MSFT	Stock	43.06	43.1	42.9	42.95	7248.0
2015-03-06 09:00:00	MSFT	Stock	42.949	43.0	42.78	42.86	148563.0
2015-03-06 09:30:00	MSFT	Stock	43.0	43.11	42.79	42.98	3303098.0
2015-03-06 10:00:00	MSFT	Stock	42.98	43.025	42.88	42.88	1624501.0
2015-03-06 10:30:00	MSFT	Stock	42.88	42.95	42.653	42.676	2097059.0
2015-03-06 11:00:00	MSFT	Stock	42.675	42.68	42.5	42.505	2768014.0
2015-03-06 11:30:00	MSFT	Stock	42.505	42.51	42.3	42.374	2379803.0
2015-03-06 12:00:00	MSFT	Stock	42.375	42.47	42.25	42.345	2407372.0
2015-03-06 12:30:00	MSFT	Stock	42.34	42.38	42.25	42.29	1965478.0
2015-03-06 13:00:00	MSFT	Stock	42.3	42.34	42.23	42.296	1612224.0
2015-03-06 13:30:00	MSFT	Stock	42.29	42.299	42.16	42.25	1505355.0
2015-03-06 14:00:00	MSFT	Stock	42.25	42.39	42.21	42.255	1727036.0
2015-03-06 14:30:00	MSFT	Stock	42.255	42.27	42.15	42.21	1613977.0
2015-03-06 15:00:00	MSFT	Stock	42.21	42.38	42.21	42.283	2289731.0
2015-03-06 15:30:00	MSFT	Stock	42.285	42.38	42.22	42.365	3698092.0
2015-03-06 16:00:00	MSFT	Stock	42.36	42.483	42.254	42.36	4627220.0
2015-03-06 16:30:00	MSFT	Stock	42.486	42.486	42.304	42.36	367649.0

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

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