PREVIEW / stock_30min / 2016-10-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-10-11.parquet
  size:    1.6 MB
  rows:    80,124
  symbols: 3,190

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-11 04:00:00	AAPL	Stock	29.1025	29.1825	29.1025	29.175	70424.0
2016-10-11 04:30:00	AAPL	Stock	29.1875	29.2375	29.175	29.2125	11492.0
2016-10-11 05:00:00	AAPL	Stock	29.2275	29.25	29.215	29.215	39628.0
2016-10-11 05:30:00	AAPL	Stock	29.2375	29.2375	29.175	29.2025	21096.0
2016-10-11 06:00:00	AAPL	Stock	29.22	29.2475	29.2	29.245	102560.0
2016-10-11 06:30:00	AAPL	Stock	29.245	29.375	29.235	29.3525	347424.0
2016-10-11 07:00:00	AAPL	Stock	29.3525	29.445	29.3	29.425	761500.0
2016-10-11 07:30:00	AAPL	Stock	29.4325	29.75	29.4325	29.5875	1447632.0
2016-10-11 08:00:00	AAPL	Stock	29.5625	29.6475	29.2725	29.5625	3174344.0
2016-10-11 08:30:00	AAPL	Stock	29.5575	29.575	29.4525	29.455	1618328.0
2016-10-11 09:00:00	AAPL	Stock	29.4575	29.4925	29.365	29.425	2104296.0
2016-10-11 09:30:00	AAPL	Stock	29.4125	29.6725	29.4025	29.5398	51564360.0
2016-10-11 10:00:00	AAPL	Stock	29.54	29.54	29.3025	29.42	21435324.0
2016-10-11 10:30:00	AAPL	Stock	29.42	29.46	29.3825	29.3838	10744492.0
2016-10-11 11:00:00	AAPL	Stock	29.3825	29.4175	29.2652	29.2838	25597728.0
2016-10-11 11:30:00	AAPL	Stock	29.2838	29.3575	29.2475	29.281	13774860.0
2016-10-11 12:00:00	AAPL	Stock	29.2815	29.3	29.18	29.22	11580180.0
2016-10-11 12:30:00	AAPL	Stock	29.2192	29.3575	29.166	29.3275	11185228.0
2016-10-11 13:00:00	AAPL	Stock	29.325	29.3272	29.195	29.23	8757740.0
2016-10-11 13:30:00	AAPL	Stock	29.2312	29.2312	29.0912	29.11	10692136.0
2016-10-11 14:00:00	AAPL	Stock	29.11	29.1425	29.05	29.1275	12636332.0
2016-10-11 14:30:00	AAPL	Stock	29.13	29.18	29.0825	29.1275	8897604.0
2016-10-11 15:00:00	AAPL	Stock	29.1285	29.165	29.0675	29.12	10788900.0
2016-10-11 15:30:00	AAPL	Stock	29.1205	29.145	29.0675	29.085	18485104.0
2016-10-11 16:00:00	AAPL	Stock	29.075	29.11	28.9375	29.0975	12577224.0
2016-10-11 16:30:00	AAPL	Stock	29.1	29.105	29.075	29.0875	125116.0
2016-10-11 17:00:00	AAPL	Stock	29.0875	29.1	29.08	29.1	49232.0
2016-10-11 17:30:00	AAPL	Stock	29.0975	29.1125	29.0825	29.11	26368.0
2016-10-11 18:00:00	AAPL	Stock	29.1125	29.1225	29.1	29.1	33972.0
2016-10-11 18:30:00	AAPL	Stock	29.0975	29.1125	29.0975	29.1125	28332.0
2016-10-11 19:00:00	AAPL	Stock	29.1125	29.1125	29.1	29.1	54440.0
2016-10-11 19:30:00	AAPL	Stock	29.1025	29.125	29.1	29.1225	59768.0
2016-10-11 06:00:00	MSFT	Stock	57.65	57.65	57.59	57.59	200.0
2016-10-11 07:30:00	MSFT	Stock	58.25	58.25	58.06	58.06	450.0
2016-10-11 08:00:00	MSFT	Stock	58.05	58.05	57.85	57.85	21805.0
2016-10-11 08:30:00	MSFT	Stock	57.89	57.89	57.89	57.89	500.0
2016-10-11 09:30:00	MSFT	Stock	57.89	58.02	57.541	57.57	2681907.0
2016-10-11 10:00:00	MSFT	Stock	57.58	57.73	57.55	57.695	1213799.0
2016-10-11 10:30:00	MSFT	Stock	57.695	57.73	57.5	57.515	966553.0
2016-10-11 11:00:00	MSFT	Stock	57.51	57.525	57.27	57.29	1347482.0
2016-10-11 11:30:00	MSFT	Stock	57.285	57.39	57.26	57.33	1012898.0
2016-10-11 12:00:00	MSFT	Stock	57.33	57.385	57.27	57.295	764373.0
2016-10-11 12:30:00	MSFT	Stock	57.295	57.36	57.16	57.26	1312406.0
2016-10-11 13:00:00	MSFT	Stock	57.26	57.26	57.05	57.14	1139199.0
2016-10-11 13:30:00	MSFT	Stock	57.14	57.19	57.06	57.18	1811939.0
2016-10-11 14:00:00	MSFT	Stock	57.18	57.195	56.89	56.995	2563088.0
2016-10-11 14:30:00	MSFT	Stock	57.0	57.14	56.98	57.025	1256589.0
2016-10-11 15:00:00	MSFT	Stock	57.02	57.16	57.005	57.11	1905816.0
2016-10-11 15:30:00	MSFT	Stock	57.11	57.23	57.09	57.18	3431165.0
2016-10-11 16:00:00	MSFT	Stock	57.19	57.29	57.19	57.19	3250452.0

> showing 50 of 80,124 rows — these rows as CSV

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