PREVIEW / stock_30min / 2021-07-21

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-21.parquet
  size:    2.2 MB
  rows:    110,127
  symbols: 2,863

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-21 04:00:00	AAPL	Stock	146.38	146.58	146.16	146.48	8367.0
2021-07-21 04:30:00	AAPL	Stock	146.51	146.51	146.3	146.4	3615.0
2021-07-21 05:00:00	AAPL	Stock	146.32	146.37	146.32	146.33	3029.0
2021-07-21 05:30:00	AAPL	Stock	146.33	146.4	146.22	146.22	2197.0
2021-07-21 06:00:00	AAPL	Stock	146.21	146.23	145.95	146.16	12523.0
2021-07-21 06:30:00	AAPL	Stock	146.13	146.13	145.97	146.0	3396.0
2021-07-21 07:00:00	AAPL	Stock	146.09	146.18	145.62	145.7	106138.0
2021-07-21 07:30:00	AAPL	Stock	145.76	145.91	145.52	145.75	69417.0
2021-07-21 08:00:00	AAPL	Stock	146.0499	146.17	145.57	146.08	255783.0
2021-07-21 08:30:00	AAPL	Stock	146.08	146.2	145.79	146.02	232652.0
2021-07-21 09:00:00	AAPL	Stock	146.0	146.1161	145.41	145.47	231082.0
2021-07-21 09:30:00	AAPL	Stock	145.53	146.13	144.82	145.29	11338255.0
2021-07-21 10:00:00	AAPL	Stock	145.28	145.68	144.63	145.44	6233088.0
2021-07-21 10:30:00	AAPL	Stock	145.45	145.88	145.25	145.715	4524178.0
2021-07-21 11:00:00	AAPL	Stock	145.715	146.0475	145.57	145.7629	3757751.0
2021-07-21 11:30:00	AAPL	Stock	145.7699	145.8	145.02	145.4239	4223297.0
2021-07-21 12:00:00	AAPL	Stock	145.42	145.48	145.12	145.315	2722829.0
2021-07-21 12:30:00	AAPL	Stock	145.315	145.43	144.96	145.028	2401077.0
2021-07-21 13:00:00	AAPL	Stock	145.025	145.18	144.84	145.115	2988740.0
2021-07-21 13:30:00	AAPL	Stock	145.115	145.35	144.99	145.28	2098239.0
2021-07-21 14:00:00	AAPL	Stock	145.2701	145.3	145.035	145.14	2411498.0
2021-07-21 14:30:00	AAPL	Stock	145.1407	145.45	145.02	145.435	2755916.0
2021-07-21 15:00:00	AAPL	Stock	145.43	145.53	145.2101	145.2798	3040267.0
2021-07-21 15:30:00	AAPL	Stock	145.27	145.4	144.82	145.39	7899498.0
2021-07-21 16:00:00	AAPL	Stock	145.39	145.45	145.21	145.3499	7218896.0
2021-07-21 16:30:00	AAPL	Stock	145.31	145.4	145.1285	145.39	34465.0
2021-07-21 17:00:00	AAPL	Stock	145.39	145.39	145.35	145.37	17894.0
2021-07-21 17:30:00	AAPL	Stock	145.37	145.4	145.36	145.39	20723.0
2021-07-21 18:00:00	AAPL	Stock	145.37	145.39	145.3	145.32	14644.0
2021-07-21 18:30:00	AAPL	Stock	145.32	145.36	145.31	145.33	15746.0
2021-07-21 19:00:00	AAPL	Stock	145.33	145.37	145.33	145.33	14957.0
2021-07-21 19:30:00	AAPL	Stock	145.3399	145.42	145.31	145.35	29220.0
2021-07-21 04:00:00	MSFT	Stock	279.6	279.6	279.6	279.6	709.0
2021-07-21 04:30:00	MSFT	Stock	279.91	279.91	279.81	279.81	451.0
2021-07-21 05:00:00	MSFT	Stock	279.6	279.67	279.6	279.67	259.0
2021-07-21 05:30:00	MSFT	Stock	279.67	279.68	279.67	279.68	861.0
2021-07-21 06:00:00	MSFT	Stock	279.68	279.68	279.56	279.66	579.0
2021-07-21 06:30:00	MSFT	Stock	279.88	280.0	279.55	279.7	1125.0
2021-07-21 07:00:00	MSFT	Stock	279.55	279.55	278.9	279.17	14954.0
2021-07-21 07:30:00	MSFT	Stock	279.19	279.42	278.3	278.5	11596.0
2021-07-21 08:00:00	MSFT	Stock	279.3	279.33	278.49	278.75	11006.0
2021-07-21 08:30:00	MSFT	Stock	278.88	279.05	278.55	278.7006	7454.0
2021-07-21 09:00:00	MSFT	Stock	278.75	279.45	278.5	278.82	18441.0
2021-07-21 09:30:00	MSFT	Stock	278.74	280.1	277.29	279.96	2094025.0
2021-07-21 10:00:00	MSFT	Stock	279.98	280.66	279.47	280.415	1286659.0
2021-07-21 10:30:00	MSFT	Stock	280.415	280.86	280.18	280.66	1120275.0
2021-07-21 11:00:00	MSFT	Stock	280.665	280.97	280.39	280.545	879880.0
2021-07-21 11:30:00	MSFT	Stock	280.54	280.64	279.89	280.64	898029.0
2021-07-21 12:00:00	MSFT	Stock	280.6374	280.665	279.86	280.12	689383.0
2021-07-21 12:30:00	MSFT	Stock	280.125	280.26	279.13	279.79	761746.0

> showing 50 of 110,127 rows — these rows as CSV

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