PREVIEW / stock_30min / 2018-02-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-23.parquet
  size:    1.6 MB
  rows:    81,555
  symbols: 2,868

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-02-23 04:00:00	AAPL	Stock	43.325	43.4	43.325	43.375	6960.0
2018-02-23 04:30:00	AAPL	Stock	43.395	43.395	43.395	43.395	6800.0
2018-02-23 05:00:00	AAPL	Stock	43.395	43.4	43.3375	43.3975	11800.0
2018-02-23 05:30:00	AAPL	Stock	43.325	43.325	43.3125	43.3125	20400.0
2018-02-23 06:00:00	AAPL	Stock	43.335	43.4475	43.325	43.4025	52112.0
2018-02-23 06:30:00	AAPL	Stock	43.4025	43.45	43.4	43.42	21584.0
2018-02-23 07:00:00	AAPL	Stock	43.4125	43.45	43.3925	43.435	147344.0
2018-02-23 07:30:00	AAPL	Stock	43.415	43.42	43.38	43.395	39936.0
2018-02-23 08:00:00	AAPL	Stock	43.4062	43.47	43.3775	43.425	220316.0
2018-02-23 08:30:00	AAPL	Stock	43.445	43.445	43.3575	43.37	171704.0
2018-02-23 09:00:00	AAPL	Stock	43.3875	43.45	43.3425	43.45	207456.0
2018-02-23 09:30:00	AAPL	Stock	43.4175	43.6575	43.4	43.5225	19257968.0
2018-02-23 10:00:00	AAPL	Stock	43.5175	43.57	43.385	43.455	10278068.0
2018-02-23 10:30:00	AAPL	Stock	43.4575	43.6125	43.425	43.5988	7537216.0
2018-02-23 11:00:00	AAPL	Stock	43.5988	43.645	43.5325	43.6175	6948044.0
2018-02-23 11:30:00	AAPL	Stock	43.615	43.6975	43.585	43.6625	7122412.0
2018-02-23 12:00:00	AAPL	Stock	43.6675	43.6888	43.5675	43.595	4569908.0
2018-02-23 12:30:00	AAPL	Stock	43.5975	43.6625	43.575	43.6425	4311852.0
2018-02-23 13:00:00	AAPL	Stock	43.6425	43.645	43.545	43.6075	4133560.0
2018-02-23 13:30:00	AAPL	Stock	43.605	43.6425	43.5975	43.635	4121288.0
2018-02-23 14:00:00	AAPL	Stock	43.6325	43.655	43.5675	43.6375	4609688.0
2018-02-23 14:30:00	AAPL	Stock	43.6375	43.75	43.6025	43.745	9040356.0
2018-02-23 15:00:00	AAPL	Stock	43.745	43.8745	43.74	43.8625	12307592.0
2018-02-23 15:30:00	AAPL	Stock	43.865	43.9125	43.815	43.89	18167964.0
2018-02-23 16:00:00	AAPL	Stock	43.875	43.9375	43.8225	43.8975	8586960.0
2018-02-23 16:30:00	AAPL	Stock	43.8825	43.925	43.875	43.885	75524.0
2018-02-23 17:00:00	AAPL	Stock	43.885	43.9075	43.85	43.895	110464.0
2018-02-23 17:30:00	AAPL	Stock	43.8925	43.9075	43.875	43.8925	15988.0
2018-02-23 18:00:00	AAPL	Stock	43.8925	43.9075	43.87	43.87	30084.0
2018-02-23 18:30:00	AAPL	Stock	43.875	43.9075	43.875	43.9075	12204.0
2018-02-23 19:00:00	AAPL	Stock	43.875	43.8925	43.87	43.875	16080.0
2018-02-23 19:30:00	AAPL	Stock	43.875	43.8925	43.865	43.87	18460.0
2018-02-23 06:00:00	MSFT	Stock	92.3	92.35	92.1	92.1	2145.0
2018-02-23 06:30:00	MSFT	Stock	92.25	92.43	92.25	92.43	986.0
2018-02-23 07:00:00	MSFT	Stock	92.45	92.49	92.4	92.49	3993.0
2018-02-23 07:30:00	MSFT	Stock	92.5	92.5	92.4	92.41	7716.0
2018-02-23 08:00:00	MSFT	Stock	92.48	92.58	92.46	92.46	8086.0
2018-02-23 08:30:00	MSFT	Stock	92.46	92.7	92.36	92.4	19873.0
2018-02-23 09:00:00	MSFT	Stock	92.56	92.78	92.4	92.77	25587.0
2018-02-23 09:30:00	MSFT	Stock	92.75	92.9	92.36	92.89	2363440.0
2018-02-23 10:00:00	MSFT	Stock	92.88	92.94	92.53	92.61	1446126.0
2018-02-23 10:30:00	MSFT	Stock	92.61	93.05	92.52	93.02	1423959.0
2018-02-23 11:00:00	MSFT	Stock	93.02	93.28	93.0	93.2	1338685.0
2018-02-23 11:30:00	MSFT	Stock	93.204	93.37	93.12	93.34	1002659.0
2018-02-23 12:00:00	MSFT	Stock	93.34	93.43	93.15	93.18	848716.0
2018-02-23 12:30:00	MSFT	Stock	93.18	93.27	93.05	93.05	1145464.0
2018-02-23 13:00:00	MSFT	Stock	93.056	93.1	92.9	93.065	950800.0
2018-02-23 13:30:00	MSFT	Stock	93.069	93.27	93.0	93.25	724825.0
2018-02-23 14:00:00	MSFT	Stock	93.24	93.3	93.03	93.21	668444.0
2018-02-23 14:30:00	MSFT	Stock	93.21	93.6	93.19	93.51	1546595.0

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

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