PREVIEW / stock_30min / 2016-05-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-16.parquet
  size:    1.6 MB
  rows:    81,342
  symbols: 3,304

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-05-16 05:30:00	AAPL	Stock	22.6725	22.6725	22.6725	22.6725	2600.0
2016-05-16 06:00:00	AAPL	Stock	22.6625	22.6625	22.6625	22.6625	800.0
2016-05-16 06:30:00	AAPL	Stock	22.655	22.655	22.655	22.655	2800.0
2016-05-16 07:00:00	AAPL	Stock	22.655	22.675	22.64	22.675	13816.0
2016-05-16 07:30:00	AAPL	Stock	22.6825	23.28	22.6775	23.055	2613216.0
2016-05-16 08:00:00	AAPL	Stock	23.0425	23.125	22.65	23.0	1471904.0
2016-05-16 08:30:00	AAPL	Stock	22.995	23.0375	22.9575	23.0175	1141740.0
2016-05-16 09:00:00	AAPL	Stock	23.0175	23.1125	23.01	23.11	1504708.0
2016-05-16 09:30:00	AAPL	Stock	23.1125	23.2375	22.9125	23.175	41027816.0
2016-05-16 10:00:00	AAPL	Stock	23.1772	23.365	23.165	23.335	26374396.0
2016-05-16 10:30:00	AAPL	Stock	23.3375	23.4375	23.2675	23.3925	18254332.0
2016-05-16 11:00:00	AAPL	Stock	23.395	23.42	23.285	23.3375	15698948.0
2016-05-16 11:30:00	AAPL	Stock	23.34	23.4675	23.34	23.4375	11552932.0
2016-05-16 12:00:00	AAPL	Stock	23.4375	23.475	23.355	23.37	10714296.0
2016-05-16 12:30:00	AAPL	Stock	23.37	23.4425	23.3675	23.41	6714520.0
2016-05-16 13:00:00	AAPL	Stock	23.41	23.45	23.4	23.4235	5836424.0
2016-05-16 13:30:00	AAPL	Stock	23.424	23.5	23.39	23.4925	11231912.0
2016-05-16 14:00:00	AAPL	Stock	23.495	23.5425	23.4825	23.5275	12282024.0
2016-05-16 14:30:00	AAPL	Stock	23.5275	23.58	23.515	23.5238	12822580.0
2016-05-16 15:00:00	AAPL	Stock	23.525	23.5975	23.52	23.555	12263580.0
2016-05-16 15:30:00	AAPL	Stock	23.5575	23.5575	23.46	23.4675	19551300.0
2016-05-16 16:00:00	AAPL	Stock	23.47	23.5665	23.3815	23.48	15366584.0
2016-05-16 16:30:00	AAPL	Stock	23.4775	23.4825	23.47	23.475	98724.0
2016-05-16 17:00:00	AAPL	Stock	23.48	23.4825	23.47	23.4775	58864.0
2016-05-16 17:30:00	AAPL	Stock	23.4775	23.48	23.4725	23.48	32900.0
2016-05-16 18:00:00	AAPL	Stock	23.4875	23.495	23.47	23.495	54992.0
2016-05-16 18:30:00	AAPL	Stock	23.4875	23.495	23.4775	23.485	23792.0
2016-05-16 19:00:00	AAPL	Stock	23.485	23.485	23.4775	23.4775	14828.0
2016-05-16 19:30:00	AAPL	Stock	23.48	23.4975	23.48	23.4875	46272.0
2016-05-16 08:00:00	MSFT	Stock	51.15	51.15	51.14	51.14	1840.0
2016-05-16 08:30:00	MSFT	Stock	51.1	51.11	51.03	51.03	2189.0
2016-05-16 09:00:00	MSFT	Stock	51.09	51.14	50.78	50.78	21675.0
2016-05-16 09:30:00	MSFT	Stock	50.8	51.26	50.75	51.19	1879120.0
2016-05-16 10:00:00	MSFT	Stock	51.2	51.21	51.0	51.105	1024744.0
2016-05-16 10:30:00	MSFT	Stock	51.11	51.36	51.11	51.34	832383.0
2016-05-16 11:00:00	MSFT	Stock	51.34	51.53	51.34	51.435	1072215.0
2016-05-16 11:30:00	MSFT	Stock	51.44	51.62	51.43	51.572	854067.0
2016-05-16 12:00:00	MSFT	Stock	51.58	51.62	51.5	51.545	634131.0
2016-05-16 12:30:00	MSFT	Stock	51.55	51.62	51.51	51.59	551191.0
2016-05-16 13:00:00	MSFT	Stock	51.6	51.67	51.565	51.65	563946.0
2016-05-16 13:30:00	MSFT	Stock	51.645	51.76	51.59	51.685	947720.0
2016-05-16 14:00:00	MSFT	Stock	51.69	51.91	51.69	51.89	1022427.0
2016-05-16 14:30:00	MSFT	Stock	51.895	51.95	51.87	51.89	1065452.0
2016-05-16 15:00:00	MSFT	Stock	51.9	51.96	51.865	51.88	1344359.0
2016-05-16 15:30:00	MSFT	Stock	51.88	51.91	51.8	51.83	2706262.0
2016-05-16 16:00:00	MSFT	Stock	51.83	51.83	51.176	51.83	3897641.0
2016-05-16 16:30:00	MSFT	Stock	51.83	51.83	51.83	51.83	4700.0
2016-05-16 17:00:00	MSFT	Stock	51.83	51.87	51.82	51.82	800.0
2016-05-16 17:30:00	MSFT	Stock	51.82	51.82	51.82	51.82	1300.0
2016-05-16 18:00:00	MSFT	Stock	51.82	51.82	51.82	51.82	5000.0

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

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