PREVIEW / stock_30min / 2017-03-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-16.parquet
  size:    1.6 MB
  rows:    81,906
  symbols: 3,089

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-03-16 04:00:00	AAPL	Stock	35.1875	35.2375	35.1875	35.2375	2400.0
2017-03-16 04:30:00	AAPL	Stock	35.245	35.245	35.225	35.225	7588.0
2017-03-16 05:00:00	AAPL	Stock	35.22	35.25	35.22	35.25	13100.0
2017-03-16 05:30:00	AAPL	Stock	35.2375	35.2375	35.21	35.21	6168.0
2017-03-16 06:00:00	AAPL	Stock	35.2225	35.2225	35.1975	35.1975	12792.0
2017-03-16 06:30:00	AAPL	Stock	35.215	35.2175	35.175	35.1875	13800.0
2017-03-16 07:00:00	AAPL	Stock	35.1875	35.2	35.1775	35.1975	31372.0
2017-03-16 07:30:00	AAPL	Stock	35.1875	35.1925	35.1725	35.1875	32312.0
2017-03-16 08:00:00	AAPL	Stock	35.185	35.2	35.1625	35.1675	158912.0
2017-03-16 08:30:00	AAPL	Stock	35.1725	35.175	35.115	35.155	221272.0
2017-03-16 09:00:00	AAPL	Stock	35.17	35.1875	35.15	35.185	173148.0
2017-03-16 09:30:00	AAPL	Stock	35.18	35.255	35.105	35.1925	14687456.0
2017-03-16 10:00:00	AAPL	Stock	35.1927	35.2225	35.105	35.105	6194924.0
2017-03-16 10:30:00	AAPL	Stock	35.1062	35.1625	35.0875	35.1358	5055268.0
2017-03-16 11:00:00	AAPL	Stock	35.135	35.1415	35.0875	35.0925	4049968.0
2017-03-16 11:30:00	AAPL	Stock	35.0925	35.1505	35.065	35.1425	3820988.0
2017-03-16 12:00:00	AAPL	Stock	35.145	35.215	35.13	35.195	4151500.0
2017-03-16 12:30:00	AAPL	Stock	35.195	35.2125	35.17	35.2	3222912.0
2017-03-16 13:00:00	AAPL	Stock	35.2025	35.2025	35.145	35.155	2545264.0
2017-03-16 13:30:00	AAPL	Stock	35.155	35.19	35.13	35.1602	2729552.0
2017-03-16 14:00:00	AAPL	Stock	35.16	35.1975	35.1525	35.18	2229300.0
2017-03-16 14:30:00	AAPL	Stock	35.1788	35.1875	35.115	35.125	2977688.0
2017-03-16 15:00:00	AAPL	Stock	35.125	35.135	35.095	35.105	3327728.0
2017-03-16 15:30:00	AAPL	Stock	35.1038	35.1825	35.1	35.1725	8400440.0
2017-03-16 16:00:00	AAPL	Stock	35.1725	35.1825	35.125	35.1725	4722296.0
2017-03-16 16:30:00	AAPL	Stock	35.175	35.18	35.165	35.18	32556.0
2017-03-16 17:00:00	AAPL	Stock	35.175	35.175	35.165	35.1725	161796.0
2017-03-16 17:30:00	AAPL	Stock	35.175	35.175	35.04	35.1725	27872.0
2017-03-16 18:00:00	AAPL	Stock	35.16	35.17	35.16	35.165	1936.0
2017-03-16 18:30:00	AAPL	Stock	35.15	35.165	35.15	35.15	2080.0
2017-03-16 19:00:00	AAPL	Stock	35.1625	35.165	35.15	35.1625	6628.0
2017-03-16 19:30:00	AAPL	Stock	35.1575	35.1575	35.145	35.1525	25576.0
2017-03-16 04:00:00	MSFT	Stock	64.98	64.98	64.98	64.98	351.0
2017-03-16 05:00:00	MSFT	Stock	64.97	64.97	64.97	64.97	100.0
2017-03-16 05:30:00	MSFT	Stock	64.97	64.97	64.97	64.97	500.0
2017-03-16 07:00:00	MSFT	Stock	64.86	64.86	64.86	64.86	200.0
2017-03-16 08:00:00	MSFT	Stock	64.9	64.94	64.9	64.9	1618.0
2017-03-16 08:30:00	MSFT	Stock	64.9	64.92	64.75	64.91	2590.0
2017-03-16 09:00:00	MSFT	Stock	64.92	64.92	64.69	64.73	19950.0
2017-03-16 09:30:00	MSFT	Stock	64.75	64.76	64.53	64.55	2954564.0
2017-03-16 10:00:00	MSFT	Stock	64.55	64.595	64.39	64.535	1614037.0
2017-03-16 10:30:00	MSFT	Stock	64.54	64.545	64.3	64.41	1631232.0
2017-03-16 11:00:00	MSFT	Stock	64.41	64.48	64.32	64.437	1247159.0
2017-03-16 11:30:00	MSFT	Stock	64.44	64.468	64.36	64.46	820363.0
2017-03-16 12:00:00	MSFT	Stock	64.455	64.65	64.44	64.63	1570632.0
2017-03-16 12:30:00	MSFT	Stock	64.64	64.67	64.54	64.55	815647.0
2017-03-16 13:00:00	MSFT	Stock	64.56	64.56	64.45	64.5	598247.0
2017-03-16 13:30:00	MSFT	Stock	64.495	64.565	64.48	64.54	532995.0
2017-03-16 14:00:00	MSFT	Stock	64.54	64.57	64.495	64.55	533975.0
2017-03-16 14:30:00	MSFT	Stock	64.56	64.565	64.37	64.386	905510.0

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

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