PREVIEW / stock_30min / 2020-11-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-20.parquet
  size:    2.0 MB
  rows:    101,268
  symbols: 2,581

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-11-20 04:00:00	AAPL	Stock	118.35	118.6	118.35	118.57	6488.0
2020-11-20 04:30:00	AAPL	Stock	118.54	118.57	118.43	118.5	4441.0
2020-11-20 05:00:00	AAPL	Stock	118.5	118.5	118.32	118.5	2468.0
2020-11-20 05:30:00	AAPL	Stock	118.45	118.64	118.45	118.64	7526.0
2020-11-20 06:00:00	AAPL	Stock	118.61	118.64	118.5	118.64	3993.0
2020-11-20 06:30:00	AAPL	Stock	118.6	118.62	118.45	118.6	1783.0
2020-11-20 07:00:00	AAPL	Stock	118.61	118.95	118.56	118.88	56105.0
2020-11-20 07:30:00	AAPL	Stock	118.88	118.9	118.78	118.84	27296.0
2020-11-20 08:00:00	AAPL	Stock	118.95	118.97	118.59	118.76	115800.0
2020-11-20 08:30:00	AAPL	Stock	118.79	118.83	118.68	118.7	51001.0
2020-11-20 09:00:00	AAPL	Stock	118.67	118.81	118.61	118.65	124667.0
2020-11-20 09:30:00	AAPL	Stock	118.64	118.66	117.84	118.13	11485197.0
2020-11-20 10:00:00	AAPL	Stock	118.13	118.45	118.06	118.273	4199130.0
2020-11-20 10:30:00	AAPL	Stock	118.27	118.64	118.17	118.465	3604287.0
2020-11-20 11:00:00	AAPL	Stock	118.46	118.77	118.38	118.45	3500495.0
2020-11-20 11:30:00	AAPL	Stock	118.45	118.47	117.905	117.99	4053671.0
2020-11-20 12:00:00	AAPL	Stock	117.98	118.22	117.88	118.2	3371331.0
2020-11-20 12:30:00	AAPL	Stock	118.19	118.3	118.09	118.27	2477750.0
2020-11-20 13:00:00	AAPL	Stock	118.28	118.29	117.96	118.12	2525972.0
2020-11-20 13:30:00	AAPL	Stock	118.115	118.195	117.9	117.958	2389006.0
2020-11-20 14:00:00	AAPL	Stock	117.96	118.1	117.88	118.015	2486759.0
2020-11-20 14:30:00	AAPL	Stock	118.011	118.019	117.7	117.87	3180515.0
2020-11-20 15:00:00	AAPL	Stock	117.87	117.96	117.5	117.565	4068910.0
2020-11-20 15:30:00	AAPL	Stock	117.565	117.86	117.29	117.32	8613273.0
2020-11-20 16:00:00	AAPL	Stock	117.33	117.41	117.15	117.33	6612600.0
2020-11-20 16:30:00	AAPL	Stock	117.32	117.41	117.29	117.38	88852.0
2020-11-20 17:00:00	AAPL	Stock	117.4	117.44	117.25	117.26	52250.0
2020-11-20 17:30:00	AAPL	Stock	117.26	117.34	117.22	117.22	45557.0
2020-11-20 18:00:00	AAPL	Stock	117.22	117.23	116.91	117.1	152233.0
2020-11-20 18:30:00	AAPL	Stock	117.04	117.14	116.99	117.08	45315.0
2020-11-20 19:00:00	AAPL	Stock	117.07	117.14	117.02	117.14	27034.0
2020-11-20 19:30:00	AAPL	Stock	117.15	117.19	117.08	117.11	65080.0
2020-11-20 04:00:00	MSFT	Stock	212.95	213.0	212.7	212.93	4322.0
2020-11-20 04:30:00	MSFT	Stock	212.93	212.93	212.93	212.93	100.0
2020-11-20 05:00:00	MSFT	Stock	212.7	212.7	212.7	212.7	100.0
2020-11-20 05:30:00	MSFT	Stock	212.7	212.98	212.7	212.98	2438.0
2020-11-20 06:00:00	MSFT	Stock	212.98	213.0	212.96	213.0	699.0
2020-11-20 06:30:00	MSFT	Stock	212.99	213.2	212.94	213.18	740.0
2020-11-20 07:00:00	MSFT	Stock	213.04	213.07	212.7	213.0	14435.0
2020-11-20 07:30:00	MSFT	Stock	212.9	213.18	212.7	212.79	11365.0
2020-11-20 08:00:00	MSFT	Stock	213.0	213.05	212.7	212.7	23457.0
2020-11-20 08:30:00	MSFT	Stock	212.8	212.8	212.62	212.62	10764.0
2020-11-20 09:00:00	MSFT	Stock	212.62	213.0	212.19	212.2	66617.0
2020-11-20 09:30:00	MSFT	Stock	212.19	212.7	211.337	212.19	2825235.0
2020-11-20 10:00:00	MSFT	Stock	212.19	212.34	211.67	211.87	964444.0
2020-11-20 10:30:00	MSFT	Stock	211.87	212.72	211.66	212.14	858126.0
2020-11-20 11:00:00	MSFT	Stock	212.13	212.992	212.1	212.89	851311.0
2020-11-20 11:30:00	MSFT	Stock	212.88	213.285	211.83	212.0	1182591.0
2020-11-20 12:00:00	MSFT	Stock	212.0	212.34	211.88	212.27	565184.0
2020-11-20 12:30:00	MSFT	Stock	212.25	212.43	211.8	212.05	697824.0

> showing 50 of 101,268 rows — these rows as CSV

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