PREVIEW / stock_30min / 2022-06-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-13.parquet
  size:    2.3 MB
  rows:    113,748
  symbols: 2,428

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-13 04:00:00	AAPL	Stock	134.98	135.98	132.54	132.91	166538.0
2022-06-13 04:30:00	AAPL	Stock	132.91	133.27	132.89	132.89	55834.0
2022-06-13 05:00:00	AAPL	Stock	132.88	133.2	132.74	132.86	72384.0
2022-06-13 05:30:00	AAPL	Stock	132.87	133.1	132.56	133.07	30849.0
2022-06-13 06:00:00	AAPL	Stock	133.02	133.5	133.01	133.07	24819.0
2022-06-13 06:30:00	AAPL	Stock	133.07	133.6	132.92	133.48	35309.0
2022-06-13 07:00:00	AAPL	Stock	133.48	133.8	132.76	133.17	198175.0
2022-06-13 07:30:00	AAPL	Stock	133.17	133.25	132.53	132.69	175889.0
2022-06-13 08:00:00	AAPL	Stock	133.69	134.5	132.54	133.29	664246.0
2022-06-13 08:30:00	AAPL	Stock	133.2312	133.48	132.83	133.1	292244.0
2022-06-13 09:00:00	AAPL	Stock	133.07	133.49	132.62	132.87	430085.0
2022-06-13 09:30:00	AAPL	Stock	132.85	134.66	132.582	134.5999	15603481.0
2022-06-13 10:00:00	AAPL	Stock	134.6	135.2	132.57	132.86	9018093.0
2022-06-13 10:30:00	AAPL	Stock	132.85	134.0599	132.74	133.07	6851471.0
2022-06-13 11:00:00	AAPL	Stock	133.0899	134.53	132.63	134.145	6781678.0
2022-06-13 11:30:00	AAPL	Stock	134.1409	134.48	133.44	133.73	5165808.0
2022-06-13 12:00:00	AAPL	Stock	133.73	134.395	133.51	134.18	6245464.0
2022-06-13 12:30:00	AAPL	Stock	134.17	135.0569	133.66	133.725	3993712.0
2022-06-13 13:00:00	AAPL	Stock	133.73	133.75	133.14	133.31	3315243.0
2022-06-13 13:30:00	AAPL	Stock	133.315	134.3179	133.16	134.2325	3950320.0
2022-06-13 14:00:00	AAPL	Stock	134.23	134.25	133.26	133.3783	3883229.0
2022-06-13 14:30:00	AAPL	Stock	133.38	133.63	132.71	132.745	4658025.0
2022-06-13 15:00:00	AAPL	Stock	132.75	133.32	132.0683	132.305	8660131.0
2022-06-13 15:30:00	AAPL	Stock	132.305	132.57	131.44	131.88	13796908.0
2022-06-13 16:00:00	AAPL	Stock	131.88	132.58	131.88	132.35	13474020.0
2022-06-13 16:30:00	AAPL	Stock	132.34	132.62	131.88	132.45	137310.0
2022-06-13 17:00:00	AAPL	Stock	132.37	132.48	132.25	132.4	37398.0
2022-06-13 17:30:00	AAPL	Stock	132.39	132.52	132.32	132.35	20273.0
2022-06-13 18:00:00	AAPL	Stock	132.4	132.87	132.3	132.76	56909.0
2022-06-13 18:30:00	AAPL	Stock	132.78	132.79	132.4	132.5	29224.0
2022-06-13 19:00:00	AAPL	Stock	132.5	132.52	132.25	132.27	30143.0
2022-06-13 19:30:00	AAPL	Stock	132.3	132.4	132.03	132.4	70850.0
2022-06-13 04:00:00	MSFT	Stock	249.97	250.0	245.1	245.88	28841.0
2022-06-13 04:30:00	MSFT	Stock	246.0	246.18	245.7	245.74	8599.0
2022-06-13 05:00:00	MSFT	Stock	245.79	246.61	245.62	245.97	9129.0
2022-06-13 05:30:00	MSFT	Stock	246.0	246.29	245.53	246.29	14107.0
2022-06-13 06:00:00	MSFT	Stock	246.43	246.84	246.11	246.12	3365.0
2022-06-13 06:30:00	MSFT	Stock	246.26	247.09	246.22	246.81	14079.0
2022-06-13 07:00:00	MSFT	Stock	246.86	247.44	246.06	246.5	27307.0
2022-06-13 07:30:00	MSFT	Stock	246.5	246.98	246.15	246.37	14006.0
2022-06-13 08:00:00	MSFT	Stock	247.2	252.358	246.0201	247.0	74693.0
2022-06-13 08:30:00	MSFT	Stock	247.0001	247.4	246.75	246.75	32540.0
2022-06-13 09:00:00	MSFT	Stock	246.75	247.2	244.59	245.15	84378.0
2022-06-13 09:30:00	MSFT	Stock	245.16	249.0242	244.2171	247.39	3991499.0
2022-06-13 10:00:00	MSFT	Stock	247.4	248.6101	246.815	247.96	2459536.0
2022-06-13 10:30:00	MSFT	Stock	247.97	248.26	245.43	245.75	1795370.0
2022-06-13 11:00:00	MSFT	Stock	245.75	246.5447	244.4862	245.745	1462661.0
2022-06-13 11:30:00	MSFT	Stock	245.73	246.65	244.98	245.5	1221200.0
2022-06-13 12:00:00	MSFT	Stock	245.48	246.7	245.24	246.21	893523.0
2022-06-13 12:30:00	MSFT	Stock	246.17	247.61	245.24	245.43	1138320.0

> showing 50 of 113,748 rows — these rows as CSV

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