PREVIEW / stock_30min / 2019-08-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-13.parquet
  size:    1.7 MB
  rows:    84,569
  symbols: 2,571

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
2019-08-13 04:00:00	AAPL	Stock	50.015	50.015	50.015	50.015	748.0
2019-08-13 04:30:00	AAPL	Stock	50.0675	50.0675	50.0675	50.0675	400.0
2019-08-13 05:00:00	AAPL	Stock	50.0	50.0	49.8	49.8	29332.0
2019-08-13 05:30:00	AAPL	Stock	49.7625	49.835	49.7625	49.83	6400.0
2019-08-13 06:00:00	AAPL	Stock	49.8525	49.9	49.74	49.8475	8496.0
2019-08-13 06:30:00	AAPL	Stock	49.9725	50.03	49.96	50.03	29200.0
2019-08-13 07:00:00	AAPL	Stock	50.0	50.25	50.0	50.1025	165112.0
2019-08-13 07:30:00	AAPL	Stock	50.1025	50.2075	50.0625	50.18	65372.0
2019-08-13 08:00:00	AAPL	Stock	50.1175	50.2125	50.0	50.2125	79252.0
2019-08-13 08:30:00	AAPL	Stock	50.1375	50.2028	49.9825	50.08	104240.0
2019-08-13 09:00:00	AAPL	Stock	50.08	50.325	50.03	50.25	293196.0
2019-08-13 09:30:00	AAPL	Stock	50.255	53.035	50.2075	53.0175	39923272.0
2019-08-13 10:00:00	AAPL	Stock	53.0112	53.0165	52.275	52.58	22804956.0
2019-08-13 10:30:00	AAPL	Stock	52.585	52.62	52.145	52.1625	12789704.0
2019-08-13 11:00:00	AAPL	Stock	52.1638	52.2375	51.8775	52.0112	14096504.0
2019-08-13 11:30:00	AAPL	Stock	52.005	52.2775	51.8975	52.195	10002584.0
2019-08-13 12:00:00	AAPL	Stock	52.1987	52.245	52.08	52.085	5382848.0
2019-08-13 12:30:00	AAPL	Stock	52.0875	52.165	52.0075	52.1075	4579596.0
2019-08-13 13:00:00	AAPL	Stock	52.11	52.38	52.0725	52.3288	6514300.0
2019-08-13 13:30:00	AAPL	Stock	52.3325	52.41	52.275	52.3575	3973784.0
2019-08-13 14:00:00	AAPL	Stock	52.3575	52.475	52.3375	52.4738	4733020.0
2019-08-13 14:30:00	AAPL	Stock	52.475	52.5	52.4075	52.4175	4920884.0
2019-08-13 15:00:00	AAPL	Stock	52.415	52.45	52.2275	52.3225	6190644.0
2019-08-13 15:30:00	AAPL	Stock	52.32	52.3825	52.205	52.245	14267020.0
2019-08-13 16:00:00	AAPL	Stock	52.245	52.3	50.12	52.2625	12111768.0
2019-08-13 16:30:00	AAPL	Stock	52.25	52.29	52.2275	52.2275	328676.0
2019-08-13 17:00:00	AAPL	Stock	52.2275	52.25	52.2	52.22	37944.0
2019-08-13 17:30:00	AAPL	Stock	52.192	52.2575	52.192	52.2575	35740.0
2019-08-13 18:00:00	AAPL	Stock	52.2725	52.2925	52.23	52.2925	57596.0
2019-08-13 18:30:00	AAPL	Stock	52.29	52.35	52.2825	52.35	52220.0
2019-08-13 19:00:00	AAPL	Stock	52.36	52.415	52.35	52.4	92888.0
2019-08-13 19:30:00	AAPL	Stock	52.4025	52.4425	52.3725	52.375	63084.0
2019-08-13 04:00:00	MSFT	Stock	135.6	135.6	135.11	135.11	542.0
2019-08-13 04:30:00	MSFT	Stock	135.65	135.65	135.65	135.65	100.0
2019-08-13 05:00:00	MSFT	Stock	135.56	135.56	135.04	135.04	1129.0
2019-08-13 05:30:00	MSFT	Stock	134.95	134.99	134.7	134.99	2451.0
2019-08-13 06:00:00	MSFT	Stock	134.75	135.18	134.71	135.18	350.0
2019-08-13 06:30:00	MSFT	Stock	135.32	135.48	135.32	135.48	200.0
2019-08-13 07:00:00	MSFT	Stock	135.58	135.58	135.37	135.37	6310.0
2019-08-13 07:30:00	MSFT	Stock	135.4	135.47	135.27	135.35	3811.0
2019-08-13 08:00:00	MSFT	Stock	135.52	135.59	135.18	135.28	14293.0
2019-08-13 08:30:00	MSFT	Stock	135.3	135.3	135.15	135.3	10758.0
2019-08-13 09:00:00	MSFT	Stock	135.3	136.0	135.3	135.93	27799.0
2019-08-13 09:30:00	MSFT	Stock	135.91	138.8	135.0	138.55	3741360.0
2019-08-13 10:00:00	MSFT	Stock	138.52	138.76	137.82	138.64	2192083.0
2019-08-13 10:30:00	MSFT	Stock	138.67	138.75	137.905	137.95	1619923.0
2019-08-13 11:00:00	MSFT	Stock	137.92	138.44	137.39	137.77	1358419.0
2019-08-13 11:30:00	MSFT	Stock	137.76	138.355	137.51	138.34	993943.0
2019-08-13 12:00:00	MSFT	Stock	138.35	138.475	138.13	138.25	848512.0
2019-08-13 12:30:00	MSFT	Stock	138.26	138.345	138.05	138.22	679108.0

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

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