PREVIEW / stock_30min / 2015-11-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-05.parquet
  size:    1.6 MB
  rows:    82,114
  symbols: 3,406

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
2015-11-05 04:00:00	AAPL	Stock	30.4575	30.46	30.4	30.4	4240.0
2015-11-05 04:30:00	AAPL	Stock	30.4025	30.4025	30.3875	30.3875	5000.0
2015-11-05 05:00:00	AAPL	Stock	30.3875	30.3875	30.3625	30.3875	16128.0
2015-11-05 05:30:00	AAPL	Stock	30.41	30.4975	30.41	30.4975	19656.0
2015-11-05 06:00:00	AAPL	Stock	30.45	30.485	30.45	30.475	29076.0
2015-11-05 06:30:00	AAPL	Stock	30.4725	30.5225	30.4725	30.49	36032.0
2015-11-05 07:00:00	AAPL	Stock	30.4825	30.4825	30.4075	30.42	136260.0
2015-11-05 07:30:00	AAPL	Stock	30.415	30.465	30.39	30.425	287244.0
2015-11-05 08:00:00	AAPL	Stock	30.425	30.5125	30.4025	30.5	470220.0
2015-11-05 08:30:00	AAPL	Stock	30.4775	30.5	30.4425	30.455	276204.0
2015-11-05 09:00:00	AAPL	Stock	30.46	30.505	30.4225	30.495	440032.0
2015-11-05 09:30:00	AAPL	Stock	30.4625	30.6725	30.445	30.6138	22848076.0
2015-11-05 10:00:00	AAPL	Stock	30.615	30.66	30.2775	30.282	18450808.0
2015-11-05 10:30:00	AAPL	Stock	30.2798	30.35	30.195	30.2775	14301184.0
2015-11-05 11:00:00	AAPL	Stock	30.275	30.3225	30.2375	30.2628	7694996.0
2015-11-05 11:30:00	AAPL	Stock	30.265	30.295	30.205	30.2325	8317688.0
2015-11-05 12:00:00	AAPL	Stock	30.2325	30.233	30.045	30.1415	11957200.0
2015-11-05 12:30:00	AAPL	Stock	30.1425	30.205	30.12	30.1975	6381184.0
2015-11-05 13:00:00	AAPL	Stock	30.1965	30.24	30.1475	30.1725	5514460.0
2015-11-05 13:30:00	AAPL	Stock	30.175	30.2625	30.1625	30.1775	5371724.0
2015-11-05 14:00:00	AAPL	Stock	30.1775	30.22	30.1	30.12	5653452.0
2015-11-05 14:30:00	AAPL	Stock	30.12	30.1408	30.0625	30.11	6881132.0
2015-11-05 15:00:00	AAPL	Stock	30.11	30.2125	30.0775	30.195	6934396.0
2015-11-05 15:30:00	AAPL	Stock	30.195	30.25	30.17	30.2275	13190896.0
2015-11-05 16:00:00	AAPL	Stock	30.23	30.3725	30.205	30.35	9805860.0
2015-11-05 16:30:00	AAPL	Stock	30.3575	30.3625	30.315	30.326	664500.0
2015-11-05 17:00:00	AAPL	Stock	30.326	30.3425	30.325	30.3425	52316.0
2015-11-05 17:30:00	AAPL	Stock	30.336	30.3415	30.325	30.325	64196.0
2015-11-05 18:00:00	AAPL	Stock	30.325	30.339	30.325	30.3375	73144.0
2015-11-05 18:30:00	AAPL	Stock	30.34	30.3425	30.3325	30.3375	40788.0
2015-11-05 19:00:00	AAPL	Stock	30.3375	30.34	30.3275	30.34	30000.0
2015-11-05 19:30:00	AAPL	Stock	30.3275	30.3425	30.3275	30.3275	25720.0
2015-11-05 04:30:00	MSFT	Stock	54.4	54.4	54.4	54.4	100.0
2015-11-05 05:00:00	MSFT	Stock	54.4	54.4	54.35	54.35	2300.0
2015-11-05 05:30:00	MSFT	Stock	54.4	54.4	54.4	54.4	1200.0
2015-11-05 06:00:00	MSFT	Stock	54.4	54.4	54.39	54.39	2000.0
2015-11-05 06:30:00	MSFT	Stock	54.39	54.4	54.39	54.4	300.0
2015-11-05 07:00:00	MSFT	Stock	54.44	54.48	54.44	54.48	1888.0
2015-11-05 08:00:00	MSFT	Stock	54.45	54.49	54.4	54.4	8104.0
2015-11-05 08:30:00	MSFT	Stock	54.43	54.47	54.4	54.41	1927.0
2015-11-05 09:00:00	MSFT	Stock	54.39	54.65	54.34	54.62	27375.0
2015-11-05 09:30:00	MSFT	Stock	54.49	54.7	54.32	54.4	3645233.0
2015-11-05 10:00:00	MSFT	Stock	54.4	54.41	54.13	54.25	3494914.0
2015-11-05 10:30:00	MSFT	Stock	54.25	54.29	54.04	54.04	2301760.0
2015-11-05 11:00:00	MSFT	Stock	54.05	54.24	54.0	54.17	1610664.0
2015-11-05 11:30:00	MSFT	Stock	54.18	54.325	54.14	54.3	1126494.0
2015-11-05 12:00:00	MSFT	Stock	54.31	54.41	54.24	54.39	1304960.0
2015-11-05 12:30:00	MSFT	Stock	54.39	54.46	54.285	54.43	1835270.0
2015-11-05 13:00:00	MSFT	Stock	54.43	54.45	54.34	54.37	1355277.0
2015-11-05 13:30:00	MSFT	Stock	54.37	54.471	54.33	54.415	979198.0

> showing 50 of 82,114 rows — these rows as CSV

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