PREVIEW / stock_30min / 2015-06-30

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-30.parquet
  size:    1.6 MB
  rows:    84,048
  symbols: 3,518

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-06-30 04:00:00	AAPL	Stock	31.275	31.305	31.2375	31.2625	22920.0
2015-06-30 04:30:00	AAPL	Stock	31.2575	31.275	31.25	31.275	72576.0
2015-06-30 05:00:00	AAPL	Stock	31.29	31.355	31.2875	31.355	3984.0
2015-06-30 05:30:00	AAPL	Stock	31.3675	31.4225	31.3475	31.3575	26396.0
2015-06-30 06:00:00	AAPL	Stock	31.34	31.3575	31.3	31.3	38264.0
2015-06-30 06:30:00	AAPL	Stock	31.3	31.33	31.2875	31.33	40264.0
2015-06-30 07:00:00	AAPL	Stock	31.33	31.375	31.305	31.345	146112.0
2015-06-30 07:30:00	AAPL	Stock	31.34	31.3875	31.3375	31.365	124908.0
2015-06-30 08:00:00	AAPL	Stock	31.365	31.4125	31.305	31.3925	681544.0
2015-06-30 08:30:00	AAPL	Stock	31.3918	31.4068	31.37	31.3875	336272.0
2015-06-30 09:00:00	AAPL	Stock	31.39	31.45	31.375	31.3875	422884.0
2015-06-30 09:30:00	AAPL	Stock	31.3925	31.4275	31.215	31.255	22900184.0
2015-06-30 10:00:00	AAPL	Stock	31.2575	31.425	31.245	31.4225	16427964.0
2015-06-30 10:30:00	AAPL	Stock	31.4225	31.425	31.2675	31.375	11584916.0
2015-06-30 11:00:00	AAPL	Stock	31.3775	31.4575	31.355	31.3788	11131180.0
2015-06-30 11:30:00	AAPL	Stock	31.378	31.4212	31.345	31.375	8899068.0
2015-06-30 12:00:00	AAPL	Stock	31.375	31.4425	31.2875	31.3225	9105168.0
2015-06-30 12:30:00	AAPL	Stock	31.3238	31.345	31.2775	31.3375	6728216.0
2015-06-30 13:00:00	AAPL	Stock	31.3375	31.3675	31.2775	31.3672	5125220.0
2015-06-30 13:30:00	AAPL	Stock	31.365	31.505	31.34	31.45	10288512.0
2015-06-30 14:00:00	AAPL	Stock	31.45	31.53	31.425	31.4575	9715140.0
2015-06-30 14:30:00	AAPL	Stock	31.46	31.495	31.385	31.4	8324864.0
2015-06-30 15:00:00	AAPL	Stock	31.3988	31.425	31.355	31.385	9312248.0
2015-06-30 15:30:00	AAPL	Stock	31.3825	31.44	31.35	31.355	20312636.0
2015-06-30 16:00:00	AAPL	Stock	31.3562	31.425	31.35	31.355	13111980.0
2015-06-30 16:30:00	AAPL	Stock	31.355	31.36	31.2825	31.3425	325708.0
2015-06-30 17:00:00	AAPL	Stock	31.3425	31.3525	31.3325	31.34	59740.0
2015-06-30 17:30:00	AAPL	Stock	31.35	31.3675	31.3475	31.3642	16944.0
2015-06-30 18:00:00	AAPL	Stock	31.355	31.36	31.3525	31.3575	11240.0
2015-06-30 18:30:00	AAPL	Stock	31.36	31.3625	31.3375	31.3375	38812.0
2015-06-30 19:00:00	AAPL	Stock	31.3375	31.3542	31.335	31.3475	15620.0
2015-06-30 04:30:00	MSFT	Stock	44.6	44.6	44.6	44.6	100.0
2015-06-30 05:00:00	MSFT	Stock	44.6	44.67	44.6	44.67	850.0
2015-06-30 06:00:00	MSFT	Stock	44.66	44.66	44.66	44.66	100.0
2015-06-30 07:00:00	MSFT	Stock	44.66	44.66	44.66	44.66	2200.0
2015-06-30 07:30:00	MSFT	Stock	44.62	44.62	44.62	44.62	2000.0
2015-06-30 08:00:00	MSFT	Stock	44.647	44.75	44.62	44.65	11475.0
2015-06-30 08:30:00	MSFT	Stock	44.62	44.68	44.56	44.67	2497.0
2015-06-30 09:00:00	MSFT	Stock	44.66	44.71	44.61	44.69	19450.0
2015-06-30 09:30:00	MSFT	Stock	44.71	44.72	44.12	44.15	4156869.0
2015-06-30 10:00:00	MSFT	Stock	44.15	44.22	43.96	44.18	2993467.0
2015-06-30 10:30:00	MSFT	Stock	44.17	44.22	44.08	44.15	2503023.0
2015-06-30 11:00:00	MSFT	Stock	44.15	44.34	44.12	44.2	1861947.0
2015-06-30 11:30:00	MSFT	Stock	44.2	44.255	44.0	44.01	1837697.0
2015-06-30 12:00:00	MSFT	Stock	44.015	44.14	43.96	44.009	1230144.0
2015-06-30 12:30:00	MSFT	Stock	44.01	44.1	43.94	44.095	1373451.0
2015-06-30 13:00:00	MSFT	Stock	44.1	44.15	44.01	44.15	1018095.0
2015-06-30 13:30:00	MSFT	Stock	44.149	44.27	44.1	44.195	1237106.0
2015-06-30 14:00:00	MSFT	Stock	44.2	44.4	44.17	44.229	1353582.0
2015-06-30 14:30:00	MSFT	Stock	44.23	44.31	44.13	44.18	1288049.0

> showing 50 of 84,048 rows — these rows as CSV

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