PREVIEW / stock_30min / 2014-12-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-19.parquet
  size:    1.7 MB
  rows:    87,978
  symbols: 3,579

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
2014-12-19 04:00:00	AAPL	Stock	28.1375	28.3375	28.1375	28.3275	23432.0
2014-12-19 04:30:00	AAPL	Stock	28.3375	28.3375	28.315	28.33	2200.0
2014-12-19 05:00:00	AAPL	Stock	28.315	28.3475	28.305	28.31	10120.0
2014-12-19 05:30:00	AAPL	Stock	28.29	28.29	28.25	28.28	7400.0
2014-12-19 06:00:00	AAPL	Stock	28.25	28.2675	28.2475	28.25	30760.0
2014-12-19 06:30:00	AAPL	Stock	28.275	28.275	28.2225	28.225	37508.0
2014-12-19 07:00:00	AAPL	Stock	28.2375	28.2875	28.2375	28.26	60084.0
2014-12-19 07:30:00	AAPL	Stock	28.2625	28.3125	28.2375	28.2375	187300.0
2014-12-19 08:00:00	AAPL	Stock	28.235	28.3125	28.2225	28.2625	450948.0
2014-12-19 08:30:00	AAPL	Stock	28.2625	28.275	28.1525	28.195	464996.0
2014-12-19 09:00:00	AAPL	Stock	28.1925	28.1925	27.9	28.05	3860636.0
2014-12-19 09:30:00	AAPL	Stock	28.065	28.11	27.915	28.0768	78402612.0
2014-12-19 10:00:00	AAPL	Stock	28.0775	28.31	28.0425	28.2475	21791148.0
2014-12-19 10:30:00	AAPL	Stock	28.2475	28.2525	28.105	28.2	12300132.0
2014-12-19 11:00:00	AAPL	Stock	28.1925	28.2075	28.0875	28.145	9451184.0
2014-12-19 11:30:00	AAPL	Stock	28.14	28.1625	28.0262	28.07	9064096.0
2014-12-19 12:00:00	AAPL	Stock	28.0675	28.0725	28.01	28.0525	7157028.0
2014-12-19 12:30:00	AAPL	Stock	28.051	28.1375	28.03	28.0922	6981388.0
2014-12-19 13:00:00	AAPL	Stock	28.09	28.1075	28.0538	28.085	6429200.0
2014-12-19 13:30:00	AAPL	Stock	28.0875	28.095	28.0175	28.0175	6082456.0
2014-12-19 14:00:00	AAPL	Stock	28.0175	28.0968	28.0162	28.0375	6383180.0
2014-12-19 14:30:00	AAPL	Stock	28.0375	28.1125	28.0225	28.095	8522884.0
2014-12-19 15:00:00	AAPL	Stock	28.1	28.1025	27.9725	28.015	13832176.0
2014-12-19 15:30:00	AAPL	Stock	28.015	28.0825	27.94	27.94	27674272.0
2014-12-19 16:00:00	AAPL	Stock	27.9475	28.1302	27.94	27.9442	108497080.0
2014-12-19 16:30:00	AAPL	Stock	28.0608	28.1598	27.9395	27.95	3467680.0
2014-12-19 17:00:00	AAPL	Stock	27.9475	28.08	27.945	27.9625	101808.0
2014-12-19 17:30:00	AAPL	Stock	27.946	27.975	27.944	27.9725	6957956.0
2014-12-19 18:00:00	AAPL	Stock	27.9725	27.985	27.945	27.965	164112.0
2014-12-19 18:30:00	AAPL	Stock	27.9625	27.9725	27.9448	27.9625	90292.0
2014-12-19 19:00:00	AAPL	Stock	27.9725	27.9725	27.9475	27.95	41748.0
2014-12-19 19:30:00	AAPL	Stock	27.9675	27.975	27.95	27.9625	46356.0
2014-12-19 04:00:00	MSFT	Stock	47.6	47.7	47.6	47.7	3100.0
2014-12-19 06:30:00	MSFT	Stock	47.7	47.7	47.7	47.7	650.0
2014-12-19 07:00:00	MSFT	Stock	47.75	47.83	47.74	47.8	1800.0
2014-12-19 07:30:00	MSFT	Stock	47.77	47.77	47.69	47.7	10267.0
2014-12-19 08:00:00	MSFT	Stock	47.74	47.84	47.65	47.67	3800.0
2014-12-19 08:30:00	MSFT	Stock	47.67	47.7	47.58	47.65	7372.0
2014-12-19 09:00:00	MSFT	Stock	47.64	47.73	47.41	47.62	1093785.0
2014-12-19 09:30:00	MSFT	Stock	47.62	47.89	47.17	47.885	21639897.0
2014-12-19 10:00:00	MSFT	Stock	47.895	47.91	47.73	47.89	1970831.0
2014-12-19 10:30:00	MSFT	Stock	47.885	47.9	47.66	47.845	1475919.0
2014-12-19 11:00:00	MSFT	Stock	47.84	47.99	47.77	47.98	1542130.0
2014-12-19 11:30:00	MSFT	Stock	47.98	47.98	47.85	47.9	1175552.0
2014-12-19 12:00:00	MSFT	Stock	47.9	47.91	47.75	47.82	1224482.0
2014-12-19 12:30:00	MSFT	Stock	47.82	47.85	47.75	47.77	1059272.0
2014-12-19 13:00:00	MSFT	Stock	47.77	47.84	47.73	47.81	976472.0
2014-12-19 13:30:00	MSFT	Stock	47.82	47.87	47.75	47.821	1090892.0
2014-12-19 14:00:00	MSFT	Stock	47.82	47.956	47.767	47.85	953151.0
2014-12-19 14:30:00	MSFT	Stock	47.86	48.005	47.82	47.99	1486046.0

> showing 50 of 87,978 rows — these rows as CSV

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