PREVIEW / stock_30min / 2019-10-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-22.parquet
  size:    1.7 MB
  rows:    83,072
  symbols: 2,493

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-10-22 04:00:00	AAPL	Stock	60.1275	60.135	60.1275	60.135	4656.0
2019-10-22 05:00:00	AAPL	Stock	60.095	60.135	60.095	60.135	5688.0
2019-10-22 05:30:00	AAPL	Stock	60.1925	60.1975	60.1925	60.1975	1600.0
2019-10-22 06:00:00	AAPL	Stock	60.215	60.2175	60.1525	60.1525	6096.0
2019-10-22 06:30:00	AAPL	Stock	60.1725	60.1825	60.1725	60.1825	5600.0
2019-10-22 07:00:00	AAPL	Stock	60.215	60.235	60.17	60.1875	51712.0
2019-10-22 07:30:00	AAPL	Stock	60.2125	60.3375	60.19	60.3	125792.0
2019-10-22 08:00:00	AAPL	Stock	60.2125	60.3725	60.175	60.3375	311052.0
2019-10-22 08:30:00	AAPL	Stock	60.345	60.3675	60.295	60.2975	117960.0
2019-10-22 09:00:00	AAPL	Stock	60.295	60.32	60.2325	60.29	230852.0
2019-10-22 09:30:00	AAPL	Stock	60.28	60.4875	60.075	60.2562	13377584.0
2019-10-22 10:00:00	AAPL	Stock	60.26	60.39	60.175	60.38	5250756.0
2019-10-22 10:30:00	AAPL	Stock	60.3775	60.46	60.365	60.39	3349160.0
2019-10-22 11:00:00	AAPL	Stock	60.3925	60.44	60.2675	60.2775	3912764.0
2019-10-22 11:30:00	AAPL	Stock	60.275	60.405	60.2305	60.2975	3685924.0
2019-10-22 12:00:00	AAPL	Stock	60.2985	60.437	60.262	60.43	2776636.0
2019-10-22 12:30:00	AAPL	Stock	60.43	60.4855	60.39	60.4845	2378856.0
2019-10-22 13:00:00	AAPL	Stock	60.4825	60.495	60.3325	60.3888	3073688.0
2019-10-22 13:30:00	AAPL	Stock	60.3875	60.49	60.3825	60.485	2883148.0
2019-10-22 14:00:00	AAPL	Stock	60.4825	60.55	60.4285	60.4745	4962264.0
2019-10-22 14:30:00	AAPL	Stock	60.4825	60.5075	60.0875	60.1875	6602328.0
2019-10-22 15:00:00	AAPL	Stock	60.1875	60.26	60.04	60.2075	5029184.0
2019-10-22 15:30:00	AAPL	Stock	60.205	60.2525	59.9055	59.9925	7020140.0
2019-10-22 16:00:00	AAPL	Stock	59.99	60.0425	59.725	59.7925	4104900.0
2019-10-22 16:30:00	AAPL	Stock	59.81	59.99	59.675	59.725	314832.0
2019-10-22 17:00:00	AAPL	Stock	59.7	59.8425	59.6875	59.7625	33284.0
2019-10-22 17:30:00	AAPL	Stock	59.775	59.99	59.775	59.8025	16788.0
2019-10-22 18:00:00	AAPL	Stock	59.8025	59.875	59.8025	59.8375	22308.0
2019-10-22 18:30:00	AAPL	Stock	59.8275	59.8875	59.81	59.81	11136.0
2019-10-22 19:00:00	AAPL	Stock	59.805	59.8675	59.8025	59.8375	50712.0
2019-10-22 19:30:00	AAPL	Stock	59.8475	59.8625	59.75	59.755	64132.0
2019-10-22 05:00:00	MSFT	Stock	138.66	138.66	138.66	138.66	300.0
2019-10-22 05:30:00	MSFT	Stock	138.8	138.8	138.79	138.79	953.0
2019-10-22 06:00:00	MSFT	Stock	138.8	138.87	138.8	138.87	305.0
2019-10-22 07:00:00	MSFT	Stock	138.75	138.81	138.68	138.72	4768.0
2019-10-22 07:30:00	MSFT	Stock	138.8	138.95	138.75	138.9	9754.0
2019-10-22 08:00:00	MSFT	Stock	138.8	138.93	138.72	138.9	19682.0
2019-10-22 08:30:00	MSFT	Stock	138.86	138.9	138.86	138.86	15200.0
2019-10-22 09:00:00	MSFT	Stock	138.89	139.03	138.86	138.98	23491.0
2019-10-22 09:30:00	MSFT	Stock	138.96	140.01	138.93	139.38	2922366.0
2019-10-22 10:00:00	MSFT	Stock	139.39	139.538	138.99	139.216	1573282.0
2019-10-22 10:30:00	MSFT	Stock	139.218	139.565	138.98	139.03	1153339.0
2019-10-22 11:00:00	MSFT	Stock	139.02	139.025	137.99	138.093	1645142.0
2019-10-22 11:30:00	MSFT	Stock	138.1	138.29	137.73	137.778	1182454.0
2019-10-22 12:00:00	MSFT	Stock	137.78	138.11	137.71	137.875	1344167.0
2019-10-22 12:30:00	MSFT	Stock	137.878	137.93	137.52	137.925	1367103.0
2019-10-22 13:00:00	MSFT	Stock	137.92	137.92	137.495	137.652	944830.0
2019-10-22 13:30:00	MSFT	Stock	137.65	137.68	137.03	137.25	1059595.0
2019-10-22 14:00:00	MSFT	Stock	137.24	137.65	137.19	137.48	1242036.0
2019-10-22 14:30:00	MSFT	Stock	137.485	137.53	136.95	137.055	1721124.0

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

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