PREVIEW / stock_30min / 2017-07-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-06.parquet
  size:    1.6 MB
  rows:    80,463
  symbols: 2,993

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-07-06 05:00:00	AAPL	Stock	35.895	35.895	35.8875	35.8875	4400.0
2017-07-06 05:30:00	AAPL	Stock	35.855	35.855	35.7625	35.8	12596.0
2017-07-06 06:00:00	AAPL	Stock	35.7925	35.7925	35.7575	35.76	6012.0
2017-07-06 06:30:00	AAPL	Stock	35.79	35.81	35.775	35.81	7164.0
2017-07-06 07:00:00	AAPL	Stock	35.81	35.81	35.7925	35.81	13516.0
2017-07-06 07:30:00	AAPL	Stock	35.795	35.8025	35.7	35.7175	96840.0
2017-07-06 08:00:00	AAPL	Stock	35.7475	35.785	35.7	35.7375	213060.0
2017-07-06 08:30:00	AAPL	Stock	35.75	35.8225	35.73	35.7975	99776.0
2017-07-06 09:00:00	AAPL	Stock	35.7975	35.8225	35.75	35.7625	196636.0
2017-07-06 09:30:00	AAPL	Stock	35.775	35.875	35.6575	35.6925	12435608.0
2017-07-06 10:00:00	AAPL	Stock	35.69	35.795	35.6025	35.6812	8259208.0
2017-07-06 10:30:00	AAPL	Stock	35.68	35.725	35.6275	35.66	7239152.0
2017-07-06 11:00:00	AAPL	Stock	35.6625	35.74	35.63	35.73	5984124.0
2017-07-06 11:30:00	AAPL	Stock	35.73	35.865	35.72	35.745	5562936.0
2017-07-06 12:00:00	AAPL	Stock	35.745	35.775	35.66	35.675	3711900.0
2017-07-06 12:30:00	AAPL	Stock	35.6763	35.83	35.6725	35.7925	3759500.0
2017-07-06 13:00:00	AAPL	Stock	35.7925	35.8062	35.74	35.7862	2830692.0
2017-07-06 13:30:00	AAPL	Stock	35.785	35.7925	35.6975	35.715	3840388.0
2017-07-06 14:00:00	AAPL	Stock	35.715	35.7375	35.665	35.7225	3293628.0
2017-07-06 14:30:00	AAPL	Stock	35.7225	35.7238	35.645	35.7075	4219492.0
2017-07-06 15:00:00	AAPL	Stock	35.7088	35.7238	35.635	35.6925	5221476.0
2017-07-06 15:30:00	AAPL	Stock	35.6948	35.735	35.63	35.68	10189912.0
2017-07-06 16:00:00	AAPL	Stock	35.6825	35.69	35.68	35.6825	7881736.0
2017-07-06 16:30:00	AAPL	Stock	35.665	35.675	35.6125	35.6475	56912.0
2017-07-06 17:00:00	AAPL	Stock	35.6275	35.675	35.625	35.675	23092.0
2017-07-06 17:30:00	AAPL	Stock	35.6775	35.6775	35.665	35.6775	6060.0
2017-07-06 18:00:00	AAPL	Stock	35.675	35.68	35.665	35.665	27252.0
2017-07-06 18:30:00	AAPL	Stock	35.6725	35.675	35.665	35.67	8800.0
2017-07-06 19:00:00	AAPL	Stock	35.665	35.665	35.6525	35.6625	13644.0
2017-07-06 19:30:00	AAPL	Stock	35.6575	35.675	35.6575	35.6625	9312.0
2017-07-06 06:30:00	MSFT	Stock	68.45	68.6	68.45	68.6	650.0
2017-07-06 07:00:00	MSFT	Stock	68.6	68.6	68.6	68.6	450.0
2017-07-06 07:30:00	MSFT	Stock	68.6	68.6	68.45	68.45	2193.0
2017-07-06 08:00:00	MSFT	Stock	68.59	68.59	68.26	68.48	20107.0
2017-07-06 08:30:00	MSFT	Stock	68.45	68.52	68.45	68.52	4771.0
2017-07-06 09:00:00	MSFT	Stock	68.61	68.61	68.3	68.3	26742.0
2017-07-06 09:30:00	MSFT	Stock	68.29	68.63	68.18	68.41	3010074.0
2017-07-06 10:00:00	MSFT	Stock	68.4	68.535	68.125	68.195	2227494.0
2017-07-06 10:30:00	MSFT	Stock	68.2	68.36	68.12	68.36	1788409.0
2017-07-06 11:00:00	MSFT	Stock	68.35	68.565	68.28	68.555	1288321.0
2017-07-06 11:30:00	MSFT	Stock	68.565	68.71	68.485	68.57	959146.0
2017-07-06 12:00:00	MSFT	Stock	68.576	68.59	68.462	68.5	787918.0
2017-07-06 12:30:00	MSFT	Stock	68.491	68.74	68.49	68.675	696372.0
2017-07-06 13:00:00	MSFT	Stock	68.68	68.78	68.605	68.736	747733.0
2017-07-06 13:30:00	MSFT	Stock	68.735	68.74	68.62	68.65	909292.0
2017-07-06 14:00:00	MSFT	Stock	68.66	68.66	68.545	68.64	790410.0
2017-07-06 14:30:00	MSFT	Stock	68.64	68.65	68.49	68.554	970740.0
2017-07-06 15:00:00	MSFT	Stock	68.55	68.645	68.47	68.525	959469.0
2017-07-06 15:30:00	MSFT	Stock	68.52	68.64	68.44	68.58	2839501.0
2017-07-06 16:00:00	MSFT	Stock	68.57	68.71	68.51	68.51	1747365.0

> showing 50 of 80,463 rows — these rows as CSV

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