PREVIEW / stock_30min / 2018-07-03

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-03.parquet
  size:    1.1 MB
  rows:    51,871
  symbols: 2,763

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-07-03 04:30:00	AAPL	Stock	46.8175	46.8175	46.8175	46.8175	3884.0
2018-07-03 05:00:00	AAPL	Stock	46.8225	46.8225	46.8225	46.8225	7200.0
2018-07-03 05:30:00	AAPL	Stock	46.925	46.925	46.825	46.825	7824.0
2018-07-03 06:00:00	AAPL	Stock	46.925	46.9725	46.925	46.9725	7188.0
2018-07-03 06:30:00	AAPL	Stock	46.9425	46.975	46.9175	46.9175	8572.0
2018-07-03 07:00:00	AAPL	Stock	46.925	46.965	46.8925	46.965	75776.0
2018-07-03 07:30:00	AAPL	Stock	46.9525	46.9975	46.9375	46.965	118052.0
2018-07-03 08:00:00	AAPL	Stock	46.975	46.9975	46.92	46.9275	132944.0
2018-07-03 08:30:00	AAPL	Stock	46.9475	46.9625	46.8875	46.9125	57448.0
2018-07-03 09:00:00	AAPL	Stock	46.9075	46.9575	46.8375	46.92	116536.0
2018-07-03 09:30:00	AAPL	Stock	46.92	46.9875	46.5775	46.675	10441516.0
2018-07-03 10:00:00	AAPL	Stock	46.675	46.81	46.585	46.7475	5999252.0
2018-07-03 10:30:00	AAPL	Stock	46.75	46.86	46.685	46.7425	3811556.0
2018-07-03 11:00:00	AAPL	Stock	46.7475	46.755	46.6175	46.6775	2358156.0
2018-07-03 11:30:00	AAPL	Stock	46.68	46.68	46.545	46.6108	2831096.0
2018-07-03 12:00:00	AAPL	Stock	46.6125	46.65	46.2775	46.305	5149876.0
2018-07-03 12:30:00	AAPL	Stock	46.305	46.3575	45.885	45.91	13089400.0
2018-07-03 13:00:00	AAPL	Stock	45.91	45.98	45.89	45.9487	5672864.0
2018-07-03 13:30:00	AAPL	Stock	45.955	45.98	45.925	45.945	72424.0
2018-07-03 14:00:00	AAPL	Stock	45.945	45.975	45.94	45.975	36608.0
2018-07-03 14:30:00	AAPL	Stock	45.9625	45.975	45.9525	45.965	36352.0
2018-07-03 15:00:00	AAPL	Stock	45.975	45.9975	45.975	45.975	41200.0
2018-07-03 15:30:00	AAPL	Stock	45.9975	46.0085	45.9925	46.0	13652.0
2018-07-03 16:00:00	AAPL	Stock	46.0	46.0	45.995	45.995	1400.0
2018-07-03 16:30:00	AAPL	Stock	45.9625	45.9975	45.9525	45.99	11892.0
2018-07-03 04:00:00	MSFT	Stock	100.1	100.3	100.1	100.3	1146.0
2018-07-03 04:30:00	MSFT	Stock	100.3	100.3	100.3	100.3	1000.0
2018-07-03 05:30:00	MSFT	Stock	100.54	100.54	100.54	100.54	1100.0
2018-07-03 06:00:00	MSFT	Stock	100.6	100.6	100.6	100.6	100.0
2018-07-03 06:30:00	MSFT	Stock	100.7	100.7	100.7	100.7	406.0
2018-07-03 07:00:00	MSFT	Stock	100.64	100.8	100.64	100.8	7234.0
2018-07-03 07:30:00	MSFT	Stock	100.83	101.04	100.8	100.8	7333.0
2018-07-03 08:00:00	MSFT	Stock	100.674	100.98	100.36	100.85	6113.0
2018-07-03 08:30:00	MSFT	Stock	100.8	100.82	100.65	100.65	5676.0
2018-07-03 09:00:00	MSFT	Stock	100.68	100.69	100.35	100.35	17769.0
2018-07-03 09:30:00	MSFT	Stock	100.41	100.63	99.47	99.96	3202666.0
2018-07-03 10:00:00	MSFT	Stock	99.96	100.16	99.841	99.92	1418314.0
2018-07-03 10:30:00	MSFT	Stock	99.93	100.015	99.62	99.7	1271953.0
2018-07-03 11:00:00	MSFT	Stock	99.7	99.83	99.58	99.79	828541.0
2018-07-03 11:30:00	MSFT	Stock	99.79	99.91	99.58	99.685	970606.0
2018-07-03 12:00:00	MSFT	Stock	99.69	99.72	99.22	99.445	1143633.0
2018-07-03 12:30:00	MSFT	Stock	99.44	99.47	98.94	99.07	2482145.0
2018-07-03 13:00:00	MSFT	Stock	99.07	99.09	98.78	98.95	1708637.0
2018-07-03 13:30:00	MSFT	Stock	98.94	99.05	98.94	99.05	4177.0
2018-07-03 14:00:00	MSFT	Stock	99.0	99.0	99.0	99.0	999.0
2018-07-03 14:30:00	MSFT	Stock	98.96	99.0	98.88	98.88	2976.0
2018-07-03 15:00:00	MSFT	Stock	99.05	99.05	98.922	99.05	5194.0
2018-07-03 15:30:00	MSFT	Stock	99.0	99.05	98.965	98.965	1527.0
2018-07-03 16:00:00	MSFT	Stock	98.97	98.97	98.97	98.97	1060.0
2018-07-03 16:30:00	MSFT	Stock	98.95	98.95	98.95	98.95	290.0

> showing 50 of 51,871 rows — these rows as CSV

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