PREVIEW / stock_30min / 2015-06-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-16.parquet
  size:    1.6 MB
  rows:    83,033
  symbols: 3,507

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-06-16 04:00:00	AAPL	Stock	31.505	31.595	31.4925	31.545	55832.0
2015-06-16 04:30:00	AAPL	Stock	31.545	31.5725	31.525	31.53	40140.0
2015-06-16 05:00:00	AAPL	Stock	31.53	31.5675	31.5175	31.5475	73920.0
2015-06-16 05:30:00	AAPL	Stock	31.5175	31.5575	31.51	31.525	14320.0
2015-06-16 06:00:00	AAPL	Stock	31.5425	31.55	31.53	31.55	12400.0
2015-06-16 06:30:00	AAPL	Stock	31.54	31.57	31.525	31.5675	24320.0
2015-06-16 07:00:00	AAPL	Stock	31.575	31.62	31.5725	31.6	124000.0
2015-06-16 07:30:00	AAPL	Stock	31.605	31.625	31.595	31.605	85260.0
2015-06-16 08:00:00	AAPL	Stock	31.6175	31.6625	31.57	31.6375	375124.0
2015-06-16 08:30:00	AAPL	Stock	31.6375	31.8	31.6375	31.785	540540.0
2015-06-16 09:00:00	AAPL	Stock	31.775	31.81	31.625	31.7575	783788.0
2015-06-16 09:30:00	AAPL	Stock	31.7575	31.87	31.6525	31.7025	24705952.0
2015-06-16 10:00:00	AAPL	Stock	31.7025	31.7225	31.5925	31.6798	12888796.0
2015-06-16 10:30:00	AAPL	Stock	31.68	31.73	31.635	31.7075	8003708.0
2015-06-16 11:00:00	AAPL	Stock	31.705	31.82	31.705	31.7625	9651400.0
2015-06-16 11:30:00	AAPL	Stock	31.76	31.7925	31.75	31.7775	4910828.0
2015-06-16 12:00:00	AAPL	Stock	31.7775	31.81	31.7725	31.8032	4674400.0
2015-06-16 12:30:00	AAPL	Stock	31.8025	31.8675	31.8012	31.85	6323612.0
2015-06-16 13:00:00	AAPL	Stock	31.8475	31.8775	31.8138	31.865	5338804.0
2015-06-16 13:30:00	AAPL	Stock	31.8675	31.9075	31.865	31.9	4750532.0
2015-06-16 14:00:00	AAPL	Stock	31.9	31.9425	31.885	31.932	6187692.0
2015-06-16 14:30:00	AAPL	Stock	31.9325	31.9625	31.905	31.9238	5319068.0
2015-06-16 15:00:00	AAPL	Stock	31.925	31.93	31.8775	31.905	4873924.0
2015-06-16 15:30:00	AAPL	Stock	31.905	31.929	31.845	31.8975	11021544.0
2015-06-16 16:00:00	AAPL	Stock	31.9	31.9	31.8025	31.885	6893332.0
2015-06-16 16:30:00	AAPL	Stock	31.885	31.9	31.885	31.9	22500.0
2015-06-16 17:00:00	AAPL	Stock	31.9	31.9	31.885	31.9	25280.0
2015-06-16 17:30:00	AAPL	Stock	31.8875	31.905	31.8875	31.9	42028.0
2015-06-16 18:00:00	AAPL	Stock	31.9018	31.9075	31.8875	31.8875	36272.0
2015-06-16 18:30:00	AAPL	Stock	31.8975	31.905	31.8825	31.9	48616.0
2015-06-16 19:00:00	AAPL	Stock	31.9	31.9	31.8875	31.895	7048.0
2015-06-16 19:30:00	AAPL	Stock	31.8925	31.8925	31.8825	31.892	39808.0
2015-06-16 04:00:00	MSFT	Stock	45.38	45.38	45.16	45.16	300.0
2015-06-16 08:00:00	MSFT	Stock	45.417	45.417	45.397	45.397	200.0
2015-06-16 08:30:00	MSFT	Stock	45.37	45.39	45.37	45.39	1100.0
2015-06-16 09:00:00	MSFT	Stock	45.39	45.52	45.32	45.44	22825.0
2015-06-16 09:30:00	MSFT	Stock	45.44	45.83	45.3	45.79	4440838.0
2015-06-16 10:00:00	MSFT	Stock	45.785	45.86	45.56	45.805	2336857.0
2015-06-16 10:30:00	MSFT	Stock	45.8	45.89	45.67	45.7	1413479.0
2015-06-16 11:00:00	MSFT	Stock	45.7	45.88	45.65	45.81	1137122.0
2015-06-16 11:30:00	MSFT	Stock	45.81	45.87	45.73	45.74	915852.0
2015-06-16 12:00:00	MSFT	Stock	45.745	45.815	45.72	45.815	710702.0
2015-06-16 12:30:00	MSFT	Stock	45.82	46.19	45.815	46.115	1933121.0
2015-06-16 13:00:00	MSFT	Stock	46.115	46.22	46.01	46.185	1058966.0
2015-06-16 13:30:00	MSFT	Stock	46.19	46.23	46.12	46.151	819800.0
2015-06-16 14:00:00	MSFT	Stock	46.16	46.24	46.105	46.11	953559.0
2015-06-16 14:30:00	MSFT	Stock	46.11	46.12	46.01	46.07	1265808.0
2015-06-16 15:00:00	MSFT	Stock	46.07	46.09	45.95	46.02	1298510.0
2015-06-16 15:30:00	MSFT	Stock	46.02	46.05	45.79	45.82	4560223.0
2015-06-16 16:00:00	MSFT	Stock	45.83	45.9	45.775	45.9	2950259.0

> showing 50 of 83,033 rows — these rows as CSV

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