PREVIEW / stock_30min / 2018-01-11

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-11.parquet
  size:    1.7 MB
  rows:    85,126
  symbols: 2,906

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-01-11 04:00:00	AAPL	Stock	43.62	43.62	43.62	43.62	400.0
2018-01-11 04:30:00	AAPL	Stock	43.5725	43.5725	43.5725	43.5725	400.0
2018-01-11 05:00:00	AAPL	Stock	43.5625	43.5625	43.5625	43.5625	3200.0
2018-01-11 05:30:00	AAPL	Stock	43.5575	43.5575	43.5	43.5	4000.0
2018-01-11 06:30:00	AAPL	Stock	43.5875	43.5875	43.525	43.525	2800.0
2018-01-11 07:00:00	AAPL	Stock	43.595	43.6825	43.575	43.6575	36220.0
2018-01-11 07:30:00	AAPL	Stock	43.6825	43.6875	43.6625	43.675	28244.0
2018-01-11 08:00:00	AAPL	Stock	43.675	43.7	43.5775	43.6775	103664.0
2018-01-11 08:30:00	AAPL	Stock	43.68	43.68	43.625	43.65	80124.0
2018-01-11 09:00:00	AAPL	Stock	43.6475	43.675	43.585	43.6475	92808.0
2018-01-11 09:30:00	AAPL	Stock	43.6475	43.87	43.6225	43.775	12649044.0
2018-01-11 10:00:00	AAPL	Stock	43.7775	43.8722	43.705	43.7525	5872968.0
2018-01-11 10:30:00	AAPL	Stock	43.7525	43.825	43.7075	43.8105	4057856.0
2018-01-11 11:00:00	AAPL	Stock	43.81	43.8475	43.7875	43.8125	4068704.0
2018-01-11 11:30:00	AAPL	Stock	43.8125	43.8438	43.745	43.77	3517004.0
2018-01-11 12:00:00	AAPL	Stock	43.7712	43.82	43.7375	43.795	3239656.0
2018-01-11 12:30:00	AAPL	Stock	43.795	43.8225	43.7702	43.8025	3488772.0
2018-01-11 13:00:00	AAPL	Stock	43.805	43.8175	43.745	43.7475	2357044.0
2018-01-11 13:30:00	AAPL	Stock	43.7475	43.765	43.725	43.759	1910588.0
2018-01-11 14:00:00	AAPL	Stock	43.7575	43.8013	43.74	43.7812	2529844.0
2018-01-11 14:30:00	AAPL	Stock	43.7825	43.79	43.7375	43.765	2157960.0
2018-01-11 15:00:00	AAPL	Stock	43.7625	43.7975	43.7475	43.78	3055576.0
2018-01-11 15:30:00	AAPL	Stock	43.779	43.8375	43.77	43.8175	7992084.0
2018-01-11 16:00:00	AAPL	Stock	43.82	43.8375	43.5125	43.8175	7294388.0
2018-01-11 16:30:00	AAPL	Stock	43.815	43.825	43.8025	43.82	182572.0
2018-01-11 17:00:00	AAPL	Stock	43.82	43.83	43.82	43.8225	3010192.0
2018-01-11 17:30:00	AAPL	Stock	43.8125	43.825	43.8	43.8225	6220.0
2018-01-11 18:00:00	AAPL	Stock	43.815	43.8225	43.8075	43.81	8308.0
2018-01-11 18:30:00	AAPL	Stock	43.81	43.8175	43.8025	43.8025	14148.0
2018-01-11 19:00:00	AAPL	Stock	43.8125	43.8125	43.8025	43.8025	10636.0
2018-01-11 19:30:00	AAPL	Stock	43.805	43.81	43.7875	43.81	10016.0
2018-01-11 04:00:00	MSFT	Stock	87.96	87.99	87.96	87.99	364.0
2018-01-11 07:00:00	MSFT	Stock	88.03	88.03	88.03	88.03	100.0
2018-01-11 07:30:00	MSFT	Stock	88.03	88.2	88.03	88.2	833.0
2018-01-11 08:00:00	MSFT	Stock	88.03	88.15	88.03	88.1	13951.0
2018-01-11 08:30:00	MSFT	Stock	88.1	88.1	88.05	88.1	3945.0
2018-01-11 09:00:00	MSFT	Stock	88.1	88.13	87.64	87.77	33833.0
2018-01-11 09:30:00	MSFT	Stock	88.13	88.13	87.24	87.75	2358112.0
2018-01-11 10:00:00	MSFT	Stock	87.745	87.97	87.73	87.78	1314564.0
2018-01-11 10:30:00	MSFT	Stock	87.79	87.805	87.52	87.649	871976.0
2018-01-11 11:00:00	MSFT	Stock	87.65	87.845	87.644	87.77	737917.0
2018-01-11 11:30:00	MSFT	Stock	87.77	87.865	87.67	87.855	605536.0
2018-01-11 12:00:00	MSFT	Stock	87.86	87.99	87.79	87.97	874941.0
2018-01-11 12:30:00	MSFT	Stock	87.97	88.09	87.93	88.025	895763.0
2018-01-11 13:00:00	MSFT	Stock	88.027	88.065	87.93	87.94	580924.0
2018-01-11 13:30:00	MSFT	Stock	87.95	87.96	87.85	87.91	436572.0
2018-01-11 14:00:00	MSFT	Stock	87.91	87.945	87.81	87.81	532982.0
2018-01-11 14:30:00	MSFT	Stock	87.815	87.85	87.705	87.725	648226.0
2018-01-11 15:00:00	MSFT	Stock	87.725	87.85	87.67	87.775	1063442.0
2018-01-11 15:30:00	MSFT	Stock	87.775	88.08	87.75	88.06	2512341.0

> showing 50 of 85,126 rows — these rows as CSV

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