PREVIEW / stock_30min / 2018-06-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-07.parquet
  size:    1.7 MB
  rows:    83,491
  symbols: 2,831

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-07 04:00:00	AAPL	Stock	48.5625	48.6125	48.5625	48.6125	4676.0
2018-06-07 04:30:00	AAPL	Stock	48.595	48.595	48.575	48.575	5520.0
2018-06-07 05:00:00	AAPL	Stock	48.575	48.575	48.575	48.575	4036.0
2018-06-07 06:00:00	AAPL	Stock	48.575	48.575	48.575	48.575	3744.0
2018-06-07 07:00:00	AAPL	Stock	48.53	48.575	48.47	48.5375	143324.0
2018-06-07 07:30:00	AAPL	Stock	48.5475	48.5475	48.5025	48.515	48368.0
2018-06-07 08:00:00	AAPL	Stock	48.5	48.575	48.465	48.52	175640.0
2018-06-07 08:30:00	AAPL	Stock	48.5	48.525	48.4875	48.525	36344.0
2018-06-07 09:00:00	AAPL	Stock	48.525	48.525	48.475	48.5125	62464.0
2018-06-07 09:30:00	AAPL	Stock	48.535	48.55	48.2862	48.45	9351732.0
2018-06-07 10:00:00	AAPL	Stock	48.45	48.45	48.24	48.2825	5446496.0
2018-06-07 10:30:00	AAPL	Stock	48.2825	48.3275	48.0838	48.32	6542508.0
2018-06-07 11:00:00	AAPL	Stock	48.3172	48.3725	48.215	48.3275	3448888.0
2018-06-07 11:30:00	AAPL	Stock	48.33	48.35	48.225	48.33	3013564.0
2018-06-07 12:00:00	AAPL	Stock	48.33	48.365	48.275	48.3288	2403316.0
2018-06-07 12:30:00	AAPL	Stock	48.33	48.3525	48.235	48.305	3258864.0
2018-06-07 13:00:00	AAPL	Stock	48.305	48.35	48.26	48.27	2843124.0
2018-06-07 13:30:00	AAPL	Stock	48.2675	48.32	48.1375	48.145	4450204.0
2018-06-07 14:00:00	AAPL	Stock	48.1475	48.27	48.1075	48.2485	3671932.0
2018-06-07 14:30:00	AAPL	Stock	48.2475	48.3725	48.2375	48.34	3169940.0
2018-06-07 15:00:00	AAPL	Stock	48.3425	48.425	48.2725	48.4192	4333716.0
2018-06-07 15:30:00	AAPL	Stock	48.42	48.48	48.3013	48.37	8795516.0
2018-06-07 16:00:00	AAPL	Stock	48.3675	48.39	48.35	48.35	16313340.0
2018-06-07 16:30:00	AAPL	Stock	48.345	48.365	48.3175	48.3175	71568.0
2018-06-07 17:00:00	AAPL	Stock	48.3175	48.3175	48.3025	48.3175	2792.0
2018-06-07 17:30:00	AAPL	Stock	48.305	48.35	48.3	48.325	9572.0
2018-06-07 18:00:00	AAPL	Stock	48.3	48.3	48.3	48.3	800.0
2018-06-07 18:30:00	AAPL	Stock	48.3	48.34	48.3	48.3325	12904.0
2018-06-07 19:00:00	AAPL	Stock	48.3325	48.3325	48.3125	48.3125	2400.0
2018-06-07 19:30:00	AAPL	Stock	48.3275	48.3275	48.25	48.285	24560.0
2018-06-07 05:00:00	MSFT	Stock	102.57	102.64	102.57	102.64	216.0
2018-06-07 05:30:00	MSFT	Stock	102.65	102.65	102.65	102.65	488.0
2018-06-07 06:00:00	MSFT	Stock	102.65	102.65	102.65	102.65	100.0
2018-06-07 06:30:00	MSFT	Stock	102.77	102.77	102.69	102.7	1794.0
2018-06-07 07:00:00	MSFT	Stock	102.56	102.65	102.56	102.6	3086.0
2018-06-07 07:30:00	MSFT	Stock	102.6	102.6	102.56	102.56	9084.0
2018-06-07 08:00:00	MSFT	Stock	102.68	102.68	102.5	102.62	8042.0
2018-06-07 08:30:00	MSFT	Stock	102.6	102.62	102.5	102.51	5161.0
2018-06-07 09:00:00	MSFT	Stock	102.5	102.69	102.5	102.69	7462.0
2018-06-07 09:30:00	MSFT	Stock	102.65	102.69	102.05	102.15	2121308.0
2018-06-07 10:00:00	MSFT	Stock	102.15	102.22	101.63	101.75	1456691.0
2018-06-07 10:30:00	MSFT	Stock	101.75	101.75	100.92	101.56	2718647.0
2018-06-07 11:00:00	MSFT	Stock	101.55	101.8	101.195	101.68	1414470.0
2018-06-07 11:30:00	MSFT	Stock	101.68	101.73	101.365	101.47	1159739.0
2018-06-07 12:00:00	MSFT	Stock	101.47	101.73	101.415	101.704	951662.0
2018-06-07 12:30:00	MSFT	Stock	101.7	101.7	101.085	101.29	1163234.0
2018-06-07 13:00:00	MSFT	Stock	101.28	101.34	100.893	101.03	861568.0
2018-06-07 13:30:00	MSFT	Stock	101.03	101.11	100.51	100.515	1712367.0
2018-06-07 14:00:00	MSFT	Stock	100.52	100.72	100.38	100.62	1813677.0
2018-06-07 14:30:00	MSFT	Stock	100.61	100.94	100.59	100.78	1295391.0

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

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