PREVIEW / stock_30min / 2016-04-07

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-07.parquet
  size:    1.5 MB
  rows:    80,973
  symbols: 3,324

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
2016-04-07 04:00:00	AAPL	Stock	27.65	27.75	27.625	27.625	21600.0
2016-04-07 04:30:00	AAPL	Stock	27.625	27.625	27.625	27.625	3200.0
2016-04-07 05:00:00	AAPL	Stock	27.625	27.625	27.625	27.625	2800.0
2016-04-07 05:30:00	AAPL	Stock	27.625	27.6375	27.605	27.605	13944.0
2016-04-07 06:00:00	AAPL	Stock	27.605	27.65	27.605	27.65	9812.0
2016-04-07 06:30:00	AAPL	Stock	27.635	27.635	27.5975	27.5975	4708.0
2016-04-07 07:00:00	AAPL	Stock	27.6375	27.64	27.5625	27.57	84228.0
2016-04-07 07:30:00	AAPL	Stock	27.5625	27.5625	27.475	27.525	138092.0
2016-04-07 08:00:00	AAPL	Stock	27.5475	27.6225	27.5375	27.61	263888.0
2016-04-07 08:30:00	AAPL	Stock	27.6125	27.6275	27.5925	27.6225	235672.0
2016-04-07 09:00:00	AAPL	Stock	27.61	27.6225	27.485	27.49	554792.0
2016-04-07 09:30:00	AAPL	Stock	27.4875	27.5675	27.3875	27.48	17886540.0
2016-04-07 10:00:00	AAPL	Stock	27.4825	27.605	27.3825	27.3875	8255692.0
2016-04-07 10:30:00	AAPL	Stock	27.385	27.44	27.34	27.3415	7406176.0
2016-04-07 11:00:00	AAPL	Stock	27.34	27.3425	27.255	27.33	8086032.0
2016-04-07 11:30:00	AAPL	Stock	27.33	27.38	27.3225	27.34	4274096.0
2016-04-07 12:00:00	AAPL	Stock	27.34	27.4425	27.32	27.4025	6640424.0
2016-04-07 12:30:00	AAPL	Stock	27.4025	27.415	27.35	27.3675	2761676.0
2016-04-07 13:00:00	AAPL	Stock	27.3688	27.3925	27.3525	27.3635	2917476.0
2016-04-07 13:30:00	AAPL	Stock	27.365	27.38	27.2292	27.2452	6997064.0
2016-04-07 14:00:00	AAPL	Stock	27.245	27.2462	27.155	27.175	6987360.0
2016-04-07 14:30:00	AAPL	Stock	27.1742	27.2075	27.095	27.095	8501848.0
2016-04-07 15:00:00	AAPL	Stock	27.095	27.1725	27.0302	27.121	9113624.0
2016-04-07 15:30:00	AAPL	Stock	27.1225	27.195	27.085	27.135	12862908.0
2016-04-07 16:00:00	AAPL	Stock	27.135	27.1775	27.089	27.1425	8793332.0
2016-04-07 16:30:00	AAPL	Stock	27.1425	27.15	27.125	27.1375	46740.0
2016-04-07 17:00:00	AAPL	Stock	27.1475	27.175	27.14	27.175	35184.0
2016-04-07 17:30:00	AAPL	Stock	27.17	27.175	27.1425	27.1525	26052.0
2016-04-07 18:00:00	AAPL	Stock	27.155	27.155	27.135	27.1475	115080.0
2016-04-07 18:30:00	AAPL	Stock	27.135	27.135	27.1025	27.1125	25348.0
2016-04-07 19:00:00	AAPL	Stock	27.1125	27.1275	27.105	27.1275	25316.0
2016-04-07 19:30:00	AAPL	Stock	27.1225	27.13	27.0875	27.0975	40956.0
2016-04-07 07:30:00	MSFT	Stock	54.71	54.71	54.7	54.7	1500.0
2016-04-07 08:00:00	MSFT	Stock	54.87	54.87	54.85	54.85	500.0
2016-04-07 08:30:00	MSFT	Stock	54.85	54.86	54.84	54.86	800.0
2016-04-07 09:00:00	MSFT	Stock	54.85	54.85	54.6	54.6	10114.0
2016-04-07 09:30:00	MSFT	Stock	54.87	54.91	54.6	54.844	1786302.0
2016-04-07 10:00:00	MSFT	Stock	54.845	54.87	54.57	54.64	1355532.0
2016-04-07 10:30:00	MSFT	Stock	54.64	54.735	54.55	54.62	1156605.0
2016-04-07 11:00:00	MSFT	Stock	54.62	54.62	54.37	54.54	1129059.0
2016-04-07 11:30:00	MSFT	Stock	54.54	54.65	54.5	54.52	799941.0
2016-04-07 12:00:00	MSFT	Stock	54.523	54.54	54.33	54.41	732288.0
2016-04-07 12:30:00	MSFT	Stock	54.42	54.59	54.3	54.53	750970.0
2016-04-07 13:00:00	MSFT	Stock	54.53	54.65	54.52	54.57	438637.0
2016-04-07 13:30:00	MSFT	Stock	54.57	54.6	54.315	54.375	719424.0
2016-04-07 14:00:00	MSFT	Stock	54.37	54.41	54.23	54.41	1210493.0
2016-04-07 14:30:00	MSFT	Stock	54.4	54.47	54.245	54.29	1224609.0
2016-04-07 15:00:00	MSFT	Stock	54.28	54.43	54.245	54.375	1119871.0
2016-04-07 15:30:00	MSFT	Stock	54.38	54.51	54.325	54.45	2702363.0
2016-04-07 16:00:00	MSFT	Stock	54.44	54.55	54.44	54.55	2038329.0

> showing 50 of 80,973 rows — these rows as CSV

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