PREVIEW / stock_30min / 2016-06-28

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-28.parquet
  size:    1.6 MB
  rows:    83,422
  symbols: 3,278

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-06-28 04:00:00	AAPL	Stock	23.1375	23.25	23.1375	23.2225	10160.0
2016-06-28 04:30:00	AAPL	Stock	23.2425	23.2625	23.2225	23.2225	2380.0
2016-06-28 05:00:00	AAPL	Stock	23.2225	23.2225	23.2125	23.2125	2000.0
2016-06-28 05:30:00	AAPL	Stock	23.2	23.2625	23.2	23.25	10504.0
2016-06-28 06:00:00	AAPL	Stock	23.2525	23.3225	23.25	23.2525	23536.0
2016-06-28 06:30:00	AAPL	Stock	23.255	23.255	23.2375	23.2375	14088.0
2016-06-28 07:00:00	AAPL	Stock	23.2475	23.25	23.2025	23.2225	45144.0
2016-06-28 07:30:00	AAPL	Stock	23.225	23.2625	23.2125	23.2475	46880.0
2016-06-28 08:00:00	AAPL	Stock	23.25	23.31	23.2125	23.2875	472116.0
2016-06-28 08:30:00	AAPL	Stock	23.2825	23.33	23.28	23.2875	400644.0
2016-06-28 09:00:00	AAPL	Stock	23.2825	23.3025	23.2025	23.2225	544036.0
2016-06-28 09:30:00	AAPL	Stock	23.2225	23.2675	23.13	23.225	25548728.0
2016-06-28 10:00:00	AAPL	Stock	23.2275	23.24	23.1925	23.2062	10723612.0
2016-06-28 10:30:00	AAPL	Stock	23.205	23.22	23.105	23.1275	10716360.0
2016-06-28 11:00:00	AAPL	Stock	23.125	23.15	23.035	23.0413	9603156.0
2016-06-28 11:30:00	AAPL	Stock	23.0422	23.1475	23.035	23.135	7700036.0
2016-06-28 12:00:00	AAPL	Stock	23.1375	23.15	23.09	23.1075	5653312.0
2016-06-28 12:30:00	AAPL	Stock	23.1088	23.1825	23.096	23.1812	7135108.0
2016-06-28 13:00:00	AAPL	Stock	23.18	23.1825	23.12	23.1525	6525644.0
2016-06-28 13:30:00	AAPL	Stock	23.15	23.22	23.1375	23.2035	6606652.0
2016-06-28 14:00:00	AAPL	Stock	23.2025	23.23	23.1625	23.21	6245876.0
2016-06-28 14:30:00	AAPL	Stock	23.2125	23.32	23.21	23.29	10484144.0
2016-06-28 15:00:00	AAPL	Stock	23.2922	23.3838	23.275	23.3825	9389152.0
2016-06-28 15:30:00	AAPL	Stock	23.3825	23.415	23.3375	23.3975	18168592.0
2016-06-28 16:00:00	AAPL	Stock	23.3975	23.42	23.122	23.4	9967136.0
2016-06-28 16:30:00	AAPL	Stock	23.4	23.435	23.1978	23.435	369540.0
2016-06-28 17:00:00	AAPL	Stock	23.3975	23.435	23.3975	23.4175	937796.0
2016-06-28 17:30:00	AAPL	Stock	23.4025	23.4175	23.3975	23.4	38132.0
2016-06-28 18:00:00	AAPL	Stock	23.4	23.4	23.37	23.37	35644.0
2016-06-28 18:30:00	AAPL	Stock	23.375	23.375	23.3725	23.375	7600.0
2016-06-28 19:00:00	AAPL	Stock	23.3925	23.395	23.37	23.3875	7800.0
2016-06-28 19:30:00	AAPL	Stock	23.375	23.4	23.365	23.395	45876.0
2016-06-28 04:00:00	MSFT	Stock	48.56	49.0	48.56	48.9	1400.0
2016-06-28 04:30:00	MSFT	Stock	48.9	48.9	48.9	48.9	600.0
2016-06-28 05:30:00	MSFT	Stock	49.03	49.03	49.03	49.03	1320.0
2016-06-28 06:00:00	MSFT	Stock	48.96	48.96	48.8	48.82	4580.0
2016-06-28 06:30:00	MSFT	Stock	48.9	48.97	48.9	48.96	569.0
2016-06-28 07:00:00	MSFT	Stock	48.87	48.9	48.85	48.85	6098.0
2016-06-28 07:30:00	MSFT	Stock	48.89	48.9	48.8	48.81	9624.0
2016-06-28 08:00:00	MSFT	Stock	48.99	48.99	48.8	48.9	25977.0
2016-06-28 08:30:00	MSFT	Stock	48.9	48.98	48.85	48.9	41113.0
2016-06-28 09:00:00	MSFT	Stock	48.9	49.03	48.84	48.9	58427.0
2016-06-28 09:30:00	MSFT	Stock	48.89	49.25	48.67	49.14	5135712.0
2016-06-28 10:00:00	MSFT	Stock	49.15	49.23	49.01	49.22	2479581.0
2016-06-28 10:30:00	MSFT	Stock	49.225	49.4	49.11	49.14	2589736.0
2016-06-28 11:00:00	MSFT	Stock	49.14	49.19	48.92	48.95	1811369.0
2016-06-28 11:30:00	MSFT	Stock	48.945	49.21	48.925	49.145	1521445.0
2016-06-28 12:00:00	MSFT	Stock	49.15	49.2	49.01	49.04	882948.0
2016-06-28 12:30:00	MSFT	Stock	49.035	49.37	49.02	49.365	5272929.0
2016-06-28 13:00:00	MSFT	Stock	49.37	49.38	49.12	49.15	1414142.0

> showing 50 of 83,422 rows — these rows as CSV

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