PREVIEW / stock_30min / 2018-07-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-30.parquet
  size:    1.7 MB
  rows:    83,845
  symbols: 2,818

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-07-30 04:00:00	AAPL	Stock	47.75	47.75	47.7	47.7	19404.0
2018-07-30 04:30:00	AAPL	Stock	47.9675	47.9675	47.745	47.745	800.0
2018-07-30 05:00:00	AAPL	Stock	47.75	47.9	47.75	47.7925	10708.0
2018-07-30 05:30:00	AAPL	Stock	47.7925	47.8575	47.75	47.825	29168.0
2018-07-30 06:00:00	AAPL	Stock	47.825	47.825	47.795	47.795	2748.0
2018-07-30 06:30:00	AAPL	Stock	47.795	47.85	47.795	47.85	5088.0
2018-07-30 07:00:00	AAPL	Stock	47.815	47.9	47.8	47.8375	106392.0
2018-07-30 07:30:00	AAPL	Stock	47.85	47.95	47.85	47.9125	103336.0
2018-07-30 08:00:00	AAPL	Stock	47.85	48.0	47.8375	47.975	253560.0
2018-07-30 08:30:00	AAPL	Stock	47.99	48.0	47.94	47.95	89272.0
2018-07-30 09:00:00	AAPL	Stock	47.94	48.025	47.8825	47.9625	246600.0
2018-07-30 09:30:00	AAPL	Stock	47.995	48.05	47.4375	47.475	11473108.0
2018-07-30 10:00:00	AAPL	Stock	47.47	47.5925	47.45	47.525	5824108.0
2018-07-30 10:30:00	AAPL	Stock	47.5225	47.5292	47.3525	47.4075	4693328.0
2018-07-30 11:00:00	AAPL	Stock	47.405	47.4825	47.3625	47.435	5112996.0
2018-07-30 11:30:00	AAPL	Stock	47.4375	47.52	47.385	47.4925	3765504.0
2018-07-30 12:00:00	AAPL	Stock	47.4925	47.505	47.4138	47.445	2891408.0
2018-07-30 12:30:00	AAPL	Stock	47.4475	47.4775	47.2675	47.385	4305420.0
2018-07-30 13:00:00	AAPL	Stock	47.3862	47.5325	47.3128	47.5025	4450912.0
2018-07-30 13:30:00	AAPL	Stock	47.505	47.5275	47.4375	47.491	3096108.0
2018-07-30 14:00:00	AAPL	Stock	47.4925	47.55	47.4475	47.4625	2166240.0
2018-07-30 14:30:00	AAPL	Stock	47.4648	47.5625	47.42	47.4588	2820104.0
2018-07-30 15:00:00	AAPL	Stock	47.46	47.4835	47.4125	47.465	3528296.0
2018-07-30 15:30:00	AAPL	Stock	47.466	47.5325	47.42	47.485	9556000.0
2018-07-30 16:00:00	AAPL	Stock	47.43	47.52	47.43	47.445	7574520.0
2018-07-30 16:30:00	AAPL	Stock	47.465	47.52	47.445	47.5125	373960.0
2018-07-30 17:00:00	AAPL	Stock	47.5	47.525	47.3825	47.415	122100.0
2018-07-30 17:30:00	AAPL	Stock	47.4125	47.47	47.41	47.465	46968.0
2018-07-30 18:00:00	AAPL	Stock	47.4675	47.4975	47.4675	47.485	40116.0
2018-07-30 18:30:00	AAPL	Stock	47.4725	47.525	47.4725	47.5	25928.0
2018-07-30 19:00:00	AAPL	Stock	47.5225	47.5225	47.4875	47.4875	29208.0
2018-07-30 19:30:00	AAPL	Stock	47.5125	47.535	47.4875	47.535	33104.0
2018-07-30 04:00:00	MSFT	Stock	107.55	107.55	107.55	107.55	100.0
2018-07-30 05:00:00	MSFT	Stock	107.52	107.55	107.37	107.37	3410.0
2018-07-30 05:30:00	MSFT	Stock	107.64	107.64	107.28	107.3	4481.0
2018-07-30 06:00:00	MSFT	Stock	107.3	107.3	107.28	107.28	1082.0
2018-07-30 07:00:00	MSFT	Stock	107.48	107.48	107.12	107.18	16904.0
2018-07-30 07:30:00	MSFT	Stock	107.22	107.27	107.01	107.27	3099.0
2018-07-30 08:00:00	MSFT	Stock	107.432	107.75	107.06	107.75	22367.0
2018-07-30 08:30:00	MSFT	Stock	107.78	107.85	107.6	107.63	12314.0
2018-07-30 09:00:00	MSFT	Stock	107.63	107.704	107.17	107.19	38437.0
2018-07-30 09:30:00	MSFT	Stock	107.16	107.53	105.24	105.4	5095118.0
2018-07-30 10:00:00	MSFT	Stock	105.41	106.21	105.28	106.1	3602879.0
2018-07-30 10:30:00	MSFT	Stock	106.1	106.13	105.52	105.585	2146834.0
2018-07-30 11:00:00	MSFT	Stock	105.58	106.025	105.349	105.756	2072851.0
2018-07-30 11:30:00	MSFT	Stock	105.76	106.04	105.64	105.9	1259523.0
2018-07-30 12:00:00	MSFT	Stock	105.9	105.9	105.31	105.45	1357789.0
2018-07-30 12:30:00	MSFT	Stock	105.45	105.49	104.76	105.045	2167203.0
2018-07-30 13:00:00	MSFT	Stock	105.04	105.66	105.02	105.59	1510250.0
2018-07-30 13:30:00	MSFT	Stock	105.59	105.76	105.39	105.715	1139996.0

> showing 50 of 83,845 rows — these rows as CSV

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