PREVIEW / stock_30min / 2022-07-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-07.parquet
  size:    2.1 MB
  rows:    103,671
  symbols: 2,324

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-07 04:00:00	AAPL	Stock	143.15	143.66	143.15	143.54	11078.0
2022-07-07 04:30:00	AAPL	Stock	143.6	143.62	143.16	143.6	32211.0
2022-07-07 05:00:00	AAPL	Stock	143.47	143.49	143.26	143.31	6066.0
2022-07-07 05:30:00	AAPL	Stock	143.29	143.34	143.04	143.07	5345.0
2022-07-07 06:00:00	AAPL	Stock	143.13	143.13	142.8	142.88	4997.0
2022-07-07 06:30:00	AAPL	Stock	143.09	143.3	143.09	143.21	10116.0
2022-07-07 07:00:00	AAPL	Stock	143.22	143.38	143.15	143.23	15969.0
2022-07-07 07:30:00	AAPL	Stock	143.25	143.56	143.24	143.56	25643.0
2022-07-07 08:00:00	AAPL	Stock	143.25	143.57	142.563	143.27	134282.0
2022-07-07 08:30:00	AAPL	Stock	143.3	143.5	143.05	143.32	132191.0
2022-07-07 09:00:00	AAPL	Stock	143.3599	143.43	142.95	143.29	147446.0
2022-07-07 09:30:00	AAPL	Stock	143.27	145.401	143.27	145.23	9656767.0
2022-07-07 10:00:00	AAPL	Stock	145.225	145.99	144.91	145.9206	6767560.0
2022-07-07 10:30:00	AAPL	Stock	145.925	145.98	145.26	145.3599	3544537.0
2022-07-07 11:00:00	AAPL	Stock	145.36	145.66	145.11	145.12	2679224.0
2022-07-07 11:30:00	AAPL	Stock	145.11	145.5599	145.01	145.55	2648739.0
2022-07-07 12:00:00	AAPL	Stock	145.545	145.84	145.45	145.76	2252014.0
2022-07-07 12:30:00	AAPL	Stock	145.76	145.99	145.64	145.89	2516365.0
2022-07-07 13:00:00	AAPL	Stock	145.895	146.0	145.53	145.7603	2017925.0
2022-07-07 13:30:00	AAPL	Stock	145.77	146.49	145.68	146.36	2971031.0
2022-07-07 14:00:00	AAPL	Stock	146.355	146.55	146.18	146.2601	2517199.0
2022-07-07 14:30:00	AAPL	Stock	146.27	146.28	146.0101	146.1953	2167450.0
2022-07-07 15:00:00	AAPL	Stock	146.2	146.55	146.12	146.1792	3307579.0
2022-07-07 15:30:00	AAPL	Stock	146.175	146.55	146.11	146.35	7103097.0
2022-07-07 16:00:00	AAPL	Stock	146.34	146.4	146.13	146.13	8144056.0
2022-07-07 16:30:00	AAPL	Stock	146.14	146.17	146.04	146.07	34166.0
2022-07-07 17:00:00	AAPL	Stock	146.02	146.09	145.95	146.0	27145.0
2022-07-07 17:30:00	AAPL	Stock	146.03	146.33	146.02	146.1	16268.0
2022-07-07 18:00:00	AAPL	Stock	146.06	146.11	146.01	146.04	8776.0
2022-07-07 18:30:00	AAPL	Stock	146.03	146.05	145.86	145.99	14296.0
2022-07-07 19:00:00	AAPL	Stock	145.99	146.07	145.84	145.85	14914.0
2022-07-07 19:30:00	AAPL	Stock	145.85	145.96	145.83	145.9	15405.0
2022-07-07 04:00:00	MSFT	Stock	267.58	267.58	267.58	267.58	200.0
2022-07-07 04:30:00	MSFT	Stock	267.02	267.7	266.98	267.7	416.0
2022-07-07 05:00:00	MSFT	Stock	267.03	267.65	266.75	267.03	800.0
2022-07-07 05:30:00	MSFT	Stock	266.58	267.09	265.81	266.0	1680.0
2022-07-07 06:00:00	MSFT	Stock	266.05	266.05	265.63	265.98	1227.0
2022-07-07 06:30:00	MSFT	Stock	266.3	266.3	266.3	266.3	100.0
2022-07-07 07:00:00	MSFT	Stock	266.79	266.86	266.41	266.55	4226.0
2022-07-07 07:30:00	MSFT	Stock	266.55	267.17	266.55	266.95	3061.0
2022-07-07 08:00:00	MSFT	Stock	266.7999	267.35	265.545	266.62	24778.0
2022-07-07 08:30:00	MSFT	Stock	267.0	267.0	266.13	266.41	15173.0
2022-07-07 09:00:00	MSFT	Stock	266.45	266.45	264.84	265.05	34445.0
2022-07-07 09:30:00	MSFT	Stock	265.17	268.155	265.02	267.711	1962101.0
2022-07-07 10:00:00	MSFT	Stock	267.78	269.055	266.865	268.81	1337356.0
2022-07-07 10:30:00	MSFT	Stock	268.82	268.9242	267.885	268.0712	731558.0
2022-07-07 11:00:00	MSFT	Stock	268.1	268.56	267.3	267.36	700550.0
2022-07-07 11:30:00	MSFT	Stock	267.365	268.175	267.05	268.03	618567.0
2022-07-07 12:00:00	MSFT	Stock	268.01	268.08	267.42	267.715	448869.0
2022-07-07 12:30:00	MSFT	Stock	267.72	267.9716	267.37	267.69	636401.0

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

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