PREVIEW / stock_30min / 2018-06-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-28.parquet
  size:    1.7 MB
  rows:    83,988
  symbols: 2,840

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-06-28 04:30:00	AAPL	Stock	46.1925	46.1925	46.1675	46.1675	14600.0
2018-06-28 05:30:00	AAPL	Stock	46.1875	46.1875	46.15	46.15	8868.0
2018-06-28 06:00:00	AAPL	Stock	46.15	46.1875	46.15	46.1875	3804.0
2018-06-28 06:30:00	AAPL	Stock	46.2475	46.2475	46.2475	46.2475	1908.0
2018-06-28 07:00:00	AAPL	Stock	46.2175	46.2425	46.1625	46.175	127272.0
2018-06-28 07:30:00	AAPL	Stock	46.2	46.24	46.1375	46.17	22720.0
2018-06-28 08:00:00	AAPL	Stock	46.22	46.2445	45.9125	45.975	128464.0
2018-06-28 08:30:00	AAPL	Stock	45.965	46.025	45.91	45.91	148172.0
2018-06-28 09:00:00	AAPL	Stock	45.91	46.0275	45.855	46.0075	322992.0
2018-06-28 09:30:00	AAPL	Stock	46.0225	46.2975	45.95	46.25	9443384.0
2018-06-28 10:00:00	AAPL	Stock	46.2575	46.3198	46.1275	46.195	5808548.0
2018-06-28 10:30:00	AAPL	Stock	46.1992	46.3922	46.0975	46.3675	5425304.0
2018-06-28 11:00:00	AAPL	Stock	46.365	46.415	46.1625	46.3125	4571340.0
2018-06-28 11:30:00	AAPL	Stock	46.3125	46.365	46.2225	46.295	2721060.0
2018-06-28 12:00:00	AAPL	Stock	46.2975	46.3075	46.15	46.165	3243452.0
2018-06-28 12:30:00	AAPL	Stock	46.1625	46.3125	46.1575	46.265	2493328.0
2018-06-28 13:00:00	AAPL	Stock	46.27	46.325	46.237	46.295	1913164.0
2018-06-28 13:30:00	AAPL	Stock	46.295	46.315	46.215	46.2675	2285144.0
2018-06-28 14:00:00	AAPL	Stock	46.2688	46.373	46.2375	46.3725	2200536.0
2018-06-28 14:30:00	AAPL	Stock	46.3725	46.49	46.3425	46.49	3059644.0
2018-06-28 15:00:00	AAPL	Stock	46.49	46.5525	46.43	46.5012	3374460.0
2018-06-28 15:30:00	AAPL	Stock	46.5025	46.5125	46.3175	46.3775	7526152.0
2018-06-28 16:00:00	AAPL	Stock	46.375	46.395	46.2925	46.3875	5886556.0
2018-06-28 16:30:00	AAPL	Stock	46.3875	46.4075	46.375	46.4075	47592.0
2018-06-28 17:00:00	AAPL	Stock	46.3925	46.4075	46.3925	46.4025	15112.0
2018-06-28 17:30:00	AAPL	Stock	46.4025	46.425	46.375	46.4225	6024.0
2018-06-28 18:00:00	AAPL	Stock	46.4225	46.45	46.3325	46.45	12868.0
2018-06-28 18:30:00	AAPL	Stock	46.45	46.45	46.3875	46.3875	5784.0
2018-06-28 19:00:00	AAPL	Stock	46.4	46.4	46.3725	46.375	4396.0
2018-06-28 19:30:00	AAPL	Stock	46.375	46.4375	46.375	46.4375	6024.0
2018-06-28 04:00:00	MSFT	Stock	98.17	98.17	98.17	98.17	300.0
2018-06-28 04:30:00	MSFT	Stock	98.17	98.38	98.0	98.38	2286.0
2018-06-28 05:30:00	MSFT	Stock	98.0	98.1	98.0	98.1	1614.0
2018-06-28 06:00:00	MSFT	Stock	97.97	97.97	97.97	97.97	500.0
2018-06-28 06:30:00	MSFT	Stock	98.05	98.2	98.05	98.2	600.0
2018-06-28 07:00:00	MSFT	Stock	98.04	98.04	97.85	98.04	1994.0
2018-06-28 07:30:00	MSFT	Stock	97.85	97.87	97.75	97.75	3455.0
2018-06-28 08:00:00	MSFT	Stock	98.03	98.1	97.25	97.37	19544.0
2018-06-28 08:30:00	MSFT	Stock	97.27	97.49	97.2	97.2	10437.0
2018-06-28 09:00:00	MSFT	Stock	97.2	97.42	97.2	97.37	11324.0
2018-06-28 09:30:00	MSFT	Stock	97.41	98.32	97.26	98.19	3460994.0
2018-06-28 10:00:00	MSFT	Stock	98.2	98.35	97.75	97.88	2117041.0
2018-06-28 10:30:00	MSFT	Stock	97.88	98.46	97.515	98.44	1859128.0
2018-06-28 11:00:00	MSFT	Stock	98.445	98.75	98.2	98.65	1869829.0
2018-06-28 11:30:00	MSFT	Stock	98.64	98.85	98.26	98.31	1480044.0
2018-06-28 12:00:00	MSFT	Stock	98.318	98.45	97.93	98.005	1079004.0
2018-06-28 12:30:00	MSFT	Stock	98.0	98.27	97.75	98.23	1066236.0
2018-06-28 13:00:00	MSFT	Stock	98.23	98.33	98.15	98.24	927897.0
2018-06-28 13:30:00	MSFT	Stock	98.235	98.49	98.2	98.42	844464.0
2018-06-28 14:00:00	MSFT	Stock	98.42	98.85	98.4	98.845	1150554.0

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

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