PREVIEW / stock_30min / 2015-04-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-22.parquet
  size:    1.6 MB
  rows:    81,956
  symbols: 3,502

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-04-22 04:00:00	AAPL	Stock	31.745	31.745	31.6	31.6	23268.0
2015-04-22 05:00:00	AAPL	Stock	31.595	31.6425	31.5625	31.6275	6284.0
2015-04-22 05:30:00	AAPL	Stock	31.5975	31.63	31.5975	31.625	7200.0
2015-04-22 06:00:00	AAPL	Stock	31.6075	31.65	31.55	31.6	29216.0
2015-04-22 06:30:00	AAPL	Stock	31.6025	31.6125	31.565	31.6	18136.0
2015-04-22 07:00:00	AAPL	Stock	31.6125	31.7125	31.6125	31.7	55452.0
2015-04-22 07:30:00	AAPL	Stock	31.6975	31.705	31.675	31.705	68784.0
2015-04-22 08:00:00	AAPL	Stock	31.7	31.7325	31.5525	31.6625	230412.0
2015-04-22 08:30:00	AAPL	Stock	31.6625	31.75	31.6525	31.7425	167972.0
2015-04-22 09:00:00	AAPL	Stock	31.7425	31.77	31.735	31.735	193120.0
2015-04-22 09:30:00	AAPL	Stock	31.7475	31.7925	31.58	31.6825	19489720.0
2015-04-22 10:00:00	AAPL	Stock	31.6825	31.714	31.5825	31.6835	8823084.0
2015-04-22 10:30:00	AAPL	Stock	31.6838	31.7525	31.6275	31.7275	8226260.0
2015-04-22 11:00:00	AAPL	Stock	31.7275	31.8182	31.7275	31.8	7650864.0
2015-04-22 11:30:00	AAPL	Stock	31.8	31.8175	31.745	31.8025	5581476.0
2015-04-22 12:00:00	AAPL	Stock	31.805	31.8925	31.755	31.8912	8755916.0
2015-04-22 12:30:00	AAPL	Stock	31.89	31.93	31.8788	31.9035	6208832.0
2015-04-22 13:00:00	AAPL	Stock	31.905	31.91	31.85	31.895	5067740.0
2015-04-22 13:30:00	AAPL	Stock	31.8925	31.975	31.8875	31.971	9459432.0
2015-04-22 14:00:00	AAPL	Stock	31.97	32.0162	31.96	32.0088	7561216.0
2015-04-22 14:30:00	AAPL	Stock	32.01	32.08	32.0	32.0762	9763788.0
2015-04-22 15:00:00	AAPL	Stock	32.075	32.2175	32.075	32.1625	16416496.0
2015-04-22 15:30:00	AAPL	Stock	32.1612	32.1775	32.1125	32.1575	14542240.0
2015-04-22 16:00:00	AAPL	Stock	32.1575	32.16	32.1175	32.145	12481676.0
2015-04-22 16:30:00	AAPL	Stock	32.145	32.1525	32.0025	32.07	434812.0
2015-04-22 17:00:00	AAPL	Stock	32.0575	32.1	32.045	32.0722	95800.0
2015-04-22 17:30:00	AAPL	Stock	32.0575	32.09	32.0575	32.075	56732.0
2015-04-22 18:00:00	AAPL	Stock	32.075	32.1025	32.075	32.1025	32152.0
2015-04-22 18:30:00	AAPL	Stock	32.1025	32.1225	32.1025	32.1125	37380.0
2015-04-22 19:00:00	AAPL	Stock	32.1025	32.1172	32.1025	32.1025	36344.0
2015-04-22 19:30:00	AAPL	Stock	32.1025	32.1175	32.0875	32.1125	108392.0
2015-04-22 04:00:00	MSFT	Stock	42.51	42.51	42.5	42.5	300.0
2015-04-22 07:00:00	MSFT	Stock	42.49	42.51	42.48	42.48	1500.0
2015-04-22 07:30:00	MSFT	Stock	42.48	42.48	42.42	42.42	2208.0
2015-04-22 08:00:00	MSFT	Stock	42.5	42.53	42.45	42.49	2475.0
2015-04-22 08:30:00	MSFT	Stock	42.49	42.6	42.42	42.6	9937.0
2015-04-22 09:00:00	MSFT	Stock	42.62	42.7	42.62	42.68	17184.0
2015-04-22 09:30:00	MSFT	Stock	42.67	42.83	42.59	42.66	2415198.0
2015-04-22 10:00:00	MSFT	Stock	42.68	42.75	42.55	42.66	1664058.0
2015-04-22 10:30:00	MSFT	Stock	42.655	42.94	42.62	42.925	2066742.0
2015-04-22 11:00:00	MSFT	Stock	42.925	43.04	42.925	43.02	2740920.0
2015-04-22 11:30:00	MSFT	Stock	43.02	43.08	42.92	43.06	1183175.0
2015-04-22 12:00:00	MSFT	Stock	43.06	43.1	43.01	43.06	1150994.0
2015-04-22 12:30:00	MSFT	Stock	43.06	43.08	43.02	43.04	1096752.0
2015-04-22 13:00:00	MSFT	Stock	43.034	43.085	42.98	43.04	1135472.0
2015-04-22 13:30:00	MSFT	Stock	43.045	43.09	42.96	43.048	930144.0
2015-04-22 14:00:00	MSFT	Stock	43.05	43.12	43.01	43.037	1530626.0
2015-04-22 14:30:00	MSFT	Stock	43.035	43.08	43.0	43.03	1058667.0
2015-04-22 15:00:00	MSFT	Stock	43.03	43.13	43.02	43.09	1522505.0
2015-04-22 15:30:00	MSFT	Stock	43.086	43.1	42.97	42.98	2593211.0

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

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