PREVIEW / stock_30min / 2017-01-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-06.parquet
  size:    1.6 MB
  rows:    81,055
  symbols: 3,136

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
2017-01-06 06:00:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	568.0
2017-01-06 06:30:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	424.0
2017-01-06 07:00:00	AAPL	Stock	29.1525	29.2025	29.1525	29.2025	6668.0
2017-01-06 07:30:00	AAPL	Stock	29.2	29.2	29.175	29.175	1800.0
2017-01-06 08:00:00	AAPL	Stock	29.1525	29.2025	29.0	29.1525	192272.0
2017-01-06 08:30:00	AAPL	Stock	29.125	29.2175	29.125	29.1375	122104.0
2017-01-06 09:00:00	AAPL	Stock	29.1525	29.2025	29.15	29.195	205588.0
2017-01-06 09:30:00	AAPL	Stock	29.195	29.425	29.1175	29.42	26551320.0
2017-01-06 10:00:00	AAPL	Stock	29.42	29.4475	29.3625	29.3828	10554416.0
2017-01-06 10:30:00	AAPL	Stock	29.385	29.4475	29.35	29.405	7686124.0
2017-01-06 11:00:00	AAPL	Stock	29.4062	29.485	29.375	29.47	6168284.0
2017-01-06 11:30:00	AAPL	Stock	29.4725	29.4925	29.4375	29.4828	5274428.0
2017-01-06 12:00:00	AAPL	Stock	29.4835	29.54	29.4725	29.525	9850140.0
2017-01-06 12:30:00	AAPL	Stock	29.525	29.5325	29.4525	29.476	5482256.0
2017-01-06 13:00:00	AAPL	Stock	29.475	29.48	29.4112	29.4252	4612412.0
2017-01-06 13:30:00	AAPL	Stock	29.426	29.4925	29.425	29.4575	3629288.0
2017-01-06 14:00:00	AAPL	Stock	29.46	29.54	29.46	29.5075	7430072.0
2017-01-06 14:30:00	AAPL	Stock	29.5062	29.54	29.4875	29.491	5550044.0
2017-01-06 15:00:00	AAPL	Stock	29.49	29.5225	29.4825	29.495	5611448.0
2017-01-06 15:30:00	AAPL	Stock	29.495	29.5075	29.4525	29.4775	10850072.0
2017-01-06 16:00:00	AAPL	Stock	29.4775	29.5	29.3932	29.4925	8065616.0
2017-01-06 16:30:00	AAPL	Stock	29.49	29.5245	29.48	29.49	112052.0
2017-01-06 17:00:00	AAPL	Stock	29.49	29.49	29.4625	29.4875	15832.0
2017-01-06 17:30:00	AAPL	Stock	29.4875	29.4875	29.48	29.485	2080.0
2017-01-06 18:00:00	AAPL	Stock	29.485	29.4875	29.475	29.4775	18404.0
2017-01-06 18:30:00	AAPL	Stock	29.475	29.475	29.47	29.47	2680.0
2017-01-06 19:00:00	AAPL	Stock	29.4725	29.4725	29.45	29.45	43472.0
2017-01-06 19:30:00	AAPL	Stock	29.46	29.47	29.46	29.46	12904.0
2017-01-06 08:00:00	MSFT	Stock	62.4	62.4	62.4	62.4	200.0
2017-01-06 08:30:00	MSFT	Stock	62.33	62.35	62.33	62.35	306.0
2017-01-06 09:30:00	MSFT	Stock	62.38	62.54	62.04	62.52	2512222.0
2017-01-06 10:00:00	MSFT	Stock	62.52	62.69	62.47	62.52	1276500.0
2017-01-06 10:30:00	MSFT	Stock	62.52	62.65	62.41	62.62	1353504.0
2017-01-06 11:00:00	MSFT	Stock	62.63	62.73	62.59	62.71	957065.0
2017-01-06 11:30:00	MSFT	Stock	62.72	62.97	62.695	62.97	1177366.0
2017-01-06 12:00:00	MSFT	Stock	62.96	63.13	62.93	63.05	1700795.0
2017-01-06 12:30:00	MSFT	Stock	63.055	63.13	63.0	63.1	943979.0
2017-01-06 13:00:00	MSFT	Stock	63.09	63.15	62.99	63.0	766199.0
2017-01-06 13:30:00	MSFT	Stock	63.005	63.109	62.99	63.02	638452.0
2017-01-06 14:00:00	MSFT	Stock	63.024	63.12	63.0	63.024	734131.0
2017-01-06 14:30:00	MSFT	Stock	63.02	63.038	62.93	63.015	975510.0
2017-01-06 15:00:00	MSFT	Stock	63.01	63.03	62.85	62.91	1077133.0
2017-01-06 15:30:00	MSFT	Stock	62.9	62.99	62.81	62.84	2327365.0
2017-01-06 16:00:00	MSFT	Stock	62.84	62.96	62.81	62.84	2152174.0
2017-01-06 16:30:00	MSFT	Stock	62.83	62.83	62.83	62.83	1000.0
2017-01-06 17:00:00	MSFT	Stock	62.85	62.85	62.83	62.83	344.0
2017-01-06 18:00:00	MSFT	Stock	62.8	62.8	62.8	62.8	200.0
2017-01-06 18:30:00	MSFT	Stock	62.8	62.8	62.8	62.8	2909.0
2017-01-06 19:00:00	MSFT	Stock	62.84	62.84	62.8	62.8	1036.0
2017-01-06 19:30:00	MSFT	Stock	62.8	62.8	62.8	62.8	2200.0

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

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