PREVIEW / stock_30min / 2018-12-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-27.parquet
  size:    1.7 MB
  rows:    87,345
  symbols: 2,724

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-12-27 04:00:00	AAPL	Stock	38.745	39.0175	38.675	38.675	29148.0
2018-12-27 04:30:00	AAPL	Stock	38.6225	38.6375	38.5875	38.625	20948.0
2018-12-27 05:00:00	AAPL	Stock	38.6125	38.75	38.58	38.625	44736.0
2018-12-27 05:30:00	AAPL	Stock	38.745	38.8	38.625	38.66	19100.0
2018-12-27 06:00:00	AAPL	Stock	38.745	38.775	38.745	38.775	4612.0
2018-12-27 06:30:00	AAPL	Stock	38.765	38.8	38.68	38.68	12764.0
2018-12-27 07:00:00	AAPL	Stock	38.68	38.8575	38.5625	38.7325	139536.0
2018-12-27 07:30:00	AAPL	Stock	38.75	38.8575	38.725	38.7725	31628.0
2018-12-27 08:00:00	AAPL	Stock	38.7575	39.3875	38.595	38.825	334152.0
2018-12-27 08:30:00	AAPL	Stock	38.835	38.835	38.745	38.78	174072.0
2018-12-27 09:00:00	AAPL	Stock	38.7875	39.05	38.7775	38.945	305220.0
2018-12-27 09:30:00	AAPL	Stock	38.96	39.0625	38.2725	38.4075	23089596.0
2018-12-27 10:00:00	AAPL	Stock	38.3975	38.5425	38.015	38.07	15794840.0
2018-12-27 10:30:00	AAPL	Stock	38.0625	38.1725	37.8575	37.9188	14252392.0
2018-12-27 11:00:00	AAPL	Stock	37.905	38.215	37.835	38.1975	9718960.0
2018-12-27 11:30:00	AAPL	Stock	38.195	38.2775	37.98	38.1385	10827160.0
2018-12-27 12:00:00	AAPL	Stock	38.1425	38.165	37.7425	37.7978	9160408.0
2018-12-27 12:30:00	AAPL	Stock	37.7975	38.0275	37.765	38.0175	6493304.0
2018-12-27 13:00:00	AAPL	Stock	38.0188	38.039	37.77	37.801	6254484.0
2018-12-27 13:30:00	AAPL	Stock	37.7975	37.8675	37.5375	37.6025	7134168.0
2018-12-27 14:00:00	AAPL	Stock	37.6025	37.7275	37.5175	37.7092	9163120.0
2018-12-27 14:30:00	AAPL	Stock	37.711	38.1025	37.61	38.1025	8804880.0
2018-12-27 15:00:00	AAPL	Stock	38.105	38.625	37.92	38.6075	16623184.0
2018-12-27 15:30:00	AAPL	Stock	38.61	39.1925	38.3425	39.1325	30915728.0
2018-12-27 16:00:00	AAPL	Stock	39.1325	39.2	38.97	39.0875	16578312.0
2018-12-27 16:30:00	AAPL	Stock	39.1	39.125	39.0375	39.05	190372.0
2018-12-27 17:00:00	AAPL	Stock	39.075	39.075	39.045	39.055	113464.0
2018-12-27 17:30:00	AAPL	Stock	39.0675	39.0725	39.0325	39.0325	87176.0
2018-12-27 18:00:00	AAPL	Stock	39.0375	39.0375	38.7975	38.8525	60252.0
2018-12-27 18:30:00	AAPL	Stock	38.84	39.0375	38.7675	38.825	5540236.0
2018-12-27 19:00:00	AAPL	Stock	38.85	38.9625	38.85	38.9125	30952.0
2018-12-27 19:30:00	AAPL	Stock	38.9	39.025	38.9	39.0	35004.0
2018-12-27 04:00:00	MSFT	Stock	99.01	99.06	98.0	98.16	7909.0
2018-12-27 04:30:00	MSFT	Stock	98.69	98.69	98.53	98.53	200.0
2018-12-27 05:00:00	MSFT	Stock	98.26	98.84	98.24	98.84	1601.0
2018-12-27 05:30:00	MSFT	Stock	98.89	98.93	98.6	98.6	573.0
2018-12-27 06:00:00	MSFT	Stock	98.8	98.82	98.74	98.8	2052.0
2018-12-27 06:30:00	MSFT	Stock	98.8	98.98	98.6	98.6	2645.0
2018-12-27 07:00:00	MSFT	Stock	98.87	99.13	98.47	98.88	22589.0
2018-12-27 07:30:00	MSFT	Stock	98.87	99.25	98.87	99.06	8712.0
2018-12-27 08:00:00	MSFT	Stock	98.901	100.8	98.7	99.08	41460.0
2018-12-27 08:30:00	MSFT	Stock	99.05	99.1	98.76	98.9	16269.0
2018-12-27 09:00:00	MSFT	Stock	98.781	99.5	98.781	99.3	36016.0
2018-12-27 09:30:00	MSFT	Stock	99.25	99.75	98.39	98.72	3891941.0
2018-12-27 10:00:00	MSFT	Stock	98.7	99.02	97.34	97.4	3327900.0
2018-12-27 10:30:00	MSFT	Stock	97.396	98.41	97.13	97.89	3670225.0
2018-12-27 11:00:00	MSFT	Stock	97.88	98.56	97.63	98.48	2164777.0
2018-12-27 11:30:00	MSFT	Stock	98.48	98.81	97.87	98.28	2257329.0
2018-12-27 12:00:00	MSFT	Stock	98.29	98.33	97.5	97.68	1923489.0
2018-12-27 12:30:00	MSFT	Stock	97.69	98.04	97.32	97.97	1955316.0

> showing 50 of 87,345 rows — these rows as CSV

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