PREVIEW / stock_30min / 2017-02-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-03.parquet
  size:    1.6 MB
  rows:    81,678
  symbols: 3,120

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-03 05:00:00	AAPL	Stock	32.01	32.01	32.01	32.01	400.0
2017-02-03 06:00:00	AAPL	Stock	32.07	32.07	32.07	32.07	400.0
2017-02-03 06:30:00	AAPL	Stock	32.0875	32.0875	32.0875	32.0875	5480.0
2017-02-03 07:00:00	AAPL	Stock	32.0875	32.1075	32.0875	32.1075	11268.0
2017-02-03 07:30:00	AAPL	Stock	32.1225	32.1225	32.1	32.12	12304.0
2017-02-03 08:00:00	AAPL	Stock	32.1175	32.13	32.03	32.075	234404.0
2017-02-03 08:30:00	AAPL	Stock	32.07	32.17	32.07	32.1375	135304.0
2017-02-03 09:00:00	AAPL	Stock	32.1375	32.1425	32.075	32.105	285580.0
2017-02-03 09:30:00	AAPL	Stock	32.0775	32.279	32.04	32.2537	15646628.0
2017-02-03 10:00:00	AAPL	Stock	32.255	32.2975	32.2025	32.2575	8689824.0
2017-02-03 10:30:00	AAPL	Stock	32.2575	32.27	32.1685	32.1775	5125000.0
2017-02-03 11:00:00	AAPL	Stock	32.1775	32.23	32.1312	32.1425	4361620.0
2017-02-03 11:30:00	AAPL	Stock	32.1425	32.1625	32.085	32.105	4205268.0
2017-02-03 12:00:00	AAPL	Stock	32.1075	32.15	32.0925	32.125	2914628.0
2017-02-03 12:30:00	AAPL	Stock	32.125	32.13	32.1025	32.1125	2329724.0
2017-02-03 13:00:00	AAPL	Stock	32.1112	32.1275	32.0908	32.1188	2755988.0
2017-02-03 13:30:00	AAPL	Stock	32.12	32.1275	32.086	32.1125	3552616.0
2017-02-03 14:00:00	AAPL	Stock	32.1142	32.1425	32.1125	32.1225	3895720.0
2017-02-03 14:30:00	AAPL	Stock	32.1235	32.175	32.123	32.1725	3786876.0
2017-02-03 15:00:00	AAPL	Stock	32.1718	32.245	32.1608	32.22	5983828.0
2017-02-03 15:30:00	AAPL	Stock	32.22	32.27	32.2075	32.2675	14232416.0
2017-02-03 16:00:00	AAPL	Stock	32.2675	32.275	32.2375	32.255	10187528.0
2017-02-03 16:30:00	AAPL	Stock	32.2575	32.2975	32.1195	32.2575	134224.0
2017-02-03 17:00:00	AAPL	Stock	32.2625	32.2825	32.26	32.2825	22396.0
2017-02-03 17:30:00	AAPL	Stock	32.285	32.2925	32.2675	32.275	44308.0
2017-02-03 18:00:00	AAPL	Stock	32.2825	32.285	32.27	32.275	6632.0
2017-02-03 18:30:00	AAPL	Stock	32.2725	32.29	32.2725	32.29	13852.0
2017-02-03 19:00:00	AAPL	Stock	32.2875	32.3	32.2875	32.2975	12440.0
2017-02-03 19:30:00	AAPL	Stock	32.2875	32.3	32.28	32.2975	25748.0
2017-02-03 04:30:00	MSFT	Stock	63.18	63.18	63.18	63.18	152.0
2017-02-03 05:30:00	MSFT	Stock	63.1	63.1	63.1	63.1	180.0
2017-02-03 06:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	160.0
2017-02-03 06:30:00	MSFT	Stock	63.19	63.19	63.19	63.19	349.0
2017-02-03 07:00:00	MSFT	Stock	63.35	63.35	63.25	63.25	5855.0
2017-02-03 07:30:00	MSFT	Stock	63.29	63.29	63.25	63.28	352.0
2017-02-03 08:00:00	MSFT	Stock	63.29	63.35	63.25	63.34	26559.0
2017-02-03 08:30:00	MSFT	Stock	63.33	63.5	63.33	63.41	30951.0
2017-02-03 09:00:00	MSFT	Stock	63.5	63.54	63.26	63.5	37631.0
2017-02-03 09:30:00	MSFT	Stock	63.5	63.64	63.14	63.415	3935061.0
2017-02-03 10:00:00	MSFT	Stock	63.42	63.52	63.22	63.3	2141050.0
2017-02-03 10:30:00	MSFT	Stock	63.3	63.36	63.165	63.22	1957992.0
2017-02-03 11:00:00	MSFT	Stock	63.22	63.33	63.16	63.215	1765870.0
2017-02-03 11:30:00	MSFT	Stock	63.21	63.23	63.07	63.22	1086854.0
2017-02-03 12:00:00	MSFT	Stock	63.23	63.33	63.2	63.206	1725146.0
2017-02-03 12:30:00	MSFT	Stock	63.205	63.31	63.19	63.23	973731.0
2017-02-03 13:00:00	MSFT	Stock	63.24	63.34	63.16	63.31	852351.0
2017-02-03 13:30:00	MSFT	Stock	63.31	63.325	63.23	63.29	1081777.0
2017-02-03 14:00:00	MSFT	Stock	63.285	63.45	63.27	63.405	1844714.0
2017-02-03 14:30:00	MSFT	Stock	63.41	63.7	63.405	63.59	2898131.0
2017-02-03 15:00:00	MSFT	Stock	63.585	63.68	63.531	63.68	1689687.0

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

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