PREVIEW / stock_30min / 2015-11-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-09.parquet
  size:    1.6 MB
  rows:    82,173
  symbols: 3,418

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
2015-11-09 04:00:00	AAPL	Stock	30.255	30.255	30.2325	30.2325	1600.0
2015-11-09 04:30:00	AAPL	Stock	30.2475	30.255	30.225	30.225	4352.0
2015-11-09 05:00:00	AAPL	Stock	30.2125	30.2125	30.2125	30.2125	1200.0
2015-11-09 05:30:00	AAPL	Stock	30.175	30.175	30.175	30.175	2000.0
2015-11-09 06:00:00	AAPL	Stock	30.175	30.1875	30.15	30.1875	2548.0
2015-11-09 06:30:00	AAPL	Stock	30.15	30.15	30.1375	30.1475	10636.0
2015-11-09 07:00:00	AAPL	Stock	30.1625	30.1675	30.145	30.1625	10340.0
2015-11-09 07:30:00	AAPL	Stock	30.17	30.1725	30.1575	30.1625	26816.0
2015-11-09 08:00:00	AAPL	Stock	30.1625	30.26	30.1475	30.245	277240.0
2015-11-09 08:30:00	AAPL	Stock	30.2475	30.325	30.2225	30.27	284148.0
2015-11-09 09:00:00	AAPL	Stock	30.27	30.3	30.1975	30.1975	195160.0
2015-11-09 09:30:00	AAPL	Stock	30.24	30.4525	30.1225	30.3225	20683476.0
2015-11-09 10:00:00	AAPL	Stock	30.3225	30.38	30.1875	30.2575	13805668.0
2015-11-09 10:30:00	AAPL	Stock	30.2562	30.3275	30.2138	30.3	7350992.0
2015-11-09 11:00:00	AAPL	Stock	30.3	30.3175	30.0125	30.0625	11558404.0
2015-11-09 11:30:00	AAPL	Stock	30.065	30.12	30.045	30.0895	7005680.0
2015-11-09 12:00:00	AAPL	Stock	30.0895	30.18	30.0775	30.135	5824572.0
2015-11-09 12:30:00	AAPL	Stock	30.135	30.1825	30.1	30.155	3459792.0
2015-11-09 13:00:00	AAPL	Stock	30.1575	30.2238	30.12	30.141	5639896.0
2015-11-09 13:30:00	AAPL	Stock	30.1425	30.175	30.0925	30.12	3580296.0
2015-11-09 14:00:00	AAPL	Stock	30.12	30.125	30.0425	30.08	5392728.0
2015-11-09 14:30:00	AAPL	Stock	30.0818	30.0925	30.025	30.0638	4432796.0
2015-11-09 15:00:00	AAPL	Stock	30.0625	30.1	30.0335	30.091	5368524.0
2015-11-09 15:30:00	AAPL	Stock	30.0922	30.2325	30.0922	30.145	13109880.0
2015-11-09 16:00:00	AAPL	Stock	30.1425	30.19	30.1425	30.155	17737848.0
2015-11-09 16:30:00	AAPL	Stock	30.155	30.1625	29.925	30.0225	302780.0
2015-11-09 17:00:00	AAPL	Stock	30.0	30.065	30.0	30.045	139448.0
2015-11-09 17:30:00	AAPL	Stock	30.055	30.095	30.0425	30.075	40912.0
2015-11-09 18:00:00	AAPL	Stock	30.0775	30.08	30.0525	30.08	14928.0
2015-11-09 18:30:00	AAPL	Stock	30.075	30.095	30.075	30.095	24260.0
2015-11-09 19:00:00	AAPL	Stock	30.07	30.1125	30.07	30.11	18692.0
2015-11-09 19:30:00	AAPL	Stock	30.11	30.1175	30.1	30.1025	49260.0
2015-11-09 04:00:00	MSFT	Stock	54.88	54.91	54.88	54.91	200.0
2015-11-09 04:30:00	MSFT	Stock	54.86	54.86	54.74	54.74	1100.0
2015-11-09 05:00:00	MSFT	Stock	54.73	54.74	54.73	54.74	331.0
2015-11-09 06:30:00	MSFT	Stock	54.73	54.74	54.73	54.73	1500.0
2015-11-09 07:00:00	MSFT	Stock	54.74	54.74	54.74	54.74	100.0
2015-11-09 07:30:00	MSFT	Stock	54.74	54.78	54.7	54.78	6160.0
2015-11-09 08:00:00	MSFT	Stock	54.74	54.81	54.73	54.74	5285.0
2015-11-09 08:30:00	MSFT	Stock	54.78	54.8	54.73	54.8	7433.0
2015-11-09 09:00:00	MSFT	Stock	54.73	54.8	54.55	54.63	83047.0
2015-11-09 09:30:00	MSFT	Stock	54.55	54.87	54.55	54.59	3362836.0
2015-11-09 10:00:00	MSFT	Stock	54.59	54.6	54.324	54.39	2126455.0
2015-11-09 10:30:00	MSFT	Stock	54.39	54.48	54.17	54.195	1537172.0
2015-11-09 11:00:00	MSFT	Stock	54.19	54.215	53.81	53.865	2095116.0
2015-11-09 11:30:00	MSFT	Stock	53.866	53.95	53.56	53.597	1711882.0
2015-11-09 12:00:00	MSFT	Stock	53.6	53.889	53.57	53.855	1466772.0
2015-11-09 12:30:00	MSFT	Stock	53.85	54.05	53.82	53.94	1406924.0
2015-11-09 13:00:00	MSFT	Stock	53.935	54.02	53.765	53.89	1024500.0
2015-11-09 13:30:00	MSFT	Stock	53.9	53.975	53.834	53.91	1193666.0

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

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