PREVIEW / stock_30min / 2022-08-08

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-08-08.parquet
  size:    2.2 MB
  rows:    108,675
  symbols: 2,303

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-08 04:00:00	AAPL	Stock	166.24	166.24	165.59	165.83	17977.0
2022-08-08 04:30:00	AAPL	Stock	165.84	165.98	165.7	165.89	12836.0
2022-08-08 05:00:00	AAPL	Stock	165.96	166.1	165.74	165.74	5704.0
2022-08-08 05:30:00	AAPL	Stock	165.82	165.86	165.77	165.81	1910.0
2022-08-08 06:00:00	AAPL	Stock	165.81	166.09	165.81	166.09	9451.0
2022-08-08 06:30:00	AAPL	Stock	166.02	166.45	166.0	166.44	16315.0
2022-08-08 07:00:00	AAPL	Stock	166.36	166.45	166.2	166.22	69556.0
2022-08-08 07:30:00	AAPL	Stock	166.19	166.58	166.1	166.37	132359.0
2022-08-08 08:00:00	AAPL	Stock	166.2602	166.66	164.937	166.62	318019.0
2022-08-08 08:30:00	AAPL	Stock	166.6	166.68	166.39	166.68	142665.0
2022-08-08 09:00:00	AAPL	Stock	166.67	166.9	165.8	166.37	403943.0
2022-08-08 09:30:00	AAPL	Stock	166.37	167.78	165.9	167.48	7974394.0
2022-08-08 10:00:00	AAPL	Stock	167.46	167.81	166.8	166.97	3853737.0
2022-08-08 10:30:00	AAPL	Stock	166.99	167.22	166.45	166.59	2765328.0
2022-08-08 11:00:00	AAPL	Stock	166.595	167.07	165.96	166.1	2723025.0
2022-08-08 11:30:00	AAPL	Stock	166.095	166.43	165.12	165.68	3355302.0
2022-08-08 12:00:00	AAPL	Stock	165.68	165.7501	164.55	164.7184	3070931.0
2022-08-08 12:30:00	AAPL	Stock	164.72	165.25	164.5609	165.05	2387051.0
2022-08-08 13:00:00	AAPL	Stock	165.04	165.55	164.84	164.86	1919797.0
2022-08-08 13:30:00	AAPL	Stock	164.87	165.34	164.69	165.2825	1813974.0
2022-08-08 14:00:00	AAPL	Stock	165.29	165.3059	164.44	164.71	1985083.0
2022-08-08 14:30:00	AAPL	Stock	164.715	164.7998	164.2	164.585	2034286.0
2022-08-08 15:00:00	AAPL	Stock	164.5875	165.17	164.505	164.89	2074422.0
2022-08-08 15:30:00	AAPL	Stock	164.9	165.1	164.705	164.88	3628342.0
2022-08-08 16:00:00	AAPL	Stock	164.87	165.0	164.8115	164.85	3172712.0
2022-08-08 16:30:00	AAPL	Stock	164.87	164.99	164.82	164.99	43661.0
2022-08-08 17:00:00	AAPL	Stock	165.0	165.16	164.94	165.1342	22080.0
2022-08-08 17:30:00	AAPL	Stock	165.12	165.15	165.04	165.04	3787.0
2022-08-08 18:00:00	AAPL	Stock	165.05	165.05	165.0	165.0	14858.0
2022-08-08 18:30:00	AAPL	Stock	164.97	165.03	164.94	165.0	3662.0
2022-08-08 19:00:00	AAPL	Stock	164.95	165.44	164.92	165.28	27081.0
2022-08-08 19:30:00	AAPL	Stock	165.3	165.38	165.12	165.27	28385.0
2022-08-08 04:00:00	MSFT	Stock	283.02	284.01	282.9	283.3	2707.0
2022-08-08 04:30:00	MSFT	Stock	283.71	283.71	283.58	283.58	1311.0
2022-08-08 05:00:00	MSFT	Stock	283.2	283.35	283.12	283.12	850.0
2022-08-08 06:00:00	MSFT	Stock	283.34	283.34	283.34	283.34	264.0
2022-08-08 06:30:00	MSFT	Stock	283.49	284.3	283.49	284.27	1075.0
2022-08-08 07:00:00	MSFT	Stock	284.1	284.34	284.0	284.0	3633.0
2022-08-08 07:30:00	MSFT	Stock	284.02	284.47	284.01	284.4	3300.0
2022-08-08 08:00:00	MSFT	Stock	284.07	284.7	281.81	284.68	11124.0
2022-08-08 08:30:00	MSFT	Stock	284.72	285.0	284.45	284.94	5922.0
2022-08-08 09:00:00	MSFT	Stock	284.9	285.89	283.07	284.06	122260.0
2022-08-08 09:30:00	MSFT	Stock	284.15	285.89	282.46	285.24	2186277.0
2022-08-08 10:00:00	MSFT	Stock	285.27	285.92	284.02	284.4654	1147822.0
2022-08-08 10:30:00	MSFT	Stock	284.45	284.83	283.13	283.49	809408.0
2022-08-08 11:00:00	MSFT	Stock	283.55	284.17	282.59	282.715	733965.0
2022-08-08 11:30:00	MSFT	Stock	282.69	282.93	281.1	282.55	916095.0
2022-08-08 12:00:00	MSFT	Stock	282.54	282.58	280.28	280.77	801575.0
2022-08-08 12:30:00	MSFT	Stock	280.77	281.58	280.39	281.28	450280.0
2022-08-08 13:00:00	MSFT	Stock	281.22	281.53	280.49	280.51	355851.0

> showing 50 of 108,675 rows — these rows as CSV

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