PREVIEW / stock_30min / 2022-12-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-12-14.parquet
  size:    2.1 MB
  rows:    102,519
  symbols: 2,005

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-12-14 04:00:00	AAPL	Stock	145.6	145.62	145.01	145.1	6694.0
2022-12-14 04:30:00	AAPL	Stock	145.17	145.2	144.91	145.14	4088.0
2022-12-14 05:00:00	AAPL	Stock	145.08	145.21	145.01	145.21	9914.0
2022-12-14 05:30:00	AAPL	Stock	145.25	145.25	145.0	145.05	3550.0
2022-12-14 06:00:00	AAPL	Stock	145.03	145.03	144.8	144.88	12172.0
2022-12-14 06:30:00	AAPL	Stock	144.97	145.07	144.71	145.0	7665.0
2022-12-14 07:00:00	AAPL	Stock	145.05	145.32	144.92	145.26	19616.0
2022-12-14 07:30:00	AAPL	Stock	145.24	145.37	144.95	145.08	30912.0
2022-12-14 08:00:00	AAPL	Stock	144.95	145.37	144.9009	145.0806	71983.0
2022-12-14 08:30:00	AAPL	Stock	145.17	145.37	145.04	145.25	37932.0
2022-12-14 09:00:00	AAPL	Stock	145.25	145.39	145.04	145.35	57643.0
2022-12-14 09:30:00	AAPL	Stock	145.35	146.42	145.07	146.305	4709526.0
2022-12-14 10:00:00	AAPL	Stock	146.3	146.655	145.895	146.0	3449761.0
2022-12-14 10:30:00	AAPL	Stock	146.01	146.385	145.64	145.99	3338857.0
2022-12-14 11:00:00	AAPL	Stock	146.0	146.36	145.58	146.075	2925430.0
2022-12-14 11:30:00	AAPL	Stock	146.07	146.23	145.82	145.93	2282053.0
2022-12-14 12:00:00	AAPL	Stock	145.93	145.94	145.4201	145.5	1880013.0
2022-12-14 12:30:00	AAPL	Stock	145.5014	145.5999	145.2595	145.3	1716608.0
2022-12-14 13:00:00	AAPL	Stock	145.31	145.84	145.2747	145.8	2574296.0
2022-12-14 13:30:00	AAPL	Stock	145.8	146.63	145.79	146.3162	3250953.0
2022-12-14 14:00:00	AAPL	Stock	146.35	146.37	142.64	143.1	8532773.0
2022-12-14 14:30:00	AAPL	Stock	143.12	143.39	141.16	142.695	9880086.0
2022-12-14 15:00:00	AAPL	Stock	142.71	145.08	142.41	142.6098	7237869.0
2022-12-14 15:30:00	AAPL	Stock	142.59	143.8393	142.19	143.22	7965395.0
2022-12-14 16:00:00	AAPL	Stock	143.23	143.58	143.13	143.47	9683586.0
2022-12-14 16:30:00	AAPL	Stock	143.45	143.56	143.21	143.42	33532.0
2022-12-14 17:00:00	AAPL	Stock	143.41	143.43	143.21	143.36	36916.0
2022-12-14 17:30:00	AAPL	Stock	143.35	143.42	143.33	143.34	2700.0
2022-12-14 18:00:00	AAPL	Stock	143.34	143.4	143.28	143.3501	12285.0
2022-12-14 18:30:00	AAPL	Stock	143.39	143.55	143.39	143.42	9643.0
2022-12-14 19:00:00	AAPL	Stock	143.44	143.44	143.25	143.25	12971.0
2022-12-14 19:30:00	AAPL	Stock	143.26	143.43	143.26	143.4	11586.0
2022-12-14 04:00:00	MSFT	Stock	257.14	257.14	256.84	256.84	303.0
2022-12-14 04:30:00	MSFT	Stock	256.85	257.01	256.75	257.01	786.0
2022-12-14 05:00:00	MSFT	Stock	257.07	257.07	257.07	257.07	100.0
2022-12-14 05:30:00	MSFT	Stock	256.95	256.95	256.93	256.93	471.0
2022-12-14 06:00:00	MSFT	Stock	256.5	256.5	256.5	256.5	300.0
2022-12-14 06:30:00	MSFT	Stock	256.52	256.65	256.35	256.6	1773.0
2022-12-14 07:00:00	MSFT	Stock	257.0	257.38	256.92	257.14	1471.0
2022-12-14 07:30:00	MSFT	Stock	257.19	257.19	256.92	257.01	5784.0
2022-12-14 08:00:00	MSFT	Stock	257.0202	257.4951	256.278	257.26	21634.0
2022-12-14 08:30:00	MSFT	Stock	257.19	257.88	257.19	257.74	16072.0
2022-12-14 09:00:00	MSFT	Stock	257.6	257.81	256.29	257.09	20857.0
2022-12-14 09:30:00	MSFT	Stock	257.19	260.83	256.92	260.61	2489957.0
2022-12-14 10:00:00	MSFT	Stock	260.57	261.0	259.8251	260.86	1388342.0
2022-12-14 10:30:00	MSFT	Stock	260.85	261.1299	260.05	260.65	1002423.0
2022-12-14 11:00:00	MSFT	Stock	260.68	261.7	260.4701	261.67	1201084.0
2022-12-14 11:30:00	MSFT	Stock	261.66	262.588	261.37	261.825	1179467.0
2022-12-14 12:00:00	MSFT	Stock	261.805	261.82	260.78	261.06	976985.0
2022-12-14 12:30:00	MSFT	Stock	261.05	261.43	260.3986	260.86	1011739.0

> showing 50 of 102,519 rows — these rows as CSV

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