PREVIEW / stock_30min / 2018-08-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-08.parquet
  size:    1.7 MB
  rows:    82,382
  symbols: 2,774

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
2018-08-08 04:00:00	AAPL	Stock	51.7	51.7	51.665	51.665	7836.0
2018-08-08 04:30:00	AAPL	Stock	51.675	51.675	51.615	51.615	10244.0
2018-08-08 05:00:00	AAPL	Stock	51.69	51.69	51.69	51.69	400.0
2018-08-08 05:30:00	AAPL	Stock	51.65	51.75	51.625	51.625	23096.0
2018-08-08 06:00:00	AAPL	Stock	51.625	51.6275	51.55	51.55	8636.0
2018-08-08 06:30:00	AAPL	Stock	51.55	51.665	51.55	51.665	28256.0
2018-08-08 07:00:00	AAPL	Stock	51.665	51.7575	51.665	51.7325	115040.0
2018-08-08 07:30:00	AAPL	Stock	51.745	51.7475	51.625	51.625	78796.0
2018-08-08 08:00:00	AAPL	Stock	51.745	51.7625	51.6075	51.6075	99192.0
2018-08-08 08:30:00	AAPL	Stock	51.6175	51.62	51.5752	51.6	79988.0
2018-08-08 09:00:00	AAPL	Stock	51.61	51.6275	51.475	51.51	624444.0
2018-08-08 09:30:00	AAPL	Stock	51.5225	51.6125	51.13	51.52	17320932.0
2018-08-08 10:00:00	AAPL	Stock	51.525	51.83	51.5125	51.755	8937276.0
2018-08-08 10:30:00	AAPL	Stock	51.755	51.9525	51.6525	51.894	6694692.0
2018-08-08 11:00:00	AAPL	Stock	51.895	51.905	51.7125	51.7645	4738176.0
2018-08-08 11:30:00	AAPL	Stock	51.765	51.86	51.6725	51.6918	3895644.0
2018-08-08 12:00:00	AAPL	Stock	51.695	51.725	51.64	51.7125	2419252.0
2018-08-08 12:30:00	AAPL	Stock	51.715	51.83	51.7125	51.8	2512876.0
2018-08-08 13:00:00	AAPL	Stock	51.795	51.8175	51.7438	51.7512	2324744.0
2018-08-08 13:30:00	AAPL	Stock	51.755	51.7925	51.6975	51.7832	2114176.0
2018-08-08 14:00:00	AAPL	Stock	51.785	51.8725	51.745	51.8575	2678208.0
2018-08-08 14:30:00	AAPL	Stock	51.8575	51.87	51.785	51.835	3027208.0
2018-08-08 15:00:00	AAPL	Stock	51.8375	51.8625	51.7975	51.83	2879224.0
2018-08-08 15:30:00	AAPL	Stock	51.8325	51.88	51.8075	51.8125	6722312.0
2018-08-08 16:00:00	AAPL	Stock	51.8125	51.8125	51.76	51.7775	8423192.0
2018-08-08 16:30:00	AAPL	Stock	51.7775	51.7775	51.7375	51.7475	35844.0
2018-08-08 17:00:00	AAPL	Stock	51.74	51.745	51.7125	51.7125	44264.0
2018-08-08 17:30:00	AAPL	Stock	51.7375	51.7375	51.7125	51.7375	12884.0
2018-08-08 18:00:00	AAPL	Stock	51.715	51.7375	51.715	51.7375	9560.0
2018-08-08 18:30:00	AAPL	Stock	51.735	51.7375	51.7225	51.7225	12300.0
2018-08-08 19:00:00	AAPL	Stock	51.735	51.7375	51.7	51.725	36780.0
2018-08-08 19:30:00	AAPL	Stock	51.725	51.75	51.7125	51.75	43140.0
2018-08-08 04:00:00	MSFT	Stock	108.22	108.79	108.22	108.79	396.0
2018-08-08 04:30:00	MSFT	Stock	108.9	108.9	108.9	108.9	300.0
2018-08-08 05:00:00	MSFT	Stock	108.9	108.9	108.9	108.9	852.0
2018-08-08 05:30:00	MSFT	Stock	108.8	108.8	108.8	108.8	495.0
2018-08-08 06:00:00	MSFT	Stock	108.8	108.8	108.8	108.8	100.0
2018-08-08 06:30:00	MSFT	Stock	108.8	108.8	108.8	108.8	200.0
2018-08-08 07:00:00	MSFT	Stock	108.77	108.8	108.77	108.8	2234.0
2018-08-08 07:30:00	MSFT	Stock	108.86	108.87	108.8	108.8	1220.0
2018-08-08 08:00:00	MSFT	Stock	108.8	108.8	108.71	108.72	1633.0
2018-08-08 08:30:00	MSFT	Stock	108.7	108.79	108.62	108.65	9283.0
2018-08-08 09:00:00	MSFT	Stock	108.71	109.34	108.63	109.33	23676.0
2018-08-08 09:30:00	MSFT	Stock	109.34	109.37	108.76	108.86	2275754.0
2018-08-08 10:00:00	MSFT	Stock	108.865	109.03	108.79	108.92	833694.0
2018-08-08 10:30:00	MSFT	Stock	108.92	109.34	108.79	109.29	1050477.0
2018-08-08 11:00:00	MSFT	Stock	109.29	109.395	109.21	109.38	703479.0
2018-08-08 11:30:00	MSFT	Stock	109.39	109.41	109.025	109.045	637273.0
2018-08-08 12:00:00	MSFT	Stock	109.04	109.2	108.96	109.086	620954.0
2018-08-08 12:30:00	MSFT	Stock	109.085	109.23	109.045	109.15	528479.0

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

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