PREVIEW / stock_30min / 2018-05-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-25.parquet
  size:    1.6 MB
  rows:    81,352
  symbols: 2,822

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-05-25 04:00:00	AAPL	Stock	47.195	47.195	47.195	47.195	1412.0
2018-05-25 04:30:00	AAPL	Stock	47.195	47.2625	47.195	47.2225	2852.0
2018-05-25 06:00:00	AAPL	Stock	47.165	47.165	47.165	47.165	400.0
2018-05-25 07:00:00	AAPL	Stock	47.21	47.215	47.0925	47.1425	60308.0
2018-05-25 07:30:00	AAPL	Stock	47.1	47.145	47.0375	47.075	36028.0
2018-05-25 08:00:00	AAPL	Stock	47.125	47.2198	47.0375	47.075	58912.0
2018-05-25 08:30:00	AAPL	Stock	47.0675	47.1	47.0175	47.0275	74424.0
2018-05-25 09:00:00	AAPL	Stock	47.0375	47.0725	46.9625	47.0625	145992.0
2018-05-25 09:30:00	AAPL	Stock	47.0575	47.185	46.9125	47.1135	7785692.0
2018-05-25 10:00:00	AAPL	Stock	47.1128	47.3625	47.085	47.3275	8065720.0
2018-05-25 10:30:00	AAPL	Stock	47.325	47.3725	47.2425	47.335	6296884.0
2018-05-25 11:00:00	AAPL	Stock	47.3325	47.3725	47.2675	47.3525	3531160.0
2018-05-25 11:30:00	AAPL	Stock	47.3525	47.4125	47.34	47.3475	3695496.0
2018-05-25 12:00:00	AAPL	Stock	47.3475	47.3725	47.27	47.3665	3401432.0
2018-05-25 12:30:00	AAPL	Stock	47.365	47.3975	47.335	47.3635	2207752.0
2018-05-25 13:00:00	AAPL	Stock	47.361	47.405	47.32	47.32	2052804.0
2018-05-25 13:30:00	AAPL	Stock	47.3225	47.325	47.195	47.215	3088548.0
2018-05-25 14:00:00	AAPL	Stock	47.2125	47.2475	47.18	47.235	2072216.0
2018-05-25 14:30:00	AAPL	Stock	47.235	47.2388	47.085	47.1548	3019804.0
2018-05-25 15:00:00	AAPL	Stock	47.155	47.19	47.1088	47.1775	3187356.0
2018-05-25 15:30:00	AAPL	Stock	47.18	47.185	47.08	47.145	6373908.0
2018-05-25 16:00:00	AAPL	Stock	47.145	47.16	47.011	47.145	6595052.0
2018-05-25 16:30:00	AAPL	Stock	47.1275	47.15	47.1275	47.15	22760.0
2018-05-25 17:00:00	AAPL	Stock	47.1725	47.175	47.1675	47.175	23408.0
2018-05-25 17:30:00	AAPL	Stock	47.145	47.155	47.145	47.155	1972.0
2018-05-25 18:00:00	AAPL	Stock	47.1575	47.17	47.1575	47.17	6080.0
2018-05-25 18:30:00	AAPL	Stock	47.165	47.175	47.165	47.175	17860.0
2018-05-25 19:00:00	AAPL	Stock	47.1825	47.1825	47.17	47.17	3200.0
2018-05-25 19:30:00	AAPL	Stock	47.1675	47.1825	47.1675	47.1825	7312.0
2018-05-25 04:30:00	MSFT	Stock	98.7	98.88	98.7	98.88	868.0
2018-05-25 06:00:00	MSFT	Stock	98.82	98.88	98.79	98.79	650.0
2018-05-25 07:00:00	MSFT	Stock	98.65	98.75	98.44	98.55	12744.0
2018-05-25 07:30:00	MSFT	Stock	98.55	98.55	98.41	98.45	3197.0
2018-05-25 08:00:00	MSFT	Stock	98.68	98.68	98.22	98.25	22077.0
2018-05-25 08:30:00	MSFT	Stock	98.3	98.35	98.15	98.2	4096.0
2018-05-25 09:00:00	MSFT	Stock	98.17	98.45	98.15	98.32	11067.0
2018-05-25 09:30:00	MSFT	Stock	98.3	98.645	97.86	98.23	1882614.0
2018-05-25 10:00:00	MSFT	Stock	98.22	98.77	98.12	98.7	1610509.0
2018-05-25 10:30:00	MSFT	Stock	98.7	98.88	98.51	98.69	1301197.0
2018-05-25 11:00:00	MSFT	Stock	98.7	98.92	98.54	98.75	936698.0
2018-05-25 11:30:00	MSFT	Stock	98.75	98.98	98.72	98.79	907448.0
2018-05-25 12:00:00	MSFT	Stock	98.78	98.81	98.44	98.68	900726.0
2018-05-25 12:30:00	MSFT	Stock	98.67	98.84	98.47	98.515	677954.0
2018-05-25 13:00:00	MSFT	Stock	98.51	98.626	98.48	98.555	452993.0
2018-05-25 13:30:00	MSFT	Stock	98.56	98.57	98.3	98.36	608548.0
2018-05-25 14:00:00	MSFT	Stock	98.354	98.6	98.3	98.58	580047.0
2018-05-25 14:30:00	MSFT	Stock	98.59	98.597	98.29	98.32	781149.0
2018-05-25 15:00:00	MSFT	Stock	98.315	98.46	98.26	98.43	916452.0
2018-05-25 15:30:00	MSFT	Stock	98.427	98.45	98.21	98.38	2547756.0
2018-05-25 16:00:00	MSFT	Stock	98.38	98.38	98.13	98.26	2119805.0

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

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