PREVIEW / stock_30min / 2015-09-24

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-24.parquet
  size:    1.6 MB
  rows:    81,471
  symbols: 3,435

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-09-24 04:00:00	AAPL	Stock	28.5075	28.6225	28.4525	28.6225	23000.0
2015-09-24 04:30:00	AAPL	Stock	28.6	28.6	28.5725	28.5825	17264.0
2015-09-24 05:00:00	AAPL	Stock	28.66	28.66	28.55	28.55	11848.0
2015-09-24 05:30:00	AAPL	Stock	28.5325	28.5325	28.5	28.5	4400.0
2015-09-24 06:00:00	AAPL	Stock	28.5	28.5	28.48	28.48	3700.0
2015-09-24 06:30:00	AAPL	Stock	28.4225	28.4225	28.34	28.3675	13208.0
2015-09-24 07:00:00	AAPL	Stock	28.3825	28.3825	28.21	28.21	139736.0
2015-09-24 07:30:00	AAPL	Stock	28.24	28.325	28.2375	28.28	58328.0
2015-09-24 08:00:00	AAPL	Stock	28.2975	28.47	28.21	28.345	487824.0
2015-09-24 08:30:00	AAPL	Stock	28.3475	28.375	28.2775	28.37	373780.0
2015-09-24 09:00:00	AAPL	Stock	28.3625	28.3625	28.2575	28.305	451744.0
2015-09-24 09:30:00	AAPL	Stock	28.3075	28.415	28.18	28.2575	23271852.0
2015-09-24 10:00:00	AAPL	Stock	28.2575	28.34	28.1975	28.2178	13662224.0
2015-09-24 10:30:00	AAPL	Stock	28.2175	28.2475	28.095	28.1325	14920416.0
2015-09-24 11:00:00	AAPL	Stock	28.135	28.2372	28.0925	28.1552	11248684.0
2015-09-24 11:30:00	AAPL	Stock	28.1575	28.31	28.1525	28.2998	8898604.0
2015-09-24 12:00:00	AAPL	Stock	28.2988	28.3925	28.2675	28.385	7327392.0
2015-09-24 12:30:00	AAPL	Stock	28.385	28.445	28.3472	28.35	8903976.0
2015-09-24 13:00:00	AAPL	Stock	28.3475	28.4	28.29	28.34	8975464.0
2015-09-24 13:30:00	AAPL	Stock	28.3412	28.4825	28.29	28.425	9366960.0
2015-09-24 14:00:00	AAPL	Stock	28.4252	28.635	28.3925	28.5958	11790452.0
2015-09-24 14:30:00	AAPL	Stock	28.5972	28.875	28.58	28.8175	16645160.0
2015-09-24 15:00:00	AAPL	Stock	28.8175	28.83	28.63	28.7635	16975572.0
2015-09-24 15:30:00	AAPL	Stock	28.7648	28.8125	28.6938	28.75	16739872.0
2015-09-24 16:00:00	AAPL	Stock	28.75	28.775	28.3212	28.7625	17104116.0
2015-09-24 16:30:00	AAPL	Stock	28.7725	28.7975	28.75	28.7625	161064.0
2015-09-24 17:00:00	AAPL	Stock	28.755	28.755	28.725	28.75	55104.0
2015-09-24 17:30:00	AAPL	Stock	28.75	28.7625	28.6775	28.6875	50940.0
2015-09-24 18:00:00	AAPL	Stock	28.6875	28.75	28.6875	28.75	23900.0
2015-09-24 18:30:00	AAPL	Stock	28.75	28.8	28.7375	28.8	126120.0
2015-09-24 19:00:00	AAPL	Stock	28.795	28.8125	28.775	28.8125	100540.0
2015-09-24 19:30:00	AAPL	Stock	28.8125	28.87	28.8125	28.86	152852.0
2015-09-24 06:00:00	MSFT	Stock	43.9	43.9	43.67	43.67	3702.0
2015-09-24 06:30:00	MSFT	Stock	43.58	43.58	43.58	43.58	250.0
2015-09-24 07:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	100.0
2015-09-24 08:00:00	MSFT	Stock	43.45	43.45	43.33	43.4	12725.0
2015-09-24 08:30:00	MSFT	Stock	43.4	43.43	43.4	43.4	3000.0
2015-09-24 09:00:00	MSFT	Stock	43.47	43.47	43.41	43.46	10738.0
2015-09-24 09:30:00	MSFT	Stock	43.45	43.72	43.3	43.38	2991115.0
2015-09-24 10:00:00	MSFT	Stock	43.38	43.59	43.35	43.42	1785421.0
2015-09-24 10:30:00	MSFT	Stock	43.42	43.47	43.27	43.41	1709286.0
2015-09-24 11:00:00	MSFT	Stock	43.415	43.605	43.32	43.4	1211404.0
2015-09-24 11:30:00	MSFT	Stock	43.41	43.58	43.405	43.546	1130649.0
2015-09-24 12:00:00	MSFT	Stock	43.54	43.67	43.53	43.61	797375.0
2015-09-24 12:30:00	MSFT	Stock	43.615	43.78	43.52	43.55	1026107.0
2015-09-24 13:00:00	MSFT	Stock	43.544	43.67	43.5	43.6	985623.0
2015-09-24 13:30:00	MSFT	Stock	43.6	43.78	43.55	43.68	1080530.0
2015-09-24 14:00:00	MSFT	Stock	43.685	43.85	43.63	43.79	1320479.0
2015-09-24 14:30:00	MSFT	Stock	43.785	44.13	43.69	44.001	2401974.0
2015-09-24 15:00:00	MSFT	Stock	44.01	44.11	43.78	44.045	2330422.0

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

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