PREVIEW / stock_30min / 2018-11-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-11-28.parquet
  size:    1.7 MB
  rows:    85,110
  symbols: 2,755

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-11-28 04:00:00	AAPL	Stock	43.9225	43.925	43.85	43.875	9996.0
2018-11-28 04:30:00	AAPL	Stock	43.925	43.95	43.925	43.95	4372.0
2018-11-28 05:00:00	AAPL	Stock	43.9	43.95	43.8775	43.95	17564.0
2018-11-28 05:30:00	AAPL	Stock	43.925	43.975	43.925	43.975	5896.0
2018-11-28 06:00:00	AAPL	Stock	43.9875	44.0	43.9625	44.0	4064.0
2018-11-28 06:30:00	AAPL	Stock	43.9875	44.0375	43.9725	43.995	17792.0
2018-11-28 07:00:00	AAPL	Stock	44.03	44.1	44.0025	44.03	142224.0
2018-11-28 07:30:00	AAPL	Stock	44.0275	44.095	43.9775	44.01	372068.0
2018-11-28 08:00:00	AAPL	Stock	44.1	44.1	43.98	44.0625	372924.0
2018-11-28 08:30:00	AAPL	Stock	44.0625	44.15	44.0625	44.085	330240.0
2018-11-28 09:00:00	AAPL	Stock	44.085	44.2225	44.0775	44.1825	499764.0
2018-11-28 09:30:00	AAPL	Stock	44.1825	44.21	43.87	44.0	19394644.0
2018-11-28 10:00:00	AAPL	Stock	44.01	44.0775	43.7325	43.8922	11521856.0
2018-11-28 10:30:00	AAPL	Stock	43.895	44.135	43.835	43.9725	9163004.0
2018-11-28 11:00:00	AAPL	Stock	43.9675	44.0198	43.8025	43.9758	8633064.0
2018-11-28 11:30:00	AAPL	Stock	43.97	44.11	43.935	44.025	6743468.0
2018-11-28 12:00:00	AAPL	Stock	44.0275	44.8625	44.0275	44.7958	19160092.0
2018-11-28 12:30:00	AAPL	Stock	44.799	44.92	44.5875	44.6325	14420612.0
2018-11-28 13:00:00	AAPL	Stock	44.6375	44.8525	44.55	44.8275	8368004.0
2018-11-28 13:30:00	AAPL	Stock	44.825	45.0275	44.79	44.9162	9461244.0
2018-11-28 14:00:00	AAPL	Stock	44.915	44.9725	44.735	44.8925	7322612.0
2018-11-28 14:30:00	AAPL	Stock	44.8975	45.005	44.825	44.86	5716824.0
2018-11-28 15:00:00	AAPL	Stock	44.8575	45.01	44.69	44.9918	9531952.0
2018-11-28 15:30:00	AAPL	Stock	44.99	45.3225	44.94	45.2425	18333736.0
2018-11-28 16:00:00	AAPL	Stock	45.24	45.35	45.2325	45.3	12656052.0
2018-11-28 16:30:00	AAPL	Stock	45.2875	45.375	45.2675	45.3725	245516.0
2018-11-28 17:00:00	AAPL	Stock	45.37	45.545	45.35	45.525	281796.0
2018-11-28 17:30:00	AAPL	Stock	45.55	45.55	45.42	45.47	115388.0
2018-11-28 18:00:00	AAPL	Stock	45.4375	45.48	45.3825	45.475	73912.0
2018-11-28 18:30:00	AAPL	Stock	45.4775	45.4875	45.43	45.4875	63868.0
2018-11-28 19:00:00	AAPL	Stock	45.4875	45.5	45.4625	45.47	48944.0
2018-11-28 19:30:00	AAPL	Stock	45.455	45.465	45.3875	45.465	66212.0
2018-11-28 04:00:00	MSFT	Stock	107.1	107.5	107.1	107.5	1542.0
2018-11-28 04:30:00	MSFT	Stock	107.75	107.75	107.75	107.75	3819.0
2018-11-28 05:30:00	MSFT	Stock	107.9	107.9	107.9	107.9	977.0
2018-11-28 06:30:00	MSFT	Stock	107.94	108.0	107.8	108.0	4772.0
2018-11-28 07:00:00	MSFT	Stock	108.0	108.1	107.85	107.91	12977.0
2018-11-28 07:30:00	MSFT	Stock	107.92	108.1	107.92	108.01	11927.0
2018-11-28 08:00:00	MSFT	Stock	108.01	108.24	107.9	108.2	41998.0
2018-11-28 08:30:00	MSFT	Stock	108.2	108.35	108.01	108.12	37226.0
2018-11-28 09:00:00	MSFT	Stock	108.11	108.18	107.72	107.87	44530.0
2018-11-28 09:30:00	MSFT	Stock	107.87	108.72	107.86	108.215	4824619.0
2018-11-28 10:00:00	MSFT	Stock	108.21	108.918	108.2	108.73	2358963.0
2018-11-28 10:30:00	MSFT	Stock	108.72	108.745	108.07	108.265	1949195.0
2018-11-28 11:00:00	MSFT	Stock	108.26	108.41	108.064	108.12	1409859.0
2018-11-28 11:30:00	MSFT	Stock	108.12	109.03	108.06	108.89	1536261.0
2018-11-28 12:00:00	MSFT	Stock	108.89	110.89	108.88	110.73	5415450.0
2018-11-28 12:30:00	MSFT	Stock	110.73	111.0	110.36	110.455	2899700.0
2018-11-28 13:00:00	MSFT	Stock	110.46	110.505	109.96	110.455	2642533.0
2018-11-28 13:30:00	MSFT	Stock	110.46	111.08	110.44	110.64	2641689.0

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

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