PREVIEW / stock_30min / 2016-06-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-14.parquet
  size:    1.6 MB
  rows:    82,365
  symbols: 3,292

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-06-14 04:00:00	AAPL	Stock	24.235	24.2375	24.235	24.2375	1360.0
2016-06-14 04:30:00	AAPL	Stock	24.235	24.235	24.175	24.1775	3000.0
2016-06-14 05:00:00	AAPL	Stock	24.175	24.1875	24.175	24.1875	6560.0
2016-06-14 05:30:00	AAPL	Stock	24.175	24.19	24.175	24.19	1308.0
2016-06-14 06:00:00	AAPL	Stock	24.1925	24.1925	24.1925	24.1925	400.0
2016-06-14 06:30:00	AAPL	Stock	24.2125	24.255	24.2125	24.2375	7672.0
2016-06-14 07:00:00	AAPL	Stock	24.25	24.295	24.2375	24.25	29372.0
2016-06-14 07:30:00	AAPL	Stock	24.285	24.285	24.26	24.275	4400.0
2016-06-14 08:00:00	AAPL	Stock	24.275	24.325	24.25	24.3	76492.0
2016-06-14 08:30:00	AAPL	Stock	24.3025	24.3825	24.3025	24.3825	154312.0
2016-06-14 09:00:00	AAPL	Stock	24.3875	24.4125	24.335	24.3375	526832.0
2016-06-14 09:30:00	AAPL	Stock	24.3375	24.6188	24.33	24.5832	18558168.0
2016-06-14 10:00:00	AAPL	Stock	24.5825	24.6075	24.3925	24.4075	12245788.0
2016-06-14 10:30:00	AAPL	Stock	24.41	24.4438	24.2375	24.2575	12213836.0
2016-06-14 11:00:00	AAPL	Stock	24.2575	24.3	24.1925	24.21	10026904.0
2016-06-14 11:30:00	AAPL	Stock	24.21	24.2725	24.1875	24.215	8171848.0
2016-06-14 12:00:00	AAPL	Stock	24.215	24.3225	24.2138	24.3125	6116492.0
2016-06-14 12:30:00	AAPL	Stock	24.3125	24.37	24.295	24.3225	5395388.0
2016-06-14 13:00:00	AAPL	Stock	24.3225	24.3425	24.2575	24.2612	4163660.0
2016-06-14 13:30:00	AAPL	Stock	24.2625	24.295	24.2175	24.2388	5062192.0
2016-06-14 14:00:00	AAPL	Stock	24.2375	24.3275	24.2325	24.32	4511856.0
2016-06-14 14:30:00	AAPL	Stock	24.3185	24.325	24.23	24.25	5152168.0
2016-06-14 15:00:00	AAPL	Stock	24.25	24.3825	24.235	24.375	7939728.0
2016-06-14 15:30:00	AAPL	Stock	24.375	24.3975	24.3325	24.365	11273012.0
2016-06-14 16:00:00	AAPL	Stock	24.365	24.37	24.345	24.365	6140100.0
2016-06-14 16:30:00	AAPL	Stock	24.365	24.365	24.34	24.3625	71672.0
2016-06-14 17:00:00	AAPL	Stock	24.36	24.36	24.3475	24.3475	8500.0
2016-06-14 17:30:00	AAPL	Stock	24.3525	24.36	24.335	24.35	60008.0
2016-06-14 18:00:00	AAPL	Stock	24.35	24.35	24.35	24.35	5280.0
2016-06-14 18:30:00	AAPL	Stock	24.3375	24.345	24.325	24.3375	11600.0
2016-06-14 19:00:00	AAPL	Stock	24.3375	24.345	24.3325	24.3325	13136.0
2016-06-14 19:30:00	AAPL	Stock	24.3375	24.35	24.3375	24.3375	17196.0
2016-06-14 04:00:00	MSFT	Stock	50.13	50.13	50.13	50.13	100.0
2016-06-14 04:30:00	MSFT	Stock	50.07	50.07	50.07	50.07	400.0
2016-06-14 05:00:00	MSFT	Stock	50.13	50.13	50.13	50.13	300.0
2016-06-14 06:30:00	MSFT	Stock	50.0	50.0	50.0	50.0	1192.0
2016-06-14 07:00:00	MSFT	Stock	49.95	49.95	49.8	49.92	5610.0
2016-06-14 07:30:00	MSFT	Stock	49.95	49.98	49.91	49.98	3600.0
2016-06-14 08:00:00	MSFT	Stock	49.99	50.05	49.95	50.05	14729.0
2016-06-14 08:30:00	MSFT	Stock	50.05	50.13	49.99	50.13	15988.0
2016-06-14 09:00:00	MSFT	Stock	50.13	50.14	49.9	49.95	49983.0
2016-06-14 09:30:00	MSFT	Stock	49.9	50.1	49.872	49.97	5654907.0
2016-06-14 10:00:00	MSFT	Stock	49.97	50.02	49.63	49.735	4207863.0
2016-06-14 10:30:00	MSFT	Stock	49.735	49.86	49.6	49.655	2952713.0
2016-06-14 11:00:00	MSFT	Stock	49.66	49.76	49.57	49.61	2882560.0
2016-06-14 11:30:00	MSFT	Stock	49.61	49.78	49.585	49.695	2232873.0
2016-06-14 12:00:00	MSFT	Stock	49.69	49.99	49.65	49.974	1825804.0
2016-06-14 12:30:00	MSFT	Stock	49.976	49.98	49.82	49.827	1680034.0
2016-06-14 13:00:00	MSFT	Stock	49.825	49.905	49.75	49.81	1519694.0
2016-06-14 13:30:00	MSFT	Stock	49.805	49.91	49.73	49.805	1438365.0

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

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