PREVIEW / stock_30min / 2022-06-29

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-29.parquet
  size:    2.1 MB
  rows:    103,836
  symbols: 2,257

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-29 04:00:00	AAPL	Stock	137.44	138.0	137.3	137.41	6982.0
2022-06-29 04:30:00	AAPL	Stock	137.6	137.6	137.4	137.46	6089.0
2022-06-29 05:00:00	AAPL	Stock	137.5	137.52	137.45	137.47	1617.0
2022-06-29 05:30:00	AAPL	Stock	137.47	137.47	136.88	136.9	13668.0
2022-06-29 06:00:00	AAPL	Stock	136.87	137.2	136.87	137.16	7409.0
2022-06-29 06:30:00	AAPL	Stock	137.07	137.3	136.96	137.06	12824.0
2022-06-29 07:00:00	AAPL	Stock	137.22	137.22	136.95	137.02	21913.0
2022-06-29 07:30:00	AAPL	Stock	137.08	137.72	137.0	137.6	37008.0
2022-06-29 08:00:00	AAPL	Stock	137.09	138.38	136.92	137.66	122901.0
2022-06-29 08:30:00	AAPL	Stock	137.69	137.69	137.08	137.33	142653.0
2022-06-29 09:00:00	AAPL	Stock	137.2201	137.73	137.22	137.48	196483.0
2022-06-29 09:30:00	AAPL	Stock	137.46	139.63	136.67	139.5299	8531024.0
2022-06-29 10:00:00	AAPL	Stock	139.51	140.14	138.75	139.72	5740928.0
2022-06-29 10:30:00	AAPL	Stock	139.7099	140.67	139.41	140.06	4838762.0
2022-06-29 11:00:00	AAPL	Stock	140.07	140.2199	139.44	139.725	3874352.0
2022-06-29 11:30:00	AAPL	Stock	139.73	140.27	139.55	140.0	2687083.0
2022-06-29 12:00:00	AAPL	Stock	139.99	140.05	138.695	138.76	2904979.0
2022-06-29 12:30:00	AAPL	Stock	138.75	139.413	138.73	139.13	2624328.0
2022-06-29 13:00:00	AAPL	Stock	139.14	139.3962	138.7399	139.085	2357370.0
2022-06-29 13:30:00	AAPL	Stock	139.09	139.72	138.91	139.64	2284891.0
2022-06-29 14:00:00	AAPL	Stock	139.64	140.18	139.58	139.885	2921701.0
2022-06-29 14:30:00	AAPL	Stock	139.88	139.91	138.93	139.16	2754756.0
2022-06-29 15:00:00	AAPL	Stock	139.165	140.04	138.9725	140.0331	4124217.0
2022-06-29 15:30:00	AAPL	Stock	140.0395	140.05	138.81	139.25	6867633.0
2022-06-29 16:00:00	AAPL	Stock	139.24	139.49	139.0	139.12	5439781.0
2022-06-29 16:30:00	AAPL	Stock	139.12	139.23	139.1	139.2	14401.0
2022-06-29 17:00:00	AAPL	Stock	139.2	139.21	139.15	139.1999	9367.0
2022-06-29 17:30:00	AAPL	Stock	139.16	139.2	139.05	139.08	14858.0
2022-06-29 18:00:00	AAPL	Stock	139.15	139.23	139.08	139.2	114301.0
2022-06-29 18:30:00	AAPL	Stock	139.23	139.23	139.11	139.15	15327.0
2022-06-29 19:00:00	AAPL	Stock	139.11	139.18	139.1	139.1	2237.0
2022-06-29 19:30:00	AAPL	Stock	139.08	139.18	138.9999	139.14	19895.0
2022-06-29 04:00:00	MSFT	Stock	256.57	257.16	256.52	256.88	2259.0
2022-06-29 04:30:00	MSFT	Stock	256.72	256.72	256.72	256.72	167.0
2022-06-29 05:30:00	MSFT	Stock	256.06	256.06	255.51	255.51	898.0
2022-06-29 06:00:00	MSFT	Stock	255.78	256.16	255.75	255.8	1526.0
2022-06-29 06:30:00	MSFT	Stock	255.8	256.16	255.8	255.8	876.0
2022-06-29 07:00:00	MSFT	Stock	255.81	255.88	255.61	255.74	1900.0
2022-06-29 07:30:00	MSFT	Stock	256.18	257.2	256.18	257.2	10652.0
2022-06-29 08:00:00	MSFT	Stock	256.0	257.77	255.75	257.0	29240.0
2022-06-29 08:30:00	MSFT	Stock	256.56	256.8	255.61	256.48	10994.0
2022-06-29 09:00:00	MSFT	Stock	256.81	257.59	256.31	257.59	14031.0
2022-06-29 09:30:00	MSFT	Stock	257.59	260.8	255.76	260.755	2120640.0
2022-06-29 10:00:00	MSFT	Stock	260.7	261.97	259.34	260.65	1520299.0
2022-06-29 10:30:00	MSFT	Stock	260.68	261.78	259.78	260.92	992414.0
2022-06-29 11:00:00	MSFT	Stock	260.92	261.32	260.16	261.05	782193.0
2022-06-29 11:30:00	MSFT	Stock	261.09	261.94	260.19	260.32	811587.0
2022-06-29 12:00:00	MSFT	Stock	260.32	260.54	258.63	258.76	620580.0
2022-06-29 12:30:00	MSFT	Stock	258.75	259.91	258.71	259.67	535828.0
2022-06-29 13:00:00	MSFT	Stock	259.705	260.375	259.17	259.79	539267.0

> showing 50 of 103,836 rows — these rows as CSV

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