PREVIEW / stock_30min / 2022-06-30

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-30.parquet
  size:    2.1 MB
  rows:    105,900
  symbols: 2,418

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-06-30 04:00:00	AAPL	Stock	138.11	139.1	137.19	137.29	31735.0
2022-06-30 04:30:00	AAPL	Stock	137.22	137.59	137.04	137.22	25284.0
2022-06-30 05:00:00	AAPL	Stock	137.2	137.31	136.51	136.52	25317.0
2022-06-30 05:30:00	AAPL	Stock	136.51	136.85	136.5	136.85	6234.0
2022-06-30 06:00:00	AAPL	Stock	136.9	136.97	136.69	136.69	5261.0
2022-06-30 06:30:00	AAPL	Stock	136.7	136.9	136.6	136.8	17527.0
2022-06-30 07:00:00	AAPL	Stock	136.92	137.0	136.63	136.93	65166.0
2022-06-30 07:30:00	AAPL	Stock	136.88	136.88	136.55	136.73	34834.0
2022-06-30 08:00:00	AAPL	Stock	136.8	137.0899	136.6	137.0598	234739.0
2022-06-30 08:30:00	AAPL	Stock	137.0	137.82	137.0	137.02	313376.0
2022-06-30 09:00:00	AAPL	Stock	137.04	137.38	136.75	137.22	242193.0
2022-06-30 09:30:00	AAPL	Stock	137.24	137.6	134.92	134.945	9775250.0
2022-06-30 10:00:00	AAPL	Stock	134.96	134.98	133.7737	134.495	7692405.0
2022-06-30 10:30:00	AAPL	Stock	134.5	135.6	134.36	135.5	4831513.0
2022-06-30 11:00:00	AAPL	Stock	135.51	137.07	135.22	136.62	4841313.0
2022-06-30 11:30:00	AAPL	Stock	136.64	137.68	136.26	137.385	5400699.0
2022-06-30 12:00:00	AAPL	Stock	137.385	137.95	136.486	137.86	4546211.0
2022-06-30 12:30:00	AAPL	Stock	137.86	138.37	137.55	137.715	4078583.0
2022-06-30 13:00:00	AAPL	Stock	137.72	137.9732	136.87	137.42	3130757.0
2022-06-30 13:30:00	AAPL	Stock	137.43	138.12	137.21	137.97	2997002.0
2022-06-30 14:00:00	AAPL	Stock	137.97	138.15	136.93	137.215	3615471.0
2022-06-30 14:30:00	AAPL	Stock	137.22	137.3394	136.48	136.6241	3119556.0
2022-06-30 15:00:00	AAPL	Stock	136.64	136.8	135.7	136.745	4933271.0
2022-06-30 15:30:00	AAPL	Stock	136.74	137.44	135.7701	136.76	10089843.0
2022-06-30 16:00:00	AAPL	Stock	136.83	137.06	136.27	136.78	18278237.0
2022-06-30 16:30:00	AAPL	Stock	136.7351	136.88	136.7	136.77	81506.0
2022-06-30 17:00:00	AAPL	Stock	136.75	136.85	136.65	136.66	52130.0
2022-06-30 17:30:00	AAPL	Stock	136.66	136.7	136.64	136.69	9011.0
2022-06-30 18:00:00	AAPL	Stock	136.67	136.67	136.2	136.38	33439.0
2022-06-30 18:30:00	AAPL	Stock	136.38	136.63	136.38	136.55	14354.0
2022-06-30 19:00:00	AAPL	Stock	136.63	136.78	136.47	136.71	26546.0
2022-06-30 19:30:00	AAPL	Stock	136.77	137.15	136.62	136.73	25400.0
2022-06-30 04:00:00	MSFT	Stock	258.49	258.49	256.1	256.11	37533.0
2022-06-30 04:30:00	MSFT	Stock	256.11	256.39	255.97	256.1	11651.0
2022-06-30 05:00:00	MSFT	Stock	256.15	256.15	254.32	254.75	4285.0
2022-06-30 05:30:00	MSFT	Stock	254.8	255.35	254.75	255.35	1644.0
2022-06-30 06:00:00	MSFT	Stock	255.3	255.3	255.3	255.3	498.0
2022-06-30 06:30:00	MSFT	Stock	254.99	255.7	254.99	255.7	3294.0
2022-06-30 07:00:00	MSFT	Stock	255.94	256.0	255.27	255.89	9181.0
2022-06-30 07:30:00	MSFT	Stock	255.88	255.88	255.0	255.64	6924.0
2022-06-30 08:00:00	MSFT	Stock	255.7	256.25	255.0	256.17	20357.0
2022-06-30 08:30:00	MSFT	Stock	256.0	258.67	256.0	256.0	40818.0
2022-06-30 09:00:00	MSFT	Stock	255.86	257.4	255.85	257.1	24468.0
2022-06-30 09:30:00	MSFT	Stock	257.06	258.97	254.62	254.7	1999414.0
2022-06-30 10:00:00	MSFT	Stock	254.74	254.79	252.9	254.3411	1704631.0
2022-06-30 10:30:00	MSFT	Stock	254.32	256.93	254.1799	256.82	1116040.0
2022-06-30 11:00:00	MSFT	Stock	256.82	258.65	256.17	257.87	1049210.0
2022-06-30 11:30:00	MSFT	Stock	257.89	258.58	257.01	258.49	761042.0
2022-06-30 12:00:00	MSFT	Stock	258.5	259.35	256.96	258.92	916154.0
2022-06-30 12:30:00	MSFT	Stock	258.93	259.53	258.26	258.64	753363.0

> showing 50 of 105,900 rows — these rows as CSV

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