PREVIEW / stock_30min / 2015-07-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-23.parquet
  size:    1.6 MB
  rows:    81,884
  symbols: 3,484

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-07-23 04:00:00	AAPL	Stock	31.45	31.5375	31.225	31.4725	107460.0
2015-07-23 04:30:00	AAPL	Stock	31.4975	31.5375	31.4925	31.5375	27000.0
2015-07-23 05:00:00	AAPL	Stock	31.5275	31.5375	31.515	31.535	11360.0
2015-07-23 05:30:00	AAPL	Stock	31.5325	31.5375	31.51	31.5375	16968.0
2015-07-23 06:00:00	AAPL	Stock	31.53	31.53	31.465	31.49	48884.0
2015-07-23 06:30:00	AAPL	Stock	31.5	31.5275	31.49	31.495	24352.0
2015-07-23 07:00:00	AAPL	Stock	31.5125	31.525	31.4275	31.46	162584.0
2015-07-23 07:30:00	AAPL	Stock	31.4525	31.4725	31.415	31.4725	86056.0
2015-07-23 08:00:00	AAPL	Stock	31.4625	31.525	31.425	31.45	421232.0
2015-07-23 08:30:00	AAPL	Stock	31.4525	31.4525	31.42	31.42	181968.0
2015-07-23 09:00:00	AAPL	Stock	31.42	31.6175	31.4	31.545	1175744.0
2015-07-23 09:30:00	AAPL	Stock	31.55	31.6875	31.43	31.4925	35641536.0
2015-07-23 10:00:00	AAPL	Stock	31.4925	31.7725	31.48	31.73	25059720.0
2015-07-23 10:30:00	AAPL	Stock	31.7275	31.7448	31.6075	31.719	14926392.0
2015-07-23 11:00:00	AAPL	Stock	31.72	31.7375	31.615	31.6495	11687676.0
2015-07-23 11:30:00	AAPL	Stock	31.6488	31.675	31.585	31.5975	9172636.0
2015-07-23 12:00:00	AAPL	Stock	31.6	31.61	31.5375	31.5425	8872264.0
2015-07-23 12:30:00	AAPL	Stock	31.545	31.605	31.415	31.4925	10178868.0
2015-07-23 13:00:00	AAPL	Stock	31.492	31.5	31.375	31.4275	6791412.0
2015-07-23 13:30:00	AAPL	Stock	31.4275	31.49	31.3275	31.4702	9185824.0
2015-07-23 14:00:00	AAPL	Stock	31.4725	31.475	31.39	31.4475	5462544.0
2015-07-23 14:30:00	AAPL	Stock	31.4412	31.5	31.39	31.4075	6635920.0
2015-07-23 15:00:00	AAPL	Stock	31.405	31.4075	31.27	31.33	13261992.0
2015-07-23 15:30:00	AAPL	Stock	31.33	31.375	31.265	31.29	18152168.0
2015-07-23 16:00:00	AAPL	Stock	31.29	31.539	31.275	31.325	10289844.0
2015-07-23 16:30:00	AAPL	Stock	31.325	31.3725	31.29	31.365	298892.0
2015-07-23 17:00:00	AAPL	Stock	31.36	31.4075	31.345	31.3825	198208.0
2015-07-23 17:30:00	AAPL	Stock	31.3875	31.4125	31.3775	31.4	105236.0
2015-07-23 18:00:00	AAPL	Stock	31.3882	31.405	31.375	31.3975	100680.0
2015-07-23 18:30:00	AAPL	Stock	31.3975	31.4	31.3775	31.395	58484.0
2015-07-23 19:00:00	AAPL	Stock	31.4	31.4075	31.38	31.3975	124204.0
2015-07-23 19:30:00	AAPL	Stock	31.4	31.405	31.3625	31.3625	101820.0
2015-07-23 07:30:00	MSFT	Stock	45.64	45.7	45.64	45.64	1113.0
2015-07-23 08:00:00	MSFT	Stock	45.64	45.7	45.57	45.65	5460.0
2015-07-23 08:30:00	MSFT	Stock	45.65	45.65	45.58	45.6	14406.0
2015-07-23 09:00:00	MSFT	Stock	45.58	45.64	45.3	45.3	25023.0
2015-07-23 09:30:00	MSFT	Stock	45.27	45.68	45.1	45.665	3929358.0
2015-07-23 10:00:00	MSFT	Stock	45.665	46.04	45.58	46.03	3022108.0
2015-07-23 10:30:00	MSFT	Stock	46.03	46.12	45.95	46.065	2205253.0
2015-07-23 11:00:00	MSFT	Stock	46.07	46.23	46.06	46.14	2113628.0
2015-07-23 11:30:00	MSFT	Stock	46.14	46.17	45.99	46.021	2215468.0
2015-07-23 12:00:00	MSFT	Stock	46.02	46.06	45.88	45.905	1583009.0
2015-07-23 12:30:00	MSFT	Stock	45.9	46.04	45.823	45.94	1751666.0
2015-07-23 13:00:00	MSFT	Stock	45.94	46.0	45.9	45.975	1287102.0
2015-07-23 13:30:00	MSFT	Stock	45.97	46.19	45.93	46.17	1354239.0
2015-07-23 14:00:00	MSFT	Stock	46.16	46.165	45.98	46.024	852442.0
2015-07-23 14:30:00	MSFT	Stock	46.025	46.05	45.85	45.885	1781449.0
2015-07-23 15:00:00	MSFT	Stock	45.87	45.91	45.76	45.865	1886031.0
2015-07-23 15:30:00	MSFT	Stock	45.86	46.16	45.8	46.12	5385180.0
2015-07-23 16:00:00	MSFT	Stock	46.11	46.23	46.018	46.11	2395560.0

> showing 50 of 81,884 rows — these rows as CSV

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