PREVIEW / stock_30min / 2015-06-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-02.parquet
  size:    1.6 MB
  rows:    81,924
  symbols: 3,480

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-06-02 04:00:00	AAPL	Stock	32.6025	32.6175	32.525	32.525	15296.0
2015-06-02 04:30:00	AAPL	Stock	32.5325	32.5375	32.32	32.32	63328.0
2015-06-02 05:00:00	AAPL	Stock	32.375	32.4425	32.3725	32.4375	37044.0
2015-06-02 05:30:00	AAPL	Stock	32.46	32.5075	32.46	32.5	44408.0
2015-06-02 06:00:00	AAPL	Stock	32.5025	32.69	32.5	32.625	60888.0
2015-06-02 06:30:00	AAPL	Stock	32.65	32.69	32.5925	32.5925	17804.0
2015-06-02 07:00:00	AAPL	Stock	32.6125	32.625	32.5	32.5625	100564.0
2015-06-02 07:30:00	AAPL	Stock	32.535	32.6175	32.53	32.605	110352.0
2015-06-02 08:00:00	AAPL	Stock	32.61	32.6375	32.4975	32.5325	373192.0
2015-06-02 08:30:00	AAPL	Stock	32.5375	32.5925	32.5325	32.59	105512.0
2015-06-02 09:00:00	AAPL	Stock	32.5875	32.59	32.465	32.4775	409564.0
2015-06-02 09:30:00	AAPL	Stock	32.465	32.6075	32.33	32.4275	25261004.0
2015-06-02 10:00:00	AAPL	Stock	32.4275	32.52	32.38	32.465	12414616.0
2015-06-02 10:30:00	AAPL	Stock	32.465	32.6	32.4525	32.5075	9159340.0
2015-06-02 11:00:00	AAPL	Stock	32.51	32.56	32.46	32.4625	7240612.0
2015-06-02 11:30:00	AAPL	Stock	32.4625	32.5225	32.445	32.5175	6007360.0
2015-06-02 12:00:00	AAPL	Stock	32.515	32.585	32.5025	32.5215	7721452.0
2015-06-02 12:30:00	AAPL	Stock	32.5225	32.5975	32.51	32.5775	6438060.0
2015-06-02 13:00:00	AAPL	Stock	32.5775	32.6275	32.5628	32.605	6566240.0
2015-06-02 13:30:00	AAPL	Stock	32.6042	32.6625	32.585	32.645	6091356.0
2015-06-02 14:00:00	AAPL	Stock	32.6428	32.6638	32.56	32.57	7150816.0
2015-06-02 14:30:00	AAPL	Stock	32.57	32.6	32.475	32.5125	8490456.0
2015-06-02 15:00:00	AAPL	Stock	32.5125	32.5225	32.4525	32.49	7569148.0
2015-06-02 15:30:00	AAPL	Stock	32.49	32.5235	32.4525	32.49	11130748.0
2015-06-02 16:00:00	AAPL	Stock	32.49	32.526	32.4775	32.495	4145644.0
2015-06-02 16:30:00	AAPL	Stock	32.495	32.505	32.495	32.5025	81296.0
2015-06-02 17:00:00	AAPL	Stock	32.505	32.505	32.49	32.5	97028.0
2015-06-02 17:30:00	AAPL	Stock	32.4975	32.5025	32.495	32.5	26936.0
2015-06-02 18:00:00	AAPL	Stock	32.5	32.505	32.5	32.5025	28864.0
2015-06-02 18:30:00	AAPL	Stock	32.5	32.5075	32.5	32.505	12444.0
2015-06-02 19:00:00	AAPL	Stock	32.5025	32.51	32.495	32.5075	59796.0
2015-06-02 19:30:00	AAPL	Stock	32.5075	32.5225	32.505	32.5175	52156.0
2015-06-02 04:00:00	MSFT	Stock	47.16	47.16	47.05	47.05	517.0
2015-06-02 06:00:00	MSFT	Stock	47.26	47.26	47.26	47.26	100.0
2015-06-02 06:30:00	MSFT	Stock	47.3	47.3	47.3	47.3	200.0
2015-06-02 07:30:00	MSFT	Stock	47.23	47.23	47.23	47.23	486.0
2015-06-02 08:00:00	MSFT	Stock	47.3	47.3	47.051	47.2	900.0
2015-06-02 08:30:00	MSFT	Stock	47.22	47.22	47.2	47.2	1560.0
2015-06-02 09:00:00	MSFT	Stock	47.17	47.17	46.9	46.9	21928.0
2015-06-02 09:30:00	MSFT	Stock	46.93	47.13	46.62	46.82	2884496.0
2015-06-02 10:00:00	MSFT	Stock	46.83	47.1	46.79	46.96	1623836.0
2015-06-02 10:30:00	MSFT	Stock	46.95	47.2	46.91	47.115	1385760.0
2015-06-02 11:00:00	MSFT	Stock	47.11	47.16	46.93	46.94	1064659.0
2015-06-02 11:30:00	MSFT	Stock	46.93	47.0	46.91	46.97	614697.0
2015-06-02 12:00:00	MSFT	Stock	46.975	47.22	46.96	47.08	843657.0
2015-06-02 12:30:00	MSFT	Stock	47.08	47.25	47.04	47.21	849110.0
2015-06-02 13:00:00	MSFT	Stock	47.2	47.35	47.14	47.181	1060107.0
2015-06-02 13:30:00	MSFT	Stock	47.18	47.27	47.145	47.24	743384.0
2015-06-02 14:00:00	MSFT	Stock	47.24	47.29	47.08	47.15	868665.0
2015-06-02 14:30:00	MSFT	Stock	47.145	47.16	47.02	47.125	788179.0

> showing 50 of 81,924 rows — these rows as CSV

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