PREVIEW / stock_30min / 2014-05-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-05.parquet
  size:    1.5 MB
  rows:    81,923
  symbols: 3,547

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-05-05 04:30:00	AAPL	Stock	21.1096	21.1096	21.1096	21.1096	5600.0
2014-05-05 05:00:00	AAPL	Stock	21.0396	21.0396	21.0396	21.0396	2800.0
2014-05-05 05:30:00	AAPL	Stock	21.0286	21.0286	21.0286	21.0286	2800.0
2014-05-05 06:00:00	AAPL	Stock	21.0039	21.0039	21.0004	21.0004	5600.0
2014-05-05 06:30:00	AAPL	Stock	21.0314	21.0357	21.0314	21.0357	7000.0
2014-05-05 07:00:00	AAPL	Stock	21.0357	21.0536	21.0179	21.0471	52164.0
2014-05-05 07:30:00	AAPL	Stock	21.0471	21.0961	21.0471	21.0961	86156.0
2014-05-05 08:00:00	AAPL	Stock	21.0961	21.1143	21.0071	21.0964	482356.0
2014-05-05 08:30:00	AAPL	Stock	21.1025	21.105	21.0786	21.0839	188916.0
2014-05-05 09:00:00	AAPL	Stock	21.0804	21.0839	21.0618	21.0693	609840.0
2014-05-05 09:30:00	AAPL	Stock	21.0764	21.2471	21.0714	21.2471	35541940.0
2014-05-05 10:00:00	AAPL	Stock	21.2471	21.3514	21.2404	21.3143	29541848.0
2014-05-05 10:30:00	AAPL	Stock	21.3118	21.3821	21.2882	21.3614	16167928.0
2014-05-05 11:00:00	AAPL	Stock	21.3582	21.3618	21.2875	21.3339	11575620.0
2014-05-05 11:30:00	AAPL	Stock	21.3336	21.3477	21.2711	21.2846	10020276.0
2014-05-05 12:00:00	AAPL	Stock	21.2861	21.33	21.2746	21.3165	7649712.0
2014-05-05 12:30:00	AAPL	Stock	21.3164	21.3518	21.2946	21.3011	11785564.0
2014-05-05 13:00:00	AAPL	Stock	21.3011	21.3464	21.3011	21.34	5923176.0
2014-05-05 13:30:00	AAPL	Stock	21.3414	21.39	21.3225	21.3864	13108004.0
2014-05-05 14:00:00	AAPL	Stock	21.3864	21.4036	21.3679	21.3686	15993544.0
2014-05-05 14:30:00	AAPL	Stock	21.3704	21.4054	21.3614	21.3796	12354888.0
2014-05-05 15:00:00	AAPL	Stock	21.3782	21.4154	21.375	21.4154	13000596.0
2014-05-05 15:30:00	AAPL	Stock	21.4154	21.4643	21.3846	21.4618	33184816.0
2014-05-05 16:00:00	AAPL	Stock	21.4629	21.4804	21.3255	21.4679	5948124.0
2014-05-05 16:30:00	AAPL	Stock	21.4711	21.475	21.3326	21.475	513156.0
2014-05-05 17:00:00	AAPL	Stock	21.4732	21.5064	21.1124	21.5064	767508.0
2014-05-05 17:30:00	AAPL	Stock	21.5043	21.5075	21.4986	21.5075	166320.0
2014-05-05 18:00:00	AAPL	Stock	21.4629	21.5179	21.4629	21.5	250124.0
2014-05-05 18:30:00	AAPL	Stock	21.51	21.5107	21.5	21.5	58688.0
2014-05-05 19:00:00	AAPL	Stock	21.5007	21.5011	21.4964	21.5	23352.0
2014-05-05 19:30:00	AAPL	Stock	21.4961	21.5	21.4929	21.4946	188300.0
2014-05-05 06:30:00	MSFT	Stock	39.69	39.69	39.69	39.69	150.0
2014-05-05 07:00:00	MSFT	Stock	39.58	39.61	39.58	39.61	200.0
2014-05-05 07:30:00	MSFT	Stock	39.6	39.6	39.58	39.59	1215.0
2014-05-05 08:00:00	MSFT	Stock	39.68	39.68	39.6	39.62	3500.0
2014-05-05 08:30:00	MSFT	Stock	39.61	39.64	39.59	39.6	9330.0
2014-05-05 09:00:00	MSFT	Stock	39.6	39.63	39.51	39.51	36072.0
2014-05-05 09:30:00	MSFT	Stock	39.55	39.58	39.3	39.43	4138240.0
2014-05-05 10:00:00	MSFT	Stock	39.43	39.64	39.36	39.53	2019763.0
2014-05-05 10:30:00	MSFT	Stock	39.526	39.6	39.44	39.48	1698828.0
2014-05-05 11:00:00	MSFT	Stock	39.48	39.49	39.37	39.41	1154238.0
2014-05-05 11:30:00	MSFT	Stock	39.41	39.5	39.4	39.42	1001479.0
2014-05-05 12:00:00	MSFT	Stock	39.43	39.44	39.38	39.4	1149468.0
2014-05-05 12:30:00	MSFT	Stock	39.407	39.42	39.34	39.35	1285740.0
2014-05-05 13:00:00	MSFT	Stock	39.35	39.4	39.33	39.38	931639.0
2014-05-05 13:30:00	MSFT	Stock	39.38	39.42	39.37	39.4	861314.0
2014-05-05 14:00:00	MSFT	Stock	39.41	39.43	39.39	39.41	926855.0
2014-05-05 14:30:00	MSFT	Stock	39.404	39.47	39.38	39.43	1453067.0
2014-05-05 15:00:00	MSFT	Stock	39.43	39.46	39.4	39.446	940161.0
2014-05-05 15:30:00	MSFT	Stock	39.44	39.48	39.4	39.43	2293767.0

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

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