PREVIEW / stock_30min / 2014-07-14

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-14.parquet
  size:    1.6 MB
  rows:    84,323
  symbols: 3,583

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-07-14 04:00:00	AAPL	Stock	23.805	24.125	23.805	24.1025	48112.0
2014-07-14 04:30:00	AAPL	Stock	24.1025	24.1125	24.1025	24.1025	13488.0
2014-07-14 05:00:00	AAPL	Stock	24.105	24.1225	24.0825	24.105	74740.0
2014-07-14 05:30:00	AAPL	Stock	24.1	24.1	24.065	24.065	14200.0
2014-07-14 06:00:00	AAPL	Stock	24.0625	24.075	24.0275	24.0725	31040.0
2014-07-14 06:30:00	AAPL	Stock	24.0625	24.0625	24.035	24.0425	11948.0
2014-07-14 07:00:00	AAPL	Stock	24.04	24.075	24.0125	24.06	186284.0
2014-07-14 07:30:00	AAPL	Stock	24.0625	24.0675	23.9925	24.04	313036.0
2014-07-14 08:00:00	AAPL	Stock	24.03	24.0725	23.9575	23.995	1058772.0
2014-07-14 08:30:00	AAPL	Stock	23.995	24.0275	23.805	23.9838	499564.0
2014-07-14 09:00:00	AAPL	Stock	23.98	23.9925	23.9425	23.97	854240.0
2014-07-14 09:30:00	AAPL	Stock	23.9675	24.1675	23.9125	24.1	36765228.0
2014-07-14 10:00:00	AAPL	Stock	24.1	24.1275	24.04	24.1125	12435300.0
2014-07-14 10:30:00	AAPL	Stock	24.1148	24.115	24.0275	24.085	11972548.0
2014-07-14 11:00:00	AAPL	Stock	24.085	24.1725	24.085	24.1452	12506036.0
2014-07-14 11:30:00	AAPL	Stock	24.1475	24.21	24.125	24.1575	12055908.0
2014-07-14 12:00:00	AAPL	Stock	24.1588	24.215	24.155	24.2098	8252192.0
2014-07-14 12:30:00	AAPL	Stock	24.2075	24.2225	24.135	24.15	8955604.0
2014-07-14 13:00:00	AAPL	Stock	24.1515	24.2075	24.1475	24.1722	5746176.0
2014-07-14 13:30:00	AAPL	Stock	24.17	24.205	24.1425	24.17	6094640.0
2014-07-14 14:00:00	AAPL	Stock	24.17	24.1975	24.1675	24.175	5270676.0
2014-07-14 14:30:00	AAPL	Stock	24.1788	24.1875	24.1525	24.175	5890696.0
2014-07-14 15:00:00	AAPL	Stock	24.1765	24.18	24.0775	24.1	11095164.0
2014-07-14 15:30:00	AAPL	Stock	24.1	24.125	24.09	24.1125	12333720.0
2014-07-14 16:00:00	AAPL	Stock	24.1125	24.1722	24.0875	24.1075	6277752.0
2014-07-14 16:30:00	AAPL	Stock	24.105	24.1125	24.1025	24.1125	69448.0
2014-07-14 17:00:00	AAPL	Stock	24.115	24.1375	24.1075	24.1375	207000.0
2014-07-14 17:30:00	AAPL	Stock	24.1375	24.1425	24.1125	24.1275	169328.0
2014-07-14 18:00:00	AAPL	Stock	24.1325	24.14	24.1125	24.14	163060.0
2014-07-14 18:30:00	AAPL	Stock	24.14	24.1425	24.1125	24.14	101304.0
2014-07-14 19:00:00	AAPL	Stock	24.14	24.14	24.125	24.135	92996.0
2014-07-14 19:30:00	AAPL	Stock	24.135	24.155	24.135	24.155	100324.0
2014-07-14 08:00:00	MSFT	Stock	42.16	42.26	42.15	42.2	2571.0
2014-07-14 08:30:00	MSFT	Stock	42.15	42.26	42.09	42.26	38120.0
2014-07-14 09:00:00	MSFT	Stock	42.23	42.26	42.23	42.26	6982.0
2014-07-14 09:30:00	MSFT	Stock	42.26	42.3	42.1	42.285	2179687.0
2014-07-14 10:00:00	MSFT	Stock	42.28	42.45	42.2	42.22	1964223.0
2014-07-14 10:30:00	MSFT	Stock	42.22	42.31	42.22	42.28	886092.0
2014-07-14 11:00:00	MSFT	Stock	42.27	42.38	42.27	42.324	999553.0
2014-07-14 11:30:00	MSFT	Stock	42.32	42.33	42.24	42.29	992708.0
2014-07-14 12:00:00	MSFT	Stock	42.295	42.43	42.28	42.4	1227636.0
2014-07-14 12:30:00	MSFT	Stock	42.4	42.42	42.37	42.395	963097.0
2014-07-14 13:00:00	MSFT	Stock	42.39	42.41	42.38	42.405	557497.0
2014-07-14 13:30:00	MSFT	Stock	42.405	42.42	42.35	42.375	1556332.0
2014-07-14 14:00:00	MSFT	Stock	42.375	42.38	42.235	42.24	1210930.0
2014-07-14 14:30:00	MSFT	Stock	42.25	42.29	42.2	42.255	966459.0
2014-07-14 15:00:00	MSFT	Stock	42.25	42.26	42.15	42.155	1303426.0
2014-07-14 15:30:00	MSFT	Stock	42.155	42.16	42.04	42.14	4381658.0
2014-07-14 16:00:00	MSFT	Stock	42.14	42.251	42.06	42.189	1750014.0
2014-07-14 16:30:00	MSFT	Stock	42.064	42.297	42.064	42.297	249890.0

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

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