PREVIEW / stock_30min / 2018-03-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-07.parquet
  size:    1.7 MB
  rows:    83,976
  symbols: 2,860

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-03-07 04:00:00	AAPL	Stock	43.75	43.75	43.675	43.6775	45812.0
2018-03-07 04:30:00	AAPL	Stock	43.65	43.75	43.65	43.75	8148.0
2018-03-07 05:00:00	AAPL	Stock	43.7475	43.815	43.7475	43.8125	16628.0
2018-03-07 05:30:00	AAPL	Stock	43.7575	43.78	43.75	43.75	9564.0
2018-03-07 06:00:00	AAPL	Stock	43.75	43.75	43.6525	43.6625	37588.0
2018-03-07 06:30:00	AAPL	Stock	43.675	43.7125	43.675	43.7025	13212.0
2018-03-07 07:00:00	AAPL	Stock	43.7225	43.84	43.7125	43.81	274292.0
2018-03-07 07:30:00	AAPL	Stock	43.7975	43.8625	43.735	43.8	144332.0
2018-03-07 08:00:00	AAPL	Stock	43.7925	43.87	43.7125	43.8675	278176.0
2018-03-07 08:30:00	AAPL	Stock	43.855	43.87	43.7875	43.815	181216.0
2018-03-07 09:00:00	AAPL	Stock	43.825	43.8375	43.6925	43.7775	375016.0
2018-03-07 09:30:00	AAPL	Stock	43.7875	43.9625	43.705	43.715	17006724.0
2018-03-07 10:00:00	AAPL	Stock	43.715	43.835	43.6638	43.79	9310580.0
2018-03-07 10:30:00	AAPL	Stock	43.79	43.8675	43.75	43.832	6650128.0
2018-03-07 11:00:00	AAPL	Stock	43.83	43.8375	43.6725	43.725	6216844.0
2018-03-07 11:30:00	AAPL	Stock	43.7275	43.8	43.675	43.6775	4908336.0
2018-03-07 12:00:00	AAPL	Stock	43.6775	43.725	43.5675	43.7075	7387704.0
2018-03-07 12:30:00	AAPL	Stock	43.705	43.8375	43.695	43.805	4803924.0
2018-03-07 13:00:00	AAPL	Stock	43.8025	43.91	43.61	43.9075	6392492.0
2018-03-07 13:30:00	AAPL	Stock	43.905	43.93	43.76	43.8125	4615784.0
2018-03-07 14:00:00	AAPL	Stock	43.8125	43.9025	43.7625	43.815	4207196.0
2018-03-07 14:30:00	AAPL	Stock	43.8125	43.8738	43.73	43.765	5065120.0
2018-03-07 15:00:00	AAPL	Stock	43.7625	43.9	43.72	43.77	9130600.0
2018-03-07 15:30:00	AAPL	Stock	43.77	43.8575	43.6825	43.755	14555308.0
2018-03-07 16:00:00	AAPL	Stock	43.765	43.765	43.705	43.7325	11376076.0
2018-03-07 16:30:00	AAPL	Stock	43.7325	43.7575	43.7125	43.715	148100.0
2018-03-07 17:00:00	AAPL	Stock	43.715	43.725	43.7125	43.725	23188.0
2018-03-07 17:30:00	AAPL	Stock	43.725	43.735	43.725	43.73	11476.0
2018-03-07 18:00:00	AAPL	Stock	43.7325	43.735	43.7125	43.7125	11444.0
2018-03-07 18:30:00	AAPL	Stock	43.7075	43.7175	43.7075	43.7175	1344.0
2018-03-07 19:00:00	AAPL	Stock	43.7325	43.735	43.7175	43.7325	4640.0
2018-03-07 19:30:00	AAPL	Stock	43.7125	43.725	43.7125	43.725	15652.0
2018-03-07 04:00:00	MSFT	Stock	92.44	92.44	92.3	92.3	4871.0
2018-03-07 05:00:00	MSFT	Stock	92.45	92.48	92.45	92.48	1600.0
2018-03-07 06:00:00	MSFT	Stock	92.4	92.4	92.4	92.4	1300.0
2018-03-07 06:30:00	MSFT	Stock	92.4	92.45	92.4	92.45	506.0
2018-03-07 07:00:00	MSFT	Stock	92.41	92.82	92.41	92.82	14561.0
2018-03-07 07:30:00	MSFT	Stock	92.79	92.8	92.58	92.6	5918.0
2018-03-07 08:00:00	MSFT	Stock	92.7	92.8	92.365	92.72	46543.0
2018-03-07 08:30:00	MSFT	Stock	92.75	92.75	92.53	92.6	12328.0
2018-03-07 09:00:00	MSFT	Stock	92.61	93.16	92.44	93.14	35603.0
2018-03-07 09:30:00	MSFT	Stock	93.13	93.54	92.71	93.085	2995225.0
2018-03-07 10:00:00	MSFT	Stock	93.09	93.365	92.94	93.165	1507642.0
2018-03-07 10:30:00	MSFT	Stock	93.17	93.476	93.06	93.25	1662224.0
2018-03-07 11:00:00	MSFT	Stock	93.24	93.265	92.73	92.935	1297372.0
2018-03-07 11:30:00	MSFT	Stock	92.93	93.095	92.66	92.67	1026317.0
2018-03-07 12:00:00	MSFT	Stock	92.67	92.85	92.43	92.77	1373781.0
2018-03-07 12:30:00	MSFT	Stock	92.77	93.15	92.75	93.11	1044111.0
2018-03-07 13:00:00	MSFT	Stock	93.1	93.44	92.83	93.425	1304671.0
2018-03-07 13:30:00	MSFT	Stock	93.425	93.54	93.34	93.48	1027059.0

> showing 50 of 83,976 rows — these rows as CSV

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