PREVIEW / stock_30min / 2021-07-16

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-16.parquet
  size:    2.2 MB
  rows:    109,072
  symbols: 2,881

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-07-16 04:00:00	AAPL	Stock	148.34	148.35	148.1	148.27	6276.0
2021-07-16 04:30:00	AAPL	Stock	148.27	148.35	148.21	148.35	4679.0
2021-07-16 05:00:00	AAPL	Stock	148.38	148.43	148.31	148.35	17280.0
2021-07-16 05:30:00	AAPL	Stock	148.35	148.4	148.3	148.34	1731.0
2021-07-16 06:00:00	AAPL	Stock	148.35	148.45	148.2	148.24	4590.0
2021-07-16 06:30:00	AAPL	Stock	148.37	148.78	148.37	148.7	26283.0
2021-07-16 07:00:00	AAPL	Stock	148.65	148.88	148.61	148.67	73457.0
2021-07-16 07:30:00	AAPL	Stock	148.68	148.89	148.64	148.78	52764.0
2021-07-16 08:00:00	AAPL	Stock	148.6999	149.02	148.109	148.92	330659.0
2021-07-16 08:30:00	AAPL	Stock	148.96	149.01	148.8	148.86	158077.0
2021-07-16 09:00:00	AAPL	Stock	148.87	149.23	148.38	148.54	453912.0
2021-07-16 09:30:00	AAPL	Stock	148.53	149.76	148.46	149.0	13135576.0
2021-07-16 10:00:00	AAPL	Stock	149.0	149.32	148.2	148.275	7561695.0
2021-07-16 10:30:00	AAPL	Stock	148.27	148.91	148.18	148.602	5327690.0
2021-07-16 11:00:00	AAPL	Stock	148.61	148.705	147.46	147.52	5567745.0
2021-07-16 11:30:00	AAPL	Stock	147.52	147.77	147.06	147.335	5227243.0
2021-07-16 12:00:00	AAPL	Stock	147.34	147.8769	147.325	147.51	3548125.0
2021-07-16 12:30:00	AAPL	Stock	147.501	147.7916	147.34	147.7	2561178.0
2021-07-16 13:00:00	AAPL	Stock	147.7	148.18	147.6501	147.865	2991912.0
2021-07-16 13:30:00	AAPL	Stock	147.865	147.92	147.63	147.68	2335906.0
2021-07-16 14:00:00	AAPL	Stock	147.68	147.685	147.28	147.2892	2706470.0
2021-07-16 14:30:00	AAPL	Stock	147.285	147.43	146.46	146.535	5077428.0
2021-07-16 15:00:00	AAPL	Stock	146.535	146.63	145.88	146.1501	7150747.0
2021-07-16 15:30:00	AAPL	Stock	146.16	146.52	145.96	146.39	9057928.0
2021-07-16 16:00:00	AAPL	Stock	146.39	147.377	146.06	146.2	5623472.0
2021-07-16 16:30:00	AAPL	Stock	146.2	146.2	146.05	146.19	61815.0
2021-07-16 17:00:00	AAPL	Stock	146.15	146.17	146.03	146.05	36663.0
2021-07-16 17:30:00	AAPL	Stock	146.04	146.08	146.0	146.01	27825.0
2021-07-16 18:00:00	AAPL	Stock	146.02	146.04	146.0	146.02	34062.0
2021-07-16 18:30:00	AAPL	Stock	146.03	146.04	145.92	145.94	18458.0
2021-07-16 19:00:00	AAPL	Stock	145.91	145.93	145.81	145.85	32676.0
2021-07-16 19:30:00	AAPL	Stock	145.87	145.94	145.84	145.92	60486.0
2021-07-16 04:00:00	MSFT	Stock	281.06	281.06	281.01	281.01	295.0
2021-07-16 05:00:00	MSFT	Stock	281.0	281.21	281.0	281.21	3383.0
2021-07-16 05:30:00	MSFT	Stock	281.21	281.21	280.9	281.0	4025.0
2021-07-16 06:00:00	MSFT	Stock	280.98	280.98	280.91	280.91	531.0
2021-07-16 06:30:00	MSFT	Stock	280.97	281.21	280.97	281.21	3778.0
2021-07-16 07:00:00	MSFT	Stock	281.33	281.65	281.33	281.6	2231.0
2021-07-16 07:30:00	MSFT	Stock	281.57	281.6	281.33	281.56	2554.0
2021-07-16 08:00:00	MSFT	Stock	281.3299	281.8	281.18	281.8	7648.0
2021-07-16 08:30:00	MSFT	Stock	281.57	282.2499	281.56	282.0	24920.0
2021-07-16 09:00:00	MSFT	Stock	281.96	282.84	281.8	282.34	85438.0
2021-07-16 09:30:00	MSFT	Stock	282.31	284.1	281.92	282.78	3781309.0
2021-07-16 10:00:00	MSFT	Stock	282.79	283.08	281.7	281.7	1381666.0
2021-07-16 10:30:00	MSFT	Stock	281.7	282.23	281.02	281.13	1370048.0
2021-07-16 11:00:00	MSFT	Stock	281.13	281.22	280.06	280.435	1312028.0
2021-07-16 11:30:00	MSFT	Stock	280.41	280.8799	279.46	280.37	1176898.0
2021-07-16 12:00:00	MSFT	Stock	280.36	281.93	280.33	281.44	1289785.0
2021-07-16 12:30:00	MSFT	Stock	281.44	281.7299	281.06	281.4917	756726.0
2021-07-16 13:00:00	MSFT	Stock	281.5	282.54	281.42	282.24	887312.0

> showing 50 of 109,072 rows — these rows as CSV

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