PREVIEW / stock_30min / 2022-06-28

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-28.parquet
  size:    2.1 MB
  rows:    104,555
  symbols: 2,340

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
2022-06-28 04:00:00	AAPL	Stock	142.01	142.38	141.59	142.24	9072.0
2022-06-28 04:30:00	AAPL	Stock	142.18	142.44	142.1	142.44	10663.0
2022-06-28 05:00:00	AAPL	Stock	142.4	142.55	142.37	142.5	7423.0
2022-06-28 05:30:00	AAPL	Stock	142.43	142.62	142.34	142.38	13416.0
2022-06-28 06:00:00	AAPL	Stock	142.37	142.37	142.25	142.3	8024.0
2022-06-28 06:30:00	AAPL	Stock	142.38	142.43	142.24	142.42	8333.0
2022-06-28 07:00:00	AAPL	Stock	142.35	142.62	142.3	142.62	33296.0
2022-06-28 07:30:00	AAPL	Stock	142.56	142.65	142.31	142.4	40622.0
2022-06-28 08:00:00	AAPL	Stock	142.42	142.66	141.9	141.96	162166.0
2022-06-28 08:30:00	AAPL	Stock	141.96	142.15	141.77	142.1	94035.0
2022-06-28 09:00:00	AAPL	Stock	142.13	142.37	141.99	142.14	88462.0
2022-06-28 09:30:00	AAPL	Stock	142.17	143.422	141.89	142.4	7114371.0
2022-06-28 10:00:00	AAPL	Stock	142.4	142.55	141.18	141.41	4648294.0
2022-06-28 10:30:00	AAPL	Stock	141.415	141.415	140.37	140.795	4324095.0
2022-06-28 11:00:00	AAPL	Stock	140.79	141.03	139.75	139.7561	3149436.0
2022-06-28 11:30:00	AAPL	Stock	139.76	139.965	138.835	139.0509	3860308.0
2022-06-28 12:00:00	AAPL	Stock	139.06	139.26	138.65	139.21	3461243.0
2022-06-28 12:30:00	AAPL	Stock	139.2	139.43	138.8553	139.31	2643447.0
2022-06-28 13:00:00	AAPL	Stock	139.3022	139.305	138.5	139.0054	2521435.0
2022-06-28 13:30:00	AAPL	Stock	139.0073	139.08	138.68	138.8175	1619105.0
2022-06-28 14:00:00	AAPL	Stock	138.82	139.08	138.12	138.2	2255550.0
2022-06-28 14:30:00	AAPL	Stock	138.19	138.205	137.58	138.01	2828981.0
2022-06-28 15:00:00	AAPL	Stock	138.0072	138.25	137.51	137.75	3471321.0
2022-06-28 15:30:00	AAPL	Stock	137.75	137.91	137.325	137.44	8098299.0
2022-06-28 16:00:00	AAPL	Stock	137.45	137.79	137.33	137.43	9091279.0
2022-06-28 16:30:00	AAPL	Stock	137.48	137.49	137.3	137.45	48912.0
2022-06-28 17:00:00	AAPL	Stock	137.48	137.5	137.4	137.4405	104125.0
2022-06-28 17:30:00	AAPL	Stock	137.48	137.52	137.4	137.4299	30743.0
2022-06-28 18:00:00	AAPL	Stock	137.46	137.6	137.46	137.59	9748.0
2022-06-28 18:30:00	AAPL	Stock	137.59	137.62	137.49	137.58	12401.0
2022-06-28 19:00:00	AAPL	Stock	137.55	137.6	137.33	137.54	35309.0
2022-06-28 19:30:00	AAPL	Stock	137.58	137.8	137.5	137.71	21056.0
2022-06-28 04:00:00	MSFT	Stock	265.65	265.65	265.65	265.65	100.0
2022-06-28 05:30:00	MSFT	Stock	265.3	265.3	265.3	265.3	332.0
2022-06-28 06:00:00	MSFT	Stock	265.15	265.15	265.15	265.15	100.0
2022-06-28 06:30:00	MSFT	Stock	266.0	266.15	265.82	265.82	350.0
2022-06-28 07:00:00	MSFT	Stock	265.94	266.5	265.94	266.5	6599.0
2022-06-28 07:30:00	MSFT	Stock	266.45	266.49	266.3	266.3	7201.0
2022-06-28 08:00:00	MSFT	Stock	266.3133	266.4374	264.228	265.3	14781.0
2022-06-28 08:30:00	MSFT	Stock	265.3	265.5285	264.88	265.45	15382.0
2022-06-28 09:00:00	MSFT	Stock	265.49	265.49	263.41	263.91	35726.0
2022-06-28 09:30:00	MSFT	Stock	264.14	266.91	263.03	263.3	2192357.0
2022-06-28 10:00:00	MSFT	Stock	263.31	263.57	261.865	262.38	1176789.0
2022-06-28 10:30:00	MSFT	Stock	262.36	262.47	261.44	262.395	975112.0
2022-06-28 11:00:00	MSFT	Stock	262.37	262.37	260.31	260.32	822729.0
2022-06-28 11:30:00	MSFT	Stock	260.33	260.86	258.98	259.28	1178222.0
2022-06-28 12:00:00	MSFT	Stock	259.26	259.5	258.13	258.73	1201051.0
2022-06-28 12:30:00	MSFT	Stock	258.66	259.3	258.24	259.08	618955.0
2022-06-28 13:00:00	MSFT	Stock	259.0787	259.16	258.01	259.0399	703683.0
2022-06-28 13:30:00	MSFT	Stock	259.04	259.3	258.48	258.885	712880.0

> showing 50 of 104,555 rows — these rows as CSV

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