PREVIEW / stock_30min / 2014-05-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-01.parquet
  size:    1.6 MB
  rows:    83,619
  symbols: 3,540

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
2014-05-01 06:30:00	AAPL	Stock	21.0757	21.0757	21.0757	21.0757	7392.0
2014-05-01 07:00:00	AAPL	Stock	21.1404	21.1632	21.1404	21.1429	33012.0
2014-05-01 07:30:00	AAPL	Stock	21.1429	21.1429	21.1071	21.14	175588.0
2014-05-01 08:00:00	AAPL	Stock	21.1371	21.1857	21.1314	21.1693	758268.0
2014-05-01 08:30:00	AAPL	Stock	21.1607	21.1786	21.1429	21.1571	344260.0
2014-05-01 09:00:00	AAPL	Stock	21.1589	21.1739	21.1179	21.1429	954464.0
2014-05-01 09:30:00	AAPL	Stock	21.145	21.23	21.0807	21.1429	37708524.0
2014-05-01 10:00:00	AAPL	Stock	21.1418	21.2429	21.1075	21.2218	20651512.0
2014-05-01 10:30:00	AAPL	Stock	21.2196	21.2386	21.1893	21.2114	12477640.0
2014-05-01 11:00:00	AAPL	Stock	21.2143	21.2354	21.1075	21.1243	11218984.0
2014-05-01 11:30:00	AAPL	Stock	21.1179	21.1582	21.01	21.04	20199676.0
2014-05-01 12:00:00	AAPL	Stock	21.04	21.0632	20.9414	20.9796	13526772.0
2014-05-01 12:30:00	AAPL	Stock	20.98	21.0511	20.9554	21.0468	9783564.0
2014-05-01 13:00:00	AAPL	Stock	21.045	21.0518	20.9954	21.0236	5402712.0
2014-05-01 13:30:00	AAPL	Stock	21.0282	21.1696	21.0236	21.104	14421596.0
2014-05-01 14:00:00	AAPL	Stock	21.1054	21.1454	21.0929	21.1289	7288680.0
2014-05-01 14:30:00	AAPL	Stock	21.1291	21.1579	21.1121	21.1286	8669332.0
2014-05-01 15:00:00	AAPL	Stock	21.1293	21.1357	21.0568	21.0607	9013032.0
2014-05-01 15:30:00	AAPL	Stock	21.0561	21.1246	21.0411	21.12	15363936.0
2014-05-01 16:00:00	AAPL	Stock	21.12	21.2429	21.0982	21.0982	6871956.0
2014-05-01 16:30:00	AAPL	Stock	21.1243	21.1243	21.0739	21.0739	353444.0
2014-05-01 17:00:00	AAPL	Stock	21.1143	21.1214	21.1143	21.1214	82880.0
2014-05-01 17:30:00	AAPL	Stock	21.1207	21.1329	21.1107	21.125	130704.0
2014-05-01 18:00:00	AAPL	Stock	21.1232	21.1232	21.1232	21.1232	11200.0
2014-05-01 18:30:00	AAPL	Stock	21.1232	21.1232	21.1232	21.1232	2800.0
2014-05-01 19:00:00	AAPL	Stock	21.1157	21.1214	21.1129	21.1132	16884.0
2014-05-01 19:30:00	AAPL	Stock	21.1132	21.1196	21.1089	21.1089	81872.0
2014-05-01 08:00:00	MSFT	Stock	40.5	40.5	40.39	40.4	14800.0
2014-05-01 08:30:00	MSFT	Stock	40.4	40.4	40.3	40.31	5085.0
2014-05-01 09:00:00	MSFT	Stock	40.4	40.4	40.2	40.25	23404.0
2014-05-01 09:30:00	MSFT	Stock	40.25	40.36	40.17	40.19	3143632.0
2014-05-01 10:00:00	MSFT	Stock	40.19	40.23	40.07	40.18	2431938.0
2014-05-01 10:30:00	MSFT	Stock	40.175	40.18	40.08	40.085	1906987.0
2014-05-01 11:00:00	MSFT	Stock	40.09	40.15	40.07	40.13	1424572.0
2014-05-01 11:30:00	MSFT	Stock	40.13	40.2	40.12	40.14	1491352.0
2014-05-01 12:00:00	MSFT	Stock	40.14	40.2	40.12	40.165	1056386.0
2014-05-01 12:30:00	MSFT	Stock	40.163	40.18	40.12	40.13	698033.0
2014-05-01 13:00:00	MSFT	Stock	40.135	40.15	40.025	40.04	830479.0
2014-05-01 13:30:00	MSFT	Stock	40.04	40.05	39.95	39.97	2709454.0
2014-05-01 14:00:00	MSFT	Stock	39.97	40.0	39.96	39.995	1687878.0
2014-05-01 14:30:00	MSFT	Stock	39.995	40.0	39.96	39.97	1401935.0
2014-05-01 15:00:00	MSFT	Stock	39.98	40.045	39.965	40.0	2172605.0
2014-05-01 15:30:00	MSFT	Stock	39.99	40.01	39.95	39.99	5607931.0
2014-05-01 16:00:00	MSFT	Stock	39.99	40.163	39.95	39.96	1442334.0
2014-05-01 16:30:00	MSFT	Stock	40.0	40.0	39.96	40.0	94777.0
2014-05-01 17:00:00	MSFT	Stock	40.0	40.0	39.99	40.0	378.0
2014-05-01 18:30:00	MSFT	Stock	39.99	39.99	39.97	39.97	717.0
2014-05-01 19:00:00	MSFT	Stock	39.97	40.0	39.97	40.0	650.0
2014-05-01 19:30:00	MSFT	Stock	39.97	40.0	39.96	39.96	2533.0
2014-05-01 09:00:00	NVDA	Stock	0.4643	0.4648	0.4643	0.4645	56000.0

> showing 50 of 83,619 rows — these rows as CSV

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