PREVIEW / stock_30min / 2015-07-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-07-02.parquet
  size:    1.6 MB
  rows:    81,337
  symbols: 3,483

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-07-02 04:00:00	AAPL	Stock	31.6975	31.77	31.6975	31.77	4904.0
2015-07-02 04:30:00	AAPL	Stock	31.725	31.725	31.725	31.725	1600.0
2015-07-02 05:00:00	AAPL	Stock	31.7025	31.7025	31.7025	31.7025	400.0
2015-07-02 06:00:00	AAPL	Stock	31.675	31.685	31.6625	31.685	3800.0
2015-07-02 06:30:00	AAPL	Stock	31.6575	31.6725	31.4475	31.655	47240.0
2015-07-02 07:00:00	AAPL	Stock	31.6625	31.6675	31.6125	31.6125	40560.0
2015-07-02 07:30:00	AAPL	Stock	31.6125	31.66	31.6125	31.65	23100.0
2015-07-02 08:00:00	AAPL	Stock	31.6325	31.655	31.6125	31.6475	101088.0
2015-07-02 08:30:00	AAPL	Stock	31.6375	31.7	31.6375	31.6675	358620.0
2015-07-02 09:00:00	AAPL	Stock	31.6725	31.6725	31.595	31.62	281484.0
2015-07-02 09:30:00	AAPL	Stock	31.6075	31.6725	31.5525	31.555	15609916.0
2015-07-02 10:00:00	AAPL	Stock	31.555	31.5825	31.525	31.5638	7851732.0
2015-07-02 10:30:00	AAPL	Stock	31.5638	31.57	31.5125	31.5425	7646672.0
2015-07-02 11:00:00	AAPL	Stock	31.545	31.55	31.48	31.4925	7433136.0
2015-07-02 11:30:00	AAPL	Stock	31.4948	31.5125	31.4425	31.4925	6154952.0
2015-07-02 12:00:00	AAPL	Stock	31.4925	31.5125	31.4525	31.4675	4221360.0
2015-07-02 12:30:00	AAPL	Stock	31.4652	31.51	31.46	31.505	3604696.0
2015-07-02 13:00:00	AAPL	Stock	31.5025	31.515	31.4725	31.5025	3871168.0
2015-07-02 13:30:00	AAPL	Stock	31.5022	31.5425	31.4925	31.52	5276668.0
2015-07-02 14:00:00	AAPL	Stock	31.52	31.5375	31.49	31.515	4171952.0
2015-07-02 14:30:00	AAPL	Stock	31.515	31.5575	31.505	31.555	4606236.0
2015-07-02 15:00:00	AAPL	Stock	31.555	31.5975	31.5362	31.5952	8067024.0
2015-07-02 15:30:00	AAPL	Stock	31.5975	31.63	31.57	31.6	16826668.0
2015-07-02 16:00:00	AAPL	Stock	31.61	31.6225	31.585	31.6025	6489800.0
2015-07-02 16:30:00	AAPL	Stock	31.5622	31.595	31.5622	31.58	86592.0
2015-07-02 17:00:00	AAPL	Stock	31.58	31.59	31.5775	31.58	30308.0
2015-07-02 17:30:00	AAPL	Stock	31.5825	31.59	31.58	31.59	6712.0
2015-07-02 18:00:00	AAPL	Stock	31.59	31.59	31.58	31.5875	25016.0
2015-07-02 18:30:00	AAPL	Stock	31.585	31.61	31.58	31.58	12172.0
2015-07-02 19:00:00	AAPL	Stock	31.5875	31.5875	31.575	31.575	43212.0
2015-07-02 19:30:00	AAPL	Stock	31.585	31.5975	31.5775	31.585	26040.0
2015-07-02 04:00:00	MSFT	Stock	44.63	44.63	44.63	44.63	100.0
2015-07-02 08:00:00	MSFT	Stock	44.58	44.63	44.58	44.63	700.0
2015-07-02 08:30:00	MSFT	Stock	44.6	44.69	44.56	44.68	1289.0
2015-07-02 09:00:00	MSFT	Stock	44.56	44.56	44.47	44.47	27684.0
2015-07-02 09:30:00	MSFT	Stock	44.48	44.75	44.47	44.57	2997485.0
2015-07-02 10:00:00	MSFT	Stock	44.57	44.59	44.34	44.37	1230074.0
2015-07-02 10:30:00	MSFT	Stock	44.36	44.37	44.145	44.225	1498901.0
2015-07-02 11:00:00	MSFT	Stock	44.23	44.23	44.11	44.185	1692619.0
2015-07-02 11:30:00	MSFT	Stock	44.18	44.25	44.135	44.19	1025170.0
2015-07-02 12:00:00	MSFT	Stock	44.19	44.24	44.06	44.07	883071.0
2015-07-02 12:30:00	MSFT	Stock	44.07	44.18	44.07	44.16	699271.0
2015-07-02 13:00:00	MSFT	Stock	44.16	44.19	44.07	44.176	783100.0
2015-07-02 13:30:00	MSFT	Stock	44.175	44.24	44.15	44.16	735327.0
2015-07-02 14:00:00	MSFT	Stock	44.17	44.23	44.13	44.19	622603.0
2015-07-02 14:30:00	MSFT	Stock	44.18	44.33	44.18	44.3	927224.0
2015-07-02 15:00:00	MSFT	Stock	44.3	44.4	44.26	44.37	1228876.0
2015-07-02 15:30:00	MSFT	Stock	44.375	44.46	44.29	44.39	3562220.0
2015-07-02 16:00:00	MSFT	Stock	44.37	44.4	44.34	44.34	2844436.0
2015-07-02 16:30:00	MSFT	Stock	44.33	44.38	44.33	44.34	3951.0

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

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