PREVIEW / stock_30min / 2019-01-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-14.parquet
  size:    1.7 MB
  rows:    82,780
  symbols: 2,674

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-01-14 04:00:00	AAPL	Stock	37.9	37.9	37.75	37.775	4784.0
2019-01-14 04:30:00	AAPL	Stock	37.775	37.775	37.74	37.74	5756.0
2019-01-14 05:00:00	AAPL	Stock	37.7	37.7	37.6625	37.6625	5052.0
2019-01-14 05:30:00	AAPL	Stock	37.6625	37.6625	37.625	37.625	8264.0
2019-01-14 06:00:00	AAPL	Stock	37.7	37.7	37.67	37.67	3100.0
2019-01-14 06:30:00	AAPL	Stock	37.6525	37.7125	37.65	37.7125	10300.0
2019-01-14 07:00:00	AAPL	Stock	37.71	37.725	37.6525	37.725	99332.0
2019-01-14 07:30:00	AAPL	Stock	37.725	37.7775	37.7	37.7	70412.0
2019-01-14 08:00:00	AAPL	Stock	37.689	37.7625	37.65	37.6875	124856.0
2019-01-14 08:30:00	AAPL	Stock	37.7125	38.0725	37.7	37.775	115948.0
2019-01-14 09:00:00	AAPL	Stock	37.7775	37.81	37.7275	37.7275	235568.0
2019-01-14 09:30:00	AAPL	Stock	37.7125	37.8175	37.4525	37.5	19098376.0
2019-01-14 10:00:00	AAPL	Stock	37.505	37.6175	37.465	37.5562	8665344.0
2019-01-14 10:30:00	AAPL	Stock	37.555	37.615	37.4875	37.516	8296692.0
2019-01-14 11:00:00	AAPL	Stock	37.5125	37.5125	37.305	37.39	8703216.0
2019-01-14 11:30:00	AAPL	Stock	37.39	37.5425	37.365	37.4425	7390468.0
2019-01-14 12:00:00	AAPL	Stock	37.4445	37.495	37.39	37.4938	3960708.0
2019-01-14 12:30:00	AAPL	Stock	37.4925	37.7	37.43	37.5775	6839584.0
2019-01-14 13:00:00	AAPL	Stock	37.575	37.5928	37.49	37.51	4462140.0
2019-01-14 13:30:00	AAPL	Stock	37.51	37.5675	37.4675	37.5125	2990152.0
2019-01-14 14:00:00	AAPL	Stock	37.51	37.51	37.4175	37.48	4445568.0
2019-01-14 14:30:00	AAPL	Stock	37.4825	37.5295	37.465	37.5	3855616.0
2019-01-14 15:00:00	AAPL	Stock	37.4988	37.525	37.44	37.495	5019052.0
2019-01-14 15:30:00	AAPL	Stock	37.495	37.5	37.3675	37.4975	13914860.0
2019-01-14 16:00:00	AAPL	Stock	37.4975	37.5	37.4275	37.46	16376000.0
2019-01-14 16:30:00	AAPL	Stock	37.4625	37.5375	37.445	37.4925	151420.0
2019-01-14 17:00:00	AAPL	Stock	37.4775	37.5	37.45	37.45	30544.0
2019-01-14 17:30:00	AAPL	Stock	37.45	37.475	37.45	37.475	3724.0
2019-01-14 18:00:00	AAPL	Stock	37.4625	37.47	37.45	37.47	8560.0
2019-01-14 18:30:00	AAPL	Stock	37.47	37.495	37.4625	37.4925	15036.0
2019-01-14 19:00:00	AAPL	Stock	37.495	37.5475	37.49	37.545	86712.0
2019-01-14 19:30:00	AAPL	Stock	37.55	37.58	37.5375	37.5625	43176.0
2019-01-14 04:00:00	MSFT	Stock	102.05	102.05	102.05	102.05	200.0
2019-01-14 04:30:00	MSFT	Stock	102.01	102.01	101.87	102.01	1360.0
2019-01-14 05:00:00	MSFT	Stock	102.01	102.01	101.7	101.89	1800.0
2019-01-14 05:30:00	MSFT	Stock	101.71	101.71	101.6	101.6	2125.0
2019-01-14 06:00:00	MSFT	Stock	101.6	101.6	101.6	101.6	950.0
2019-01-14 06:30:00	MSFT	Stock	101.69	101.78	101.69	101.78	1042.0
2019-01-14 07:00:00	MSFT	Stock	101.92	101.95	101.73	101.73	3576.0
2019-01-14 07:30:00	MSFT	Stock	101.9	102.0	101.9	101.9	2262.0
2019-01-14 08:00:00	MSFT	Stock	101.86	101.95	101.75	101.75	7948.0
2019-01-14 08:30:00	MSFT	Stock	101.92	102.05	101.89	102.03	6604.0
2019-01-14 09:00:00	MSFT	Stock	102.03	102.05	101.8	102.0	16124.0
2019-01-14 09:30:00	MSFT	Stock	101.9	102.2	101.36	101.37	2905116.0
2019-01-14 10:00:00	MSFT	Stock	101.39	101.82	101.26	101.7	2334881.0
2019-01-14 10:30:00	MSFT	Stock	101.7	102.152	101.69	102.01	1318508.0
2019-01-14 11:00:00	MSFT	Stock	102.01	102.182	101.88	102.015	1155594.0
2019-01-14 11:30:00	MSFT	Stock	102.02	102.185	101.51	102.03	1583839.0
2019-01-14 12:00:00	MSFT	Stock	102.03	102.07	101.87	101.92	785059.0
2019-01-14 12:30:00	MSFT	Stock	101.93	101.99	101.83	101.91	691084.0

> showing 50 of 82,780 rows — these rows as CSV

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