PREVIEW / stock_30min / 2020-09-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-15.parquet
  size:    1.9 MB
  rows:    95,796
  symbols: 2,491

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-15 04:00:00	AAPL	Stock	116.54	116.86	116.11	116.85	37352.0
2020-09-15 04:30:00	AAPL	Stock	116.83	117.22	116.7	117.19	29221.0
2020-09-15 05:00:00	AAPL	Stock	117.19	117.48	117.08	117.48	25707.0
2020-09-15 05:30:00	AAPL	Stock	117.45	117.65	117.35	117.49	28626.0
2020-09-15 06:00:00	AAPL	Stock	117.55	117.55	116.65	117.07	54989.0
2020-09-15 06:30:00	AAPL	Stock	117.09	117.6	117.0	117.48	34272.0
2020-09-15 07:00:00	AAPL	Stock	117.51	117.59	117.0	117.47	224960.0
2020-09-15 07:30:00	AAPL	Stock	117.47	117.89	117.44	117.54	290809.0
2020-09-15 08:00:00	AAPL	Stock	117.55	117.89	117.0	117.52	647514.0
2020-09-15 08:30:00	AAPL	Stock	117.53	118.48	117.52	118.255	949209.0
2020-09-15 09:00:00	AAPL	Stock	118.254	118.88	118.21	118.33	1138935.0
2020-09-15 09:30:00	AAPL	Stock	118.39	118.829	117.23	118.038	19156420.0
2020-09-15 10:00:00	AAPL	Stock	118.04	118.08	116.07	116.73	12825160.0
2020-09-15 10:30:00	AAPL	Stock	116.74	116.81	115.64	116.48	9332680.0
2020-09-15 11:00:00	AAPL	Stock	116.49	117.53	116.26	117.145	9390754.0
2020-09-15 11:30:00	AAPL	Stock	117.15	117.568	116.95	117.4	5979170.0
2020-09-15 12:00:00	AAPL	Stock	117.41	117.81	117.13	117.45	6371007.0
2020-09-15 12:30:00	AAPL	Stock	117.44	118.11	117.22	117.86	6642139.0
2020-09-15 13:00:00	AAPL	Stock	117.86	118.2	116.5	116.83	14282528.0
2020-09-15 13:30:00	AAPL	Stock	116.835	117.43	116.52	116.79	9075769.0
2020-09-15 14:00:00	AAPL	Stock	116.79	116.94	115.1	115.37	16997192.0
2020-09-15 14:30:00	AAPL	Stock	115.38	115.76	115.0	115.335	10559820.0
2020-09-15 15:00:00	AAPL	Stock	115.338	115.36	113.61	114.75	15856235.0
2020-09-15 15:30:00	AAPL	Stock	114.74	115.79	114.11	115.58	13853743.0
2020-09-15 16:00:00	AAPL	Stock	115.535	116.439	115.27	115.53	7070989.0
2020-09-15 16:30:00	AAPL	Stock	115.5	115.54	115.25	115.3	144419.0
2020-09-15 17:00:00	AAPL	Stock	115.29	115.5	115.0	115.04	218318.0
2020-09-15 17:30:00	AAPL	Stock	115.04	115.36	114.91	115.1	172455.0
2020-09-15 18:00:00	AAPL	Stock	115.11	115.31	115.0	115.15	79856.0
2020-09-15 18:30:00	AAPL	Stock	115.14	115.26	115.1	115.12	50645.0
2020-09-15 19:00:00	AAPL	Stock	115.12	115.14	114.75	114.96	145233.0
2020-09-15 19:30:00	AAPL	Stock	114.92	114.92	114.5	114.77	203432.0
2020-09-15 04:00:00	MSFT	Stock	206.4	206.6	206.37	206.37	1222.0
2020-09-15 04:30:00	MSFT	Stock	206.19	206.2	205.84	205.86	783.0
2020-09-15 05:00:00	MSFT	Stock	206.13	206.49	206.12	206.43	889.0
2020-09-15 05:30:00	MSFT	Stock	206.99	207.65	206.99	207.65	833.0
2020-09-15 06:00:00	MSFT	Stock	207.4	207.4	206.65	206.65	1300.0
2020-09-15 06:30:00	MSFT	Stock	207.06	207.45	207.0	207.25	3076.0
2020-09-15 07:00:00	MSFT	Stock	207.1	207.8	206.63	207.75	22938.0
2020-09-15 07:30:00	MSFT	Stock	207.79	207.99	207.34	207.34	35788.0
2020-09-15 08:00:00	MSFT	Stock	207.46	207.99	206.62	207.7	30273.0
2020-09-15 08:30:00	MSFT	Stock	207.8	207.99	207.0	207.19	36550.0
2020-09-15 09:00:00	MSFT	Stock	207.16	209.0	207.16	208.44	76172.0
2020-09-15 09:30:00	MSFT	Stock	208.42	209.78	207.9	209.48	3040169.0
2020-09-15 10:00:00	MSFT	Stock	209.404	209.65	207.52	208.08	1217951.0
2020-09-15 10:30:00	MSFT	Stock	208.12	208.25	206.93	207.75	853825.0
2020-09-15 11:00:00	MSFT	Stock	207.79	208.3	207.46	208.24	855442.0
2020-09-15 11:30:00	MSFT	Stock	208.23	209.22	208.21	208.64	970023.0
2020-09-15 12:00:00	MSFT	Stock	208.65	209.16	208.63	208.93	582673.0
2020-09-15 12:30:00	MSFT	Stock	208.9	208.97	208.39	208.605	498249.0

> showing 50 of 95,796 rows — these rows as CSV

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