PREVIEW / stock_30min / 2016-12-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-22.parquet
  size:    1.6 MB
  rows:    80,822
  symbols: 3,164

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-12-22 04:00:00	AAPL	Stock	29.0	29.07	29.0	29.07	4072.0
2016-12-22 04:30:00	AAPL	Stock	29.0875	29.0875	29.01	29.01	4232.0
2016-12-22 05:00:00	AAPL	Stock	29.025	29.0525	29.01	29.01	8256.0
2016-12-22 05:30:00	AAPL	Stock	29.025	29.09	29.025	29.0875	10664.0
2016-12-22 06:00:00	AAPL	Stock	29.1	29.1	29.1	29.1	2000.0
2016-12-22 06:30:00	AAPL	Stock	29.1225	29.1225	29.08	29.105	14184.0
2016-12-22 07:00:00	AAPL	Stock	29.1225	29.17	29.115	29.1375	11812.0
2016-12-22 07:30:00	AAPL	Stock	29.14	29.1675	29.12	29.1625	9460.0
2016-12-22 08:00:00	AAPL	Stock	29.1225	29.225	29.115	29.225	89484.0
2016-12-22 08:30:00	AAPL	Stock	29.225	29.265	29.2125	29.2125	63544.0
2016-12-22 09:00:00	AAPL	Stock	29.215	29.235	29.0875	29.09	322848.0
2016-12-22 09:30:00	AAPL	Stock	29.0875	29.1275	28.965	29.065	16769200.0
2016-12-22 10:00:00	AAPL	Stock	29.0575	29.1225	29.0538	29.0825	7278000.0
2016-12-22 10:30:00	AAPL	Stock	29.0825	29.125	29.0525	29.0595	4923064.0
2016-12-22 11:00:00	AAPL	Stock	29.055	29.0875	28.995	28.995	5386596.0
2016-12-22 11:30:00	AAPL	Stock	28.9962	29.015	28.91	28.935	7173888.0
2016-12-22 12:00:00	AAPL	Stock	28.935	28.984	28.93	28.9815	3814392.0
2016-12-22 12:30:00	AAPL	Stock	28.9825	28.9975	28.95	28.95	3517172.0
2016-12-22 13:00:00	AAPL	Stock	28.95	29.0	28.9475	28.995	2422820.0
2016-12-22 13:30:00	AAPL	Stock	28.9938	29.0575	28.975	29.0325	4018420.0
2016-12-22 14:00:00	AAPL	Stock	29.0325	29.0575	29.021	29.0312	3070260.0
2016-12-22 14:30:00	AAPL	Stock	29.0305	29.0312	28.98	29.0028	3497596.0
2016-12-22 15:00:00	AAPL	Stock	29.0035	29.005	28.9175	28.9525	7145816.0
2016-12-22 15:30:00	AAPL	Stock	28.9525	29.0725	28.9425	29.0725	13268672.0
2016-12-22 16:00:00	AAPL	Stock	29.075	29.075	29.0125	29.0725	11098040.0
2016-12-22 16:30:00	AAPL	Stock	29.0725	29.075	29.0675	29.0725	799672.0
2016-12-22 17:00:00	AAPL	Stock	29.055	29.0725	29.055	29.0725	24400.0
2016-12-22 17:30:00	AAPL	Stock	29.0725	29.0725	29.055	29.055	4740.0
2016-12-22 18:00:00	AAPL	Stock	29.0525	29.06	29.01	29.01	59116.0
2016-12-22 18:30:00	AAPL	Stock	29.0025	29.02	29.0	29.02	9212.0
2016-12-22 19:00:00	AAPL	Stock	29.0125	29.035	29.0	29.0	12044.0
2016-12-22 19:30:00	AAPL	Stock	29.005	29.0175	28.9875	29.0	17000.0
2016-12-22 05:30:00	MSFT	Stock	63.72	63.84	63.72	63.84	1193.0
2016-12-22 06:30:00	MSFT	Stock	63.72	63.72	63.6	63.6	828.0
2016-12-22 07:00:00	MSFT	Stock	63.63	63.72	63.63	63.66	1005.0
2016-12-22 07:30:00	MSFT	Stock	63.73	63.76	63.73	63.75	3200.0
2016-12-22 08:00:00	MSFT	Stock	63.7	63.88	63.7	63.87	31061.0
2016-12-22 08:30:00	MSFT	Stock	63.85	63.95	63.84	63.94	12349.0
2016-12-22 09:00:00	MSFT	Stock	63.95	64.05	63.85	63.9	36061.0
2016-12-22 09:30:00	MSFT	Stock	63.84	64.1	63.535	63.688	3795495.0
2016-12-22 10:00:00	MSFT	Stock	63.68	63.94	63.63	63.93	1896548.0
2016-12-22 10:30:00	MSFT	Stock	63.93	63.94	63.76	63.78	1178009.0
2016-12-22 11:00:00	MSFT	Stock	63.79	63.81	63.64	63.645	1189981.0
2016-12-22 11:30:00	MSFT	Stock	63.65	63.68	63.41	63.49	1364477.0
2016-12-22 12:00:00	MSFT	Stock	63.48	63.6	63.47	63.57	767987.0
2016-12-22 12:30:00	MSFT	Stock	63.58	63.61	63.475	63.52	813224.0
2016-12-22 13:00:00	MSFT	Stock	63.51	63.665	63.49	63.59	744677.0
2016-12-22 13:30:00	MSFT	Stock	63.59	63.72	63.58	63.67	1071021.0
2016-12-22 14:00:00	MSFT	Stock	63.66	63.76	63.62	63.63	807820.0
2016-12-22 14:30:00	MSFT	Stock	63.62	63.64	63.56	63.585	726370.0

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

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