PREVIEW / stock_30min / 2016-08-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-09.parquet
  size:    1.6 MB
  rows:    81,691
  symbols: 3,250

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-08-09 04:00:00	AAPL	Stock	27.1025	27.1025	27.0975	27.0975	3748.0
2016-08-09 05:00:00	AAPL	Stock	27.125	27.1275	27.125	27.1275	4680.0
2016-08-09 05:30:00	AAPL	Stock	27.1475	27.1475	27.135	27.135	1172.0
2016-08-09 06:00:00	AAPL	Stock	27.135	27.145	27.135	27.145	4660.0
2016-08-09 06:30:00	AAPL	Stock	27.1475	27.1575	27.1475	27.1575	1500.0
2016-08-09 07:00:00	AAPL	Stock	27.1475	27.1625	27.1475	27.16	52716.0
2016-08-09 07:30:00	AAPL	Stock	27.1525	27.155	27.13	27.1375	23664.0
2016-08-09 08:00:00	AAPL	Stock	27.1475	27.1625	27.125	27.125	183920.0
2016-08-09 08:30:00	AAPL	Stock	27.125	27.14	27.0225	27.0375	325060.0
2016-08-09 09:00:00	AAPL	Stock	27.0375	27.0775	27.025	27.055	170260.0
2016-08-09 09:30:00	AAPL	Stock	27.055	27.15	27.0425	27.0475	15273360.0
2016-08-09 10:00:00	AAPL	Stock	27.0462	27.0875	27.01	27.0125	10084496.0
2016-08-09 10:30:00	AAPL	Stock	27.0125	27.1125	27.0025	27.0725	7164152.0
2016-08-09 11:00:00	AAPL	Stock	27.0725	27.1175	27.0625	27.0748	4506856.0
2016-08-09 11:30:00	AAPL	Stock	27.0725	27.105	27.055	27.0925	4432712.0
2016-08-09 12:00:00	AAPL	Stock	27.095	27.125	27.0825	27.0875	4489588.0
2016-08-09 12:30:00	AAPL	Stock	27.0875	27.095	27.0475	27.085	5527188.0
2016-08-09 13:00:00	AAPL	Stock	27.085	27.1385	27.085	27.125	4772644.0
2016-08-09 13:30:00	AAPL	Stock	27.1225	27.16	27.1075	27.1425	5047376.0
2016-08-09 14:00:00	AAPL	Stock	27.1435	27.1875	27.13	27.176	5328732.0
2016-08-09 14:30:00	AAPL	Stock	27.175	27.1775	27.145	27.1775	4339592.0
2016-08-09 15:00:00	AAPL	Stock	27.1775	27.235	27.1675	27.225	6977636.0
2016-08-09 15:30:00	AAPL	Stock	27.2252	27.23	27.185	27.205	10546876.0
2016-08-09 16:00:00	AAPL	Stock	27.205	27.2075	27.19	27.195	6582272.0
2016-08-09 16:30:00	AAPL	Stock	27.1975	27.2025	27.1775	27.1775	175764.0
2016-08-09 17:00:00	AAPL	Stock	27.1875	27.1875	27.175	27.175	58224.0
2016-08-09 17:30:00	AAPL	Stock	27.175	27.175	27.165	27.175	10680.0
2016-08-09 18:00:00	AAPL	Stock	27.1675	27.175	27.1675	27.175	2760.0
2016-08-09 18:30:00	AAPL	Stock	27.175	27.18	27.17	27.18	13816.0
2016-08-09 19:00:00	AAPL	Stock	27.1675	27.17	27.1675	27.17	8000.0
2016-08-09 19:30:00	AAPL	Stock	27.17	27.1725	27.1675	27.1675	12800.0
2016-08-09 07:30:00	MSFT	Stock	58.12	58.12	58.12	58.12	400.0
2016-08-09 09:00:00	MSFT	Stock	58.1	58.18	58.1	58.17	6270.0
2016-08-09 09:30:00	MSFT	Stock	58.17	58.34	58.03	58.26	1640049.0
2016-08-09 10:00:00	MSFT	Stock	58.26	58.3	58.155	58.285	904219.0
2016-08-09 10:30:00	MSFT	Stock	58.285	58.45	58.28	58.29	1246891.0
2016-08-09 11:00:00	MSFT	Stock	58.296	58.5	58.29	58.45	1187849.0
2016-08-09 11:30:00	MSFT	Stock	58.45	58.47	58.28	58.296	844838.0
2016-08-09 12:00:00	MSFT	Stock	58.29	58.4	58.19	58.257	915011.0
2016-08-09 12:30:00	MSFT	Stock	58.253	58.28	58.15	58.156	998207.0
2016-08-09 13:00:00	MSFT	Stock	58.16	58.265	58.13	58.15	831042.0
2016-08-09 13:30:00	MSFT	Stock	58.152	58.18	58.06	58.14	780220.0
2016-08-09 14:00:00	MSFT	Stock	58.14	58.22	58.07	58.16	864112.0
2016-08-09 14:30:00	MSFT	Stock	58.16	58.193	58.02	58.16	995397.0
2016-08-09 15:00:00	MSFT	Stock	58.164	58.18	58.1	58.15	1045649.0
2016-08-09 15:30:00	MSFT	Stock	58.16	58.205	58.08	58.2	2278252.0
2016-08-09 16:00:00	MSFT	Stock	58.2	58.23	58.12	58.138	1327068.0
2016-08-09 16:30:00	MSFT	Stock	58.2	58.2	58.2	58.2	40657.0
2016-08-09 17:00:00	MSFT	Stock	58.24	58.24	58.24	58.24	100.0
2016-08-09 17:30:00	MSFT	Stock	58.24	58.45	58.18	58.3	6900.0

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

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