PREVIEW / stock_30min / 2015-07-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-16.parquet
  size:    1.6 MB
  rows:    83,197
  symbols: 3,502

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-16 04:00:00	AAPL	Stock	31.8625	31.9175	31.86	31.875	25168.0
2015-07-16 04:30:00	AAPL	Stock	31.875	31.9	31.875	31.9	4848.0
2015-07-16 05:00:00	AAPL	Stock	31.92	31.925	31.9	31.9	15396.0
2015-07-16 05:30:00	AAPL	Stock	31.9125	31.925	31.9	31.9125	10372.0
2015-07-16 06:00:00	AAPL	Stock	31.9125	31.925	31.9025	31.9125	12188.0
2015-07-16 06:30:00	AAPL	Stock	31.925	31.925	31.9	31.9	10636.0
2015-07-16 07:00:00	AAPL	Stock	31.9	31.925	31.875	31.8875	120112.0
2015-07-16 07:30:00	AAPL	Stock	31.8975	31.91	31.8825	31.895	64792.0
2015-07-16 08:00:00	AAPL	Stock	31.8875	31.96	31.8525	31.9475	458740.0
2015-07-16 08:30:00	AAPL	Stock	31.945	31.95	31.9075	31.9325	319904.0
2015-07-16 09:00:00	AAPL	Stock	31.9325	31.97	31.925	31.93	421796.0
2015-07-16 09:30:00	AAPL	Stock	31.93	32.0475	31.8375	31.9888	24565480.0
2015-07-16 10:00:00	AAPL	Stock	31.9875	32.0125	31.8762	31.8812	12359692.0
2015-07-16 10:30:00	AAPL	Stock	31.8812	31.975	31.85	31.94	7837548.0
2015-07-16 11:00:00	AAPL	Stock	31.94	31.96	31.9	31.9462	5451716.0
2015-07-16 11:30:00	AAPL	Stock	31.9475	32.03	31.9425	31.9775	7191392.0
2015-07-16 12:00:00	AAPL	Stock	31.975	32.0375	31.96	32.01	5477436.0
2015-07-16 12:30:00	AAPL	Stock	32.0085	32.0325	31.9925	32.01	12089948.0
2015-07-16 13:00:00	AAPL	Stock	32.0088	32.0175	31.945	31.9765	4748012.0
2015-07-16 13:30:00	AAPL	Stock	31.9775	32.01	31.975	31.995	4177108.0
2015-07-16 14:00:00	AAPL	Stock	31.995	32.055	31.9875	32.035	5415540.0
2015-07-16 14:30:00	AAPL	Stock	32.0328	32.115	32.0325	32.1075	9506156.0
2015-07-16 15:00:00	AAPL	Stock	32.1068	32.1425	32.0885	32.14	9721956.0
2015-07-16 15:30:00	AAPL	Stock	32.135	32.1425	32.0862	32.125	14883684.0
2015-07-16 16:00:00	AAPL	Stock	32.1225	32.195	32.105	32.17	7480588.0
2015-07-16 16:30:00	AAPL	Stock	32.1725	32.195	32.165	32.195	229176.0
2015-07-16 17:00:00	AAPL	Stock	32.1775	32.235	32.1775	32.225	205360.0
2015-07-16 17:30:00	AAPL	Stock	32.225	32.25	32.21	32.24	264716.0
2015-07-16 18:00:00	AAPL	Stock	32.23	32.2525	32.23	32.2525	68376.0
2015-07-16 18:30:00	AAPL	Stock	32.2525	32.3125	32.25	32.275	180220.0
2015-07-16 19:00:00	AAPL	Stock	32.275	32.31	32.2655	32.3075	74288.0
2015-07-16 19:30:00	AAPL	Stock	32.3075	32.31	32.275	32.3	168448.0
2015-07-16 06:30:00	MSFT	Stock	46.1	46.1	46.1	46.1	100.0
2015-07-16 07:00:00	MSFT	Stock	46.08	46.09	46.08	46.09	2860.0
2015-07-16 07:30:00	MSFT	Stock	46.12	46.13	46.1	46.1	2340.0
2015-07-16 08:00:00	MSFT	Stock	46.1	46.1	46.06	46.06	2167.0
2015-07-16 08:30:00	MSFT	Stock	46.05	46.1	46.01	46.08	2350.0
2015-07-16 09:00:00	MSFT	Stock	46.11	46.13	45.99	46.05	41926.0
2015-07-16 09:30:00	MSFT	Stock	46.04	46.24	45.965	46.11	2805451.0
2015-07-16 10:00:00	MSFT	Stock	46.11	46.36	45.995	46.275	2016066.0
2015-07-16 10:30:00	MSFT	Stock	46.28	46.5	46.21	46.45	2101938.0
2015-07-16 11:00:00	MSFT	Stock	46.45	46.47	46.31	46.395	1610451.0
2015-07-16 11:30:00	MSFT	Stock	46.39	46.54	46.39	46.44	1426972.0
2015-07-16 12:00:00	MSFT	Stock	46.45	46.48	46.38	46.39	1087318.0
2015-07-16 12:30:00	MSFT	Stock	46.39	46.41	46.28	46.285	1438067.0
2015-07-16 13:00:00	MSFT	Stock	46.284	46.36	46.28	46.33	1000363.0
2015-07-16 13:30:00	MSFT	Stock	46.33	46.41	46.31	46.34	1025996.0
2015-07-16 14:00:00	MSFT	Stock	46.35	46.485	46.33	46.44	1524042.0
2015-07-16 14:30:00	MSFT	Stock	46.44	46.54	46.424	46.51	1663120.0
2015-07-16 15:00:00	MSFT	Stock	46.515	46.64	46.5	46.63	1829523.0

> showing 50 of 83,197 rows — these rows as CSV

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