PREVIEW / stock_30min / 2020-07-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-27.parquet
  size:    1.9 MB
  rows:    97,386
  symbols: 2,452

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
2020-07-27 04:00:00	AAPL	Stock	93.0025	93.0275	92.83	93.0	17936.0
2020-07-27 04:30:00	AAPL	Stock	92.9975	93.08	92.9975	93.08	3548.0
2020-07-27 05:00:00	AAPL	Stock	93.0825	93.25	93.0825	93.25	2000.0
2020-07-27 05:30:00	AAPL	Stock	93.4775	93.5	93.3825	93.45	8084.0
2020-07-27 06:00:00	AAPL	Stock	93.535	93.875	93.45	93.875	25296.0
2020-07-27 06:30:00	AAPL	Stock	93.8975	94.0	93.65	93.65	14872.0
2020-07-27 07:00:00	AAPL	Stock	93.625	93.7375	93.3725	93.625	240432.0
2020-07-27 07:30:00	AAPL	Stock	93.625	93.8125	93.6175	93.8125	190368.0
2020-07-27 08:00:00	AAPL	Stock	93.3765	93.825	93.375	93.695	281472.0
2020-07-27 08:30:00	AAPL	Stock	93.6825	93.785	93.5025	93.7375	315456.0
2020-07-27 09:00:00	AAPL	Stock	93.7375	93.9525	93.535	93.625	455760.0
2020-07-27 09:30:00	AAPL	Stock	93.7175	94.875	93.49	94.425	19836076.0
2020-07-27 10:00:00	AAPL	Stock	94.4375	94.766	93.975	94.25	9740808.0
2020-07-27 10:30:00	AAPL	Stock	94.2472	94.54	94.0175	94.325	5320920.0
2020-07-27 11:00:00	AAPL	Stock	94.325	94.4625	93.6575	93.6812	5573816.0
2020-07-27 11:30:00	AAPL	Stock	93.69	94.035	93.48	93.895	5626392.0
2020-07-27 12:00:00	AAPL	Stock	93.91	94.0325	93.7925	93.895	3994832.0
2020-07-27 12:30:00	AAPL	Stock	93.8925	94.26	93.76	94.2375	3595268.0
2020-07-27 13:00:00	AAPL	Stock	94.245	94.3975	94.14	94.39	3318304.0
2020-07-27 13:30:00	AAPL	Stock	94.3898	94.6112	94.325	94.5445	3606932.0
2020-07-27 14:00:00	AAPL	Stock	94.555	94.7448	94.4275	94.6875	4403744.0
2020-07-27 14:30:00	AAPL	Stock	94.695	94.75	94.29	94.3225	5333164.0
2020-07-27 15:00:00	AAPL	Stock	94.315	94.7825	94.3025	94.6875	6289504.0
2020-07-27 15:30:00	AAPL	Stock	94.675	94.905	94.63	94.8037	8954780.0
2020-07-27 16:00:00	AAPL	Stock	94.805	94.9375	94.795	94.89	9012632.0
2020-07-27 16:30:00	AAPL	Stock	94.9375	94.975	94.81	94.9625	135968.0
2020-07-27 17:00:00	AAPL	Stock	94.81	94.9875	94.81	94.9875	2381028.0
2020-07-27 17:30:00	AAPL	Stock	94.9875	94.9925	94.9575	94.9575	20236.0
2020-07-27 18:00:00	AAPL	Stock	94.975	95.125	94.975	95.115	69324.0
2020-07-27 18:30:00	AAPL	Stock	95.115	95.2375	95.075	95.195	49428.0
2020-07-27 19:00:00	AAPL	Stock	95.195	95.2475	95.1525	95.175	35576.0
2020-07-27 19:30:00	AAPL	Stock	95.14	95.2475	95.045	95.245	82840.0
2020-07-27 04:00:00	MSFT	Stock	202.05	202.66	202.05	202.05	2220.0
2020-07-27 04:30:00	MSFT	Stock	202.37	202.48	202.2	202.2	1834.0
2020-07-27 05:00:00	MSFT	Stock	202.32	202.55	202.3	202.55	4413.0
2020-07-27 05:30:00	MSFT	Stock	202.44	203.13	202.44	203.13	8522.0
2020-07-27 06:00:00	MSFT	Stock	203.06	203.71	202.62	203.71	2358.0
2020-07-27 06:30:00	MSFT	Stock	203.74	203.79	203.6	203.6	2311.0
2020-07-27 07:00:00	MSFT	Stock	203.25	203.45	202.75	203.2	42512.0
2020-07-27 07:30:00	MSFT	Stock	203.19	203.43	203.13	203.39	22006.0
2020-07-27 08:00:00	MSFT	Stock	203.4	203.5	201.8	203.0	69509.0
2020-07-27 08:30:00	MSFT	Stock	202.96	203.05	202.3	202.6	50366.0
2020-07-27 09:00:00	MSFT	Stock	202.6	202.78	201.0	201.38	98968.0
2020-07-27 09:30:00	MSFT	Stock	201.47	203.32	201.345	202.81	3755561.0
2020-07-27 10:00:00	MSFT	Stock	202.81	203.027	200.86	201.025	2312060.0
2020-07-27 10:30:00	MSFT	Stock	201.025	202.8	201.025	202.6	1944231.0
2020-07-27 11:00:00	MSFT	Stock	202.6	202.735	201.57	201.64	1414433.0
2020-07-27 11:30:00	MSFT	Stock	201.64	202.26	201.31	201.95	1176351.0
2020-07-27 12:00:00	MSFT	Stock	201.96	202.43	201.67	201.71	1067743.0
2020-07-27 12:30:00	MSFT	Stock	201.719	202.23	201.55	202.185	868891.0

> showing 50 of 97,386 rows — these rows as CSV

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