PREVIEW / stock_30min / 2014-10-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-27.parquet
  size:    1.6 MB
  rows:    82,167
  symbols: 3,540

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-10-27 04:00:00	AAPL	Stock	26.315	26.4	26.315	26.3975	10800.0
2014-10-27 04:30:00	AAPL	Stock	26.34	26.3975	26.3125	26.3375	8000.0
2014-10-27 05:00:00	AAPL	Stock	26.3025	26.325	26.2975	26.3125	9600.0
2014-10-27 05:30:00	AAPL	Stock	26.275	26.275	26.2525	26.2525	1200.0
2014-10-27 06:00:00	AAPL	Stock	26.2625	26.2725	26.225	26.25	25348.0
2014-10-27 06:30:00	AAPL	Stock	26.23	26.2375	26.215	26.2375	16116.0
2014-10-27 07:00:00	AAPL	Stock	26.2375	26.2675	26.2375	26.245	47340.0
2014-10-27 07:30:00	AAPL	Stock	26.245	26.245	26.195	26.2125	102608.0
2014-10-27 08:00:00	AAPL	Stock	26.215	26.305	26.2	26.25	357996.0
2014-10-27 08:30:00	AAPL	Stock	26.245	26.25	26.19	26.2375	494280.0
2014-10-27 09:00:00	AAPL	Stock	26.2375	26.2475	26.165	26.21	764596.0
2014-10-27 09:30:00	AAPL	Stock	26.2125	26.3375	26.1775	26.2038	23394748.0
2014-10-27 10:00:00	AAPL	Stock	26.205	26.28	26.175	26.265	10463296.0
2014-10-27 10:30:00	AAPL	Stock	26.2675	26.37	26.2662	26.3475	13190372.0
2014-10-27 11:00:00	AAPL	Stock	26.3475	26.36	26.3025	26.3275	7295700.0
2014-10-27 11:30:00	AAPL	Stock	26.3275	26.3425	26.2525	26.29	7069496.0
2014-10-27 12:00:00	AAPL	Stock	26.29	26.3175	26.255	26.2725	7177396.0
2014-10-27 12:30:00	AAPL	Stock	26.275	26.3275	26.2625	26.2988	5254996.0
2014-10-27 13:00:00	AAPL	Stock	26.3	26.34	26.2988	26.3125	7359376.0
2014-10-27 13:30:00	AAPL	Stock	26.315	26.3192	26.2575	26.2688	6119168.0
2014-10-27 14:00:00	AAPL	Stock	26.2675	26.3075	26.2425	26.2925	8085800.0
2014-10-27 14:30:00	AAPL	Stock	26.29	26.3125	26.2475	26.2812	6420584.0
2014-10-27 15:00:00	AAPL	Stock	26.28	26.305	26.2675	26.2868	5731280.0
2014-10-27 15:30:00	AAPL	Stock	26.2875	26.3225	26.2575	26.275	10036168.0
2014-10-27 16:00:00	AAPL	Stock	26.2775	26.309	26.2198	26.27	4251344.0
2014-10-27 16:30:00	AAPL	Stock	26.2725	26.28	26.2525	26.2775	34652.0
2014-10-27 17:00:00	AAPL	Stock	26.2725	26.28	26.2675	26.2725	33888.0
2014-10-27 17:30:00	AAPL	Stock	26.28	26.28	26.2225	26.2475	159972.0
2014-10-27 18:00:00	AAPL	Stock	26.235	26.255	26.235	26.2475	28700.0
2014-10-27 18:30:00	AAPL	Stock	26.2475	26.2775	26.2475	26.25	115432.0
2014-10-27 19:00:00	AAPL	Stock	26.245	26.2725	26.245	26.2725	45288.0
2014-10-27 19:30:00	AAPL	Stock	26.2725	26.2725	26.26	26.2675	41112.0
2014-10-27 04:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	407.0
2014-10-27 04:30:00	MSFT	Stock	46.35	46.38	46.35	46.38	1000.0
2014-10-27 05:00:00	MSFT	Stock	46.25	46.38	46.24	46.38	1196.0
2014-10-27 06:30:00	MSFT	Stock	46.11	46.19	46.11	46.19	2100.0
2014-10-27 07:00:00	MSFT	Stock	46.15	46.2	46.15	46.2	600.0
2014-10-27 07:30:00	MSFT	Stock	46.1	46.1	46.1	46.1	1300.0
2014-10-27 08:00:00	MSFT	Stock	46.1	46.2	46.09	46.1	19572.0
2014-10-27 08:30:00	MSFT	Stock	46.1	46.1	45.97	45.97	5030.0
2014-10-27 09:00:00	MSFT	Stock	45.99	46.04	45.7	45.7	60031.0
2014-10-27 09:30:00	MSFT	Stock	45.7	46.1	45.7	45.86	3514725.0
2014-10-27 10:00:00	MSFT	Stock	45.86	45.915	45.755	45.81	1816144.0
2014-10-27 10:30:00	MSFT	Stock	45.81	45.91	45.78	45.865	1635558.0
2014-10-27 11:00:00	MSFT	Stock	45.865	45.89	45.8	45.85	1951831.0
2014-10-27 11:30:00	MSFT	Stock	45.84	45.87	45.8	45.85	1793451.0
2014-10-27 12:00:00	MSFT	Stock	45.85	45.88	45.8	45.875	914070.0
2014-10-27 12:30:00	MSFT	Stock	45.87	45.98	45.86	45.94	1151193.0
2014-10-27 13:00:00	MSFT	Stock	45.945	46.01	45.92	45.92	1885521.0
2014-10-27 13:30:00	MSFT	Stock	45.925	45.97	45.87	45.96	1440392.0

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

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