PREVIEW / stock_30min / 2015-07-21

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-21.parquet
  size:    1.6 MB
  rows:    82,316
  symbols: 3,470

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-21 04:00:00	AAPL	Stock	33.1875	33.25	33.1825	33.215	16800.0
2015-07-21 04:30:00	AAPL	Stock	33.215	33.2475	33.215	33.2475	8800.0
2015-07-21 05:00:00	AAPL	Stock	33.24	33.24	33.1975	33.225	20496.0
2015-07-21 05:30:00	AAPL	Stock	33.2125	33.22	33.2	33.2175	18236.0
2015-07-21 06:00:00	AAPL	Stock	33.2075	33.25	33.2075	33.25	62856.0
2015-07-21 06:30:00	AAPL	Stock	33.25	33.25	33.205	33.215	124804.0
2015-07-21 07:00:00	AAPL	Stock	33.21	33.32	33.21	33.2625	365028.0
2015-07-21 07:30:00	AAPL	Stock	33.2675	33.2875	33.21	33.2625	308276.0
2015-07-21 08:00:00	AAPL	Stock	33.26	33.3175	33.2175	33.2343	1081496.0
2015-07-21 08:30:00	AAPL	Stock	33.235	33.2625	33.175	33.2	575828.0
2015-07-21 09:00:00	AAPL	Stock	33.2025	33.2442	33.18	33.2075	605564.0
2015-07-21 09:30:00	AAPL	Stock	33.2125	33.23	32.7025	32.9275	40666688.0
2015-07-21 10:00:00	AAPL	Stock	32.925	32.95	32.7525	32.7652	17933840.0
2015-07-21 10:30:00	AAPL	Stock	32.765	32.8	32.6075	32.6425	18679032.0
2015-07-21 11:00:00	AAPL	Stock	32.645	32.73	32.58	32.7262	14416944.0
2015-07-21 11:30:00	AAPL	Stock	32.7262	32.8	32.7025	32.7725	10648396.0
2015-07-21 12:00:00	AAPL	Stock	32.7745	32.91	32.7712	32.8988	9841916.0
2015-07-21 12:30:00	AAPL	Stock	32.8988	32.91	32.8025	32.8175	7393304.0
2015-07-21 13:00:00	AAPL	Stock	32.815	32.86	32.72	32.8165	7919924.0
2015-07-21 13:30:00	AAPL	Stock	32.8175	32.83	32.7463	32.8125	6100124.0
2015-07-21 14:00:00	AAPL	Stock	32.8112	32.815	32.665	32.7925	12114236.0
2015-07-21 14:30:00	AAPL	Stock	32.7912	32.7975	32.7	32.765	10825976.0
2015-07-21 15:00:00	AAPL	Stock	32.765	32.8025	32.6875	32.6888	14110408.0
2015-07-21 15:30:00	AAPL	Stock	32.6888	32.7675	32.635	32.6675	27309228.0
2015-07-21 16:00:00	AAPL	Stock	32.6875	33.0875	32.625	32.8125	11743840.0
2015-07-21 16:30:00	AAPL	Stock	32.8	32.815	29.8	30.4125	44396408.0
2015-07-21 17:00:00	AAPL	Stock	30.4125	30.6675	30.125	30.2725	12219684.0
2015-07-21 17:30:00	AAPL	Stock	30.25	30.5625	30.2	30.5	4242748.0
2015-07-21 18:00:00	AAPL	Stock	30.505	30.6675	30.4125	30.5775	2959800.0
2015-07-21 18:30:00	AAPL	Stock	30.5775	30.6425	30.49	30.505	1323396.0
2015-07-21 19:00:00	AAPL	Stock	30.51	30.52	30.4575	30.475	818104.0
2015-07-21 19:30:00	AAPL	Stock	30.475	30.495	30.4125	30.45	1124652.0
2015-07-21 04:00:00	MSFT	Stock	46.92	46.92	46.92	46.92	176.0
2015-07-21 05:30:00	MSFT	Stock	46.92	46.92	46.92	46.92	200.0
2015-07-21 06:00:00	MSFT	Stock	46.92	46.94	46.92	46.94	340.0
2015-07-21 06:30:00	MSFT	Stock	46.99	46.99	46.99	46.99	200.0
2015-07-21 07:00:00	MSFT	Stock	46.93	47.0	46.92	46.98	900.0
2015-07-21 07:30:00	MSFT	Stock	46.92	46.92	46.89	46.89	3100.0
2015-07-21 08:00:00	MSFT	Stock	46.89	46.98	46.85	46.86	31723.0
2015-07-21 08:30:00	MSFT	Stock	46.87	46.88	46.85	46.85	13139.0
2015-07-21 09:00:00	MSFT	Stock	46.85	46.92	46.75	46.92	16436.0
2015-07-21 09:30:00	MSFT	Stock	46.79	46.92	46.48	46.915	4139422.0
2015-07-21 10:00:00	MSFT	Stock	46.915	47.0	46.8	46.835	2528673.0
2015-07-21 10:30:00	MSFT	Stock	46.84	46.935	46.73	46.915	2548539.0
2015-07-21 11:00:00	MSFT	Stock	46.91	47.08	46.76	47.071	2918678.0
2015-07-21 11:30:00	MSFT	Stock	47.07	47.077	46.905	46.98	1857318.0
2015-07-21 12:00:00	MSFT	Stock	46.977	46.989	46.72	46.79	1946194.0
2015-07-21 12:30:00	MSFT	Stock	46.79	46.81	46.72	46.8	1872409.0
2015-07-21 13:00:00	MSFT	Stock	46.8	46.8	46.61	46.66	1996075.0
2015-07-21 13:30:00	MSFT	Stock	46.66	46.67	46.57	46.64	1346332.0

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

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