PREVIEW / stock_30min / 2021-06-11

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-11.parquet
  size:    2.2 MB
  rows:    111,666
  symbols: 2,972

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
2021-06-11 04:00:00	AAPL	Stock	126.33	126.59	126.33	126.4	6975.0
2021-06-11 04:30:00	AAPL	Stock	126.34	126.59	126.34	126.56	1776.0
2021-06-11 05:00:00	AAPL	Stock	126.54	126.58	126.43	126.44	2976.0
2021-06-11 05:30:00	AAPL	Stock	126.48	126.49	126.44	126.47	1683.0
2021-06-11 06:00:00	AAPL	Stock	126.46	126.46	126.36	126.4	5472.0
2021-06-11 06:30:00	AAPL	Stock	126.39	126.68	126.39	126.68	5139.0
2021-06-11 07:00:00	AAPL	Stock	126.69	126.75	126.54	126.58	94421.0
2021-06-11 07:30:00	AAPL	Stock	126.6	126.75	126.5	126.6	61918.0
2021-06-11 08:00:00	AAPL	Stock	126.59	126.74	126.425	126.6	216751.0
2021-06-11 08:30:00	AAPL	Stock	126.6	126.63	126.47	126.5499	121972.0
2021-06-11 09:00:00	AAPL	Stock	126.55	126.63	126.46	126.48	188464.0
2021-06-11 09:30:00	AAPL	Stock	126.53	127.12	126.1	126.9033	8826672.0
2021-06-11 10:00:00	AAPL	Stock	126.9	127.275	126.9	127.12	4744451.0
2021-06-11 10:30:00	AAPL	Stock	127.115	127.17	126.58	126.7092	3509987.0
2021-06-11 11:00:00	AAPL	Stock	126.7	126.9868	126.515	126.975	2919052.0
2021-06-11 11:30:00	AAPL	Stock	126.975	127.165	126.95	127.08	2618227.0
2021-06-11 12:00:00	AAPL	Stock	127.0701	127.255	127.01	127.1	2432593.0
2021-06-11 12:30:00	AAPL	Stock	127.1079	127.145	126.91	127.0619	2008699.0
2021-06-11 13:00:00	AAPL	Stock	127.07	127.21	126.91	127.17	1846961.0
2021-06-11 13:30:00	AAPL	Stock	127.18	127.41	127.16	127.3348	2047590.0
2021-06-11 14:00:00	AAPL	Stock	127.34	127.44	127.19	127.3118	2036079.0
2021-06-11 14:30:00	AAPL	Stock	127.315	127.42	127.25	127.375	1702653.0
2021-06-11 15:00:00	AAPL	Stock	127.37	127.3784	127.06	127.15	2316512.0
2021-06-11 15:30:00	AAPL	Stock	127.15	127.36	127.04	127.3521	4592888.0
2021-06-11 16:00:00	AAPL	Stock	127.35	127.4	127.26	127.31	5430859.0
2021-06-11 16:30:00	AAPL	Stock	127.33	127.35	127.2	127.24	34870.0
2021-06-11 17:00:00	AAPL	Stock	127.22	127.28	127.2	127.24	27533.0
2021-06-11 17:30:00	AAPL	Stock	127.25	127.28	127.23	127.26	12849.0
2021-06-11 18:00:00	AAPL	Stock	127.27	127.27	127.23	127.27	16114.0
2021-06-11 18:30:00	AAPL	Stock	127.27	127.29	127.2	127.26	19114.0
2021-06-11 19:00:00	AAPL	Stock	127.26	127.34	127.2599	127.32	29450.0
2021-06-11 19:30:00	AAPL	Stock	127.28	127.4	127.27	127.4	44165.0
2021-06-11 04:00:00	MSFT	Stock	257.52	257.59	257.0	257.59	892.0
2021-06-11 04:30:00	MSFT	Stock	257.6	257.6	257.5	257.52	1437.0
2021-06-11 05:00:00	MSFT	Stock	257.5	257.5	257.35	257.35	1907.0
2021-06-11 05:30:00	MSFT	Stock	257.35	257.41	257.35	257.41	799.0
2021-06-11 06:00:00	MSFT	Stock	257.3	257.3	257.15	257.2	395.0
2021-06-11 06:30:00	MSFT	Stock	257.99	258.1	257.93	257.93	3000.0
2021-06-11 07:00:00	MSFT	Stock	258.09	258.44	258.09	258.26	6866.0
2021-06-11 07:30:00	MSFT	Stock	258.41	258.5	258.1	258.14	4029.0
2021-06-11 08:00:00	MSFT	Stock	258.15	258.55	256.597	258.1	11823.0
2021-06-11 08:30:00	MSFT	Stock	258.16	258.23	257.7	257.7	27487.0
2021-06-11 09:00:00	MSFT	Stock	257.85	258.5	257.7	257.98	26161.0
2021-06-11 09:30:00	MSFT	Stock	257.9	258.23	256.8	257.71	2189930.0
2021-06-11 10:00:00	MSFT	Stock	257.68	258.4868	257.67	258.14	1394080.0
2021-06-11 10:30:00	MSFT	Stock	258.14	258.27	257.68	257.97	875759.0
2021-06-11 11:00:00	MSFT	Stock	257.97	258.18	257.505	258.08	793866.0
2021-06-11 11:30:00	MSFT	Stock	258.0786	258.16	257.34	257.43	597315.0
2021-06-11 12:00:00	MSFT	Stock	257.43	257.57	256.68	256.8	961321.0
2021-06-11 12:30:00	MSFT	Stock	256.79	257.01	256.61	256.925	793539.0

> showing 50 of 111,666 rows — these rows as CSV

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