PREVIEW / stock_30min / 2018-06-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-08.parquet
  size:    1.7 MB
  rows:    83,290
  symbols: 2,811

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-06-08 04:00:00	AAPL	Stock	47.9375	47.9375	47.0475	47.3625	110044.0
2018-06-08 04:30:00	AAPL	Stock	47.35	47.4725	47.3025	47.3875	38108.0
2018-06-08 05:00:00	AAPL	Stock	47.3875	47.4125	47.3125	47.3175	19296.0
2018-06-08 05:30:00	AAPL	Stock	47.4175	47.4375	47.2375	47.2375	48068.0
2018-06-08 06:00:00	AAPL	Stock	47.31	47.5525	47.3	47.525	89628.0
2018-06-08 06:30:00	AAPL	Stock	47.525	47.525	47.3375	47.38	83524.0
2018-06-08 07:00:00	AAPL	Stock	47.415	47.8775	47.3875	47.85	527584.0
2018-06-08 07:30:00	AAPL	Stock	47.82	47.8375	47.7	47.7375	426240.0
2018-06-08 08:00:00	AAPL	Stock	47.755	47.8375	47.4	47.835	606416.0
2018-06-08 08:30:00	AAPL	Stock	47.835	47.865	47.6775	47.7	381784.0
2018-06-08 09:00:00	AAPL	Stock	47.6875	47.79	47.67	47.785	530684.0
2018-06-08 09:30:00	AAPL	Stock	47.78	47.8125	47.4425	47.7012	19781816.0
2018-06-08 10:00:00	AAPL	Stock	47.7	47.7025	47.55	47.595	8114124.0
2018-06-08 10:30:00	AAPL	Stock	47.5925	47.6612	47.465	47.6125	7560284.0
2018-06-08 11:00:00	AAPL	Stock	47.6075	47.7375	47.54	47.685	5792904.0
2018-06-08 11:30:00	AAPL	Stock	47.6875	47.71	47.5975	47.6335	3559264.0
2018-06-08 12:00:00	AAPL	Stock	47.6325	47.7425	47.6325	47.74	3395228.0
2018-06-08 12:30:00	AAPL	Stock	47.74	47.7975	47.675	47.7692	3983932.0
2018-06-08 13:00:00	AAPL	Stock	47.7675	47.8475	47.75	47.84	2864988.0
2018-06-08 13:30:00	AAPL	Stock	47.8388	47.855	47.7225	47.7825	4053752.0
2018-06-08 14:00:00	AAPL	Stock	47.785	47.8875	47.785	47.7875	3116268.0
2018-06-08 14:30:00	AAPL	Stock	47.7875	47.8725	47.7825	47.8475	2959620.0
2018-06-08 15:00:00	AAPL	Stock	47.8475	47.915	47.8432	47.889	3758372.0
2018-06-08 15:30:00	AAPL	Stock	47.89	48.0	47.865	47.87	10298412.0
2018-06-08 16:00:00	AAPL	Stock	47.925	47.985	47.8725	47.91	13901832.0
2018-06-08 16:30:00	AAPL	Stock	47.9225	47.94	47.91	47.925	51556.0
2018-06-08 17:00:00	AAPL	Stock	47.925	47.9432	47.925	47.925	27480.0
2018-06-08 17:30:00	AAPL	Stock	47.925	47.9725	47.925	47.95	32452.0
2018-06-08 18:00:00	AAPL	Stock	47.9725	47.9725	47.925	47.9625	231356.0
2018-06-08 18:30:00	AAPL	Stock	47.9625	47.9625	47.9525	47.9525	2820.0
2018-06-08 19:00:00	AAPL	Stock	47.9725	47.9825	47.9725	47.9825	9976.0
2018-06-08 19:30:00	AAPL	Stock	47.9825	48.0	47.9775	48.0	17432.0
2018-06-08 04:00:00	MSFT	Stock	100.5	100.5	100.06	100.06	1244.0
2018-06-08 04:30:00	MSFT	Stock	100.03	100.03	100.03	100.03	400.0
2018-06-08 05:30:00	MSFT	Stock	100.01	100.01	100.0	100.0	5266.0
2018-06-08 06:00:00	MSFT	Stock	100.0	100.0	100.0	100.0	150.0
2018-06-08 06:30:00	MSFT	Stock	99.98	100.08	99.98	100.07	930.0
2018-06-08 07:00:00	MSFT	Stock	100.14	100.4	100.0	100.4	8206.0
2018-06-08 07:30:00	MSFT	Stock	100.5	100.5	100.3	100.3	3290.0
2018-06-08 08:00:00	MSFT	Stock	100.14	100.56	100.01	100.38	9418.0
2018-06-08 08:30:00	MSFT	Stock	100.38	100.65	100.38	100.55	24806.0
2018-06-08 09:00:00	MSFT	Stock	100.55	101.01	100.5	101.0	36958.0
2018-06-08 09:30:00	MSFT	Stock	101.0	101.27	100.54	101.02	3011000.0
2018-06-08 10:00:00	MSFT	Stock	101.03	101.1	100.8	100.817	1257508.0
2018-06-08 10:30:00	MSFT	Stock	100.81	101.17	100.63	101.155	1339255.0
2018-06-08 11:00:00	MSFT	Stock	101.15	101.63	101.08	101.45	1038520.0
2018-06-08 11:30:00	MSFT	Stock	101.46	101.465	101.15	101.25	975153.0
2018-06-08 12:00:00	MSFT	Stock	101.255	101.46	101.17	101.46	689907.0
2018-06-08 12:30:00	MSFT	Stock	101.45	101.56	101.39	101.47	770838.0
2018-06-08 13:00:00	MSFT	Stock	101.465	101.51	101.38	101.405	538322.0

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

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