PREVIEW / stock_30min / 2020-02-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-11.parquet
  size:    1.8 MB
  rows:    86,083
  symbols: 2,415

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
2020-02-11 04:00:00	AAPL	Stock	80.5025	80.575	80.4525	80.575	20056.0
2020-02-11 04:30:00	AAPL	Stock	80.575	80.6075	80.575	80.575	6268.0
2020-02-11 05:00:00	AAPL	Stock	80.6075	80.6775	80.6075	80.675	17712.0
2020-02-11 05:30:00	AAPL	Stock	80.6775	80.6825	80.675	80.675	11344.0
2020-02-11 06:00:00	AAPL	Stock	80.6875	80.6875	80.645	80.645	2180.0
2020-02-11 06:30:00	AAPL	Stock	80.62	80.625	80.575	80.575	13836.0
2020-02-11 07:00:00	AAPL	Stock	80.555	80.6225	80.39	80.51	155456.0
2020-02-11 07:30:00	AAPL	Stock	80.535	80.62	80.465	80.62	117856.0
2020-02-11 08:00:00	AAPL	Stock	80.535	80.735	80.3875	80.72	336528.0
2020-02-11 08:30:00	AAPL	Stock	80.725	80.8	80.595	80.75	343744.0
2020-02-11 09:00:00	AAPL	Stock	80.75	80.9125	80.7025	80.9	301304.0
2020-02-11 09:30:00	AAPL	Stock	80.8575	80.975	80.3875	80.4425	13561744.0
2020-02-11 10:00:00	AAPL	Stock	80.44	80.6225	80.4	80.5485	5722032.0
2020-02-11 10:30:00	AAPL	Stock	80.5475	80.82	80.5125	80.7075	6432792.0
2020-02-11 11:00:00	AAPL	Stock	80.7025	80.765	80.59	80.6175	3314280.0
2020-02-11 11:30:00	AAPL	Stock	80.6175	80.661	80.2525	80.49	5762600.0
2020-02-11 12:00:00	AAPL	Stock	80.4925	80.6	80.4025	80.507	2916052.0
2020-02-11 12:30:00	AAPL	Stock	80.51	80.695	80.4025	80.6732	3137112.0
2020-02-11 13:00:00	AAPL	Stock	80.675	80.7525	80.5325	80.605	2432364.0
2020-02-11 13:30:00	AAPL	Stock	80.6075	80.665	80.3675	80.4445	2590164.0
2020-02-11 14:00:00	AAPL	Stock	80.45	80.465	80.04	80.17	5482572.0
2020-02-11 14:30:00	AAPL	Stock	80.18	80.31	80.1	80.17	3819280.0
2020-02-11 15:00:00	AAPL	Stock	80.175	80.25	79.6775	79.795	7166660.0
2020-02-11 15:30:00	AAPL	Stock	79.7975	79.9325	79.69	79.9025	8382280.0
2020-02-11 16:00:00	AAPL	Stock	79.9025	80.5812	79.8025	79.9025	5975012.0
2020-02-11 16:30:00	AAPL	Stock	79.85	79.9025	79.85	79.875	49928.0
2020-02-11 17:00:00	AAPL	Stock	79.8875	79.8975	79.85	79.85	9460.0
2020-02-11 17:30:00	AAPL	Stock	79.8625	79.8675	79.825	79.85	12880.0
2020-02-11 18:00:00	AAPL	Stock	79.845	79.9	79.825	79.8375	73236.0
2020-02-11 18:30:00	AAPL	Stock	79.8375	79.9275	79.825	79.9075	12092.0
2020-02-11 19:00:00	AAPL	Stock	79.925	79.925	79.82	79.875	33128.0
2020-02-11 19:30:00	AAPL	Stock	79.85	79.85	79.775	79.8375	38020.0
2020-02-11 04:00:00	MSFT	Stock	190.0	190.29	189.9	190.29	7414.0
2020-02-11 04:30:00	MSFT	Stock	190.33	190.33	190.1	190.25	3183.0
2020-02-11 05:00:00	MSFT	Stock	190.25	190.44	190.25	190.42	5324.0
2020-02-11 05:30:00	MSFT	Stock	190.42	190.42	190.14	190.23	6624.0
2020-02-11 06:00:00	MSFT	Stock	190.3	190.35	190.15	190.18	11471.0
2020-02-11 06:30:00	MSFT	Stock	190.16	190.18	190.0	190.03	10347.0
2020-02-11 07:00:00	MSFT	Stock	190.1	191.0	190.03	190.83	80625.0
2020-02-11 07:30:00	MSFT	Stock	190.83	191.4	190.68	191.06	70036.0
2020-02-11 08:00:00	MSFT	Stock	191.06	191.4	190.15	190.94	123265.0
2020-02-11 08:30:00	MSFT	Stock	190.89	191.1	190.56	191.0	83877.0
2020-02-11 09:00:00	MSFT	Stock	191.04	191.1	190.45	190.66	81724.0
2020-02-11 09:30:00	MSFT	Stock	190.53	190.7	187.1	187.27	9423361.0
2020-02-11 10:00:00	MSFT	Stock	187.27	188.932	187.27	188.88	3775455.0
2020-02-11 10:30:00	MSFT	Stock	188.88	189.25	188.22	188.51	2473762.0
2020-02-11 11:00:00	MSFT	Stock	188.5	188.93	188.23	188.24	1543861.0
2020-02-11 11:30:00	MSFT	Stock	188.23	188.3	186.858	187.065	3159818.0
2020-02-11 12:00:00	MSFT	Stock	187.07	187.3	186.28	186.827	2579533.0
2020-02-11 12:30:00	MSFT	Stock	186.84	187.0	186.5	187.0	1386521.0

> showing 50 of 86,083 rows — these rows as CSV

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