PREVIEW / stock_30min / 2015-02-04

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-04.parquet
  size:    1.6 MB
  rows:    84,242
  symbols: 3,546

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
2015-02-04 04:30:00	AAPL	Stock	29.5975	29.5975	29.53	29.5625	3600.0
2015-02-04 05:00:00	AAPL	Stock	29.5875	29.5875	29.575	29.575	2800.0
2015-02-04 05:30:00	AAPL	Stock	29.6175	29.6175	29.6175	29.6175	2400.0
2015-02-04 06:00:00	AAPL	Stock	29.5775	29.6325	29.5775	29.6325	7032.0
2015-02-04 06:30:00	AAPL	Stock	29.655	29.6575	29.645	29.645	4004.0
2015-02-04 07:00:00	AAPL	Stock	29.645	29.65	29.5625	29.58	32692.0
2015-02-04 07:30:00	AAPL	Stock	29.6	29.615	29.575	29.59	72692.0
2015-02-04 08:00:00	AAPL	Stock	29.6	29.61	29.5425	29.5575	217424.0
2015-02-04 08:30:00	AAPL	Stock	29.565	29.5775	29.525	29.575	245264.0
2015-02-04 09:00:00	AAPL	Stock	29.575	29.6625	29.4925	29.6175	307948.0
2015-02-04 09:30:00	AAPL	Stock	29.625	29.9225	29.5772	29.89	35410120.0
2015-02-04 10:00:00	AAPL	Stock	29.895	29.95	29.8225	29.9425	25006540.0
2015-02-04 10:30:00	AAPL	Stock	29.94	29.9675	29.7925	29.9348	19984308.0
2015-02-04 11:00:00	AAPL	Stock	29.9325	30.0875	29.8925	30.025	39112536.0
2015-02-04 11:30:00	AAPL	Stock	30.0255	30.08	29.97	29.995	14435412.0
2015-02-04 12:00:00	AAPL	Stock	29.99	30.04	29.95	29.965	10044560.0
2015-02-04 12:30:00	AAPL	Stock	29.9638	29.99	29.8525	29.9525	19212520.0
2015-02-04 13:00:00	AAPL	Stock	29.955	30.05	29.9325	30.05	8056460.0
2015-02-04 13:30:00	AAPL	Stock	30.05	30.075	30.015	30.0425	10950912.0
2015-02-04 14:00:00	AAPL	Stock	30.0425	30.0825	29.945	30.0238	12465560.0
2015-02-04 14:30:00	AAPL	Stock	30.025	30.0475	29.9875	30.0225	7463056.0
2015-02-04 15:00:00	AAPL	Stock	30.025	30.0875	29.9925	30.0875	10961380.0
2015-02-04 15:30:00	AAPL	Stock	30.0875	30.1275	29.8175	29.8875	39622016.0
2015-02-04 16:00:00	AAPL	Stock	29.8875	29.986	29.624	29.89	8901352.0
2015-02-04 16:30:00	AAPL	Stock	29.8375	29.9622	29.775	29.84	338960.0
2015-02-04 17:00:00	AAPL	Stock	29.84	29.84	29.8125	29.8275	88404.0
2015-02-04 17:30:00	AAPL	Stock	29.8275	29.89	29.7575	29.8225	121136.0
2015-02-04 18:00:00	AAPL	Stock	29.8225	29.845	29.815	29.845	101848.0
2015-02-04 18:30:00	AAPL	Stock	29.83	29.89	29.8175	29.835	125872.0
2015-02-04 19:00:00	AAPL	Stock	29.83	29.8675	29.83	29.8675	182688.0
2015-02-04 19:30:00	AAPL	Stock	29.8625	29.8725	29.8275	29.83	137388.0
2015-02-04 04:00:00	MSFT	Stock	41.6	41.7	41.6	41.7	400.0
2015-02-04 06:30:00	MSFT	Stock	41.6	41.6	41.57	41.57	800.0
2015-02-04 07:00:00	MSFT	Stock	41.57	41.57	41.47	41.47	3997.0
2015-02-04 07:30:00	MSFT	Stock	41.5	41.5	41.5	41.5	200.0
2015-02-04 08:00:00	MSFT	Stock	41.57	41.57	41.46	41.5	8785.0
2015-02-04 08:30:00	MSFT	Stock	41.56	41.57	41.5	41.55	6000.0
2015-02-04 09:00:00	MSFT	Stock	41.5	41.95	41.43	41.89	137517.0
2015-02-04 09:30:00	MSFT	Stock	41.94	41.98	41.6	41.63	5043727.0
2015-02-04 10:00:00	MSFT	Stock	41.63	41.74	41.36	41.395	4284405.0
2015-02-04 10:30:00	MSFT	Stock	41.39	41.61	41.36	41.555	1998114.0
2015-02-04 11:00:00	MSFT	Stock	41.55	41.62	41.52	41.6	1468273.0
2015-02-04 11:30:00	MSFT	Stock	41.6	41.67	41.595	41.64	1275340.0
2015-02-04 12:00:00	MSFT	Stock	41.64	41.7	41.61	41.62	1032358.0
2015-02-04 12:30:00	MSFT	Stock	41.625	41.66	41.58	41.62	1603418.0
2015-02-04 13:00:00	MSFT	Stock	41.63	41.76	41.61	41.756	1175175.0
2015-02-04 13:30:00	MSFT	Stock	41.755	41.85	41.745	41.8	1685181.0
2015-02-04 14:00:00	MSFT	Stock	41.805	41.88	41.8	41.845	2233854.0
2015-02-04 14:30:00	MSFT	Stock	41.845	42.08	41.81	42.04	2570466.0
2015-02-04 15:00:00	MSFT	Stock	42.045	42.18	42.0	42.17	3499417.0

> showing 50 of 84,242 rows — these rows as CSV

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