PREVIEW / stock_30min / 2015-12-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-12-14.parquet
  size:    1.6 MB
  rows:    85,379
  symbols: 3,412

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-14 04:00:00	AAPL	Stock	28.4375	28.455	28.385	28.455	19000.0
2015-12-14 04:30:00	AAPL	Stock	28.425	28.4975	28.425	28.4775	8000.0
2015-12-14 05:00:00	AAPL	Stock	28.46	28.46	28.39	28.395	27280.0
2015-12-14 05:30:00	AAPL	Stock	28.415	28.4625	28.415	28.4625	5200.0
2015-12-14 06:00:00	AAPL	Stock	28.45	28.45	28.275	28.3	34304.0
2015-12-14 06:30:00	AAPL	Stock	28.34	28.34	28.1875	28.2125	249640.0
2015-12-14 07:00:00	AAPL	Stock	28.19	28.225	27.915	27.9725	494012.0
2015-12-14 07:30:00	AAPL	Stock	27.9625	27.995	27.725	27.8375	860688.0
2015-12-14 08:00:00	AAPL	Stock	27.775	28.1875	27.7475	27.8575	1236616.0
2015-12-14 08:30:00	AAPL	Stock	27.8825	28.0625	27.8375	27.965	1049760.0
2015-12-14 09:00:00	AAPL	Stock	27.965	28.0325	27.9	27.9975	842416.0
2015-12-14 09:30:00	AAPL	Stock	28.045	28.045	27.6525	27.7525	37926620.0
2015-12-14 10:00:00	AAPL	Stock	27.75	27.95	27.6825	27.7175	25751052.0
2015-12-14 10:30:00	AAPL	Stock	27.7188	27.8425	27.6825	27.7875	15839532.0
2015-12-14 11:00:00	AAPL	Stock	27.785	27.795	27.5792	27.5945	16456564.0
2015-12-14 11:30:00	AAPL	Stock	27.59	27.65	27.4475	27.6382	18666572.0
2015-12-14 12:00:00	AAPL	Stock	27.6432	27.845	27.585	27.825	14789768.0
2015-12-14 12:30:00	AAPL	Stock	27.825	27.865	27.72	27.825	12089644.0
2015-12-14 13:00:00	AAPL	Stock	27.8225	27.915	27.815	27.8625	9487936.0
2015-12-14 13:30:00	AAPL	Stock	27.8625	28.1625	27.85	28.115	16028744.0
2015-12-14 14:00:00	AAPL	Stock	28.1175	28.17	27.9848	27.9975	12200032.0
2015-12-14 14:30:00	AAPL	Stock	28.0	28.07	27.9175	28.0588	10135636.0
2015-12-14 15:00:00	AAPL	Stock	28.06	28.0775	27.9025	28.01	11419352.0
2015-12-14 15:30:00	AAPL	Stock	28.0075	28.125	27.93	28.1175	21348892.0
2015-12-14 16:00:00	AAPL	Stock	28.12	28.12	27.6862	28.105	9851176.0
2015-12-14 16:30:00	AAPL	Stock	28.105	28.135	28.105	28.1325	128016.0
2015-12-14 17:00:00	AAPL	Stock	28.125	28.125	28.04	28.04	817876.0
2015-12-14 17:30:00	AAPL	Stock	28.0475	28.075	27.9625	28.0	182680.0
2015-12-14 18:00:00	AAPL	Stock	28.0	28.0675	28.0	28.0625	42024.0
2015-12-14 18:30:00	AAPL	Stock	28.0675	28.0825	28.0425	28.0425	44592.0
2015-12-14 19:00:00	AAPL	Stock	28.075	28.08	28.065	28.065	31200.0
2015-12-14 19:30:00	AAPL	Stock	28.08	28.0875	28.0525	28.075	39384.0
2015-12-14 04:00:00	MSFT	Stock	54.39	54.39	54.38	54.39	1600.0
2015-12-14 06:30:00	MSFT	Stock	53.95	54.17	53.95	54.17	7529.0
2015-12-14 07:00:00	MSFT	Stock	54.16	54.17	53.87	53.87	10691.0
2015-12-14 07:30:00	MSFT	Stock	53.9	54.1	53.88	54.05	22090.0
2015-12-14 08:00:00	MSFT	Stock	54.0	54.1	53.87	54.06	26651.0
2015-12-14 08:30:00	MSFT	Stock	54.11	54.36	54.05	54.25	19200.0
2015-12-14 09:00:00	MSFT	Stock	54.25	54.33	54.12	54.22	32122.0
2015-12-14 09:30:00	MSFT	Stock	54.33	54.37	53.73	53.76	5094137.0
2015-12-14 10:00:00	MSFT	Stock	53.77	54.43	53.68	53.78	4507150.0
2015-12-14 10:30:00	MSFT	Stock	53.79	54.3	53.77	54.065	3427371.0
2015-12-14 11:00:00	MSFT	Stock	54.07	54.12	53.895	54.07	2078204.0
2015-12-14 11:30:00	MSFT	Stock	54.07	54.31	53.88	54.25	2544794.0
2015-12-14 12:00:00	MSFT	Stock	54.25	54.5	54.05	54.47	2028967.0
2015-12-14 12:30:00	MSFT	Stock	54.48	54.59	54.345	54.54	1951398.0
2015-12-14 13:00:00	MSFT	Stock	54.54	54.695	54.5	54.64	1774311.0
2015-12-14 13:30:00	MSFT	Stock	54.64	54.68	54.41	54.63	1548952.0
2015-12-14 14:00:00	MSFT	Stock	54.63	54.69	54.48	54.62	1791103.0
2015-12-14 14:30:00	MSFT	Stock	54.62	54.95	54.545	54.89	2075820.0

> showing 50 of 85,379 rows — these rows as CSV

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