PREVIEW / stock_30min / 2018-05-02

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-02.parquet
  size:    1.7 MB
  rows:    83,085
  symbols: 2,841

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-02 04:00:00	AAPL	Stock	43.59	43.825	43.59	43.6725	170864.0
2018-05-02 04:30:00	AAPL	Stock	43.6725	43.6725	43.4525	43.455	167188.0
2018-05-02 05:00:00	AAPL	Stock	43.4875	43.55	43.415	43.55	59964.0
2018-05-02 05:30:00	AAPL	Stock	43.55	43.765	43.55	43.7325	87716.0
2018-05-02 06:00:00	AAPL	Stock	43.7375	43.75	43.575	43.575	106000.0
2018-05-02 06:30:00	AAPL	Stock	43.5625	43.685	43.55	43.685	26352.0
2018-05-02 07:00:00	AAPL	Stock	43.6825	44.1125	43.6575	44.0875	1323316.0
2018-05-02 07:30:00	AAPL	Stock	44.075	44.24	44.05	44.22	996724.0
2018-05-02 08:00:00	AAPL	Stock	44.11	44.3125	43.675	44.1375	3250088.0
2018-05-02 08:30:00	AAPL	Stock	44.1375	44.1375	43.7525	43.9475	2341056.0
2018-05-02 09:00:00	AAPL	Stock	43.925	43.9625	43.7175	43.8125	1388356.0
2018-05-02 09:30:00	AAPL	Stock	43.8125	44.0225	43.45	43.865	64802424.0
2018-05-02 10:00:00	AAPL	Stock	43.865	44.1875	43.865	44.04	23664020.0
2018-05-02 10:30:00	AAPL	Stock	44.035	44.18	43.94	43.975	13604980.0
2018-05-02 11:00:00	AAPL	Stock	43.9775	44.15	43.94	44.0067	13054124.0
2018-05-02 11:30:00	AAPL	Stock	44.008	44.055	43.8025	43.9975	11340260.0
2018-05-02 12:00:00	AAPL	Stock	43.9925	44.15	43.94	44.13	9281200.0
2018-05-02 12:30:00	AAPL	Stock	44.13	44.1875	44.0052	44.0575	9097140.0
2018-05-02 13:00:00	AAPL	Stock	44.056	44.235	44.041	44.2252	7622824.0
2018-05-02 13:30:00	AAPL	Stock	44.2275	44.25	44.1525	44.2465	6221800.0
2018-05-02 14:00:00	AAPL	Stock	44.2475	44.4225	44.2175	44.3888	15173344.0
2018-05-02 14:30:00	AAPL	Stock	44.3885	44.4375	44.271	44.3578	10802344.0
2018-05-02 15:00:00	AAPL	Stock	44.3625	44.4125	44.25	44.3125	9627572.0
2018-05-02 15:30:00	AAPL	Stock	44.3118	44.375	44.025	44.155	21900696.0
2018-05-02 16:00:00	AAPL	Stock	44.16	44.19	44.0875	44.1075	10096608.0
2018-05-02 16:30:00	AAPL	Stock	44.1175	44.1425	44.0675	44.0925	170712.0
2018-05-02 17:00:00	AAPL	Stock	44.11	44.125	44.09	44.1175	40040.0
2018-05-02 17:30:00	AAPL	Stock	44.13	44.1425	44.1175	44.1375	29972.0
2018-05-02 18:00:00	AAPL	Stock	44.13	44.15	44.125	44.15	40240.0
2018-05-02 18:30:00	AAPL	Stock	44.14	44.15	44.1325	44.1475	26956.0
2018-05-02 19:00:00	AAPL	Stock	44.135	44.1725	44.135	44.135	9640.0
2018-05-02 19:30:00	AAPL	Stock	44.15	44.15	44.125	44.125	88272.0
2018-05-02 04:00:00	MSFT	Stock	95.05	95.11	95.05	95.11	620.0
2018-05-02 04:30:00	MSFT	Stock	95.25	95.3	95.25	95.25	300.0
2018-05-02 05:00:00	MSFT	Stock	95.29	95.58	95.29	95.58	1820.0
2018-05-02 05:30:00	MSFT	Stock	95.58	95.58	95.58	95.58	1800.0
2018-05-02 07:00:00	MSFT	Stock	95.31	95.35	95.2	95.2	2328.0
2018-05-02 07:30:00	MSFT	Stock	95.21	95.22	95.0	95.0	12072.0
2018-05-02 08:00:00	MSFT	Stock	95.2	95.4	94.86	95.05	13840.0
2018-05-02 08:30:00	MSFT	Stock	95.05	95.05	94.71	94.87	32185.0
2018-05-02 09:00:00	MSFT	Stock	94.92	95.0	94.84	94.99	16965.0
2018-05-02 09:30:00	MSFT	Stock	94.96	95.17	94.26	94.29	2620446.0
2018-05-02 10:00:00	MSFT	Stock	94.3	94.65	94.05	94.07	1932579.0
2018-05-02 10:30:00	MSFT	Stock	94.08	94.42	94.01	94.15	1444843.0
2018-05-02 11:00:00	MSFT	Stock	94.15	94.33	93.96	94.095	1176655.0
2018-05-02 11:30:00	MSFT	Stock	94.09	94.166	93.43	93.805	2020370.0
2018-05-02 12:00:00	MSFT	Stock	93.8	94.04	93.62	94.025	1159942.0
2018-05-02 12:30:00	MSFT	Stock	94.02	94.28	93.88	94.05	1181842.0
2018-05-02 13:00:00	MSFT	Stock	94.05	94.479	94.045	94.334	1021711.0
2018-05-02 13:30:00	MSFT	Stock	94.33	94.36	94.03	94.14	675412.0

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

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