PREVIEW / stock_30min / 2016-08-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-22.parquet
  size:    1.6 MB
  rows:    81,542
  symbols: 3,257

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-08-22 04:00:00	AAPL	Stock	27.25	27.25	27.25	27.25	408.0
2016-08-22 05:30:00	AAPL	Stock	27.4125	27.4125	27.4125	27.4125	400.0
2016-08-22 06:00:00	AAPL	Stock	27.3875	27.3875	27.365	27.365	4900.0
2016-08-22 06:30:00	AAPL	Stock	27.31	27.31	27.31	27.31	2400.0
2016-08-22 07:00:00	AAPL	Stock	27.3125	27.345	27.2975	27.345	9068.0
2016-08-22 07:30:00	AAPL	Stock	27.3125	27.3475	27.3125	27.3475	8620.0
2016-08-22 08:00:00	AAPL	Stock	27.3375	27.35	27.3125	27.335	41832.0
2016-08-22 08:30:00	AAPL	Stock	27.3275	27.3375	27.2675	27.2725	88276.0
2016-08-22 09:00:00	AAPL	Stock	27.2725	27.2875	27.22	27.22	207732.0
2016-08-22 09:30:00	AAPL	Stock	27.215	27.26	27.1575	27.19	13687108.0
2016-08-22 10:00:00	AAPL	Stock	27.1878	27.235	27.1238	27.2085	9840240.0
2016-08-22 10:30:00	AAPL	Stock	27.2075	27.22	27.1425	27.1475	6116632.0
2016-08-22 11:00:00	AAPL	Stock	27.1462	27.16	27.025	27.0425	7831892.0
2016-08-22 11:30:00	AAPL	Stock	27.04	27.0538	26.9625	27.035	9025744.0
2016-08-22 12:00:00	AAPL	Stock	27.035	27.1025	26.995	27.0825	6578452.0
2016-08-22 12:30:00	AAPL	Stock	27.0825	27.1538	27.0675	27.1112	6824388.0
2016-08-22 13:00:00	AAPL	Stock	27.11	27.1138	27.0262	27.05	4057400.0
2016-08-22 13:30:00	AAPL	Stock	27.0475	27.1175	27.035	27.0902	3664080.0
2016-08-22 14:00:00	AAPL	Stock	27.0925	27.1075	27.0475	27.05	3794204.0
2016-08-22 14:30:00	AAPL	Stock	27.05	27.1175	27.045	27.0925	3222660.0
2016-08-22 15:00:00	AAPL	Stock	27.095	27.1338	27.0925	27.1198	4000488.0
2016-08-22 15:30:00	AAPL	Stock	27.1175	27.1562	27.1075	27.125	8312936.0
2016-08-22 16:00:00	AAPL	Stock	27.1275	27.1325	27.084	27.115	5991804.0
2016-08-22 16:30:00	AAPL	Stock	27.1325	27.14	27.125	27.125	104648.0
2016-08-22 17:00:00	AAPL	Stock	27.125	27.13	27.12	27.12	23184.0
2016-08-22 17:30:00	AAPL	Stock	27.1175	27.1175	27.1075	27.1125	15040.0
2016-08-22 18:00:00	AAPL	Stock	27.11	27.1125	27.09	27.09	16312.0
2016-08-22 18:30:00	AAPL	Stock	27.095	27.095	27.0925	27.0925	2000.0
2016-08-22 19:00:00	AAPL	Stock	27.0975	27.11	27.075	27.075	12856.0
2016-08-22 19:30:00	AAPL	Stock	27.075	27.0825	27.025	27.07	67172.0
2016-08-22 06:00:00	MSFT	Stock	57.63	57.63	57.63	57.63	200.0
2016-08-22 07:30:00	MSFT	Stock	57.62	57.62	57.62	57.62	200.0
2016-08-22 08:00:00	MSFT	Stock	57.5	57.5	57.5	57.5	108.0
2016-08-22 08:30:00	MSFT	Stock	57.61	57.61	57.61	57.61	559.0
2016-08-22 09:00:00	MSFT	Stock	57.51	57.55	57.51	57.55	6917.0
2016-08-22 09:30:00	MSFT	Stock	57.57	57.6	57.26	57.42	1991008.0
2016-08-22 10:00:00	MSFT	Stock	57.43	57.7	57.36	57.64	1105809.0
2016-08-22 10:30:00	MSFT	Stock	57.65	57.75	57.63	57.653	820415.0
2016-08-22 11:00:00	MSFT	Stock	57.65	57.7	57.39	57.41	1184386.0
2016-08-22 11:30:00	MSFT	Stock	57.4	57.49	57.38	57.47	628237.0
2016-08-22 12:00:00	MSFT	Stock	57.46	57.66	57.405	57.63	857771.0
2016-08-22 12:30:00	MSFT	Stock	57.635	57.645	57.54	57.575	596198.0
2016-08-22 13:00:00	MSFT	Stock	57.57	57.62	57.4	57.47	578140.0
2016-08-22 13:30:00	MSFT	Stock	57.47	57.67	57.44	57.589	705363.0
2016-08-22 14:00:00	MSFT	Stock	57.59	57.63	57.47	57.47	659852.0
2016-08-22 14:30:00	MSFT	Stock	57.46	57.58	57.45	57.535	635275.0
2016-08-22 15:00:00	MSFT	Stock	57.53	57.655	57.53	57.64	919393.0
2016-08-22 15:30:00	MSFT	Stock	57.64	57.68	57.58	57.66	2066800.0
2016-08-22 16:00:00	MSFT	Stock	57.66	57.68	57.58	57.582	1478722.0
2016-08-22 16:30:00	MSFT	Stock	57.67	57.67	57.67	57.67	1161.0

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

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