PREVIEW / stock_30min / 2018-05-04

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-04.parquet
  size:    1.6 MB
  rows:    81,998
  symbols: 2,842

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-05-04 04:00:00	AAPL	Stock	44.375	44.4975	44.3675	44.375	22464.0
2018-05-04 04:30:00	AAPL	Stock	44.4125	44.545	44.37	44.4375	29216.0
2018-05-04 05:00:00	AAPL	Stock	44.4125	44.4375	44.4125	44.4375	9620.0
2018-05-04 05:30:00	AAPL	Stock	44.405	44.475	44.405	44.4525	15068.0
2018-05-04 06:00:00	AAPL	Stock	44.4625	44.595	44.4625	44.595	44840.0
2018-05-04 06:30:00	AAPL	Stock	44.595	44.7375	44.575	44.6775	120776.0
2018-05-04 07:00:00	AAPL	Stock	44.675	44.8175	44.6375	44.6525	401000.0
2018-05-04 07:30:00	AAPL	Stock	44.675	44.775	44.6625	44.7	188688.0
2018-05-04 08:00:00	AAPL	Stock	44.7025	44.8175	44.625	44.7	677756.0
2018-05-04 08:30:00	AAPL	Stock	44.7075	44.7875	44.625	44.7275	640160.0
2018-05-04 09:00:00	AAPL	Stock	44.74	44.8225	44.5375	44.5875	1025944.0
2018-05-04 09:30:00	AAPL	Stock	44.5625	45.3025	44.5425	45.3	36151212.0
2018-05-04 10:00:00	AAPL	Stock	45.2975	45.7475	45.1425	45.7433	24650280.0
2018-05-04 10:30:00	AAPL	Stock	45.745	45.9125	45.695	45.7175	25146212.0
2018-05-04 11:00:00	AAPL	Stock	45.7188	45.78	45.63	45.7375	13452712.0
2018-05-04 11:30:00	AAPL	Stock	45.74	45.805	45.6675	45.675	8642272.0
2018-05-04 12:00:00	AAPL	Stock	45.6725	45.8875	45.64	45.865	9929708.0
2018-05-04 12:30:00	AAPL	Stock	45.8625	45.9675	45.8325	45.84	9916772.0
2018-05-04 13:00:00	AAPL	Stock	45.845	45.9	45.6825	45.7625	8315112.0
2018-05-04 13:30:00	AAPL	Stock	45.7625	45.92	45.76	45.915	5955828.0
2018-05-04 14:00:00	AAPL	Stock	45.9125	45.92	45.82	45.9025	7358168.0
2018-05-04 14:30:00	AAPL	Stock	45.9025	46.0	45.885	45.925	9351920.0
2018-05-04 15:00:00	AAPL	Stock	45.925	45.995	45.92	45.966	8459924.0
2018-05-04 15:30:00	AAPL	Stock	45.9672	46.0625	45.885	45.9575	23268392.0
2018-05-04 16:00:00	AAPL	Stock	45.9675	45.9975	45.9475	45.975	9206672.0
2018-05-04 16:30:00	AAPL	Stock	45.975	45.9975	45.9575	45.97	327288.0
2018-05-04 17:00:00	AAPL	Stock	45.98	46.0225	45.97	45.97	217472.0
2018-05-04 17:30:00	AAPL	Stock	45.985	45.9925	45.9625	45.98	39960.0
2018-05-04 18:00:00	AAPL	Stock	45.985	46.0	45.98	46.0	36900.0
2018-05-04 18:30:00	AAPL	Stock	46.0	46.0125	45.9875	46.0125	39652.0
2018-05-04 19:00:00	AAPL	Stock	46.02	46.025	46.0075	46.025	33224.0
2018-05-04 19:30:00	AAPL	Stock	46.0125	46.025	46.005	46.025	73456.0
2018-05-04 05:30:00	MSFT	Stock	94.16	94.16	94.16	94.16	200.0
2018-05-04 07:00:00	MSFT	Stock	94.08	94.08	94.0	94.0	365.0
2018-05-04 07:30:00	MSFT	Stock	94.07	94.07	93.91	94.0	2071.0
2018-05-04 08:00:00	MSFT	Stock	93.96	94.26	93.67	93.82	6298.0
2018-05-04 08:30:00	MSFT	Stock	93.89	94.09	93.69	93.75	14209.0
2018-05-04 09:00:00	MSFT	Stock	93.75	93.93	93.35	93.36	24926.0
2018-05-04 09:30:00	MSFT	Stock	93.32	93.73	92.92	93.57	2305002.0
2018-05-04 10:00:00	MSFT	Stock	93.56	94.28	93.37	94.19	1461777.0
2018-05-04 10:30:00	MSFT	Stock	94.2	94.9	94.15	94.8	1630184.0
2018-05-04 11:00:00	MSFT	Stock	94.795	95.089	94.795	95.03	1566608.0
2018-05-04 11:30:00	MSFT	Stock	95.03	95.12	94.65	94.86	1041008.0
2018-05-04 12:00:00	MSFT	Stock	94.87	95.11	94.79	94.97	780842.0
2018-05-04 12:30:00	MSFT	Stock	94.975	95.12	94.83	94.9	760261.0
2018-05-04 13:00:00	MSFT	Stock	94.905	95.0	94.78	94.8	708892.0
2018-05-04 13:30:00	MSFT	Stock	94.8	95.09	94.78	95.02	845947.0
2018-05-04 14:00:00	MSFT	Stock	95.02	95.22	94.96	95.19	1140960.0
2018-05-04 14:30:00	MSFT	Stock	95.19	95.37	95.12	95.13	1160293.0
2018-05-04 15:00:00	MSFT	Stock	95.14	95.34	94.935	95.16	1169154.0

> showing 50 of 81,998 rows — these rows as CSV

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