PREVIEW / stock_30min / 2016-08-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-01.parquet
  size:    1.6 MB
  rows:    81,972
  symbols: 3,270

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
2016-08-01 04:00:00	AAPL	Stock	26.1	26.125	26.1	26.125	2800.0
2016-08-01 04:30:00	AAPL	Stock	26.13	26.13	26.13	26.13	3920.0
2016-08-01 05:30:00	AAPL	Stock	26.1325	26.155	26.1325	26.1475	4920.0
2016-08-01 06:00:00	AAPL	Stock	26.1475	26.1475	26.125	26.125	13680.0
2016-08-01 06:30:00	AAPL	Stock	26.1375	26.1425	26.125	26.125	21168.0
2016-08-01 07:00:00	AAPL	Stock	26.125	26.1725	26.125	26.15	58120.0
2016-08-01 07:30:00	AAPL	Stock	26.155	26.245	26.155	26.225	19128.0
2016-08-01 08:00:00	AAPL	Stock	26.1625	26.2225	26.1275	26.205	262500.0
2016-08-01 08:30:00	AAPL	Stock	26.2075	26.21	26.155	26.1575	167664.0
2016-08-01 09:00:00	AAPL	Stock	26.16	26.1725	26.1025	26.1025	337024.0
2016-08-01 09:30:00	AAPL	Stock	26.105	26.2875	26.1025	26.2612	24316996.0
2016-08-01 10:00:00	AAPL	Stock	26.26	26.345	26.25	26.329	12212880.0
2016-08-01 10:30:00	AAPL	Stock	26.3275	26.375	26.295	26.3575	9380336.0
2016-08-01 11:00:00	AAPL	Stock	26.3575	26.385	26.3275	26.37	7997520.0
2016-08-01 11:30:00	AAPL	Stock	26.3725	26.3775	26.3275	26.335	6179640.0
2016-08-01 12:00:00	AAPL	Stock	26.3325	26.3375	26.2625	26.275	8629152.0
2016-08-01 12:30:00	AAPL	Stock	26.275	26.3338	26.2675	26.2938	6790232.0
2016-08-01 13:00:00	AAPL	Stock	26.295	26.3375	26.2875	26.3325	5138060.0
2016-08-01 13:30:00	AAPL	Stock	26.3338	26.3625	26.31	26.3525	5527468.0
2016-08-01 14:00:00	AAPL	Stock	26.35	26.385	26.34	26.375	6282692.0
2016-08-01 14:30:00	AAPL	Stock	26.375	26.4762	26.3725	26.475	9115460.0
2016-08-01 15:00:00	AAPL	Stock	26.4725	26.5075	26.42	26.435	12388808.0
2016-08-01 15:30:00	AAPL	Stock	26.4338	26.5375	26.4325	26.515	17727940.0
2016-08-01 16:00:00	AAPL	Stock	26.5125	26.535	26.151	26.52	6051948.0
2016-08-01 16:30:00	AAPL	Stock	26.52	26.5225	26.5125	26.5225	40584.0
2016-08-01 17:00:00	AAPL	Stock	26.52	26.5225	26.5125	26.5125	43216.0
2016-08-01 17:30:00	AAPL	Stock	26.5125	26.5325	26.5125	26.5175	102572.0
2016-08-01 18:00:00	AAPL	Stock	26.5175	26.535	26.5175	26.535	47160.0
2016-08-01 18:30:00	AAPL	Stock	26.5375	26.56	26.5325	26.5425	293632.0
2016-08-01 19:00:00	AAPL	Stock	26.55	26.55	26.5425	26.5425	27760.0
2016-08-01 19:30:00	AAPL	Stock	26.5325	26.5475	26.5325	26.5475	60400.0
2016-08-01 07:00:00	MSFT	Stock	56.8	56.8	56.8	56.8	175.0
2016-08-01 07:30:00	MSFT	Stock	56.7	56.7	56.7	56.7	1001.0
2016-08-01 08:00:00	MSFT	Stock	56.54	56.8	56.54	56.75	1541.0
2016-08-01 08:30:00	MSFT	Stock	56.75	56.75	56.65	56.68	2208.0
2016-08-01 09:00:00	MSFT	Stock	56.62	56.76	56.61	56.69	23900.0
2016-08-01 09:30:00	MSFT	Stock	56.69	56.75	56.38	56.47	2592764.0
2016-08-01 10:00:00	MSFT	Stock	56.46	56.615	56.43	56.54	1822094.0
2016-08-01 10:30:00	MSFT	Stock	56.545	56.56	56.44	56.555	1437137.0
2016-08-01 11:00:00	MSFT	Stock	56.55	56.74	56.54	56.69	1274470.0
2016-08-01 11:30:00	MSFT	Stock	56.69	56.71	56.45	56.455	1244227.0
2016-08-01 12:00:00	MSFT	Stock	56.45	56.455	56.22	56.251	1442786.0
2016-08-01 12:30:00	MSFT	Stock	56.255	56.31	56.2	56.255	1603690.0
2016-08-01 13:00:00	MSFT	Stock	56.26	56.35	56.22	56.315	969606.0
2016-08-01 13:30:00	MSFT	Stock	56.314	56.32	56.14	56.282	1176792.0
2016-08-01 14:00:00	MSFT	Stock	56.285	56.34	56.16	56.236	1474922.0
2016-08-01 14:30:00	MSFT	Stock	56.235	56.355	56.23	56.355	1184529.0
2016-08-01 15:00:00	MSFT	Stock	56.34	56.4	56.295	56.365	1694657.0
2016-08-01 15:30:00	MSFT	Stock	56.365	56.59	56.365	56.58	3874487.0
2016-08-01 16:00:00	MSFT	Stock	56.58	56.65	56.43	56.43	1605291.0

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

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