PREVIEW / stock_30min / 2019-08-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-09.parquet
  size:    1.7 MB
  rows:    82,352
  symbols: 2,544

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-08-09 04:00:00	AAPL	Stock	50.375	50.375	50.25	50.25	19440.0
2019-08-09 04:30:00	AAPL	Stock	50.25	50.2975	50.25	50.2975	800.0
2019-08-09 05:00:00	AAPL	Stock	50.2975	50.375	50.2975	50.375	3776.0
2019-08-09 05:30:00	AAPL	Stock	50.2925	50.2975	50.2	50.2125	13384.0
2019-08-09 06:00:00	AAPL	Stock	50.2275	50.275	50.1825	50.1825	8416.0
2019-08-09 06:30:00	AAPL	Stock	50.1825	50.2	50.1825	50.1875	2800.0
2019-08-09 07:00:00	AAPL	Stock	50.25	50.325	50.125	50.1875	104572.0
2019-08-09 07:30:00	AAPL	Stock	50.175	50.35	50.0625	50.13	129948.0
2019-08-09 08:00:00	AAPL	Stock	50.255	50.3625	50.065	50.3237	193676.0
2019-08-09 08:30:00	AAPL	Stock	50.27	50.35	50.215	50.31	118548.0
2019-08-09 09:00:00	AAPL	Stock	50.3075	50.3625	50.25	50.319	153812.0
2019-08-09 09:30:00	AAPL	Stock	50.325	50.625	50.15	50.395	10527708.0
2019-08-09 10:00:00	AAPL	Stock	50.39	50.46	50.13	50.1625	7091672.0
2019-08-09 10:30:00	AAPL	Stock	50.16	50.1763	49.915	50.1325	6889308.0
2019-08-09 11:00:00	AAPL	Stock	50.125	50.1558	49.8225	49.8325	5449984.0
2019-08-09 11:30:00	AAPL	Stock	49.8325	50.06	49.8275	49.9372	5143880.0
2019-08-09 12:00:00	AAPL	Stock	49.9325	50.1275	49.9175	50.0588	3702328.0
2019-08-09 12:30:00	AAPL	Stock	50.0625	50.48	50.03	50.31	5494608.0
2019-08-09 13:00:00	AAPL	Stock	50.3075	50.475	50.268	50.4475	4618004.0
2019-08-09 13:30:00	AAPL	Stock	50.4525	50.605	50.435	50.45	4128432.0
2019-08-09 14:00:00	AAPL	Stock	50.45	50.56	50.4	50.555	2858840.0
2019-08-09 14:30:00	AAPL	Stock	50.56	50.6125	50.4525	50.505	3176740.0
2019-08-09 15:00:00	AAPL	Stock	50.508	50.6675	50.4775	50.6325	4358876.0
2019-08-09 15:30:00	AAPL	Stock	50.6275	50.69	50.21	50.2325	11069264.0
2019-08-09 16:00:00	AAPL	Stock	50.2475	50.305	50.225	50.28	8688808.0
2019-08-09 16:30:00	AAPL	Stock	50.295	50.375	50.2475	50.315	113304.0
2019-08-09 17:00:00	AAPL	Stock	50.325	50.37	50.2475	50.37	18560.0
2019-08-09 17:30:00	AAPL	Stock	50.3225	50.3375	50.305	50.305	8012.0
2019-08-09 18:30:00	AAPL	Stock	50.28	50.305	50.28	50.28	4692.0
2019-08-09 19:00:00	AAPL	Stock	50.295	50.3125	50.28	50.3125	6304.0
2019-08-09 19:30:00	AAPL	Stock	50.3375	50.35	50.275	50.275	6832.0
2019-08-09 04:00:00	MSFT	Stock	138.15	138.15	138.15	138.15	100.0
2019-08-09 04:30:00	MSFT	Stock	138.27	138.27	138.27	138.27	100.0
2019-08-09 05:00:00	MSFT	Stock	138.18	138.18	138.18	138.18	100.0
2019-08-09 05:30:00	MSFT	Stock	138.01	138.01	138.0	138.0	200.0
2019-08-09 06:00:00	MSFT	Stock	137.91	137.91	137.9	137.9	1152.0
2019-08-09 06:30:00	MSFT	Stock	137.87	137.88	137.87	137.88	805.0
2019-08-09 07:00:00	MSFT	Stock	138.0	138.0	137.7	137.95	9216.0
2019-08-09 07:30:00	MSFT	Stock	137.94	138.22	137.76	137.89	4724.0
2019-08-09 08:00:00	MSFT	Stock	137.7	138.35	137.7	138.22	17197.0
2019-08-09 08:30:00	MSFT	Stock	138.15	138.33	138.0	138.3	10404.0
2019-08-09 09:00:00	MSFT	Stock	138.2	138.6	138.2	138.6	5954.0
2019-08-09 09:30:00	MSFT	Stock	138.61	139.38	137.43	137.58	2624538.0
2019-08-09 10:00:00	MSFT	Stock	137.58	137.99	137.22	137.59	1876207.0
2019-08-09 10:30:00	MSFT	Stock	137.58	137.95	137.1	137.795	1383359.0
2019-08-09 11:00:00	MSFT	Stock	137.79	137.88	136.72	136.72	1255107.0
2019-08-09 11:30:00	MSFT	Stock	136.72	137.21	136.46	136.7	1030782.0
2019-08-09 12:00:00	MSFT	Stock	136.68	137.0	136.51	136.75	761433.0
2019-08-09 12:30:00	MSFT	Stock	136.75	137.84	136.66	137.412	1162804.0
2019-08-09 13:00:00	MSFT	Stock	137.41	138.16	137.38	138.015	1183786.0

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

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