PREVIEW / stock_30min / 2016-03-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-22.parquet
  size:    1.6 MB
  rows:    81,502
  symbols: 3,332

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
2016-03-22 04:00:00	AAPL	Stock	26.49	26.49	26.35	26.35	18244.0
2016-03-22 04:30:00	AAPL	Stock	26.3025	26.3025	26.3025	26.3025	400.0
2016-03-22 05:30:00	AAPL	Stock	26.395	26.425	26.395	26.425	1600.0
2016-03-22 06:00:00	AAPL	Stock	26.425	26.45	26.425	26.45	3600.0
2016-03-22 06:30:00	AAPL	Stock	26.38	26.41	26.38	26.385	3628.0
2016-03-22 07:00:00	AAPL	Stock	26.3825	26.43	26.355	26.41	20340.0
2016-03-22 07:30:00	AAPL	Stock	26.42	26.435	26.38	26.3975	55840.0
2016-03-22 08:00:00	AAPL	Stock	26.395	26.43	26.38	26.4	138776.0
2016-03-22 08:30:00	AAPL	Stock	26.4075	26.425	26.3975	26.4025	81652.0
2016-03-22 09:00:00	AAPL	Stock	26.4	26.4175	26.315	26.315	404308.0
2016-03-22 09:30:00	AAPL	Stock	26.3125	26.705	26.3025	26.66	20204928.0
2016-03-22 10:00:00	AAPL	Stock	26.66	26.8075	26.6585	26.7785	14559644.0
2016-03-22 10:30:00	AAPL	Stock	26.7795	26.8225	26.7525	26.775	8601832.0
2016-03-22 11:00:00	AAPL	Stock	26.7725	26.79	26.715	26.75	7744964.0
2016-03-22 11:30:00	AAPL	Stock	26.7498	26.765	26.6775	26.745	9662768.0
2016-03-22 12:00:00	AAPL	Stock	26.7425	26.7525	26.68	26.7375	4218848.0
2016-03-22 12:30:00	AAPL	Stock	26.74	26.741	26.6925	26.7075	3781292.0
2016-03-22 13:00:00	AAPL	Stock	26.705	26.705	26.6505	26.6725	4237824.0
2016-03-22 13:30:00	AAPL	Stock	26.6702	26.7125	26.665	26.7025	4691852.0
2016-03-22 14:00:00	AAPL	Stock	26.7025	26.7625	26.7	26.7375	6058356.0
2016-03-22 14:30:00	AAPL	Stock	26.735	26.785	26.7125	26.7125	5578668.0
2016-03-22 15:00:00	AAPL	Stock	26.7125	26.7375	26.68	26.7165	5321864.0
2016-03-22 15:30:00	AAPL	Stock	26.7175	26.74	26.6675	26.685	11664188.0
2016-03-22 16:00:00	AAPL	Stock	26.68	26.6825	26.3928	26.65	9137024.0
2016-03-22 16:30:00	AAPL	Stock	26.6525	26.68	26.6375	26.64	220320.0
2016-03-22 17:00:00	AAPL	Stock	26.635	26.64	26.6	26.6125	47876.0
2016-03-22 17:30:00	AAPL	Stock	26.64	26.64	26.6125	26.6125	32584.0
2016-03-22 18:00:00	AAPL	Stock	26.625	26.635	26.6175	26.635	2200.0
2016-03-22 18:30:00	AAPL	Stock	26.625	26.635	26.625	26.625	20836.0
2016-03-22 19:00:00	AAPL	Stock	26.625	26.635	26.625	26.63	17816.0
2016-03-22 19:30:00	AAPL	Stock	26.635	26.6475	26.635	26.64	14520.0
2016-03-22 05:30:00	MSFT	Stock	53.7	53.7	53.7	53.7	2000.0
2016-03-22 07:00:00	MSFT	Stock	53.67	53.67	53.67	53.67	100.0
2016-03-22 08:00:00	MSFT	Stock	53.55	53.6	53.5	53.5	2275.0
2016-03-22 08:30:00	MSFT	Stock	53.53	53.53	53.53	53.53	2785.0
2016-03-22 09:00:00	MSFT	Stock	53.64	53.74	53.64	53.73	9563.0
2016-03-22 09:30:00	MSFT	Stock	53.73	53.83	53.46	53.54	2743664.0
2016-03-22 10:00:00	MSFT	Stock	53.535	53.85	53.53	53.67	1878997.0
2016-03-22 10:30:00	MSFT	Stock	53.68	53.84	53.61	53.805	1008449.0
2016-03-22 11:00:00	MSFT	Stock	53.8	53.855	53.66	53.81	1104086.0
2016-03-22 11:30:00	MSFT	Stock	53.81	53.96	53.74	53.765	929495.0
2016-03-22 12:00:00	MSFT	Stock	53.76	53.96	53.75	53.93	623659.0
2016-03-22 12:30:00	MSFT	Stock	53.93	54.12	53.89	54.07	822933.0
2016-03-22 13:00:00	MSFT	Stock	54.07	54.17	54.06	54.13	775343.0
2016-03-22 13:30:00	MSFT	Stock	54.14	54.169	53.995	54.11	894927.0
2016-03-22 14:00:00	MSFT	Stock	54.11	54.18	54.05	54.1	924565.0
2016-03-22 14:30:00	MSFT	Stock	54.105	54.25	54.1	54.13	1297028.0
2016-03-22 15:00:00	MSFT	Stock	54.135	54.18	54.015	54.159	1710882.0
2016-03-22 15:30:00	MSFT	Stock	54.16	54.195	54.02	54.09	3009047.0
2016-03-22 16:00:00	MSFT	Stock	54.07	54.13	53.908	54.13	2576446.0

> showing 50 of 81,502 rows — these rows as CSV

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