PREVIEW / stock_30min / 2017-08-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-23.parquet
  size:    1.6 MB
  rows:    79,735
  symbols: 2,955

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-08-23 05:00:00	AAPL	Stock	39.965	39.965	39.9375	39.9375	4528.0
2017-08-23 06:00:00	AAPL	Stock	39.8875	39.8875	39.8875	39.8875	1600.0
2017-08-23 06:30:00	AAPL	Stock	39.8275	39.8275	39.805	39.805	1600.0
2017-08-23 07:00:00	AAPL	Stock	39.8625	39.91	39.85	39.8725	49024.0
2017-08-23 07:30:00	AAPL	Stock	39.8575	39.8575	39.8025	39.8025	50324.0
2017-08-23 08:00:00	AAPL	Stock	39.8125	39.8725	39.7675	39.7775	238840.0
2017-08-23 08:30:00	AAPL	Stock	39.7625	39.7875	39.75	39.785	191072.0
2017-08-23 09:00:00	AAPL	Stock	39.75	39.785	39.6975	39.77	222288.0
2017-08-23 09:30:00	AAPL	Stock	39.7675	40.0625	39.72	40.0425	11741380.0
2017-08-23 10:00:00	AAPL	Stock	40.04	40.04	39.8825	39.9675	5886064.0
2017-08-23 10:30:00	AAPL	Stock	39.97	40.0225	39.9125	39.9525	4511940.0
2017-08-23 11:00:00	AAPL	Stock	39.9525	40.05	39.91	40.045	4611220.0
2017-08-23 11:30:00	AAPL	Stock	40.0438	40.105	39.9875	40.0808	4317708.0
2017-08-23 12:00:00	AAPL	Stock	40.08	40.1175	40.005	40.0075	2864872.0
2017-08-23 12:30:00	AAPL	Stock	40.01	40.05	39.9525	39.9675	2568900.0
2017-08-23 13:00:00	AAPL	Stock	39.9675	39.98	39.8562	39.8825	3501792.0
2017-08-23 13:30:00	AAPL	Stock	39.8825	39.9225	39.85	39.905	2955680.0
2017-08-23 14:00:00	AAPL	Stock	39.905	40.02	39.9025	39.9875	3686084.0
2017-08-23 14:30:00	AAPL	Stock	39.975	40.05	39.955	40.0325	3230272.0
2017-08-23 15:00:00	AAPL	Stock	40.0338	40.035	39.9825	40.0135	2383156.0
2017-08-23 15:30:00	AAPL	Stock	40.015	40.0825	39.9825	39.9975	7336288.0
2017-08-23 16:00:00	AAPL	Stock	39.995	39.995	39.97	39.995	7343956.0
2017-08-23 16:30:00	AAPL	Stock	39.9625	39.985	39.95	39.9825	19768.0
2017-08-23 17:00:00	AAPL	Stock	39.98	39.995	39.925	39.95	54788.0
2017-08-23 17:30:00	AAPL	Stock	39.95	39.97	39.9325	39.9375	11180.0
2017-08-23 18:00:00	AAPL	Stock	39.9675	39.9675	39.9125	39.9175	14956.0
2017-08-23 18:30:00	AAPL	Stock	39.9125	39.9125	39.83	39.83	25492.0
2017-08-23 19:00:00	AAPL	Stock	39.875	39.9125	39.875	39.9125	12232.0
2017-08-23 19:30:00	AAPL	Stock	39.9125	39.935	39.8525	39.8525	8064.0
2017-08-23 05:00:00	MSFT	Stock	73.25	73.25	73.25	73.25	1796.0
2017-08-23 05:30:00	MSFT	Stock	73.1	73.1	73.1	73.1	119.0
2017-08-23 06:00:00	MSFT	Stock	73.1	73.1	73.1	73.1	1400.0
2017-08-23 06:30:00	MSFT	Stock	73.1	73.1	73.1	73.1	528.0
2017-08-23 07:30:00	MSFT	Stock	72.96	72.96	72.96	72.96	350.0
2017-08-23 08:00:00	MSFT	Stock	73.0	73.09	72.95	73.09	2908.0
2017-08-23 08:30:00	MSFT	Stock	73.09	73.09	72.84	72.88	2284.0
2017-08-23 09:00:00	MSFT	Stock	72.9	72.96	72.81	72.96	6937.0
2017-08-23 09:30:00	MSFT	Stock	72.96	73.15	72.79	73.07	1453675.0
2017-08-23 10:00:00	MSFT	Stock	73.07	73.12	72.865	72.874	995034.0
2017-08-23 10:30:00	MSFT	Stock	72.87	72.88	72.694	72.71	900880.0
2017-08-23 11:00:00	MSFT	Stock	72.71	72.91	72.68	72.84	673433.0
2017-08-23 11:30:00	MSFT	Stock	72.85	72.86	72.63	72.72	672767.0
2017-08-23 12:00:00	MSFT	Stock	72.72	72.755	72.55	72.56	553341.0
2017-08-23 12:30:00	MSFT	Stock	72.56	72.67	72.55	72.65	319224.0
2017-08-23 13:00:00	MSFT	Stock	72.655	72.68	72.56	72.62	390433.0
2017-08-23 13:30:00	MSFT	Stock	72.62	72.64	72.53	72.62	447777.0
2017-08-23 14:00:00	MSFT	Stock	72.61	72.8	72.61	72.76	408589.0
2017-08-23 14:30:00	MSFT	Stock	72.76	72.91	72.74	72.85	453813.0
2017-08-23 15:00:00	MSFT	Stock	72.859	72.905	72.81	72.87	442495.0
2017-08-23 15:30:00	MSFT	Stock	72.87	72.935	72.71	72.73	1644668.0

> showing 50 of 79,735 rows — these rows as CSV

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