PREVIEW / stock_30min / 2021-04-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-09.parquet
  size:    2.2 MB
  rows:    110,616
  symbols: 2,949

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-09 04:00:00	AAPL	Stock	130.29	130.34	129.86	130.04	18879.0
2021-04-09 04:30:00	AAPL	Stock	130.01	130.24	129.98	130.19	4648.0
2021-04-09 05:00:00	AAPL	Stock	130.2	130.2	129.9	130.0	5332.0
2021-04-09 05:30:00	AAPL	Stock	129.97	130.0	129.81	129.9	6779.0
2021-04-09 06:00:00	AAPL	Stock	129.9	129.91	129.59	129.67	9423.0
2021-04-09 06:30:00	AAPL	Stock	129.7	130.05	129.7	130.02	20128.0
2021-04-09 07:00:00	AAPL	Stock	130.03	130.27	129.94	130.189	100494.0
2021-04-09 07:30:00	AAPL	Stock	130.18	130.19	129.91	130.02	68481.0
2021-04-09 08:00:00	AAPL	Stock	130.0	130.685	129.78	129.87	399269.0
2021-04-09 08:30:00	AAPL	Stock	129.89	129.96	129.3	129.44	352288.0
2021-04-09 09:00:00	AAPL	Stock	129.42	130.1	129.3	129.9	372076.0
2021-04-09 09:30:00	AAPL	Stock	129.9	131.055	129.47	130.851	12611567.0
2021-04-09 10:00:00	AAPL	Stock	130.84	131.395	130.67	131.025	8414419.0
2021-04-09 10:30:00	AAPL	Stock	131.0218	131.43	130.715	130.7701	6079437.0
2021-04-09 11:00:00	AAPL	Stock	130.78	131.21	130.54	130.98	5608907.0
2021-04-09 11:30:00	AAPL	Stock	130.985	131.55	130.92	131.4317	5243921.0
2021-04-09 12:00:00	AAPL	Stock	131.433	131.55	131.2701	131.4279	3540783.0
2021-04-09 12:30:00	AAPL	Stock	131.425	131.81	131.3278	131.775	3874133.0
2021-04-09 13:00:00	AAPL	Stock	131.775	132.31	131.7317	132.07	6278871.0
2021-04-09 13:30:00	AAPL	Stock	132.0683	132.62	132.01	132.4	5943789.0
2021-04-09 14:00:00	AAPL	Stock	132.41	132.495	132.06	132.0787	4558618.0
2021-04-09 14:30:00	AAPL	Stock	132.08	132.4	132.01	132.2612	4214144.0
2021-04-09 15:00:00	AAPL	Stock	132.263	132.56	131.9	132.53	5908750.0
2021-04-09 15:30:00	AAPL	Stock	132.53	133.04	132.41	132.99	12423610.0
2021-04-09 16:00:00	AAPL	Stock	132.995	133.03	130.9746	132.89	7547404.0
2021-04-09 16:30:00	AAPL	Stock	132.83	132.995	132.8	132.92	54451.0
2021-04-09 17:00:00	AAPL	Stock	132.92	133.0	132.84	132.99	93211.0
2021-04-09 17:30:00	AAPL	Stock	132.97	133.03	132.96	132.96	89929.0
2021-04-09 18:00:00	AAPL	Stock	132.98	133.03	132.85	132.92	52056.0
2021-04-09 18:30:00	AAPL	Stock	132.92	132.95	132.82	132.88	38395.0
2021-04-09 19:00:00	AAPL	Stock	132.86	132.92	132.83	132.88	23465.0
2021-04-09 19:30:00	AAPL	Stock	132.89	132.95	132.87	132.91	64511.0
2021-04-09 04:00:00	MSFT	Stock	253.0	253.0	252.79	252.79	545.0
2021-04-09 04:30:00	MSFT	Stock	253.0	253.0	253.0	253.0	945.0
2021-04-09 05:00:00	MSFT	Stock	252.87	252.87	252.69	252.71	2339.0
2021-04-09 05:30:00	MSFT	Stock	252.7	252.7	252.67	252.67	368.0
2021-04-09 06:00:00	MSFT	Stock	252.7	252.7	252.67	252.67	1388.0
2021-04-09 06:30:00	MSFT	Stock	252.67	252.99	252.67	252.99	1144.0
2021-04-09 07:00:00	MSFT	Stock	253.08	253.25	252.96	253.2	5398.0
2021-04-09 07:30:00	MSFT	Stock	253.12	253.27	253.0	253.0	8072.0
2021-04-09 08:00:00	MSFT	Stock	253.4	253.4	252.36	252.51	13784.0
2021-04-09 08:30:00	MSFT	Stock	252.54	252.56	252.0	252.16	46852.0
2021-04-09 09:00:00	MSFT	Stock	252.1	253.05	252.0	252.82	46733.0
2021-04-09 09:30:00	MSFT	Stock	252.86	254.25	252.44	254.14	2440947.0
2021-04-09 10:00:00	MSFT	Stock	254.17	254.84	253.9271	254.16	1446429.0
2021-04-09 10:30:00	MSFT	Stock	254.15	254.705	253.98	254.13	1210120.0
2021-04-09 11:00:00	MSFT	Stock	254.145	254.41	253.71	254.02	988404.0
2021-04-09 11:30:00	MSFT	Stock	254.02	254.87	253.905	254.805	788728.0
2021-04-09 12:00:00	MSFT	Stock	254.8	255.07	254.5201	254.5201	963449.0
2021-04-09 12:30:00	MSFT	Stock	254.52	254.58	254.25	254.42	665999.0

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

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