PREVIEW / stock_30min / 2020-09-25

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-25.parquet
  size:    1.9 MB
  rows:    95,075
  symbols: 2,494

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-09-25 04:00:00	AAPL	Stock	108.53	108.53	108.02	108.21	17644.0
2020-09-25 04:30:00	AAPL	Stock	108.29	108.42	108.27	108.4	5861.0
2020-09-25 05:00:00	AAPL	Stock	108.5	108.7	108.04	108.04	5128.0
2020-09-25 05:30:00	AAPL	Stock	108.3	108.3	107.54	108.11	12101.0
2020-09-25 06:00:00	AAPL	Stock	108.07	108.4	107.65	107.8	13469.0
2020-09-25 06:30:00	AAPL	Stock	107.8	107.88	107.27	107.5	10459.0
2020-09-25 07:00:00	AAPL	Stock	107.62	108.27	107.2	108.03	179530.0
2020-09-25 07:30:00	AAPL	Stock	108.01	108.67	107.66	108.56	123835.0
2020-09-25 08:00:00	AAPL	Stock	107.45	109.0	107.25	108.7	484474.0
2020-09-25 08:30:00	AAPL	Stock	108.67	109.19	108.3	109.15	407369.0
2020-09-25 09:00:00	AAPL	Stock	109.102	109.436	108.42	108.51	531442.0
2020-09-25 09:30:00	AAPL	Stock	108.51	109.17	107.67	109.14	16690141.0
2020-09-25 10:00:00	AAPL	Stock	109.13	110.12	108.57	109.91	13547157.0
2020-09-25 10:30:00	AAPL	Stock	109.9	110.45	109.74	110.095	9921945.0
2020-09-25 11:00:00	AAPL	Stock	110.09	110.94	109.9	110.46	9784618.0
2020-09-25 11:30:00	AAPL	Stock	110.441	110.71	109.81	109.865	7339746.0
2020-09-25 12:00:00	AAPL	Stock	109.865	110.67	109.82	110.285	6577271.0
2020-09-25 12:30:00	AAPL	Stock	110.28	110.75	110.07	110.7	5025042.0
2020-09-25 13:00:00	AAPL	Stock	110.71	110.97	110.4	110.745	6172409.0
2020-09-25 13:30:00	AAPL	Stock	110.749	111.265	110.58	111.235	6476874.0
2020-09-25 14:00:00	AAPL	Stock	111.23	111.64	111.18	111.492	8190533.0
2020-09-25 14:30:00	AAPL	Stock	111.496	111.82	111.3	111.77	7868462.0
2020-09-25 15:00:00	AAPL	Stock	111.76	112.32	111.715	111.995	11387866.0
2020-09-25 15:30:00	AAPL	Stock	111.995	112.44	111.77	112.28	14409651.0
2020-09-25 16:00:00	AAPL	Stock	112.28	112.57	112.279	112.5	8469084.0
2020-09-25 16:30:00	AAPL	Stock	112.5	112.52	112.45	112.48	109398.0
2020-09-25 17:00:00	AAPL	Stock	112.5	112.52	112.0	112.04	229912.0
2020-09-25 17:30:00	AAPL	Stock	112.08	112.09	111.9	111.97	140809.0
2020-09-25 18:00:00	AAPL	Stock	112.0	112.0	111.64	111.8	134478.0
2020-09-25 18:30:00	AAPL	Stock	111.78	111.96	111.71	111.86	38387.0
2020-09-25 19:00:00	AAPL	Stock	111.89	112.0	111.86	111.97	34840.0
2020-09-25 19:30:00	AAPL	Stock	111.97	112.25	111.93	112.25	89143.0
2020-09-25 04:00:00	MSFT	Stock	203.8	203.8	203.11	203.19	2549.0
2020-09-25 05:00:00	MSFT	Stock	203.8	203.8	202.83	202.83	520.0
2020-09-25 05:30:00	MSFT	Stock	202.35	202.65	202.35	202.65	400.0
2020-09-25 06:00:00	MSFT	Stock	202.69	202.69	202.5	202.5	799.0
2020-09-25 06:30:00	MSFT	Stock	202.82	202.82	202.31	202.37	323.0
2020-09-25 07:00:00	MSFT	Stock	202.65	203.45	202.2	203.08	11811.0
2020-09-25 07:30:00	MSFT	Stock	202.82	203.77	202.55	203.77	27650.0
2020-09-25 08:00:00	MSFT	Stock	202.927	204.0	202.13	203.5	22158.0
2020-09-25 08:30:00	MSFT	Stock	203.55	204.278	202.76	204.278	29021.0
2020-09-25 09:00:00	MSFT	Stock	204.01	204.34	203.5	203.5	26170.0
2020-09-25 09:30:00	MSFT	Stock	203.55	204.66	202.54	203.955	2597606.0
2020-09-25 10:00:00	MSFT	Stock	203.96	205.18	202.72	205.04	1873469.0
2020-09-25 10:30:00	MSFT	Stock	205.026	205.78	204.8	205.31	1607744.0
2020-09-25 11:00:00	MSFT	Stock	205.32	207.09	204.83	206.56	1555273.0
2020-09-25 11:30:00	MSFT	Stock	206.56	206.67	205.491	205.54	1134901.0
2020-09-25 12:00:00	MSFT	Stock	205.56	206.99	205.54	206.33	1358243.0
2020-09-25 12:30:00	MSFT	Stock	206.38	206.53	206.0	206.45	666499.0
2020-09-25 13:00:00	MSFT	Stock	206.47	207.06	206.12	206.4	1037355.0

> showing 50 of 95,075 rows — these rows as CSV

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