PREVIEW / stock_30min / 2022-06-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-06-27.parquet
  size:    2.1 MB
  rows:    105,465
  symbols: 2,340

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-27 04:00:00	AAPL	Stock	142.0	143.03	142.0	142.81	35546.0
2022-06-27 04:30:00	AAPL	Stock	142.9	142.93	142.5	142.55	20967.0
2022-06-27 05:00:00	AAPL	Stock	142.54	142.68	142.19	142.58	11997.0
2022-06-27 05:30:00	AAPL	Stock	142.58	142.59	142.51	142.55	1838.0
2022-06-27 06:00:00	AAPL	Stock	142.55	142.57	142.0	142.08	11040.0
2022-06-27 06:30:00	AAPL	Stock	142.11	142.42	142.08	142.42	9015.0
2022-06-27 07:00:00	AAPL	Stock	142.41	142.87	142.07	142.71	105449.0
2022-06-27 07:30:00	AAPL	Stock	142.68	142.97	142.68	142.79	52805.0
2022-06-27 08:00:00	AAPL	Stock	142.5588	142.96	142.2312	142.56	250532.0
2022-06-27 08:30:00	AAPL	Stock	142.55	142.65	142.16	142.32	122020.0
2022-06-27 09:00:00	AAPL	Stock	142.32	142.85	142.2901	142.68	152372.0
2022-06-27 09:30:00	AAPL	Stock	142.68	143.49	141.29	141.89	9430469.0
2022-06-27 10:00:00	AAPL	Stock	141.91	142.6337	141.69	141.96	5581234.0
2022-06-27 10:30:00	AAPL	Stock	141.96	142.95	141.888	142.84	3723734.0
2022-06-27 11:00:00	AAPL	Stock	142.8375	142.96	142.225	142.875	2869331.0
2022-06-27 11:30:00	AAPL	Stock	142.8799	143.09	142.45	143.035	2454143.0
2022-06-27 12:00:00	AAPL	Stock	143.0474	143.07	142.31	142.34	2703868.0
2022-06-27 12:30:00	AAPL	Stock	142.33	142.605	142.07	142.5499	2456081.0
2022-06-27 13:00:00	AAPL	Stock	142.55	142.58	142.05	142.16	2067872.0
2022-06-27 13:30:00	AAPL	Stock	142.15	142.19	141.565	141.6754	2258380.0
2022-06-27 14:00:00	AAPL	Stock	141.68	141.92	141.5	141.69	2385639.0
2022-06-27 14:30:00	AAPL	Stock	141.67	142.055	141.5901	141.61	2270437.0
2022-06-27 15:00:00	AAPL	Stock	141.62	141.85	141.09	141.6846	3435173.0
2022-06-27 15:30:00	AAPL	Stock	141.69	141.77	140.965	141.71	6003388.0
2022-06-27 16:00:00	AAPL	Stock	141.71	142.087	141.53	141.98	8863937.0
2022-06-27 16:30:00	AAPL	Stock	141.98	142.05	141.9	141.957	19688.0
2022-06-27 17:00:00	AAPL	Stock	141.95	141.98	141.92	141.96	12884.0
2022-06-27 17:30:00	AAPL	Stock	141.9374	141.95	141.92	141.92	9293.0
2022-06-27 18:00:00	AAPL	Stock	141.95	141.95	141.75	141.77	17934.0
2022-06-27 18:30:00	AAPL	Stock	141.86	141.9	141.8401	141.87	1657.0
2022-06-27 19:00:00	AAPL	Stock	141.87	141.96	141.87	141.94	7102.0
2022-06-27 19:30:00	AAPL	Stock	141.98	141.98	141.88	141.98	27404.0
2022-06-27 04:00:00	MSFT	Stock	268.5	270.55	268.5	270.44	7646.0
2022-06-27 04:30:00	MSFT	Stock	270.24	270.32	269.36	269.36	3027.0
2022-06-27 05:00:00	MSFT	Stock	269.3	269.7	269.11	269.58	1577.0
2022-06-27 05:30:00	MSFT	Stock	269.39	269.4	269.39	269.4	284.0
2022-06-27 06:00:00	MSFT	Stock	269.32	269.32	268.76	268.76	1729.0
2022-06-27 06:30:00	MSFT	Stock	268.66	268.84	268.5	268.82	1614.0
2022-06-27 07:00:00	MSFT	Stock	268.7	269.38	268.7	269.02	6047.0
2022-06-27 07:30:00	MSFT	Stock	268.96	269.45	268.96	269.0	9867.0
2022-06-27 08:00:00	MSFT	Stock	269.0979	269.5859	268.05	268.05	26979.0
2022-06-27 08:30:00	MSFT	Stock	268.58	268.58	267.75	268.0	26783.0
2022-06-27 09:00:00	MSFT	Stock	267.83	268.74	267.82	268.05	30945.0
2022-06-27 09:30:00	MSFT	Stock	268.14	268.3	264.83	265.54	2245203.0
2022-06-27 10:00:00	MSFT	Stock	265.56	266.8614	265.195	265.43	992566.0
2022-06-27 10:30:00	MSFT	Stock	265.37	267.19	265.29	267.05	777286.0
2022-06-27 11:00:00	MSFT	Stock	267.07	267.18	265.13	266.12	736794.0
2022-06-27 11:30:00	MSFT	Stock	266.18	266.23	265.31	265.98	628085.0
2022-06-27 12:00:00	MSFT	Stock	265.99	266.125	264.68	264.77	785734.0
2022-06-27 12:30:00	MSFT	Stock	264.76	265.715	264.64	265.56	606519.0

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

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