PREVIEW / stock_30min / 2016-10-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-21.parquet
  size:    1.5 MB
  rows:    79,120
  symbols: 3,191

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
2016-10-21 04:00:00	AAPL	Stock	29.2925	29.2925	29.215	29.215	2120.0
2016-10-21 04:30:00	AAPL	Stock	29.22	29.22	29.22	29.22	2736.0
2016-10-21 05:30:00	AAPL	Stock	29.2325	29.235	29.2325	29.235	1680.0
2016-10-21 06:00:00	AAPL	Stock	29.2275	29.24	29.2125	29.24	7192.0
2016-10-21 06:30:00	AAPL	Stock	29.2125	29.2325	29.18	29.2325	5400.0
2016-10-21 07:00:00	AAPL	Stock	29.225	29.235	29.2225	29.225	3864.0
2016-10-21 07:30:00	AAPL	Stock	29.2325	29.2375	29.215	29.2225	22112.0
2016-10-21 08:00:00	AAPL	Stock	29.235	29.3	29.2	29.2675	85736.0
2016-10-21 08:30:00	AAPL	Stock	29.2625	29.28	29.2375	29.2425	45252.0
2016-10-21 09:00:00	AAPL	Stock	29.26	29.315	29.205	29.205	280952.0
2016-10-21 09:30:00	AAPL	Stock	29.2025	29.2275	29.0775	29.2088	19120824.0
2016-10-21 10:00:00	AAPL	Stock	29.2075	29.2075	29.1025	29.1475	7421736.0
2016-10-21 10:30:00	AAPL	Stock	29.1475	29.18	29.125	29.165	4776412.0
2016-10-21 11:00:00	AAPL	Stock	29.1625	29.19	29.13	29.155	4557928.0
2016-10-21 11:30:00	AAPL	Stock	29.1525	29.2175	29.135	29.1825	3970808.0
2016-10-21 12:00:00	AAPL	Stock	29.185	29.1975	29.1325	29.1328	3618496.0
2016-10-21 12:30:00	AAPL	Stock	29.1328	29.1425	29.12	29.1335	2871144.0
2016-10-21 13:00:00	AAPL	Stock	29.134	29.1575	29.1275	29.1375	2920676.0
2016-10-21 13:30:00	AAPL	Stock	29.1388	29.185	29.1175	29.15	3210116.0
2016-10-21 14:00:00	AAPL	Stock	29.1525	29.1825	29.1438	29.1788	2841708.0
2016-10-21 14:30:00	AAPL	Stock	29.18	29.1825	29.1425	29.155	3289012.0
2016-10-21 15:00:00	AAPL	Stock	29.155	29.1625	29.1225	29.1245	5070976.0
2016-10-21 15:30:00	AAPL	Stock	29.1238	29.155	29.07	29.1325	12405540.0
2016-10-21 16:00:00	AAPL	Stock	29.15	29.15	29.105	29.115	7433484.0
2016-10-21 16:30:00	AAPL	Stock	29.115	29.1772	29.1125	29.1225	117404.0
2016-10-21 17:00:00	AAPL	Stock	29.1225	29.135	29.1	29.1025	126168.0
2016-10-21 17:30:00	AAPL	Stock	29.1125	29.15	29.11	29.115	2556828.0
2016-10-21 18:00:00	AAPL	Stock	29.125	29.145	29.125	29.1375	20272.0
2016-10-21 18:30:00	AAPL	Stock	29.1375	29.14	29.1275	29.13	27268.0
2016-10-21 19:00:00	AAPL	Stock	29.125	29.14	29.1175	29.14	29000.0
2016-10-21 19:30:00	AAPL	Stock	29.14	29.14	29.12	29.135	18232.0
2016-10-21 04:00:00	MSFT	Stock	60.35	60.35	60.21	60.23	5139.0
2016-10-21 04:30:00	MSFT	Stock	60.21	60.26	60.11	60.26	1036.0
2016-10-21 05:00:00	MSFT	Stock	60.26	60.26	60.2	60.23	2200.0
2016-10-21 05:30:00	MSFT	Stock	60.25	60.38	60.23	60.35	3287.0
2016-10-21 06:00:00	MSFT	Stock	60.35	60.45	60.33	60.4	8131.0
2016-10-21 06:30:00	MSFT	Stock	60.4	60.47	60.15	60.3	34020.0
2016-10-21 07:00:00	MSFT	Stock	60.22	60.48	60.13	60.45	167818.0
2016-10-21 07:30:00	MSFT	Stock	60.44	60.74	60.35	60.7	142165.0
2016-10-21 08:00:00	MSFT	Stock	60.7	60.79	57.25	60.7	572429.0
2016-10-21 08:30:00	MSFT	Stock	60.61	60.9	60.53	60.6	1105906.0
2016-10-21 09:00:00	MSFT	Stock	60.62	60.62	60.06	60.28	1712977.0
2016-10-21 09:30:00	MSFT	Stock	60.3	60.45	59.74	59.775	22069098.0
2016-10-21 10:00:00	MSFT	Stock	59.77	59.87	59.485	59.64	7236103.0
2016-10-21 10:30:00	MSFT	Stock	59.63	59.84	59.525	59.63	5757688.0
2016-10-21 11:00:00	MSFT	Stock	59.63	59.98	59.61	59.94	4384169.0
2016-10-21 11:30:00	MSFT	Stock	59.93	60.0	59.86	59.925	3694073.0
2016-10-21 12:00:00	MSFT	Stock	59.915	60.31	59.8	59.837	5524318.0
2016-10-21 12:30:00	MSFT	Stock	59.84	59.95	59.83	59.88	2175730.0
2016-10-21 13:00:00	MSFT	Stock	59.89	60.02	59.88	59.97	1606395.0

> showing 50 of 79,120 rows — these rows as CSV

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