PREVIEW / stock_30min / 2020-06-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-18.parquet
  size:    1.9 MB
  rows:    97,371
  symbols: 2,431

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-06-18 04:00:00	AAPL	Stock	87.9275	88.07	87.925	88.05	10660.0
2020-06-18 04:30:00	AAPL	Stock	88.125	88.325	88.0775	88.2875	24452.0
2020-06-18 05:00:00	AAPL	Stock	88.3075	88.3075	88.2075	88.2475	6432.0
2020-06-18 05:30:00	AAPL	Stock	88.35	88.35	88.1225	88.1225	5068.0
2020-06-18 06:00:00	AAPL	Stock	88.0075	88.0075	87.94	87.975	6320.0
2020-06-18 06:30:00	AAPL	Stock	88.0625	88.225	88.05	88.0775	17264.0
2020-06-18 07:00:00	AAPL	Stock	88.015	88.25	87.8375	87.9125	120076.0
2020-06-18 07:30:00	AAPL	Stock	87.94	87.9425	87.6125	87.625	117304.0
2020-06-18 08:00:00	AAPL	Stock	87.9125	88.245	87.555	87.875	244452.0
2020-06-18 08:30:00	AAPL	Stock	87.8875	88.137	87.5	88.0575	197780.0
2020-06-18 09:00:00	AAPL	Stock	88.035	88.075	87.75	87.875	188064.0
2020-06-18 09:30:00	AAPL	Stock	87.8725	88.2575	87.715	87.8225	11114384.0
2020-06-18 10:00:00	AAPL	Stock	87.82	88.1975	87.7375	87.855	6913472.0
2020-06-18 10:30:00	AAPL	Stock	87.855	88.145	87.58	88.125	5989252.0
2020-06-18 11:00:00	AAPL	Stock	88.125	88.3625	88.07	88.1642	5480304.0
2020-06-18 11:30:00	AAPL	Stock	88.1625	88.2083	87.9575	88.005	3547616.0
2020-06-18 12:00:00	AAPL	Stock	87.9875	88.09	87.84	88.0325	3513104.0
2020-06-18 12:30:00	AAPL	Stock	88.0325	88.1075	87.8552	87.9025	2916272.0
2020-06-18 13:00:00	AAPL	Stock	87.9025	88.025	87.825	87.9125	2595436.0
2020-06-18 13:30:00	AAPL	Stock	87.91	88.0775	87.8925	87.9825	2236272.0
2020-06-18 14:00:00	AAPL	Stock	87.985	87.9925	87.63	87.6958	3866104.0
2020-06-18 14:30:00	AAPL	Stock	87.6925	87.815	87.4475	87.4615	4816148.0
2020-06-18 15:00:00	AAPL	Stock	87.465	87.5925	87.305	87.5775	5681868.0
2020-06-18 15:30:00	AAPL	Stock	87.5713	88.0275	87.495	87.8975	9262416.0
2020-06-18 16:00:00	AAPL	Stock	87.8962	87.9925	87.8125	87.9	5727304.0
2020-06-18 16:30:00	AAPL	Stock	87.9	88.4227	87.83	87.83	37168.0
2020-06-18 17:00:00	AAPL	Stock	87.85	87.92	87.8125	87.875	45300.0
2020-06-18 17:30:00	AAPL	Stock	87.85	87.8725	87.83	87.83	12748.0
2020-06-18 18:00:00	AAPL	Stock	87.83	87.9875	87.8	87.9875	28132.0
2020-06-18 18:30:00	AAPL	Stock	87.9375	87.9875	87.9375	87.9875	16392.0
2020-06-18 19:00:00	AAPL	Stock	87.98	88.075	87.98	88.075	45480.0
2020-06-18 19:30:00	AAPL	Stock	88.075	88.14	88.0625	88.1375	61216.0
2020-06-18 04:30:00	MSFT	Stock	195.49	195.49	195.49	195.49	100.0
2020-06-18 06:00:00	MSFT	Stock	194.8	194.8	194.55	194.55	307.0
2020-06-18 06:30:00	MSFT	Stock	194.25	194.33	194.03	194.03	1469.0
2020-06-18 07:00:00	MSFT	Stock	194.19	194.48	194.19	194.4	5131.0
2020-06-18 07:30:00	MSFT	Stock	194.37	194.37	193.85	193.85	6271.0
2020-06-18 08:00:00	MSFT	Stock	194.35	194.51	193.24	193.95	18001.0
2020-06-18 08:30:00	MSFT	Stock	194.1	194.71	193.71	194.31	20000.0
2020-06-18 09:00:00	MSFT	Stock	194.364	194.364	194.0	194.2	13447.0
2020-06-18 09:30:00	MSFT	Stock	194.18	196.49	194.0	195.8	2986671.0
2020-06-18 10:00:00	MSFT	Stock	195.77	195.97	194.76	194.91	1584362.0
2020-06-18 10:30:00	MSFT	Stock	194.88	195.75	194.25	195.685	1623413.0
2020-06-18 11:00:00	MSFT	Stock	195.685	196.28	195.56	195.95	1027962.0
2020-06-18 11:30:00	MSFT	Stock	195.9	196.0	195.35	195.522	877992.0
2020-06-18 12:00:00	MSFT	Stock	195.51	195.62	194.93	195.37	944817.0
2020-06-18 12:30:00	MSFT	Stock	195.386	195.54	195.21	195.46	627986.0
2020-06-18 13:00:00	MSFT	Stock	195.46	195.67	195.22	195.55	623869.0
2020-06-18 13:30:00	MSFT	Stock	195.557	196.03	195.55	195.77	686939.0
2020-06-18 14:00:00	MSFT	Stock	195.79	195.87	195.04	195.26	956692.0

> showing 50 of 97,371 rows — these rows as CSV

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