PREVIEW / stock_30min / 2018-07-10

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-10.parquet
  size:    1.7 MB
  rows:    84,535
  symbols: 2,823

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-07-10 04:00:00	AAPL	Stock	47.6425	47.6425	47.565	47.565	2236.0
2018-07-10 05:00:00	AAPL	Stock	47.565	47.6025	47.5625	47.6025	9712.0
2018-07-10 05:30:00	AAPL	Stock	47.625	47.6975	47.6175	47.6975	2576.0
2018-07-10 06:00:00	AAPL	Stock	47.66	47.68	47.66	47.68	2000.0
2018-07-10 06:30:00	AAPL	Stock	47.6725	47.6875	47.65	47.6875	26812.0
2018-07-10 07:00:00	AAPL	Stock	47.685	47.725	47.645	47.6975	73416.0
2018-07-10 07:30:00	AAPL	Stock	47.6875	47.75	47.65	47.695	86468.0
2018-07-10 08:00:00	AAPL	Stock	47.7105	47.735	47.625	47.625	113056.0
2018-07-10 08:30:00	AAPL	Stock	47.6375	47.705	47.625	47.675	66724.0
2018-07-10 09:00:00	AAPL	Stock	47.665	47.7225	47.65	47.665	90096.0
2018-07-10 09:30:00	AAPL	Stock	47.645	47.7825	47.555	47.65	8803872.0
2018-07-10 10:00:00	AAPL	Stock	47.6475	47.7325	47.5675	47.7275	5233312.0
2018-07-10 10:30:00	AAPL	Stock	47.7275	47.8	47.705	47.7425	4338712.0
2018-07-10 11:00:00	AAPL	Stock	47.7475	47.7875	47.69	47.76	3823172.0
2018-07-10 11:30:00	AAPL	Stock	47.755	47.8025	47.7025	47.7975	2603972.0
2018-07-10 12:00:00	AAPL	Stock	47.7985	47.82	47.7425	47.7725	2587264.0
2018-07-10 12:30:00	AAPL	Stock	47.7725	47.775	47.705	47.7175	2079388.0
2018-07-10 13:00:00	AAPL	Stock	47.7175	47.73	47.6275	47.66	2183416.0
2018-07-10 13:30:00	AAPL	Stock	47.6575	47.67	47.5675	47.6268	2791072.0
2018-07-10 14:00:00	AAPL	Stock	47.6262	47.6425	47.5675	47.6062	2164024.0
2018-07-10 14:30:00	AAPL	Stock	47.6075	47.665	47.56	47.645	1946372.0
2018-07-10 15:00:00	AAPL	Stock	47.6475	47.7025	47.63	47.6612	2304844.0
2018-07-10 15:30:00	AAPL	Stock	47.665	47.6962	47.545	47.5875	6063308.0
2018-07-10 16:00:00	AAPL	Stock	47.5875	47.62	47.5625	47.5725	5616344.0
2018-07-10 16:30:00	AAPL	Stock	47.5725	47.5875	47.3425	47.385	310556.0
2018-07-10 17:00:00	AAPL	Stock	47.445	47.45	47.2625	47.2875	81028.0
2018-07-10 17:30:00	AAPL	Stock	47.2875	47.3675	47.2825	47.32	65724.0
2018-07-10 18:00:00	AAPL	Stock	47.345	47.35	47.25	47.2525	77796.0
2018-07-10 18:30:00	AAPL	Stock	47.2525	47.275	47.155	47.1575	119788.0
2018-07-10 19:00:00	AAPL	Stock	47.165	47.2	47.155	47.17	46420.0
2018-07-10 19:30:00	AAPL	Stock	47.1875	47.1875	47.155	47.17	102136.0
2018-07-10 05:30:00	MSFT	Stock	102.2	102.2	102.18	102.2	2051.0
2018-07-10 06:00:00	MSFT	Stock	102.26	102.3	102.26	102.3	548.0
2018-07-10 06:30:00	MSFT	Stock	102.3	102.3	102.3	102.3	400.0
2018-07-10 07:00:00	MSFT	Stock	102.3	102.39	102.1	102.37	4030.0
2018-07-10 07:30:00	MSFT	Stock	102.37	102.37	102.25	102.33	1629.0
2018-07-10 08:00:00	MSFT	Stock	102.12	102.4	102.0	102.0	17133.0
2018-07-10 08:30:00	MSFT	Stock	102.0	102.19	102.0	102.11	6254.0
2018-07-10 09:00:00	MSFT	Stock	102.02	102.18	102.02	102.11	2327.0
2018-07-10 09:30:00	MSFT	Stock	102.0	102.38	101.995	102.02	2516258.0
2018-07-10 10:00:00	MSFT	Stock	102.02	102.28	101.9	102.137	1295147.0
2018-07-10 10:30:00	MSFT	Stock	102.13	102.37	102.096	102.31	915133.0
2018-07-10 11:00:00	MSFT	Stock	102.3	102.42	102.01	102.09	1212133.0
2018-07-10 11:30:00	MSFT	Stock	102.1	102.51	102.06	102.508	787491.0
2018-07-10 12:00:00	MSFT	Stock	102.51	102.51	102.25	102.48	782307.0
2018-07-10 12:30:00	MSFT	Stock	102.48	102.5	102.365	102.41	716544.0
2018-07-10 13:00:00	MSFT	Stock	102.41	102.46	102.23	102.26	674267.0
2018-07-10 13:30:00	MSFT	Stock	102.25	102.27	101.86	101.91	1068198.0
2018-07-10 14:00:00	MSFT	Stock	101.915	102.2	101.91	102.145	763940.0
2018-07-10 14:30:00	MSFT	Stock	102.145	102.18	102.0	102.13	717119.0

> showing 50 of 84,535 rows — these rows as CSV

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