PREVIEW / stock_30min / 2016-05-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-06.parquet
  size:    1.5 MB
  rows:    80,789
  symbols: 3,288

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-06 04:00:00	AAPL	Stock	23.31	23.31	23.31	23.31	1168.0
2016-05-06 05:00:00	AAPL	Stock	23.37	23.37	23.37	23.37	1252.0
2016-05-06 06:00:00	AAPL	Stock	23.33	23.33	23.33	23.33	1200.0
2016-05-06 06:30:00	AAPL	Stock	23.2875	23.3225	23.2875	23.3225	1200.0
2016-05-06 07:00:00	AAPL	Stock	23.335	23.3525	23.3	23.31	25492.0
2016-05-06 07:30:00	AAPL	Stock	23.2875	23.3	23.2875	23.2925	7512.0
2016-05-06 08:00:00	AAPL	Stock	23.315	23.35	23.285	23.35	143952.0
2016-05-06 08:30:00	AAPL	Stock	23.35	23.3525	23.25	23.29	385092.0
2016-05-06 09:00:00	AAPL	Stock	23.29	23.345	23.275	23.34	240656.0
2016-05-06 09:30:00	AAPL	Stock	23.34	23.3625	23.2025	23.265	15616260.0
2016-05-06 10:00:00	AAPL	Stock	23.2638	23.3575	23.2025	23.2375	10626076.0
2016-05-06 10:30:00	AAPL	Stock	23.2375	23.2625	23.1275	23.1625	11526236.0
2016-05-06 11:00:00	AAPL	Stock	23.1625	23.25	23.155	23.19	7360320.0
2016-05-06 11:30:00	AAPL	Stock	23.19	23.1938	23.025	23.0487	16370868.0
2016-05-06 12:00:00	AAPL	Stock	23.0498	23.08	23.0	23.0038	14403744.0
2016-05-06 12:30:00	AAPL	Stock	23.0025	23.0775	22.9975	23.0525	8774692.0
2016-05-06 13:00:00	AAPL	Stock	23.0538	23.1175	23.0525	23.0615	10478120.0
2016-05-06 13:30:00	AAPL	Stock	23.0608	23.0662	22.9625	23.0512	12882636.0
2016-05-06 14:00:00	AAPL	Stock	23.0525	23.1612	23.0525	23.0825	12444252.0
2016-05-06 14:30:00	AAPL	Stock	23.0812	23.2	23.0775	23.18	10642420.0
2016-05-06 15:00:00	AAPL	Stock	23.18	23.2	23.1575	23.1778	8327856.0
2016-05-06 15:30:00	AAPL	Stock	23.1778	23.1825	23.105	23.18	16415272.0
2016-05-06 16:00:00	AAPL	Stock	23.18	23.195	23.15	23.1825	6312700.0
2016-05-06 16:30:00	AAPL	Stock	23.18	23.19	23.035	23.1825	693064.0
2016-05-06 17:00:00	AAPL	Stock	23.18	23.1825	23.165	23.165	33328.0
2016-05-06 17:30:00	AAPL	Stock	23.165	23.1825	23.165	23.175	23936.0
2016-05-06 18:00:00	AAPL	Stock	23.175	23.18	23.17	23.17	36496.0
2016-05-06 18:30:00	AAPL	Stock	23.1775	23.1825	23.17	23.17	8832.0
2016-05-06 19:00:00	AAPL	Stock	23.17	23.17	23.165	23.165	12000.0
2016-05-06 19:30:00	AAPL	Stock	23.1725	23.185	23.1675	23.1675	24292.0
2016-05-06 08:00:00	MSFT	Stock	49.78	49.78	49.77	49.77	1999.0
2016-05-06 08:30:00	MSFT	Stock	49.85	49.85	49.63	49.7	21490.0
2016-05-06 09:00:00	MSFT	Stock	49.7	49.92	49.7	49.92	44202.0
2016-05-06 09:30:00	MSFT	Stock	49.91	50.0	49.75	49.874	3221789.0
2016-05-06 10:00:00	MSFT	Stock	49.88	49.955	49.76	49.87	1765911.0
2016-05-06 10:30:00	MSFT	Stock	49.86	49.93	49.72	49.774	2169238.0
2016-05-06 11:00:00	MSFT	Stock	49.77	49.88	49.66	49.84	1362147.0
2016-05-06 11:30:00	MSFT	Stock	49.84	49.84	49.68	49.76	1242330.0
2016-05-06 12:00:00	MSFT	Stock	49.755	49.77	49.695	49.74	830755.0
2016-05-06 12:30:00	MSFT	Stock	49.735	49.88	49.72	49.88	1047055.0
2016-05-06 13:00:00	MSFT	Stock	49.88	50.025	49.86	49.98	963733.0
2016-05-06 13:30:00	MSFT	Stock	49.985	50.205	49.95	50.2	1342196.0
2016-05-06 14:00:00	MSFT	Stock	50.21	50.32	50.16	50.19	1316046.0
2016-05-06 14:30:00	MSFT	Stock	50.19	50.33	50.11	50.245	1519111.0
2016-05-06 15:00:00	MSFT	Stock	50.245	50.32	50.22	50.299	1854207.0
2016-05-06 15:30:00	MSFT	Stock	50.29	50.39	50.17	50.39	3005279.0
2016-05-06 16:00:00	MSFT	Stock	50.38	50.39	49.782	50.38	1704133.0
2016-05-06 16:30:00	MSFT	Stock	50.38	50.38	50.37	50.38	1700.0
2016-05-06 17:00:00	MSFT	Stock	50.37	50.39	50.37	50.39	3454.0
2016-05-06 17:30:00	MSFT	Stock	50.39	50.39	50.39	50.39	200.0

> showing 50 of 80,789 rows — these rows as CSV

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