PREVIEW / stock_30min / 2016-09-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-20.parquet
  size:    1.5 MB
  rows:    80,223
  symbols: 3,216

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-20 04:00:00	AAPL	Stock	28.395	28.395	28.3575	28.37	2000.0
2016-09-20 05:00:00	AAPL	Stock	28.3325	28.3325	28.2925	28.2925	5480.0
2016-09-20 05:30:00	AAPL	Stock	28.32	28.3325	28.32	28.3275	8116.0
2016-09-20 06:00:00	AAPL	Stock	28.37	28.37	28.37	28.37	400.0
2016-09-20 06:30:00	AAPL	Stock	28.3475	28.47	28.345	28.375	40440.0
2016-09-20 07:00:00	AAPL	Stock	28.35	28.4275	28.35	28.365	36080.0
2016-09-20 07:30:00	AAPL	Stock	28.365	28.365	28.2575	28.2575	181468.0
2016-09-20 08:00:00	AAPL	Stock	28.275	28.4275	28.2575	28.3	247100.0
2016-09-20 08:30:00	AAPL	Stock	28.31	28.325	28.265	28.275	274876.0
2016-09-20 09:00:00	AAPL	Stock	28.2725	28.3	28.2375	28.2475	499504.0
2016-09-20 09:30:00	AAPL	Stock	28.24	28.4875	28.1275	28.4725	33573472.0
2016-09-20 10:00:00	AAPL	Stock	28.4712	28.51	28.33	28.455	14467804.0
2016-09-20 10:30:00	AAPL	Stock	28.455	28.49	28.3868	28.4475	8693648.0
2016-09-20 11:00:00	AAPL	Stock	28.4475	28.53	28.44	28.465	8301904.0
2016-09-20 11:30:00	AAPL	Stock	28.4675	28.485	28.426	28.45	6051712.0
2016-09-20 12:00:00	AAPL	Stock	28.45	28.46	28.4	28.46	3799760.0
2016-09-20 12:30:00	AAPL	Stock	28.4598	28.4598	28.345	28.3515	5610024.0
2016-09-20 13:00:00	AAPL	Stock	28.3505	28.365	28.295	28.342	6145428.0
2016-09-20 13:30:00	AAPL	Stock	28.341	28.385	28.328	28.3725	4652608.0
2016-09-20 14:00:00	AAPL	Stock	28.3725	28.4238	28.36	28.4088	4815768.0
2016-09-20 14:30:00	AAPL	Stock	28.4075	28.4825	28.3925	28.4675	6176460.0
2016-09-20 15:00:00	AAPL	Stock	28.4675	28.485	28.44	28.4762	5894324.0
2016-09-20 15:30:00	AAPL	Stock	28.4775	28.485	28.3925	28.3925	11163216.0
2016-09-20 16:00:00	AAPL	Stock	28.3925	28.4	28.3625	28.3925	6635992.0
2016-09-20 16:30:00	AAPL	Stock	28.355	28.3925	28.35	28.3575	213272.0
2016-09-20 17:00:00	AAPL	Stock	28.3575	28.3875	28.3575	28.3875	3936.0
2016-09-20 17:30:00	AAPL	Stock	28.37	28.38	28.3675	28.3675	2884.0
2016-09-20 18:00:00	AAPL	Stock	28.3825	28.4	28.3675	28.4	26156.0
2016-09-20 18:30:00	AAPL	Stock	28.3975	28.4125	28.395	28.395	5560.0
2016-09-20 19:00:00	AAPL	Stock	28.4125	28.4225	28.4125	28.4175	17356.0
2016-09-20 19:30:00	AAPL	Stock	28.4175	28.42	28.4125	28.4125	8752.0
2016-09-20 08:00:00	MSFT	Stock	57.12	57.18	57.12	57.17	2450.0
2016-09-20 08:30:00	MSFT	Stock	57.17	57.17	57.17	57.17	685.0
2016-09-20 09:00:00	MSFT	Stock	57.18	57.24	57.18	57.24	4170.0
2016-09-20 09:30:00	MSFT	Stock	57.25	57.35	57.1	57.18	2039003.0
2016-09-20 10:00:00	MSFT	Stock	57.185	57.22	56.91	57.02	1662108.0
2016-09-20 10:30:00	MSFT	Stock	57.02	57.02	56.79	56.94	1306740.0
2016-09-20 11:00:00	MSFT	Stock	56.93	56.99	56.79	56.82	951622.0
2016-09-20 11:30:00	MSFT	Stock	56.82	56.88	56.79	56.81	897304.0
2016-09-20 12:00:00	MSFT	Stock	56.81	56.96	56.79	56.94	659854.0
2016-09-20 12:30:00	MSFT	Stock	56.94	56.94	56.75	56.775	832835.0
2016-09-20 13:00:00	MSFT	Stock	56.775	56.87	56.75	56.84	560399.0
2016-09-20 13:30:00	MSFT	Stock	56.845	56.97	56.81	56.94	712586.0
2016-09-20 14:00:00	MSFT	Stock	56.94	56.99	56.9	56.92	661124.0
2016-09-20 14:30:00	MSFT	Stock	56.92	57.0	56.9	56.95	683891.0
2016-09-20 15:00:00	MSFT	Stock	56.95	57.02	56.91	56.965	1313138.0
2016-09-20 15:30:00	MSFT	Stock	56.97	56.98	56.81	56.82	1992828.0
2016-09-20 16:00:00	MSFT	Stock	56.81	57.92	56.81	57.42	1628727.0
2016-09-20 16:30:00	MSFT	Stock	57.44	57.5	56.81	57.31	386221.0
2016-09-20 17:00:00	MSFT	Stock	57.36	57.49	57.32	57.49	24784.0

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

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