PREVIEW / stock_30min / 2018-10-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-19.parquet
  size:    1.7 MB
  rows:    84,383
  symbols: 2,746

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-19 04:00:00	AAPL	Stock	54.2975	54.3125	54.17	54.17	7632.0
2018-10-19 04:30:00	AAPL	Stock	54.19	54.2375	54.19	54.2375	1940.0
2018-10-19 05:00:00	AAPL	Stock	54.35	54.38	54.3475	54.375	13416.0
2018-10-19 05:30:00	AAPL	Stock	54.4	54.5	54.395	54.395	18324.0
2018-10-19 06:00:00	AAPL	Stock	54.3725	54.49	54.37	54.4425	59356.0
2018-10-19 06:30:00	AAPL	Stock	54.5	54.53	54.485	54.4925	32964.0
2018-10-19 07:00:00	AAPL	Stock	54.4625	54.6775	54.4175	54.645	163624.0
2018-10-19 07:30:00	AAPL	Stock	54.625	54.65	54.55	54.6375	145856.0
2018-10-19 08:00:00	AAPL	Stock	54.4795	54.785	54.4425	54.6825	484496.0
2018-10-19 08:30:00	AAPL	Stock	54.665	54.7025	54.5825	54.6625	283236.0
2018-10-19 09:00:00	AAPL	Stock	54.6625	54.8275	54.3775	54.79	1014908.0
2018-10-19 09:30:00	AAPL	Stock	54.79	55.0	54.41	54.92	20873168.0
2018-10-19 10:00:00	AAPL	Stock	54.92	55.2075	54.89	55.095	9320036.0
2018-10-19 10:30:00	AAPL	Stock	55.0975	55.2825	55.065	55.223	6724940.0
2018-10-19 11:00:00	AAPL	Stock	55.2255	55.315	54.965	54.98	5778076.0
2018-10-19 11:30:00	AAPL	Stock	54.9775	55.0325	54.725	54.905	5964440.0
2018-10-19 12:00:00	AAPL	Stock	54.9175	54.9718	54.4125	54.5375	6747248.0
2018-10-19 12:30:00	AAPL	Stock	54.5375	54.84	54.3575	54.77	6262440.0
2018-10-19 13:00:00	AAPL	Stock	54.765	54.9825	54.5825	54.9475	4672220.0
2018-10-19 13:30:00	AAPL	Stock	54.955	55.035	54.73	54.7385	4354004.0
2018-10-19 14:00:00	AAPL	Stock	54.735	54.7725	54.4625	54.6425	4962644.0
2018-10-19 14:30:00	AAPL	Stock	54.65	54.86	54.605	54.7175	3464756.0
2018-10-19 15:00:00	AAPL	Stock	54.7075	54.9825	54.695	54.95	5398388.0
2018-10-19 15:30:00	AAPL	Stock	54.9495	55.0525	54.795	54.825	10632368.0
2018-10-19 16:00:00	AAPL	Stock	54.8275	54.8675	54.7275	54.77	10180792.0
2018-10-19 16:30:00	AAPL	Stock	54.78	54.8275	54.76	54.7675	112272.0
2018-10-19 17:00:00	AAPL	Stock	54.7675	54.7775	54.705	54.7225	69024.0
2018-10-19 17:30:00	AAPL	Stock	54.7125	54.7475	54.6775	54.7475	55816.0
2018-10-19 18:00:00	AAPL	Stock	54.725	54.7875	54.725	54.75	18124.0
2018-10-19 18:30:00	AAPL	Stock	54.75	54.795	54.75	54.75	14156.0
2018-10-19 19:00:00	AAPL	Stock	54.75	54.75	54.73	54.75	7936.0
2018-10-19 19:30:00	AAPL	Stock	54.75	54.785	54.735	54.75	44304.0
2018-10-19 04:00:00	MSFT	Stock	109.24	109.24	109.24	109.24	400.0
2018-10-19 04:30:00	MSFT	Stock	108.89	108.89	108.89	108.89	1000.0
2018-10-19 05:00:00	MSFT	Stock	108.95	108.98	108.95	108.98	600.0
2018-10-19 05:30:00	MSFT	Stock	108.89	109.0	108.89	109.0	720.0
2018-10-19 06:30:00	MSFT	Stock	109.15	109.25	109.15	109.2	4433.0
2018-10-19 07:00:00	MSFT	Stock	109.22	109.5	109.18	109.45	11589.0
2018-10-19 07:30:00	MSFT	Stock	109.45	109.58	109.3	109.58	11387.0
2018-10-19 08:00:00	MSFT	Stock	109.39	109.79	109.0	109.05	36123.0
2018-10-19 08:30:00	MSFT	Stock	109.25	109.33	108.86	109.26	32937.0
2018-10-19 09:00:00	MSFT	Stock	109.28	109.57	108.72	108.94	215743.0
2018-10-19 09:30:00	MSFT	Stock	109.51	110.47	108.92	110.17	5432591.0
2018-10-19 10:00:00	MSFT	Stock	110.18	110.799	110.07	110.42	2175376.0
2018-10-19 10:30:00	MSFT	Stock	110.42	110.86	110.05	110.43	1390055.0
2018-10-19 11:00:00	MSFT	Stock	110.46	110.69	109.835	109.85	1096292.0
2018-10-19 11:30:00	MSFT	Stock	109.86	110.02	109.46	109.87	1325144.0
2018-10-19 12:00:00	MSFT	Stock	109.87	110.09	108.81	108.93	1925418.0
2018-10-19 12:30:00	MSFT	Stock	108.93	109.23	108.38	109.1	1902753.0
2018-10-19 13:00:00	MSFT	Stock	109.09	109.325	108.53	109.28	1200080.0

> showing 50 of 84,383 rows — these rows as CSV

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