PREVIEW / stock_30min / 2013-08-01

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-01.parquet
  size:    1.6 MB
  rows:    81,053
  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
2013-08-01 04:00:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	2800.0
2013-08-01 05:00:00	AAPL	Stock	16.2196	16.2196	16.2196	16.2196	2800.0
2013-08-01 05:30:00	AAPL	Stock	16.25	16.25	16.25	16.25	2800.0
2013-08-01 06:30:00	AAPL	Stock	16.25	16.25	16.25	16.25	2800.0
2013-08-01 07:00:00	AAPL	Stock	16.25	16.3036	16.2411	16.2964	169456.0
2013-08-01 07:30:00	AAPL	Stock	16.3143	16.3607	16.2964	16.3207	292432.0
2013-08-01 08:00:00	AAPL	Stock	16.3214	16.3214	16.1429	16.2989	1182132.0
2013-08-01 08:30:00	AAPL	Stock	16.295	16.3036	16.2875	16.29	941444.0
2013-08-01 09:00:00	AAPL	Stock	16.2904	16.2946	16.2593	16.2593	678440.0
2013-08-01 09:30:00	AAPL	Stock	16.2769	16.3143	16.1879	16.2321	41842332.0
2013-08-01 10:00:00	AAPL	Stock	16.2321	16.3018	16.225	16.2764	25532752.0
2013-08-01 10:30:00	AAPL	Stock	16.2775	16.2871	16.2321	16.2821	16665460.0
2013-08-01 11:00:00	AAPL	Stock	16.2789	16.2943	16.2432	16.2829	16099300.0
2013-08-01 11:30:00	AAPL	Stock	16.2854	16.2964	16.2611	16.2762	6972616.0
2013-08-01 12:00:00	AAPL	Stock	16.2761	16.2835	16.2571	16.2704	6666128.0
2013-08-01 12:30:00	AAPL	Stock	16.2704	16.28	16.2439	16.2511	7152936.0
2013-08-01 13:00:00	AAPL	Stock	16.2507	16.2768	16.2418	16.2532	5096448.0
2013-08-01 13:30:00	AAPL	Stock	16.254	16.2639	16.2418	16.2636	5249804.0
2013-08-01 14:00:00	AAPL	Stock	16.2582	16.2757	16.2543	16.2629	7950880.0
2013-08-01 14:30:00	AAPL	Stock	16.2632	16.2736	16.2518	16.2643	6247500.0
2013-08-01 15:00:00	AAPL	Stock	16.2646	16.2729	16.2275	16.255	12000996.0
2013-08-01 15:30:00	AAPL	Stock	16.2493	16.3132	16.2421	16.3125	32935616.0
2013-08-01 16:00:00	AAPL	Stock	16.3129	16.3214	16.2666	16.3207	8328152.0
2013-08-01 16:30:00	AAPL	Stock	16.3207	16.3329	16.31	16.3321	994812.0
2013-08-01 17:00:00	AAPL	Stock	16.3389	16.3464	16.3129	16.3418	194992.0
2013-08-01 17:30:00	AAPL	Stock	16.3407	16.3429	16.3129	16.3396	297696.0
2013-08-01 18:00:00	AAPL	Stock	16.3404	16.3421	16.3346	16.3375	182308.0
2013-08-01 18:30:00	AAPL	Stock	16.3346	16.3446	16.3339	16.3411	77112.0
2013-08-01 19:00:00	AAPL	Stock	16.3339	16.3354	16.3286	16.3286	92344.0
2013-08-01 19:30:00	AAPL	Stock	16.3286	16.3421	16.3286	16.3421	54796.0
2013-08-01 06:00:00	MSFT	Stock	31.95	31.95	31.95	31.95	100.0
2013-08-01 06:30:00	MSFT	Stock	31.95	31.95	31.95	31.95	200.0
2013-08-01 07:00:00	MSFT	Stock	32.0	32.03	32.0	32.03	600.0
2013-08-01 07:30:00	MSFT	Stock	31.94	31.94	31.94	31.94	125.0
2013-08-01 08:00:00	MSFT	Stock	31.93	32.02	31.93	32.0	5769.0
2013-08-01 08:30:00	MSFT	Stock	32.0	32.02	31.95	32.01	9850.0
2013-08-01 09:00:00	MSFT	Stock	32.0	32.13	32.0	32.1	27264.0
2013-08-01 09:30:00	MSFT	Stock	32.06	32.09	31.84	31.91	3903254.0
2013-08-01 10:00:00	MSFT	Stock	31.91	32.01	31.91	31.95	2641842.0
2013-08-01 10:30:00	MSFT	Stock	31.945	31.96	31.75	31.75	2803391.0
2013-08-01 11:00:00	MSFT	Stock	31.755	31.84	31.7	31.79	2365971.0
2013-08-01 11:30:00	MSFT	Stock	31.795	31.82	31.74	31.79	3158063.0
2013-08-01 12:00:00	MSFT	Stock	31.785	31.8	31.69	31.724	1943949.0
2013-08-01 12:30:00	MSFT	Stock	31.726	31.75	31.68	31.69	1456146.0
2013-08-01 13:00:00	MSFT	Stock	31.69	31.73	31.6	31.645	2861176.0
2013-08-01 13:30:00	MSFT	Stock	31.64	31.67	31.6	31.67	2094291.0
2013-08-01 14:00:00	MSFT	Stock	31.66	31.73	31.66	31.673	2694731.0
2013-08-01 14:30:00	MSFT	Stock	31.68	31.7	31.65	31.68	1393675.0
2013-08-01 15:00:00	MSFT	Stock	31.67	31.7	31.6	31.63	3591733.0
2013-08-01 15:30:00	MSFT	Stock	31.635	31.79	31.63	31.68	7346678.0

> showing 50 of 81,053 rows — these rows as CSV

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