PREVIEW / stock_30min / 2021-06-29

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-29.parquet
  size:    2.2 MB
  rows:    113,075
  symbols: 2,918

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
2021-06-29 04:00:00	AAPL	Stock	134.62	134.65	134.22	134.24	3310.0
2021-06-29 04:30:00	AAPL	Stock	134.22	134.3	134.21	134.28	4282.0
2021-06-29 05:00:00	AAPL	Stock	134.39	134.4	134.35	134.4	1644.0
2021-06-29 05:30:00	AAPL	Stock	134.4	134.5	134.4	134.5	1029.0
2021-06-29 06:00:00	AAPL	Stock	134.5	134.52	134.46	134.46	2128.0
2021-06-29 06:30:00	AAPL	Stock	134.47	134.57	134.47	134.57	1439.0
2021-06-29 07:00:00	AAPL	Stock	134.59	134.75	134.54	134.54	20463.0
2021-06-29 07:30:00	AAPL	Stock	134.55	134.56	134.45	134.52	23892.0
2021-06-29 08:00:00	AAPL	Stock	134.65	134.72	134.444	134.63	117573.0
2021-06-29 08:30:00	AAPL	Stock	134.63	134.64	134.45	134.57	70365.0
2021-06-29 09:00:00	AAPL	Stock	134.58	134.98	134.55	134.82	119421.0
2021-06-29 09:30:00	AAPL	Stock	134.82	135.62	134.35	135.47	9052038.0
2021-06-29 10:00:00	AAPL	Stock	135.47	135.63	135.2	135.51	4478122.0
2021-06-29 10:30:00	AAPL	Stock	135.51	136.08	135.45	136.0043	5361968.0
2021-06-29 11:00:00	AAPL	Stock	136.0025	136.17	135.78	136.07	3938525.0
2021-06-29 11:30:00	AAPL	Stock	136.07	136.16	135.93	136.03	2959508.0
2021-06-29 12:00:00	AAPL	Stock	136.04	136.475	136.005	136.4499	3284136.0
2021-06-29 12:30:00	AAPL	Stock	136.45	136.465	136.18	136.43	2279828.0
2021-06-29 13:00:00	AAPL	Stock	136.43	136.49	136.11	136.2001	2365908.0
2021-06-29 13:30:00	AAPL	Stock	136.203	136.43	136.15	136.385	1941085.0
2021-06-29 14:00:00	AAPL	Stock	136.38	136.48	136.23	136.2481	1953320.0
2021-06-29 14:30:00	AAPL	Stock	136.243	136.46	136.09	136.4422	3082216.0
2021-06-29 15:00:00	AAPL	Stock	136.445	136.48	136.22	136.33	2995463.0
2021-06-29 15:30:00	AAPL	Stock	136.33	136.45	136.16	136.33	5617087.0
2021-06-29 16:00:00	AAPL	Stock	136.3201	136.47	136.25	136.39	3706914.0
2021-06-29 16:30:00	AAPL	Stock	136.39	136.44	136.33	136.42	25003.0
2021-06-29 17:00:00	AAPL	Stock	136.41	136.44	136.39	136.39	12659.0
2021-06-29 17:30:00	AAPL	Stock	136.38	136.4	136.33	136.35	17717.0
2021-06-29 18:00:00	AAPL	Stock	136.35	136.4	136.33	136.3999	19272.0
2021-06-29 18:30:00	AAPL	Stock	136.3999	136.4	136.27	136.29	49334.0
2021-06-29 19:00:00	AAPL	Stock	136.29	136.42	136.28	136.4	29005.0
2021-06-29 19:30:00	AAPL	Stock	136.3501	136.42	136.34	136.42	32585.0
2021-06-29 04:00:00	MSFT	Stock	268.46	268.46	268.16	268.4	2416.0
2021-06-29 04:30:00	MSFT	Stock	268.32	268.6	268.32	268.6	3179.0
2021-06-29 05:00:00	MSFT	Stock	268.6	268.67	268.6	268.67	300.0
2021-06-29 05:30:00	MSFT	Stock	268.62	268.91	268.61	268.91	750.0
2021-06-29 06:30:00	MSFT	Stock	268.9	268.93	268.8	268.93	345.0
2021-06-29 07:00:00	MSFT	Stock	269.08	269.19	268.83	268.86	1747.0
2021-06-29 07:30:00	MSFT	Stock	268.8	268.95	268.6	268.6	2462.0
2021-06-29 08:00:00	MSFT	Stock	268.97	269.391	268.32	268.65	9876.0
2021-06-29 08:30:00	MSFT	Stock	268.7	268.71	268.51	268.62	6661.0
2021-06-29 09:00:00	MSFT	Stock	268.595	269.55	268.56	268.88	23248.0
2021-06-29 09:30:00	MSFT	Stock	268.88	269.89	267.98	269.37	2033002.0
2021-06-29 10:00:00	MSFT	Stock	269.37	269.79	269.0	269.08	1038516.0
2021-06-29 10:30:00	MSFT	Stock	269.09	269.9	268.995	269.76	791952.0
2021-06-29 11:00:00	MSFT	Stock	269.76	269.83	269.3601	269.53	641250.0
2021-06-29 11:30:00	MSFT	Stock	269.535	269.94	269.46	269.84	525784.0
2021-06-29 12:00:00	MSFT	Stock	269.85	270.4	269.74	270.4	712779.0
2021-06-29 12:30:00	MSFT	Stock	270.41	271.02	270.165	270.91	959695.0
2021-06-29 13:00:00	MSFT	Stock	270.9	271.035	270.73	270.835	619643.0

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

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