PREVIEW / stock_30min / 2015-05-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-22.parquet
  size:    1.6 MB
  rows:    81,039
  symbols: 3,493

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-05-22 04:00:00	AAPL	Stock	32.8775	32.9125	32.87	32.8975	14820.0
2015-05-22 04:30:00	AAPL	Stock	32.935	32.9575	32.935	32.9575	6740.0
2015-05-22 05:00:00	AAPL	Stock	32.9	32.95	32.9	32.95	4000.0
2015-05-22 05:30:00	AAPL	Stock	32.95	32.955	32.9375	32.9375	32600.0
2015-05-22 06:00:00	AAPL	Stock	32.9325	32.9375	32.9125	32.92	8072.0
2015-05-22 06:30:00	AAPL	Stock	32.91	32.9125	32.8975	32.8975	4480.0
2015-05-22 07:00:00	AAPL	Stock	32.9	32.9375	32.8975	32.9375	56948.0
2015-05-22 07:30:00	AAPL	Stock	32.9425	32.975	32.9375	32.9725	179320.0
2015-05-22 08:00:00	AAPL	Stock	32.97	33.0375	32.9	32.995	570528.0
2015-05-22 08:30:00	AAPL	Stock	32.9925	32.9975	32.925	32.935	369636.0
2015-05-22 09:00:00	AAPL	Stock	32.935	32.9425	32.8925	32.9	741296.0
2015-05-22 09:30:00	AAPL	Stock	32.9	33.1225	32.85	33.09	33363876.0
2015-05-22 10:00:00	AAPL	Stock	33.09	33.175	33.0725	33.1325	19173724.0
2015-05-22 10:30:00	AAPL	Stock	33.1335	33.225	33.12	33.1975	15471048.0
2015-05-22 11:00:00	AAPL	Stock	33.1975	33.2175	33.065	33.0938	12664124.0
2015-05-22 11:30:00	AAPL	Stock	33.095	33.11	33.0325	33.1075	8828120.0
2015-05-22 12:00:00	AAPL	Stock	33.11	33.13	33.0925	33.1075	5703176.0
2015-05-22 12:30:00	AAPL	Stock	33.1075	33.14	33.0885	33.095	4497244.0
2015-05-22 13:00:00	AAPL	Stock	33.0975	33.2275	33.085	33.21	12519080.0
2015-05-22 13:30:00	AAPL	Stock	33.21	33.2425	33.1812	33.1975	8182720.0
2015-05-22 14:00:00	AAPL	Stock	33.1952	33.1975	33.1325	33.165	6924316.0
2015-05-22 14:30:00	AAPL	Stock	33.1658	33.2025	33.1202	33.199	6149204.0
2015-05-22 15:00:00	AAPL	Stock	33.1992	33.2375	33.16	33.1925	9382608.0
2015-05-22 15:30:00	AAPL	Stock	33.195	33.22	33.135	33.1425	17760928.0
2015-05-22 16:00:00	AAPL	Stock	33.135	33.1875	33.116	33.1675	9012576.0
2015-05-22 16:30:00	AAPL	Stock	33.165	33.175	33.1625	33.1702	84860.0
2015-05-22 17:00:00	AAPL	Stock	33.1675	33.1725	33.155	33.1625	22944.0
2015-05-22 17:30:00	AAPL	Stock	33.1625	33.195	33.1622	33.1875	206272.0
2015-05-22 18:00:00	AAPL	Stock	33.1925	33.2075	33.1875	33.2	111656.0
2015-05-22 18:30:00	AAPL	Stock	33.1975	33.2	33.19	33.19	42680.0
2015-05-22 19:00:00	AAPL	Stock	33.195	33.2	33.1875	33.1925	30880.0
2015-05-22 19:30:00	AAPL	Stock	33.1975	33.2	33.1878	33.1925	64788.0
2015-05-22 06:30:00	MSFT	Stock	47.42	47.42	47.42	47.42	500.0
2015-05-22 07:00:00	MSFT	Stock	47.41	47.43	47.41	47.43	1900.0
2015-05-22 07:30:00	MSFT	Stock	47.43	47.44	47.4	47.4	2200.0
2015-05-22 08:00:00	MSFT	Stock	47.42	47.449	47.37	47.37	4255.0
2015-05-22 08:30:00	MSFT	Stock	47.29	47.35	47.2	47.35	4265.0
2015-05-22 09:00:00	MSFT	Stock	47.37	47.37	47.26	47.36	16900.0
2015-05-22 09:30:00	MSFT	Stock	47.3	47.35	47.11	47.11	2951051.0
2015-05-22 10:00:00	MSFT	Stock	47.12	47.2	47.075	47.12	1212242.0
2015-05-22 10:30:00	MSFT	Stock	47.125	47.2	47.1	47.16	919833.0
2015-05-22 11:00:00	MSFT	Stock	47.16	47.16	46.96	47.0	1494308.0
2015-05-22 11:30:00	MSFT	Stock	47.005	47.02	46.95	46.985	1065951.0
2015-05-22 12:00:00	MSFT	Stock	46.985	47.07	46.97	47.064	776213.0
2015-05-22 12:30:00	MSFT	Stock	47.065	47.12	47.0	47.07	918193.0
2015-05-22 13:00:00	MSFT	Stock	47.065	47.2	47.01	47.101	2344986.0
2015-05-22 13:30:00	MSFT	Stock	47.105	47.15	47.05	47.08	1046446.0
2015-05-22 14:00:00	MSFT	Stock	47.09	47.09	46.89	46.93	1938429.0
2015-05-22 14:30:00	MSFT	Stock	46.93	47.02	46.92	46.975	834462.0
2015-05-22 15:00:00	MSFT	Stock	46.975	47.09	46.95	47.062	1272603.0

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

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