PREVIEW / stock_30min / 2022-08-04

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-04.parquet
  size:    2.2 MB
  rows:    107,763
  symbols: 2,234

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-08-04 04:00:00	AAPL	Stock	165.63	166.04	165.63	165.9	9984.0
2022-08-04 04:30:00	AAPL	Stock	165.9	165.9	165.78	165.81	7097.0
2022-08-04 05:00:00	AAPL	Stock	165.76	166.0	165.62	165.98	8485.0
2022-08-04 05:30:00	AAPL	Stock	165.98	166.11	165.86	166.1	3619.0
2022-08-04 06:00:00	AAPL	Stock	166.1	166.53	166.1	166.4	12049.0
2022-08-04 06:30:00	AAPL	Stock	166.45	166.65	166.29	166.47	9478.0
2022-08-04 07:00:00	AAPL	Stock	166.43	166.45	166.0	166.08	39686.0
2022-08-04 07:30:00	AAPL	Stock	166.06	166.46	165.92	165.93	49022.0
2022-08-04 08:00:00	AAPL	Stock	166.4745	166.49	165.33	166.33	278799.0
2022-08-04 08:30:00	AAPL	Stock	166.32	166.58	166.18	166.49	187354.0
2022-08-04 09:00:00	AAPL	Stock	166.48	166.48	166.0	166.01	320595.0
2022-08-04 09:30:00	AAPL	Stock	166.01	167.19	165.7092	166.22	8362552.0
2022-08-04 10:00:00	AAPL	Stock	166.225	166.59	164.91	164.9599	4192770.0
2022-08-04 10:30:00	AAPL	Stock	164.95	165.47	164.5612	165.3103	3614599.0
2022-08-04 11:00:00	AAPL	Stock	165.31	165.49	164.43	164.7195	2929670.0
2022-08-04 11:30:00	AAPL	Stock	164.7208	165.48	164.53	165.3838	2476318.0
2022-08-04 12:00:00	AAPL	Stock	165.39	165.735	165.08	165.55	2404813.0
2022-08-04 12:30:00	AAPL	Stock	165.55	165.55	164.791	164.96	2076467.0
2022-08-04 13:00:00	AAPL	Stock	164.96	165.57	164.95	165.455	1802354.0
2022-08-04 13:30:00	AAPL	Stock	165.45	165.54	165.1915	165.26	1554253.0
2022-08-04 14:00:00	AAPL	Stock	165.26	165.34	165.01	165.265	1543917.0
2022-08-04 14:30:00	AAPL	Stock	165.2785	165.61	165.01	165.55	1764891.0
2022-08-04 15:00:00	AAPL	Stock	165.55	166.06	165.535	165.94	3011728.0
2022-08-04 15:30:00	AAPL	Stock	165.95	165.98	165.27	165.82	4737387.0
2022-08-04 16:00:00	AAPL	Stock	165.82	165.85	165.6	165.62	4289816.0
2022-08-04 16:30:00	AAPL	Stock	165.6388	165.81	165.61	165.69	26702.0
2022-08-04 17:00:00	AAPL	Stock	165.64	165.6962	165.63	165.65	5269.0
2022-08-04 17:30:00	AAPL	Stock	165.65	165.6679	165.61	165.66	5789.0
2022-08-04 18:00:00	AAPL	Stock	165.63	165.67	165.61	165.65	6193.0
2022-08-04 18:30:00	AAPL	Stock	165.65	165.77	165.65	165.71	9076.0
2022-08-04 19:00:00	AAPL	Stock	165.7	165.81	165.69	165.81	18128.0
2022-08-04 19:30:00	AAPL	Stock	165.81	165.86	165.75	165.86	15124.0
2022-08-04 04:00:00	MSFT	Stock	281.85	282.0	281.77	281.89	907.0
2022-08-04 04:30:00	MSFT	Stock	281.84	281.84	281.15	281.19	3206.0
2022-08-04 05:00:00	MSFT	Stock	281.4	281.6	281.4	281.6	2149.0
2022-08-04 05:30:00	MSFT	Stock	281.8	281.8	281.8	281.8	3570.0
2022-08-04 06:00:00	MSFT	Stock	282.4	282.98	282.4	282.98	1892.0
2022-08-04 06:30:00	MSFT	Stock	282.95	283.3	282.95	283.16	3109.0
2022-08-04 07:00:00	MSFT	Stock	283.0	283.01	281.9	282.03	13082.0
2022-08-04 07:30:00	MSFT	Stock	282.03	282.47	281.67	281.72	10606.0
2022-08-04 08:00:00	MSFT	Stock	283.1983	283.1983	281.21	281.81	21002.0
2022-08-04 08:30:00	MSFT	Stock	281.9	282.84	281.9	282.71	7197.0
2022-08-04 09:00:00	MSFT	Stock	282.68	282.84	281.56	281.84	15678.0
2022-08-04 09:30:00	MSFT	Stock	281.9	283.4	281.11	282.78	1875381.0
2022-08-04 10:00:00	MSFT	Stock	282.745	283.36	280.95	281.12	992516.0
2022-08-04 10:30:00	MSFT	Stock	281.15	281.94	280.1677	281.73	1196717.0
2022-08-04 11:00:00	MSFT	Stock	281.73	282.1233	280.54	281.1532	618688.0
2022-08-04 11:30:00	MSFT	Stock	281.16	282.94	281.05	282.77	594007.0
2022-08-04 12:00:00	MSFT	Stock	282.78	283.75	282.44	283.34	696930.0
2022-08-04 12:30:00	MSFT	Stock	283.34	283.35	281.35	281.36	699211.0

> showing 50 of 107,763 rows — these rows as CSV

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