PREVIEW / stock_30min / 2018-10-29

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-29.parquet
  size:    1.7 MB
  rows:    84,905
  symbols: 2,752

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-10-29 04:00:00	AAPL	Stock	54.25	54.7175	54.25	54.645	5892.0
2018-10-29 04:30:00	AAPL	Stock	54.6625	54.6625	54.6625	54.6625	400.0
2018-10-29 05:00:00	AAPL	Stock	54.6375	54.685	54.5	54.685	17680.0
2018-10-29 05:30:00	AAPL	Stock	54.6825	54.995	54.6825	54.97	50776.0
2018-10-29 06:00:00	AAPL	Stock	54.925	54.925	54.795	54.8725	26684.0
2018-10-29 06:30:00	AAPL	Stock	54.91	55.025	54.895	55.025	65752.0
2018-10-29 07:00:00	AAPL	Stock	54.9625	55.125	54.83	55.095	265736.0
2018-10-29 07:30:00	AAPL	Stock	55.0925	55.0925	54.8275	54.86	202400.0
2018-10-29 08:00:00	AAPL	Stock	54.9125	55.1	54.8	54.875	335856.0
2018-10-29 08:30:00	AAPL	Stock	54.8375	54.935	54.8375	54.875	208296.0
2018-10-29 09:00:00	AAPL	Stock	54.885	54.885	54.6675	54.8025	586352.0
2018-10-29 09:30:00	AAPL	Stock	54.8138	54.9175	54.5025	54.7525	15763680.0
2018-10-29 10:00:00	AAPL	Stock	54.7575	54.9225	54.6725	54.735	9056388.0
2018-10-29 10:30:00	AAPL	Stock	54.735	54.77	54.53	54.61	7127272.0
2018-10-29 11:00:00	AAPL	Stock	54.62	54.7125	54.33	54.485	7570784.0
2018-10-29 11:30:00	AAPL	Stock	54.4825	54.5025	53.9625	54.005	7429200.0
2018-10-29 12:00:00	AAPL	Stock	54.005	54.275	53.69	53.845	9953524.0
2018-10-29 12:30:00	AAPL	Stock	53.8575	54.1825	53.77	53.865	6634484.0
2018-10-29 13:00:00	AAPL	Stock	53.8688	54.2175	53.8495	53.87	5628092.0
2018-10-29 13:30:00	AAPL	Stock	53.8648	54.3025	53.825	54.0782	5030264.0
2018-10-29 14:00:00	AAPL	Stock	54.075	54.075	53.3875	53.427	9583468.0
2018-10-29 14:30:00	AAPL	Stock	53.4225	53.7	53.3	53.515	9650788.0
2018-10-29 15:00:00	AAPL	Stock	53.5125	53.5325	52.8775	52.88	13998160.0
2018-10-29 15:30:00	AAPL	Stock	52.8775	53.2425	51.5225	53.1375	36851476.0
2018-10-29 16:00:00	AAPL	Stock	53.1225	53.1875	52.95	53.0375	12649684.0
2018-10-29 16:30:00	AAPL	Stock	53.06	53.125	52.9625	53.0	89288.0
2018-10-29 17:00:00	AAPL	Stock	52.975	53.06	52.875	52.9	211428.0
2018-10-29 17:30:00	AAPL	Stock	52.8825	53.06	52.8775	52.9	133916.0
2018-10-29 18:00:00	AAPL	Stock	52.9125	52.9125	52.8475	52.8625	112692.0
2018-10-29 18:30:00	AAPL	Stock	52.8475	52.9225	52.765	52.8375	73244.0
2018-10-29 19:00:00	AAPL	Stock	52.9075	53.0	52.895	52.9625	62372.0
2018-10-29 19:30:00	AAPL	Stock	53.0	53.0675	52.975	53.0675	169076.0
2018-10-29 04:00:00	MSFT	Stock	107.1	107.2	107.0	107.0	1644.0
2018-10-29 04:30:00	MSFT	Stock	107.4	107.5	107.09	107.5	320.0
2018-10-29 05:00:00	MSFT	Stock	107.2	107.5	107.0	107.5	4320.0
2018-10-29 05:30:00	MSFT	Stock	107.76	108.45	107.76	108.39	2563.0
2018-10-29 06:00:00	MSFT	Stock	108.2	108.2	108.2	108.2	200.0
2018-10-29 06:30:00	MSFT	Stock	108.3	108.3	108.3	108.3	500.0
2018-10-29 07:00:00	MSFT	Stock	108.1	108.5	108.04	108.29	28071.0
2018-10-29 07:30:00	MSFT	Stock	108.49	108.59	108.16	108.17	7266.0
2018-10-29 08:00:00	MSFT	Stock	108.25	108.59	108.0	108.5	30365.0
2018-10-29 08:30:00	MSFT	Stock	108.38	108.59	108.35	108.49	15522.0
2018-10-29 09:00:00	MSFT	Stock	108.56	108.56	107.85	107.91	43961.0
2018-10-29 09:30:00	MSFT	Stock	108.01	108.458	107.67	107.97	3661522.0
2018-10-29 10:00:00	MSFT	Stock	107.97	108.7	107.71	107.74	2653447.0
2018-10-29 10:30:00	MSFT	Stock	107.73	107.81	106.94	107.03	2479372.0
2018-10-29 11:00:00	MSFT	Stock	107.04	107.34	106.55	106.84	2436901.0
2018-10-29 11:30:00	MSFT	Stock	106.84	107.06	105.98	106.0	2212184.0
2018-10-29 12:00:00	MSFT	Stock	106.01	106.02	104.97	105.26	3499621.0
2018-10-29 12:30:00	MSFT	Stock	105.28	106.07	104.95	105.23	2480365.0

> showing 50 of 84,905 rows — these rows as CSV

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