PREVIEW / stock_30min / 2022-09-16

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-16.parquet
  size:    2.1 MB
  rows:    106,069
  symbols: 2,184

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-09-16 04:00:00	AAPL	Stock	151.35	151.55	150.8	150.8	34090.0
2022-09-16 04:30:00	AAPL	Stock	150.82	150.9	150.53	150.82	15533.0
2022-09-16 05:00:00	AAPL	Stock	150.84	150.89	150.74	150.74	9800.0
2022-09-16 05:30:00	AAPL	Stock	150.74	150.93	150.72	150.89	5255.0
2022-09-16 06:00:00	AAPL	Stock	150.84	150.94	150.63	150.9	11503.0
2022-09-16 06:30:00	AAPL	Stock	150.88	151.42	150.86	151.39	30826.0
2022-09-16 07:00:00	AAPL	Stock	151.39	151.4	150.79	150.96	65785.0
2022-09-16 07:30:00	AAPL	Stock	150.92	151.15	150.78	151.04	42547.0
2022-09-16 08:00:00	AAPL	Stock	151.12	151.2	150.55	150.55	214295.0
2022-09-16 08:30:00	AAPL	Stock	150.55	150.8	150.16	150.18	190543.0
2022-09-16 09:00:00	AAPL	Stock	150.2	151.53	150.16	151.22	615786.0
2022-09-16 09:30:00	AAPL	Stock	151.21	151.33	148.37	148.49	27157988.0
2022-09-16 10:00:00	AAPL	Stock	148.49	149.97	148.47	149.46	9545746.0
2022-09-16 10:30:00	AAPL	Stock	149.45	150.53	148.96	148.995	7086191.0
2022-09-16 11:00:00	AAPL	Stock	148.99	149.79	148.73	149.14	5140042.0
2022-09-16 11:30:00	AAPL	Stock	149.14	149.96	149.02	149.86	3663125.0
2022-09-16 12:00:00	AAPL	Stock	149.87	149.915	148.66	148.7678	3730690.0
2022-09-16 12:30:00	AAPL	Stock	148.765	149.49	148.71	149.41	3515634.0
2022-09-16 13:00:00	AAPL	Stock	149.405	149.51	149.02	149.28	2925203.0
2022-09-16 13:30:00	AAPL	Stock	149.28	149.91	149.15	149.325	3496451.0
2022-09-16 14:00:00	AAPL	Stock	149.33	150.26	149.26	150.15	4921880.0
2022-09-16 14:30:00	AAPL	Stock	150.155	150.81	149.93	150.51	4384392.0
2022-09-16 15:00:00	AAPL	Stock	150.5	151.35	150.47	150.77	6641447.0
2022-09-16 15:30:00	AAPL	Stock	150.76	150.9799	150.3	150.44	10582984.0
2022-09-16 16:00:00	AAPL	Stock	150.44	150.7	150.44	150.57	50697403.0
2022-09-16 16:30:00	AAPL	Stock	150.6	150.96	150.53	150.96	83889.0
2022-09-16 17:00:00	AAPL	Stock	150.9	150.94	150.63	150.85	38721.0
2022-09-16 17:30:00	AAPL	Stock	150.82	150.98	150.7	150.94	72514.0
2022-09-16 18:00:00	AAPL	Stock	150.97	151.08	150.92	151.08	26439.0
2022-09-16 18:30:00	AAPL	Stock	151.03	151.18	151.0	151.11	39247.0
2022-09-16 19:00:00	AAPL	Stock	151.1	151.16	151.1	151.14	9312.0
2022-09-16 19:30:00	AAPL	Stock	151.16	151.3	151.12	151.3	19743.0
2022-09-16 04:00:00	MSFT	Stock	243.72	243.72	243.0	243.0	6944.0
2022-09-16 04:30:00	MSFT	Stock	243.0	243.14	242.89	243.14	5438.0
2022-09-16 05:00:00	MSFT	Stock	243.2	243.3	243.05	243.05	1732.0
2022-09-16 05:30:00	MSFT	Stock	243.3	243.56	243.2	243.56	2688.0
2022-09-16 06:00:00	MSFT	Stock	243.1	243.2	243.0	243.0	5004.0
2022-09-16 06:30:00	MSFT	Stock	243.09	243.86	243.09	243.86	4345.0
2022-09-16 07:00:00	MSFT	Stock	243.62	243.62	243.2	243.27	5069.0
2022-09-16 07:30:00	MSFT	Stock	243.25	243.6	243.07	243.45	13679.0
2022-09-16 08:00:00	MSFT	Stock	243.4287	243.79	243.05	243.2	25885.0
2022-09-16 08:30:00	MSFT	Stock	243.15	243.59	242.65	242.81	26104.0
2022-09-16 09:00:00	MSFT	Stock	242.8	244.97	242.1	244.4	240121.0
2022-09-16 09:30:00	MSFT	Stock	244.25	244.51	242.38	242.68	9147866.0
2022-09-16 10:00:00	MSFT	Stock	242.72	244.58	242.51	243.35	1743626.0
2022-09-16 10:30:00	MSFT	Stock	243.37	244.38	242.42	242.42	1421575.0
2022-09-16 11:00:00	MSFT	Stock	242.455	243.61	242.41	243.07	1088504.0
2022-09-16 11:30:00	MSFT	Stock	243.05	244.28	242.47	244.1565	1151675.0
2022-09-16 12:00:00	MSFT	Stock	244.19	244.22	242.37	242.55	976859.0
2022-09-16 12:30:00	MSFT	Stock	242.52	243.33	242.42	243.21	652396.0

> showing 50 of 106,069 rows — these rows as CSV

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