PREVIEW / stock_30min / 2018-08-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-20.parquet
  size:    1.7 MB
  rows:    82,711
  symbols: 2,797

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-08-20 04:00:00	AAPL	Stock	54.5625	54.8375	54.5625	54.695	20968.0
2018-08-20 04:30:00	AAPL	Stock	54.7375	54.825	54.725	54.825	17352.0
2018-08-20 05:00:00	AAPL	Stock	54.81	54.81	54.725	54.725	52120.0
2018-08-20 05:30:00	AAPL	Stock	54.7675	54.775	54.7275	54.7625	10948.0
2018-08-20 06:00:00	AAPL	Stock	54.75	54.75	54.65	54.6625	55220.0
2018-08-20 06:30:00	AAPL	Stock	54.6625	54.685	54.6625	54.6775	16824.0
2018-08-20 07:00:00	AAPL	Stock	54.645	54.7225	54.6075	54.6075	261384.0
2018-08-20 07:30:00	AAPL	Stock	54.6075	54.6075	54.465	54.5	367908.0
2018-08-20 08:00:00	AAPL	Stock	54.66	54.725	54.475	54.475	374696.0
2018-08-20 08:30:00	AAPL	Stock	54.4925	54.5475	54.395	54.49	715776.0
2018-08-20 09:00:00	AAPL	Stock	54.4775	54.535	54.4425	54.5125	341760.0
2018-08-20 09:30:00	AAPL	Stock	54.5175	54.795	54.2825	54.3675	21814700.0
2018-08-20 10:00:00	AAPL	Stock	54.3575	54.51	54.11	54.1275	12664344.0
2018-08-20 10:30:00	AAPL	Stock	54.1275	54.1832	53.9345	53.9622	9189892.0
2018-08-20 11:00:00	AAPL	Stock	53.96	53.9822	53.7775	53.8725	8789260.0
2018-08-20 11:30:00	AAPL	Stock	53.8735	53.9625	53.8125	53.8275	6325944.0
2018-08-20 12:00:00	AAPL	Stock	53.83	53.98	53.7775	53.965	4494120.0
2018-08-20 12:30:00	AAPL	Stock	53.9675	54.0525	53.91	54.0485	3098656.0
2018-08-20 13:00:00	AAPL	Stock	54.05	54.2	54.0235	54.0705	4415636.0
2018-08-20 13:30:00	AAPL	Stock	54.0705	54.17	54.0475	54.0825	2803580.0
2018-08-20 14:00:00	AAPL	Stock	54.0825	54.105	53.97	54.03	3334704.0
2018-08-20 14:30:00	AAPL	Stock	54.0298	54.03	53.8125	53.9038	4753192.0
2018-08-20 15:00:00	AAPL	Stock	53.9025	53.93	53.8375	53.8592	3213320.0
2018-08-20 15:30:00	AAPL	Stock	53.8575	53.935	53.805	53.8625	8199876.0
2018-08-20 16:00:00	AAPL	Stock	53.865	53.8875	53.8375	53.875	8344996.0
2018-08-20 16:30:00	AAPL	Stock	53.875	53.875	53.8275	53.8375	43500.0
2018-08-20 17:00:00	AAPL	Stock	53.835	53.8575	53.8325	53.8575	24104.0
2018-08-20 17:30:00	AAPL	Stock	53.865	53.865	53.835	53.8375	84496.0
2018-08-20 18:00:00	AAPL	Stock	53.8475	53.85	53.835	53.85	12088.0
2018-08-20 18:30:00	AAPL	Stock	53.8725	53.8725	53.8375	53.865	26964.0
2018-08-20 19:00:00	AAPL	Stock	53.865	53.87	53.865	53.865	13596.0
2018-08-20 19:30:00	AAPL	Stock	53.865	53.88	53.84	53.88	36840.0
2018-08-20 04:00:00	MSFT	Stock	107.9	107.91	107.9	107.91	400.0
2018-08-20 04:30:00	MSFT	Stock	108.1	108.1	108.1	108.1	500.0
2018-08-20 06:00:00	MSFT	Stock	107.99	107.99	107.96	107.96	900.0
2018-08-20 07:00:00	MSFT	Stock	107.9	108.0	107.9	107.99	1710.0
2018-08-20 07:30:00	MSFT	Stock	107.9	107.9	107.75	107.85	3129.0
2018-08-20 08:00:00	MSFT	Stock	107.999	107.999	107.81	107.81	1150.0
2018-08-20 08:30:00	MSFT	Stock	107.87	107.88	107.81	107.81	1136.0
2018-08-20 09:00:00	MSFT	Stock	107.84	107.96	107.47	107.47	15440.0
2018-08-20 09:30:00	MSFT	Stock	107.51	107.9	106.83	106.925	1930118.0
2018-08-20 10:00:00	MSFT	Stock	106.92	107.205	106.79	106.9	1171748.0
2018-08-20 10:30:00	MSFT	Stock	106.903	107.09	106.725	106.745	1038690.0
2018-08-20 11:00:00	MSFT	Stock	106.745	106.805	106.48	106.68	1322148.0
2018-08-20 11:30:00	MSFT	Stock	106.683	107.03	106.62	106.91	1166289.0
2018-08-20 12:00:00	MSFT	Stock	106.93	107.19	106.84	107.12	650157.0
2018-08-20 12:30:00	MSFT	Stock	107.12	107.245	107.085	107.136	693033.0
2018-08-20 13:00:00	MSFT	Stock	107.14	107.15	106.98	107.1	513613.0
2018-08-20 13:30:00	MSFT	Stock	107.105	107.18	107.03	107.1	418612.0
2018-08-20 14:00:00	MSFT	Stock	107.11	107.16	106.95	107.03	660136.0

> showing 50 of 82,711 rows — these rows as CSV

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