PREVIEW / stock_30min / 2017-05-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-15.parquet
  size:    1.6 MB
  rows:    81,770
  symbols: 3,030

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-05-15 04:00:00	AAPL	Stock	39.175	39.25	39.175	39.25	1200.0
2017-05-15 04:30:00	AAPL	Stock	39.1575	39.175	39.125	39.125	6612.0
2017-05-15 05:00:00	AAPL	Stock	39.1525	39.1525	39.0625	39.0625	12488.0
2017-05-15 05:30:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	3860.0
2017-05-15 06:00:00	AAPL	Stock	39.05	39.0925	39.0375	39.0925	8676.0
2017-05-15 06:30:00	AAPL	Stock	39.095	39.105	39.095	39.105	4800.0
2017-05-15 07:00:00	AAPL	Stock	39.0875	39.125	39.0875	39.125	78912.0
2017-05-15 07:30:00	AAPL	Stock	39.1225	39.1225	39.0875	39.0875	35748.0
2017-05-15 08:00:00	AAPL	Stock	39.0975	39.125	39.085	39.125	395508.0
2017-05-15 08:30:00	AAPL	Stock	39.12	39.125	39.045	39.065	249744.0
2017-05-15 09:00:00	AAPL	Stock	39.0625	39.065	38.995	39.0025	486772.0
2017-05-15 09:30:00	AAPL	Stock	39.0025	39.1625	38.855	38.9225	17873824.0
2017-05-15 10:00:00	AAPL	Stock	38.9225	38.9425	38.7625	38.9175	9652984.0
2017-05-15 10:30:00	AAPL	Stock	38.9175	38.9875	38.855	38.98	6336376.0
2017-05-15 11:00:00	AAPL	Stock	38.98	38.995	38.835	38.855	5142972.0
2017-05-15 11:30:00	AAPL	Stock	38.855	38.8975	38.7875	38.8175	4495624.0
2017-05-15 12:00:00	AAPL	Stock	38.815	38.855	38.7775	38.784	4009092.0
2017-05-15 12:30:00	AAPL	Stock	38.7825	38.8425	38.7688	38.795	3332264.0
2017-05-15 13:00:00	AAPL	Stock	38.795	38.8798	38.7775	38.8675	3303236.0
2017-05-15 13:30:00	AAPL	Stock	38.8688	38.8875	38.8175	38.8575	3351664.0
2017-05-15 14:00:00	AAPL	Stock	38.8562	38.86	38.8	38.8025	2681704.0
2017-05-15 14:30:00	AAPL	Stock	38.8025	38.845	38.8	38.84	2675828.0
2017-05-15 15:00:00	AAPL	Stock	38.8412	38.8875	38.8338	38.8638	3540568.0
2017-05-15 15:30:00	AAPL	Stock	38.865	38.9275	38.8332	38.92	10867744.0
2017-05-15 16:00:00	AAPL	Stock	38.925	38.925	38.8683	38.905	14351544.0
2017-05-15 16:30:00	AAPL	Stock	38.91	38.925	38.9	38.92	54504.0
2017-05-15 17:00:00	AAPL	Stock	38.9175	38.9325	38.9175	38.9325	27500.0
2017-05-15 17:30:00	AAPL	Stock	38.9375	38.95	38.925	38.95	19324.0
2017-05-15 18:00:00	AAPL	Stock	38.9325	38.96	38.9325	38.9375	31212.0
2017-05-15 18:30:00	AAPL	Stock	38.9375	38.9475	38.9375	38.9375	6396.0
2017-05-15 19:00:00	AAPL	Stock	38.9375	38.9525	38.925	38.925	18092.0
2017-05-15 19:30:00	AAPL	Stock	38.9175	38.925	38.915	38.915	12056.0
2017-05-15 04:30:00	MSFT	Stock	68.38	68.38	68.38	68.38	423.0
2017-05-15 06:00:00	MSFT	Stock	68.4	68.4	68.4	68.4	100.0
2017-05-15 06:30:00	MSFT	Stock	68.38	68.38	68.29	68.29	2031.0
2017-05-15 07:00:00	MSFT	Stock	68.38	68.38	68.13	68.38	22282.0
2017-05-15 07:30:00	MSFT	Stock	68.38	68.38	68.3	68.3	2630.0
2017-05-15 08:00:00	MSFT	Stock	68.3	68.38	68.3	68.33	2910.0
2017-05-15 08:30:00	MSFT	Stock	68.34	68.34	68.25	68.27	6772.0
2017-05-15 09:00:00	MSFT	Stock	68.27	68.38	68.04	68.15	96124.0
2017-05-15 09:30:00	MSFT	Stock	68.16	68.42	67.73	67.796	4141055.0
2017-05-15 10:00:00	MSFT	Stock	67.795	67.87	67.57	67.648	2074118.0
2017-05-15 10:30:00	MSFT	Stock	67.645	67.84	67.62	67.835	1778045.0
2017-05-15 11:00:00	MSFT	Stock	67.84	67.91	67.81	67.85	1031276.0
2017-05-15 11:30:00	MSFT	Stock	67.845	67.87	67.74	67.77	856460.0
2017-05-15 12:00:00	MSFT	Stock	67.77	67.88	67.74	67.76	1153349.0
2017-05-15 12:30:00	MSFT	Stock	67.76	67.77	67.7	67.715	969837.0
2017-05-15 13:00:00	MSFT	Stock	67.72	67.9	67.71	67.89	710106.0
2017-05-15 13:30:00	MSFT	Stock	67.89	67.995	67.87	67.97	1272393.0
2017-05-15 14:00:00	MSFT	Stock	67.97	68.19	67.95	68.19	1827057.0

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

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