PREVIEW / stock_30min / 2014-04-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-30.parquet
  size:    1.6 MB
  rows:    84,007
  symbols: 3,555

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-04-30 04:30:00	AAPL	Stock	21.0714	21.0714	21.0357	21.0357	5600.0
2014-04-30 05:30:00	AAPL	Stock	21.0857	21.0857	21.0721	21.0721	29680.0
2014-04-30 06:00:00	AAPL	Stock	21.0736	21.1071	21.0736	21.1071	34468.0
2014-04-30 06:30:00	AAPL	Stock	21.125	21.1286	21.125	21.1286	17024.0
2014-04-30 07:00:00	AAPL	Stock	21.1246	21.1339	21.0946	21.1218	162848.0
2014-04-30 07:30:00	AAPL	Stock	21.1425	21.2343	21.1425	21.2282	776552.0
2014-04-30 08:00:00	AAPL	Stock	21.2146	21.2568	21.1593	21.2321	1178548.0
2014-04-30 08:30:00	AAPL	Stock	21.22	21.2286	21.1914	21.1939	603148.0
2014-04-30 09:00:00	AAPL	Stock	21.1964	21.2018	21.1464	21.1675	883148.0
2014-04-30 09:30:00	AAPL	Stock	21.1657	21.25	21.1161	21.1629	36616244.0
2014-04-30 10:00:00	AAPL	Stock	21.1643	21.2839	21.1436	21.2625	24244024.0
2014-04-30 10:30:00	AAPL	Stock	21.2596	21.4	21.2564	21.3986	38129084.0
2014-04-30 11:00:00	AAPL	Stock	21.3954	21.4082	21.3271	21.3554	19210016.0
2014-04-30 11:30:00	AAPL	Stock	21.3554	21.3643	21.2861	21.3132	13740468.0
2014-04-30 12:00:00	AAPL	Stock	21.3143	21.385	21.3141	21.3529	12968872.0
2014-04-30 12:30:00	AAPL	Stock	21.3546	21.3707	21.3286	21.3439	6106240.0
2014-04-30 13:00:00	AAPL	Stock	21.3421	21.3643	21.3214	21.3532	7732816.0
2014-04-30 13:30:00	AAPL	Stock	21.3518	21.3646	21.3411	21.3564	5812156.0
2014-04-30 14:00:00	AAPL	Stock	21.3536	21.4071	21.2939	21.3154	21928088.0
2014-04-30 14:30:00	AAPL	Stock	21.3161	21.3414	21.2104	21.2189	23578296.0
2014-04-30 15:00:00	AAPL	Stock	21.2188	21.24	21.1364	21.1507	26610136.0
2014-04-30 15:30:00	AAPL	Stock	21.1489	21.1714	21.0643	21.0729	45163412.0
2014-04-30 16:00:00	AAPL	Stock	21.0746	21.2587	21.0721	21.0746	95630640.0
2014-04-30 16:30:00	AAPL	Stock	21.1057	21.3319	21.0704	21.1214	4039448.0
2014-04-30 17:00:00	AAPL	Stock	21.1214	21.1214	21.1096	21.1114	95088.0
2014-04-30 17:30:00	AAPL	Stock	21.1114	21.1132	21.0746	21.0964	174692.0
2014-04-30 18:00:00	AAPL	Stock	21.1143	21.1254	21.0746	21.1071	205436.0
2014-04-30 18:30:00	AAPL	Stock	21.1229	21.1304	21.1146	21.1304	82040.0
2014-04-30 19:00:00	AAPL	Stock	21.1182	21.1329	21.1182	21.1329	63000.0
2014-04-30 19:30:00	AAPL	Stock	21.1329	21.1329	21.1168	21.1168	78316.0
2014-04-30 04:00:00	MSFT	Stock	40.5	40.5	40.5	40.5	100.0
2014-04-30 07:30:00	MSFT	Stock	40.36	40.51	40.36	40.51	300.0
2014-04-30 08:00:00	MSFT	Stock	40.51	40.51	40.51	40.51	5700.0
2014-04-30 08:30:00	MSFT	Stock	40.48	40.51	40.45	40.49	2100.0
2014-04-30 09:00:00	MSFT	Stock	40.48	40.48	40.37	40.37	6179.0
2014-04-30 09:30:00	MSFT	Stock	40.4	40.495	40.17	40.27	3232209.0
2014-04-30 10:00:00	MSFT	Stock	40.265	40.34	40.19	40.26	2571648.0
2014-04-30 10:30:00	MSFT	Stock	40.27	40.34	40.24	40.256	2805771.0
2014-04-30 11:00:00	MSFT	Stock	40.25	40.35	40.245	40.3	2184266.0
2014-04-30 11:30:00	MSFT	Stock	40.3	40.34	40.27	40.3	1097859.0
2014-04-30 12:00:00	MSFT	Stock	40.31	40.35	40.3	40.305	1133634.0
2014-04-30 12:30:00	MSFT	Stock	40.31	40.39	40.304	40.375	1324141.0
2014-04-30 13:00:00	MSFT	Stock	40.375	40.39	40.36	40.365	826384.0
2014-04-30 13:30:00	MSFT	Stock	40.36	40.38	40.33	40.34	871817.0
2014-04-30 14:00:00	MSFT	Stock	40.335	40.46	40.27	40.355	2689783.0
2014-04-30 14:30:00	MSFT	Stock	40.36	40.455	40.34	40.4	1870280.0
2014-04-30 15:00:00	MSFT	Stock	40.4	40.41	40.24	40.265	2309676.0
2014-04-30 15:30:00	MSFT	Stock	40.27	40.5	40.24	40.4	6169534.0
2014-04-30 16:00:00	MSFT	Stock	40.4	40.413	40.24	40.24	4563340.0
2014-04-30 16:30:00	MSFT	Stock	40.29	40.4	40.25	40.289	138233.0

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

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