PREVIEW / stock_30min / 2017-06-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-08.parquet
  size:    1.6 MB
  rows:    80,881
  symbols: 3,027

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-06-08 04:30:00	AAPL	Stock	38.9175	38.9175	38.9175	38.9175	436.0
2017-06-08 05:00:00	AAPL	Stock	38.92	38.92	38.92	38.92	3028.0
2017-06-08 05:30:00	AAPL	Stock	38.9375	38.94	38.9375	38.94	7268.0
2017-06-08 06:00:00	AAPL	Stock	38.9125	38.95	38.9125	38.925	8428.0
2017-06-08 06:30:00	AAPL	Stock	38.94	38.965	38.9125	38.95	19536.0
2017-06-08 07:00:00	AAPL	Stock	38.9575	38.9625	38.955	38.9625	6308.0
2017-06-08 07:30:00	AAPL	Stock	38.9625	38.9625	38.9375	38.9475	6440.0
2017-06-08 08:00:00	AAPL	Stock	38.925	38.97	38.9125	38.9425	94228.0
2017-06-08 08:30:00	AAPL	Stock	38.94	38.94	38.8875	38.9	91596.0
2017-06-08 09:00:00	AAPL	Stock	38.9	38.9175	38.8025	38.8125	184272.0
2017-06-08 09:30:00	AAPL	Stock	38.8125	38.885	38.6125	38.6875	12000524.0
2017-06-08 10:00:00	AAPL	Stock	38.6875	38.7575	38.6	38.6525	7563456.0
2017-06-08 10:30:00	AAPL	Stock	38.65	38.75	38.6375	38.7463	5185200.0
2017-06-08 11:00:00	AAPL	Stock	38.7475	38.795	38.7202	38.7525	4597412.0
2017-06-08 11:30:00	AAPL	Stock	38.7525	38.7925	38.73	38.775	3102116.0
2017-06-08 12:00:00	AAPL	Stock	38.775	38.7972	38.7248	38.747	3391944.0
2017-06-08 12:30:00	AAPL	Stock	38.745	38.765	38.71	38.7525	2717844.0
2017-06-08 13:00:00	AAPL	Stock	38.7525	38.77	38.675	38.6825	3341632.0
2017-06-08 13:30:00	AAPL	Stock	38.68	38.71	38.645	38.7058	2923188.0
2017-06-08 14:00:00	AAPL	Stock	38.7052	38.7225	38.6425	38.6538	3333344.0
2017-06-08 14:30:00	AAPL	Stock	38.65	38.6975	38.6325	38.6565	3344420.0
2017-06-08 15:00:00	AAPL	Stock	38.6575	38.73	38.655	38.7222	3744400.0
2017-06-08 15:30:00	AAPL	Stock	38.7225	38.7875	38.7025	38.73	7305444.0
2017-06-08 16:00:00	AAPL	Stock	38.745	38.7475	38.7	38.715	9759480.0
2017-06-08 16:30:00	AAPL	Stock	38.7125	38.735	38.705	38.7325	16288.0
2017-06-08 17:00:00	AAPL	Stock	38.7175	38.7175	38.6825	38.69	26924.0
2017-06-08 17:30:00	AAPL	Stock	38.6975	38.6975	38.6875	38.6975	5672.0
2017-06-08 18:00:00	AAPL	Stock	38.6975	38.7	38.675	38.6825	17004.0
2017-06-08 18:30:00	AAPL	Stock	38.6825	38.6975	38.6775	38.6875	10600.0
2017-06-08 19:00:00	AAPL	Stock	38.6825	38.7	38.675	38.7	9404.0
2017-06-08 19:30:00	AAPL	Stock	38.695	38.6975	38.6625	38.675	27440.0
2017-06-08 05:30:00	MSFT	Stock	72.3	72.3	72.3	72.3	1400.0
2017-06-08 06:30:00	MSFT	Stock	72.2	72.2	72.2	72.2	500.0
2017-06-08 07:00:00	MSFT	Stock	72.44	72.44	72.44	72.44	500.0
2017-06-08 07:30:00	MSFT	Stock	72.42	72.42	72.38	72.38	300.0
2017-06-08 08:00:00	MSFT	Stock	72.39	72.45	72.38	72.45	6748.0
2017-06-08 08:30:00	MSFT	Stock	72.5	72.5	72.41	72.41	6388.0
2017-06-08 09:00:00	MSFT	Stock	72.41	72.58	72.41	72.43	8695.0
2017-06-08 09:30:00	MSFT	Stock	72.51	72.52	71.93	72.025	2603994.0
2017-06-08 10:00:00	MSFT	Stock	72.025	72.09	71.84	71.984	1598999.0
2017-06-08 10:30:00	MSFT	Stock	71.984	72.23	71.984	72.07	1154536.0
2017-06-08 11:00:00	MSFT	Stock	72.07	72.12	71.98	72.02	1329416.0
2017-06-08 11:30:00	MSFT	Stock	72.02	72.07	71.95	71.98	1288511.0
2017-06-08 12:00:00	MSFT	Stock	71.99	72.07	71.94	72.044	950571.0
2017-06-08 12:30:00	MSFT	Stock	72.04	72.09	72.025	72.08	775291.0
2017-06-08 13:00:00	MSFT	Stock	72.08	72.09	71.83	71.86	1226379.0
2017-06-08 13:30:00	MSFT	Stock	71.85	71.86	71.7	71.78	1180991.0
2017-06-08 14:00:00	MSFT	Stock	71.78	71.815	71.63	71.64	1139241.0
2017-06-08 14:30:00	MSFT	Stock	71.64	71.71	71.5	71.545	1332010.0
2017-06-08 15:00:00	MSFT	Stock	71.545	71.75	71.545	71.7	1460606.0

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

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