PREVIEW / stock_30min / 2016-02-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-22.parquet
  size:    1.6 MB
  rows:    84,042
  symbols: 3,365

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-02-22 04:00:00	AAPL	Stock	24.095	24.2375	24.095	24.19	13760.0
2016-02-22 04:30:00	AAPL	Stock	24.25	24.3125	24.25	24.3125	13208.0
2016-02-22 05:00:00	AAPL	Stock	24.2525	24.2525	24.1925	24.1925	2800.0
2016-02-22 05:30:00	AAPL	Stock	24.265	24.265	24.265	24.265	456.0
2016-02-22 06:00:00	AAPL	Stock	24.2725	24.275	24.2725	24.275	2468.0
2016-02-22 06:30:00	AAPL	Stock	24.235	24.235	24.2025	24.2025	6840.0
2016-02-22 07:00:00	AAPL	Stock	24.2025	24.2025	24.15	24.2	62648.0
2016-02-22 07:30:00	AAPL	Stock	24.2	24.2	24.1325	24.15	46872.0
2016-02-22 08:00:00	AAPL	Stock	24.1425	24.19	24.1075	24.1225	353860.0
2016-02-22 08:30:00	AAPL	Stock	24.125	24.13	24.0625	24.1075	201352.0
2016-02-22 09:00:00	AAPL	Stock	24.1125	24.125	24.065	24.075	198664.0
2016-02-22 09:30:00	AAPL	Stock	24.0775	24.1825	23.98	24.1375	20673328.0
2016-02-22 10:00:00	AAPL	Stock	24.1375	24.1875	24.0325	24.0725	12555464.0
2016-02-22 10:30:00	AAPL	Stock	24.075	24.125	24.0425	24.0688	7574576.0
2016-02-22 11:00:00	AAPL	Stock	24.0688	24.0975	24.0275	24.06	8239620.0
2016-02-22 11:30:00	AAPL	Stock	24.0625	24.065	23.985	24.0575	7750248.0
2016-02-22 12:00:00	AAPL	Stock	24.0565	24.075	24.0175	24.063	5906064.0
2016-02-22 12:30:00	AAPL	Stock	24.065	24.075	24.0012	24.008	5676524.0
2016-02-22 13:00:00	AAPL	Stock	24.0075	24.07	24.0	24.0575	4911728.0
2016-02-22 13:30:00	AAPL	Stock	24.0575	24.125	24.053	24.1175	7298920.0
2016-02-22 14:00:00	AAPL	Stock	24.12	24.1625	24.0975	24.12	7494208.0
2016-02-22 14:30:00	AAPL	Stock	24.12	24.18	24.065	24.1525	10382972.0
2016-02-22 15:00:00	AAPL	Stock	24.1545	24.172	24.1	24.1475	7347432.0
2016-02-22 15:30:00	AAPL	Stock	24.1475	24.225	24.1325	24.2175	14000840.0
2016-02-22 16:00:00	AAPL	Stock	24.2175	24.22	24.0948	24.1925	5591552.0
2016-02-22 16:30:00	AAPL	Stock	24.1925	24.2	24.175	24.175	80856.0
2016-02-22 17:00:00	AAPL	Stock	24.1875	24.2	24.165	24.165	93632.0
2016-02-22 17:30:00	AAPL	Stock	24.15	24.18	24.145	24.165	34900.0
2016-02-22 18:00:00	AAPL	Stock	24.1625	24.1825	24.1625	24.18	17120.0
2016-02-22 18:30:00	AAPL	Stock	24.175	24.175	24.155	24.155	2000.0
2016-02-22 19:00:00	AAPL	Stock	24.155	24.1625	24.1525	24.1525	10260.0
2016-02-22 19:30:00	AAPL	Stock	24.1625	24.1625	24.1525	24.1625	11016.0
2016-02-22 04:00:00	MSFT	Stock	52.0	52.0	52.0	52.0	100.0
2016-02-22 06:30:00	MSFT	Stock	52.3	52.3	52.3	52.3	400.0
2016-02-22 07:00:00	MSFT	Stock	52.45	52.45	52.4	52.4	660.0
2016-02-22 07:30:00	MSFT	Stock	52.42	52.42	52.4	52.4	1129.0
2016-02-22 08:00:00	MSFT	Stock	52.38	52.4	52.3	52.3	18370.0
2016-02-22 08:30:00	MSFT	Stock	52.3	52.37	52.3	52.35	12868.0
2016-02-22 09:00:00	MSFT	Stock	52.33	52.36	52.28	52.35	23863.0
2016-02-22 09:30:00	MSFT	Stock	52.28	52.83	52.28	52.83	3189787.0
2016-02-22 10:00:00	MSFT	Stock	52.83	52.97	52.73	52.81	2173423.0
2016-02-22 10:30:00	MSFT	Stock	52.82	52.88	52.74	52.785	1209961.0
2016-02-22 11:00:00	MSFT	Stock	52.78	52.95	52.74	52.92	1346790.0
2016-02-22 11:30:00	MSFT	Stock	52.92	53.0	52.84	52.86	1648007.0
2016-02-22 12:00:00	MSFT	Stock	52.86	52.87	52.71	52.86	789775.0
2016-02-22 12:30:00	MSFT	Stock	52.85	52.875	52.7	52.72	1189302.0
2016-02-22 13:00:00	MSFT	Stock	52.725	52.795	52.68	52.73	670705.0
2016-02-22 13:30:00	MSFT	Stock	52.725	52.91	52.72	52.85	773390.0
2016-02-22 14:00:00	MSFT	Stock	52.845	52.85	52.66	52.705	961979.0
2016-02-22 14:30:00	MSFT	Stock	52.7	52.73	52.5	52.535	1092780.0

> showing 50 of 84,042 rows — these rows as CSV

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