PREVIEW / stock_30min / 2019-11-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-08.parquet
  size:    1.7 MB
  rows:    83,847
  symbols: 2,501

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
2019-11-08 04:00:00	AAPL	Stock	64.72	64.75	64.72	64.72	4364.0
2019-11-08 05:00:00	AAPL	Stock	64.675	64.7	64.675	64.7	3264.0
2019-11-08 05:30:00	AAPL	Stock	64.6975	64.75	64.6975	64.7325	7872.0
2019-11-08 06:00:00	AAPL	Stock	64.6825	64.725	64.6825	64.725	7340.0
2019-11-08 06:30:00	AAPL	Stock	64.73	64.775	64.7025	64.775	10956.0
2019-11-08 07:00:00	AAPL	Stock	64.7825	64.8325	64.7375	64.8175	55080.0
2019-11-08 07:30:00	AAPL	Stock	64.8175	64.8175	64.675	64.7	48944.0
2019-11-08 08:00:00	AAPL	Stock	64.7625	64.8575	64.69	64.735	127384.0
2019-11-08 08:30:00	AAPL	Stock	64.725	64.7625	64.69	64.75	102560.0
2019-11-08 09:00:00	AAPL	Stock	64.7575	64.775	64.6675	64.675	216056.0
2019-11-08 09:30:00	AAPL	Stock	64.675	64.8348	64.355	64.37	9778708.0
2019-11-08 10:00:00	AAPL	Stock	64.37	64.64	64.2125	64.6305	7477156.0
2019-11-08 10:30:00	AAPL	Stock	64.6305	64.6475	64.478	64.6475	3687532.0
2019-11-08 11:00:00	AAPL	Stock	64.6462	64.6925	64.4825	64.5537	2576708.0
2019-11-08 11:30:00	AAPL	Stock	64.5525	64.6425	64.5375	64.63	1848936.0
2019-11-08 12:00:00	AAPL	Stock	64.6375	64.6575	64.5875	64.615	1476036.0
2019-11-08 12:30:00	AAPL	Stock	64.615	64.7875	64.6025	64.7835	2377412.0
2019-11-08 13:00:00	AAPL	Stock	64.7825	64.905	64.7625	64.81	3032808.0
2019-11-08 13:30:00	AAPL	Stock	64.8118	64.8175	64.715	64.72	2003436.0
2019-11-08 14:00:00	AAPL	Stock	64.7225	64.815	64.6975	64.8062	1805240.0
2019-11-08 14:30:00	AAPL	Stock	64.805	64.8525	64.7675	64.81	1959904.0
2019-11-08 15:00:00	AAPL	Stock	64.8075	64.985	64.8	64.9662	3868128.0
2019-11-08 15:30:00	AAPL	Stock	64.9675	65.11	64.8775	65.035	9278780.0
2019-11-08 16:00:00	AAPL	Stock	65.035	65.045	64.99	65.005	5623196.0
2019-11-08 16:30:00	AAPL	Stock	65.0	65.035	65.0	65.005	255728.0
2019-11-08 17:00:00	AAPL	Stock	65.0025	65.02	65.0	65.0175	28288.0
2019-11-08 17:30:00	AAPL	Stock	65.0025	65.015	65.0	65.0025	14108.0
2019-11-08 18:00:00	AAPL	Stock	65.005	65.0125	65.005	65.005	6212.0
2019-11-08 18:30:00	AAPL	Stock	65.0075	65.0075	65.0025	65.0025	15056.0
2019-11-08 19:00:00	AAPL	Stock	65.005	65.0075	65.0025	65.0075	29632.0
2019-11-08 19:30:00	AAPL	Stock	65.0075	65.025	65.0	65.0075	40468.0
2019-11-08 04:00:00	MSFT	Stock	144.26	144.26	144.26	144.26	100.0
2019-11-08 04:30:00	MSFT	Stock	144.24	144.5	144.19	144.27	603.0
2019-11-08 05:00:00	MSFT	Stock	144.38	144.38	144.38	144.38	100.0
2019-11-08 05:30:00	MSFT	Stock	144.5	144.51	144.5	144.51	521.0
2019-11-08 06:00:00	MSFT	Stock	144.35	144.48	144.3	144.3	835.0
2019-11-08 06:30:00	MSFT	Stock	144.3	144.3	144.3	144.3	249.0
2019-11-08 07:00:00	MSFT	Stock	144.35	144.48	144.32	144.35	5829.0
2019-11-08 07:30:00	MSFT	Stock	144.41	144.47	144.02	144.05	7047.0
2019-11-08 08:00:00	MSFT	Stock	144.46	144.46	144.0	144.1	26539.0
2019-11-08 08:30:00	MSFT	Stock	144.09	144.09	143.9	144.02	9160.0
2019-11-08 09:00:00	MSFT	Stock	144.06	144.15	143.95	143.95	36573.0
2019-11-08 09:30:00	MSFT	Stock	144.0	144.5	143.85	144.14	1567657.0
2019-11-08 10:00:00	MSFT	Stock	144.15	144.28	143.76	144.24	1009306.0
2019-11-08 10:30:00	MSFT	Stock	144.25	144.54	144.12	144.399	660454.0
2019-11-08 11:00:00	MSFT	Stock	144.4	144.74	144.31	144.555	761506.0
2019-11-08 11:30:00	MSFT	Stock	144.56	144.75	144.535	144.71	489685.0
2019-11-08 12:00:00	MSFT	Stock	144.702	145.0	144.68	145.0	740050.0
2019-11-08 12:30:00	MSFT	Stock	144.99	145.4	144.99	145.07	1368402.0
2019-11-08 13:00:00	MSFT	Stock	145.08	145.24	145.03	145.11	513620.0

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

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