PREVIEW / stock_30min / 2019-08-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-05.parquet
  size:    1.8 MB
  rows:    88,067
  symbols: 2,568

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-05 04:00:00	AAPL	Stock	49.75	49.995	49.7	49.705	39640.0
2019-08-05 04:30:00	AAPL	Stock	49.7	49.915	49.6525	49.6525	37892.0
2019-08-05 05:00:00	AAPL	Stock	49.645	49.8225	49.6	49.8025	61268.0
2019-08-05 05:30:00	AAPL	Stock	49.8825	50.0	49.7975	49.875	19504.0
2019-08-05 06:00:00	AAPL	Stock	49.8625	49.975	49.75	49.75	37448.0
2019-08-05 06:30:00	AAPL	Stock	49.7875	49.7975	49.735	49.76	21344.0
2019-08-05 07:00:00	AAPL	Stock	49.775	49.875	49.47	49.47	291364.0
2019-08-05 07:30:00	AAPL	Stock	49.465	49.725	49.465	49.6125	174212.0
2019-08-05 08:00:00	AAPL	Stock	49.725	49.86	49.45	49.5975	611728.0
2019-08-05 08:30:00	AAPL	Stock	49.6025	49.635	49.4225	49.475	305040.0
2019-08-05 09:00:00	AAPL	Stock	49.435	49.6125	49.3775	49.525	544332.0
2019-08-05 09:30:00	AAPL	Stock	49.475	49.6622	48.8328	49.0575	27358828.0
2019-08-05 10:00:00	AAPL	Stock	49.0375	49.1702	48.7825	49.0125	14010300.0
2019-08-05 10:30:00	AAPL	Stock	49.01	49.0325	48.575	48.8528	13354848.0
2019-08-05 11:00:00	AAPL	Stock	48.8525	49.07	48.805	48.83	9360612.0
2019-08-05 11:30:00	AAPL	Stock	48.835	48.9188	48.7075	48.78	6901408.0
2019-08-05 12:00:00	AAPL	Stock	48.7812	48.81	48.5825	48.59	7253540.0
2019-08-05 12:30:00	AAPL	Stock	48.5875	48.685	48.275	48.3025	9077600.0
2019-08-05 13:00:00	AAPL	Stock	48.3025	48.635	48.2625	48.5425	7344488.0
2019-08-05 13:30:00	AAPL	Stock	48.54	48.695	48.3925	48.41	7100292.0
2019-08-05 14:00:00	AAPL	Stock	48.4075	48.495	48.2175	48.2192	8300948.0
2019-08-05 14:30:00	AAPL	Stock	48.218	48.36	48.175	48.24	8825692.0
2019-08-05 15:00:00	AAPL	Stock	48.2425	48.54	48.145	48.245	13501232.0
2019-08-05 15:30:00	AAPL	Stock	48.2412	48.575	48.205	48.305	18521184.0
2019-08-05 16:00:00	AAPL	Stock	48.2975	48.335	48.105	48.105	21651112.0
2019-08-05 16:30:00	AAPL	Stock	48.1225	48.335	48.0125	48.085	300336.0
2019-08-05 17:00:00	AAPL	Stock	48.0925	48.0925	48.0375	48.0525	74608.0
2019-08-05 17:30:00	AAPL	Stock	48.05	48.335	47.775	47.775	386476.0
2019-08-05 18:00:00	AAPL	Stock	47.8075	47.8075	47.0	47.34	528068.0
2019-08-05 18:30:00	AAPL	Stock	47.34	47.4875	47.0375	47.1075	206384.0
2019-08-05 19:00:00	AAPL	Stock	47.1	47.1925	47.09	47.1125	127688.0
2019-08-05 19:30:00	AAPL	Stock	47.0875	47.115	46.7625	46.825	196552.0
2019-08-05 04:00:00	MSFT	Stock	135.2	135.2	134.0	134.02	8630.0
2019-08-05 04:30:00	MSFT	Stock	134.16	134.4	134.05	134.4	790.0
2019-08-05 05:00:00	MSFT	Stock	134.05	134.75	134.0	134.11	7833.0
2019-08-05 05:30:00	MSFT	Stock	134.5	134.94	134.5	134.94	2920.0
2019-08-05 06:00:00	MSFT	Stock	134.94	134.94	134.3	134.3	4361.0
2019-08-05 06:30:00	MSFT	Stock	134.29	134.5	134.26	134.5	4482.0
2019-08-05 07:00:00	MSFT	Stock	134.68	134.8	133.76	133.76	47984.0
2019-08-05 07:30:00	MSFT	Stock	133.84	134.35	133.84	134.12	30797.0
2019-08-05 08:00:00	MSFT	Stock	134.18	134.73	133.67	133.75	71894.0
2019-08-05 08:30:00	MSFT	Stock	133.8	133.81	133.33	133.47	68475.0
2019-08-05 09:00:00	MSFT	Stock	133.49	133.66	133.1	133.24	79153.0
2019-08-05 09:30:00	MSFT	Stock	133.24	133.66	132.0	133.559	4353253.0
2019-08-05 10:00:00	MSFT	Stock	133.53	133.755	132.82	133.441	1929733.0
2019-08-05 10:30:00	MSFT	Stock	133.43	133.57	132.714	133.15	1590080.0
2019-08-05 11:00:00	MSFT	Stock	133.15	133.93	133.03	133.45	2024970.0
2019-08-05 11:30:00	MSFT	Stock	133.47	133.72	133.27	133.62	1624580.0
2019-08-05 12:00:00	MSFT	Stock	133.63	133.66	133.08	133.24	1524391.0
2019-08-05 12:30:00	MSFT	Stock	133.235	133.39	132.31	132.37	1735940.0

> showing 50 of 88,067 rows — these rows as CSV

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