PREVIEW / stock_30min / 2018-01-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-25.parquet
  size:    1.7 MB
  rows:    84,569
  symbols: 2,888

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-01-25 04:00:00	AAPL	Stock	43.6725	43.675	43.6725	43.675	968.0
2018-01-25 04:30:00	AAPL	Stock	43.6725	43.7125	43.64	43.7125	18104.0
2018-01-25 05:00:00	AAPL	Stock	43.6975	43.6975	43.6975	43.6975	1600.0
2018-01-25 05:30:00	AAPL	Stock	43.7175	43.7675	43.7175	43.7625	11344.0
2018-01-25 06:00:00	AAPL	Stock	43.7425	43.775	43.7175	43.7475	32820.0
2018-01-25 06:30:00	AAPL	Stock	43.725	43.75	43.7125	43.7125	9668.0
2018-01-25 07:00:00	AAPL	Stock	43.715	43.7375	43.7	43.725	49840.0
2018-01-25 07:30:00	AAPL	Stock	43.725	43.8075	43.72	43.7675	61344.0
2018-01-25 08:00:00	AAPL	Stock	43.77	43.7875	43.7125	43.7375	126824.0
2018-01-25 08:30:00	AAPL	Stock	43.7375	43.765	43.6725	43.715	246688.0
2018-01-25 09:00:00	AAPL	Stock	43.7325	43.74	43.565	43.5675	342740.0
2018-01-25 09:30:00	AAPL	Stock	43.57	43.7375	43.1175	43.27	18300904.0
2018-01-25 10:00:00	AAPL	Stock	43.275	43.325	43.065	43.205	13344476.0
2018-01-25 10:30:00	AAPL	Stock	43.2075	43.355	43.18	43.2675	7878024.0
2018-01-25 11:00:00	AAPL	Stock	43.2688	43.3925	43.2438	43.3332	6776992.0
2018-01-25 11:30:00	AAPL	Stock	43.3338	43.3938	43.325	43.38	6779644.0
2018-01-25 12:00:00	AAPL	Stock	43.38	43.425	43.3	43.3118	5671420.0
2018-01-25 12:30:00	AAPL	Stock	43.3118	43.3275	43.16	43.16	5294968.0
2018-01-25 13:00:00	AAPL	Stock	43.16	43.1975	43.0375	43.1262	7306556.0
2018-01-25 13:30:00	AAPL	Stock	43.1275	43.16	43.0712	43.085	4956788.0
2018-01-25 14:00:00	AAPL	Stock	43.0875	43.0875	42.845	42.8875	12588940.0
2018-01-25 14:30:00	AAPL	Stock	42.89	42.9	42.695	42.8025	13288400.0
2018-01-25 15:00:00	AAPL	Stock	42.805	42.815	42.6325	42.7375	13415688.0
2018-01-25 15:30:00	AAPL	Stock	42.7375	42.8375	42.6875	42.775	17750632.0
2018-01-25 16:00:00	AAPL	Stock	42.7775	42.8475	42.775	42.8475	8857916.0
2018-01-25 16:30:00	AAPL	Stock	42.8475	42.855	42.7775	42.85	3487236.0
2018-01-25 17:00:00	AAPL	Stock	42.85	42.8525	42.7775	42.835	39576.0
2018-01-25 17:30:00	AAPL	Stock	42.8225	42.855	42.8225	42.8525	64976.0
2018-01-25 18:00:00	AAPL	Stock	42.8525	42.8875	42.85	42.8875	82016.0
2018-01-25 18:30:00	AAPL	Stock	42.895	42.9325	42.895	42.91	78776.0
2018-01-25 19:00:00	AAPL	Stock	42.9125	42.925	42.875	42.925	32192.0
2018-01-25 19:30:00	AAPL	Stock	42.915	42.9375	42.915	42.9375	40164.0
2018-01-25 06:00:00	MSFT	Stock	92.35	92.36	92.23	92.23	637.0
2018-01-25 06:30:00	MSFT	Stock	92.42	92.45	92.42	92.45	2460.0
2018-01-25 07:00:00	MSFT	Stock	92.29	92.51	92.29	92.5	2722.0
2018-01-25 07:30:00	MSFT	Stock	92.5	92.55	92.42	92.42	1562.0
2018-01-25 08:00:00	MSFT	Stock	92.405	92.5	92.0	92.45	17899.0
2018-01-25 08:30:00	MSFT	Stock	92.41	92.65	91.82	92.54	18172.0
2018-01-25 09:00:00	MSFT	Stock	92.57	92.6	92.41	92.49	11541.0
2018-01-25 09:30:00	MSFT	Stock	92.45	92.68	91.93	92.06	3310591.0
2018-01-25 10:00:00	MSFT	Stock	92.07	92.58	91.96	92.36	1836922.0
2018-01-25 10:30:00	MSFT	Stock	92.36	92.59	92.12	92.411	1789631.0
2018-01-25 11:00:00	MSFT	Stock	92.42	92.77	92.35	92.63	1880197.0
2018-01-25 11:30:00	MSFT	Stock	92.64	93.0	92.62	92.99	1374616.0
2018-01-25 12:00:00	MSFT	Stock	92.981	93.24	92.89	93.02	1612358.0
2018-01-25 12:30:00	MSFT	Stock	93.01	93.08	92.77	92.78	1072004.0
2018-01-25 13:00:00	MSFT	Stock	92.77	92.78	92.6	92.7	841843.0
2018-01-25 13:30:00	MSFT	Stock	92.7	92.82	92.66	92.68	765272.0
2018-01-25 14:00:00	MSFT	Stock	92.68	92.78	92.37	92.425	1069979.0
2018-01-25 14:30:00	MSFT	Stock	92.425	92.485	92.19	92.225	1135530.0

> showing 50 of 84,569 rows — these rows as CSV

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