PREVIEW / stock_30min / 2014-12-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-15.parquet
  size:    1.7 MB
  rows:    85,910
  symbols: 3,563

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-12-15 04:00:00	AAPL	Stock	27.5	27.6875	27.5	27.6875	28292.0
2014-12-15 04:30:00	AAPL	Stock	27.655	27.655	27.6275	27.6375	18800.0
2014-12-15 05:00:00	AAPL	Stock	27.655	27.655	27.65	27.65	5200.0
2014-12-15 05:30:00	AAPL	Stock	27.7	27.7	27.675	27.675	800.0
2014-12-15 06:00:00	AAPL	Stock	27.675	27.745	27.635	27.635	7488.0
2014-12-15 06:30:00	AAPL	Stock	27.66	27.6625	27.65	27.6625	24360.0
2014-12-15 07:00:00	AAPL	Stock	27.6525	27.6625	27.625	27.6625	106232.0
2014-12-15 07:30:00	AAPL	Stock	27.6625	27.6825	27.6425	27.6425	118436.0
2014-12-15 08:00:00	AAPL	Stock	27.6275	27.695	27.625	27.6798	495880.0
2014-12-15 08:30:00	AAPL	Stock	27.675	27.675	27.6	27.615	433248.0
2014-12-15 09:00:00	AAPL	Stock	27.605	27.685	27.4325	27.675	899124.0
2014-12-15 09:30:00	AAPL	Stock	27.675	27.9	27.6125	27.6822	29657400.0
2014-12-15 10:00:00	AAPL	Stock	27.6775	27.69	27.545	27.5725	14421828.0
2014-12-15 10:30:00	AAPL	Stock	27.57	27.6175	27.4375	27.5725	16937040.0
2014-12-15 11:00:00	AAPL	Stock	27.565	27.575	27.0575	27.195	21409348.0
2014-12-15 11:30:00	AAPL	Stock	27.1925	27.2225	26.5875	26.8925	41819388.0
2014-12-15 12:00:00	AAPL	Stock	26.8938	27.2425	26.8875	27.23	17139344.0
2014-12-15 12:30:00	AAPL	Stock	27.23	27.43	27.1928	27.3638	16654404.0
2014-12-15 13:00:00	AAPL	Stock	27.3625	27.4625	27.1925	27.2325	12472612.0
2014-12-15 13:30:00	AAPL	Stock	27.23	27.25	27.1075	27.1875	8798044.0
2014-12-15 14:00:00	AAPL	Stock	27.185	27.3475	27.135	27.3175	10766720.0
2014-12-15 14:30:00	AAPL	Stock	27.315	27.3925	27.125	27.2	10461336.0
2014-12-15 15:00:00	AAPL	Stock	27.2	27.275	26.9825	27.005	11226480.0
2014-12-15 15:30:00	AAPL	Stock	27.0025	27.1625	26.9375	27.0575	22327272.0
2014-12-15 16:00:00	AAPL	Stock	27.0562	27.3085	27.0525	27.0625	14270444.0
2014-12-15 16:30:00	AAPL	Stock	27.05	27.6222	26.995	27.025	168876.0
2014-12-15 17:00:00	AAPL	Stock	27.0125	27.4225	27.0125	27.0598	70944.0
2014-12-15 17:30:00	AAPL	Stock	27.0375	27.0575	27.02	27.025	112316.0
2014-12-15 18:00:00	AAPL	Stock	27.0375	27.0575	27.035	27.055	57160.0
2014-12-15 18:30:00	AAPL	Stock	27.0525	27.095	27.0525	27.0875	131448.0
2014-12-15 19:00:00	AAPL	Stock	27.0875	27.135	27.0875	27.115	62932.0
2014-12-15 19:30:00	AAPL	Stock	27.115	27.115	27.0525	27.0525	139520.0
2014-12-15 04:00:00	MSFT	Stock	46.95	46.95	46.95	46.95	100.0
2014-12-15 04:30:00	MSFT	Stock	47.16	47.16	47.16	47.16	200.0
2014-12-15 07:30:00	MSFT	Stock	47.2	47.2	47.2	47.2	100.0
2014-12-15 08:00:00	MSFT	Stock	47.18	47.38	47.18	47.22	4209.0
2014-12-15 08:30:00	MSFT	Stock	47.25	47.25	47.09	47.09	8786.0
2014-12-15 09:00:00	MSFT	Stock	47.26	47.3	47.21	47.26	9416.0
2014-12-15 09:30:00	MSFT	Stock	47.2	47.67	47.11	47.5	3609761.0
2014-12-15 10:00:00	MSFT	Stock	47.49	47.52	47.18	47.3	1770242.0
2014-12-15 10:30:00	MSFT	Stock	47.29	47.33	47.01	47.196	1555237.0
2014-12-15 11:00:00	MSFT	Stock	47.2	47.2	46.821	46.92	1715065.0
2014-12-15 11:30:00	MSFT	Stock	46.91	47.06	46.82	46.831	2489829.0
2014-12-15 12:00:00	MSFT	Stock	46.835	47.07	46.82	46.984	1611951.0
2014-12-15 12:30:00	MSFT	Stock	46.98	47.08	46.89	47.02	1031517.0
2014-12-15 13:00:00	MSFT	Stock	47.02	47.085	46.77	46.795	1026790.0
2014-12-15 13:30:00	MSFT	Stock	46.79	46.869	46.68	46.77	1094331.0
2014-12-15 14:00:00	MSFT	Stock	46.76	46.95	46.63	46.86	1269284.0
2014-12-15 14:30:00	MSFT	Stock	46.86	46.94	46.704	46.73	1043114.0
2014-12-15 15:00:00	MSFT	Stock	46.735	46.86	46.63	46.64	1229683.0

> showing 50 of 85,910 rows — these rows as CSV

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