PREVIEW / stock_30min / 2017-02-14

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-14.parquet
  size:    1.6 MB
  rows:    82,304
  symbols: 3,102

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
2017-02-14 04:00:00	AAPL	Stock	33.2675	33.3425	33.2675	33.3425	1852.0
2017-02-14 04:30:00	AAPL	Stock	33.3725	33.3725	33.3725	33.3725	444.0
2017-02-14 05:00:00	AAPL	Stock	33.3625	33.3625	33.35	33.3625	7368.0
2017-02-14 05:30:00	AAPL	Stock	33.3625	33.3625	33.3425	33.3425	844.0
2017-02-14 06:00:00	AAPL	Stock	33.345	33.41	33.3425	33.3525	22448.0
2017-02-14 06:30:00	AAPL	Stock	33.385	33.385	33.385	33.385	2256.0
2017-02-14 07:00:00	AAPL	Stock	33.3625	33.4125	33.3625	33.38	17352.0
2017-02-14 07:30:00	AAPL	Stock	33.3975	33.42	33.3975	33.4	22468.0
2017-02-14 08:00:00	AAPL	Stock	33.395	33.4075	33.25	33.3475	201088.0
2017-02-14 08:30:00	AAPL	Stock	33.3425	33.3425	33.2775	33.28	163284.0
2017-02-14 09:00:00	AAPL	Stock	33.3	33.3775	33.2575	33.365	277696.0
2017-02-14 09:30:00	AAPL	Stock	33.3575	33.435	33.3125	33.3938	15506724.0
2017-02-14 10:00:00	AAPL	Stock	33.3925	33.4675	33.34	33.465	8984384.0
2017-02-14 10:30:00	AAPL	Stock	33.465	33.4675	33.3525	33.435	6741936.0
2017-02-14 11:00:00	AAPL	Stock	33.435	33.5575	33.42	33.5575	9625196.0
2017-02-14 11:30:00	AAPL	Stock	33.5575	33.5975	33.5075	33.57	6562748.0
2017-02-14 12:00:00	AAPL	Stock	33.5725	33.595	33.5425	33.565	3824360.0
2017-02-14 12:30:00	AAPL	Stock	33.5675	33.675	33.5625	33.6625	5957344.0
2017-02-14 13:00:00	AAPL	Stock	33.6625	33.7325	33.655	33.67	7659540.0
2017-02-14 13:30:00	AAPL	Stock	33.6725	33.7375	33.67	33.7272	4931216.0
2017-02-14 14:00:00	AAPL	Stock	33.725	33.7265	33.6875	33.7225	3977828.0
2017-02-14 14:30:00	AAPL	Stock	33.725	33.75	33.705	33.715	7071028.0
2017-02-14 15:00:00	AAPL	Stock	33.715	33.7375	33.695	33.735	4859016.0
2017-02-14 15:30:00	AAPL	Stock	33.7358	33.7725	33.725	33.7525	17150748.0
2017-02-14 16:00:00	AAPL	Stock	33.7325	33.765	33.705	33.7625	10534464.0
2017-02-14 16:30:00	AAPL	Stock	33.7625	33.825	33.7625	33.8225	436668.0
2017-02-14 17:00:00	AAPL	Stock	33.8175	33.8725	33.795	33.815	410616.0
2017-02-14 17:30:00	AAPL	Stock	33.8125	33.8175	33.805	33.805	74184.0
2017-02-14 18:00:00	AAPL	Stock	33.8125	33.8175	33.775	33.805	74292.0
2017-02-14 18:30:00	AAPL	Stock	33.8075	33.855	33.8075	33.82	110252.0
2017-02-14 19:00:00	AAPL	Stock	33.825	33.855	33.825	33.855	71868.0
2017-02-14 19:30:00	AAPL	Stock	33.85	33.86	33.8325	33.86	147488.0
2017-02-14 04:00:00	MSFT	Stock	64.5	64.5	64.5	64.5	100.0
2017-02-14 04:30:00	MSFT	Stock	64.5	64.5	64.5	64.5	100.0
2017-02-14 05:30:00	MSFT	Stock	64.5	64.5	64.5	64.5	284.0
2017-02-14 07:00:00	MSFT	Stock	64.48	64.49	64.48	64.48	1472.0
2017-02-14 07:30:00	MSFT	Stock	64.5	64.5	64.5	64.5	500.0
2017-02-14 08:00:00	MSFT	Stock	64.48	64.51	64.47	64.47	3020.0
2017-02-14 08:30:00	MSFT	Stock	64.47	64.47	64.43	64.43	4700.0
2017-02-14 09:00:00	MSFT	Stock	64.44	64.59	64.42	64.55	50799.0
2017-02-14 09:30:00	MSFT	Stock	64.55	64.72	64.185	64.25	2597437.0
2017-02-14 10:00:00	MSFT	Stock	64.245	64.28	64.03	64.04	1628234.0
2017-02-14 10:30:00	MSFT	Stock	64.04	64.25	64.02	64.21	1274798.0
2017-02-14 11:00:00	MSFT	Stock	64.2	64.25	64.1	64.24	913338.0
2017-02-14 11:30:00	MSFT	Stock	64.23	64.29	64.2	64.21	775544.0
2017-02-14 12:00:00	MSFT	Stock	64.215	64.27	64.19	64.23	469187.0
2017-02-14 12:30:00	MSFT	Stock	64.23	64.4	64.205	64.36	755236.0
2017-02-14 13:00:00	MSFT	Stock	64.357	64.43	64.33	64.405	592688.0
2017-02-14 13:30:00	MSFT	Stock	64.405	64.43	64.35	64.41	779502.0
2017-02-14 14:00:00	MSFT	Stock	64.404	64.49	64.39	64.405	839996.0

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

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