PREVIEW / stock_30min / 2011-10-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-26.parquet
  size:    1.4 MB
  rows:    74,678
  symbols: 3,493

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
2011-10-26 04:00:00	AAPL	Stock	14.2336	14.3214	14.2336	14.2857	35084.0
2011-10-26 04:30:00	AAPL	Stock	14.2693	14.2718	14.2643	14.2643	8400.0
2011-10-26 05:00:00	AAPL	Stock	14.2661	14.2661	14.25	14.25	11200.0
2011-10-26 05:30:00	AAPL	Stock	14.25	14.25	14.25	14.25	2800.0
2011-10-26 06:30:00	AAPL	Stock	14.2786	14.2786	14.2786	14.2786	2800.0
2011-10-26 07:00:00	AAPL	Stock	14.2854	14.2996	14.2639	14.2639	177716.0
2011-10-26 07:30:00	AAPL	Stock	14.2782	14.2875	14.2646	14.2786	369572.0
2011-10-26 08:00:00	AAPL	Stock	14.2746	14.3368	14.2579	14.3182	1657936.0
2011-10-26 08:30:00	AAPL	Stock	14.3164	14.3318	14.2886	14.3186	1427104.0
2011-10-26 09:00:00	AAPL	Stock	14.3229	14.3786	14.3179	14.3564	2266012.0
2011-10-26 09:30:00	AAPL	Stock	14.3557	14.3768	14.2786	14.3104	51438296.0
2011-10-26 10:00:00	AAPL	Stock	14.3143	14.3175	14.1846	14.2175	36554924.0
2011-10-26 10:30:00	AAPL	Stock	14.215	14.2264	14.0411	14.0841	44201192.0
2011-10-26 11:00:00	AAPL	Stock	14.085	14.1218	14.0639	14.1096	27083588.0
2011-10-26 11:30:00	AAPL	Stock	14.1057	14.2143	14.1018	14.1789	28384692.0
2011-10-26 12:00:00	AAPL	Stock	14.1821	14.2082	14.1439	14.1571	15472828.0
2011-10-26 12:30:00	AAPL	Stock	14.1547	14.1704	14.1096	14.12	14022568.0
2011-10-26 13:00:00	AAPL	Stock	14.1204	14.1496	14.0768	14.1489	17759364.0
2011-10-26 13:30:00	AAPL	Stock	14.1504	14.2589	14.1475	14.2496	37478364.0
2011-10-26 14:00:00	AAPL	Stock	14.249	14.3046	14.2361	14.2518	32968992.0
2011-10-26 14:30:00	AAPL	Stock	14.2525	14.3093	14.2361	14.2589	25401572.0
2011-10-26 15:00:00	AAPL	Stock	14.2582	14.3286	14.25	14.3261	28795536.0
2011-10-26 15:30:00	AAPL	Stock	14.3243	14.3425	14.2739	14.2971	51328284.0
2011-10-26 16:00:00	AAPL	Stock	14.3104	14.3154	14.2326	14.3104	34619088.0
2011-10-26 16:30:00	AAPL	Stock	14.3043	14.3282	14.3043	14.3057	446320.0
2011-10-26 17:00:00	AAPL	Stock	14.3254	14.3432	14.3214	14.3361	201964.0
2011-10-26 17:30:00	AAPL	Stock	14.3393	14.3429	14.3071	14.3214	187068.0
2011-10-26 18:00:00	AAPL	Stock	14.3214	14.3221	14.3071	14.3207	69440.0
2011-10-26 18:30:00	AAPL	Stock	14.3125	14.3168	14.3071	14.3168	117768.0
2011-10-26 19:00:00	AAPL	Stock	14.3168	14.3421	14.3168	14.3368	188160.0
2011-10-26 19:30:00	AAPL	Stock	14.3411	14.3429	14.3304	14.3393	187432.0
2011-10-26 07:30:00	MSFT	Stock	27.0	27.0	26.96	26.96	4600.0
2011-10-26 08:00:00	MSFT	Stock	26.96	26.96	26.92	26.96	9000.0
2011-10-26 08:30:00	MSFT	Stock	26.96	27.0	26.95	26.99	14093.0
2011-10-26 09:00:00	MSFT	Stock	26.95	27.06	26.95	27.03	41533.0
2011-10-26 09:30:00	MSFT	Stock	27.03	27.06	26.84	26.94	5336738.0
2011-10-26 10:00:00	MSFT	Stock	26.946	26.95	26.605	26.69	5543434.0
2011-10-26 10:30:00	MSFT	Stock	26.685	26.7	26.1	26.155	6527130.0
2011-10-26 11:00:00	MSFT	Stock	26.155	26.29	26.1	26.16	5679135.0
2011-10-26 11:30:00	MSFT	Stock	26.16	26.5	26.152	26.33	3226394.0
2011-10-26 12:00:00	MSFT	Stock	26.338	26.43	26.32	26.37	2739590.0
2011-10-26 12:30:00	MSFT	Stock	26.37	26.38	26.285	26.294	2593793.0
2011-10-26 13:00:00	MSFT	Stock	26.29	26.38	26.25	26.356	1794818.0
2011-10-26 13:30:00	MSFT	Stock	26.36	26.63	26.355	26.6	4469277.0
2011-10-26 14:00:00	MSFT	Stock	26.595	26.66	26.535	26.55	3928855.0
2011-10-26 14:30:00	MSFT	Stock	26.55	26.66	26.421	26.46	3235659.0
2011-10-26 15:00:00	MSFT	Stock	26.46	26.64	26.45	26.621	3839877.0
2011-10-26 15:30:00	MSFT	Stock	26.625	26.7	26.5	26.59	7894325.0
2011-10-26 16:00:00	MSFT	Stock	26.59	26.7	26.518	26.59	5281330.0
2011-10-26 16:30:00	MSFT	Stock	26.634	26.65	26.634	26.65	29800.0

> showing 50 of 74,678 rows — these rows as CSV

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