PREVIEW / stock_30min / 2015-09-15

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-15.parquet
  size:    1.5 MB
  rows:    81,084
  symbols: 3,461

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-15 04:00:00	AAPL	Stock	29.0	29.0	28.8125	28.9	27788.0
2015-09-15 04:30:00	AAPL	Stock	28.885	28.885	28.845	28.875	14596.0
2015-09-15 05:00:00	AAPL	Stock	28.87	28.875	28.8125	28.825	4304.0
2015-09-15 05:30:00	AAPL	Stock	28.825	28.83	28.8125	28.825	4956.0
2015-09-15 06:00:00	AAPL	Stock	28.8225	28.86	28.8075	28.86	43128.0
2015-09-15 06:30:00	AAPL	Stock	28.8575	28.94	28.8575	28.9	46420.0
2015-09-15 07:00:00	AAPL	Stock	28.915	28.935	28.8425	28.85	129540.0
2015-09-15 07:30:00	AAPL	Stock	28.86	28.925	28.86	28.9025	70652.0
2015-09-15 08:00:00	AAPL	Stock	28.9	28.935	28.8325	28.9275	370492.0
2015-09-15 08:30:00	AAPL	Stock	28.915	28.915	28.8825	28.9125	258620.0
2015-09-15 09:00:00	AAPL	Stock	28.9025	28.9775	28.9	28.975	583704.0
2015-09-15 09:30:00	AAPL	Stock	28.9825	28.9925	28.605	28.72	27273532.0
2015-09-15 10:00:00	AAPL	Stock	28.725	28.95	28.725	28.9	16032508.0
2015-09-15 10:30:00	AAPL	Stock	28.9	29.0225	28.8925	28.9875	15426296.0
2015-09-15 11:00:00	AAPL	Stock	28.985	29.035	28.95	28.9838	9886096.0
2015-09-15 11:30:00	AAPL	Stock	28.9825	28.9925	28.905	28.9362	6632768.0
2015-09-15 12:00:00	AAPL	Stock	28.935	28.9925	28.91	28.9925	6717460.0
2015-09-15 12:30:00	AAPL	Stock	28.99	29.0575	28.9675	28.9875	9442364.0
2015-09-15 13:00:00	AAPL	Stock	28.9852	29.0375	28.9625	29.0125	6871944.0
2015-09-15 13:30:00	AAPL	Stock	29.0138	29.09	28.9675	29.025	10333832.0
2015-09-15 14:00:00	AAPL	Stock	29.025	29.075	28.975	29.0225	8159972.0
2015-09-15 14:30:00	AAPL	Stock	29.02	29.1125	29.01	29.0925	9703124.0
2015-09-15 15:00:00	AAPL	Stock	29.09	29.1325	29.0675	29.1088	12430124.0
2015-09-15 15:30:00	AAPL	Stock	29.1075	29.1175	28.965	29.0675	16293108.0
2015-09-15 16:00:00	AAPL	Stock	29.07	29.1025	29.0675	29.1	5112800.0
2015-09-15 16:30:00	AAPL	Stock	29.0825	29.1225	29.07	29.09	227768.0
2015-09-15 17:00:00	AAPL	Stock	29.1	29.1225	29.07	29.0925	65164.0
2015-09-15 17:30:00	AAPL	Stock	29.1	29.1125	29.1	29.1	19928.0
2015-09-15 18:00:00	AAPL	Stock	29.1025	29.11	29.075	29.075	95836.0
2015-09-15 18:30:00	AAPL	Stock	29.0775	29.0875	29.075	29.0875	97000.0
2015-09-15 19:00:00	AAPL	Stock	29.0875	29.1	29.0775	29.1	86852.0
2015-09-15 19:30:00	AAPL	Stock	29.1	29.1	29.0875	29.0975	70196.0
2015-09-15 06:30:00	MSFT	Stock	43.03	43.03	43.03	43.03	300.0
2015-09-15 07:00:00	MSFT	Stock	43.05	43.05	43.05	43.05	225.0
2015-09-15 08:00:00	MSFT	Stock	43.08	43.08	43.08	43.08	350.0
2015-09-15 08:30:00	MSFT	Stock	43.11	43.11	43.11	43.11	900.0
2015-09-15 09:00:00	MSFT	Stock	43.14	43.16	43.07	43.16	1300.0
2015-09-15 09:30:00	MSFT	Stock	43.19	43.77	43.08	43.74	4099259.0
2015-09-15 10:00:00	MSFT	Stock	43.74	43.91	43.62	43.8	2778383.0
2015-09-15 10:30:00	MSFT	Stock	43.795	43.975	43.795	43.88	2130477.0
2015-09-15 11:00:00	MSFT	Stock	43.89	44.03	43.84	44.0	1859790.0
2015-09-15 11:30:00	MSFT	Stock	43.99	44.02	43.75	43.78	1303211.0
2015-09-15 12:00:00	MSFT	Stock	43.78	43.97	43.76	43.91	1048873.0
2015-09-15 12:30:00	MSFT	Stock	43.9	43.92	43.755	43.755	1043618.0
2015-09-15 13:00:00	MSFT	Stock	43.755	43.92	43.73	43.9	895681.0
2015-09-15 13:30:00	MSFT	Stock	43.9	43.98	43.87	43.89	1004235.0
2015-09-15 14:00:00	MSFT	Stock	43.895	44.03	43.89	44.02	1312120.0
2015-09-15 14:30:00	MSFT	Stock	44.03	44.27	44.03	44.24	2071353.0
2015-09-15 15:00:00	MSFT	Stock	44.24	44.29	44.135	44.18	1651052.0
2015-09-15 15:30:00	MSFT	Stock	44.18	44.225	43.96	43.98	3863488.0

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

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