PREVIEW / stock_30min / 2018-02-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-20.parquet
  size:    1.7 MB
  rows:    83,671
  symbols: 2,891

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-02-20 04:00:00	AAPL	Stock	42.775	42.9	42.7525	42.775	26824.0
2018-02-20 04:30:00	AAPL	Stock	42.775	42.775	42.7	42.7	15544.0
2018-02-20 05:00:00	AAPL	Stock	42.7	42.7	42.545	42.675	75184.0
2018-02-20 05:30:00	AAPL	Stock	42.68	42.695	42.6025	42.675	48280.0
2018-02-20 06:00:00	AAPL	Stock	42.725	42.7375	42.6475	42.665	73600.0
2018-02-20 06:30:00	AAPL	Stock	42.675	42.7475	42.655	42.7475	26404.0
2018-02-20 07:00:00	AAPL	Stock	42.7475	42.92	42.725	42.8125	201112.0
2018-02-20 07:30:00	AAPL	Stock	42.8275	42.935	42.8125	42.9225	148708.0
2018-02-20 08:00:00	AAPL	Stock	42.915	42.9375	42.735	42.9175	410316.0
2018-02-20 08:30:00	AAPL	Stock	42.925	43.0625	42.9225	42.955	546280.0
2018-02-20 09:00:00	AAPL	Stock	42.9875	43.025	42.9275	43.0025	345272.0
2018-02-20 09:30:00	AAPL	Stock	43.0175	43.26	42.88	43.215	18451580.0
2018-02-20 10:00:00	AAPL	Stock	43.2175	43.5	43.2125	43.3325	12246076.0
2018-02-20 10:30:00	AAPL	Stock	43.335	43.455	43.175	43.3575	8611116.0
2018-02-20 11:00:00	AAPL	Stock	43.36	43.525	43.337	43.51	7624644.0
2018-02-20 11:30:00	AAPL	Stock	43.5075	43.565	43.43	43.5138	5797652.0
2018-02-20 12:00:00	AAPL	Stock	43.5175	43.56	43.435	43.5025	4407668.0
2018-02-20 12:30:00	AAPL	Stock	43.5025	43.5302	43.42	43.4425	4601944.0
2018-02-20 13:00:00	AAPL	Stock	43.4425	43.4525	43.3325	43.395	4312304.0
2018-02-20 13:30:00	AAPL	Stock	43.395	43.5425	43.37	43.53	4810232.0
2018-02-20 14:00:00	AAPL	Stock	43.53	43.5375	43.305	43.31	6475328.0
2018-02-20 14:30:00	AAPL	Stock	43.31	43.3875	42.8675	43.1475	7121720.0
2018-02-20 15:00:00	AAPL	Stock	43.1525	43.195	42.855	42.9625	12044764.0
2018-02-20 15:30:00	AAPL	Stock	42.9625	43.0725	42.92	42.9625	13672920.0
2018-02-20 16:00:00	AAPL	Stock	42.9725	43.3478	42.925	42.95	11294420.0
2018-02-20 16:30:00	AAPL	Stock	42.9625	42.9625	42.925	42.935	129408.0
2018-02-20 17:00:00	AAPL	Stock	42.95	42.9725	42.95	42.9625	56976.0
2018-02-20 17:30:00	AAPL	Stock	42.9625	42.9825	42.9325	42.9325	109408.0
2018-02-20 18:00:00	AAPL	Stock	42.935	42.9475	42.9125	42.945	16560.0
2018-02-20 18:30:00	AAPL	Stock	42.945	43.0	42.945	42.9925	36036.0
2018-02-20 19:00:00	AAPL	Stock	42.97	43.0075	42.97	43.0075	25664.0
2018-02-20 19:30:00	AAPL	Stock	43.005	43.0625	43.005	43.0575	18920.0
2018-02-20 04:00:00	MSFT	Stock	92.0	92.0	91.9	91.9	1100.0
2018-02-20 04:30:00	MSFT	Stock	91.52	91.55	91.3	91.35	6144.0
2018-02-20 05:00:00	MSFT	Stock	91.35	91.35	91.35	91.35	500.0
2018-02-20 06:00:00	MSFT	Stock	91.45	91.5	91.45	91.5	2025.0
2018-02-20 06:30:00	MSFT	Stock	91.5	91.54	91.5	91.5	1280.0
2018-02-20 07:00:00	MSFT	Stock	91.67	91.67	91.5	91.5	3387.0
2018-02-20 07:30:00	MSFT	Stock	91.5	91.6	91.5	91.5	2985.0
2018-02-20 08:00:00	MSFT	Stock	91.5	91.565	91.42	91.5	7112.0
2018-02-20 08:30:00	MSFT	Stock	91.54	91.65	91.5	91.54	4822.0
2018-02-20 09:00:00	MSFT	Stock	91.59	91.68	91.28	91.4	47656.0
2018-02-20 09:30:00	MSFT	Stock	91.4	92.32	91.01	92.11	3162681.0
2018-02-20 10:00:00	MSFT	Stock	92.1	92.42	91.95	92.207	1952725.0
2018-02-20 10:30:00	MSFT	Stock	92.2	92.42	92.04	92.2	1332314.0
2018-02-20 11:00:00	MSFT	Stock	92.2	92.63	92.17	92.61	1486448.0
2018-02-20 11:30:00	MSFT	Stock	92.62	92.82	92.42	92.775	860770.0
2018-02-20 12:00:00	MSFT	Stock	92.77	92.896	92.73	92.789	729812.0
2018-02-20 12:30:00	MSFT	Stock	92.79	93.02	92.74	92.989	819846.0
2018-02-20 13:00:00	MSFT	Stock	92.99	92.993	92.657	92.76	802882.0

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

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