PREVIEW / stock_30min / 2020-09-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-22.parquet
  size:    1.9 MB
  rows:    96,153
  symbols: 2,502

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-22 04:00:00	AAPL	Stock	111.0	111.0	110.0	110.59	44900.0
2020-09-22 04:30:00	AAPL	Stock	110.59	110.88	110.41	110.63	23877.0
2020-09-22 05:00:00	AAPL	Stock	110.64	111.42	110.58	111.38	28039.0
2020-09-22 05:30:00	AAPL	Stock	111.35	111.52	111.12	111.44	37751.0
2020-09-22 06:00:00	AAPL	Stock	111.42	111.6	111.0	111.6	38612.0
2020-09-22 06:30:00	AAPL	Stock	111.61	111.68	111.16	111.19	21599.0
2020-09-22 07:00:00	AAPL	Stock	111.26	111.99	111.03	111.88	346944.0
2020-09-22 07:30:00	AAPL	Stock	111.88	111.94	110.8	111.03	359938.0
2020-09-22 08:00:00	AAPL	Stock	111.03	112.0	110.8	111.65	907445.0
2020-09-22 08:30:00	AAPL	Stock	111.673	112.37	111.51	112.17	969893.0
2020-09-22 09:00:00	AAPL	Stock	112.16	112.94	112.12	112.78	965444.0
2020-09-22 09:30:00	AAPL	Stock	112.68	112.86	110.27	111.45	25475174.0
2020-09-22 10:00:00	AAPL	Stock	111.43	111.86	110.791	111.46	14194743.0
2020-09-22 10:30:00	AAPL	Stock	111.47	111.67	109.4	109.44	13620359.0
2020-09-22 11:00:00	AAPL	Stock	109.46	110.35	109.16	110.04	11292359.0
2020-09-22 11:30:00	AAPL	Stock	110.049	110.39	109.48	110.04	7553841.0
2020-09-22 12:00:00	AAPL	Stock	110.04	110.55	109.98	110.52	7293250.0
2020-09-22 12:30:00	AAPL	Stock	110.52	110.67	109.47	109.82	8033995.0
2020-09-22 13:00:00	AAPL	Stock	109.828	110.52	109.68	110.263	6668639.0
2020-09-22 13:30:00	AAPL	Stock	110.26	110.7	109.69	110.65	8340942.0
2020-09-22 14:00:00	AAPL	Stock	110.66	111.45	110.65	110.92	11090058.0
2020-09-22 14:30:00	AAPL	Stock	110.92	111.03	110.47	110.868	8005504.0
2020-09-22 15:00:00	AAPL	Stock	110.866	111.85	110.68	111.83	10967461.0
2020-09-22 15:30:00	AAPL	Stock	111.84	112.45	111.36	111.8	19642022.0
2020-09-22 16:00:00	AAPL	Stock	111.81	111.92	111.21	111.47	7881312.0
2020-09-22 16:30:00	AAPL	Stock	111.47	111.63	111.27	111.5	142965.0
2020-09-22 17:00:00	AAPL	Stock	111.55	111.6	111.3	111.4	92419.0
2020-09-22 17:30:00	AAPL	Stock	111.4	111.81	111.37	111.53	107832.0
2020-09-22 18:00:00	AAPL	Stock	111.58	111.69	111.0	111.16	111247.0
2020-09-22 18:30:00	AAPL	Stock	111.15	111.6	110.93	111.02	147356.0
2020-09-22 19:00:00	AAPL	Stock	111.01	111.1	110.51	110.65	179688.0
2020-09-22 19:30:00	AAPL	Stock	110.67	111.06	110.5	110.6	250688.0
2020-09-22 04:00:00	MSFT	Stock	203.0	203.05	203.0	203.05	1083.0
2020-09-22 04:30:00	MSFT	Stock	203.55	203.55	203.05	203.1	7885.0
2020-09-22 05:00:00	MSFT	Stock	203.1	204.9	203.1	204.9	2523.0
2020-09-22 05:30:00	MSFT	Stock	204.74	205.0	204.52	204.62	5550.0
2020-09-22 06:00:00	MSFT	Stock	204.66	204.85	204.6	204.85	2791.0
2020-09-22 06:30:00	MSFT	Stock	204.85	205.0	204.64	204.64	3745.0
2020-09-22 07:00:00	MSFT	Stock	204.81	205.2	204.01	205.2	28855.0
2020-09-22 07:30:00	MSFT	Stock	205.02	205.07	203.11	203.38	36524.0
2020-09-22 08:00:00	MSFT	Stock	204.8	205.21	203.11	204.06	59261.0
2020-09-22 08:30:00	MSFT	Stock	204.13	205.1	204.05	204.805	84747.0
2020-09-22 09:00:00	MSFT	Stock	204.98	205.4	204.65	205.21	90393.0
2020-09-22 09:30:00	MSFT	Stock	205.06	205.42	202.075	202.92	3776749.0
2020-09-22 10:00:00	MSFT	Stock	202.94	204.33	202.83	204.25	1833374.0
2020-09-22 10:30:00	MSFT	Stock	204.25	204.51	202.89	202.905	1594008.0
2020-09-22 11:00:00	MSFT	Stock	202.93	203.53	202.27	203.37	1290296.0
2020-09-22 11:30:00	MSFT	Stock	203.4	204.344	202.86	204.3	1065666.0
2020-09-22 12:00:00	MSFT	Stock	204.29	204.98	204.23	204.83	1214162.0
2020-09-22 12:30:00	MSFT	Stock	204.82	205.24	203.87	204.24	1114121.0

> showing 50 of 96,153 rows — these rows as CSV

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