PREVIEW / stock_30min / 2014-09-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-16.parquet
  size:    1.6 MB
  rows:    83,448
  symbols: 3,575

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
2014-09-16 04:00:00	AAPL	Stock	25.4625	25.485	25.4625	25.4725	6648.0
2014-09-16 04:30:00	AAPL	Stock	25.47	25.47	25.41	25.41	18736.0
2014-09-16 05:30:00	AAPL	Stock	25.4425	25.4725	25.4425	25.4725	1200.0
2014-09-16 06:00:00	AAPL	Stock	25.4725	25.49	25.4725	25.49	3888.0
2014-09-16 06:30:00	AAPL	Stock	25.4825	25.4825	25.3325	25.375	63644.0
2014-09-16 07:00:00	AAPL	Stock	25.38	25.425	25.37	25.42	60552.0
2014-09-16 07:30:00	AAPL	Stock	25.4225	25.425	25.18	25.2	752496.0
2014-09-16 08:00:00	AAPL	Stock	25.225	25.4612	24.9	25.0	3785276.0
2014-09-16 08:30:00	AAPL	Stock	24.995	25.145	24.975	25.05	1605600.0
2014-09-16 09:00:00	AAPL	Stock	25.05	25.05	24.9475	24.95	2443792.0
2014-09-16 09:30:00	AAPL	Stock	24.95	25.1325	24.7225	25.0225	55884208.0
2014-09-16 10:00:00	AAPL	Stock	25.0225	25.1	24.94	24.9928	26027140.0
2014-09-16 10:30:00	AAPL	Stock	24.9925	25.03	24.89	24.8975	20840360.0
2014-09-16 11:00:00	AAPL	Stock	24.895	24.925	24.8375	24.92	20603548.0
2014-09-16 11:30:00	AAPL	Stock	24.92	25.06	24.915	25.05	17280012.0
2014-09-16 12:00:00	AAPL	Stock	25.0475	25.075	25.0125	25.07	11947548.0
2014-09-16 12:30:00	AAPL	Stock	25.07	25.0775	25.0275	25.04	8352108.0
2014-09-16 13:00:00	AAPL	Stock	25.0415	25.105	25.04	25.0888	9525492.0
2014-09-16 13:30:00	AAPL	Stock	25.0882	25.1375	25.05	25.0675	11028904.0
2014-09-16 14:00:00	AAPL	Stock	25.0658	25.1125	25.065	25.1075	5909236.0
2014-09-16 14:30:00	AAPL	Stock	25.11	25.2475	25.0975	25.2175	13774588.0
2014-09-16 15:00:00	AAPL	Stock	25.22	25.29	25.2125	25.2125	16218728.0
2014-09-16 15:30:00	AAPL	Stock	25.2145	25.315	25.2025	25.21	22116852.0
2014-09-16 16:00:00	AAPL	Stock	25.2125	25.2525	24.9532	25.1775	4639320.0
2014-09-16 16:30:00	AAPL	Stock	25.1775	25.22	24.992	25.1725	534860.0
2014-09-16 17:00:00	AAPL	Stock	25.175	25.215	25.145	25.145	187648.0
2014-09-16 17:30:00	AAPL	Stock	25.1425	25.1525	25.0825	25.1	145136.0
2014-09-16 18:00:00	AAPL	Stock	25.125	25.215	25.095	25.1125	113016.0
2014-09-16 18:30:00	AAPL	Stock	25.1125	25.12	25.1	25.1	108116.0
2014-09-16 19:00:00	AAPL	Stock	25.095	25.115	25.095	25.105	47868.0
2014-09-16 19:30:00	AAPL	Stock	25.1025	25.12	25.095	25.11	79340.0
2014-09-16 07:00:00	MSFT	Stock	46.44	46.44	46.4	46.42	2600.0
2014-09-16 07:30:00	MSFT	Stock	46.41	46.45	46.41	46.45	9100.0
2014-09-16 08:00:00	MSFT	Stock	46.4	46.48	46.37	46.4	3300.0
2014-09-16 08:30:00	MSFT	Stock	46.38	46.38	46.38	46.38	850.0
2014-09-16 09:00:00	MSFT	Stock	46.4	46.44	46.36	46.36	46456.0
2014-09-16 09:30:00	MSFT	Stock	46.39	46.52	46.29	46.415	4552778.0
2014-09-16 10:00:00	MSFT	Stock	46.415	46.54	46.39	46.49	2815077.0
2014-09-16 10:30:00	MSFT	Stock	46.49	46.58	46.45	46.575	1676683.0
2014-09-16 11:00:00	MSFT	Stock	46.574	46.61	46.45	46.54	1894769.0
2014-09-16 11:30:00	MSFT	Stock	46.54	46.76	46.51	46.69	1662821.0
2014-09-16 12:00:00	MSFT	Stock	46.69	46.736	46.64	46.65	1335828.0
2014-09-16 12:30:00	MSFT	Stock	46.66	46.71	46.53	46.56	1271114.0
2014-09-16 13:00:00	MSFT	Stock	46.57	46.735	46.565	46.7	1170242.0
2014-09-16 13:30:00	MSFT	Stock	46.7	46.8	46.695	46.77	993957.0
2014-09-16 14:00:00	MSFT	Stock	46.77	46.83	46.72	46.8	987428.0
2014-09-16 14:30:00	MSFT	Stock	46.805	46.81	46.76	46.776	826059.0
2014-09-16 15:00:00	MSFT	Stock	46.77	46.85	46.75	46.82	1418639.0
2014-09-16 15:30:00	MSFT	Stock	46.81	46.83	46.75	46.75	3340898.0
2014-09-16 16:00:00	MSFT	Stock	46.76	46.825	46.607	46.76	2407186.0

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

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