PREVIEW / stock_30min / 2015-04-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-17.parquet
  size:    1.6 MB
  rows:    82,567
  symbols: 3,511

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
2015-04-17 04:00:00	AAPL	Stock	31.6825	31.7	31.645	31.6575	6000.0
2015-04-17 05:00:00	AAPL	Stock	31.695	31.7125	31.6575	31.6575	8400.0
2015-04-17 05:30:00	AAPL	Stock	31.6975	31.6975	31.675	31.675	1500.0
2015-04-17 06:00:00	AAPL	Stock	31.6575	31.6575	31.34	31.3625	44452.0
2015-04-17 06:30:00	AAPL	Stock	31.325	31.44	31.275	31.425	30528.0
2015-04-17 07:00:00	AAPL	Stock	31.425	31.525	31.425	31.4875	131060.0
2015-04-17 07:30:00	AAPL	Stock	31.48	31.4875	31.4125	31.425	82848.0
2015-04-17 08:00:00	AAPL	Stock	31.425	31.55	31.275	31.5125	438660.0
2015-04-17 08:30:00	AAPL	Stock	31.5075	31.51	31.465	31.4825	205944.0
2015-04-17 09:00:00	AAPL	Stock	31.48	31.4975	31.345	31.385	987180.0
2015-04-17 09:30:00	AAPL	Stock	31.3875	31.535	31.29	31.3125	31503516.0
2015-04-17 10:00:00	AAPL	Stock	31.3125	31.3375	31.18	31.245	22425880.0
2015-04-17 10:30:00	AAPL	Stock	31.2425	31.3125	31.22	31.3062	10532236.0
2015-04-17 11:00:00	AAPL	Stock	31.3062	31.4425	31.2925	31.36	15745896.0
2015-04-17 11:30:00	AAPL	Stock	31.3625	31.412	31.315	31.3575	7412392.0
2015-04-17 12:00:00	AAPL	Stock	31.3575	31.4125	31.3575	31.3975	5496912.0
2015-04-17 12:30:00	AAPL	Stock	31.3962	31.3962	31.3	31.3275	5139144.0
2015-04-17 13:00:00	AAPL	Stock	31.33	31.3438	31.3025	31.31	4856440.0
2015-04-17 13:30:00	AAPL	Stock	31.3125	31.315	31.2225	31.25	8936344.0
2015-04-17 14:00:00	AAPL	Stock	31.2525	31.255	31.115	31.175	13643820.0
2015-04-17 14:30:00	AAPL	Stock	31.175	31.1975	31.14	31.17	8161772.0
2015-04-17 15:00:00	AAPL	Stock	31.17	31.2225	31.1425	31.185	9206368.0
2015-04-17 15:30:00	AAPL	Stock	31.1875	31.2575	31.155	31.19	18613248.0
2015-04-17 16:00:00	AAPL	Stock	31.1875	31.2175	31.175	31.2025	6384712.0
2015-04-17 16:30:00	AAPL	Stock	31.2025	31.21	31.19	31.2	245332.0
2015-04-17 17:00:00	AAPL	Stock	31.195	31.195	31.125	31.1625	90428.0
2015-04-17 17:30:00	AAPL	Stock	31.1775	31.1775	31.1	31.1725	221636.0
2015-04-17 18:00:00	AAPL	Stock	31.1725	31.1725	31.15	31.1575	43952.0
2015-04-17 18:30:00	AAPL	Stock	31.16	31.185	31.16	31.18	40980.0
2015-04-17 19:00:00	AAPL	Stock	31.175	31.1825	31.1675	31.1775	21196.0
2015-04-17 19:30:00	AAPL	Stock	31.1775	31.1775	31.1625	31.1675	40096.0
2015-04-17 04:30:00	MSFT	Stock	42.09	42.09	42.09	42.09	300.0
2015-04-17 06:00:00	MSFT	Stock	41.9	42.08	41.73	41.73	850.0
2015-04-17 06:30:00	MSFT	Stock	41.73	41.73	41.65	41.73	3100.0
2015-04-17 07:00:00	MSFT	Stock	41.79	41.79	41.78	41.78	1100.0
2015-04-17 07:30:00	MSFT	Stock	41.8	41.8	41.74	41.74	3320.0
2015-04-17 08:00:00	MSFT	Stock	41.83	41.85	41.8	41.83	7740.0
2015-04-17 08:30:00	MSFT	Stock	41.83	41.86	41.83	41.83	7227.0
2015-04-17 09:00:00	MSFT	Stock	41.82	41.86	41.67	41.68	45722.0
2015-04-17 09:30:00	MSFT	Stock	41.67	41.74	41.41	41.466	6685287.0
2015-04-17 10:00:00	MSFT	Stock	41.465	41.49	41.245	41.39	3123519.0
2015-04-17 10:30:00	MSFT	Stock	41.39	41.5	41.29	41.29	2520035.0
2015-04-17 11:00:00	MSFT	Stock	41.29	41.33	41.16	41.28	2842839.0
2015-04-17 11:30:00	MSFT	Stock	41.29	41.36	41.21	41.315	1420100.0
2015-04-17 12:00:00	MSFT	Stock	41.32	41.35	41.21	41.28	1407886.0
2015-04-17 12:30:00	MSFT	Stock	41.28	41.35	41.22	41.31	1130091.0
2015-04-17 13:00:00	MSFT	Stock	41.31	41.42	41.29	41.42	1874441.0
2015-04-17 13:30:00	MSFT	Stock	41.419	41.56	41.4	41.45	3263256.0
2015-04-17 14:00:00	MSFT	Stock	41.46	41.52	41.44	41.505	2683053.0
2015-04-17 14:30:00	MSFT	Stock	41.51	41.555	41.46	41.5	2424087.0

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

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