PREVIEW / stock_30min / 2017-03-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-10.parquet
  size:    1.6 MB
  rows:    82,622
  symbols: 3,084

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
2017-03-10 04:00:00	AAPL	Stock	34.8225	34.825	34.8225	34.825	3440.0
2017-03-10 04:30:00	AAPL	Stock	34.825	34.825	34.825	34.825	856.0
2017-03-10 05:00:00	AAPL	Stock	34.845	34.845	34.845	34.845	800.0
2017-03-10 05:30:00	AAPL	Stock	34.825	34.825	34.825	34.825	1600.0
2017-03-10 06:00:00	AAPL	Stock	34.83	34.85	34.8275	34.8375	14464.0
2017-03-10 06:30:00	AAPL	Stock	34.8375	34.8375	34.8375	34.8375	3324.0
2017-03-10 07:00:00	AAPL	Stock	34.8275	34.8425	34.7875	34.8375	27148.0
2017-03-10 07:30:00	AAPL	Stock	34.815	34.82	34.8	34.8	20760.0
2017-03-10 08:00:00	AAPL	Stock	34.81	34.81	34.76	34.795	124112.0
2017-03-10 08:30:00	AAPL	Stock	34.795	34.8375	34.75	34.8175	230656.0
2017-03-10 09:00:00	AAPL	Stock	34.7925	34.8525	34.79	34.81	198300.0
2017-03-10 09:30:00	AAPL	Stock	34.8125	34.8225	34.66	34.7625	12631116.0
2017-03-10 10:00:00	AAPL	Stock	34.76	34.815	34.755	34.755	6558912.0
2017-03-10 10:30:00	AAPL	Stock	34.755	34.7775	34.69	34.745	5180908.0
2017-03-10 11:00:00	AAPL	Stock	34.7425	34.83	34.7175	34.8158	4871408.0
2017-03-10 11:30:00	AAPL	Stock	34.817	34.8392	34.785	34.7975	3834872.0
2017-03-10 12:00:00	AAPL	Stock	34.7962	34.82	34.78	34.8013	2042124.0
2017-03-10 12:30:00	AAPL	Stock	34.8	34.8025	34.6925	34.7575	4535080.0
2017-03-10 13:00:00	AAPL	Stock	34.7575	34.775	34.7025	34.725	2930860.0
2017-03-10 13:30:00	AAPL	Stock	34.725	34.775	34.7125	34.76	2935488.0
2017-03-10 14:00:00	AAPL	Stock	34.7592	34.795	34.7463	34.7925	2671520.0
2017-03-10 14:30:00	AAPL	Stock	34.7942	34.8175	34.7775	34.7975	3211420.0
2017-03-10 15:00:00	AAPL	Stock	34.7975	34.8125	34.78	34.81	3397156.0
2017-03-10 15:30:00	AAPL	Stock	34.81	34.83	34.75	34.7875	7983372.0
2017-03-10 16:00:00	AAPL	Stock	34.785	34.7975	34.755	34.7675	8245296.0
2017-03-10 16:30:00	AAPL	Stock	34.765	34.785	34.76	34.7675	112240.0
2017-03-10 17:00:00	AAPL	Stock	34.77	34.7725	34.77	34.77	49196.0
2017-03-10 17:30:00	AAPL	Stock	34.775	34.775	34.77	34.775	36320.0
2017-03-10 18:00:00	AAPL	Stock	34.7775	34.7775	34.77	34.77	38372.0
2017-03-10 18:30:00	AAPL	Stock	34.785	34.785	34.7725	34.7725	2400.0
2017-03-10 19:00:00	AAPL	Stock	34.775	34.78	34.775	34.78	5612.0
2017-03-10 19:30:00	AAPL	Stock	34.77	34.78	34.77	34.78	6680.0
2017-03-10 05:30:00	MSFT	Stock	65.09	65.1	65.09	65.1	1110.0
2017-03-10 07:00:00	MSFT	Stock	65.1	65.1	65.1	65.1	1189.0
2017-03-10 07:30:00	MSFT	Stock	65.05	65.05	65.05	65.05	800.0
2017-03-10 08:00:00	MSFT	Stock	64.95	65.1	64.95	65.1	640.0
2017-03-10 08:30:00	MSFT	Stock	65.1	65.1	65.03	65.03	1399.0
2017-03-10 09:00:00	MSFT	Stock	65.03	65.2	65.02	65.1	33743.0
2017-03-10 09:30:00	MSFT	Stock	65.1	65.18	64.86	65.09	2346344.0
2017-03-10 10:00:00	MSFT	Stock	65.1	65.26	65.095	65.175	1872633.0
2017-03-10 10:30:00	MSFT	Stock	65.17	65.18	64.92	64.955	1591779.0
2017-03-10 11:00:00	MSFT	Stock	64.95	65.035	64.89	65.01	724338.0
2017-03-10 11:30:00	MSFT	Stock	65.02	65.03	64.91	64.915	734355.0
2017-03-10 12:00:00	MSFT	Stock	64.92	64.99	64.86	64.97	494003.0
2017-03-10 12:30:00	MSFT	Stock	64.964	64.97	64.77	64.865	740899.0
2017-03-10 13:00:00	MSFT	Stock	64.862	64.9	64.75	64.9	641222.0
2017-03-10 13:30:00	MSFT	Stock	64.895	64.95	64.84	64.89	709643.0
2017-03-10 14:00:00	MSFT	Stock	64.896	64.98	64.86	64.925	897924.0
2017-03-10 14:30:00	MSFT	Stock	64.925	64.99	64.88	64.95	619896.0
2017-03-10 15:00:00	MSFT	Stock	64.95	65.0	64.89	64.93	1037552.0

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

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