PREVIEW / stock_30min / 2018-10-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-25.parquet
  size:    1.7 MB
  rows:    86,131
  symbols: 2,762

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-25 04:00:00	AAPL	Stock	54.625	54.69	54.5625	54.625	17120.0
2018-10-25 04:30:00	AAPL	Stock	54.625	54.6925	54.5	54.6725	8288.0
2018-10-25 05:00:00	AAPL	Stock	54.675	54.8225	54.6475	54.8225	8480.0
2018-10-25 05:30:00	AAPL	Stock	54.8125	55.0	54.8075	54.9875	30064.0
2018-10-25 06:00:00	AAPL	Stock	54.9875	54.9875	54.7125	54.7125	44336.0
2018-10-25 06:30:00	AAPL	Stock	54.75	54.8125	54.7025	54.8	15516.0
2018-10-25 07:00:00	AAPL	Stock	54.7325	54.805	54.5425	54.6625	155280.0
2018-10-25 07:30:00	AAPL	Stock	54.6625	54.7	54.515	54.555	148448.0
2018-10-25 08:00:00	AAPL	Stock	54.715	54.7775	54.5	54.6125	372480.0
2018-10-25 08:30:00	AAPL	Stock	54.5825	54.6475	54.395	54.395	318064.0
2018-10-25 09:00:00	AAPL	Stock	54.375	54.5375	54.325	54.4275	302112.0
2018-10-25 09:30:00	AAPL	Stock	54.425	54.81	54.1875	54.5825	15047336.0
2018-10-25 10:00:00	AAPL	Stock	54.59	54.9175	54.58	54.8588	7763056.0
2018-10-25 10:30:00	AAPL	Stock	54.8625	54.9925	54.77	54.785	6531568.0
2018-10-25 11:00:00	AAPL	Stock	54.79	55.08	54.5975	55.015	6595544.0
2018-10-25 11:30:00	AAPL	Stock	55.01	55.055	54.8525	54.8725	3915320.0
2018-10-25 12:00:00	AAPL	Stock	54.8678	54.8872	54.65	54.7425	3679860.0
2018-10-25 12:30:00	AAPL	Stock	54.738	54.9175	54.705	54.835	2980824.0
2018-10-25 13:00:00	AAPL	Stock	54.8388	54.89	54.545	54.79	3630664.0
2018-10-25 13:30:00	AAPL	Stock	54.791	54.9225	54.7375	54.8325	2972856.0
2018-10-25 14:00:00	AAPL	Stock	54.83	55.065	54.7375	55.04	4550844.0
2018-10-25 14:30:00	AAPL	Stock	55.0425	55.2425	55.01	55.134	5247072.0
2018-10-25 15:00:00	AAPL	Stock	55.135	55.3425	55.105	55.2825	4982508.0
2018-10-25 15:30:00	AAPL	Stock	55.275	55.345	54.9175	54.9625	11368204.0
2018-10-25 16:00:00	AAPL	Stock	54.95	54.95	54.255	54.575	12973788.0
2018-10-25 16:30:00	AAPL	Stock	54.575	54.95	54.25	54.3125	442040.0
2018-10-25 17:00:00	AAPL	Stock	54.3125	54.3725	53.8125	54.095	461892.0
2018-10-25 17:30:00	AAPL	Stock	54.0675	54.31	54.005	54.2	182768.0
2018-10-25 18:00:00	AAPL	Stock	54.185	54.225	53.9175	54.2	136204.0
2018-10-25 18:30:00	AAPL	Stock	54.2	55.1125	54.2	54.9575	1846276.0
2018-10-25 19:00:00	AAPL	Stock	54.845	55.1125	54.775	54.875	320644.0
2018-10-25 19:30:00	AAPL	Stock	54.8775	55.1975	54.75	54.75	364212.0
2018-10-25 04:00:00	MSFT	Stock	104.75	106.0	104.75	105.99	6480.0
2018-10-25 04:30:00	MSFT	Stock	105.98	106.34	105.96	106.34	7794.0
2018-10-25 05:00:00	MSFT	Stock	106.32	106.6	106.3	106.6	4820.0
2018-10-25 05:30:00	MSFT	Stock	106.46	107.36	106.28	107.3	11493.0
2018-10-25 06:00:00	MSFT	Stock	107.36	107.36	106.27	106.49	15879.0
2018-10-25 06:30:00	MSFT	Stock	106.35	106.35	105.56	105.92	22185.0
2018-10-25 07:00:00	MSFT	Stock	106.0	106.0	104.69	105.25	66552.0
2018-10-25 07:30:00	MSFT	Stock	105.25	105.45	104.94	105.15	41754.0
2018-10-25 08:00:00	MSFT	Stock	105.9	105.981	104.7	105.88	127341.0
2018-10-25 08:30:00	MSFT	Stock	105.94	106.22	105.0	105.32	218994.0
2018-10-25 09:00:00	MSFT	Stock	105.32	106.63	104.83	106.58	269694.0
2018-10-25 09:30:00	MSFT	Stock	106.58	108.97	106.15	108.43	13475086.0
2018-10-25 10:00:00	MSFT	Stock	108.41	109.27	107.2	108.36	6122229.0
2018-10-25 10:30:00	MSFT	Stock	108.35	108.91	108.1	108.125	3772034.0
2018-10-25 11:00:00	MSFT	Stock	108.12	108.72	107.72	108.21	2916413.0
2018-10-25 11:30:00	MSFT	Stock	108.21	108.37	107.55	107.72	2190906.0
2018-10-25 12:00:00	MSFT	Stock	107.73	107.77	106.94	107.46	2259083.0
2018-10-25 12:30:00	MSFT	Stock	107.46	108.1	107.39	107.7	1879340.0

> showing 50 of 86,131 rows — these rows as CSV

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