PREVIEW / stock_30min / 2016-11-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-09.parquet
  size:    1.7 MB
  rows:    85,981
  symbols: 3,179

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-11-09 04:00:00	AAPL	Stock	26.9975	27.2625	26.925	27.1225	462484.0
2016-11-09 04:30:00	AAPL	Stock	27.1125	27.3175	27.1125	27.275	69408.0
2016-11-09 05:00:00	AAPL	Stock	27.25	27.2525	27.1875	27.24	112904.0
2016-11-09 05:30:00	AAPL	Stock	27.295	27.315	27.2125	27.2275	108572.0
2016-11-09 06:00:00	AAPL	Stock	27.25	27.25	27.0775	27.1	342740.0
2016-11-09 06:30:00	AAPL	Stock	27.115	27.185	27.0875	27.14	122772.0
2016-11-09 07:00:00	AAPL	Stock	27.1625	27.4025	27.125	27.4025	603904.0
2016-11-09 07:30:00	AAPL	Stock	27.4075	27.55	27.3775	27.55	516164.0
2016-11-09 08:00:00	AAPL	Stock	27.545	27.6475	27.075	27.5	2165820.0
2016-11-09 08:30:00	AAPL	Stock	27.5	27.675	27.4775	27.55	1031020.0
2016-11-09 09:00:00	AAPL	Stock	27.55	27.8125	27.4675	27.47	3502516.0
2016-11-09 09:30:00	AAPL	Stock	27.4675	27.655	27.0125	27.3125	56943032.0
2016-11-09 10:00:00	AAPL	Stock	27.3125	27.3575	27.115	27.2	19289228.0
2016-11-09 10:30:00	AAPL	Stock	27.2	27.2975	27.11	27.2575	14541492.0
2016-11-09 11:00:00	AAPL	Stock	27.255	27.4475	27.21	27.4192	13874620.0
2016-11-09 11:30:00	AAPL	Stock	27.415	27.5475	27.39	27.4475	15772320.0
2016-11-09 12:00:00	AAPL	Stock	27.45	27.47	27.285	27.408	9143544.0
2016-11-09 12:30:00	AAPL	Stock	27.4088	27.51	27.3675	27.4988	6948572.0
2016-11-09 13:00:00	AAPL	Stock	27.4992	27.54	27.2975	27.3225	7857448.0
2016-11-09 13:30:00	AAPL	Stock	27.324	27.4925	27.3	27.4012	6076056.0
2016-11-09 14:00:00	AAPL	Stock	27.4025	27.685	27.3675	27.63	10015828.0
2016-11-09 14:30:00	AAPL	Stock	27.63	27.745	27.625	27.65	8955284.0
2016-11-09 15:00:00	AAPL	Stock	27.65	27.83	27.65	27.705	9525388.0
2016-11-09 15:30:00	AAPL	Stock	27.7072	27.73	27.6175	27.72	15878220.0
2016-11-09 16:00:00	AAPL	Stock	27.72	27.755	27.447	27.755	8927008.0
2016-11-09 16:30:00	AAPL	Stock	27.7525	27.785	27.72	27.72	2717036.0
2016-11-09 17:00:00	AAPL	Stock	27.7725	27.7875	27.7675	27.7775	26320.0
2016-11-09 17:30:00	AAPL	Stock	27.78	27.78	27.765	27.7675	11400.0
2016-11-09 18:00:00	AAPL	Stock	27.7675	27.7675	27.72	27.725	13544.0
2016-11-09 18:30:00	AAPL	Stock	27.7375	27.75	27.725	27.75	13296.0
2016-11-09 19:00:00	AAPL	Stock	27.7675	27.7675	27.735	27.735	8940.0
2016-11-09 19:30:00	AAPL	Stock	27.735	27.775	27.735	27.75	12624.0
2016-11-09 04:00:00	MSFT	Stock	59.5	59.5	59.0	59.0	2600.0
2016-11-09 04:30:00	MSFT	Stock	59.02	59.1	59.02	59.05	1296.0
2016-11-09 05:00:00	MSFT	Stock	59.15	59.29	59.15	59.15	2975.0
2016-11-09 05:30:00	MSFT	Stock	59.15	59.28	59.15	59.28	1000.0
2016-11-09 06:00:00	MSFT	Stock	59.2	59.2	58.8	58.98	21175.0
2016-11-09 06:30:00	MSFT	Stock	58.81	59.1	58.81	59.09	19516.0
2016-11-09 07:00:00	MSFT	Stock	59.17	59.7	59.17	59.7	67853.0
2016-11-09 07:30:00	MSFT	Stock	59.53	60.3	59.5	60.0	50390.0
2016-11-09 08:00:00	MSFT	Stock	60.0	60.29	58.51	60.0	127425.0
2016-11-09 08:30:00	MSFT	Stock	60.0	60.17	59.5	59.64	64529.0
2016-11-09 09:00:00	MSFT	Stock	59.63	60.29	59.6	60.01	124943.0
2016-11-09 09:30:00	MSFT	Stock	60.0	60.59	59.2	60.068	10044102.0
2016-11-09 10:00:00	MSFT	Stock	60.07	60.11	59.53	59.805	3541990.0
2016-11-09 10:30:00	MSFT	Stock	59.79	59.87	59.52	59.81	3175532.0
2016-11-09 11:00:00	MSFT	Stock	59.81	60.165	59.69	60.1	3999337.0
2016-11-09 11:30:00	MSFT	Stock	60.1	60.44	60.03	60.295	2520192.0
2016-11-09 12:00:00	MSFT	Stock	60.3	60.475	60.12	60.42	2483136.0
2016-11-09 12:30:00	MSFT	Stock	60.42	60.51	60.31	60.485	1655178.0

> showing 50 of 85,981 rows — these rows as CSV

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