PREVIEW / stock_30min / 2016-05-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-23.parquet
  size:    1.6 MB
  rows:    81,034
  symbols: 3,290

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-05-23 04:00:00	AAPL	Stock	23.875	23.975	23.875	23.975	26488.0
2016-05-23 04:30:00	AAPL	Stock	23.9525	23.9525	23.9425	23.9425	1900.0
2016-05-23 05:30:00	AAPL	Stock	23.9675	23.9675	23.915	23.915	8220.0
2016-05-23 06:00:00	AAPL	Stock	23.8875	23.9125	23.855	23.9125	37672.0
2016-05-23 06:30:00	AAPL	Stock	23.89	23.91	23.875	23.8925	19864.0
2016-05-23 07:00:00	AAPL	Stock	23.88	23.98	23.8775	23.975	151452.0
2016-05-23 07:30:00	AAPL	Stock	23.975	24.0475	23.9575	24.0175	279112.0
2016-05-23 08:00:00	AAPL	Stock	24.0175	24.025	23.8875	23.9625	328020.0
2016-05-23 08:30:00	AAPL	Stock	23.965	23.975	23.925	23.95	246532.0
2016-05-23 09:00:00	AAPL	Stock	23.95	24.0	23.925	23.975	495540.0
2016-05-23 09:30:00	AAPL	Stock	23.9675	24.225	23.9175	24.17	31184500.0
2016-05-23 10:00:00	AAPL	Stock	24.17	24.2875	24.1625	24.2375	16258476.0
2016-05-23 10:30:00	AAPL	Stock	24.2375	24.2975	24.2	24.24	10025428.0
2016-05-23 11:00:00	AAPL	Stock	24.2375	24.245	24.1775	24.2338	7675600.0
2016-05-23 11:30:00	AAPL	Stock	24.2325	24.245	24.1325	24.145	7318244.0
2016-05-23 12:00:00	AAPL	Stock	24.1475	24.1875	24.1375	24.154	4868188.0
2016-05-23 12:30:00	AAPL	Stock	24.155	24.2175	24.1178	24.2	5724784.0
2016-05-23 13:00:00	AAPL	Stock	24.201	24.225	24.175	24.2075	4541232.0
2016-05-23 13:30:00	AAPL	Stock	24.2075	24.2425	24.1675	24.2188	4230648.0
2016-05-23 14:00:00	AAPL	Stock	24.2198	24.2375	24.175	24.1925	4631788.0
2016-05-23 14:30:00	AAPL	Stock	24.1925	24.205	24.1375	24.1575	5084296.0
2016-05-23 15:00:00	AAPL	Stock	24.1575	24.175	24.1	24.1288	7926552.0
2016-05-23 15:30:00	AAPL	Stock	24.1275	24.175	24.08	24.105	14336080.0
2016-05-23 16:00:00	AAPL	Stock	24.1075	24.2087	24.095	24.095	12916308.0
2016-05-23 16:30:00	AAPL	Stock	24.105	24.1075	24.0975	24.1	47832.0
2016-05-23 17:00:00	AAPL	Stock	24.1	24.105	24.095	24.1	72128.0
2016-05-23 17:30:00	AAPL	Stock	24.095	24.1225	24.095	24.1225	18520.0
2016-05-23 18:00:00	AAPL	Stock	24.125	24.125	24.115	24.12	24028.0
2016-05-23 18:30:00	AAPL	Stock	24.1275	24.135	24.125	24.135	15720.0
2016-05-23 19:00:00	AAPL	Stock	24.135	24.1525	24.125	24.14	36564.0
2016-05-23 19:30:00	AAPL	Stock	24.14	24.15	24.1325	24.1375	61080.0
2016-05-23 04:00:00	MSFT	Stock	50.45	50.45	50.45	50.45	930.0
2016-05-23 05:30:00	MSFT	Stock	50.51	50.51	50.51	50.51	200.0
2016-05-23 07:00:00	MSFT	Stock	50.61	50.61	50.61	50.61	300.0
2016-05-23 08:00:00	MSFT	Stock	50.62	50.62	50.62	50.62	130.0
2016-05-23 08:30:00	MSFT	Stock	50.62	50.63	50.58	50.58	584.0
2016-05-23 09:00:00	MSFT	Stock	50.53	50.65	50.47	50.6	4379.0
2016-05-23 09:30:00	MSFT	Stock	50.6	50.68	50.33	50.47	2639359.0
2016-05-23 10:00:00	MSFT	Stock	50.465	50.55	50.26	50.275	1648143.0
2016-05-23 10:30:00	MSFT	Stock	50.27	50.4	50.18	50.2	1906222.0
2016-05-23 11:00:00	MSFT	Stock	50.2	50.33	50.17	50.31	1145319.0
2016-05-23 11:30:00	MSFT	Stock	50.31	50.32	50.17	50.22	1001402.0
2016-05-23 12:00:00	MSFT	Stock	50.22	50.25	50.181	50.214	803003.0
2016-05-23 12:30:00	MSFT	Stock	50.21	50.24	50.15	50.18	1190625.0
2016-05-23 13:00:00	MSFT	Stock	50.18	50.25	50.15	50.16	1386323.0
2016-05-23 13:30:00	MSFT	Stock	50.16	50.21	50.12	50.2	858725.0
2016-05-23 14:00:00	MSFT	Stock	50.2	50.28	50.19	50.19	1165477.0
2016-05-23 14:30:00	MSFT	Stock	50.19	50.26	50.18	50.195	1157103.0
2016-05-23 15:00:00	MSFT	Stock	50.195	50.22	50.11	50.14	1408869.0
2016-05-23 15:30:00	MSFT	Stock	50.14	50.16	49.98	50.03	3150587.0

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

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