PREVIEW / stock_30min / 2019-03-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-05.parquet
  size:    1.7 MB
  rows:    83,971
  symbols: 2,638

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
2019-03-05 04:00:00	AAPL	Stock	44.04	44.075	44.04	44.045	2416.0
2019-03-05 05:00:00	AAPL	Stock	44.025	44.025	44.025	44.025	688.0
2019-03-05 05:30:00	AAPL	Stock	43.965	44.025	43.9375	43.9375	3332.0
2019-03-05 06:00:00	AAPL	Stock	43.95	43.95	43.95	43.95	9160.0
2019-03-05 06:30:00	AAPL	Stock	43.95	43.95	43.95	43.95	424.0
2019-03-05 07:00:00	AAPL	Stock	43.95	43.95	43.875	43.9125	22028.0
2019-03-05 07:30:00	AAPL	Stock	43.91	43.9375	43.85	43.875	25016.0
2019-03-05 08:00:00	AAPL	Stock	43.9375	43.9625	43.825	43.95	45528.0
2019-03-05 08:30:00	AAPL	Stock	43.9625	44.0325	43.88	43.935	81892.0
2019-03-05 09:00:00	AAPL	Stock	43.935	43.9775	43.925	43.9625	34028.0
2019-03-05 09:30:00	AAPL	Stock	43.98	44.0	43.6915	43.72	10070048.0
2019-03-05 10:00:00	AAPL	Stock	43.72	43.885	43.635	43.6775	7606400.0
2019-03-05 10:30:00	AAPL	Stock	43.675	43.8025	43.6725	43.7925	5379132.0
2019-03-05 11:00:00	AAPL	Stock	43.7925	43.915	43.7675	43.8525	4745592.0
2019-03-05 11:30:00	AAPL	Stock	43.8542	43.9875	43.8325	43.8775	4141076.0
2019-03-05 12:00:00	AAPL	Stock	43.8775	43.8875	43.7725	43.802	3262764.0
2019-03-05 12:30:00	AAPL	Stock	43.805	43.8425	43.7725	43.815	2429768.0
2019-03-05 13:00:00	AAPL	Stock	43.8175	43.8675	43.805	43.8125	2471348.0
2019-03-05 13:30:00	AAPL	Stock	43.815	43.85	43.7888	43.845	2068036.0
2019-03-05 14:00:00	AAPL	Stock	43.845	43.905	43.8418	43.89	2131316.0
2019-03-05 14:30:00	AAPL	Stock	43.89	43.925	43.8575	43.9162	2155084.0
2019-03-05 15:00:00	AAPL	Stock	43.9162	43.92	43.87	43.8812	2722076.0
2019-03-05 15:30:00	AAPL	Stock	43.8812	43.9625	43.875	43.8775	6828880.0
2019-03-05 16:00:00	AAPL	Stock	43.88	43.911	43.85	43.911	13769828.0
2019-03-05 16:30:00	AAPL	Stock	43.8875	43.8975	43.855	43.855	14576.0
2019-03-05 17:00:00	AAPL	Stock	43.85	43.85	43.815	43.8195	6188.0
2019-03-05 17:30:00	AAPL	Stock	43.815	43.86	43.8025	43.8125	17052.0
2019-03-05 18:00:00	AAPL	Stock	43.8125	43.8575	43.785	43.825	5896.0
2019-03-05 18:30:00	AAPL	Stock	43.79	43.8125	43.7525	43.7525	10656.0
2019-03-05 19:00:00	AAPL	Stock	43.8375	43.8375	43.76	43.7625	7872.0
2019-03-05 19:30:00	AAPL	Stock	43.7775	43.7925	43.7625	43.775	14520.0
2019-03-05 04:00:00	MSFT	Stock	112.42	112.42	112.42	112.42	100.0
2019-03-05 05:00:00	MSFT	Stock	112.25	112.25	112.25	112.25	100.0
2019-03-05 06:00:00	MSFT	Stock	112.25	112.25	112.21	112.21	420.0
2019-03-05 07:00:00	MSFT	Stock	112.13	112.13	112.06	112.06	1656.0
2019-03-05 07:30:00	MSFT	Stock	112.02	112.1	111.9	112.05	5944.0
2019-03-05 08:00:00	MSFT	Stock	112.06	112.16	111.95	112.1	9181.0
2019-03-05 08:30:00	MSFT	Stock	112.1	112.29	112.1	112.15	17585.0
2019-03-05 09:00:00	MSFT	Stock	112.1	112.26	112.026	112.25	3902.0
2019-03-05 09:30:00	MSFT	Stock	112.25	112.39	111.254	111.5	1994518.0
2019-03-05 10:00:00	MSFT	Stock	111.5	111.87	111.23	111.409	1319116.0
2019-03-05 10:30:00	MSFT	Stock	111.41	111.87	111.41	111.63	894252.0
2019-03-05 11:00:00	MSFT	Stock	111.62	111.75	111.455	111.67	776538.0
2019-03-05 11:30:00	MSFT	Stock	111.68	111.91	111.5	111.68	767649.0
2019-03-05 12:00:00	MSFT	Stock	111.68	111.708	111.49	111.6	519251.0
2019-03-05 12:30:00	MSFT	Stock	111.605	111.74	111.57	111.65	546271.0
2019-03-05 13:00:00	MSFT	Stock	111.65	111.8	111.55	111.57	571364.0
2019-03-05 13:30:00	MSFT	Stock	111.56	111.64	111.45	111.575	608970.0
2019-03-05 14:00:00	MSFT	Stock	111.575	111.76	111.51	111.7	457298.0
2019-03-05 14:30:00	MSFT	Stock	111.7	111.87	111.61	111.86	492443.0

> showing 50 of 83,971 rows — these rows as CSV

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