PREVIEW / stock_30min / 2015-06-24

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-24.parquet
  size:    1.6 MB
  rows:    84,984
  symbols: 3,512

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
2015-06-24 04:00:00	AAPL	Stock	31.75	31.7825	31.7475	31.7825	2000.0
2015-06-24 04:30:00	AAPL	Stock	31.7875	31.7875	31.7875	31.7875	400.0
2015-06-24 05:30:00	AAPL	Stock	31.75	31.75	31.6975	31.6975	30296.0
2015-06-24 06:00:00	AAPL	Stock	31.6975	31.72	31.6725	31.7	21164.0
2015-06-24 06:30:00	AAPL	Stock	31.675	31.69	31.675	31.69	3908.0
2015-06-24 07:00:00	AAPL	Stock	31.6875	31.725	31.6575	31.71	16884.0
2015-06-24 07:30:00	AAPL	Stock	31.7175	31.725	31.69	31.7	28652.0
2015-06-24 08:00:00	AAPL	Stock	31.6975	31.78	31.675	31.77	291652.0
2015-06-24 08:30:00	AAPL	Stock	31.77	31.79	31.73	31.78	200608.0
2015-06-24 09:00:00	AAPL	Stock	31.7875	31.865	31.78	31.7925	634904.0
2015-06-24 09:30:00	AAPL	Stock	31.8025	32.14	31.78	32.115	33297708.0
2015-06-24 10:00:00	AAPL	Stock	32.1162	32.2025	32.1025	32.2025	18174540.0
2015-06-24 10:30:00	AAPL	Stock	32.2025	32.45	32.2	32.3475	31233996.0
2015-06-24 11:00:00	AAPL	Stock	32.345	32.3725	32.27	32.3612	15374800.0
2015-06-24 11:30:00	AAPL	Stock	32.36	32.3775	32.2975	32.31	13285732.0
2015-06-24 12:00:00	AAPL	Stock	32.3125	32.3125	32.1825	32.2325	12543032.0
2015-06-24 12:30:00	AAPL	Stock	32.235	32.3177	32.225	32.2475	10721332.0
2015-06-24 13:00:00	AAPL	Stock	32.2425	32.3525	32.2375	32.25	9370296.0
2015-06-24 13:30:00	AAPL	Stock	32.255	32.2725	32.1075	32.1778	13387312.0
2015-06-24 14:00:00	AAPL	Stock	32.1775	32.2	32.0675	32.075	8994980.0
2015-06-24 14:30:00	AAPL	Stock	32.0762	32.1575	32.055	32.1125	8927100.0
2015-06-24 15:00:00	AAPL	Stock	32.1123	32.1175	32.0612	32.1	8243368.0
2015-06-24 15:30:00	AAPL	Stock	32.1	32.1175	31.9925	32.04	17684796.0
2015-06-24 16:00:00	AAPL	Stock	32.0425	32.2905	32.0275	32.1025	7339120.0
2015-06-24 16:30:00	AAPL	Stock	32.1025	32.1175	32.0275	32.0875	78568.0
2015-06-24 17:00:00	AAPL	Stock	32.1	32.15	32.1	32.105	158908.0
2015-06-24 17:30:00	AAPL	Stock	32.1125	32.1125	32.105	32.1075	35296.0
2015-06-24 18:00:00	AAPL	Stock	32.105	32.1075	32.0275	32.0825	583276.0
2015-06-24 18:30:00	AAPL	Stock	32.08	32.11	32.08	32.1	46080.0
2015-06-24 19:00:00	AAPL	Stock	32.1	32.11	32.095	32.11	12680.0
2015-06-24 19:30:00	AAPL	Stock	32.105	32.1075	32.095	32.105	10332.0
2015-06-24 05:30:00	MSFT	Stock	45.8	45.8	45.8	45.8	300.0
2015-06-24 06:00:00	MSFT	Stock	45.78	45.78	45.78	45.78	200.0
2015-06-24 08:00:00	MSFT	Stock	45.75	45.75	45.75	45.75	1594.0
2015-06-24 08:30:00	MSFT	Stock	45.67	45.91	45.663	45.72	4675.0
2015-06-24 09:00:00	MSFT	Stock	45.75	45.75	45.6	45.67	14611.0
2015-06-24 09:30:00	MSFT	Stock	45.68	45.84	45.55	45.8	3541832.0
2015-06-24 10:00:00	MSFT	Stock	45.78	46.16	45.78	46.115	2188554.0
2015-06-24 10:30:00	MSFT	Stock	46.13	46.245	46.08	46.23	1916643.0
2015-06-24 11:00:00	MSFT	Stock	46.23	46.24	46.07	46.08	1284208.0
2015-06-24 11:30:00	MSFT	Stock	46.09	46.115	45.91	46.01	1200361.0
2015-06-24 12:00:00	MSFT	Stock	46.005	46.007	45.85	45.98	852662.0
2015-06-24 12:30:00	MSFT	Stock	45.97	46.025	45.9	46.02	837220.0
2015-06-24 13:00:00	MSFT	Stock	46.02	46.145	45.9	45.935	1049623.0
2015-06-24 13:30:00	MSFT	Stock	45.935	45.96	45.8	45.9	1075651.0
2015-06-24 14:00:00	MSFT	Stock	45.905	45.93	45.79	45.83	849488.0
2015-06-24 14:30:00	MSFT	Stock	45.835	45.95	45.79	45.88	984233.0
2015-06-24 15:00:00	MSFT	Stock	45.88	45.91	45.8	45.885	1134705.0
2015-06-24 15:30:00	MSFT	Stock	45.885	45.9	45.63	45.63	3937693.0
2015-06-24 16:00:00	MSFT	Stock	45.635	45.83	45.63	45.68	6833251.0

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

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