PREVIEW / stock_30min / 2014-02-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-02-13.parquet
  size:    1.6 MB
  rows:    82,518
  symbols: 3,541

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-02-13 04:00:00	AAPL	Stock	19.0893	19.0893	18.9546	19.0607	42000.0
2014-02-13 04:30:00	AAPL	Stock	19.0193	19.0193	19.0193	19.0193	5096.0
2014-02-13 05:00:00	AAPL	Stock	19.0371	19.0371	19.0371	19.0371	8400.0
2014-02-13 05:30:00	AAPL	Stock	19.0371	19.0371	19.0371	19.0371	2800.0
2014-02-13 06:00:00	AAPL	Stock	19.0357	19.0371	19.0357	19.0371	12936.0
2014-02-13 06:30:00	AAPL	Stock	19.0375	19.0375	19.0371	19.0371	14336.0
2014-02-13 07:00:00	AAPL	Stock	19.0464	19.0889	19.0357	19.0625	136584.0
2014-02-13 07:30:00	AAPL	Stock	19.0536	19.0711	19.0357	19.0446	181160.0
2014-02-13 08:00:00	AAPL	Stock	19.0446	19.0625	19.0011	19.0357	583240.0
2014-02-13 08:30:00	AAPL	Stock	19.0296	19.0679	19.0089	19.0636	808612.0
2014-02-13 09:00:00	AAPL	Stock	19.0561	19.1071	19.05	19.0979	486360.0
2014-02-13 09:30:00	AAPL	Stock	19.0879	19.2554	19.0786	19.2082	44669660.0
2014-02-13 10:00:00	AAPL	Stock	19.2082	19.3014	19.1857	19.2893	28634032.0
2014-02-13 10:30:00	AAPL	Stock	19.2876	19.3771	19.2804	19.375	22953672.0
2014-02-13 11:00:00	AAPL	Stock	19.3761	19.3818	19.3193	19.3498	16803276.0
2014-02-13 11:30:00	AAPL	Stock	19.3511	19.3698	19.3364	19.35	11572596.0
2014-02-13 12:00:00	AAPL	Stock	19.3525	19.3911	19.3414	19.383	10805872.0
2014-02-13 12:30:00	AAPL	Stock	19.3829	19.4018	19.3754	19.3961	10758132.0
2014-02-13 13:00:00	AAPL	Stock	19.3946	19.4175	19.3864	19.4014	14240632.0
2014-02-13 13:30:00	AAPL	Stock	19.4018	19.455	19.3975	19.45	15775872.0
2014-02-13 14:00:00	AAPL	Stock	19.4516	19.4589	19.395	19.4102	15980216.0
2014-02-13 14:30:00	AAPL	Stock	19.4111	19.4257	19.37	19.4143	13447308.0
2014-02-13 15:00:00	AAPL	Stock	19.4143	19.4225	19.3757	19.3854	10519964.0
2014-02-13 15:30:00	AAPL	Stock	19.3854	19.4436	19.385	19.4436	25071228.0
2014-02-13 16:00:00	AAPL	Stock	19.4432	19.4478	19.3156	19.4307	11053868.0
2014-02-13 16:30:00	AAPL	Stock	19.4371	19.4439	19.4293	19.4307	232624.0
2014-02-13 17:00:00	AAPL	Stock	19.4357	19.4393	19.4304	19.4389	96040.0
2014-02-13 17:30:00	AAPL	Stock	19.4429	19.4518	19.4411	19.4518	221088.0
2014-02-13 18:00:00	AAPL	Stock	19.4339	19.4446	19.4254	19.4446	106008.0
2014-02-13 18:30:00	AAPL	Stock	19.4396	19.4439	19.4321	19.4439	82656.0
2014-02-13 19:00:00	AAPL	Stock	19.4446	19.4446	19.4446	19.4446	41748.0
2014-02-13 19:30:00	AAPL	Stock	19.4311	19.4446	19.4286	19.4286	134400.0
2014-02-13 06:00:00	MSFT	Stock	37.38	37.38	37.38	37.38	569.0
2014-02-13 08:00:00	MSFT	Stock	37.42	37.42	37.31	37.31	3920.0
2014-02-13 08:30:00	MSFT	Stock	37.24	37.24	37.23	37.24	1038.0
2014-02-13 09:00:00	MSFT	Stock	37.29	37.29	37.24	37.24	1136.0
2014-02-13 09:30:00	MSFT	Stock	37.33	37.85	37.33	37.67	4514547.0
2014-02-13 10:00:00	MSFT	Stock	37.673	37.75	37.64	37.735	2722060.0
2014-02-13 10:30:00	MSFT	Stock	37.73	37.84	37.7	37.79	2501317.0
2014-02-13 11:00:00	MSFT	Stock	37.797	37.86	37.72	37.75	2366154.0
2014-02-13 11:30:00	MSFT	Stock	37.76	37.77	37.69	37.72	1342838.0
2014-02-13 12:00:00	MSFT	Stock	37.72	37.74	37.69	37.715	1023649.0
2014-02-13 12:30:00	MSFT	Stock	37.715	37.74	37.705	37.715	1198337.0
2014-02-13 13:00:00	MSFT	Stock	37.715	37.73	37.7	37.7	1175203.0
2014-02-13 13:30:00	MSFT	Stock	37.71	37.73	37.69	37.72	1679349.0
2014-02-13 14:00:00	MSFT	Stock	37.73	37.76	37.65	37.703	2449357.0
2014-02-13 14:30:00	MSFT	Stock	37.71	37.72	37.68	37.7	2069750.0
2014-02-13 15:00:00	MSFT	Stock	37.69	37.715	37.62	37.681	2501965.0
2014-02-13 15:30:00	MSFT	Stock	37.69	37.69	37.55	37.6	6693793.0
2014-02-13 16:00:00	MSFT	Stock	37.61	37.75	37.53	37.75	4273821.0

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

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