PREVIEW / stock_30min / 2017-07-18

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-18.parquet
  size:    1.6 MB
  rows:    80,872
  symbols: 3,003

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
2017-07-18 04:00:00	AAPL	Stock	37.3775	37.3775	37.375	37.375	2024.0
2017-07-18 04:30:00	AAPL	Stock	37.375	37.375	37.375	37.375	6500.0
2017-07-18 05:30:00	AAPL	Stock	37.405	37.405	37.405	37.405	800.0
2017-07-18 06:00:00	AAPL	Stock	37.405	37.405	37.38	37.38	3880.0
2017-07-18 06:30:00	AAPL	Stock	37.375	37.375	37.35	37.35	9600.0
2017-07-18 07:00:00	AAPL	Stock	37.35	37.38	37.2875	37.3	75280.0
2017-07-18 07:30:00	AAPL	Stock	37.2925	37.295	37.275	37.275	23468.0
2017-07-18 08:00:00	AAPL	Stock	37.29	37.3725	37.2775	37.3325	94564.0
2017-07-18 08:30:00	AAPL	Stock	37.3325	37.3375	37.2	37.215	189484.0
2017-07-18 09:00:00	AAPL	Stock	37.205	37.365	37.2	37.3625	198476.0
2017-07-18 09:30:00	AAPL	Stock	37.36	37.36	37.18	37.2075	9768428.0
2017-07-18 10:00:00	AAPL	Stock	37.21	37.315	37.1675	37.31	5682100.0
2017-07-18 10:30:00	AAPL	Stock	37.31	37.335	37.175	37.31	5964732.0
2017-07-18 11:00:00	AAPL	Stock	37.3075	37.32	37.2525	37.2875	3173904.0
2017-07-18 11:30:00	AAPL	Stock	37.29	37.3675	37.29	37.32	3590272.0
2017-07-18 12:00:00	AAPL	Stock	37.32	37.3262	37.275	37.305	3214252.0
2017-07-18 12:30:00	AAPL	Stock	37.3	37.435	37.3	37.42	3204992.0
2017-07-18 13:00:00	AAPL	Stock	37.4162	37.4825	37.37	37.4738	2629660.0
2017-07-18 13:30:00	AAPL	Stock	37.4738	37.505	37.435	37.4685	3237996.0
2017-07-18 14:00:00	AAPL	Stock	37.4675	37.4725	37.37	37.3875	2683504.0
2017-07-18 14:30:00	AAPL	Stock	37.385	37.4525	37.375	37.405	3492456.0
2017-07-18 15:00:00	AAPL	Stock	37.405	37.465	37.4	37.4625	2815888.0
2017-07-18 15:30:00	AAPL	Stock	37.4645	37.5325	37.4275	37.52	8538136.0
2017-07-18 16:00:00	AAPL	Stock	37.52	37.535	37.51	37.515	4688732.0
2017-07-18 16:30:00	AAPL	Stock	37.52	37.55	37.515	37.5375	108404.0
2017-07-18 17:00:00	AAPL	Stock	37.5375	37.5625	37.52	37.52	13820.0
2017-07-18 17:30:00	AAPL	Stock	37.5025	37.525	37.5025	37.525	8604.0
2017-07-18 18:00:00	AAPL	Stock	37.52	37.52	37.5075	37.5075	4400.0
2017-07-18 18:30:00	AAPL	Stock	37.525	37.525	37.5075	37.52	34920.0
2017-07-18 19:00:00	AAPL	Stock	37.525	37.525	37.5225	37.525	17152.0
2017-07-18 19:30:00	AAPL	Stock	37.545	37.55	37.5375	37.545	9504.0
2017-07-18 04:00:00	MSFT	Stock	73.52	73.52	73.52	73.52	100.0
2017-07-18 06:00:00	MSFT	Stock	73.49	73.49	73.49	73.49	100.0
2017-07-18 06:30:00	MSFT	Stock	73.57	73.57	73.57	73.57	1076.0
2017-07-18 07:00:00	MSFT	Stock	73.57	73.62	73.55	73.55	1765.0
2017-07-18 07:30:00	MSFT	Stock	73.55	73.55	73.35	73.5	8476.0
2017-07-18 08:00:00	MSFT	Stock	73.5	73.56	73.4	73.44	22059.0
2017-07-18 08:30:00	MSFT	Stock	73.45	73.45	73.3	73.34	56676.0
2017-07-18 09:00:00	MSFT	Stock	73.35	73.4	73.08	73.11	43129.0
2017-07-18 09:30:00	MSFT	Stock	73.09	73.39	72.85	73.21	4386511.0
2017-07-18 10:00:00	MSFT	Stock	73.215	73.25	73.02	73.115	2005725.0
2017-07-18 10:30:00	MSFT	Stock	73.115	73.205	72.95	73.18	1724554.0
2017-07-18 11:00:00	MSFT	Stock	73.18	73.2	72.86	72.91	1902561.0
2017-07-18 11:30:00	MSFT	Stock	72.91	73.05	72.88	72.895	1371130.0
2017-07-18 12:00:00	MSFT	Stock	72.895	72.92	72.68	72.68	1259375.0
2017-07-18 12:30:00	MSFT	Stock	72.68	72.82	72.66	72.73	1122211.0
2017-07-18 13:00:00	MSFT	Stock	72.74	72.86	72.67	72.855	1208837.0
2017-07-18 13:30:00	MSFT	Stock	72.858	72.98	72.855	72.976	1040011.0
2017-07-18 14:00:00	MSFT	Stock	72.979	73.12	72.97	73.1	1011677.0
2017-07-18 14:30:00	MSFT	Stock	73.095	73.215	73.09	73.125	1053007.0

> showing 50 of 80,872 rows — these rows as CSV

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