PREVIEW / stock_30min / 2018-06-18

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-18.parquet
  size:    1.7 MB
  rows:    84,898
  symbols: 2,835

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
2018-06-18 04:00:00	AAPL	Stock	47.08	47.08	46.9525	46.9525	4528.0
2018-06-18 05:00:00	AAPL	Stock	47.0	47.0475	47.0	47.0425	8324.0
2018-06-18 05:30:00	AAPL	Stock	47.045	47.045	46.9625	47.0025	3728.0
2018-06-18 06:00:00	AAPL	Stock	47.0	47.0	46.9425	46.985	3656.0
2018-06-18 06:30:00	AAPL	Stock	46.9175	46.92	46.9	46.9025	8624.0
2018-06-18 07:00:00	AAPL	Stock	46.935	46.9525	46.895	46.91	71896.0
2018-06-18 07:30:00	AAPL	Stock	46.925	46.95	46.875	46.875	71892.0
2018-06-18 08:00:00	AAPL	Stock	46.9125	46.9475	46.8525	46.9	130496.0
2018-06-18 08:30:00	AAPL	Stock	46.8875	46.9625	46.8875	46.9625	97324.0
2018-06-18 09:00:00	AAPL	Stock	46.96	46.9675	46.875	46.9675	139616.0
2018-06-18 09:30:00	AAPL	Stock	46.9675	47.0825	46.8	47.0188	9508280.0
2018-06-18 10:00:00	AAPL	Stock	47.015	47.0775	46.93	46.9325	5200744.0
2018-06-18 10:30:00	AAPL	Stock	46.935	47.305	46.935	47.2262	5390812.0
2018-06-18 11:00:00	AAPL	Stock	47.225	47.305	47.1925	47.2325	3294204.0
2018-06-18 11:30:00	AAPL	Stock	47.2325	47.29	47.1825	47.23	2798220.0
2018-06-18 12:00:00	AAPL	Stock	47.2275	47.2825	47.195	47.2088	2237048.0
2018-06-18 12:30:00	AAPL	Stock	47.2075	47.2275	47.1575	47.1975	2435724.0
2018-06-18 13:00:00	AAPL	Stock	47.1975	47.275	47.185	47.2675	2372952.0
2018-06-18 13:30:00	AAPL	Stock	47.265	47.305	47.25	47.265	2085612.0
2018-06-18 14:00:00	AAPL	Stock	47.265	47.3025	47.23	47.2675	2568020.0
2018-06-18 14:30:00	AAPL	Stock	47.2688	47.2925	47.2075	47.2425	2053800.0
2018-06-18 15:00:00	AAPL	Stock	47.2425	47.275	47.21	47.2175	2624908.0
2018-06-18 15:30:00	AAPL	Stock	47.2162	47.2475	47.1675	47.19	7422600.0
2018-06-18 16:00:00	AAPL	Stock	47.185	47.2425	47.175	47.19	13021796.0
2018-06-18 16:30:00	AAPL	Stock	47.2	47.2	47.0925	47.175	140724.0
2018-06-18 17:00:00	AAPL	Stock	47.2	47.207	47.1875	47.207	9212.0
2018-06-18 17:30:00	AAPL	Stock	47.1875	47.2	47.1875	47.2	2772.0
2018-06-18 18:30:00	AAPL	Stock	47.1875	47.1875	47.1875	47.1875	500.0
2018-06-18 19:00:00	AAPL	Stock	47.1925	47.2	47.1625	47.185	8824.0
2018-06-18 19:30:00	AAPL	Stock	47.2	47.2	46.925	47.0825	60184.0
2018-06-18 04:00:00	MSFT	Stock	100.01	100.01	99.7	99.7	1103.0
2018-06-18 04:30:00	MSFT	Stock	99.7	99.7	99.7	99.7	100.0
2018-06-18 05:00:00	MSFT	Stock	99.89	99.89	99.86	99.86	600.0
2018-06-18 06:00:00	MSFT	Stock	99.72	99.72	99.52	99.52	953.0
2018-06-18 06:30:00	MSFT	Stock	99.79	99.79	99.55	99.55	420.0
2018-06-18 07:00:00	MSFT	Stock	99.69	99.7	99.04	99.55	9168.0
2018-06-18 07:30:00	MSFT	Stock	99.56	99.6	99.26	99.36	6065.0
2018-06-18 08:00:00	MSFT	Stock	99.601	100.13	99.3	99.7	43143.0
2018-06-18 08:30:00	MSFT	Stock	99.72	100.01	99.61	99.95	58137.0
2018-06-18 09:00:00	MSFT	Stock	99.95	100.19	99.85	100.1	51808.0
2018-06-18 09:30:00	MSFT	Stock	100.05	100.54	99.42	100.3	3567419.0
2018-06-18 10:00:00	MSFT	Stock	100.3	100.85	100.09	100.54	2011996.0
2018-06-18 10:30:00	MSFT	Stock	100.54	101.1	100.49	100.94	1586285.0
2018-06-18 11:00:00	MSFT	Stock	100.93	101.11	100.8	100.87	1129056.0
2018-06-18 11:30:00	MSFT	Stock	100.865	100.915	100.48	100.49	1232881.0
2018-06-18 12:00:00	MSFT	Stock	100.48	100.68	100.48	100.575	894973.0
2018-06-18 12:30:00	MSFT	Stock	100.57	100.63	100.485	100.6	945663.0
2018-06-18 13:00:00	MSFT	Stock	100.595	100.88	100.57	100.795	819354.0
2018-06-18 13:30:00	MSFT	Stock	100.79	100.99	100.76	100.97	798574.0
2018-06-18 14:00:00	MSFT	Stock	100.96	100.98	100.77	100.806	1087192.0

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

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