PREVIEW / stock_30min / 2015-12-18

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-12-18.parquet
  size:    1.6 MB
  rows:    84,152
  symbols: 3,443

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-12-18 04:00:00	AAPL	Stock	27.5	27.5	27.09	27.155	10696.0
2015-12-18 04:30:00	AAPL	Stock	27.13	27.175	27.0925	27.1625	25600.0
2015-12-18 05:00:00	AAPL	Stock	27.15	27.15	27.145	27.15	5344.0
2015-12-18 05:30:00	AAPL	Stock	27.16	27.1775	27.16	27.1775	1200.0
2015-12-18 06:00:00	AAPL	Stock	27.1875	27.1875	27.14	27.14	12000.0
2015-12-18 06:30:00	AAPL	Stock	27.1825	27.22	27.12	27.12	10080.0
2015-12-18 07:00:00	AAPL	Stock	27.1625	27.1625	27.0925	27.105	92204.0
2015-12-18 07:30:00	AAPL	Stock	27.11	27.1575	27.09	27.1475	161056.0
2015-12-18 08:00:00	AAPL	Stock	27.1425	27.1525	26.75	27.15	336236.0
2015-12-18 08:30:00	AAPL	Stock	27.1425	27.17	27.12	27.17	103984.0
2015-12-18 09:00:00	AAPL	Stock	27.17	27.3525	27.15	27.1575	1061464.0
2015-12-18 09:30:00	AAPL	Stock	27.2275	27.38	27.115	27.3175	52621224.0
2015-12-18 10:00:00	AAPL	Stock	27.3175	27.3225	27.08	27.095	15173568.0
2015-12-18 10:30:00	AAPL	Stock	27.094	27.1375	26.915	27.017	18638888.0
2015-12-18 11:00:00	AAPL	Stock	27.0175	27.07	26.9425	26.955	11464168.0
2015-12-18 11:30:00	AAPL	Stock	26.955	26.9825	26.785	26.835	12602216.0
2015-12-18 12:00:00	AAPL	Stock	26.8365	26.885	26.6925	26.7025	15411904.0
2015-12-18 12:30:00	AAPL	Stock	26.7055	26.73	26.6	26.6022	17830120.0
2015-12-18 13:00:00	AAPL	Stock	26.6	26.86	26.6	26.69	15330864.0
2015-12-18 13:30:00	AAPL	Stock	26.6882	26.8275	26.6675	26.8075	10987432.0
2015-12-18 14:00:00	AAPL	Stock	26.8075	26.875	26.725	26.79	11060712.0
2015-12-18 14:30:00	AAPL	Stock	26.79	26.7912	26.6375	26.6425	11724716.0
2015-12-18 15:00:00	AAPL	Stock	26.6425	26.6875	26.4525	26.5625	23118240.0
2015-12-18 15:30:00	AAPL	Stock	26.565	26.62	26.455	26.4725	30759004.0
2015-12-18 16:00:00	AAPL	Stock	26.5075	26.6765	26.46	26.5075	96639292.0
2015-12-18 16:30:00	AAPL	Stock	26.535	26.605	26.5075	26.58	330768.0
2015-12-18 17:00:00	AAPL	Stock	26.505	26.605	26.505	26.6	156876.0
2015-12-18 17:30:00	AAPL	Stock	26.6025	26.6075	26.58	26.585	136400.0
2015-12-18 18:00:00	AAPL	Stock	26.5775	26.6	26.5775	26.5925	30040.0
2015-12-18 18:30:00	AAPL	Stock	26.5875	26.6	26.58	26.5875	53352.0
2015-12-18 19:00:00	AAPL	Stock	26.595	26.605	26.5875	26.6	20000.0
2015-12-18 19:30:00	AAPL	Stock	26.6	26.605	26.5825	26.5825	43504.0
2015-12-18 04:00:00	MSFT	Stock	55.5	55.75	55.5	55.6	5300.0
2015-12-18 05:30:00	MSFT	Stock	55.57	55.57	55.57	55.57	900.0
2015-12-18 06:00:00	MSFT	Stock	55.57	55.66	55.57	55.63	4700.0
2015-12-18 06:30:00	MSFT	Stock	55.63	55.63	55.56	55.63	4100.0
2015-12-18 07:00:00	MSFT	Stock	55.63	55.63	55.5	55.5	3400.0
2015-12-18 07:30:00	MSFT	Stock	55.65	55.65	55.56	55.56	4000.0
2015-12-18 08:00:00	MSFT	Stock	55.62	55.75	55.56	55.75	10704.0
2015-12-18 08:30:00	MSFT	Stock	55.75	55.87	55.7	55.85	12700.0
2015-12-18 09:00:00	MSFT	Stock	55.85	56.15	55.72	55.72	192194.0
2015-12-18 09:30:00	MSFT	Stock	55.83	56.0	55.21	55.27	14146183.0
2015-12-18 10:00:00	MSFT	Stock	55.28	55.32	54.9	55.0	6464018.0
2015-12-18 10:30:00	MSFT	Stock	54.99	55.226	54.85	55.095	3640985.0
2015-12-18 11:00:00	MSFT	Stock	55.1	55.22	54.99	55.04	2290214.0
2015-12-18 11:30:00	MSFT	Stock	55.03	55.21	55.01	55.07	1748530.0
2015-12-18 12:00:00	MSFT	Stock	55.07	55.1	54.96	55.0	1859806.0
2015-12-18 12:30:00	MSFT	Stock	55.0	55.0	54.73	54.81	2585107.0
2015-12-18 13:00:00	MSFT	Stock	54.8	55.055	54.75	54.85	1795544.0
2015-12-18 13:30:00	MSFT	Stock	54.86	55.03	54.78	54.97	1656227.0

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

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