PREVIEW / stock_30min / 2018-04-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-04-05.parquet
  size:    1.6 MB
  rows:    83,194
  symbols: 2,845

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-04-05 04:00:00	AAPL	Stock	43.2525	43.2525	43.1375	43.1375	23336.0
2018-04-05 04:30:00	AAPL	Stock	43.13	43.13	43.13	43.13	800.0
2018-04-05 05:30:00	AAPL	Stock	43.145	43.15	43.11	43.15	28424.0
2018-04-05 06:00:00	AAPL	Stock	43.1475	43.15	43.1	43.15	18940.0
2018-04-05 06:30:00	AAPL	Stock	43.1375	43.15	43.125	43.15	4212.0
2018-04-05 07:00:00	AAPL	Stock	43.1225	43.295	43.1225	43.295	122404.0
2018-04-05 07:30:00	AAPL	Stock	43.2975	43.3	43.1825	43.21	107488.0
2018-04-05 08:00:00	AAPL	Stock	43.12	43.28	43.12	43.15	216064.0
2018-04-05 08:30:00	AAPL	Stock	43.15	43.2575	43.1375	43.245	196584.0
2018-04-05 09:00:00	AAPL	Stock	43.2375	43.25	43.1075	43.15	193096.0
2018-04-05 09:30:00	AAPL	Stock	43.145	43.39	43.02	43.2475	16126828.0
2018-04-05 10:00:00	AAPL	Stock	43.245	43.2575	43.085	43.1925	7497104.0
2018-04-05 10:30:00	AAPL	Stock	43.19	43.2725	43.115	43.2275	5456028.0
2018-04-05 11:00:00	AAPL	Stock	43.2325	43.4675	43.2175	43.4325	6783764.0
2018-04-05 11:30:00	AAPL	Stock	43.4295	43.5475	43.4078	43.539	6622116.0
2018-04-05 12:00:00	AAPL	Stock	43.5405	43.5575	43.29	43.345	5294344.0
2018-04-05 12:30:00	AAPL	Stock	43.345	43.46	43.2625	43.4525	3837848.0
2018-04-05 13:00:00	AAPL	Stock	43.4525	43.515	43.1625	43.2435	4373944.0
2018-04-05 13:30:00	AAPL	Stock	43.2425	43.345	43.115	43.295	5128588.0
2018-04-05 14:00:00	AAPL	Stock	43.2975	43.4225	43.2625	43.34	3946224.0
2018-04-05 14:30:00	AAPL	Stock	43.3388	43.5075	43.3388	43.5025	4201880.0
2018-04-05 15:00:00	AAPL	Stock	43.505	43.55	43.3875	43.439	4776824.0
2018-04-05 15:30:00	AAPL	Stock	43.44	43.4525	43.1675	43.195	11162312.0
2018-04-05 16:00:00	AAPL	Stock	43.2	43.2425	43.1875	43.19	9623044.0
2018-04-05 16:30:00	AAPL	Stock	43.19	43.205	43.1875	43.1875	150768.0
2018-04-05 17:00:00	AAPL	Stock	43.1875	43.205	43.1875	43.205	13680.0
2018-04-05 17:30:00	AAPL	Stock	43.2	43.2	43.1875	43.2	9384.0
2018-04-05 18:00:00	AAPL	Stock	43.1875	43.2	43.1875	43.2	5768.0
2018-04-05 18:30:00	AAPL	Stock	43.185	43.185	42.85	42.85	85732.0
2018-04-05 19:00:00	AAPL	Stock	42.8375	42.8375	42.3075	42.3625	193844.0
2018-04-05 19:30:00	AAPL	Stock	42.3625	42.45	42.2975	42.3975	204372.0
2018-04-05 04:00:00	MSFT	Stock	93.0	93.0	93.0	93.0	200.0
2018-04-05 04:30:00	MSFT	Stock	92.6	92.7	92.52	92.7	4589.0
2018-04-05 05:00:00	MSFT	Stock	92.7	92.7	92.7	92.7	360.0
2018-04-05 05:30:00	MSFT	Stock	92.74	92.74	92.74	92.74	1676.0
2018-04-05 06:30:00	MSFT	Stock	92.56	92.74	92.5	92.74	2275.0
2018-04-05 07:00:00	MSFT	Stock	92.74	93.0	92.67	93.0	14260.0
2018-04-05 07:30:00	MSFT	Stock	92.85	92.85	92.75	92.83	12574.0
2018-04-05 08:00:00	MSFT	Stock	92.85	93.0	92.55	92.93	22525.0
2018-04-05 08:30:00	MSFT	Stock	92.85	92.93	92.65	92.93	21212.0
2018-04-05 09:00:00	MSFT	Stock	92.9	92.9	92.47	92.56	40877.0
2018-04-05 09:30:00	MSFT	Stock	92.63	92.83	92.02	92.4	3349142.0
2018-04-05 10:00:00	MSFT	Stock	92.4	92.58	92.05	92.25	1661744.0
2018-04-05 10:30:00	MSFT	Stock	92.25	92.53	92.15	92.335	1464346.0
2018-04-05 11:00:00	MSFT	Stock	92.35	92.98	92.34	92.845	1537100.0
2018-04-05 11:30:00	MSFT	Stock	92.85	93.065	92.57	92.79	1307214.0
2018-04-05 12:00:00	MSFT	Stock	92.79	92.845	92.24	92.38	1417097.0
2018-04-05 12:30:00	MSFT	Stock	92.38	92.5	92.18	92.47	1065174.0
2018-04-05 13:00:00	MSFT	Stock	92.48	92.6	91.58	91.73	1538241.0
2018-04-05 13:30:00	MSFT	Stock	91.72	91.98	91.4	91.85	1937832.0

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

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