PREVIEW / stock_30min / 2020-06-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-11.parquet
  size:    2.1 MB
  rows:    105,475
  symbols: 2,434

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-06-11 04:00:00	AAPL	Stock	87.235	87.235	86.875	86.875	62612.0
2020-06-11 04:30:00	AAPL	Stock	86.88	87.0525	86.6025	86.7975	35464.0
2020-06-11 05:00:00	AAPL	Stock	86.755	87.1875	86.7475	87.1875	23132.0
2020-06-11 05:30:00	AAPL	Stock	87.1875	87.3	87.1125	87.275	11720.0
2020-06-11 06:00:00	AAPL	Stock	87.2675	87.2675	87.115	87.2225	18956.0
2020-06-11 06:30:00	AAPL	Stock	87.1975	87.1975	87.025	87.08	16372.0
2020-06-11 07:00:00	AAPL	Stock	87.0575	87.145	86.8125	87.1	368588.0
2020-06-11 07:30:00	AAPL	Stock	87.025	87.225	86.7175	86.8925	294876.0
2020-06-11 08:00:00	AAPL	Stock	86.9235	87.225	86.55	86.725	556044.0
2020-06-11 08:30:00	AAPL	Stock	86.663	87.0575	86.6	87.0	523852.0
2020-06-11 09:00:00	AAPL	Stock	87.0	87.3325	86.8125	87.3175	519604.0
2020-06-11 09:30:00	AAPL	Stock	87.3175	87.7425	86.6492	87.2625	21031708.0
2020-06-11 10:00:00	AAPL	Stock	87.2675	87.765	87.0625	87.46	9655308.0
2020-06-11 10:30:00	AAPL	Stock	87.4575	87.715	86.85	86.95	7500692.0
2020-06-11 11:00:00	AAPL	Stock	86.945	87.475	86.7338	87.41	9657412.0
2020-06-11 11:30:00	AAPL	Stock	87.4062	87.5125	86.8125	87.0688	7897448.0
2020-06-11 12:00:00	AAPL	Stock	87.065	87.085	85.65	85.8925	11325120.0
2020-06-11 12:30:00	AAPL	Stock	85.88	86.31	84.8675	85.0938	11947052.0
2020-06-11 13:00:00	AAPL	Stock	85.0875	86.18	84.96	85.78	10540824.0
2020-06-11 13:30:00	AAPL	Stock	85.7688	85.86	85.4375	85.69	6301492.0
2020-06-11 14:00:00	AAPL	Stock	85.6925	85.6925	85.09	85.38	7086716.0
2020-06-11 14:30:00	AAPL	Stock	85.3762	85.4125	84.5575	84.7875	9237272.0
2020-06-11 15:00:00	AAPL	Stock	84.7775	85.05	83.91	84.2038	11286384.0
2020-06-11 15:30:00	AAPL	Stock	84.204	84.7175	83.87	83.9925	20047620.0
2020-06-11 16:00:00	AAPL	Stock	83.95	84.425	83.95	84.25	14183284.0
2020-06-11 16:30:00	AAPL	Stock	84.25	84.3125	84.0875	84.275	135524.0
2020-06-11 17:00:00	AAPL	Stock	84.2675	84.2675	84.125	84.2	47488.0
2020-06-11 17:30:00	AAPL	Stock	84.265	84.4575	84.265	84.4475	81132.0
2020-06-11 18:00:00	AAPL	Stock	84.4125	84.5	84.2	84.25	130276.0
2020-06-11 18:30:00	AAPL	Stock	84.25	84.6675	84.205	84.6675	52804.0
2020-06-11 19:00:00	AAPL	Stock	84.7075	84.85	84.515	84.6875	56624.0
2020-06-11 19:30:00	AAPL	Stock	84.8125	85.1825	84.75	85.1825	258276.0
2020-06-11 04:00:00	MSFT	Stock	194.48	194.8	193.8	194.0	14082.0
2020-06-11 04:30:00	MSFT	Stock	194.0	194.5	193.27	193.4	6354.0
2020-06-11 05:00:00	MSFT	Stock	193.3	193.75	193.3	193.75	4762.0
2020-06-11 05:30:00	MSFT	Stock	193.75	194.39	193.75	194.14	7490.0
2020-06-11 06:00:00	MSFT	Stock	194.14	194.54	194.14	194.54	16824.0
2020-06-11 06:30:00	MSFT	Stock	194.31	194.43	193.82	193.91	8111.0
2020-06-11 07:00:00	MSFT	Stock	194.0	194.4	192.15	193.14	99977.0
2020-06-11 07:30:00	MSFT	Stock	193.11	193.6	192.94	193.57	64163.0
2020-06-11 08:00:00	MSFT	Stock	193.95	194.39	192.42	193.2	123444.0
2020-06-11 08:30:00	MSFT	Stock	193.1	194.0	192.3	193.92	106570.0
2020-06-11 09:00:00	MSFT	Stock	193.9	193.98	191.0	193.13	124753.0
2020-06-11 09:30:00	MSFT	Stock	193.26	195.015	192.02	194.93	5784056.0
2020-06-11 10:00:00	MSFT	Stock	194.935	195.76	194.3	194.38	3033973.0
2020-06-11 10:30:00	MSFT	Stock	194.375	195.46	193.05	193.28	2356276.0
2020-06-11 11:00:00	MSFT	Stock	193.28	193.86	192.88	193.02	2457609.0
2020-06-11 11:30:00	MSFT	Stock	193.02	193.27	192.11	192.66	2124605.0
2020-06-11 12:00:00	MSFT	Stock	192.64	192.72	189.43	189.82	2931851.0
2020-06-11 12:30:00	MSFT	Stock	189.8	190.57	188.2	188.61	2548746.0

> showing 50 of 105,475 rows — these rows as CSV

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