PREVIEW / stock_30min / 2022-07-01

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-01.parquet
  size:    2.0 MB
  rows:    101,461
  symbols: 2,270

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-01 04:00:00	AAPL	Stock	135.76	136.1	135.32	136.05	34058.0
2022-07-01 04:30:00	AAPL	Stock	136.06	136.32	135.97	136.32	10628.0
2022-07-01 05:00:00	AAPL	Stock	136.12	136.58	136.04	136.27	11178.0
2022-07-01 05:30:00	AAPL	Stock	136.36	136.59	136.06	136.41	23060.0
2022-07-01 06:00:00	AAPL	Stock	136.5	136.5	136.15	136.25	12816.0
2022-07-01 06:30:00	AAPL	Stock	136.25	136.26	135.89	135.89	27243.0
2022-07-01 07:00:00	AAPL	Stock	135.98	136.3	135.94	136.28	41560.0
2022-07-01 07:30:00	AAPL	Stock	136.28	136.35	135.42	135.65	56229.0
2022-07-01 08:00:00	AAPL	Stock	136.08	136.72	135.45	135.77	312564.0
2022-07-01 08:30:00	AAPL	Stock	135.72	136.3	135.68	136.05	161127.0
2022-07-01 09:00:00	AAPL	Stock	136.07	136.72	135.92	136.05	198733.0
2022-07-01 09:30:00	AAPL	Stock	136.04	138.13	136.04	137.74	8701639.0
2022-07-01 10:00:00	AAPL	Stock	137.75	138.32	136.0	136.09	5669665.0
2022-07-01 10:30:00	AAPL	Stock	136.0999	136.924	135.66	136.59	4871976.0
2022-07-01 11:00:00	AAPL	Stock	136.58	137.25	136.16	136.6012	3632470.0
2022-07-01 11:30:00	AAPL	Stock	136.6	137.05	136.21	136.35	2705138.0
2022-07-01 12:00:00	AAPL	Stock	136.355	137.1899	136.0718	137.02	2839649.0
2022-07-01 12:30:00	AAPL	Stock	137.03	137.12	136.52	136.52	2243284.0
2022-07-01 13:00:00	AAPL	Stock	136.505	137.07	136.44	137.05	2195154.0
2022-07-01 13:30:00	AAPL	Stock	137.06	137.72	137.02	137.7178	2748717.0
2022-07-01 14:00:00	AAPL	Stock	137.715	138.1	137.24	137.87	2518507.0
2022-07-01 14:30:00	AAPL	Stock	137.87	138.56	137.845	138.375	3119678.0
2022-07-01 15:00:00	AAPL	Stock	138.38	138.4499	137.851	138.265	3211033.0
2022-07-01 15:30:00	AAPL	Stock	138.27	139.04	138.205	138.94	8002041.0
2022-07-01 16:00:00	AAPL	Stock	138.899	139.23	138.8701	138.8701	8344533.0
2022-07-01 16:30:00	AAPL	Stock	138.86	139.04	138.85	139.03	43223.0
2022-07-01 17:00:00	AAPL	Stock	139.03	139.04	138.94	138.95	39770.0
2022-07-01 17:30:00	AAPL	Stock	139.0	139.05	138.941	138.97	20787.0
2022-07-01 18:00:00	AAPL	Stock	138.97	139.0	138.92	138.95	16877.0
2022-07-01 18:30:00	AAPL	Stock	138.99	139.02	138.92	138.96	13117.0
2022-07-01 19:00:00	AAPL	Stock	138.96	138.98	138.93	138.95	3709.0
2022-07-01 19:30:00	AAPL	Stock	138.94	139.03	138.94	139.02	8728.0
2022-07-01 04:00:00	MSFT	Stock	255.53	256.0	254.55	256.0	2762.0
2022-07-01 04:30:00	MSFT	Stock	256.0	256.49	255.94	256.49	2585.0
2022-07-01 05:00:00	MSFT	Stock	256.47	256.5	256.47	256.5	275.0
2022-07-01 05:30:00	MSFT	Stock	256.82	256.82	256.7	256.81	500.0
2022-07-01 06:00:00	MSFT	Stock	256.69	256.73	256.3	256.3	594.0
2022-07-01 06:30:00	MSFT	Stock	256.31	256.31	255.49	255.6	7133.0
2022-07-01 07:00:00	MSFT	Stock	255.6	256.5	255.6	256.5	2751.0
2022-07-01 07:30:00	MSFT	Stock	256.25	256.47	254.8	255.0	8324.0
2022-07-01 08:00:00	MSFT	Stock	256.3	256.54	254.8001	256.1	6888.0
2022-07-01 08:30:00	MSFT	Stock	255.906	256.8999	255.88	256.89	6781.0
2022-07-01 09:00:00	MSFT	Stock	256.8	256.83	255.8	256.39	15292.0
2022-07-01 09:30:00	MSFT	Stock	256.39	258.37	254.61	257.78	2017645.0
2022-07-01 10:00:00	MSFT	Stock	257.77	258.97	255.41	255.71	1203151.0
2022-07-01 10:30:00	MSFT	Stock	255.74	256.79	254.941	256.07	919857.0
2022-07-01 11:00:00	MSFT	Stock	256.025	257.4758	255.56	256.24	938504.0
2022-07-01 11:30:00	MSFT	Stock	256.27	257.18	255.72	256.02	783666.0
2022-07-01 12:00:00	MSFT	Stock	256.02	256.85	255.47	256.85	690619.0
2022-07-01 12:30:00	MSFT	Stock	256.84	257.11	256.0217	256.0217	610860.0

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

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