PREVIEW / stock_30min / 2018-03-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-01.parquet
  size:    1.7 MB
  rows:    84,208
  symbols: 2,878

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
2018-03-01 04:00:00	AAPL	Stock	44.8425	44.8425	44.63	44.6875	6024.0
2018-03-01 04:30:00	AAPL	Stock	44.5875	44.5875	44.5	44.5	10932.0
2018-03-01 05:00:00	AAPL	Stock	44.5325	44.6225	44.475	44.475	81204.0
2018-03-01 05:30:00	AAPL	Stock	44.4725	44.525	44.45	44.475	34672.0
2018-03-01 06:00:00	AAPL	Stock	44.475	44.535	44.475	44.5	13200.0
2018-03-01 06:30:00	AAPL	Stock	44.495	44.495	44.275	44.32	22996.0
2018-03-01 07:00:00	AAPL	Stock	44.35	44.4275	44.325	44.4025	110096.0
2018-03-01 07:30:00	AAPL	Stock	44.4025	44.455	44.3975	44.4125	166452.0
2018-03-01 08:00:00	AAPL	Stock	44.3875	44.4875	44.325	44.4875	246960.0
2018-03-01 08:30:00	AAPL	Stock	44.475	44.7325	44.475	44.6775	384496.0
2018-03-01 09:00:00	AAPL	Stock	44.69	44.7225	44.64	44.64	201208.0
2018-03-01 09:30:00	AAPL	Stock	44.6375	44.84	44.3725	44.4775	19035376.0
2018-03-01 10:00:00	AAPL	Stock	44.485	44.81	44.4125	44.795	12924176.0
2018-03-01 10:30:00	AAPL	Stock	44.7975	44.9438	44.58	44.5975	10208688.0
2018-03-01 11:00:00	AAPL	Stock	44.595	44.7425	44.5448	44.5762	6067672.0
2018-03-01 11:30:00	AAPL	Stock	44.5762	44.685	44.5425	44.5825	5598676.0
2018-03-01 12:00:00	AAPL	Stock	44.585	44.6075	44.275	44.3125	8426228.0
2018-03-01 12:30:00	AAPL	Stock	44.3075	44.3225	43.945	43.9925	12772596.0
2018-03-01 13:00:00	AAPL	Stock	43.9925	43.9938	43.5875	43.875	15452020.0
2018-03-01 13:30:00	AAPL	Stock	43.8675	43.875	43.3175	43.3225	16025604.0
2018-03-01 14:00:00	AAPL	Stock	43.3225	43.7032	43.165	43.7032	20090160.0
2018-03-01 14:30:00	AAPL	Stock	43.7025	43.775	43.4775	43.7365	9791692.0
2018-03-01 15:00:00	AAPL	Stock	43.7375	43.9675	43.545	43.8392	11120404.0
2018-03-01 15:30:00	AAPL	Stock	43.8425	43.9	43.48	43.7375	17879632.0
2018-03-01 16:00:00	AAPL	Stock	43.75	43.825	43.7325	43.775	8494908.0
2018-03-01 16:30:00	AAPL	Stock	43.7925	43.825	43.75	43.7975	101380.0
2018-03-01 17:00:00	AAPL	Stock	43.78	43.8225	43.765	43.78	76484.0
2018-03-01 17:30:00	AAPL	Stock	43.8125	43.825	43.7725	43.7875	30624.0
2018-03-01 18:00:00	AAPL	Stock	43.7675	43.82	43.7675	43.7875	27408.0
2018-03-01 18:30:00	AAPL	Stock	43.7625	43.775	43.7375	43.75	20720.0
2018-03-01 19:00:00	AAPL	Stock	43.75	43.8225	43.7175	43.79	31800.0
2018-03-01 19:30:00	AAPL	Stock	43.7975	43.8225	43.7525	43.7975	56176.0
2018-03-01 04:00:00	MSFT	Stock	94.01	94.2	94.01	94.2	287.0
2018-03-01 05:00:00	MSFT	Stock	94.04	94.04	94.04	94.04	1600.0
2018-03-01 05:30:00	MSFT	Stock	93.9	93.9	93.85	93.85	700.0
2018-03-01 06:00:00	MSFT	Stock	94.16	94.16	94.16	94.16	200.0
2018-03-01 06:30:00	MSFT	Stock	93.55	93.55	93.52	93.52	600.0
2018-03-01 07:00:00	MSFT	Stock	93.74	93.75	93.59	93.64	11853.0
2018-03-01 07:30:00	MSFT	Stock	93.75	93.75	93.66	93.66	1675.0
2018-03-01 08:00:00	MSFT	Stock	93.85	93.93	93.7	93.86	27834.0
2018-03-01 08:30:00	MSFT	Stock	93.77	94.3	93.76	94.2	32460.0
2018-03-01 09:00:00	MSFT	Stock	94.19	94.35	93.88	93.94	33832.0
2018-03-01 09:30:00	MSFT	Stock	93.94	94.57	92.55	92.56	3872351.0
2018-03-01 10:00:00	MSFT	Stock	92.57	93.5	92.351	93.48	2025247.0
2018-03-01 10:30:00	MSFT	Stock	93.47	94.035	92.84	92.94	1866262.0
2018-03-01 11:00:00	MSFT	Stock	92.94	93.47	92.88	93.1	1185969.0
2018-03-01 11:30:00	MSFT	Stock	93.11	93.77	93.07	93.62	1328066.0
2018-03-01 12:00:00	MSFT	Stock	93.62	93.66	92.93	93.07	1276024.0
2018-03-01 12:30:00	MSFT	Stock	93.06	93.29	92.76	93.05	1279185.0
2018-03-01 13:00:00	MSFT	Stock	93.04	93.1	92.25	92.84	2435583.0

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

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