PREVIEW / stock_30min / 2016-04-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-11.parquet
  size:    1.6 MB
  rows:    81,828
  symbols: 3,327

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-04-11 04:00:00	AAPL	Stock	27.165	27.3425	27.165	27.3425	2400.0
2016-04-11 05:00:00	AAPL	Stock	27.2775	27.2775	27.2775	27.2775	400.0
2016-04-11 05:30:00	AAPL	Stock	27.3225	27.3375	27.3225	27.3375	7216.0
2016-04-11 06:00:00	AAPL	Stock	27.2875	27.2875	27.2875	27.2875	4000.0
2016-04-11 06:30:00	AAPL	Stock	27.3	27.31	27.3	27.31	3600.0
2016-04-11 07:00:00	AAPL	Stock	27.2625	27.3075	27.2625	27.275	37928.0
2016-04-11 07:30:00	AAPL	Stock	27.2875	27.3	27.2875	27.295	31080.0
2016-04-11 08:00:00	AAPL	Stock	27.295	27.3	27.2625	27.2625	141088.0
2016-04-11 08:30:00	AAPL	Stock	27.265	27.295	27.25	27.2925	121648.0
2016-04-11 09:00:00	AAPL	Stock	27.165	27.3075	27.165	27.2425	319612.0
2016-04-11 09:30:00	AAPL	Stock	27.2425	27.61	27.2075	27.5925	19817064.0
2016-04-11 10:00:00	AAPL	Stock	27.5925	27.6375	27.5575	27.585	11314556.0
2016-04-11 10:30:00	AAPL	Stock	27.5848	27.6525	27.505	27.51	9176240.0
2016-04-11 11:00:00	AAPL	Stock	27.5078	27.5825	27.465	27.5525	6660192.0
2016-04-11 11:30:00	AAPL	Stock	27.5525	27.5575	27.395	27.485	7053200.0
2016-04-11 12:00:00	AAPL	Stock	27.485	27.51	27.4425	27.4865	3843716.0
2016-04-11 12:30:00	AAPL	Stock	27.49	27.545	27.4225	27.5325	3400916.0
2016-04-11 13:00:00	AAPL	Stock	27.5325	27.5575	27.485	27.5015	4213700.0
2016-04-11 13:30:00	AAPL	Stock	27.5	27.5375	27.43	27.4475	3202784.0
2016-04-11 14:00:00	AAPL	Stock	27.4462	27.4825	27.4025	27.4298	3831736.0
2016-04-11 14:30:00	AAPL	Stock	27.428	27.525	27.4175	27.5175	4446148.0
2016-04-11 15:00:00	AAPL	Stock	27.5175	27.52	27.34	27.34	6128136.0
2016-04-11 15:30:00	AAPL	Stock	27.3405	27.3625	27.25	27.2575	11711372.0
2016-04-11 16:00:00	AAPL	Stock	27.255	27.4262	27.2525	27.2525	6812448.0
2016-04-11 16:30:00	AAPL	Stock	27.255	27.4785	27.23	27.2475	3968588.0
2016-04-11 17:00:00	AAPL	Stock	27.2375	27.245	27.215	27.22	25432.0
2016-04-11 17:30:00	AAPL	Stock	27.225	27.225	27.2075	27.215	28008.0
2016-04-11 18:00:00	AAPL	Stock	27.2125	27.215	27.2025	27.215	18660.0
2016-04-11 18:30:00	AAPL	Stock	27.2075	27.2125	27.1975	27.2025	35720.0
2016-04-11 19:00:00	AAPL	Stock	27.2	27.2025	27.0375	27.18	48616.0
2016-04-11 19:30:00	AAPL	Stock	27.1875	27.1975	27.175	27.175	27596.0
2016-04-11 06:30:00	MSFT	Stock	54.52	54.52	54.51	54.52	9980.0
2016-04-11 07:30:00	MSFT	Stock	54.58	54.58	54.55	54.55	300.0
2016-04-11 08:00:00	MSFT	Stock	54.58	54.58	54.51	54.57	9480.0
2016-04-11 08:30:00	MSFT	Stock	54.57	54.58	54.57	54.58	380.0
2016-04-11 09:00:00	MSFT	Stock	54.42	54.6	54.42	54.51	20444.0
2016-04-11 09:30:00	MSFT	Stock	54.49	54.97	54.44	54.94	2376033.0
2016-04-11 10:00:00	MSFT	Stock	54.95	55.09	54.9	54.98	1430726.0
2016-04-11 10:30:00	MSFT	Stock	54.99	55.08	54.74	54.75	1100004.0
2016-04-11 11:00:00	MSFT	Stock	54.75	54.87	54.7	54.84	1287194.0
2016-04-11 11:30:00	MSFT	Stock	54.85	54.86	54.62	54.78	1248112.0
2016-04-11 12:00:00	MSFT	Stock	54.775	55.0	54.71	54.99	790997.0
2016-04-11 12:30:00	MSFT	Stock	54.98	55.15	54.86	55.11	1217664.0
2016-04-11 13:00:00	MSFT	Stock	55.1	55.15	55.01	55.09	1123154.0
2016-04-11 13:30:00	MSFT	Stock	55.09	55.135	54.94	54.97	749179.0
2016-04-11 14:00:00	MSFT	Stock	54.97	55.04	54.83	54.85	955912.0
2016-04-11 14:30:00	MSFT	Stock	54.855	55.035	54.82	55.0	1035028.0
2016-04-11 15:00:00	MSFT	Stock	54.995	54.995	54.6	54.6	1076778.0
2016-04-11 15:30:00	MSFT	Stock	54.605	54.66	54.3	54.31	3485145.0
2016-04-11 16:00:00	MSFT	Stock	54.31	54.34	54.29	54.33	1965598.0

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

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