PREVIEW / stock_30min / 2018-06-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-25.parquet
  size:    1.7 MB
  rows:    85,507
  symbols: 2,815

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-25 04:00:00	AAPL	Stock	46.125	46.125	45.9225	45.9275	10420.0
2018-06-25 04:30:00	AAPL	Stock	45.8775	45.8775	45.8775	45.8775	1616.0
2018-06-25 05:00:00	AAPL	Stock	45.8	45.8875	45.675	45.6825	24560.0
2018-06-25 05:30:00	AAPL	Stock	45.72	45.72	45.7125	45.7125	1800.0
2018-06-25 06:00:00	AAPL	Stock	45.75	45.75	45.7	45.7	12076.0
2018-06-25 06:30:00	AAPL	Stock	45.7275	45.775	45.6875	45.75	36536.0
2018-06-25 07:00:00	AAPL	Stock	45.75	45.8475	45.6775	45.765	175312.0
2018-06-25 07:30:00	AAPL	Stock	45.775	45.84	45.76	45.83	57472.0
2018-06-25 08:00:00	AAPL	Stock	45.7025	45.9	45.7	45.89	234524.0
2018-06-25 08:30:00	AAPL	Stock	45.9075	45.9125	45.795	45.8075	222868.0
2018-06-25 09:00:00	AAPL	Stock	45.8025	45.9	45.78	45.85	124556.0
2018-06-25 09:30:00	AAPL	Stock	45.85	46.23	45.745	45.835	13225368.0
2018-06-25 10:00:00	AAPL	Stock	45.825	45.995	45.7825	45.935	7759248.0
2018-06-25 10:30:00	AAPL	Stock	45.9325	46.025	45.795	45.84	6277580.0
2018-06-25 11:00:00	AAPL	Stock	45.84	45.8725	45.6125	45.67	6964392.0
2018-06-25 11:30:00	AAPL	Stock	45.6675	45.7025	45.545	45.58	6036756.0
2018-06-25 12:00:00	AAPL	Stock	45.5825	45.595	45.1875	45.3625	9963060.0
2018-06-25 12:30:00	AAPL	Stock	45.3675	45.3775	45.23	45.3025	4963440.0
2018-06-25 13:00:00	AAPL	Stock	45.3	45.35	45.21	45.32	5021188.0
2018-06-25 13:30:00	AAPL	Stock	45.3225	45.5675	45.3075	45.4425	5166476.0
2018-06-25 14:00:00	AAPL	Stock	45.445	45.4762	45.325	45.3538	3321748.0
2018-06-25 14:30:00	AAPL	Stock	45.355	45.36	45.1825	45.275	4888680.0
2018-06-25 15:00:00	AAPL	Stock	45.2775	45.42	45.23	45.3632	5470608.0
2018-06-25 15:30:00	AAPL	Stock	45.3675	45.71	45.315	45.545	15661708.0
2018-06-25 16:00:00	AAPL	Stock	45.5425	45.6075	45.4275	45.5425	10453168.0
2018-06-25 16:30:00	AAPL	Stock	45.5625	45.7005	45.525	45.5252	335416.0
2018-06-25 17:00:00	AAPL	Stock	45.5425	45.5425	45.525	45.535	3672.0
2018-06-25 17:30:00	AAPL	Stock	45.525	45.5375	45.505	45.5075	10680.0
2018-06-25 18:00:00	AAPL	Stock	45.5375	45.575	45.5375	45.575	11704.0
2018-06-25 18:30:00	AAPL	Stock	45.5625	45.5625	45.525	45.5625	10416.0
2018-06-25 19:00:00	AAPL	Stock	45.5625	45.5625	45.525	45.5425	10396.0
2018-06-25 19:30:00	AAPL	Stock	45.5375	45.55	45.515	45.5425	49976.0
2018-06-25 05:00:00	MSFT	Stock	99.8	99.8	99.7	99.7	2100.0
2018-06-25 05:30:00	MSFT	Stock	99.63	99.7	99.63	99.69	1269.0
2018-06-25 06:00:00	MSFT	Stock	99.7	100.2	99.7	100.0	10693.0
2018-06-25 06:30:00	MSFT	Stock	99.91	99.95	99.74	99.89	10825.0
2018-06-25 07:00:00	MSFT	Stock	99.86	100.0	99.86	99.91	7393.0
2018-06-25 07:30:00	MSFT	Stock	99.94	100.0	99.91	100.0	4180.0
2018-06-25 08:00:00	MSFT	Stock	99.99	100.29	99.91	100.29	32555.0
2018-06-25 08:30:00	MSFT	Stock	100.1	100.2	100.014	100.05	9847.0
2018-06-25 09:00:00	MSFT	Stock	100.01	100.22	99.99	99.99	52452.0
2018-06-25 09:30:00	MSFT	Stock	100.0	100.11	99.01	99.43	3497481.0
2018-06-25 10:00:00	MSFT	Stock	99.42	99.6	98.67	98.813	3086711.0
2018-06-25 10:30:00	MSFT	Stock	98.81	99.34	98.71	98.93	1956538.0
2018-06-25 11:00:00	MSFT	Stock	98.93	99.09	98.705	98.72	1543308.0
2018-06-25 11:30:00	MSFT	Stock	98.73	98.75	98.45	98.48	1727276.0
2018-06-25 12:00:00	MSFT	Stock	98.48	98.53	97.77	98.1	2743988.0
2018-06-25 12:30:00	MSFT	Stock	98.1	98.25	97.67	98.09	2267036.0
2018-06-25 13:00:00	MSFT	Stock	98.08	98.12	97.75	98.045	1376098.0
2018-06-25 13:30:00	MSFT	Stock	98.05	98.4	98.02	98.09	1392784.0

> showing 50 of 85,507 rows — these rows as CSV

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