PREVIEW / stock_30min / 2017-09-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-11.parquet
  size:    1.6 MB
  rows:    82,577
  symbols: 2,972

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
2017-09-11 04:00:00	AAPL	Stock	40.1025	40.2	40.0875	40.175	42896.0
2017-09-11 04:30:00	AAPL	Stock	40.175	40.2225	40.175	40.2175	25352.0
2017-09-11 05:00:00	AAPL	Stock	40.2175	40.2225	40.2125	40.2125	14464.0
2017-09-11 05:30:00	AAPL	Stock	40.225	40.2575	40.2125	40.2575	25516.0
2017-09-11 06:00:00	AAPL	Stock	40.26	40.26	40.215	40.2375	38908.0
2017-09-11 06:30:00	AAPL	Stock	40.25	40.25	40.1525	40.175	86300.0
2017-09-11 07:00:00	AAPL	Stock	40.175	40.1875	40.115	40.1675	159580.0
2017-09-11 07:30:00	AAPL	Stock	40.1675	40.18	40.125	40.1625	104664.0
2017-09-11 08:00:00	AAPL	Stock	40.165	40.25	40.14	40.15	343072.0
2017-09-11 08:30:00	AAPL	Stock	40.145	40.145	40.1	40.1225	228992.0
2017-09-11 09:00:00	AAPL	Stock	40.1225	40.17	40.0925	40.125	496168.0
2017-09-11 09:30:00	AAPL	Stock	40.125	40.3725	39.9725	40.35	20661064.0
2017-09-11 10:00:00	AAPL	Stock	40.3475	40.5125	40.3475	40.48	12092828.0
2017-09-11 10:30:00	AAPL	Stock	40.4795	40.5	40.305	40.335	7534432.0
2017-09-11 11:00:00	AAPL	Stock	40.335	40.35	40.215	40.275	7529872.0
2017-09-11 11:30:00	AAPL	Stock	40.275	40.405	40.2725	40.395	5537372.0
2017-09-11 12:00:00	AAPL	Stock	40.395	40.435	40.3475	40.405	4011300.0
2017-09-11 12:30:00	AAPL	Stock	40.405	40.42	40.36	40.375	4878060.0
2017-09-11 13:00:00	AAPL	Stock	40.3775	40.405	40.345	40.35	3675260.0
2017-09-11 13:30:00	AAPL	Stock	40.35	40.3775	40.3075	40.3625	3882076.0
2017-09-11 14:00:00	AAPL	Stock	40.365	40.3725	40.3	40.3025	3897376.0
2017-09-11 14:30:00	AAPL	Stock	40.3025	40.3225	40.1775	40.29	6755392.0
2017-09-11 15:00:00	AAPL	Stock	40.29	40.3865	40.2525	40.3695	6346976.0
2017-09-11 15:30:00	AAPL	Stock	40.3713	40.375	40.295	40.3725	11570720.0
2017-09-11 16:00:00	AAPL	Stock	40.37	40.375	40.325	40.3625	11663252.0
2017-09-11 16:30:00	AAPL	Stock	40.3525	40.375	40.34	40.3575	349000.0
2017-09-11 17:00:00	AAPL	Stock	40.3575	40.3875	40.35	40.3875	1309192.0
2017-09-11 17:30:00	AAPL	Stock	40.3825	40.385	40.3675	40.3675	49060.0
2017-09-11 18:00:00	AAPL	Stock	40.3675	40.3825	40.365	40.37	23640.0
2017-09-11 18:30:00	AAPL	Stock	40.3775	40.3875	40.365	40.37	54856.0
2017-09-11 19:00:00	AAPL	Stock	40.37	40.39	40.3675	40.3875	41328.0
2017-09-11 19:30:00	AAPL	Stock	40.3975	40.4225	40.395	40.415	45232.0
2017-09-11 04:00:00	MSFT	Stock	74.4	74.4	74.4	74.4	100.0
2017-09-11 05:00:00	MSFT	Stock	74.68	74.68	74.68	74.68	100.0
2017-09-11 05:30:00	MSFT	Stock	74.4	74.4	74.4	74.4	800.0
2017-09-11 06:30:00	MSFT	Stock	74.48	74.48	74.48	74.48	100.0
2017-09-11 07:00:00	MSFT	Stock	74.45	74.45	74.45	74.45	294.0
2017-09-11 08:00:00	MSFT	Stock	74.48	74.49	74.4	74.41	1889.0
2017-09-11 08:30:00	MSFT	Stock	74.44	74.49	74.44	74.49	3884.0
2017-09-11 09:00:00	MSFT	Stock	74.45	74.55	74.41	74.41	10052.0
2017-09-11 09:30:00	MSFT	Stock	74.31	74.89	74.31	74.829	2247467.0
2017-09-11 10:00:00	MSFT	Stock	74.82	74.945	74.82	74.905	1373490.0
2017-09-11 10:30:00	MSFT	Stock	74.905	74.93	74.56	74.58	814183.0
2017-09-11 11:00:00	MSFT	Stock	74.584	74.675	74.555	74.64	813890.0
2017-09-11 11:30:00	MSFT	Stock	74.645	74.69	74.6	74.635	657809.0
2017-09-11 12:00:00	MSFT	Stock	74.635	74.76	74.62	74.66	830174.0
2017-09-11 12:30:00	MSFT	Stock	74.655	74.71	74.615	74.69	716996.0
2017-09-11 13:00:00	MSFT	Stock	74.7	74.74	74.66	74.725	525040.0
2017-09-11 13:30:00	MSFT	Stock	74.728	74.76	74.715	74.73	507225.0
2017-09-11 14:00:00	MSFT	Stock	74.73	74.775	74.64	74.65	597927.0

> showing 50 of 82,577 rows — these rows as CSV

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