PREVIEW / stock_30min / 2015-10-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-16.parquet
  size:    1.6 MB
  rows:    80,984
  symbols: 3,419

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-10-16 04:00:00	AAPL	Stock	27.9775	27.9775	27.9775	27.9775	400.0
2015-10-16 04:30:00	AAPL	Stock	27.99	27.99	27.99	27.99	400.0
2015-10-16 05:00:00	AAPL	Stock	28.0025	28.0025	27.985	27.985	2400.0
2015-10-16 06:00:00	AAPL	Stock	27.9575	27.9575	27.95	27.95	3124.0
2015-10-16 06:30:00	AAPL	Stock	27.945	27.945	27.91	27.925	10360.0
2015-10-16 07:00:00	AAPL	Stock	27.9075	27.9075	27.875	27.875	26384.0
2015-10-16 07:30:00	AAPL	Stock	27.8925	27.9	27.89	27.9	10800.0
2015-10-16 08:00:00	AAPL	Stock	27.9075	27.9625	27.875	27.8875	242032.0
2015-10-16 08:30:00	AAPL	Stock	27.8875	27.8925	27.8375	27.8575	331216.0
2015-10-16 09:00:00	AAPL	Stock	27.875	27.9975	27.8375	27.88	2205304.0
2015-10-16 09:30:00	AAPL	Stock	27.945	28.0	27.7875	27.8865	25764008.0
2015-10-16 10:00:00	AAPL	Stock	27.8875	27.97	27.7675	27.8198	14734532.0
2015-10-16 10:30:00	AAPL	Stock	27.82	27.9025	27.7925	27.8675	9728104.0
2015-10-16 11:00:00	AAPL	Stock	27.8675	27.9375	27.84	27.87	8381684.0
2015-10-16 11:30:00	AAPL	Stock	27.8688	27.92	27.805	27.8925	7684936.0
2015-10-16 12:00:00	AAPL	Stock	27.8925	27.8975	27.745	27.7525	8696376.0
2015-10-16 12:30:00	AAPL	Stock	27.755	27.7825	27.6875	27.7652	8713428.0
2015-10-16 13:00:00	AAPL	Stock	27.7675	27.7875	27.7125	27.755	5059832.0
2015-10-16 13:30:00	AAPL	Stock	27.7525	27.7725	27.6675	27.6738	6781028.0
2015-10-16 14:00:00	AAPL	Stock	27.675	27.715	27.6325	27.6775	8464328.0
2015-10-16 14:30:00	AAPL	Stock	27.6798	27.725	27.6625	27.6875	6700944.0
2015-10-16 15:00:00	AAPL	Stock	27.6888	27.7775	27.6888	27.7385	7732280.0
2015-10-16 15:30:00	AAPL	Stock	27.74	27.7725	27.7125	27.755	16535616.0
2015-10-16 16:00:00	AAPL	Stock	27.76	27.775	27.74	27.755	6678688.0
2015-10-16 16:30:00	AAPL	Stock	27.755	27.755	27.7475	27.7525	94932.0
2015-10-16 17:00:00	AAPL	Stock	27.75	27.7525	27.7475	27.7525	39600.0
2015-10-16 17:30:00	AAPL	Stock	27.7525	27.76	27.745	27.745	1403000.0
2015-10-16 18:00:00	AAPL	Stock	27.75	27.755	27.74	27.74	21440.0
2015-10-16 18:30:00	AAPL	Stock	27.74	27.7525	27.74	27.7525	12056.0
2015-10-16 19:00:00	AAPL	Stock	27.7425	27.755	27.7375	27.755	21676.0
2015-10-16 19:30:00	AAPL	Stock	27.7525	27.7575	27.74	27.74	12872.0
2015-10-16 04:00:00	MSFT	Stock	47.12	47.12	47.12	47.12	1700.0
2015-10-16 07:30:00	MSFT	Stock	47.01	47.01	47.01	47.01	400.0
2015-10-16 08:00:00	MSFT	Stock	47.01	47.1	47.01	47.1	500.0
2015-10-16 08:30:00	MSFT	Stock	47.09	47.1	47.09	47.1	1500.0
2015-10-16 09:00:00	MSFT	Stock	47.09	47.28	47.06	47.1	610971.0
2015-10-16 09:30:00	MSFT	Stock	47.02	47.3	46.897	47.07	4927823.0
2015-10-16 10:00:00	MSFT	Stock	47.07	47.12	47.01	47.11	1369227.0
2015-10-16 10:30:00	MSFT	Stock	47.11	47.33	47.1	47.269	1201533.0
2015-10-16 11:00:00	MSFT	Stock	47.27	47.38	47.18	47.2	1365267.0
2015-10-16 11:30:00	MSFT	Stock	47.201	47.27	47.12	47.235	890258.0
2015-10-16 12:00:00	MSFT	Stock	47.23	47.24	47.1	47.17	862610.0
2015-10-16 12:30:00	MSFT	Stock	47.16	47.19	47.08	47.15	579076.0
2015-10-16 13:00:00	MSFT	Stock	47.156	47.19	47.12	47.15	485115.0
2015-10-16 13:30:00	MSFT	Stock	47.155	47.17	47.1	47.11	576445.0
2015-10-16 14:00:00	MSFT	Stock	47.115	47.26	47.04	47.25	835144.0
2015-10-16 14:30:00	MSFT	Stock	47.25	47.337	47.22	47.224	1368990.0
2015-10-16 15:00:00	MSFT	Stock	47.225	47.32	47.22	47.3	1282574.0
2015-10-16 15:30:00	MSFT	Stock	47.3	47.54	47.27	47.5	4548874.0
2015-10-16 16:00:00	MSFT	Stock	47.49	47.51	47.35	47.47	3870000.0

> showing 50 of 80,984 rows — these rows as CSV

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