PREVIEW / stock_30min / 2015-08-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-12.parquet
  size:    1.6 MB
  rows:    83,046
  symbols: 3,461

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-08-12 04:00:00	AAPL	Stock	28.3075	28.3075	27.7525	27.975	192156.0
2015-08-12 04:30:00	AAPL	Stock	27.925	27.9775	27.825	27.8525	232420.0
2015-08-12 05:00:00	AAPL	Stock	27.8525	27.95	27.8525	27.9375	98176.0
2015-08-12 05:30:00	AAPL	Stock	27.9	27.9	27.825	27.845	60912.0
2015-08-12 06:00:00	AAPL	Stock	27.845	28.025	27.8125	27.9975	178992.0
2015-08-12 06:30:00	AAPL	Stock	28.02	28.0575	28.0	28.0125	149972.0
2015-08-12 07:00:00	AAPL	Stock	28.0225	28.065	27.9125	28.03	225668.0
2015-08-12 07:30:00	AAPL	Stock	28.0175	28.07	27.9	28.07	304328.0
2015-08-12 08:00:00	AAPL	Stock	28.0625	28.3725	27.8375	28.0125	2457144.0
2015-08-12 08:30:00	AAPL	Stock	28.0075	28.165	28.0025	28.1275	790656.0
2015-08-12 09:00:00	AAPL	Stock	28.1375	28.225	28.1025	28.135	1509344.0
2015-08-12 09:30:00	AAPL	Stock	28.135	28.155	27.4075	27.7312	83503148.0
2015-08-12 10:00:00	AAPL	Stock	27.7275	27.8862	27.595	27.8812	40641576.0
2015-08-12 10:30:00	AAPL	Stock	27.8825	27.9975	27.805	27.9775	27876028.0
2015-08-12 11:00:00	AAPL	Stock	27.98	28.4575	27.97	28.455	37707324.0
2015-08-12 11:30:00	AAPL	Stock	28.4525	28.5	28.08	28.1138	28414384.0
2015-08-12 12:00:00	AAPL	Stock	28.1175	28.4522	28.0675	28.4225	20675912.0
2015-08-12 12:30:00	AAPL	Stock	28.4225	28.6	28.3875	28.55	21251736.0
2015-08-12 13:00:00	AAPL	Stock	28.55	28.7475	28.5225	28.6475	22347848.0
2015-08-12 13:30:00	AAPL	Stock	28.6462	28.8375	28.5625	28.7512	20657044.0
2015-08-12 14:00:00	AAPL	Stock	28.7475	28.8	28.6128	28.6775	17033748.0
2015-08-12 14:30:00	AAPL	Stock	28.675	28.8225	28.625	28.7955	14070276.0
2015-08-12 15:00:00	AAPL	Stock	28.7925	28.8375	28.72	28.832	13232080.0
2015-08-12 15:30:00	AAPL	Stock	28.8312	28.855	28.7475	28.815	19505308.0
2015-08-12 16:00:00	AAPL	Stock	28.81	28.925	27.6858	28.9	7863120.0
2015-08-12 16:30:00	AAPL	Stock	28.9	28.905	28.8625	28.9025	116224.0
2015-08-12 17:00:00	AAPL	Stock	28.81	28.9375	28.81	28.8975	237128.0
2015-08-12 17:30:00	AAPL	Stock	28.8925	28.9125	28.85	28.86	97044.0
2015-08-12 18:00:00	AAPL	Stock	28.865	28.9225	28.8625	28.875	46972.0
2015-08-12 18:30:00	AAPL	Stock	28.905	28.905	28.865	28.8775	21720.0
2015-08-12 19:00:00	AAPL	Stock	28.875	28.9125	28.875	28.8975	23200.0
2015-08-12 19:30:00	AAPL	Stock	28.8975	28.925	28.875	28.925	102828.0
2015-08-12 08:00:00	MSFT	Stock	45.67	46.1	45.67	46.1	980.0
2015-08-12 08:30:00	MSFT	Stock	46.14	46.3	46.03	46.03	1369.0
2015-08-12 09:00:00	MSFT	Stock	46.04	46.22	46.04	46.15	25022.0
2015-08-12 09:30:00	MSFT	Stock	46.15	46.465	46.03	46.26	2988032.0
2015-08-12 10:00:00	MSFT	Stock	46.26	46.35	46.04	46.13	2780475.0
2015-08-12 10:30:00	MSFT	Stock	46.13	46.18	45.9	45.96	2449929.0
2015-08-12 11:00:00	MSFT	Stock	45.96	46.005	45.86	45.97	2374928.0
2015-08-12 11:30:00	MSFT	Stock	45.97	45.98	45.71	45.725	2148501.0
2015-08-12 12:00:00	MSFT	Stock	45.72	45.96	45.705	45.96	1283529.0
2015-08-12 12:30:00	MSFT	Stock	45.96	46.16	45.915	46.13	907852.0
2015-08-12 13:00:00	MSFT	Stock	46.13	46.28	46.11	46.231	1410132.0
2015-08-12 13:30:00	MSFT	Stock	46.24	46.54	46.21	46.5	1487159.0
2015-08-12 14:00:00	MSFT	Stock	46.51	46.675	46.445	46.56	1773919.0
2015-08-12 14:30:00	MSFT	Stock	46.57	46.78	46.56	46.775	1337229.0
2015-08-12 15:00:00	MSFT	Stock	46.775	46.854	46.69	46.834	1352419.0
2015-08-12 15:30:00	MSFT	Stock	46.84	46.9	46.73	46.75	3683879.0
2015-08-12 16:00:00	MSFT	Stock	46.74	46.81	46.74	46.77	2593746.0
2015-08-12 16:30:00	MSFT	Stock	46.79	46.79	46.77	46.77	2749.0

> showing 50 of 83,046 rows — these rows as CSV

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