PREVIEW / stock_30min / 2017-05-17

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-17.parquet
  size:    1.6 MB
  rows:    82,966
  symbols: 3,049

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-05-17 04:00:00	AAPL	Stock	38.6875	38.7375	38.675	38.7	27976.0
2017-05-17 04:30:00	AAPL	Stock	38.725	38.7375	38.6875	38.6875	9660.0
2017-05-17 05:00:00	AAPL	Stock	38.675	38.675	38.675	38.675	7600.0
2017-05-17 05:30:00	AAPL	Stock	38.6275	38.675	38.6275	38.675	11644.0
2017-05-17 06:00:00	AAPL	Stock	38.675	38.675	38.65	38.6625	11248.0
2017-05-17 06:30:00	AAPL	Stock	38.6625	38.71	38.6625	38.71	30816.0
2017-05-17 07:00:00	AAPL	Stock	38.7125	38.735	38.7125	38.7125	22216.0
2017-05-17 07:30:00	AAPL	Stock	38.7225	38.7225	38.6625	38.695	33752.0
2017-05-17 08:00:00	AAPL	Stock	38.6775	38.735	38.5	38.5375	311624.0
2017-05-17 08:30:00	AAPL	Stock	38.5275	38.5425	38.4525	38.4625	347572.0
2017-05-17 09:00:00	AAPL	Stock	38.4625	38.8675	38.385	38.4975	568196.0
2017-05-17 09:30:00	AAPL	Stock	38.4	38.6425	38.3	38.3	19748212.0
2017-05-17 10:00:00	AAPL	Stock	38.3025	38.3678	38.0675	38.13	17239920.0
2017-05-17 10:30:00	AAPL	Stock	38.13	38.175	37.5	37.7312	22444072.0
2017-05-17 11:00:00	AAPL	Stock	37.7325	37.995	37.695	37.92	14618300.0
2017-05-17 11:30:00	AAPL	Stock	37.9225	38.115	37.8875	38.0775	9972724.0
2017-05-17 12:00:00	AAPL	Stock	38.0775	38.1025	37.8825	37.885	6877456.0
2017-05-17 12:30:00	AAPL	Stock	37.8875	38.05	37.8825	37.9825	5474324.0
2017-05-17 13:00:00	AAPL	Stock	37.98	38.035	37.92	37.9275	5275712.0
2017-05-17 13:30:00	AAPL	Stock	37.9275	37.9475	37.755	37.7575	8216008.0
2017-05-17 14:00:00	AAPL	Stock	37.7575	37.8375	37.6225	37.6475	10673308.0
2017-05-17 14:30:00	AAPL	Stock	37.6468	37.695	37.475	37.6075	15536768.0
2017-05-17 15:00:00	AAPL	Stock	37.6075	37.745	37.575	37.6585	11331284.0
2017-05-17 15:30:00	AAPL	Stock	37.655	37.705	37.4275	37.55	22570680.0
2017-05-17 16:00:00	AAPL	Stock	37.5475	37.68	37.5425	37.575	11716648.0
2017-05-17 16:30:00	AAPL	Stock	37.61	37.6175	37.5625	37.6	55104.0
2017-05-17 17:00:00	AAPL	Stock	37.6	37.6175	37.58	37.595	31920.0
2017-05-17 17:30:00	AAPL	Stock	37.6	37.6125	37.57	37.5975	22708.0
2017-05-17 18:00:00	AAPL	Stock	37.575	37.64	37.575	37.6325	103300.0
2017-05-17 18:30:00	AAPL	Stock	37.625	37.6375	37.615	37.6375	32592.0
2017-05-17 19:00:00	AAPL	Stock	37.64	37.69	37.6325	37.675	65240.0
2017-05-17 19:30:00	AAPL	Stock	37.6925	37.7325	37.675	37.7325	76336.0
2017-05-17 05:00:00	MSFT	Stock	69.12	69.12	69.12	69.12	200.0
2017-05-17 06:30:00	MSFT	Stock	69.05	69.05	69.05	69.05	500.0
2017-05-17 07:00:00	MSFT	Stock	69.08	69.15	69.08	69.1	600.0
2017-05-17 07:30:00	MSFT	Stock	69.11	69.11	69.11	69.11	600.0
2017-05-17 08:00:00	MSFT	Stock	69.01	69.11	68.86	68.9	21605.0
2017-05-17 08:30:00	MSFT	Stock	68.9	69.0	68.9	68.99	15903.0
2017-05-17 09:00:00	MSFT	Stock	68.87	68.97	68.63	68.89	46624.0
2017-05-17 09:30:00	MSFT	Stock	68.89	69.1	68.75	68.86	3021502.0
2017-05-17 10:00:00	MSFT	Stock	68.87	68.89	68.6	68.66	1676173.0
2017-05-17 10:30:00	MSFT	Stock	68.65	68.73	68.24	68.285	2065313.0
2017-05-17 11:00:00	MSFT	Stock	68.28	68.5	68.12	68.38	1689697.0
2017-05-17 11:30:00	MSFT	Stock	68.38	68.52	68.29	68.485	1075075.0
2017-05-17 12:00:00	MSFT	Stock	68.487	68.487	68.26	68.28	897900.0
2017-05-17 12:30:00	MSFT	Stock	68.28	68.415	68.28	68.34	1307389.0
2017-05-17 13:00:00	MSFT	Stock	68.346	68.36	68.11	68.12	805013.0
2017-05-17 13:30:00	MSFT	Stock	68.12	68.13	67.92	67.96	1087133.0
2017-05-17 14:00:00	MSFT	Stock	67.96	68.04	67.74	67.78	1611215.0
2017-05-17 14:30:00	MSFT	Stock	67.785	67.89	67.655	67.825	1777954.0

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

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