PREVIEW / stock_30min / 2015-10-19

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-19.parquet
  size:    1.5 MB
  rows:    80,432
  symbols: 3,424

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-10-19 04:00:00	AAPL	Stock	27.8225	27.8225	27.7625	27.7625	5600.0
2015-10-19 05:00:00	AAPL	Stock	27.7875	27.7875	27.7625	27.7625	3528.0
2015-10-19 05:30:00	AAPL	Stock	27.7625	27.7675	27.7625	27.7675	2776.0
2015-10-19 06:00:00	AAPL	Stock	27.77	27.775	27.75	27.75	7248.0
2015-10-19 06:30:00	AAPL	Stock	27.775	27.7875	27.7725	27.7825	5000.0
2015-10-19 07:00:00	AAPL	Stock	27.7675	27.795	27.7175	27.795	34000.0
2015-10-19 07:30:00	AAPL	Stock	27.825	27.825	27.7625	27.775	41404.0
2015-10-19 08:00:00	AAPL	Stock	27.775	27.835	27.7375	27.775	181292.0
2015-10-19 08:30:00	AAPL	Stock	27.775	27.775	27.685	27.685	182212.0
2015-10-19 09:00:00	AAPL	Stock	27.685	27.735	27.64	27.7125	258416.0
2015-10-19 09:30:00	AAPL	Stock	27.7	27.7475	27.5275	27.705	16969272.0
2015-10-19 10:00:00	AAPL	Stock	27.7	27.865	27.6175	27.83	11682980.0
2015-10-19 10:30:00	AAPL	Stock	27.83	27.87	27.76	27.865	7438096.0
2015-10-19 11:00:00	AAPL	Stock	27.865	27.895	27.7475	27.75	7448168.0
2015-10-19 11:30:00	AAPL	Stock	27.75	27.8162	27.72	27.7975	6622988.0
2015-10-19 12:00:00	AAPL	Stock	27.795	27.81	27.7575	27.805	3924320.0
2015-10-19 12:30:00	AAPL	Stock	27.805	27.81	27.7612	27.775	3767416.0
2015-10-19 13:00:00	AAPL	Stock	27.775	27.8	27.7125	27.7225	4578296.0
2015-10-19 13:30:00	AAPL	Stock	27.72	27.8	27.7175	27.7875	6670412.0
2015-10-19 14:00:00	AAPL	Stock	27.785	27.85	27.7675	27.8025	6800040.0
2015-10-19 14:30:00	AAPL	Stock	27.8032	27.895	27.7975	27.8925	7626552.0
2015-10-19 15:00:00	AAPL	Stock	27.8925	27.895	27.83	27.8525	6136188.0
2015-10-19 15:30:00	AAPL	Stock	27.8535	27.9375	27.8425	27.9325	13077620.0
2015-10-19 16:00:00	AAPL	Stock	27.9325	27.9325	27.8875	27.9	7554252.0
2015-10-19 16:30:00	AAPL	Stock	27.91	27.91	27.89	27.9	28456.0
2015-10-19 17:00:00	AAPL	Stock	27.9025	27.925	27.8875	27.89	71324.0
2015-10-19 17:30:00	AAPL	Stock	27.89	27.9175	27.89	27.9025	12400.0
2015-10-19 18:00:00	AAPL	Stock	27.9125	27.9325	27.9025	27.9025	49224.0
2015-10-19 18:30:00	AAPL	Stock	27.9025	27.9025	27.9025	27.9025	10000.0
2015-10-19 19:00:00	AAPL	Stock	27.9025	27.915	27.8975	27.8975	19684.0
2015-10-19 19:30:00	AAPL	Stock	27.91	27.91	27.8875	27.9025	28584.0
2015-10-19 05:30:00	MSFT	Stock	47.57	47.71	47.57	47.71	1212.0
2015-10-19 06:30:00	MSFT	Stock	47.69	47.69	47.6	47.6	2082.0
2015-10-19 07:00:00	MSFT	Stock	47.6	47.6	47.51	47.52	500.0
2015-10-19 07:30:00	MSFT	Stock	47.62	47.62	47.62	47.62	20518.0
2015-10-19 08:00:00	MSFT	Stock	47.65	47.72	47.5	47.56	24937.0
2015-10-19 08:30:00	MSFT	Stock	47.51	47.51	47.4	47.4	4288.0
2015-10-19 09:00:00	MSFT	Stock	47.38	47.54	47.37	47.54	18771.0
2015-10-19 09:30:00	MSFT	Stock	47.42	47.54	47.02	47.23	2826344.0
2015-10-19 10:00:00	MSFT	Stock	47.23	47.235	47.025	47.08	1931996.0
2015-10-19 10:30:00	MSFT	Stock	47.08	47.29	47.065	47.28	1318573.0
2015-10-19 11:00:00	MSFT	Stock	47.28	47.46	47.158	47.45	1319305.0
2015-10-19 11:30:00	MSFT	Stock	47.45	47.71	47.44	47.62	1549292.0
2015-10-19 12:00:00	MSFT	Stock	47.61	47.8	47.53	47.785	1692669.0
2015-10-19 12:30:00	MSFT	Stock	47.79	47.88	47.74	47.82	1951698.0
2015-10-19 13:00:00	MSFT	Stock	47.816	47.84	47.69	47.69	1692368.0
2015-10-19 13:30:00	MSFT	Stock	47.69	47.735	47.635	47.7	1192680.0
2015-10-19 14:00:00	MSFT	Stock	47.696	47.71	47.5	47.51	1572477.0
2015-10-19 14:30:00	MSFT	Stock	47.51	47.67	47.5	47.6	1005077.0
2015-10-19 15:00:00	MSFT	Stock	47.604	47.71	47.59	47.67	1594496.0

> showing 50 of 80,432 rows — these rows as CSV

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