PREVIEW / stock_30min / 2016-01-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-14.parquet
  size:    1.6 MB
  rows:    84,780
  symbols: 3,406

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-01-14 04:00:00	AAPL	Stock	24.385	24.395	24.275	24.3175	8400.0
2016-01-14 04:30:00	AAPL	Stock	24.3125	24.39	24.2875	24.345	32148.0
2016-01-14 05:00:00	AAPL	Stock	24.35	24.39	24.25	24.25	32032.0
2016-01-14 05:30:00	AAPL	Stock	24.25	24.345	24.25	24.28	15048.0
2016-01-14 06:00:00	AAPL	Stock	24.3125	24.3125	24.175	24.2125	29968.0
2016-01-14 06:30:00	AAPL	Stock	24.22	24.25	24.175	24.215	34624.0
2016-01-14 07:00:00	AAPL	Stock	24.23	24.295	24.2225	24.25	85996.0
2016-01-14 07:30:00	AAPL	Stock	24.255	24.355	24.2425	24.345	145952.0
2016-01-14 08:00:00	AAPL	Stock	24.34	24.345	24.235	24.345	300516.0
2016-01-14 08:30:00	AAPL	Stock	24.345	24.4375	24.3125	24.415	1074180.0
2016-01-14 09:00:00	AAPL	Stock	24.4175	24.5025	24.3475	24.4825	330636.0
2016-01-14 09:30:00	AAPL	Stock	24.49	24.505	23.94	23.995	35472060.0
2016-01-14 10:00:00	AAPL	Stock	23.9852	24.305	23.935	24.3025	27045820.0
2016-01-14 10:30:00	AAPL	Stock	24.2975	24.58	24.2425	24.4775	22295816.0
2016-01-14 11:00:00	AAPL	Stock	24.4825	24.5325	24.3175	24.44	11944712.0
2016-01-14 11:30:00	AAPL	Stock	24.445	24.5825	24.3525	24.5425	10741164.0
2016-01-14 12:00:00	AAPL	Stock	24.5425	24.5875	24.4325	24.4725	8375832.0
2016-01-14 12:30:00	AAPL	Stock	24.48	24.68	24.46	24.6325	10759288.0
2016-01-14 13:00:00	AAPL	Stock	24.6325	24.8375	24.6125	24.8	11797148.0
2016-01-14 13:30:00	AAPL	Stock	24.8025	24.895	24.725	24.868	10295400.0
2016-01-14 14:00:00	AAPL	Stock	24.87	24.9662	24.8578	24.92	12957784.0
2016-01-14 14:30:00	AAPL	Stock	24.9175	25.0438	24.9	25.0125	16030452.0
2016-01-14 15:00:00	AAPL	Stock	25.0125	25.12	25.0	25.0262	15541176.0
2016-01-14 15:30:00	AAPL	Stock	25.0252	25.0325	24.8375	24.8775	25850900.0
2016-01-14 16:00:00	AAPL	Stock	24.88	24.905	24.7105	24.8725	9507888.0
2016-01-14 16:30:00	AAPL	Stock	24.8525	25.034	24.59	24.68	1225612.0
2016-01-14 17:00:00	AAPL	Stock	24.68	24.7375	24.65	24.6875	286360.0
2016-01-14 17:30:00	AAPL	Stock	24.6875	24.6875	24.6675	24.6875	180964.0
2016-01-14 18:00:00	AAPL	Stock	24.6875	24.6875	24.65	24.6875	116120.0
2016-01-14 18:30:00	AAPL	Stock	24.6875	24.6875	24.6625	24.6875	94828.0
2016-01-14 19:00:00	AAPL	Stock	24.6625	24.75	24.6625	24.75	108524.0
2016-01-14 19:30:00	AAPL	Stock	24.75	24.825	24.745	24.8125	123988.0
2016-01-14 05:00:00	MSFT	Stock	51.75	51.75	51.75	51.75	1000.0
2016-01-14 06:00:00	MSFT	Stock	51.74	51.74	51.36	51.36	2964.0
2016-01-14 07:00:00	MSFT	Stock	51.63	51.63	51.58	51.58	900.0
2016-01-14 07:30:00	MSFT	Stock	51.64	51.89	51.6	51.89	5482.0
2016-01-14 08:00:00	MSFT	Stock	51.82	51.98	51.7	51.85	53169.0
2016-01-14 08:30:00	MSFT	Stock	51.81	51.93	51.64	51.88	294759.0
2016-01-14 09:00:00	MSFT	Stock	51.9	52.05	51.9	52.04	34784.0
2016-01-14 09:30:00	MSFT	Stock	52.04	52.09	51.64	51.75	5052278.0
2016-01-14 10:00:00	MSFT	Stock	51.75	52.35	51.57	52.21	5698097.0
2016-01-14 10:30:00	MSFT	Stock	52.205	52.77	52.13	52.47	4719163.0
2016-01-14 11:00:00	MSFT	Stock	52.48	52.64	52.29	52.47	2619234.0
2016-01-14 11:30:00	MSFT	Stock	52.48	52.92	52.345	52.92	2301616.0
2016-01-14 12:00:00	MSFT	Stock	52.92	53.01	52.56	52.82	2055338.0
2016-01-14 12:30:00	MSFT	Stock	52.83	53.0	52.56	52.56	1969516.0
2016-01-14 13:00:00	MSFT	Stock	52.56	53.075	52.45	52.98	3097521.0
2016-01-14 13:30:00	MSFT	Stock	52.98	53.1	52.85	53.032	1892062.0
2016-01-14 14:00:00	MSFT	Stock	53.04	53.08	52.85	53.02	2526383.0
2016-01-14 14:30:00	MSFT	Stock	53.01	53.36	53.0	53.29	2025888.0

> showing 50 of 84,780 rows — these rows as CSV

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