PREVIEW / stock_30min / 2016-08-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-24.parquet
  size:    1.6 MB
  rows:    81,153
  symbols: 3,267

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-08-24 04:00:00	AAPL	Stock	27.235	27.235	27.235	27.235	824.0
2016-08-24 06:00:00	AAPL	Stock	27.23	27.2425	27.23	27.2425	1200.0
2016-08-24 06:30:00	AAPL	Stock	27.2125	27.2125	27.2125	27.2125	400.0
2016-08-24 07:00:00	AAPL	Stock	27.215	27.245	27.205	27.205	5060.0
2016-08-24 07:30:00	AAPL	Stock	27.2075	27.2225	27.2075	27.2225	3000.0
2016-08-24 08:00:00	AAPL	Stock	27.215	27.2375	27.215	27.2275	7524.0
2016-08-24 08:30:00	AAPL	Stock	27.23	27.2425	27.2275	27.2325	22644.0
2016-08-24 09:00:00	AAPL	Stock	27.23	27.24	27.1425	27.1425	216260.0
2016-08-24 09:30:00	AAPL	Stock	27.1425	27.1875	27.03	27.066	12916856.0
2016-08-24 10:00:00	AAPL	Stock	27.0675	27.0975	27.04	27.0875	5827148.0
2016-08-24 10:30:00	AAPL	Stock	27.0875	27.0875	27.0	27.0325	7160896.0
2016-08-24 11:00:00	AAPL	Stock	27.035	27.065	26.9812	27.0088	5979740.0
2016-08-24 11:30:00	AAPL	Stock	27.0075	27.0312	26.9825	27.0062	4432456.0
2016-08-24 12:00:00	AAPL	Stock	27.0075	27.035	26.9825	27.0235	4514164.0
2016-08-24 12:30:00	AAPL	Stock	27.0225	27.075	27.0225	27.0725	4049440.0
2016-08-24 13:00:00	AAPL	Stock	27.072	27.1	27.055	27.062	3425280.0
2016-08-24 13:30:00	AAPL	Stock	27.0625	27.08	27.0525	27.0725	1922828.0
2016-08-24 14:00:00	AAPL	Stock	27.0725	27.0725	26.9975	27.025	4450948.0
2016-08-24 14:30:00	AAPL	Stock	27.0225	27.0725	27.0075	27.06	3817116.0
2016-08-24 15:00:00	AAPL	Stock	27.06	27.08	27.0175	27.03	5839500.0
2016-08-24 15:30:00	AAPL	Stock	27.0312	27.045	26.92	27.01	13705404.0
2016-08-24 16:00:00	AAPL	Stock	27.01	27.015	26.975	26.9875	6559684.0
2016-08-24 16:30:00	AAPL	Stock	27.0	27.0075	26.975	26.98	28664.0
2016-08-24 17:00:00	AAPL	Stock	26.98	26.985	26.965	26.9825	19800.0
2016-08-24 17:30:00	AAPL	Stock	26.975	26.9825	26.97	26.9775	14092.0
2016-08-24 18:00:00	AAPL	Stock	26.975	26.9825	26.9625	26.97	30024.0
2016-08-24 18:30:00	AAPL	Stock	26.97	27.0075	26.965	26.965	87152.0
2016-08-24 19:00:00	AAPL	Stock	26.965	26.965	26.965	26.965	2200.0
2016-08-24 19:30:00	AAPL	Stock	26.965	26.975	26.9625	26.975	16428.0
2016-08-24 06:00:00	MSFT	Stock	57.91	57.91	57.91	57.91	309.0
2016-08-24 07:30:00	MSFT	Stock	57.95	58.0	57.95	58.0	211.0
2016-08-24 08:00:00	MSFT	Stock	57.95	58.0	57.95	58.0	2700.0
2016-08-24 08:30:00	MSFT	Stock	58.0	58.0	57.9	58.0	2400.0
2016-08-24 09:00:00	MSFT	Stock	58.0	58.03	57.82	57.83	21142.0
2016-08-24 09:30:00	MSFT	Stock	57.82	57.88	57.715	57.8	1913864.0
2016-08-24 10:00:00	MSFT	Stock	57.809	57.95	57.76	57.835	788137.0
2016-08-24 10:30:00	MSFT	Stock	57.83	57.92	57.8	57.825	1258856.0
2016-08-24 11:00:00	MSFT	Stock	57.83	57.96	57.81	57.92	820462.0
2016-08-24 11:30:00	MSFT	Stock	57.92	57.95	57.83	57.88	680131.0
2016-08-24 12:00:00	MSFT	Stock	57.88	58.04	57.88	57.99	770002.0
2016-08-24 12:30:00	MSFT	Stock	57.99	58.02	57.97	58.02	683962.0
2016-08-24 13:00:00	MSFT	Stock	58.02	58.02	57.93	58.0	668732.0
2016-08-24 13:30:00	MSFT	Stock	57.994	58.0	57.94	57.94	659937.0
2016-08-24 14:00:00	MSFT	Stock	57.946	57.95	57.82	57.885	1090434.0
2016-08-24 14:30:00	MSFT	Stock	57.88	57.97	57.87	57.97	634805.0
2016-08-24 15:00:00	MSFT	Stock	57.97	57.97	57.88	57.88	1008499.0
2016-08-24 15:30:00	MSFT	Stock	57.88	57.97	57.75	57.97	2700692.0
2016-08-24 16:00:00	MSFT	Stock	57.95	57.95	57.9	57.95	2199272.0
2016-08-24 06:00:00	NVDA	Stock	1.5792	1.5792	1.5792	1.5792	4000.0
2016-08-24 07:00:00	NVDA	Stock	1.5783	1.5785	1.5783	1.5785	40000.0

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

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