PREVIEW / stock_30min / 2017-10-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-11.parquet
  size:    1.6 MB
  rows:    82,344
  symbols: 2,954

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-10-11 04:00:00	AAPL	Stock	38.945	38.945	38.945	38.945	796.0
2017-10-11 04:30:00	AAPL	Stock	38.9	38.925	38.9	38.925	6692.0
2017-10-11 05:00:00	AAPL	Stock	38.925	38.925	38.925	38.925	2000.0
2017-10-11 05:30:00	AAPL	Stock	38.945	38.945	38.945	38.945	800.0
2017-10-11 06:00:00	AAPL	Stock	38.955	38.955	38.95	38.95	800.0
2017-10-11 06:30:00	AAPL	Stock	38.95	38.95	38.9	38.9	42200.0
2017-10-11 07:00:00	AAPL	Stock	38.9375	38.97	38.9375	38.95	46724.0
2017-10-11 07:30:00	AAPL	Stock	38.95	38.95	38.9125	38.9125	17624.0
2017-10-11 08:00:00	AAPL	Stock	38.95	39.055	38.9125	38.945	79248.0
2017-10-11 08:30:00	AAPL	Stock	38.9675	39.0	38.95	38.9725	47496.0
2017-10-11 09:00:00	AAPL	Stock	38.9725	39.0175	38.965	38.965	80400.0
2017-10-11 09:30:00	AAPL	Stock	38.9925	39.08	38.9375	39.055	8276432.0
2017-10-11 10:00:00	AAPL	Stock	39.0575	39.245	39.05	39.1918	9202576.0
2017-10-11 10:30:00	AAPL	Stock	39.195	39.235	39.1225	39.1862	5184640.0
2017-10-11 11:00:00	AAPL	Stock	39.1868	39.2175	39.13	39.1475	4012256.0
2017-10-11 11:30:00	AAPL	Stock	39.145	39.19	39.13	39.1675	2445312.0
2017-10-11 12:00:00	AAPL	Stock	39.1675	39.1885	39.145	39.1825	2001980.0
2017-10-11 12:30:00	AAPL	Stock	39.1832	39.21	39.155	39.1725	2978908.0
2017-10-11 13:00:00	AAPL	Stock	39.17	39.2032	39.135	39.1535	2363744.0
2017-10-11 13:30:00	AAPL	Stock	39.1538	39.1715	39.11	39.11	2272576.0
2017-10-11 14:00:00	AAPL	Stock	39.1125	39.1875	39.0975	39.1375	2759888.0
2017-10-11 14:30:00	AAPL	Stock	39.1362	39.145	39.095	39.1275	2214812.0
2017-10-11 15:00:00	AAPL	Stock	39.13	39.1612	39.1185	39.1375	2795604.0
2017-10-11 15:30:00	AAPL	Stock	39.135	39.17	39.105	39.135	6216732.0
2017-10-11 16:00:00	AAPL	Stock	39.1375	39.1375	39.1075	39.1375	7843996.0
2017-10-11 16:30:00	AAPL	Stock	39.1375	39.145	39.1275	39.145	150972.0
2017-10-11 17:00:00	AAPL	Stock	39.1375	39.18	39.1375	39.1575	108728.0
2017-10-11 17:30:00	AAPL	Stock	39.1575	39.1575	39.1	39.125	115596.0
2017-10-11 18:00:00	AAPL	Stock	39.1125	39.1375	39.1075	39.1375	3600.0
2017-10-11 18:30:00	AAPL	Stock	39.1375	39.15	39.1175	39.1375	12624.0
2017-10-11 19:00:00	AAPL	Stock	39.1375	39.1375	39.1075	39.1375	12720.0
2017-10-11 19:30:00	AAPL	Stock	39.1	39.1325	39.1	39.1075	6576.0
2017-10-11 06:00:00	MSFT	Stock	76.38	76.38	76.38	76.38	100.0
2017-10-11 07:00:00	MSFT	Stock	76.32	76.33	76.32	76.32	8518.0
2017-10-11 07:30:00	MSFT	Stock	76.26	76.27	76.21	76.21	1599.0
2017-10-11 08:00:00	MSFT	Stock	76.23	76.23	76.23	76.23	1620.0
2017-10-11 09:00:00	MSFT	Stock	76.2	76.39	76.2	76.33	5040.0
2017-10-11 09:30:00	MSFT	Stock	76.36	76.42	75.96	75.99	1403234.0
2017-10-11 10:00:00	MSFT	Stock	75.99	76.25	75.95	76.17	1064432.0
2017-10-11 10:30:00	MSFT	Stock	76.17	76.25	76.075	76.08	714865.0
2017-10-11 11:00:00	MSFT	Stock	76.08	76.21	76.01	76.08	638215.0
2017-10-11 11:30:00	MSFT	Stock	76.08	76.17	76.08	76.16	518382.0
2017-10-11 12:00:00	MSFT	Stock	76.155	76.29	76.155	76.28	604719.0
2017-10-11 12:30:00	MSFT	Stock	76.28	76.29	76.15	76.16	534262.0
2017-10-11 13:00:00	MSFT	Stock	76.165	76.19	76.1	76.11	457738.0
2017-10-11 13:30:00	MSFT	Stock	76.115	76.26	76.09	76.195	676719.0
2017-10-11 14:00:00	MSFT	Stock	76.195	76.32	76.194	76.265	660927.0
2017-10-11 14:30:00	MSFT	Stock	76.27	76.29	76.19	76.22	461920.0
2017-10-11 15:00:00	MSFT	Stock	76.21	76.305	76.2	76.25	710500.0
2017-10-11 15:30:00	MSFT	Stock	76.25	76.46	76.25	76.41	1705106.0

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

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