PREVIEW / stock_30min / 2016-04-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-19.parquet
  size:    1.6 MB
  rows:    82,418
  symbols: 3,328

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-04-19 04:00:00	AAPL	Stock	27.045	27.075	27.045	27.075	4000.0
2016-04-19 04:30:00	AAPL	Stock	27.065	27.065	27.045	27.045	1636.0
2016-04-19 05:00:00	AAPL	Stock	27.0725	27.0725	27.0725	27.0725	1420.0
2016-04-19 05:30:00	AAPL	Stock	27.0725	27.0825	27.0725	27.0825	7964.0
2016-04-19 06:00:00	AAPL	Stock	27.0925	27.095	27.0475	27.0475	32240.0
2016-04-19 06:30:00	AAPL	Stock	27.0275	27.045	27.01	27.01	11780.0
2016-04-19 07:00:00	AAPL	Stock	27.025	27.0325	26.985	27.0	32756.0
2016-04-19 07:30:00	AAPL	Stock	27.0	27.03	27.0	27.025	107016.0
2016-04-19 08:00:00	AAPL	Stock	27.0125	27.0375	26.87	27.0	148216.0
2016-04-19 08:30:00	AAPL	Stock	27.0075	27.015	26.965	26.99	180304.0
2016-04-19 09:00:00	AAPL	Stock	26.9875	26.9975	26.87	26.97	256332.0
2016-04-19 09:30:00	AAPL	Stock	26.97	26.99	26.6378	26.8025	21022080.0
2016-04-19 10:00:00	AAPL	Stock	26.8	26.92	26.735	26.7675	12520268.0
2016-04-19 10:30:00	AAPL	Stock	26.7675	26.8548	26.755	26.7775	7846864.0
2016-04-19 11:00:00	AAPL	Stock	26.7775	26.8	26.7325	26.7442	6341000.0
2016-04-19 11:30:00	AAPL	Stock	26.745	26.765	26.6775	26.685	6701300.0
2016-04-19 12:00:00	AAPL	Stock	26.685	26.7165	26.63	26.67	5839104.0
2016-04-19 12:30:00	AAPL	Stock	26.67	26.7	26.5575	26.6975	8426080.0
2016-04-19 13:00:00	AAPL	Stock	26.695	26.77	26.6688	26.7475	6190940.0
2016-04-19 13:30:00	AAPL	Stock	26.7488	26.7825	26.69	26.7625	4710824.0
2016-04-19 14:00:00	AAPL	Stock	26.7648	26.81	26.7445	26.7475	5437992.0
2016-04-19 14:30:00	AAPL	Stock	26.7475	26.7725	26.72	26.7488	4929516.0
2016-04-19 15:00:00	AAPL	Stock	26.745	26.75	26.6728	26.695	7024396.0
2016-04-19 15:30:00	AAPL	Stock	26.6975	27.0	26.6925	26.7375	11736264.0
2016-04-19 16:00:00	AAPL	Stock	26.7275	26.765	26.6615	26.7	9414852.0
2016-04-19 16:30:00	AAPL	Stock	26.69	26.7275	26.69	26.7075	99252.0
2016-04-19 17:00:00	AAPL	Stock	26.7	26.73	26.7	26.7225	36620.0
2016-04-19 17:30:00	AAPL	Stock	26.73	26.73	26.71	26.71	43736.0
2016-04-19 18:00:00	AAPL	Stock	26.71	26.72	26.7	26.7175	10484.0
2016-04-19 18:30:00	AAPL	Stock	26.7	26.7075	26.6625	26.6625	54600.0
2016-04-19 19:00:00	AAPL	Stock	26.675	26.6975	26.6725	26.675	20536.0
2016-04-19 19:30:00	AAPL	Stock	26.67	26.6725	26.65	26.67	20984.0
2016-04-19 07:00:00	MSFT	Stock	56.74	56.75	56.74	56.75	2100.0
2016-04-19 07:30:00	MSFT	Stock	56.73	56.79	56.7	56.79	14600.0
2016-04-19 08:00:00	MSFT	Stock	56.77	56.8	56.7	56.8	6414.0
2016-04-19 08:30:00	MSFT	Stock	56.77	56.79	56.65	56.71	25634.0
2016-04-19 09:00:00	MSFT	Stock	56.75	56.78	56.46	56.63	30963.0
2016-04-19 09:30:00	MSFT	Stock	56.64	56.77	55.68	56.01	5853422.0
2016-04-19 10:00:00	MSFT	Stock	56.01	56.25	56.0	56.01	3053827.0
2016-04-19 10:30:00	MSFT	Stock	56.02	56.28	56.02	56.255	1275504.0
2016-04-19 11:00:00	MSFT	Stock	56.25	56.39	56.2	56.31	1033506.0
2016-04-19 11:30:00	MSFT	Stock	56.31	56.36	56.0	56.005	1356904.0
2016-04-19 12:00:00	MSFT	Stock	56.01	56.24	56.0	56.16	1423436.0
2016-04-19 12:30:00	MSFT	Stock	56.15	56.27	56.04	56.245	853553.0
2016-04-19 13:00:00	MSFT	Stock	56.25	56.33	56.2	56.255	906715.0
2016-04-19 13:30:00	MSFT	Stock	56.26	56.385	56.2	56.385	812188.0
2016-04-19 14:00:00	MSFT	Stock	56.385	56.5	56.36	56.375	992456.0
2016-04-19 14:30:00	MSFT	Stock	56.37	56.465	56.29	56.335	1108929.0
2016-04-19 15:00:00	MSFT	Stock	56.339	56.385	56.205	56.35	1219843.0
2016-04-19 15:30:00	MSFT	Stock	56.35	56.4	56.245	56.4	2805062.0

> showing 50 of 82,418 rows — these rows as CSV

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