PREVIEW / stock_30min / 2015-06-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-05.parquet
  size:    1.6 MB
  rows:    81,338
  symbols: 3,469

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-05 04:00:00	AAPL	Stock	32.4075	32.45	32.375	32.3775	4528.0
2015-06-05 04:30:00	AAPL	Stock	32.4	32.4	32.3825	32.3825	800.0
2015-06-05 05:30:00	AAPL	Stock	32.3925	32.3925	32.3925	32.3925	3564.0
2015-06-05 06:00:00	AAPL	Stock	32.3675	32.3675	32.315	32.315	3600.0
2015-06-05 06:30:00	AAPL	Stock	32.2825	32.29	32.2825	32.29	12068.0
2015-06-05 07:00:00	AAPL	Stock	32.295	32.3275	32.2925	32.305	34688.0
2015-06-05 07:30:00	AAPL	Stock	32.3175	32.3675	32.3075	32.365	52180.0
2015-06-05 08:00:00	AAPL	Stock	32.365	32.405	32.295	32.39	304612.0
2015-06-05 08:30:00	AAPL	Stock	32.3875	32.4775	32.305	32.3925	861980.0
2015-06-05 09:00:00	AAPL	Stock	32.3825	32.4225	32.3525	32.3925	192168.0
2015-06-05 09:30:00	AAPL	Stock	32.375	32.4225	32.09	32.24	26242336.0
2015-06-05 10:00:00	AAPL	Stock	32.2412	32.37	32.2325	32.285	14019816.0
2015-06-05 10:30:00	AAPL	Stock	32.2825	32.36	32.2017	32.23	10709356.0
2015-06-05 11:00:00	AAPL	Stock	32.23	32.29	32.2125	32.2625	6530832.0
2015-06-05 11:30:00	AAPL	Stock	32.2675	32.28	32.1525	32.1825	7637388.0
2015-06-05 12:00:00	AAPL	Stock	32.18	32.195	32.1175	32.13	7284668.0
2015-06-05 12:30:00	AAPL	Stock	32.1275	32.225	32.0975	32.21	7601412.0
2015-06-05 13:00:00	AAPL	Stock	32.2075	32.2175	32.1625	32.2075	4690200.0
2015-06-05 13:30:00	AAPL	Stock	32.2075	32.2375	32.1425	32.185	6032164.0
2015-06-05 14:00:00	AAPL	Stock	32.1875	32.23	32.174	32.195	6495000.0
2015-06-05 14:30:00	AAPL	Stock	32.195	32.2265	32.165	32.2125	6009676.0
2015-06-05 15:00:00	AAPL	Stock	32.2125	32.225	32.15	32.165	7341500.0
2015-06-05 15:30:00	AAPL	Stock	32.165	32.21	32.15	32.1625	14251304.0
2015-06-05 16:00:00	AAPL	Stock	32.1625	32.23	32.1625	32.185	7443848.0
2015-06-05 16:30:00	AAPL	Stock	32.1825	32.185	32.1675	32.1725	197384.0
2015-06-05 17:00:00	AAPL	Stock	32.175	32.175	32.1525	32.1625	253224.0
2015-06-05 17:30:00	AAPL	Stock	32.1525	32.1725	32.15	32.15	68288.0
2015-06-05 18:00:00	AAPL	Stock	32.1675	32.17	32.1575	32.1675	13484.0
2015-06-05 18:30:00	AAPL	Stock	32.1675	32.17	32.125	32.1675	28888.0
2015-06-05 19:00:00	AAPL	Stock	32.17	32.1748	32.155	32.155	17792.0
2015-06-05 19:30:00	AAPL	Stock	32.1625	32.17	32.15	32.17	33776.0
2015-06-05 07:30:00	MSFT	Stock	46.48	46.48	46.48	46.48	375.0
2015-06-05 08:00:00	MSFT	Stock	46.55	46.55	46.39	46.44	8100.0
2015-06-05 08:30:00	MSFT	Stock	46.39	46.44	46.25	46.29	30805.0
2015-06-05 09:00:00	MSFT	Stock	46.28	46.349	46.26	46.349	4990.0
2015-06-05 09:30:00	MSFT	Stock	46.31	46.38	45.84	46.1	4062244.0
2015-06-05 10:00:00	MSFT	Stock	46.1	46.415	46.09	46.29	2186092.0
2015-06-05 10:30:00	MSFT	Stock	46.3	46.52	46.14	46.225	2126497.0
2015-06-05 11:00:00	MSFT	Stock	46.23	46.43	46.22	46.36	1212853.0
2015-06-05 11:30:00	MSFT	Stock	46.365	46.375	46.17	46.228	1081041.0
2015-06-05 12:00:00	MSFT	Stock	46.225	46.29	46.16	46.245	1117537.0
2015-06-05 12:30:00	MSFT	Stock	46.24	46.345	46.16	46.305	1055186.0
2015-06-05 13:00:00	MSFT	Stock	46.305	46.34	46.25	46.292	850472.0
2015-06-05 13:30:00	MSFT	Stock	46.3	46.31	46.19	46.19	981937.0
2015-06-05 14:00:00	MSFT	Stock	46.2	46.33	46.18	46.285	1247503.0
2015-06-05 14:30:00	MSFT	Stock	46.29	46.36	46.225	46.295	1370319.0
2015-06-05 15:00:00	MSFT	Stock	46.3	46.34	46.15	46.19	1446748.0
2015-06-05 15:30:00	MSFT	Stock	46.19	46.27	46.14	46.15	3609164.0
2015-06-05 16:00:00	MSFT	Stock	46.14	46.246	46.14	46.19	1975202.0
2015-06-05 16:30:00	MSFT	Stock	46.16	46.21	46.16	46.19	2550.0

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

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