PREVIEW / stock_30min / 2019-08-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-01.parquet
  size:    1.8 MB
  rows:    87,234
  symbols: 2,572

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-01 04:00:00	AAPL	Stock	53.5	53.5	53.485	53.4875	12824.0
2019-08-01 04:30:00	AAPL	Stock	53.45	53.45	53.445	53.45	4180.0
2019-08-01 05:00:00	AAPL	Stock	53.52	53.55	53.52	53.55	12040.0
2019-08-01 05:30:00	AAPL	Stock	53.5675	53.625	53.5675	53.625	9912.0
2019-08-01 06:00:00	AAPL	Stock	53.625	53.675	53.625	53.675	15568.0
2019-08-01 06:30:00	AAPL	Stock	53.675	53.7075	53.575	53.625	13664.0
2019-08-01 07:00:00	AAPL	Stock	53.62	53.6375	53.5375	53.5625	93920.0
2019-08-01 07:30:00	AAPL	Stock	53.59	53.7	53.555	53.6375	145168.0
2019-08-01 08:00:00	AAPL	Stock	53.6425	53.715	53.1275	53.5275	355260.0
2019-08-01 08:30:00	AAPL	Stock	53.53	53.6125	53.53	53.58	108844.0
2019-08-01 09:00:00	AAPL	Stock	53.58	53.61	53.4025	53.54	325508.0
2019-08-01 09:30:00	AAPL	Stock	53.455	53.9725	53.455	53.7325	20244052.0
2019-08-01 10:00:00	AAPL	Stock	53.7275	54.215	53.6875	54.21	11209240.0
2019-08-01 10:30:00	AAPL	Stock	54.21	54.3975	54.125	54.3038	9977052.0
2019-08-01 11:00:00	AAPL	Stock	54.305	54.4425	54.2175	54.4125	7885288.0
2019-08-01 11:30:00	AAPL	Stock	54.415	54.5075	54.2625	54.3772	7010644.0
2019-08-01 12:00:00	AAPL	Stock	54.3775	54.3892	54.225	54.327	5682536.0
2019-08-01 12:30:00	AAPL	Stock	54.33	54.3425	54.165	54.1925	3909408.0
2019-08-01 13:00:00	AAPL	Stock	54.195	54.2462	53.5975	53.645	6314068.0
2019-08-01 13:30:00	AAPL	Stock	53.62	53.8825	52.05	52.4475	32864944.0
2019-08-01 14:00:00	AAPL	Stock	52.455	52.535	51.686	52.065	22282916.0
2019-08-01 14:30:00	AAPL	Stock	52.06	52.6725	51.8975	52.4975	17358680.0
2019-08-01 15:00:00	AAPL	Stock	52.5	52.575	52.13	52.26	13177800.0
2019-08-01 15:30:00	AAPL	Stock	52.255	52.4425	51.875	52.115	17903468.0
2019-08-01 16:00:00	AAPL	Stock	52.115	53.4458	52.0225	52.0925	7106296.0
2019-08-01 16:30:00	AAPL	Stock	52.095	52.1475	52.0	52.025	149280.0
2019-08-01 17:00:00	AAPL	Stock	52.0125	52.0475	51.985	52.045	72900.0
2019-08-01 17:30:00	AAPL	Stock	52.045	52.0875	52.0375	52.0875	18572.0
2019-08-01 18:00:00	AAPL	Stock	52.075	52.1	51.8775	51.885	138128.0
2019-08-01 18:30:00	AAPL	Stock	51.885	51.885	51.7525	51.795	134748.0
2019-08-01 19:00:00	AAPL	Stock	51.795	51.855	51.78	51.81	67396.0
2019-08-01 19:30:00	AAPL	Stock	51.8	51.82	51.6875	51.71	163356.0
2019-08-01 04:00:00	MSFT	Stock	136.96	137.0	136.95	137.0	3500.0
2019-08-01 04:30:00	MSFT	Stock	136.88	137.0	136.87	137.0	2656.0
2019-08-01 05:00:00	MSFT	Stock	136.98	137.4	136.95	137.34	5688.0
2019-08-01 05:30:00	MSFT	Stock	137.4	137.44	137.25	137.44	4258.0
2019-08-01 06:00:00	MSFT	Stock	137.5	137.5	137.32	137.42	1603.0
2019-08-01 06:30:00	MSFT	Stock	137.45	137.49	137.3	137.3	1575.0
2019-08-01 07:00:00	MSFT	Stock	137.14	137.26	137.09	137.23	21694.0
2019-08-01 07:30:00	MSFT	Stock	137.23	137.45	137.13	137.25	11770.0
2019-08-01 08:00:00	MSFT	Stock	137.2	137.44	136.27	137.01	63067.0
2019-08-01 08:30:00	MSFT	Stock	136.95	137.29	136.95	137.15	8720.0
2019-08-01 09:00:00	MSFT	Stock	137.11	137.19	136.8	137.03	47967.0
2019-08-01 09:30:00	MSFT	Stock	136.97	138.83	136.93	138.805	3899958.0
2019-08-01 10:00:00	MSFT	Stock	138.8	139.41	138.603	139.4	2688423.0
2019-08-01 10:30:00	MSFT	Stock	139.4	140.33	139.22	140.3	2408333.0
2019-08-01 11:00:00	MSFT	Stock	140.3	140.79	140.16	140.79	2497905.0
2019-08-01 11:30:00	MSFT	Stock	140.78	140.938	140.53	140.55	1891118.0
2019-08-01 12:00:00	MSFT	Stock	140.574	140.59	140.26	140.57	1260534.0
2019-08-01 12:30:00	MSFT	Stock	140.565	140.74	140.43	140.651	932127.0

> showing 50 of 87,234 rows — these rows as CSV

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