PREVIEW / stock_30min / 2020-09-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-23.parquet
  size:    1.9 MB
  rows:    98,108
  symbols: 2,512

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-23 04:00:00	AAPL	Stock	111.15	111.77	111.15	111.62	34072.0
2020-09-23 04:30:00	AAPL	Stock	111.72	112.2	111.72	112.19	27981.0
2020-09-23 05:00:00	AAPL	Stock	112.17	112.51	112.17	112.26	36938.0
2020-09-23 05:30:00	AAPL	Stock	112.25	112.61	112.17	112.48	16417.0
2020-09-23 06:00:00	AAPL	Stock	112.42	112.49	112.0	112.06	17077.0
2020-09-23 06:30:00	AAPL	Stock	111.98	112.3	111.79	112.03	25899.0
2020-09-23 07:00:00	AAPL	Stock	112.15	112.19	111.34	111.65	184987.0
2020-09-23 07:30:00	AAPL	Stock	111.6	112.0	111.04	111.11	258837.0
2020-09-23 08:00:00	AAPL	Stock	111.11	112.0	111.02	111.34	549322.0
2020-09-23 08:30:00	AAPL	Stock	111.33	111.53	110.81	111.25	358802.0
2020-09-23 09:00:00	AAPL	Stock	111.25	111.782	111.11	111.63	366940.0
2020-09-23 09:30:00	AAPL	Stock	111.63	112.11	110.6	110.891	13956668.0
2020-09-23 10:00:00	AAPL	Stock	110.87	111.24	110.01	110.73	9737952.0
2020-09-23 10:30:00	AAPL	Stock	110.73	111.32	110.26	110.48	9040133.0
2020-09-23 11:00:00	AAPL	Stock	110.485	110.92	110.2	110.45	6877701.0
2020-09-23 11:30:00	AAPL	Stock	110.45	110.62	109.71	109.82	8218323.0
2020-09-23 12:00:00	AAPL	Stock	109.81	110.11	109.04	109.44	7625537.0
2020-09-23 12:30:00	AAPL	Stock	109.445	110.18	109.22	110.048	6014239.0
2020-09-23 13:00:00	AAPL	Stock	110.045	110.07	109.28	109.35	4872252.0
2020-09-23 13:30:00	AAPL	Stock	109.36	109.46	108.5	108.75	7963765.0
2020-09-23 14:00:00	AAPL	Stock	108.745	108.75	107.76	108.06	9244612.0
2020-09-23 14:30:00	AAPL	Stock	108.05	108.34	107.45	107.68	8174786.0
2020-09-23 15:00:00	AAPL	Stock	107.689	107.95	106.8	107.66	11358644.0
2020-09-23 15:30:00	AAPL	Stock	107.68	108.03	106.77	107.23	15097735.0
2020-09-23 16:00:00	AAPL	Stock	107.24	107.39	106.85	106.99	13575511.0
2020-09-23 16:30:00	AAPL	Stock	106.96	107.08	106.77	106.85	150069.0
2020-09-23 17:00:00	AAPL	Stock	106.87	106.92	106.25	106.41	260157.0
2020-09-23 17:30:00	AAPL	Stock	106.4	106.5	105.8	106.24	283450.0
2020-09-23 18:00:00	AAPL	Stock	106.23	106.85	106.2	106.64	259477.0
2020-09-23 18:30:00	AAPL	Stock	106.65	106.9	106.15	106.43	144647.0
2020-09-23 19:00:00	AAPL	Stock	106.44	106.54	105.76	105.76	158038.0
2020-09-23 19:30:00	AAPL	Stock	105.77	105.85	105.55	105.6	283838.0
2020-09-23 04:00:00	MSFT	Stock	207.2	207.88	207.2	207.42	1598.0
2020-09-23 04:30:00	MSFT	Stock	207.96	208.0	207.95	207.95	940.0
2020-09-23 05:00:00	MSFT	Stock	207.95	208.98	207.95	208.5	3485.0
2020-09-23 05:30:00	MSFT	Stock	208.12	209.44	208.05	209.44	2904.0
2020-09-23 06:00:00	MSFT	Stock	208.99	209.02	208.85	208.85	2781.0
2020-09-23 06:30:00	MSFT	Stock	208.38	208.67	208.05	208.5	2084.0
2020-09-23 07:00:00	MSFT	Stock	208.22	208.7	207.96	208.0	31259.0
2020-09-23 07:30:00	MSFT	Stock	208.02	208.5	206.49	206.49	36610.0
2020-09-23 08:00:00	MSFT	Stock	208.35	208.645	206.4	207.2	49532.0
2020-09-23 08:30:00	MSFT	Stock	207.2	207.7	206.62	207.49	23250.0
2020-09-23 09:00:00	MSFT	Stock	207.472	208.25	206.9	208.03	92430.0
2020-09-23 09:30:00	MSFT	Stock	207.9	208.1	205.23	205.58	2908143.0
2020-09-23 10:00:00	MSFT	Stock	205.53	205.99	204.65	205.28	1454274.0
2020-09-23 10:30:00	MSFT	Stock	205.29	205.7	204.52	204.71	1378791.0
2020-09-23 11:00:00	MSFT	Stock	204.72	205.58	204.34	204.75	1038118.0
2020-09-23 11:30:00	MSFT	Stock	204.74	205.17	203.95	204.065	1172492.0
2020-09-23 12:00:00	MSFT	Stock	204.08	204.8	203.7	204.26	982457.0
2020-09-23 12:30:00	MSFT	Stock	204.23	204.948	204.021	204.933	701554.0

> showing 50 of 98,108 rows — these rows as CSV

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