PREVIEW / stock_30min / 2015-09-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-10.parquet
  size:    1.6 MB
  rows:    81,897
  symbols: 3,455

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
2015-09-10 04:00:00	AAPL	Stock	27.7125	27.7875	27.6625	27.685	15260.0
2015-09-10 04:30:00	AAPL	Stock	27.635	27.675	27.6	27.675	13532.0
2015-09-10 05:00:00	AAPL	Stock	27.675	27.7	27.6375	27.6375	26992.0
2015-09-10 05:30:00	AAPL	Stock	27.7175	27.8125	27.7	27.7825	68364.0
2015-09-10 06:00:00	AAPL	Stock	27.8125	27.87	27.7	27.7	51412.0
2015-09-10 06:30:00	AAPL	Stock	27.7375	27.8325	27.6375	27.68	68392.0
2015-09-10 07:00:00	AAPL	Stock	27.6875	27.72	27.4825	27.5925	181572.0
2015-09-10 07:30:00	AAPL	Stock	27.5925	27.645	27.465	27.525	308508.0
2015-09-10 08:00:00	AAPL	Stock	27.535	27.7125	27.45	27.5125	774768.0
2015-09-10 08:30:00	AAPL	Stock	27.5125	27.55	27.42	27.45	1044572.0
2015-09-10 09:00:00	AAPL	Stock	27.4625	27.6225	27.4525	27.565	1099076.0
2015-09-10 09:30:00	AAPL	Stock	27.5675	27.92	27.475	27.795	40366656.0
2015-09-10 10:00:00	AAPL	Stock	27.7975	27.87	27.6722	27.8625	20618252.0
2015-09-10 10:30:00	AAPL	Stock	27.8625	28.1775	27.8125	28.0838	26154440.0
2015-09-10 11:00:00	AAPL	Stock	28.0825	28.115	27.94	28.0272	17062576.0
2015-09-10 11:30:00	AAPL	Stock	28.0275	28.165	28.005	28.105	12925812.0
2015-09-10 12:00:00	AAPL	Stock	28.11	28.195	28.0662	28.09	12899908.0
2015-09-10 12:30:00	AAPL	Stock	28.0875	28.1575	28.0475	28.1188	8934220.0
2015-09-10 13:00:00	AAPL	Stock	28.1175	28.2325	28.06	28.2262	9186128.0
2015-09-10 13:30:00	AAPL	Stock	28.225	28.3205	28.17	28.2075	16091268.0
2015-09-10 14:00:00	AAPL	Stock	28.2075	28.2225	28.0778	28.1675	10324756.0
2015-09-10 14:30:00	AAPL	Stock	28.165	28.28	28.1225	28.133	11144520.0
2015-09-10 15:00:00	AAPL	Stock	28.1325	28.2125	28.0275	28.12	15693556.0
2015-09-10 15:30:00	AAPL	Stock	28.1175	28.17	27.9875	28.1475	21680784.0
2015-09-10 16:00:00	AAPL	Stock	28.1425	28.145	27.7152	28.1175	7921412.0
2015-09-10 16:30:00	AAPL	Stock	28.1175	28.15	28.11	28.125	207060.0
2015-09-10 17:00:00	AAPL	Stock	28.125	28.15	28.1175	28.1325	73412.0
2015-09-10 17:30:00	AAPL	Stock	28.1425	28.1425	28.12	28.125	18700.0
2015-09-10 18:00:00	AAPL	Stock	28.12	28.13	28.12	28.125	20084.0
2015-09-10 18:30:00	AAPL	Stock	28.13	28.1625	28.12	28.1625	58064.0
2015-09-10 19:00:00	AAPL	Stock	28.145	28.1625	28.14	28.155	32000.0
2015-09-10 19:30:00	AAPL	Stock	28.145	28.145	28.105	28.1125	46128.0
2015-09-10 04:00:00	MSFT	Stock	43.44	43.44	43.44	43.44	100.0
2015-09-10 05:30:00	MSFT	Stock	43.48	43.48	43.48	43.48	100.0
2015-09-10 07:30:00	MSFT	Stock	43.08	43.08	43.08	43.08	100.0
2015-09-10 08:00:00	MSFT	Stock	43.15	43.15	42.97	42.97	3100.0
2015-09-10 08:30:00	MSFT	Stock	42.97	42.97	42.79	42.83	2200.0
2015-09-10 09:00:00	MSFT	Stock	42.89	43.1	42.87	43.1	12719.0
2015-09-10 09:30:00	MSFT	Stock	43.12	43.15	42.82	42.82	3055977.0
2015-09-10 10:00:00	MSFT	Stock	42.825	43.07	42.745	43.04	2311407.0
2015-09-10 10:30:00	MSFT	Stock	43.04	43.6	43.02	43.49	2637713.0
2015-09-10 11:00:00	MSFT	Stock	43.49	43.49	43.105	43.205	1749143.0
2015-09-10 11:30:00	MSFT	Stock	43.21	43.403	43.14	43.29	1213204.0
2015-09-10 12:00:00	MSFT	Stock	43.3	43.51	43.25	43.29	1231028.0
2015-09-10 12:30:00	MSFT	Stock	43.29	43.49	43.26	43.405	1027359.0
2015-09-10 13:00:00	MSFT	Stock	43.409	43.58	43.31	43.57	1308691.0
2015-09-10 13:30:00	MSFT	Stock	43.58	43.79	43.43	43.53	2095705.0
2015-09-10 14:00:00	MSFT	Stock	43.524	43.58	43.41	43.455	1192808.0
2015-09-10 14:30:00	MSFT	Stock	43.455	43.55	43.283	43.283	1342835.0
2015-09-10 15:00:00	MSFT	Stock	43.29	43.36	43.15	43.22	1871057.0

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

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