PREVIEW / stock_30min / 2016-07-26

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-26.parquet
  size:    1.6 MB
  rows:    82,431
  symbols: 3,271

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
2016-07-26 04:00:00	AAPL	Stock	24.2725	24.2725	24.2725	24.2725	20500.0
2016-07-26 04:30:00	AAPL	Stock	24.2725	24.2725	24.2725	24.2725	8180.0
2016-07-26 05:00:00	AAPL	Stock	24.2725	24.29	24.2425	24.25	10680.0
2016-07-26 05:30:00	AAPL	Stock	24.265	24.265	24.265	24.265	400.0
2016-07-26 06:00:00	AAPL	Stock	24.2525	24.2525	24.25	24.25	3248.0
2016-07-26 06:30:00	AAPL	Stock	24.2725	24.275	24.2625	24.2625	8260.0
2016-07-26 07:00:00	AAPL	Stock	24.2625	24.265	24.25	24.25	31040.0
2016-07-26 07:30:00	AAPL	Stock	24.2575	24.5825	24.25	24.3	31456.0
2016-07-26 08:00:00	AAPL	Stock	24.2925	24.345	24.25	24.31	134696.0
2016-07-26 08:30:00	AAPL	Stock	24.3075	24.315	24.2625	24.285	141040.0
2016-07-26 09:00:00	AAPL	Stock	24.2925	24.2925	24.2075	24.2075	253080.0
2016-07-26 09:30:00	AAPL	Stock	24.2075	24.4925	24.195	24.415	23587976.0
2016-07-26 10:00:00	AAPL	Stock	24.42	24.4675	24.36	24.445	11153904.0
2016-07-26 10:30:00	AAPL	Stock	24.445	24.45	24.2275	24.2325	11560484.0
2016-07-26 11:00:00	AAPL	Stock	24.23	24.275	24.215	24.2625	10860724.0
2016-07-26 11:30:00	AAPL	Stock	24.2625	24.3075	24.2288	24.3	9259372.0
2016-07-26 12:00:00	AAPL	Stock	24.3025	24.324	24.285	24.3112	6648140.0
2016-07-26 12:30:00	AAPL	Stock	24.31	24.365	24.3075	24.3275	6024248.0
2016-07-26 13:00:00	AAPL	Stock	24.3263	24.3375	24.25	24.2638	7303764.0
2016-07-26 13:30:00	AAPL	Stock	24.2645	24.265	24.2175	24.2225	7150204.0
2016-07-26 14:00:00	AAPL	Stock	24.2228	24.2438	24.1525	24.18	11262300.0
2016-07-26 14:30:00	AAPL	Stock	24.18	24.2	24.1575	24.185	8937668.0
2016-07-26 15:00:00	AAPL	Stock	24.1855	24.22	24.105	24.1425	12071824.0
2016-07-26 15:30:00	AAPL	Stock	24.1425	24.2125	24.13	24.168	22605244.0
2016-07-26 16:00:00	AAPL	Stock	24.1675	24.3625	24.04	24.15	6929964.0
2016-07-26 16:30:00	AAPL	Stock	24.15	25.61	24.125	25.47	27598620.0
2016-07-26 17:00:00	AAPL	Stock	25.47	25.895	24.1675	25.86	15747892.0
2016-07-26 17:30:00	AAPL	Stock	25.8575	25.97	25.7025	25.7875	6262812.0
2016-07-26 18:00:00	AAPL	Stock	25.785	25.875	25.7825	25.85	2090580.0
2016-07-26 18:30:00	AAPL	Stock	25.86	25.9225	25.86	25.8925	1105220.0
2016-07-26 19:00:00	AAPL	Stock	25.895	25.8975	25.8075	25.85	364708.0
2016-07-26 19:30:00	AAPL	Stock	25.85	25.85	25.81	25.8125	535768.0
2016-07-26 05:30:00	MSFT	Stock	56.5	56.5	56.5	56.5	483.0
2016-07-26 06:30:00	MSFT	Stock	56.5	56.64	56.49	56.5	1600.0
2016-07-26 07:00:00	MSFT	Stock	56.63	56.64	56.57	56.61	2650.0
2016-07-26 07:30:00	MSFT	Stock	56.59	56.61	56.59	56.61	900.0
2016-07-26 08:00:00	MSFT	Stock	56.57	56.63	56.57	56.63	3558.0
2016-07-26 08:30:00	MSFT	Stock	56.63	56.63	56.61	56.61	750.0
2016-07-26 09:00:00	MSFT	Stock	56.61	56.69	56.52	56.52	26053.0
2016-07-26 09:30:00	MSFT	Stock	56.52	57.12	56.51	57.12	3898273.0
2016-07-26 10:00:00	MSFT	Stock	57.129	57.29	56.925	57.055	3431969.0
2016-07-26 10:30:00	MSFT	Stock	57.06	57.11	56.65	56.65	2154363.0
2016-07-26 11:00:00	MSFT	Stock	56.65	56.77	56.61	56.75	1820841.0
2016-07-26 11:30:00	MSFT	Stock	56.755	56.93	56.73	56.84	1359618.0
2016-07-26 12:00:00	MSFT	Stock	56.85	57.05	56.82	57.025	1379089.0
2016-07-26 12:30:00	MSFT	Stock	57.02	57.06	56.94	56.975	884486.0
2016-07-26 13:00:00	MSFT	Stock	56.971	56.978	56.73	56.777	1160678.0
2016-07-26 13:30:00	MSFT	Stock	56.77	56.84	56.7	56.83	778410.0
2016-07-26 14:00:00	MSFT	Stock	56.835	56.87	56.71	56.794	1058298.0
2016-07-26 14:30:00	MSFT	Stock	56.795	56.86	56.69	56.725	964789.0

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

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