PREVIEW / stock_30min / 2018-08-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-13.parquet
  size:    1.7 MB
  rows:    82,300
  symbols: 2,819

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-08-13 04:00:00	AAPL	Stock	51.675	51.7775	51.65	51.7775	1200.0
2018-08-13 05:30:00	AAPL	Stock	51.795	51.795	51.795	51.795	1780.0
2018-08-13 06:00:00	AAPL	Stock	51.795	51.82	51.795	51.82	1200.0
2018-08-13 06:30:00	AAPL	Stock	51.8125	51.8125	51.8125	51.8125	2800.0
2018-08-13 07:00:00	AAPL	Stock	51.8425	51.8675	51.83	51.85	43208.0
2018-08-13 07:30:00	AAPL	Stock	51.8375	51.9625	51.825	51.935	60884.0
2018-08-13 08:00:00	AAPL	Stock	51.8375	52.0125	51.79	52.0125	157644.0
2018-08-13 08:30:00	AAPL	Stock	52.0125	52.0125	51.925	51.9375	126320.0
2018-08-13 09:00:00	AAPL	Stock	51.9425	51.9875	51.91	51.915	67920.0
2018-08-13 09:30:00	AAPL	Stock	51.925	52.3725	51.925	52.3525	11181024.0
2018-08-13 10:00:00	AAPL	Stock	52.355	52.738	52.3425	52.68	15759228.0
2018-08-13 10:30:00	AAPL	Stock	52.68	52.7375	52.5275	52.585	8249056.0
2018-08-13 11:00:00	AAPL	Stock	52.5875	52.6275	52.36	52.3975	7105008.0
2018-08-13 11:30:00	AAPL	Stock	52.3985	52.5125	52.3125	52.315	6149464.0
2018-08-13 12:00:00	AAPL	Stock	52.315	52.439	52.2475	52.2925	5891556.0
2018-08-13 12:30:00	AAPL	Stock	52.2912	52.395	52.25	52.31	3794280.0
2018-08-13 13:00:00	AAPL	Stock	52.31	52.3675	52.1875	52.3375	3811548.0
2018-08-13 13:30:00	AAPL	Stock	52.3425	52.4115	52.3175	52.38	3031096.0
2018-08-13 14:00:00	AAPL	Stock	52.38	52.4975	52.3775	52.4625	3842112.0
2018-08-13 14:30:00	AAPL	Stock	52.4665	52.48	52.315	52.3425	3378416.0
2018-08-13 15:00:00	AAPL	Stock	52.3402	52.39	52.2525	52.2975	4107216.0
2018-08-13 15:30:00	AAPL	Stock	52.2975	52.39	52.215	52.215	8754732.0
2018-08-13 16:00:00	AAPL	Stock	52.2175	52.2975	52.2175	52.2275	6317756.0
2018-08-13 16:30:00	AAPL	Stock	52.2305	52.25	52.2175	52.25	30588.0
2018-08-13 17:00:00	AAPL	Stock	52.2475	52.27	52.245	52.245	4976.0
2018-08-13 17:30:00	AAPL	Stock	52.235	52.2675	52.235	52.235	6660.0
2018-08-13 18:00:00	AAPL	Stock	52.2375	52.275	52.2375	52.2625	13432.0
2018-08-13 18:30:00	AAPL	Stock	52.275	52.285	52.2175	52.28	25088.0
2018-08-13 19:00:00	AAPL	Stock	52.29	52.3	52.29	52.3	13144.0
2018-08-13 19:30:00	AAPL	Stock	52.29	52.315	52.255	52.275	29392.0
2018-08-13 04:00:00	MSFT	Stock	108.88	108.98	108.88	108.98	200.0
2018-08-13 04:30:00	MSFT	Stock	108.75	108.89	108.72	108.89	1364.0
2018-08-13 05:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	1000.0
2018-08-13 05:30:00	MSFT	Stock	108.89	108.89	108.89	108.89	1531.0
2018-08-13 06:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	600.0
2018-08-13 06:30:00	MSFT	Stock	108.9	108.9	108.9	108.9	100.0
2018-08-13 07:00:00	MSFT	Stock	108.9	108.9	108.9	108.9	425.0
2018-08-13 07:30:00	MSFT	Stock	108.9	109.04	108.79	109.04	24010.0
2018-08-13 08:00:00	MSFT	Stock	108.95	109.19	108.75	109.19	19533.0
2018-08-13 08:30:00	MSFT	Stock	109.2	109.21	109.05	109.1	10986.0
2018-08-13 09:00:00	MSFT	Stock	109.06	109.29	109.01	109.25	8039.0
2018-08-13 09:30:00	MSFT	Stock	109.26	109.37	108.72	109.07	1843889.0
2018-08-13 10:00:00	MSFT	Stock	109.07	109.48	108.89	109.445	1374242.0
2018-08-13 10:30:00	MSFT	Stock	109.45	109.58	109.26	109.302	1041344.0
2018-08-13 11:00:00	MSFT	Stock	109.305	109.37	108.69	108.745	1008735.0
2018-08-13 11:30:00	MSFT	Stock	108.74	108.83	108.38	108.55	913242.0
2018-08-13 12:00:00	MSFT	Stock	108.54	108.71	108.235	108.355	829303.0
2018-08-13 12:30:00	MSFT	Stock	108.35	108.519	108.28	108.39	716529.0
2018-08-13 13:00:00	MSFT	Stock	108.38	108.487	108.16	108.395	738166.0
2018-08-13 13:30:00	MSFT	Stock	108.4	108.55	108.36	108.45	777472.0

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

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