PREVIEW / stock_30min / 2018-03-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-19.parquet
  size:    1.7 MB
  rows:    83,137
  symbols: 2,883

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
2018-03-19 04:00:00	AAPL	Stock	44.25	44.25	44.0325	44.0325	5656.0
2018-03-19 04:30:00	AAPL	Stock	43.95	43.95	43.8	43.8725	24936.0
2018-03-19 05:00:00	AAPL	Stock	43.9125	43.9125	43.9125	43.9125	4000.0
2018-03-19 05:30:00	AAPL	Stock	43.9825	43.9825	43.9125	43.9125	4864.0
2018-03-19 06:00:00	AAPL	Stock	43.8825	43.8825	43.8825	43.8825	600.0
2018-03-19 06:30:00	AAPL	Stock	43.8775	43.9575	43.8775	43.9575	5444.0
2018-03-19 07:00:00	AAPL	Stock	43.9675	44.0775	43.9375	43.9775	219352.0
2018-03-19 07:30:00	AAPL	Stock	44.005	44.215	44.0	44.175	104464.0
2018-03-19 08:00:00	AAPL	Stock	44.005	44.36	43.96	44.3125	324204.0
2018-03-19 08:30:00	AAPL	Stock	44.3225	44.33	44.2525	44.3075	146060.0
2018-03-19 09:00:00	AAPL	Stock	44.305	44.3625	44.2025	44.305	201736.0
2018-03-19 09:30:00	AAPL	Stock	44.3425	44.3675	44.0725	44.2025	13137804.0
2018-03-19 10:00:00	AAPL	Stock	44.2025	44.22	44.065	44.1238	6332268.0
2018-03-19 10:30:00	AAPL	Stock	44.1225	44.124	43.895	43.96	7721472.0
2018-03-19 11:00:00	AAPL	Stock	43.9575	44.0075	43.825	43.94	6223256.0
2018-03-19 11:30:00	AAPL	Stock	43.9425	43.9425	43.6275	43.6675	9121044.0
2018-03-19 12:00:00	AAPL	Stock	43.67	43.8425	43.63	43.8338	7706960.0
2018-03-19 12:30:00	AAPL	Stock	43.835	43.8475	43.5075	43.63	8036100.0
2018-03-19 13:00:00	AAPL	Stock	43.6275	43.655	43.415	43.5475	6823852.0
2018-03-19 13:30:00	AAPL	Stock	43.5475	43.6872	43.5075	43.6275	6065924.0
2018-03-19 14:00:00	AAPL	Stock	43.625	43.72	43.5275	43.575	5225156.0
2018-03-19 14:30:00	AAPL	Stock	43.5725	43.705	43.4575	43.66	6405100.0
2018-03-19 15:00:00	AAPL	Stock	43.6548	43.8325	43.58	43.695	7562708.0
2018-03-19 15:30:00	AAPL	Stock	43.695	43.855	43.6325	43.83	14001624.0
2018-03-19 16:00:00	AAPL	Stock	43.8275	43.97	43.815	43.9625	12012768.0
2018-03-19 16:30:00	AAPL	Stock	43.9375	43.95	43.825	43.935	61680.0
2018-03-19 17:00:00	AAPL	Stock	43.925	43.925	43.8975	43.9	46124.0
2018-03-19 17:30:00	AAPL	Stock	43.875	43.885	43.845	43.875	32108.0
2018-03-19 18:00:00	AAPL	Stock	43.875	43.875	43.8425	43.85	22900.0
2018-03-19 18:30:00	AAPL	Stock	43.85	43.86	43.83	43.83	17556.0
2018-03-19 19:00:00	AAPL	Stock	43.85	43.85	43.7525	43.7525	31740.0
2018-03-19 19:30:00	AAPL	Stock	43.7375	43.8	43.6875	43.6875	11320.0
2018-03-19 04:00:00	MSFT	Stock	94.06	94.06	93.64	93.64	1200.0
2018-03-19 04:30:00	MSFT	Stock	93.53	93.53	93.53	93.53	800.0
2018-03-19 06:00:00	MSFT	Stock	93.64	93.64	93.64	93.64	200.0
2018-03-19 06:30:00	MSFT	Stock	93.58	93.58	93.55	93.57	1289.0
2018-03-19 07:00:00	MSFT	Stock	93.68	93.7	93.2	93.26	23815.0
2018-03-19 07:30:00	MSFT	Stock	93.28	93.6	93.25	93.6	16291.0
2018-03-19 08:00:00	MSFT	Stock	93.4	93.77	93.26	93.74	8762.0
2018-03-19 08:30:00	MSFT	Stock	93.65	93.7	93.6	93.67	5718.0
2018-03-19 09:00:00	MSFT	Stock	93.65	93.88	93.65	93.74	23978.0
2018-03-19 09:30:00	MSFT	Stock	93.74	93.96	93.19	93.52	3377556.0
2018-03-19 10:00:00	MSFT	Stock	93.525	93.6	93.15	93.46	1559998.0
2018-03-19 10:30:00	MSFT	Stock	93.46	93.56	92.735	92.845	1613589.0
2018-03-19 11:00:00	MSFT	Stock	92.84	92.95	92.52	92.71	1741018.0
2018-03-19 11:30:00	MSFT	Stock	92.72	92.82	92.42	92.59	1683452.0
2018-03-19 12:00:00	MSFT	Stock	92.59	92.84	92.51	92.796	1641321.0
2018-03-19 12:30:00	MSFT	Stock	92.79	92.9	92.44	92.774	1548178.0
2018-03-19 13:00:00	MSFT	Stock	92.77	92.88	92.24	92.45	1586854.0
2018-03-19 13:30:00	MSFT	Stock	92.45	92.64	92.27	92.492	1367799.0

> showing 50 of 83,137 rows — these rows as CSV

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