PREVIEW / stock_30min / 2016-09-27

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-27.parquet
  size:    1.6 MB
  rows:    80,606
  symbols: 3,205

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-09-27 04:00:00	AAPL	Stock	28.385	28.385	28.34	28.34	2148.0
2016-09-27 04:30:00	AAPL	Stock	28.325	28.325	28.2275	28.2275	8872.0
2016-09-27 05:00:00	AAPL	Stock	28.2825	28.2825	28.2825	28.2825	1640.0
2016-09-27 05:30:00	AAPL	Stock	28.2875	28.2875	28.2875	28.2875	416.0
2016-09-27 06:00:00	AAPL	Stock	28.22	28.25	28.22	28.25	2400.0
2016-09-27 06:30:00	AAPL	Stock	28.2275	28.32	28.21	28.32	51320.0
2016-09-27 07:00:00	AAPL	Stock	28.31	28.3375	28.265	28.325	53680.0
2016-09-27 07:30:00	AAPL	Stock	28.3475	28.375	28.325	28.3475	63700.0
2016-09-27 08:00:00	AAPL	Stock	28.3625	28.3625	28.1625	28.2375	208808.0
2016-09-27 08:30:00	AAPL	Stock	28.2475	28.3	28.225	28.295	174780.0
2016-09-27 09:00:00	AAPL	Stock	28.2825	28.2825	28.23	28.23	360816.0
2016-09-27 09:30:00	AAPL	Stock	28.25	28.2575	28.1125	28.1925	16758184.0
2016-09-27 10:00:00	AAPL	Stock	28.1912	28.285	28.1675	28.22	9797460.0
2016-09-27 10:30:00	AAPL	Stock	28.2225	28.2375	28.1302	28.1422	6348568.0
2016-09-27 11:00:00	AAPL	Stock	28.1425	28.2	28.085	28.19	5665124.0
2016-09-27 11:30:00	AAPL	Stock	28.19	28.2172	28.1675	28.1925	4078132.0
2016-09-27 12:00:00	AAPL	Stock	28.1925	28.2475	28.145	28.21	5412680.0
2016-09-27 12:30:00	AAPL	Stock	28.2112	28.2275	28.185	28.215	2958772.0
2016-09-27 13:00:00	AAPL	Stock	28.215	28.234	28.1725	28.1975	3570100.0
2016-09-27 13:30:00	AAPL	Stock	28.1975	28.2325	28.19	28.215	2835792.0
2016-09-27 14:00:00	AAPL	Stock	28.2125	28.28	28.2025	28.2725	4422488.0
2016-09-27 14:30:00	AAPL	Stock	28.2738	28.2775	28.215	28.24	3960852.0
2016-09-27 15:00:00	AAPL	Stock	28.24	28.28	28.2325	28.26	4681736.0
2016-09-27 15:30:00	AAPL	Stock	28.26	28.295	28.235	28.2775	8843848.0
2016-09-27 16:00:00	AAPL	Stock	28.2725	28.2925	28.1828	28.265	9303520.0
2016-09-27 16:30:00	AAPL	Stock	28.27	28.2725	28.265	28.27	31760.0
2016-09-27 17:00:00	AAPL	Stock	28.27	28.27	28.2525	28.2525	12576.0
2016-09-27 17:30:00	AAPL	Stock	28.265	28.2725	28.265	28.27	4188.0
2016-09-27 18:00:00	AAPL	Stock	28.2725	28.2725	28.265	28.265	4776.0
2016-09-27 18:30:00	AAPL	Stock	28.27	28.275	28.26	28.2725	14176.0
2016-09-27 19:00:00	AAPL	Stock	28.2725	28.2725	28.265	28.265	10148.0
2016-09-27 19:30:00	AAPL	Stock	28.265	28.265	28.26	28.2625	8772.0
2016-09-27 07:00:00	MSFT	Stock	57.37	57.37	57.37	57.37	1000.0
2016-09-27 08:00:00	MSFT	Stock	57.01	57.14	56.9	56.9	2037.0
2016-09-27 08:30:00	MSFT	Stock	56.94	56.98	56.94	56.98	520.0
2016-09-27 09:00:00	MSFT	Stock	56.91	56.95	56.89	56.92	3294.0
2016-09-27 09:30:00	MSFT	Stock	56.93	57.245	56.681	57.24	2727894.0
2016-09-27 10:00:00	MSFT	Stock	57.24	57.4	57.235	57.4	1684004.0
2016-09-27 10:30:00	MSFT	Stock	57.4	57.44	57.2	57.23	1737671.0
2016-09-27 11:00:00	MSFT	Stock	57.24	57.47	57.22	57.455	986050.0
2016-09-27 11:30:00	MSFT	Stock	57.455	57.6	57.455	57.596	1149074.0
2016-09-27 12:00:00	MSFT	Stock	57.6	57.77	57.47	57.72	1937114.0
2016-09-27 12:30:00	MSFT	Stock	57.72	57.82	57.67	57.815	1389310.0
2016-09-27 13:00:00	MSFT	Stock	57.815	57.91	57.68	57.845	1430855.0
2016-09-27 13:30:00	MSFT	Stock	57.85	57.985	57.84	57.98	1740314.0
2016-09-27 14:00:00	MSFT	Stock	57.976	58.05	57.92	58.032	1968247.0
2016-09-27 14:30:00	MSFT	Stock	58.032	58.06	57.88	57.905	1347220.0
2016-09-27 15:00:00	MSFT	Stock	57.905	57.96	57.79	57.865	1518137.0
2016-09-27 15:30:00	MSFT	Stock	57.86	58.0	57.83	57.97	3427828.0
2016-09-27 16:00:00	MSFT	Stock	57.95	57.97	57.9	57.9	2653590.0

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

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