PREVIEW / stock_30min / 2017-01-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-31.parquet
  size:    1.6 MB
  rows:    82,720
  symbols: 3,129

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
2017-01-31 04:00:00	AAPL	Stock	30.3375	30.36	30.305	30.305	1944.0
2017-01-31 05:00:00	AAPL	Stock	30.4	30.4	30.395	30.395	2400.0
2017-01-31 05:30:00	AAPL	Stock	30.3725	30.3725	30.37	30.37	5596.0
2017-01-31 06:00:00	AAPL	Stock	30.375	30.3925	30.345	30.345	8304.0
2017-01-31 06:30:00	AAPL	Stock	30.3875	30.4125	30.385	30.395	16580.0
2017-01-31 07:00:00	AAPL	Stock	30.3875	30.425	30.375	30.3775	39080.0
2017-01-31 07:30:00	AAPL	Stock	30.38	30.3875	30.34	30.3475	25120.0
2017-01-31 08:00:00	AAPL	Stock	30.4	30.4	30.3275	30.335	126268.0
2017-01-31 08:30:00	AAPL	Stock	30.3425	30.355	30.2875	30.2875	130008.0
2017-01-31 09:00:00	AAPL	Stock	30.29	30.325	30.25	30.275	274112.0
2017-01-31 09:30:00	AAPL	Stock	30.2875	30.3475	30.2025	30.29	20308724.0
2017-01-31 10:00:00	AAPL	Stock	30.29	30.2962	30.2075	30.23	10902040.0
2017-01-31 10:30:00	AAPL	Stock	30.2325	30.255	30.1775	30.23	10562480.0
2017-01-31 11:00:00	AAPL	Stock	30.23	30.3025	30.2262	30.2475	9165604.0
2017-01-31 11:30:00	AAPL	Stock	30.2475	30.3075	30.2362	30.28	8433088.0
2017-01-31 12:00:00	AAPL	Stock	30.28	30.2975	30.2525	30.297	5316092.0
2017-01-31 12:30:00	AAPL	Stock	30.2975	30.305	30.2705	30.2788	5038212.0
2017-01-31 13:00:00	AAPL	Stock	30.28	30.2958	30.225	30.2425	6939784.0
2017-01-31 13:30:00	AAPL	Stock	30.2425	30.2475	30.16	30.1675	7907984.0
2017-01-31 14:00:00	AAPL	Stock	30.1688	30.205	30.155	30.199	9542500.0
2017-01-31 14:30:00	AAPL	Stock	30.1975	30.2725	30.1812	30.265	9238056.0
2017-01-31 15:00:00	AAPL	Stock	30.2675	30.3175	30.255	30.295	14116804.0
2017-01-31 15:30:00	AAPL	Stock	30.295	30.3325	30.29	30.325	25307496.0
2017-01-31 16:00:00	AAPL	Stock	30.3375	30.4	30.2685	30.34	11030552.0
2017-01-31 16:30:00	AAPL	Stock	30.36	31.3175	29.765	30.9975	17098120.0
2017-01-31 17:00:00	AAPL	Stock	31.0	31.4025	30.99	31.3325	6843468.0
2017-01-31 17:30:00	AAPL	Stock	31.3375	31.385	31.25	31.275	2825440.0
2017-01-31 18:00:00	AAPL	Stock	31.275	31.35	31.25	31.2525	767236.0
2017-01-31 18:30:00	AAPL	Stock	31.2625	31.2825	31.2125	31.2125	436548.0
2017-01-31 19:00:00	AAPL	Stock	31.2125	31.3	31.2125	31.2625	496308.0
2017-01-31 19:30:00	AAPL	Stock	31.2625	31.275	31.25	31.255	443424.0
2017-01-31 04:00:00	MSFT	Stock	65.0	65.1	65.0	65.1	1606.0
2017-01-31 05:00:00	MSFT	Stock	65.1	65.13	65.1	65.1	1542.0
2017-01-31 05:30:00	MSFT	Stock	65.19	65.19	65.17	65.17	432.0
2017-01-31 07:00:00	MSFT	Stock	65.17	65.17	65.1	65.1	527.0
2017-01-31 07:30:00	MSFT	Stock	65.05	65.05	65.05	65.05	17531.0
2017-01-31 08:00:00	MSFT	Stock	65.05	65.17	65.0	65.0	4197.0
2017-01-31 08:30:00	MSFT	Stock	65.0	65.0	64.91	65.0	4351.0
2017-01-31 09:00:00	MSFT	Stock	64.95	65.0	64.8	64.89	8546.0
2017-01-31 09:30:00	MSFT	Stock	64.86	65.15	64.54	64.67	2751479.0
2017-01-31 10:00:00	MSFT	Stock	64.665	64.81	64.5	64.675	1627704.0
2017-01-31 10:30:00	MSFT	Stock	64.68	64.74	64.43	64.505	1609239.0
2017-01-31 11:00:00	MSFT	Stock	64.505	64.6	64.45	64.45	1533543.0
2017-01-31 11:30:00	MSFT	Stock	64.45	64.475	64.26	64.355	1582387.0
2017-01-31 12:00:00	MSFT	Stock	64.354	64.53	64.345	64.49	1040375.0
2017-01-31 12:30:00	MSFT	Stock	64.49	64.52	64.44	64.45	697783.0
2017-01-31 13:00:00	MSFT	Stock	64.46	64.48	64.34	64.46	831322.0
2017-01-31 13:30:00	MSFT	Stock	64.46	64.49	64.31	64.37	1440761.0
2017-01-31 14:00:00	MSFT	Stock	64.37	64.47	64.31	64.425	1353961.0
2017-01-31 14:30:00	MSFT	Stock	64.43	64.53	64.405	64.51	1234795.0

> showing 50 of 82,720 rows — these rows as CSV

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