PREVIEW / stock_30min / 2017-05-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-11.parquet
  size:    1.6 MB
  rows:    81,074
  symbols: 3,034

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-05-11 04:00:00	AAPL	Stock	38.3225	38.3225	38.2325	38.2325	2400.0
2017-05-11 04:30:00	AAPL	Stock	38.2075	38.2075	38.2075	38.2075	484.0
2017-05-11 05:30:00	AAPL	Stock	38.18	38.18	38.18	38.18	400.0
2017-05-11 06:00:00	AAPL	Stock	38.1875	38.2025	38.1875	38.2	2000.0
2017-05-11 06:30:00	AAPL	Stock	38.1975	38.1975	38.175	38.175	7620.0
2017-05-11 07:00:00	AAPL	Stock	38.1525	38.175	38.105	38.1425	51648.0
2017-05-11 07:30:00	AAPL	Stock	38.1425	38.1675	38.125	38.13	91976.0
2017-05-11 08:00:00	AAPL	Stock	38.145	38.175	38.12	38.165	206252.0
2017-05-11 08:30:00	AAPL	Stock	38.1425	38.215	38.1375	38.17	121824.0
2017-05-11 09:00:00	AAPL	Stock	38.1675	38.1675	38.155	38.1675	76868.0
2017-05-11 09:30:00	AAPL	Stock	38.1125	38.39	38.0875	38.14	14642612.0
2017-05-11 10:00:00	AAPL	Stock	38.135	38.235	38.0775	38.1875	8199720.0
2017-05-11 10:30:00	AAPL	Stock	38.1875	38.1915	38.09	38.115	4596100.0
2017-05-11 11:00:00	AAPL	Stock	38.1162	38.2225	38.0925	38.1808	4905172.0
2017-05-11 11:30:00	AAPL	Stock	38.18	38.2185	38.135	38.15	2676672.0
2017-05-11 12:00:00	AAPL	Stock	38.151	38.265	38.1425	38.2175	3494444.0
2017-05-11 12:30:00	AAPL	Stock	38.22	38.2345	38.15	38.1725	2354116.0
2017-05-11 13:00:00	AAPL	Stock	38.1725	38.31	38.16	38.271	3744696.0
2017-05-11 13:30:00	AAPL	Stock	38.272	38.335	38.2675	38.325	3717136.0
2017-05-11 14:00:00	AAPL	Stock	38.3275	38.4125	38.2825	38.4112	6359784.0
2017-05-11 14:30:00	AAPL	Stock	38.4122	38.4275	38.335	38.3488	3719820.0
2017-05-11 15:00:00	AAPL	Stock	38.35	38.41	38.345	38.4038	4335212.0
2017-05-11 15:30:00	AAPL	Stock	38.4025	38.5175	38.3925	38.485	12271724.0
2017-05-11 16:00:00	AAPL	Stock	38.4875	38.5075	38.15	38.4675	8576136.0
2017-05-11 16:30:00	AAPL	Stock	38.44	38.4875	38.4375	38.4625	84412.0
2017-05-11 17:00:00	AAPL	Stock	38.46	38.46	38.45	38.4575	12236.0
2017-05-11 17:30:00	AAPL	Stock	38.46	38.465	38.455	38.465	25256.0
2017-05-11 18:00:00	AAPL	Stock	38.475	38.475	38.455	38.46	17768.0
2017-05-11 18:30:00	AAPL	Stock	38.475	38.475	38.475	38.475	13012.0
2017-05-11 19:00:00	AAPL	Stock	38.47	38.47	38.4625	38.4625	2400.0
2017-05-11 19:30:00	AAPL	Stock	38.4625	38.4725	38.4625	38.47	8344.0
2017-05-11 04:00:00	MSFT	Stock	69.15	69.15	69.15	69.15	192.0
2017-05-11 07:00:00	MSFT	Stock	69.0	69.02	69.0	69.0	5612.0
2017-05-11 07:30:00	MSFT	Stock	68.95	68.95	68.5	68.6	33505.0
2017-05-11 08:00:00	MSFT	Stock	68.75	68.75	68.45	68.5	103619.0
2017-05-11 08:30:00	MSFT	Stock	68.45	68.5	68.41	68.5	36113.0
2017-05-11 09:00:00	MSFT	Stock	68.5	68.55	68.3	68.38	51863.0
2017-05-11 09:30:00	MSFT	Stock	68.36	68.73	68.27	68.465	4405862.0
2017-05-11 10:00:00	MSFT	Stock	68.45	68.47	68.12	68.37	3166892.0
2017-05-11 10:30:00	MSFT	Stock	68.375	68.505	68.24	68.26	1961867.0
2017-05-11 11:00:00	MSFT	Stock	68.265	68.33	68.19	68.32	1221974.0
2017-05-11 11:30:00	MSFT	Stock	68.32	68.42	68.22	68.234	969382.0
2017-05-11 12:00:00	MSFT	Stock	68.238	68.28	68.18	68.27	1321372.0
2017-05-11 12:30:00	MSFT	Stock	68.28	68.35	68.22	68.24	908006.0
2017-05-11 13:00:00	MSFT	Stock	68.245	68.34	68.22	68.22	859872.0
2017-05-11 13:30:00	MSFT	Stock	68.22	68.3	68.19	68.295	1418000.0
2017-05-11 14:00:00	MSFT	Stock	68.3	68.44	68.26	68.4	1307557.0
2017-05-11 14:30:00	MSFT	Stock	68.4	68.41	68.25	68.29	841597.0
2017-05-11 15:00:00	MSFT	Stock	68.29	68.32	68.26	68.285	803937.0
2017-05-11 15:30:00	MSFT	Stock	68.29	68.48	68.28	68.46	3240790.0

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

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