PREVIEW / stock_30min / 2016-09-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-14.parquet
  size:    1.6 MB
  rows:    81,713
  symbols: 3,232

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-09-14 04:00:00	AAPL	Stock	27.05	27.1975	27.05	27.065	20180.0
2016-09-14 04:30:00	AAPL	Stock	27.11	27.11	27.0525	27.0525	11136.0
2016-09-14 05:00:00	AAPL	Stock	27.0725	27.0725	27.05	27.05	41484.0
2016-09-14 05:30:00	AAPL	Stock	27.05	27.05	27.0	27.0	1600.0
2016-09-14 06:00:00	AAPL	Stock	27.0375	27.09	26.9825	27.09	42644.0
2016-09-14 06:30:00	AAPL	Stock	27.095	27.1975	27.095	27.1625	131680.0
2016-09-14 07:00:00	AAPL	Stock	27.125	27.275	27.115	27.255	175764.0
2016-09-14 07:30:00	AAPL	Stock	27.2325	27.2375	27.1875	27.2375	112620.0
2016-09-14 08:00:00	AAPL	Stock	27.215	27.25	27.065	27.1875	873640.0
2016-09-14 08:30:00	AAPL	Stock	27.1825	27.22	27.16	27.17	373720.0
2016-09-14 09:00:00	AAPL	Stock	27.1625	27.2	27.12	27.1825	751752.0
2016-09-14 09:30:00	AAPL	Stock	27.1875	27.7425	27.15	27.7375	68463444.0
2016-09-14 10:00:00	AAPL	Stock	27.7388	27.8925	27.6625	27.7838	41578736.0
2016-09-14 10:30:00	AAPL	Stock	27.785	27.8525	27.7625	27.7962	23097176.0
2016-09-14 11:00:00	AAPL	Stock	27.7988	28.1025	27.7938	28.0575	39302804.0
2016-09-14 11:30:00	AAPL	Stock	28.06	28.1925	27.99	28.1592	26542316.0
2016-09-14 12:00:00	AAPL	Stock	28.1585	28.21	28.0775	28.145	19671524.0
2016-09-14 12:30:00	AAPL	Stock	28.145	28.2575	28.1138	28.1302	22912508.0
2016-09-14 13:00:00	AAPL	Stock	28.135	28.175	28.085	28.1548	13794020.0
2016-09-14 13:30:00	AAPL	Stock	28.155	28.1875	27.7375	27.89	47968624.0
2016-09-14 14:00:00	AAPL	Stock	27.895	28.1875	27.7875	28.0475	40506696.0
2016-09-14 14:30:00	AAPL	Stock	28.045	28.06	27.945	28.0522	17982972.0
2016-09-14 15:00:00	AAPL	Stock	28.0525	28.085	27.8475	27.85	20539936.0
2016-09-14 15:30:00	AAPL	Stock	27.85	27.9925	27.85	27.9425	25210544.0
2016-09-14 16:00:00	AAPL	Stock	27.94	28.1542	27.9	27.9225	11841592.0
2016-09-14 16:30:00	AAPL	Stock	27.9225	27.935	27.9125	27.935	105812.0
2016-09-14 17:00:00	AAPL	Stock	27.93	27.9475	27.9275	27.9375	472712.0
2016-09-14 17:30:00	AAPL	Stock	27.945	27.945	27.93	27.945	18600.0
2016-09-14 18:00:00	AAPL	Stock	27.945	27.9675	27.9375	27.9625	51328.0
2016-09-14 18:30:00	AAPL	Stock	27.96	27.9775	27.9525	27.97	63772.0
2016-09-14 19:00:00	AAPL	Stock	27.96	27.97	27.9375	27.97	68856.0
2016-09-14 19:30:00	AAPL	Stock	27.97	27.985	27.96	27.9775	40640.0
2016-09-14 05:30:00	MSFT	Stock	56.8	56.8	56.8	56.8	175.0
2016-09-14 07:30:00	MSFT	Stock	56.81	56.81	56.81	56.81	200.0
2016-09-14 08:30:00	MSFT	Stock	56.65	56.69	56.65	56.69	6600.0
2016-09-14 09:00:00	MSFT	Stock	56.69	56.69	56.42	56.42	6701.0
2016-09-14 09:30:00	MSFT	Stock	56.41	56.43	56.03	56.14	3041144.0
2016-09-14 10:00:00	MSFT	Stock	56.15	56.46	56.12	56.45	2003938.0
2016-09-14 10:30:00	MSFT	Stock	56.45	56.625	56.43	56.49	1753341.0
2016-09-14 11:00:00	MSFT	Stock	56.49	56.545	56.22	56.46	1387304.0
2016-09-14 11:30:00	MSFT	Stock	56.46	56.525	56.36	56.52	953741.0
2016-09-14 12:00:00	MSFT	Stock	56.52	56.63	56.51	56.585	820963.0
2016-09-14 12:30:00	MSFT	Stock	56.585	56.6	56.4	56.485	808814.0
2016-09-14 13:00:00	MSFT	Stock	56.48	56.52	56.37	56.48	656585.0
2016-09-14 13:30:00	MSFT	Stock	56.474	56.51	56.28	56.28	881386.0
2016-09-14 14:00:00	MSFT	Stock	56.28	56.351	56.141	56.26	1030782.0
2016-09-14 14:30:00	MSFT	Stock	56.25	56.39	56.2	56.34	1119632.0
2016-09-14 15:00:00	MSFT	Stock	56.34	56.37	56.04	56.06	2030191.0
2016-09-14 15:30:00	MSFT	Stock	56.05	56.339	56.05	56.26	3253076.0
2016-09-14 16:00:00	MSFT	Stock	56.26	56.29	56.07	56.07	2829214.0

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

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