PREVIEW / stock_30min / 2019-05-31

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-31.parquet
  size:    1.7 MB
  rows:    86,018
  symbols: 2,610

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
2019-05-31 04:00:00	AAPL	Stock	43.8	43.9075	43.8	43.8075	23168.0
2019-05-31 04:30:00	AAPL	Stock	43.8125	43.8575	43.8125	43.8475	2564.0
2019-05-31 05:00:00	AAPL	Stock	43.8675	43.875	43.765	43.765	14460.0
2019-05-31 05:30:00	AAPL	Stock	43.75	43.75	43.62	43.6675	44568.0
2019-05-31 06:00:00	AAPL	Stock	43.6875	43.7225	43.6	43.72	11420.0
2019-05-31 06:30:00	AAPL	Stock	43.7175	43.75	43.625	43.75	15096.0
2019-05-31 07:00:00	AAPL	Stock	43.725	43.9	43.7025	43.9	148192.0
2019-05-31 07:30:00	AAPL	Stock	43.9475	43.965	43.8425	43.875	72384.0
2019-05-31 08:00:00	AAPL	Stock	43.805	43.95	43.7625	43.875	196196.0
2019-05-31 08:30:00	AAPL	Stock	43.8675	44.05	43.8675	43.9425	235280.0
2019-05-31 09:00:00	AAPL	Stock	43.945	44.0475	43.905	44.035	181340.0
2019-05-31 09:30:00	AAPL	Stock	44.0475	44.275	43.9625	44.225	12801424.0
2019-05-31 10:00:00	AAPL	Stock	44.2175	44.4975	44.2025	44.4192	7986516.0
2019-05-31 10:30:00	AAPL	Stock	44.42	44.475	44.245	44.3575	5652840.0
2019-05-31 11:00:00	AAPL	Stock	44.3525	44.4025	44.25	44.3975	4114604.0
2019-05-31 11:30:00	AAPL	Stock	44.4025	44.4175	44.19	44.275	4502272.0
2019-05-31 12:00:00	AAPL	Stock	44.2725	44.2925	44.17	44.1825	3635932.0
2019-05-31 12:30:00	AAPL	Stock	44.1825	44.2475	44.1325	44.21	3214552.0
2019-05-31 13:00:00	AAPL	Stock	44.2075	44.345	44.165	44.3425	2953492.0
2019-05-31 13:30:00	AAPL	Stock	44.3325	44.39	44.2625	44.3078	3299212.0
2019-05-31 14:00:00	AAPL	Stock	44.3125	44.3525	44.1025	44.1088	4133236.0
2019-05-31 14:30:00	AAPL	Stock	44.11	44.115	43.9625	44.035	7272352.0
2019-05-31 15:00:00	AAPL	Stock	44.035	44.0475	43.805	43.8787	7420408.0
2019-05-31 15:30:00	AAPL	Stock	43.8752	43.9275	43.7475	43.75	11764788.0
2019-05-31 16:00:00	AAPL	Stock	43.76	43.8	43.745	43.765	9670652.0
2019-05-31 16:30:00	AAPL	Stock	43.7675	43.7675	43.75	43.755	73600.0
2019-05-31 17:00:00	AAPL	Stock	43.7625	43.7925	43.7525	43.7875	85740.0
2019-05-31 17:30:00	AAPL	Stock	43.785	43.825	43.735	43.7525	36880.0
2019-05-31 18:00:00	AAPL	Stock	43.7625	43.7675	43.7375	43.7375	15616.0
2019-05-31 18:30:00	AAPL	Stock	43.7375	43.7525	43.71	43.71	22020.0
2019-05-31 19:00:00	AAPL	Stock	43.7	43.7175	43.6925	43.7	22296.0
2019-05-31 19:30:00	AAPL	Stock	43.7125	43.7375	43.6975	43.705	23164.0
2019-05-31 04:00:00	MSFT	Stock	124.0	124.02	123.99	124.02	1063.0
2019-05-31 04:30:00	MSFT	Stock	124.2	124.27	124.15	124.21	1393.0
2019-05-31 05:00:00	MSFT	Stock	124.15	124.16	124.08	124.16	456.0
2019-05-31 05:30:00	MSFT	Stock	124.0	124.0	123.59	123.65	1497.0
2019-05-31 06:00:00	MSFT	Stock	123.6	123.73	123.56	123.64	3673.0
2019-05-31 06:30:00	MSFT	Stock	123.64	123.72	123.42	123.7	3128.0
2019-05-31 07:00:00	MSFT	Stock	123.55	124.0	123.55	123.95	10998.0
2019-05-31 07:30:00	MSFT	Stock	123.97	124.17	123.95	124.0	3958.0
2019-05-31 08:00:00	MSFT	Stock	123.726	124.24	123.65	124.0	18571.0
2019-05-31 08:30:00	MSFT	Stock	124.07	124.27	124.055	124.15	17708.0
2019-05-31 09:00:00	MSFT	Stock	124.2	124.28	124.0	124.25	11128.0
2019-05-31 09:30:00	MSFT	Stock	124.23	124.615	123.52	123.83	2519590.0
2019-05-31 10:00:00	MSFT	Stock	123.85	124.17	123.78	123.9	1125886.0
2019-05-31 10:30:00	MSFT	Stock	123.905	124.28	123.59	123.94	1374945.0
2019-05-31 11:00:00	MSFT	Stock	123.94	124.2	123.87	124.13	1252177.0
2019-05-31 11:30:00	MSFT	Stock	124.14	124.19	123.61	123.712	1041758.0
2019-05-31 12:00:00	MSFT	Stock	123.71	123.835	123.32	123.48	986369.0
2019-05-31 12:30:00	MSFT	Stock	123.48	123.677	123.4	123.51	744987.0

> showing 50 of 86,018 rows — these rows as CSV

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