PREVIEW / stock_30min / 2017-09-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-06.parquet
  size:    1.6 MB
  rows:    81,499
  symbols: 2,983

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-09-06 04:00:00	AAPL	Stock	40.605	40.605	40.605	40.605	15588.0
2017-09-06 04:30:00	AAPL	Stock	40.6725	40.6725	40.6725	40.6725	1956.0
2017-09-06 05:00:00	AAPL	Stock	40.6275	40.6275	40.625	40.625	4560.0
2017-09-06 05:30:00	AAPL	Stock	40.605	40.6175	40.605	40.6175	7084.0
2017-09-06 06:00:00	AAPL	Stock	40.6725	40.6875	40.67	40.67	16072.0
2017-09-06 06:30:00	AAPL	Stock	40.65	40.65	40.5625	40.5625	11264.0
2017-09-06 07:00:00	AAPL	Stock	40.5825	40.645	40.5775	40.645	43868.0
2017-09-06 07:30:00	AAPL	Stock	40.6425	40.6475	40.6075	40.625	33996.0
2017-09-06 08:00:00	AAPL	Stock	40.6375	40.66	40.5875	40.645	149600.0
2017-09-06 08:30:00	AAPL	Stock	40.65	40.675	40.6125	40.6625	171020.0
2017-09-06 09:00:00	AAPL	Stock	40.6625	40.695	40.6425	40.675	117336.0
2017-09-06 09:30:00	AAPL	Stock	40.6775	40.7475	40.5125	40.595	11074328.0
2017-09-06 10:00:00	AAPL	Stock	40.5938	40.645	40.405	40.4362	7146696.0
2017-09-06 10:30:00	AAPL	Stock	40.4375	40.4675	40.215	40.345	7914428.0
2017-09-06 11:00:00	AAPL	Stock	40.3425	40.345	40.13	40.19	7129492.0
2017-09-06 11:30:00	AAPL	Stock	40.1882	40.2975	40.1675	40.2975	4296256.0
2017-09-06 12:00:00	AAPL	Stock	40.295	40.3975	40.2475	40.3775	3957468.0
2017-09-06 12:30:00	AAPL	Stock	40.375	40.495	40.3125	40.4652	3826840.0
2017-09-06 13:00:00	AAPL	Stock	40.4675	40.525	40.455	40.4775	3206996.0
2017-09-06 13:30:00	AAPL	Stock	40.4795	40.5425	40.4675	40.4738	2333604.0
2017-09-06 14:00:00	AAPL	Stock	40.4725	40.545	40.4675	40.52	3043248.0
2017-09-06 14:30:00	AAPL	Stock	40.5175	40.5175	40.4075	40.4685	3300652.0
2017-09-06 15:00:00	AAPL	Stock	40.47	40.525	40.445	40.5125	3458048.0
2017-09-06 15:30:00	AAPL	Stock	40.5138	40.5175	40.445	40.48	7549104.0
2017-09-06 16:00:00	AAPL	Stock	40.4775	40.48	40.425	40.4275	8026876.0
2017-09-06 16:30:00	AAPL	Stock	40.4275	40.43	40.3925	40.405	56144.0
2017-09-06 17:00:00	AAPL	Stock	40.41	40.4225	40.405	40.4225	3644.0
2017-09-06 17:30:00	AAPL	Stock	40.4025	40.4775	40.4	40.4175	12616.0
2017-09-06 18:00:00	AAPL	Stock	40.4	40.4125	40.38	40.38	38136.0
2017-09-06 18:30:00	AAPL	Stock	40.4125	40.4125	40.3625	40.39	33900.0
2017-09-06 19:00:00	AAPL	Stock	40.3775	40.4	40.375	40.4	19868.0
2017-09-06 19:30:00	AAPL	Stock	40.39	40.4	40.3625	40.375	41452.0
2017-09-06 08:00:00	MSFT	Stock	73.64	73.87	73.64	73.87	230.0
2017-09-06 08:30:00	MSFT	Stock	73.86	73.86	73.81	73.85	688.0
2017-09-06 09:00:00	MSFT	Stock	73.81	73.85	73.65	73.75	7431.0
2017-09-06 09:30:00	MSFT	Stock	73.77	74.04	73.605	73.685	2049113.0
2017-09-06 10:00:00	MSFT	Stock	73.685	73.87	73.47	73.59	862389.0
2017-09-06 10:30:00	MSFT	Stock	73.59	73.67	73.421	73.63	833198.0
2017-09-06 11:00:00	MSFT	Stock	73.635	73.66	73.39	73.64	895174.0
2017-09-06 11:30:00	MSFT	Stock	73.636	73.788	73.61	73.69	476711.0
2017-09-06 12:00:00	MSFT	Stock	73.68	73.73	73.62	73.715	692280.0
2017-09-06 12:30:00	MSFT	Stock	73.71	73.71	73.6	73.66	575100.0
2017-09-06 13:00:00	MSFT	Stock	73.66	73.74	73.6	73.64	504489.0
2017-09-06 13:30:00	MSFT	Stock	73.64	73.69	73.56	73.59	340783.0
2017-09-06 14:00:00	MSFT	Stock	73.585	73.72	73.57	73.665	523176.0
2017-09-06 14:30:00	MSFT	Stock	73.66	73.695	73.52	73.6	619783.0
2017-09-06 15:00:00	MSFT	Stock	73.61	73.66	73.55	73.57	992186.0
2017-09-06 15:30:00	MSFT	Stock	73.575	73.58	73.35	73.4	2351832.0
2017-09-06 16:00:00	MSFT	Stock	73.4	73.41	73.3	73.3	2799158.0
2017-09-06 16:30:00	MSFT	Stock	73.45	73.5	73.45	73.5	1461.0

> showing 50 of 81,499 rows — these rows as CSV

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