PREVIEW / stock_30min / 2015-09-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-21.parquet
  size:    1.6 MB
  rows:    82,236
  symbols: 3,451

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-09-21 04:00:00	AAPL	Stock	28.3725	28.3725	28.2775	28.3325	30692.0
2015-09-21 04:30:00	AAPL	Stock	28.3275	28.4	28.3275	28.4	22360.0
2015-09-21 05:00:00	AAPL	Stock	28.4025	28.4025	28.4025	28.4025	400.0
2015-09-21 05:30:00	AAPL	Stock	28.43	28.4525	28.43	28.4525	6244.0
2015-09-21 06:00:00	AAPL	Stock	28.46	28.475	28.4125	28.4125	5172.0
2015-09-21 06:30:00	AAPL	Stock	28.4175	28.4175	28.4175	28.4175	400.0
2015-09-21 07:00:00	AAPL	Stock	28.4475	28.5625	28.4475	28.5	80796.0
2015-09-21 07:30:00	AAPL	Stock	28.505	28.625	28.4475	28.5875	173668.0
2015-09-21 08:00:00	AAPL	Stock	28.5975	28.6125	28.4875	28.5925	286760.0
2015-09-21 08:30:00	AAPL	Stock	28.59	28.59	28.5	28.53	294064.0
2015-09-21 09:00:00	AAPL	Stock	28.5325	28.5325	28.41	28.41	297328.0
2015-09-21 09:30:00	AAPL	Stock	28.4175	28.64	28.41	28.58	21799956.0
2015-09-21 10:00:00	AAPL	Stock	28.5775	28.605	28.545	28.5475	12637896.0
2015-09-21 10:30:00	AAPL	Stock	28.5475	28.71	28.5475	28.6738	12943036.0
2015-09-21 11:00:00	AAPL	Stock	28.6725	28.75	28.6425	28.6925	9835212.0
2015-09-21 11:30:00	AAPL	Stock	28.6925	28.72	28.555	28.57	10370348.0
2015-09-21 12:00:00	AAPL	Stock	28.575	28.585	28.485	28.546	9326620.0
2015-09-21 12:30:00	AAPL	Stock	28.545	28.55	28.43	28.465	9026392.0
2015-09-21 13:00:00	AAPL	Stock	28.465	28.55	28.453	28.538	7980684.0
2015-09-21 13:30:00	AAPL	Stock	28.54	28.71	28.5325	28.615	12642204.0
2015-09-21 14:00:00	AAPL	Stock	28.6125	28.76	28.6075	28.705	13151852.0
2015-09-21 14:30:00	AAPL	Stock	28.705	28.825	28.6592	28.8122	11890192.0
2015-09-21 15:00:00	AAPL	Stock	28.8125	28.84	28.7775	28.83	9518668.0
2015-09-21 15:30:00	AAPL	Stock	28.8278	28.8425	28.6952	28.805	18804220.0
2015-09-21 16:00:00	AAPL	Stock	28.8025	28.8725	28.8025	28.8625	13388776.0
2015-09-21 16:30:00	AAPL	Stock	28.8525	28.8525	28.825	28.8375	114808.0
2015-09-21 17:00:00	AAPL	Stock	28.8475	28.85	28.8325	28.85	32140.0
2015-09-21 17:30:00	AAPL	Stock	28.845	28.85	28.825	28.8275	26920.0
2015-09-21 18:00:00	AAPL	Stock	28.8475	28.875	28.8175	28.8175	73984.0
2015-09-21 18:30:00	AAPL	Stock	28.83	28.8375	28.8175	28.82	37080.0
2015-09-21 19:00:00	AAPL	Stock	28.83	28.8375	28.83	28.8325	25388.0
2015-09-21 19:30:00	AAPL	Stock	28.8375	28.8475	28.83	28.8375	47548.0
2015-09-21 07:00:00	MSFT	Stock	43.7	43.7	43.7	43.7	2668.0
2015-09-21 07:30:00	MSFT	Stock	43.9	43.95	43.9	43.9	2200.0
2015-09-21 08:00:00	MSFT	Stock	43.85	43.89	43.8	43.8	2420.0
2015-09-21 08:30:00	MSFT	Stock	43.8	43.9	43.8	43.83	23418.0
2015-09-21 09:00:00	MSFT	Stock	43.86	43.86	43.62	43.62	32549.0
2015-09-21 09:30:00	MSFT	Stock	43.62	44.0	43.6	43.9	2593846.0
2015-09-21 10:00:00	MSFT	Stock	43.91	44.24	43.895	44.2	1808241.0
2015-09-21 10:30:00	MSFT	Stock	44.2	44.47	44.2	44.305	2134415.0
2015-09-21 11:00:00	MSFT	Stock	44.31	44.35	44.245	44.29	1035526.0
2015-09-21 11:30:00	MSFT	Stock	44.28	44.32	44.09	44.16	1334047.0
2015-09-21 12:00:00	MSFT	Stock	44.16	44.175	44.01	44.12	999668.0
2015-09-21 12:30:00	MSFT	Stock	44.11	44.11	43.8	43.905	1403318.0
2015-09-21 13:00:00	MSFT	Stock	43.9	44.08	43.88	44.06	894110.0
2015-09-21 13:30:00	MSFT	Stock	44.06	44.25	44.03	44.17	858280.0
2015-09-21 14:00:00	MSFT	Stock	44.17	44.24	44.09	44.19	1173164.0
2015-09-21 14:30:00	MSFT	Stock	44.19	44.45	44.16	44.41	1807787.0
2015-09-21 15:00:00	MSFT	Stock	44.4	44.42	44.28	44.34	1275386.0
2015-09-21 15:30:00	MSFT	Stock	44.35	44.39	44.08	44.13	4058507.0

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

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