PREVIEW / stock_30min / 2015-04-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-23.parquet
  size:    1.6 MB
  rows:    82,748
  symbols: 3,507

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-04-23 04:00:00	AAPL	Stock	32.0025	32.0025	31.9325	31.9675	18600.0
2015-04-23 04:30:00	AAPL	Stock	31.93	31.955	31.93	31.955	6124.0
2015-04-23 05:00:00	AAPL	Stock	31.975	32.0225	31.975	32.0125	2640.0
2015-04-23 05:30:00	AAPL	Stock	31.9825	31.9825	31.9825	31.9825	1600.0
2015-04-23 06:00:00	AAPL	Stock	32.08	32.0875	32.0375	32.0375	49708.0
2015-04-23 06:30:00	AAPL	Stock	32.025	32.05	32.01	32.05	19520.0
2015-04-23 07:00:00	AAPL	Stock	32.0475	32.0925	32.0475	32.0825	62500.0
2015-04-23 07:30:00	AAPL	Stock	32.07	32.0875	32.05	32.0675	42404.0
2015-04-23 08:00:00	AAPL	Stock	32.075	32.1	32.055	32.0875	207140.0
2015-04-23 08:30:00	AAPL	Stock	32.085	32.135	32.075	32.1347	332836.0
2015-04-23 09:00:00	AAPL	Stock	32.125	32.1375	32.07	32.07	689568.0
2015-04-23 09:30:00	AAPL	Stock	32.0725	32.34	32.035	32.3242	27950608.0
2015-04-23 10:00:00	AAPL	Stock	32.325	32.445	32.29	32.31	19590232.0
2015-04-23 10:30:00	AAPL	Stock	32.3075	32.37	32.215	32.2192	11627884.0
2015-04-23 11:00:00	AAPL	Stock	32.22	32.345	32.2175	32.34	8269084.0
2015-04-23 11:30:00	AAPL	Stock	32.3375	32.3975	32.265	32.3752	9331996.0
2015-04-23 12:00:00	AAPL	Stock	32.3745	32.4075	32.3375	32.4075	5575696.0
2015-04-23 12:30:00	AAPL	Stock	32.405	32.47	32.385	32.47	7772180.0
2015-04-23 13:00:00	AAPL	Stock	32.4675	32.4825	32.425	32.44	6172040.0
2015-04-23 13:30:00	AAPL	Stock	32.4375	32.465	32.385	32.4612	5940672.0
2015-04-23 14:00:00	AAPL	Stock	32.46	32.5175	32.445	32.4935	14257180.0
2015-04-23 14:30:00	AAPL	Stock	32.495	32.525	32.4575	32.5225	9365864.0
2015-04-23 15:00:00	AAPL	Stock	32.52	32.605	32.485	32.52	15384860.0
2015-04-23 15:30:00	AAPL	Stock	32.52	32.5438	32.4125	32.42	18381712.0
2015-04-23 16:00:00	AAPL	Stock	32.4175	32.4775	32.4125	32.4378	9147108.0
2015-04-23 16:30:00	AAPL	Stock	32.4425	32.5375	32.4425	32.5375	445620.0
2015-04-23 17:00:00	AAPL	Stock	32.535	32.5625	32.5025	32.5025	226888.0
2015-04-23 17:30:00	AAPL	Stock	32.5052	32.5375	32.5025	32.5175	49204.0
2015-04-23 18:00:00	AAPL	Stock	32.5125	32.535	32.5	32.505	165760.0
2015-04-23 18:30:00	AAPL	Stock	32.505	32.5175	32.5	32.5025	98976.0
2015-04-23 19:00:00	AAPL	Stock	32.505	32.5175	32.5025	32.5175	83888.0
2015-04-23 19:30:00	AAPL	Stock	32.525	32.5675	32.5125	32.52	235912.0
2015-04-23 05:30:00	MSFT	Stock	42.63	42.63	42.63	42.63	100.0
2015-04-23 06:30:00	MSFT	Stock	42.64	42.64	42.64	42.64	247.0
2015-04-23 07:00:00	MSFT	Stock	42.79	42.79	42.76	42.77	962.0
2015-04-23 07:30:00	MSFT	Stock	42.77	42.78	42.77	42.78	1500.0
2015-04-23 08:00:00	MSFT	Stock	42.9	42.9	42.76	42.771	4553.0
2015-04-23 08:30:00	MSFT	Stock	42.8	42.8	42.73	42.73	12093.0
2015-04-23 09:00:00	MSFT	Stock	42.75	42.89	42.71	42.85	36571.0
2015-04-23 09:30:00	MSFT	Stock	42.84	43.19	42.8	43.05	5586785.0
2015-04-23 10:00:00	MSFT	Stock	43.045	43.1	42.875	42.94	3602317.0
2015-04-23 10:30:00	MSFT	Stock	42.94	43.15	42.93	42.96	2488115.0
2015-04-23 11:00:00	MSFT	Stock	42.965	43.11	42.95	43.08	1686542.0
2015-04-23 11:30:00	MSFT	Stock	43.08	43.53	43.07	43.39	3031525.0
2015-04-23 12:00:00	MSFT	Stock	43.4	43.47	43.32	43.37	1383801.0
2015-04-23 12:30:00	MSFT	Stock	43.38	43.53	43.345	43.415	2007598.0
2015-04-23 13:00:00	MSFT	Stock	43.42	43.47	43.36	43.41	1028165.0
2015-04-23 13:30:00	MSFT	Stock	43.41	43.45	43.26	43.315	2847018.0
2015-04-23 14:00:00	MSFT	Stock	43.319	43.59	43.29	43.554	2448098.0
2015-04-23 14:30:00	MSFT	Stock	43.56	43.6	43.42	43.445	1685758.0

> showing 50 of 82,748 rows — these rows as CSV

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