PREVIEW / stock_30min / 2018-10-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-01.parquet
  size:    1.7 MB
  rows:    86,264
  symbols: 2,791

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-10-01 04:00:00	AAPL	Stock	56.6875	56.99	56.6875	56.9	33396.0
2018-10-01 04:30:00	AAPL	Stock	56.9	56.945	56.875	56.8975	11844.0
2018-10-01 05:00:00	AAPL	Stock	56.8975	56.925	56.8975	56.8975	5104.0
2018-10-01 05:30:00	AAPL	Stock	56.8975	56.9	56.8975	56.9	4980.0
2018-10-01 06:00:00	AAPL	Stock	56.9	56.9175	56.875	56.8975	26748.0
2018-10-01 06:30:00	AAPL	Stock	56.9225	57.0	56.9175	56.995	34928.0
2018-10-01 07:00:00	AAPL	Stock	56.9525	57.11	56.925	57.075	210732.0
2018-10-01 07:30:00	AAPL	Stock	57.045	57.045	56.9125	56.9625	129632.0
2018-10-01 08:00:00	AAPL	Stock	56.93	57.1125	56.9125	56.9775	354172.0
2018-10-01 08:30:00	AAPL	Stock	56.9775	56.98	56.9	56.9425	190172.0
2018-10-01 09:00:00	AAPL	Stock	56.94	57.0	56.94	57.0	178312.0
2018-10-01 09:30:00	AAPL	Stock	56.985	57.335	56.8575	57.1975	14924236.0
2018-10-01 10:00:00	AAPL	Stock	57.1925	57.355	57.115	57.241	7069000.0
2018-10-01 10:30:00	AAPL	Stock	57.2405	57.25	57.12	57.2175	4462448.0
2018-10-01 11:00:00	AAPL	Stock	57.22	57.22	57.0325	57.1425	4622508.0
2018-10-01 11:30:00	AAPL	Stock	57.145	57.2475	57.115	57.22	3655112.0
2018-10-01 12:00:00	AAPL	Stock	57.2212	57.2212	56.98	56.9925	3455648.0
2018-10-01 12:30:00	AAPL	Stock	56.9925	57.0358	56.8875	56.8945	3412460.0
2018-10-01 13:00:00	AAPL	Stock	56.895	57.0025	56.8525	56.975	3604560.0
2018-10-01 13:30:00	AAPL	Stock	56.9775	56.9892	56.8975	56.935	2269416.0
2018-10-01 14:00:00	AAPL	Stock	56.935	56.9425	56.795	56.835	2980200.0
2018-10-01 14:30:00	AAPL	Stock	56.8352	56.8382	56.6825	56.785	4038932.0
2018-10-01 15:00:00	AAPL	Stock	56.79	56.8325	56.655	56.7	3257372.0
2018-10-01 15:30:00	AAPL	Stock	56.6975	56.865	56.5875	56.8175	7599256.0
2018-10-01 16:00:00	AAPL	Stock	56.815	56.855	56.8	56.8125	5800632.0
2018-10-01 16:30:00	AAPL	Stock	56.8125	56.835	56.8	56.8325	4916.0
2018-10-01 17:00:00	AAPL	Stock	56.8142	56.8325	56.8125	56.8125	11768.0
2018-10-01 17:30:00	AAPL	Stock	56.8325	56.8325	56.8125	56.8125	12764.0
2018-10-01 18:00:00	AAPL	Stock	56.815	56.8375	56.815	56.815	60920.0
2018-10-01 18:30:00	AAPL	Stock	56.82	56.835	56.82	56.825	6012.0
2018-10-01 19:00:00	AAPL	Stock	56.825	56.8425	56.82	56.8425	21356.0
2018-10-01 19:30:00	AAPL	Stock	56.825	56.85	56.825	56.845	12692.0
2018-10-01 04:00:00	MSFT	Stock	114.52	115.33	114.52	115.15	2984.0
2018-10-01 06:00:00	MSFT	Stock	115.25	115.4	115.25	115.4	500.0
2018-10-01 06:30:00	MSFT	Stock	115.45	115.45	115.4	115.4	550.0
2018-10-01 07:00:00	MSFT	Stock	115.47	115.47	115.16	115.39	4965.0
2018-10-01 07:30:00	MSFT	Stock	115.36	115.36	115.15	115.18	2212.0
2018-10-01 08:00:00	MSFT	Stock	115.15	115.47	115.07	115.2	18997.0
2018-10-01 08:30:00	MSFT	Stock	115.18	115.19	114.37	115.06	13650.0
2018-10-01 09:00:00	MSFT	Stock	115.08	115.14	114.37	114.76	56834.0
2018-10-01 09:30:00	MSFT	Stock	114.75	115.485	114.73	115.18	2174412.0
2018-10-01 10:00:00	MSFT	Stock	115.19	115.45	115.08	115.26	1305720.0
2018-10-01 10:30:00	MSFT	Stock	115.26	115.49	115.25	115.48	917226.0
2018-10-01 11:00:00	MSFT	Stock	115.48	115.61	115.32	115.57	1025306.0
2018-10-01 11:30:00	MSFT	Stock	115.57	115.655	115.305	115.521	865735.0
2018-10-01 12:00:00	MSFT	Stock	115.53	115.645	115.35	115.475	595747.0
2018-10-01 12:30:00	MSFT	Stock	115.47	115.52	115.34	115.396	831323.0
2018-10-01 13:00:00	MSFT	Stock	115.395	115.54	115.32	115.5	584829.0
2018-10-01 13:30:00	MSFT	Stock	115.49	115.54	115.43	115.53	571551.0
2018-10-01 14:00:00	MSFT	Stock	115.53	115.535	115.31	115.35	674158.0

> showing 50 of 86,264 rows — these rows as CSV

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