PREVIEW / stock_30min / 2022-07-08

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-08.parquet
  size:    2.0 MB
  rows:    101,314
  symbols: 2,302

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-07-08 04:00:00	AAPL	Stock	145.74	145.86	145.5	145.5	5715.0
2022-07-08 04:30:00	AAPL	Stock	145.35	145.59	145.3	145.47	5490.0
2022-07-08 05:00:00	AAPL	Stock	145.36	145.36	145.19	145.3	6949.0
2022-07-08 05:30:00	AAPL	Stock	145.4	145.51	145.4	145.51	2713.0
2022-07-08 06:00:00	AAPL	Stock	145.51	145.88	145.49	145.81	11306.0
2022-07-08 06:30:00	AAPL	Stock	145.81	145.81	145.41	145.44	3980.0
2022-07-08 07:00:00	AAPL	Stock	145.59	145.72	145.5	145.72	16427.0
2022-07-08 07:30:00	AAPL	Stock	145.75	145.76	145.64	145.7	13907.0
2022-07-08 08:00:00	AAPL	Stock	145.5525	145.985	145.0	145.72	120710.0
2022-07-08 08:30:00	AAPL	Stock	145.72	145.74	144.25	144.86	498290.0
2022-07-08 09:00:00	AAPL	Stock	144.9	145.41	144.8	145.18	230582.0
2022-07-08 09:30:00	AAPL	Stock	145.21	146.62	145.0	145.77	8178009.0
2022-07-08 10:00:00	AAPL	Stock	145.77	147.025	145.4859	146.93	6652256.0
2022-07-08 10:30:00	AAPL	Stock	146.9323	147.2699	146.39	146.86	4143012.0
2022-07-08 11:00:00	AAPL	Stock	146.86	147.46	146.85	147.35	3642231.0
2022-07-08 11:30:00	AAPL	Stock	147.345	147.39	146.82	147.25	2774035.0
2022-07-08 12:00:00	AAPL	Stock	147.25	147.3	146.07	146.107	2702953.0
2022-07-08 12:30:00	AAPL	Stock	146.1	146.26	145.54	145.79	3271610.0
2022-07-08 13:00:00	AAPL	Stock	145.7906	146.59	145.54	146.5803	2724059.0
2022-07-08 13:30:00	AAPL	Stock	146.58	147.11	146.47	146.845	2891786.0
2022-07-08 14:00:00	AAPL	Stock	146.85	147.34	146.62	147.27	2920783.0
2022-07-08 14:30:00	AAPL	Stock	147.2613	147.55	147.195	147.46	2797041.0
2022-07-08 15:00:00	AAPL	Stock	147.46	147.54	147.2	147.355	2718174.0
2022-07-08 15:30:00	AAPL	Stock	147.355	147.5	146.84	147.03	6039366.0
2022-07-08 16:00:00	AAPL	Stock	147.03	147.04	146.66	147.01	4575977.0
2022-07-08 16:30:00	AAPL	Stock	147.01	147.03	146.97	147.02	83455.0
2022-07-08 17:00:00	AAPL	Stock	147.0	147.04	146.81	146.95	57044.0
2022-07-08 17:30:00	AAPL	Stock	146.95	146.98	146.77	146.8	20503.0
2022-07-08 18:00:00	AAPL	Stock	146.97	147.03	146.82	147.02	14878.0
2022-07-08 18:30:00	AAPL	Stock	147.0	147.0	146.9	146.99	5542.0
2022-07-08 19:00:00	AAPL	Stock	146.99	147.0	146.8999	147.0	15498.0
2022-07-08 19:30:00	AAPL	Stock	146.98	147.0	146.77	146.78	9272.0
2022-07-08 04:00:00	MSFT	Stock	267.63	267.83	267.63	267.83	298.0
2022-07-08 04:30:00	MSFT	Stock	267.29	267.29	267.29	267.29	100.0
2022-07-08 05:00:00	MSFT	Stock	266.58	266.75	266.1	266.75	3131.0
2022-07-08 05:30:00	MSFT	Stock	267.15	267.2	267.15	267.2	200.0
2022-07-08 06:30:00	MSFT	Stock	267.9	267.9	267.2	267.2	379.0
2022-07-08 07:00:00	MSFT	Stock	266.8	267.45	266.8	267.45	2269.0
2022-07-08 07:30:00	MSFT	Stock	267.45	267.9	267.3	267.9	1500.0
2022-07-08 08:00:00	MSFT	Stock	267.1903	267.729	266.8	267.25	20759.0
2022-07-08 08:30:00	MSFT	Stock	267.25	267.25	264.1259	265.55	84085.0
2022-07-08 09:00:00	MSFT	Stock	265.6499	265.766	263.7	264.58	45022.0
2022-07-08 09:30:00	MSFT	Stock	264.63	266.27	263.66	263.92	1987101.0
2022-07-08 10:00:00	MSFT	Stock	263.93	265.42	263.285	265.2822	1349297.0
2022-07-08 10:30:00	MSFT	Stock	265.33	265.8185	264.59	265.77	1188248.0
2022-07-08 11:00:00	MSFT	Stock	265.7703	267.3	265.75	267.2426	897436.0
2022-07-08 11:30:00	MSFT	Stock	267.2391	268.02	266.83	267.98	726058.0
2022-07-08 12:00:00	MSFT	Stock	268.0	268.02	266.25	266.27	546365.0
2022-07-08 12:30:00	MSFT	Stock	266.26	266.3899	265.2	265.35	513784.0
2022-07-08 13:00:00	MSFT	Stock	265.33	266.4399	265.0579	266.42	535036.0

> showing 50 of 101,314 rows — these rows as CSV

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