PREVIEW / stock_30min / 2017-04-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-27.parquet
  size:    1.6 MB
  rows:    81,818
  symbols: 3,029

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-04-27 04:00:00	AAPL	Stock	35.9375	35.9975	35.9375	35.9375	14828.0
2017-04-27 04:30:00	AAPL	Stock	35.9375	35.9375	35.9375	35.9375	476.0
2017-04-27 05:00:00	AAPL	Stock	35.9125	35.9375	35.8825	35.8825	4832.0
2017-04-27 05:30:00	AAPL	Stock	35.8875	35.9125	35.8875	35.9125	3664.0
2017-04-27 06:00:00	AAPL	Stock	35.93	35.9375	35.915	35.915	6156.0
2017-04-27 06:30:00	AAPL	Stock	35.915	35.9875	35.915	35.9875	11304.0
2017-04-27 07:00:00	AAPL	Stock	35.9675	35.9675	35.9675	35.9675	3600.0
2017-04-27 07:30:00	AAPL	Stock	35.97	35.97	35.9375	35.945	30064.0
2017-04-27 08:00:00	AAPL	Stock	35.96	35.9725	35.945	35.95	46920.0
2017-04-27 08:30:00	AAPL	Stock	35.95	35.9875	35.9375	35.9425	68124.0
2017-04-27 09:00:00	AAPL	Stock	35.96	35.9825	35.96	35.9725	38712.0
2017-04-27 09:30:00	AAPL	Stock	35.9775	36.04	35.8578	35.8975	8639628.0
2017-04-27 10:00:00	AAPL	Stock	35.8965	35.9375	35.8275	35.835	4320816.0
2017-04-27 10:30:00	AAPL	Stock	35.834	35.905	35.8275	35.845	3472592.0
2017-04-27 11:00:00	AAPL	Stock	35.845	35.8928	35.8375	35.855	2996560.0
2017-04-27 11:30:00	AAPL	Stock	35.855	35.91	35.855	35.9075	2409392.0
2017-04-27 12:00:00	AAPL	Stock	35.9075	35.923	35.89	35.9162	1800732.0
2017-04-27 12:30:00	AAPL	Stock	35.9175	35.9725	35.8965	35.97	2192144.0
2017-04-27 13:00:00	AAPL	Stock	35.9718	35.975	35.935	35.95	1750928.0
2017-04-27 13:30:00	AAPL	Stock	35.95	35.9575	35.93	35.955	1172900.0
2017-04-27 14:00:00	AAPL	Stock	35.9525	35.955	35.9	35.9165	1964160.0
2017-04-27 14:30:00	AAPL	Stock	35.915	35.9525	35.9125	35.9425	1548408.0
2017-04-27 15:00:00	AAPL	Stock	35.9425	35.9525	35.8775	35.9512	2733640.0
2017-04-27 15:30:00	AAPL	Stock	35.95	35.9725	35.8725	35.9475	7861128.0
2017-04-27 16:00:00	AAPL	Stock	35.9475	35.99	35.895	35.9025	8015804.0
2017-04-27 16:30:00	AAPL	Stock	35.9025	35.9625	35.875	35.92	215352.0
2017-04-27 17:00:00	AAPL	Stock	35.925	35.9725	35.915	35.9525	81284.0
2017-04-27 17:30:00	AAPL	Stock	35.9525	35.985	35.95	35.97	56612.0
2017-04-27 18:00:00	AAPL	Stock	35.97	35.975	35.95	35.97	48212.0
2017-04-27 18:30:00	AAPL	Stock	35.97	35.975	35.9575	35.975	20608.0
2017-04-27 19:00:00	AAPL	Stock	35.975	35.9775	35.9575	35.97	20332.0
2017-04-27 19:30:00	AAPL	Stock	35.97	35.975	35.9625	35.975	18188.0
2017-04-27 04:00:00	MSFT	Stock	68.29	68.29	67.92	67.92	3200.0
2017-04-27 06:00:00	MSFT	Stock	68.03	68.13	67.91	67.91	2453.0
2017-04-27 06:30:00	MSFT	Stock	68.03	68.03	68.03	68.03	500.0
2017-04-27 07:00:00	MSFT	Stock	68.16	68.19	68.08	68.1	2520.0
2017-04-27 07:30:00	MSFT	Stock	68.18	68.39	68.12	68.3	16250.0
2017-04-27 08:00:00	MSFT	Stock	68.24	68.37	68.0	68.3	53817.0
2017-04-27 08:30:00	MSFT	Stock	68.3	68.35	68.26	68.26	44135.0
2017-04-27 09:00:00	MSFT	Stock	68.27	68.31	68.15	68.16	39009.0
2017-04-27 09:30:00	MSFT	Stock	68.16	68.16	67.66	67.82	3564394.0
2017-04-27 10:00:00	MSFT	Stock	67.82	68.055	67.815	67.986	2599318.0
2017-04-27 10:30:00	MSFT	Stock	67.99	68.01	67.74	67.805	1709016.0
2017-04-27 11:00:00	MSFT	Stock	67.806	67.89	67.765	67.815	1271469.0
2017-04-27 11:30:00	MSFT	Stock	67.815	67.88	67.75	67.826	1157581.0
2017-04-27 12:00:00	MSFT	Stock	67.83	67.88	67.75	67.755	1250838.0
2017-04-27 12:30:00	MSFT	Stock	67.76	67.82	67.58	67.815	1992771.0
2017-04-27 13:00:00	MSFT	Stock	67.815	67.83	67.73	67.81	1299043.0
2017-04-27 13:30:00	MSFT	Stock	67.81	67.88	67.75	67.87	1191051.0
2017-04-27 14:00:00	MSFT	Stock	67.865	68.035	67.84	67.9	1967124.0

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

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