PREVIEW / stock_30min / 2019-09-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-04.parquet
  size:    1.7 MB
  rows:    84,179
  symbols: 2,562

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
2019-09-04 04:00:00	AAPL	Stock	52.225	52.3	52.1975	52.25	24436.0
2019-09-04 04:30:00	AAPL	Stock	52.1425	52.25	52.1425	52.185	6720.0
2019-09-04 05:30:00	AAPL	Stock	52.1825	52.1825	52.11	52.115	5836.0
2019-09-04 06:00:00	AAPL	Stock	52.0575	52.0575	52.0575	52.0575	1600.0
2019-09-04 06:30:00	AAPL	Stock	52.1175	52.1175	52.005	52.08	4236.0
2019-09-04 07:00:00	AAPL	Stock	52.1125	52.1225	52.0375	52.0575	75516.0
2019-09-04 07:30:00	AAPL	Stock	52.0875	52.175	52.075	52.1225	64988.0
2019-09-04 08:00:00	AAPL	Stock	52.1	52.1675	52.05	52.09	172776.0
2019-09-04 08:30:00	AAPL	Stock	52.11	52.175	52.045	52.045	99036.0
2019-09-04 09:00:00	AAPL	Stock	52.04	52.1225	51.9625	52.095	284516.0
2019-09-04 09:30:00	AAPL	Stock	52.0975	52.1825	51.885	51.93	10323536.0
2019-09-04 10:00:00	AAPL	Stock	51.9325	51.995	51.83	51.9075	4184544.0
2019-09-04 10:30:00	AAPL	Stock	51.9025	51.9725	51.8325	51.965	3637940.0
2019-09-04 11:00:00	AAPL	Stock	51.9675	52.03	51.9375	52.0235	2422940.0
2019-09-04 11:30:00	AAPL	Stock	52.0232	52.1125	52.015	52.065	3083108.0
2019-09-04 12:00:00	AAPL	Stock	52.0625	52.08	51.925	52.04	2613896.0
2019-09-04 12:30:00	AAPL	Stock	52.0418	52.2375	51.96	52.2125	3906300.0
2019-09-04 13:00:00	AAPL	Stock	52.215	52.3475	52.21	52.34	3315480.0
2019-09-04 13:30:00	AAPL	Stock	52.3412	52.3685	52.1925	52.22	2911984.0
2019-09-04 14:00:00	AAPL	Stock	52.2212	52.305	52.205	52.2825	2219184.0
2019-09-04 14:30:00	AAPL	Stock	52.2812	52.315	52.2	52.2625	2487060.0
2019-09-04 15:00:00	AAPL	Stock	52.2612	52.35	52.25	52.3262	3110284.0
2019-09-04 15:30:00	AAPL	Stock	52.3275	52.37	52.2625	52.3125	6508320.0
2019-09-04 16:00:00	AAPL	Stock	52.2975	52.315	52.1475	52.2975	7046648.0
2019-09-04 16:30:00	AAPL	Stock	52.21	52.275	52.21	52.25	31644.0
2019-09-04 17:00:00	AAPL	Stock	52.2325	52.2725	52.175	52.205	31496.0
2019-09-04 17:30:00	AAPL	Stock	52.2075	52.225	52.2	52.22	5960.0
2019-09-04 18:00:00	AAPL	Stock	52.225	52.2475	52.2	52.2325	10200.0
2019-09-04 18:30:00	AAPL	Stock	52.2375	52.2525	52.225	52.2525	20252.0
2019-09-04 19:00:00	AAPL	Stock	52.25	52.2525	52.205	52.205	9280.0
2019-09-04 19:30:00	AAPL	Stock	52.2125	52.27	52.2	52.2525	16028.0
2019-09-04 04:00:00	MSFT	Stock	137.85	137.85	137.8	137.8	279.0
2019-09-04 04:30:00	MSFT	Stock	137.85	137.85	137.59	137.7	1655.0
2019-09-04 05:00:00	MSFT	Stock	137.75	137.93	137.75	137.93	1387.0
2019-09-04 05:30:00	MSFT	Stock	137.57	137.57	137.57	137.57	100.0
2019-09-04 06:00:00	MSFT	Stock	137.6	137.8	137.6	137.8	3742.0
2019-09-04 06:30:00	MSFT	Stock	137.63	137.63	137.5	137.5	2139.0
2019-09-04 07:00:00	MSFT	Stock	137.55	137.59	137.43	137.5	9424.0
2019-09-04 07:30:00	MSFT	Stock	137.5	137.55	137.43	137.5	18266.0
2019-09-04 08:00:00	MSFT	Stock	137.489	137.6	137.3	137.36	37904.0
2019-09-04 08:30:00	MSFT	Stock	137.49	137.6	137.3	137.48	11928.0
2019-09-04 09:00:00	MSFT	Stock	137.36	137.48	137.1	137.18	21631.0
2019-09-04 09:30:00	MSFT	Stock	137.3	137.36	136.85	137.065	2082799.0
2019-09-04 10:00:00	MSFT	Stock	137.065	137.13	136.48	136.975	1198824.0
2019-09-04 10:30:00	MSFT	Stock	136.97	137.1	136.89	137.02	824220.0
2019-09-04 11:00:00	MSFT	Stock	137.03	137.165	136.94	137.145	966983.0
2019-09-04 11:30:00	MSFT	Stock	137.14	137.425	137.12	137.32	925256.0
2019-09-04 12:00:00	MSFT	Stock	137.32	137.48	137.08	137.095	643291.0
2019-09-04 12:30:00	MSFT	Stock	137.093	137.46	137.015	137.355	747172.0
2019-09-04 13:00:00	MSFT	Stock	137.36	137.51	137.33	137.49	659560.0

> showing 50 of 84,179 rows — these rows as CSV

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