PREVIEW / stock_30min / 2017-12-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-21.parquet
  size:    1.7 MB
  rows:    83,983
  symbols: 2,937

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
2017-12-21 04:30:00	AAPL	Stock	43.5	43.5	43.5	43.5	400.0
2017-12-21 05:00:00	AAPL	Stock	43.4575	43.5	43.455	43.455	3360.0
2017-12-21 05:30:00	AAPL	Stock	43.455	43.4625	43.455	43.4625	940.0
2017-12-21 06:00:00	AAPL	Stock	43.465	43.465	43.465	43.465	796.0
2017-12-21 06:30:00	AAPL	Stock	43.48	43.55	43.48	43.5025	2404.0
2017-12-21 07:00:00	AAPL	Stock	43.5	43.54	43.5	43.5375	8856.0
2017-12-21 07:30:00	AAPL	Stock	43.5125	43.5875	43.5125	43.5625	31596.0
2017-12-21 08:00:00	AAPL	Stock	43.5375	43.6375	43.505	43.6375	81552.0
2017-12-21 08:30:00	AAPL	Stock	43.6375	43.6375	43.5875	43.635	88996.0
2017-12-21 09:00:00	AAPL	Stock	43.625	43.625	43.5225	43.555	290156.0
2017-12-21 09:30:00	AAPL	Stock	43.5425	43.8275	43.525	43.72	10562440.0
2017-12-21 10:00:00	AAPL	Stock	43.72	43.78	43.6425	43.695	4962204.0
2017-12-21 10:30:00	AAPL	Stock	43.6975	43.81	43.6475	43.8	6108496.0
2017-12-21 11:00:00	AAPL	Stock	43.8025	43.98	43.8	43.9725	7660384.0
2017-12-21 11:30:00	AAPL	Stock	43.9725	44.005	43.8665	43.8725	6378600.0
2017-12-21 12:00:00	AAPL	Stock	43.8675	43.9175	43.855	43.908	3069124.0
2017-12-21 12:30:00	AAPL	Stock	43.9075	43.925	43.8675	43.9112	3541988.0
2017-12-21 13:00:00	AAPL	Stock	43.91	43.9638	43.9	43.9	2620476.0
2017-12-21 13:30:00	AAPL	Stock	43.9025	43.94	43.88	43.915	2190324.0
2017-12-21 14:00:00	AAPL	Stock	43.915	43.915	43.81	43.835	2857436.0
2017-12-21 14:30:00	AAPL	Stock	43.8375	43.87	43.8125	43.8512	2058224.0
2017-12-21 15:00:00	AAPL	Stock	43.85	43.8625	43.77	43.8375	2824904.0
2017-12-21 15:30:00	AAPL	Stock	43.84	43.8692	43.72	43.7525	6900752.0
2017-12-21 16:00:00	AAPL	Stock	43.775	43.8	43.735	43.78	13679436.0
2017-12-21 16:30:00	AAPL	Stock	43.7925	43.7925	43.7525	43.7525	215852.0
2017-12-21 17:00:00	AAPL	Stock	43.7875	43.7875	43.7525	43.78	634664.0
2017-12-21 17:30:00	AAPL	Stock	43.78	43.7925	43.7725	43.7925	12940.0
2017-12-21 18:00:00	AAPL	Stock	43.7925	43.7925	43.7875	43.79	3200.0
2017-12-21 18:30:00	AAPL	Stock	43.7925	43.7925	43.7875	43.7875	13212.0
2017-12-21 19:00:00	AAPL	Stock	43.795	43.7975	43.7875	43.7875	13640.0
2017-12-21 19:30:00	AAPL	Stock	43.8	43.8	43.79	43.79	8376.0
2017-12-21 04:00:00	MSFT	Stock	86.12	86.14	86.12	86.14	400.0
2017-12-21 05:00:00	MSFT	Stock	85.96	85.96	85.96	85.96	156.0
2017-12-21 05:30:00	MSFT	Stock	85.8	85.8	85.8	85.8	200.0
2017-12-21 06:00:00	MSFT	Stock	85.85	85.85	85.85	85.85	100.0
2017-12-21 06:30:00	MSFT	Stock	85.85	85.85	85.85	85.85	100.0
2017-12-21 07:30:00	MSFT	Stock	85.74	85.74	85.73	85.73	550.0
2017-12-21 08:00:00	MSFT	Stock	85.9	85.9	85.7	85.77	3276.0
2017-12-21 08:30:00	MSFT	Stock	85.77	85.77	85.65	85.65	3437.0
2017-12-21 09:00:00	MSFT	Stock	85.75	86.1	85.7	86.1	30804.0
2017-12-21 09:30:00	MSFT	Stock	86.05	86.1	85.61	85.675	2128265.0
2017-12-21 10:00:00	MSFT	Stock	85.675	85.89	85.571	85.705	857105.0
2017-12-21 10:30:00	MSFT	Stock	85.7	86.02	85.65	85.895	940098.0
2017-12-21 11:00:00	MSFT	Stock	85.89	86.04	85.83	85.986	775393.0
2017-12-21 11:30:00	MSFT	Stock	85.99	86.035	85.94	86.005	772629.0
2017-12-21 12:00:00	MSFT	Stock	86.01	86.03	85.855	85.876	750523.0
2017-12-21 12:30:00	MSFT	Stock	85.88	85.96	85.82	85.94	424300.0
2017-12-21 13:00:00	MSFT	Stock	85.94	86.06	85.915	86.04	527340.0
2017-12-21 13:30:00	MSFT	Stock	86.035	86.05	85.92	85.935	412887.0
2017-12-21 14:00:00	MSFT	Stock	85.93	85.93	85.66	85.7	536580.0

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

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