PREVIEW / stock_30min / 2019-09-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-10.parquet
  size:    1.7 MB
  rows:    84,833
  symbols: 2,559

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-09-10 04:00:00	AAPL	Stock	53.255	53.2875	53.15	53.175	18112.0
2019-09-10 04:30:00	AAPL	Stock	53.25	53.25	53.205	53.205	3400.0
2019-09-10 05:00:00	AAPL	Stock	53.2875	53.3325	53.275	53.3325	12368.0
2019-09-10 05:30:00	AAPL	Stock	53.3	53.35	53.23	53.35	16012.0
2019-09-10 06:00:00	AAPL	Stock	53.35	53.4	53.35	53.395	8124.0
2019-09-10 06:30:00	AAPL	Stock	53.395	53.4175	53.385	53.4	39696.0
2019-09-10 07:00:00	AAPL	Stock	53.43	53.5725	53.4	53.5	46568.0
2019-09-10 07:30:00	AAPL	Stock	53.495	53.4975	53.3625	53.425	66724.0
2019-09-10 08:00:00	AAPL	Stock	53.4375	53.6	53.4002	53.4575	97172.0
2019-09-10 08:30:00	AAPL	Stock	53.4425	53.5	53.4	53.4	108280.0
2019-09-10 09:00:00	AAPL	Stock	53.405	53.505	53.305	53.4525	202132.0
2019-09-10 09:30:00	AAPL	Stock	53.4525	53.6375	52.9275	53.305	11610448.0
2019-09-10 10:00:00	AAPL	Stock	53.3	53.395	53.19	53.365	4682680.0
2019-09-10 10:30:00	AAPL	Stock	53.37	53.4	53.19	53.2625	3424996.0
2019-09-10 11:00:00	AAPL	Stock	53.2628	53.385	53.2575	53.3175	2668128.0
2019-09-10 11:30:00	AAPL	Stock	53.315	53.605	53.26	53.4825	4695276.0
2019-09-10 12:00:00	AAPL	Stock	53.4925	53.61	53.3225	53.53	3587648.0
2019-09-10 12:30:00	AAPL	Stock	53.5275	53.6575	53.44	53.605	3504372.0
2019-09-10 13:00:00	AAPL	Stock	53.6075	53.95	53.3725	53.7275	12845720.0
2019-09-10 13:30:00	AAPL	Stock	53.7292	53.8678	53.35	53.45	9112500.0
2019-09-10 14:00:00	AAPL	Stock	53.4488	53.7	53.3925	53.5475	7645284.0
2019-09-10 14:30:00	AAPL	Stock	53.545	53.625	53.2925	53.57	6587500.0
2019-09-10 15:00:00	AAPL	Stock	53.5662	53.73	53.5662	53.645	4569676.0
2019-09-10 15:30:00	AAPL	Stock	53.645	54.195	53.6355	54.1925	12058188.0
2019-09-10 16:00:00	AAPL	Stock	54.1925	54.2225	54.1275	54.165	9387460.0
2019-09-10 16:30:00	AAPL	Stock	54.1825	54.2375	54.175	54.2375	212692.0
2019-09-10 17:00:00	AAPL	Stock	54.2375	54.375	54.2125	54.325	593824.0
2019-09-10 17:30:00	AAPL	Stock	54.3375	54.37	54.325	54.37	99892.0
2019-09-10 18:00:00	AAPL	Stock	54.3675	54.3675	54.285	54.285	164648.0
2019-09-10 18:30:00	AAPL	Stock	54.2875	54.3225	54.2	54.2275	152704.0
2019-09-10 19:00:00	AAPL	Stock	54.2375	54.2625	54.225	54.25	40440.0
2019-09-10 19:30:00	AAPL	Stock	54.2625	54.2625	54.2175	54.2175	45064.0
2019-09-10 04:00:00	MSFT	Stock	136.75	136.75	136.55	136.55	200.0
2019-09-10 06:00:00	MSFT	Stock	137.0	137.0	137.0	137.0	1000.0
2019-09-10 06:30:00	MSFT	Stock	137.0	137.27	136.97	136.97	2844.0
2019-09-10 07:00:00	MSFT	Stock	136.97	137.25	136.97	137.25	5707.0
2019-09-10 07:30:00	MSFT	Stock	136.83	136.83	136.83	136.83	200.0
2019-09-10 08:00:00	MSFT	Stock	137.03	137.3	136.75	136.836	15049.0
2019-09-10 08:30:00	MSFT	Stock	136.7	136.85	136.697	136.72	3884.0
2019-09-10 09:00:00	MSFT	Stock	136.8	136.84	136.59	136.73	11295.0
2019-09-10 09:30:00	MSFT	Stock	136.8	136.886	134.71	135.02	3805038.0
2019-09-10 10:00:00	MSFT	Stock	135.03	135.54	134.77	135.355	2439567.0
2019-09-10 10:30:00	MSFT	Stock	135.36	135.59	135.045	135.105	1661245.0
2019-09-10 11:00:00	MSFT	Stock	135.08	135.3	134.51	134.68	1614443.0
2019-09-10 11:30:00	MSFT	Stock	134.67	135.43	134.6	135.246	1485921.0
2019-09-10 12:00:00	MSFT	Stock	135.248	135.89	135.07	135.685	1016663.0
2019-09-10 12:30:00	MSFT	Stock	135.685	136.19	135.66	136.04	737727.0
2019-09-10 13:00:00	MSFT	Stock	136.04	136.07	135.41	135.415	844164.0
2019-09-10 13:30:00	MSFT	Stock	135.41	135.86	135.41	135.58	672011.0
2019-09-10 14:00:00	MSFT	Stock	135.575	135.63	135.125	135.22	828432.0

> showing 50 of 84,833 rows — these rows as CSV

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