PREVIEW / stock_30min / 2018-03-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-06.parquet
  size:    1.7 MB
  rows:    85,385
  symbols: 2,873

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-03-06 04:00:00	AAPL	Stock	44.3425	44.3425	44.3375	44.3425	2400.0
2018-03-06 04:30:00	AAPL	Stock	44.37	44.3875	44.37	44.3875	5600.0
2018-03-06 05:00:00	AAPL	Stock	44.3375	44.4425	44.325	44.3875	7716.0
2018-03-06 05:30:00	AAPL	Stock	44.4375	44.4375	44.4375	44.4375	800.0
2018-03-06 06:00:00	AAPL	Stock	44.405	44.53	44.405	44.53	22592.0
2018-03-06 06:30:00	AAPL	Stock	44.5275	44.5325	44.455	44.5	14992.0
2018-03-06 07:00:00	AAPL	Stock	44.4875	44.54	44.46	44.5	144828.0
2018-03-06 07:30:00	AAPL	Stock	44.48	44.535	44.47	44.5325	57960.0
2018-03-06 08:00:00	AAPL	Stock	44.525	44.54	44.4788	44.5	160580.0
2018-03-06 08:30:00	AAPL	Stock	44.485	44.5	44.4325	44.4625	235236.0
2018-03-06 09:00:00	AAPL	Stock	44.4775	44.525	44.455	44.4775	301712.0
2018-03-06 09:30:00	AAPL	Stock	44.475	44.56	44.35	44.475	14597252.0
2018-03-06 10:00:00	AAPL	Stock	44.475	44.5625	44.34	44.405	7523144.0
2018-03-06 10:30:00	AAPL	Stock	44.4025	44.4475	44.2025	44.2575	6225280.0
2018-03-06 11:00:00	AAPL	Stock	44.2525	44.265	44.085	44.14	7224280.0
2018-03-06 11:30:00	AAPL	Stock	44.1425	44.2455	44.1	44.2448	4888804.0
2018-03-06 12:00:00	AAPL	Stock	44.24	44.285	44.1575	44.1725	3815028.0
2018-03-06 12:30:00	AAPL	Stock	44.17	44.355	44.1425	44.355	4580636.0
2018-03-06 13:00:00	AAPL	Stock	44.3525	44.385	44.2375	44.2588	4392496.0
2018-03-06 13:30:00	AAPL	Stock	44.2588	44.291	44.085	44.12	4676564.0
2018-03-06 14:00:00	AAPL	Stock	44.12	44.175	44.0325	44.0475	3969604.0
2018-03-06 14:30:00	AAPL	Stock	44.045	44.25	44.045	44.175	3726484.0
2018-03-06 15:00:00	AAPL	Stock	44.1763	44.205	44.05	44.09	4191548.0
2018-03-06 15:30:00	AAPL	Stock	44.09	44.215	44.0525	44.17	8468168.0
2018-03-06 16:00:00	AAPL	Stock	44.1675	44.17	44.13	44.1675	5943044.0
2018-03-06 16:30:00	AAPL	Stock	44.1425	44.1725	44.1425	44.1625	79144.0
2018-03-06 17:00:00	AAPL	Stock	44.145	44.145	44.1275	44.1275	32144.0
2018-03-06 17:30:00	AAPL	Stock	44.125	44.1375	43.45	43.5625	440444.0
2018-03-06 18:00:00	AAPL	Stock	43.5625	43.625	43.35	43.4	349452.0
2018-03-06 18:30:00	AAPL	Stock	43.4375	43.545	43.375	43.4625	159432.0
2018-03-06 19:00:00	AAPL	Stock	43.4725	43.475	43.4	43.4225	128124.0
2018-03-06 19:30:00	AAPL	Stock	43.405	43.4975	43.405	43.485	98544.0
2018-03-06 06:00:00	MSFT	Stock	94.15	94.15	94.15	94.15	100.0
2018-03-06 07:00:00	MSFT	Stock	94.45	94.45	94.05	94.1	4737.0
2018-03-06 07:30:00	MSFT	Stock	94.05	94.05	94.03	94.03	2267.0
2018-03-06 08:00:00	MSFT	Stock	94.19	94.19	93.85	94.14	14985.0
2018-03-06 08:30:00	MSFT	Stock	94.11	94.14	94.05	94.05	4749.0
2018-03-06 09:00:00	MSFT	Stock	94.0	94.4	94.0	94.37	17624.0
2018-03-06 09:30:00	MSFT	Stock	94.34	94.49	93.92	94.12	2678939.0
2018-03-06 10:00:00	MSFT	Stock	94.125	94.24	93.77	94.12	1170543.0
2018-03-06 10:30:00	MSFT	Stock	94.13	94.21	93.32	93.365	1344625.0
2018-03-06 11:00:00	MSFT	Stock	93.37	93.55	93.095	93.19	1176323.0
2018-03-06 11:30:00	MSFT	Stock	93.2	93.51	92.941	93.5	1004211.0
2018-03-06 12:00:00	MSFT	Stock	93.5	93.515	93.22	93.26	768924.0
2018-03-06 12:30:00	MSFT	Stock	93.27	93.63	93.215	93.62	953194.0
2018-03-06 13:00:00	MSFT	Stock	93.625	93.775	93.51	93.62	891641.0
2018-03-06 13:30:00	MSFT	Stock	93.63	93.69	93.2	93.275	784356.0
2018-03-06 14:00:00	MSFT	Stock	93.27	93.365	92.97	93.025	1271470.0
2018-03-06 14:30:00	MSFT	Stock	93.03	93.545	93.02	93.385	1164377.0
2018-03-06 15:00:00	MSFT	Stock	93.38	93.395	93.03	93.215	1062632.0

> showing 50 of 85,385 rows — these rows as CSV

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