PREVIEW / stock_30min / 2021-10-06

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-10-06.parquet
  size:    2.2 MB
  rows:    109,952
  symbols: 2,690

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-10-06 04:00:00	AAPL	Stock	139.48	139.5	138.97	139.28	29455.0
2021-10-06 04:30:00	AAPL	Stock	139.3	139.39	139.08	139.1	34653.0
2021-10-06 05:00:00	AAPL	Stock	139.08	139.14	138.76	138.76	31681.0
2021-10-06 05:30:00	AAPL	Stock	138.75	138.9	138.75	138.85	11500.0
2021-10-06 06:00:00	AAPL	Stock	138.85	139.01	138.68	139.01	20594.0
2021-10-06 06:30:00	AAPL	Stock	138.96	139.0	138.71	138.99	15939.0
2021-10-06 07:00:00	AAPL	Stock	138.92	139.38	138.89	139.18	189699.0
2021-10-06 07:30:00	AAPL	Stock	139.21	139.49	139.05	139.45	77199.0
2021-10-06 08:00:00	AAPL	Stock	139.1296	139.68	138.9	139.57	217286.0
2021-10-06 08:30:00	AAPL	Stock	139.55	141.1495	139.15	141.1495	187245.0
2021-10-06 09:00:00	AAPL	Stock	139.499	139.95	139.35	139.5	316967.0
2021-10-06 09:30:00	AAPL	Stock	139.58	140.18	138.96	139.12	11480233.0
2021-10-06 10:00:00	AAPL	Stock	139.12	140.2876	138.37	140.025	8879307.0
2021-10-06 10:30:00	AAPL	Stock	140.02	140.68	140.0	140.3	5577891.0
2021-10-06 11:00:00	AAPL	Stock	140.285	140.38	139.585	139.7076	4327209.0
2021-10-06 11:30:00	AAPL	Stock	139.7099	140.455	139.6504	140.3901	3728222.0
2021-10-06 12:00:00	AAPL	Stock	140.39	140.415	139.7536	139.8101	3776123.0
2021-10-06 12:30:00	AAPL	Stock	139.81	140.08	139.715	139.85	3068088.0
2021-10-06 13:00:00	AAPL	Stock	139.85	140.429	139.56	140.4288	3648119.0
2021-10-06 13:30:00	AAPL	Stock	140.4227	140.92	140.34	140.9111	4597932.0
2021-10-06 14:00:00	AAPL	Stock	140.91	141.43	140.72	141.4201	4150462.0
2021-10-06 14:30:00	AAPL	Stock	141.42	141.66	141.12	141.165	2939567.0
2021-10-06 15:00:00	AAPL	Stock	141.15	141.48	141.09	141.475	3053374.0
2021-10-06 15:30:00	AAPL	Stock	141.47	142.15	141.12	141.97	6760616.0
2021-10-06 16:00:00	AAPL	Stock	141.98	142.15	141.86	142.11	6162269.0
2021-10-06 16:30:00	AAPL	Stock	142.1	142.17	142.0	142.14	179258.0
2021-10-06 17:00:00	AAPL	Stock	142.13	142.19	142.0	142.13	158516.0
2021-10-06 17:30:00	AAPL	Stock	142.13	142.15	142.11	142.13	14248.0
2021-10-06 18:00:00	AAPL	Stock	142.15	142.35	142.13	142.3	23210.0
2021-10-06 18:30:00	AAPL	Stock	142.3	142.5	142.3	142.49	37805.0
2021-10-06 19:00:00	AAPL	Stock	142.5	142.77	142.48	142.59	56045.0
2021-10-06 19:30:00	AAPL	Stock	142.58	142.67	142.4	142.49	79981.0
2021-10-06 04:00:00	MSFT	Stock	285.11	285.11	284.32	284.57	5718.0
2021-10-06 04:30:00	MSFT	Stock	285.0	285.33	284.25	284.6	5715.0
2021-10-06 05:00:00	MSFT	Stock	284.67	284.67	283.89	284.15	5420.0
2021-10-06 05:30:00	MSFT	Stock	283.99	284.5	283.69	284.0	5357.0
2021-10-06 06:00:00	MSFT	Stock	284.13	284.59	284.1	284.25	5800.0
2021-10-06 06:30:00	MSFT	Stock	284.3	284.59	283.92	283.92	4632.0
2021-10-06 07:00:00	MSFT	Stock	284.35	285.25	284.15	284.98	40866.0
2021-10-06 07:30:00	MSFT	Stock	285.0	285.44	284.8	285.39	14810.0
2021-10-06 08:00:00	MSFT	Stock	284.3501	285.8	284.35	285.8	21761.0
2021-10-06 08:30:00	MSFT	Stock	285.81	286.61	285.62	286.35	36567.0
2021-10-06 09:00:00	MSFT	Stock	286.4	286.95	285.78	285.85	35700.0
2021-10-06 09:30:00	MSFT	Stock	285.78	288.4886	285.5093	286.935	2281288.0
2021-10-06 10:00:00	MSFT	Stock	286.93	289.18	285.91	288.98	1479668.0
2021-10-06 10:30:00	MSFT	Stock	288.965	290.88	288.92	289.85	1971774.0
2021-10-06 11:00:00	MSFT	Stock	289.87	290.08	288.56	288.85	984831.0
2021-10-06 11:30:00	MSFT	Stock	288.85	289.86	288.51	289.81	729802.0
2021-10-06 12:00:00	MSFT	Stock	289.81	289.83	288.58	288.91	693866.0
2021-10-06 12:30:00	MSFT	Stock	288.88	289.67	288.61	289.14	539322.0

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

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