PREVIEW / stock_30min / 2021-04-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-14.parquet
  size:    2.2 MB
  rows:    111,173
  symbols: 2,963

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-14 04:00:00	AAPL	Stock	134.88	134.88	134.22	134.5	9758.0
2021-04-14 04:30:00	AAPL	Stock	134.43	134.68	134.43	134.67	6832.0
2021-04-14 05:00:00	AAPL	Stock	134.67	134.7	134.6	134.6	6784.0
2021-04-14 05:30:00	AAPL	Stock	134.6	134.69	134.59	134.66	4795.0
2021-04-14 06:00:00	AAPL	Stock	134.63	134.72	134.45	134.72	16248.0
2021-04-14 06:30:00	AAPL	Stock	134.72	134.8	134.62	134.75	8460.0
2021-04-14 07:00:00	AAPL	Stock	134.76	134.99	134.7	134.95	102901.0
2021-04-14 07:30:00	AAPL	Stock	134.94	135.02	134.86	135.0	104132.0
2021-04-14 08:00:00	AAPL	Stock	134.7545	135.06	134.68	134.9	350271.0
2021-04-14 08:30:00	AAPL	Stock	134.88	135.3	134.72	134.72	264978.0
2021-04-14 09:00:00	AAPL	Stock	134.74	134.99	134.6	134.94	338502.0
2021-04-14 09:30:00	AAPL	Stock	134.94	135.0	133.45	134.02	12008694.0
2021-04-14 10:00:00	AAPL	Stock	134.015	134.03	133.4439	133.57	5853213.0
2021-04-14 10:30:00	AAPL	Stock	133.57	133.88	133.25	133.285	5315496.0
2021-04-14 11:00:00	AAPL	Stock	133.29	133.48	132.57	132.9	5926221.0
2021-04-14 11:30:00	AAPL	Stock	132.9	133.35	132.83	133.33	3679635.0
2021-04-14 12:00:00	AAPL	Stock	133.3301	133.39	132.98	133.25	3418606.0
2021-04-14 12:30:00	AAPL	Stock	133.24	133.62	133.17	133.53	2603516.0
2021-04-14 13:00:00	AAPL	Stock	133.53	133.58	133.28	133.29	2018232.0
2021-04-14 13:30:00	AAPL	Stock	133.28	133.305	132.57	132.6713	2815285.0
2021-04-14 14:00:00	AAPL	Stock	132.69	132.96	131.655	132.8	6972065.0
2021-04-14 14:30:00	AAPL	Stock	132.8	132.8899	132.215	132.29	3978536.0
2021-04-14 15:00:00	AAPL	Stock	132.29	132.65	132.0101	132.58	4347165.0
2021-04-14 15:30:00	AAPL	Stock	132.58	132.63	131.82	132.15	8675520.0
2021-04-14 16:00:00	AAPL	Stock	132.11	132.24	132.0	132.23	6604686.0
2021-04-14 16:30:00	AAPL	Stock	132.22	132.24	132.11	132.12	45898.0
2021-04-14 17:00:00	AAPL	Stock	132.15	132.17	132.11	132.13	24754.0
2021-04-14 17:30:00	AAPL	Stock	132.14	132.97	132.14	132.35	64244.0
2021-04-14 18:00:00	AAPL	Stock	132.31	132.32	132.21	132.29	21202.0
2021-04-14 18:30:00	AAPL	Stock	132.28	132.35	132.2	132.26	40600.0
2021-04-14 19:00:00	AAPL	Stock	132.25	132.34	132.2201	132.27	34102.0
2021-04-14 19:30:00	AAPL	Stock	132.26	132.28	132.1	132.15	40010.0
2021-04-14 04:00:00	MSFT	Stock	259.03	259.03	259.0	259.0	2641.0
2021-04-14 04:30:00	MSFT	Stock	259.32	259.32	259.32	259.32	135.0
2021-04-14 05:00:00	MSFT	Stock	259.32	259.32	259.32	259.32	219.0
2021-04-14 05:30:00	MSFT	Stock	259.1	259.69	259.1	259.63	3866.0
2021-04-14 06:00:00	MSFT	Stock	259.39	259.5	259.2	259.2	1280.0
2021-04-14 06:30:00	MSFT	Stock	259.5	259.5	259.5	259.5	330.0
2021-04-14 07:00:00	MSFT	Stock	259.32	259.64	259.2	259.51	13678.0
2021-04-14 07:30:00	MSFT	Stock	259.51	259.61	259.27	259.45	9049.0
2021-04-14 08:00:00	MSFT	Stock	259.4899	259.77	257.844	259.5046	21778.0
2021-04-14 08:30:00	MSFT	Stock	259.43	259.5	258.44	258.55	25873.0
2021-04-14 09:00:00	MSFT	Stock	258.57	258.57	257.06	257.22	39972.0
2021-04-14 09:30:00	MSFT	Stock	257.22	258.32	256.77	257.98	1983207.0
2021-04-14 10:00:00	MSFT	Stock	257.99	258.698	257.3	258.21	1289381.0
2021-04-14 10:30:00	MSFT	Stock	258.23	258.83	257.57	257.59	887353.0
2021-04-14 11:00:00	MSFT	Stock	257.59	257.82	256.24	256.405	1078331.0
2021-04-14 11:30:00	MSFT	Stock	256.39	256.89	256.16	256.87	794985.0
2021-04-14 12:00:00	MSFT	Stock	256.8801	256.98	256.2601	256.36	737419.0
2021-04-14 12:30:00	MSFT	Stock	256.37	256.89	256.27	256.835	632891.0

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

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