PREVIEW / stock_30min / 2021-07-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-20.parquet
  size:    2.2 MB
  rows:    111,174
  symbols: 2,859

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
2021-07-20 04:00:00	AAPL	Stock	143.3	143.6	142.99	143.0	42194.0
2021-07-20 04:30:00	AAPL	Stock	143.07	143.18	143.07	143.08	3746.0
2021-07-20 05:00:00	AAPL	Stock	143.1	143.17	143.1	143.15	2208.0
2021-07-20 05:30:00	AAPL	Stock	143.19	143.29	142.75	142.92	10394.0
2021-07-20 06:00:00	AAPL	Stock	142.9	143.3	142.89	143.25	6768.0
2021-07-20 06:30:00	AAPL	Stock	143.26	143.65	143.19	143.65	18119.0
2021-07-20 07:00:00	AAPL	Stock	143.63	143.8	143.41	143.55	113315.0
2021-07-20 07:30:00	AAPL	Stock	143.58	143.6	143.3	143.55	53333.0
2021-07-20 08:00:00	AAPL	Stock	143.56	143.8	143.33	143.52	392666.0
2021-07-20 08:30:00	AAPL	Stock	143.51	143.55	143.23	143.5	216239.0
2021-07-20 09:00:00	AAPL	Stock	143.5	143.65	143.0	143.49	293206.0
2021-07-20 09:30:00	AAPL	Stock	143.47	144.315	142.96	144.22	12320525.0
2021-07-20 10:00:00	AAPL	Stock	144.22	144.8886	143.8	144.52	8270364.0
2021-07-20 10:30:00	AAPL	Stock	144.525	145.25	144.35	145.16	5649305.0
2021-07-20 11:00:00	AAPL	Stock	145.16	145.21	144.915	145.0618	4135496.0
2021-07-20 11:30:00	AAPL	Stock	145.065	145.66	145.01	145.6301	3876563.0
2021-07-20 12:00:00	AAPL	Stock	145.64	145.965	145.54	145.94	3392857.0
2021-07-20 12:30:00	AAPL	Stock	145.95	146.7	145.95	146.7	5066204.0
2021-07-20 13:00:00	AAPL	Stock	146.7	146.89	146.19	146.88	4946515.0
2021-07-20 13:30:00	AAPL	Stock	146.88	147.0997	146.74	146.75	4266956.0
2021-07-20 14:00:00	AAPL	Stock	146.751	146.99	146.54	146.9399	3947278.0
2021-07-20 14:30:00	AAPL	Stock	146.93	146.9899	146.2	146.4111	3955388.0
2021-07-20 15:00:00	AAPL	Stock	146.42	146.99	146.4	146.96	4143197.0
2021-07-20 15:30:00	AAPL	Stock	146.96	147.005	146.1	146.1427	8256373.0
2021-07-20 16:00:00	AAPL	Stock	146.15	146.15	145.71	145.93	12082282.0
2021-07-20 16:30:00	AAPL	Stock	145.95	146.14	145.93	146.11	41532.0
2021-07-20 17:00:00	AAPL	Stock	146.13	146.15	146.0	146.04	40966.0
2021-07-20 17:30:00	AAPL	Stock	146.03	146.09	146.0	146.09	13345.0
2021-07-20 18:00:00	AAPL	Stock	146.09	146.25	146.06	146.25	19941.0
2021-07-20 18:30:00	AAPL	Stock	146.24	146.39	145.54	146.2	31681.0
2021-07-20 19:00:00	AAPL	Stock	146.19	146.45	146.18	146.44	20435.0
2021-07-20 19:30:00	AAPL	Stock	146.43	146.44	146.28	146.3399	27033.0
2021-07-20 04:00:00	MSFT	Stock	278.0	278.84	278.0	278.79	2864.0
2021-07-20 04:30:00	MSFT	Stock	278.68	278.68	278.51	278.63	716.0
2021-07-20 05:00:00	MSFT	Stock	278.5	278.55	278.47	278.55	1294.0
2021-07-20 05:30:00	MSFT	Stock	278.58	278.58	278.2	278.2	19820.0
2021-07-20 06:00:00	MSFT	Stock	278.21	278.57	278.2	278.57	1605.0
2021-07-20 06:30:00	MSFT	Stock	278.52	278.6	278.49	278.49	1741.0
2021-07-20 07:00:00	MSFT	Stock	278.55	278.72	278.4	278.54	12532.0
2021-07-20 07:30:00	MSFT	Stock	278.62	278.65	278.14	278.33	3191.0
2021-07-20 08:00:00	MSFT	Stock	278.75	278.75	278.11	278.25	14622.0
2021-07-20 08:30:00	MSFT	Stock	278.27	278.27	277.88	278.19	19844.0
2021-07-20 09:00:00	MSFT	Stock	278.23	278.48	277.52	278.1	22746.0
2021-07-20 09:30:00	MSFT	Stock	278.1	278.39	276.26	277.75	1904351.0
2021-07-20 10:00:00	MSFT	Stock	277.75	277.82	276.54	277.03	1178438.0
2021-07-20 10:30:00	MSFT	Stock	277.02	278.52	276.82	278.36	993863.0
2021-07-20 11:00:00	MSFT	Stock	278.37	278.7943	277.8	278.43	918064.0
2021-07-20 11:30:00	MSFT	Stock	278.43	278.77	278.19	278.76	716041.0
2021-07-20 12:00:00	MSFT	Stock	278.74	279.325	278.7	278.97	740100.0
2021-07-20 12:30:00	MSFT	Stock	278.97	280.18	278.97	280.17	1102838.0

> showing 50 of 111,174 rows — these rows as CSV

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