PREVIEW / stock_30min / 2021-04-21

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-21.parquet
  size:    2.2 MB
  rows:    110,208
  symbols: 2,971

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-04-21 04:00:00	AAPL	Stock	132.59	132.64	132.31	132.6	5165.0
2021-04-21 04:30:00	AAPL	Stock	132.57	132.64	132.57	132.58	4560.0
2021-04-21 05:00:00	AAPL	Stock	132.58	133.05	132.58	133.05	10455.0
2021-04-21 05:30:00	AAPL	Stock	132.84	132.85	132.66	132.71	5541.0
2021-04-21 06:00:00	AAPL	Stock	132.78	132.87	132.64	132.82	3015.0
2021-04-21 06:30:00	AAPL	Stock	132.73	133.07	132.73	133.07	8113.0
2021-04-21 07:00:00	AAPL	Stock	132.98	132.98	132.78	132.84	54191.0
2021-04-21 07:30:00	AAPL	Stock	132.84	132.99	132.66	132.7	41896.0
2021-04-21 08:00:00	AAPL	Stock	132.97	133.442	132.41	132.46	157395.0
2021-04-21 08:30:00	AAPL	Stock	132.48	132.7175	132.38	132.69	126172.0
2021-04-21 09:00:00	AAPL	Stock	132.7	132.75	132.13	132.36	190295.0
2021-04-21 09:30:00	AAPL	Stock	132.39	133.05	131.3001	132.63	10617913.0
2021-04-21 10:00:00	AAPL	Stock	132.62	132.66	131.9101	132.525	5744409.0
2021-04-21 10:30:00	AAPL	Stock	132.52	132.52	131.94	132.17	4486224.0
2021-04-21 11:00:00	AAPL	Stock	132.17	133.3093	132.09	133.2601	5342782.0
2021-04-21 11:30:00	AAPL	Stock	133.255	133.5	133.08	133.435	4171292.0
2021-04-21 12:00:00	AAPL	Stock	133.4314	133.435	132.94	132.99	3184769.0
2021-04-21 12:30:00	AAPL	Stock	132.9969	133.08	132.75	132.8391	2962450.0
2021-04-21 13:00:00	AAPL	Stock	132.842	133.26	132.82	133.09	2664173.0
2021-04-21 13:30:00	AAPL	Stock	133.09	133.25	133.01	133.056	1940644.0
2021-04-21 14:00:00	AAPL	Stock	133.0676	133.43	133.05	133.14	2703681.0
2021-04-21 14:30:00	AAPL	Stock	133.14	133.25	133.06	133.21	2121181.0
2021-04-21 15:00:00	AAPL	Stock	133.205	133.46	133.09	133.395	2359492.0
2021-04-21 15:30:00	AAPL	Stock	133.4	133.75	133.39	133.49	6243335.0
2021-04-21 16:00:00	AAPL	Stock	133.5	133.54	133.32	133.4	6213202.0
2021-04-21 16:30:00	AAPL	Stock	133.4	133.5	133.0	133.26	56161.0
2021-04-21 17:00:00	AAPL	Stock	133.27	133.27	133.13	133.15	45098.0
2021-04-21 17:30:00	AAPL	Stock	133.13	133.25	133.12	133.21	24177.0
2021-04-21 18:00:00	AAPL	Stock	133.21	133.3	133.21	133.24	18789.0
2021-04-21 18:30:00	AAPL	Stock	133.23	133.24	133.15	133.24	15497.0
2021-04-21 19:00:00	AAPL	Stock	133.23	133.28	133.2	133.22	19008.0
2021-04-21 19:30:00	AAPL	Stock	133.2	133.24	132.9	132.9	64697.0
2021-04-21 04:00:00	MSFT	Stock	258.4	258.4	258.38	258.4	1210.0
2021-04-21 04:30:00	MSFT	Stock	258.1	258.1	258.1	258.1	424.0
2021-04-21 05:30:00	MSFT	Stock	258.14	258.14	258.14	258.14	210.0
2021-04-21 06:00:00	MSFT	Stock	258.23	258.4	258.14	258.14	2772.0
2021-04-21 06:30:00	MSFT	Stock	258.38	258.65	258.38	258.65	706.0
2021-04-21 07:00:00	MSFT	Stock	258.67	258.76	258.35	258.35	6712.0
2021-04-21 07:30:00	MSFT	Stock	258.42	258.5	258.36	258.5	5354.0
2021-04-21 08:00:00	MSFT	Stock	258.58	258.58	257.615	257.8157	11295.0
2021-04-21 08:30:00	MSFT	Stock	257.97	258.12	257.55	258.01	7386.0
2021-04-21 09:00:00	MSFT	Stock	258.11	258.98	257.7	258.98	21013.0
2021-04-21 09:30:00	MSFT	Stock	258.93	259.7	257.25	259.52	2501748.0
2021-04-21 10:00:00	MSFT	Stock	259.52	260.13	258.7901	260.03	1503953.0
2021-04-21 10:30:00	MSFT	Stock	260.0	260.02	258.26	258.48	1248934.0
2021-04-21 11:00:00	MSFT	Stock	258.49	259.98	258.38	259.84	942825.0
2021-04-21 11:30:00	MSFT	Stock	259.83	260.34	259.59	259.902	1047348.0
2021-04-21 12:00:00	MSFT	Stock	259.91	259.93	259.27	259.31	630219.0
2021-04-21 12:30:00	MSFT	Stock	259.32	259.58	259.1	259.24	685066.0
2021-04-21 13:00:00	MSFT	Stock	259.24	259.6	259.105	259.34	499577.0

> showing 50 of 110,208 rows — these rows as CSV

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