PREVIEW / stock_30min / 2019-11-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-07.parquet
  size:    1.8 MB
  rows:    85,968
  symbols: 2,526

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-11-07 04:00:00	AAPL	Stock	64.54	64.7	64.4375	64.625	47508.0
2019-11-07 04:30:00	AAPL	Stock	64.6075	64.65	64.5525	64.5525	27564.0
2019-11-07 05:00:00	AAPL	Stock	64.5625	64.595	64.5625	64.575	24488.0
2019-11-07 05:30:00	AAPL	Stock	64.55	64.55	64.5	64.5	15432.0
2019-11-07 06:00:00	AAPL	Stock	64.5175	64.525	64.5	64.5125	9596.0
2019-11-07 06:30:00	AAPL	Stock	64.5125	64.5225	64.5	64.5	7248.0
2019-11-07 07:00:00	AAPL	Stock	64.5	64.72	64.485	64.645	226680.0
2019-11-07 07:30:00	AAPL	Stock	64.65	64.6625	64.6125	64.655	81208.0
2019-11-07 08:00:00	AAPL	Stock	64.6828	64.7175	64.51	64.625	310916.0
2019-11-07 08:30:00	AAPL	Stock	64.6375	64.6575	64.6	64.63	157316.0
2019-11-07 09:00:00	AAPL	Stock	64.625	64.675	64.57	64.675	181352.0
2019-11-07 09:30:00	AAPL	Stock	64.685	64.78	64.5275	64.616	11514944.0
2019-11-07 10:00:00	AAPL	Stock	64.6175	64.685	64.5575	64.625	5938772.0
2019-11-07 10:30:00	AAPL	Stock	64.6225	64.8975	64.6	64.8525	7208552.0
2019-11-07 11:00:00	AAPL	Stock	64.855	64.9475	64.815	64.9175	4241376.0
2019-11-07 11:30:00	AAPL	Stock	64.915	65.01	64.7675	64.95	4813576.0
2019-11-07 12:00:00	AAPL	Stock	64.9625	64.975	64.83	64.96	3820980.0
2019-11-07 12:30:00	AAPL	Stock	64.9575	65.0	64.9325	64.9912	4373144.0
2019-11-07 13:00:00	AAPL	Stock	64.9925	65.0475	64.9375	65.035	4239628.0
2019-11-07 13:30:00	AAPL	Stock	65.0338	65.075	64.9625	65.0425	3675300.0
2019-11-07 14:00:00	AAPL	Stock	65.045	65.0875	65.0387	65.0525	2745452.0
2019-11-07 14:30:00	AAPL	Stock	65.0537	65.085	64.75	64.9662	7092700.0
2019-11-07 15:00:00	AAPL	Stock	64.9688	64.9975	64.5925	64.733	5932072.0
2019-11-07 15:30:00	AAPL	Stock	64.73	64.875	64.5875	64.875	7426792.0
2019-11-07 16:00:00	AAPL	Stock	64.8575	64.8625	64.76	64.76	4771496.0
2019-11-07 16:30:00	AAPL	Stock	64.8	64.8575	64.775	64.8125	89864.0
2019-11-07 17:00:00	AAPL	Stock	64.8575	64.8575	64.7875	64.805	94704.0
2019-11-07 17:30:00	AAPL	Stock	64.8025	64.805	64.7875	64.805	20948.0
2019-11-07 18:00:00	AAPL	Stock	64.8025	64.85	64.8025	64.805	58208.0
2019-11-07 18:30:00	AAPL	Stock	64.8325	64.8325	64.8125	64.825	8112.0
2019-11-07 19:00:00	AAPL	Stock	64.83	64.9	64.825	64.875	17016.0
2019-11-07 19:30:00	AAPL	Stock	64.855	64.87	64.775	64.8625	51344.0
2019-11-07 04:00:00	MSFT	Stock	144.65	145.0	144.65	144.86	2739.0
2019-11-07 04:30:00	MSFT	Stock	145.0	145.0	144.99	144.99	800.0
2019-11-07 05:00:00	MSFT	Stock	144.99	144.99	144.99	144.99	100.0
2019-11-07 05:30:00	MSFT	Stock	144.95	144.95	144.93	144.93	700.0
2019-11-07 06:00:00	MSFT	Stock	144.83	144.83	144.83	144.83	200.0
2019-11-07 06:30:00	MSFT	Stock	144.75	144.8	144.7	144.8	685.0
2019-11-07 07:00:00	MSFT	Stock	144.63	144.65	144.51	144.6	8681.0
2019-11-07 07:30:00	MSFT	Stock	144.6	144.6	144.56	144.58	14756.0
2019-11-07 08:00:00	MSFT	Stock	144.55	144.65	144.5	144.56	23337.0
2019-11-07 08:30:00	MSFT	Stock	144.58	144.58	144.4	144.53	16139.0
2019-11-07 09:00:00	MSFT	Stock	144.43	144.59	143.67	144.04	42243.0
2019-11-07 09:30:00	MSFT	Stock	143.84	144.87	143.67	144.69	2086794.0
2019-11-07 10:00:00	MSFT	Stock	144.69	144.87	144.54	144.61	950740.0
2019-11-07 10:30:00	MSFT	Stock	144.61	144.88	144.595	144.737	832844.0
2019-11-07 11:00:00	MSFT	Stock	144.74	144.83	144.65	144.665	687431.0
2019-11-07 11:30:00	MSFT	Stock	144.665	144.85	144.38	144.77	925468.0
2019-11-07 12:00:00	MSFT	Stock	144.78	144.83	144.51	144.69	578224.0
2019-11-07 12:30:00	MSFT	Stock	144.68	144.78	144.56	144.75	493071.0

> showing 50 of 85,968 rows — these rows as CSV

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