PREVIEW / etf_30min / 2015-12-16

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-16.parquet
  size:    401 KB
  rows:    13,488

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-12-16 04:00:00	SPY	ETF	205.48	205.92	205.48	205.87	6550.0
2015-12-16 04:30:00	SPY	ETF	205.8	205.94	205.78	205.94	5348.0
2015-12-16 05:00:00	SPY	ETF	205.95	206.04	205.82	206.01	5099.0
2015-12-16 05:30:00	SPY	ETF	206.03	206.6	206.03	206.41	29066.0
2015-12-16 06:00:00	SPY	ETF	206.25	206.5	206.12	206.45	35231.0
2015-12-16 06:30:00	SPY	ETF	206.53	206.54	206.25	206.25	12514.0
2015-12-16 07:00:00	SPY	ETF	206.25	206.3	206.02	206.1	57823.0
2015-12-16 07:30:00	SPY	ETF	206.1	206.2	205.97	206.12	79159.0
2015-12-16 08:00:00	SPY	ETF	205.89	206.4	205.42	206.24	345532.0
2015-12-16 08:30:00	SPY	ETF	206.31	206.5	206.26	206.35	513767.0
2015-12-16 09:00:00	SPY	ETF	206.37	206.495	205.03	206.37	475819.0
2015-12-16 09:30:00	SPY	ETF	206.365	206.78	206.16	206.16	13354523.0
2015-12-16 10:00:00	SPY	ETF	206.17	206.37	205.93	206.025	9071951.0
2015-12-16 10:30:00	SPY	ETF	206.03	206.07	205.475	205.72	11518100.0
2015-12-16 11:00:00	SPY	ETF	205.72	205.79	205.3201	205.36	7843556.0
2015-12-16 11:30:00	SPY	ETF	205.35	205.7399	205.33	205.65	5892149.0
2015-12-16 12:00:00	SPY	ETF	205.65	205.88	205.59	205.76	5095615.0
2015-12-16 12:30:00	SPY	ETF	205.78	205.87	205.36	205.42	5346777.0
2015-12-16 13:00:00	SPY	ETF	205.43	205.795	205.315	205.75	4333303.0
2015-12-16 13:30:00	SPY	ETF	205.74	206.36	205.56	206.2525	5963759.0
2015-12-16 14:00:00	SPY	ETF	206.19	207.12	204.8	205.96	33343485.0
2015-12-16 14:30:00	SPY	ETF	205.96	207.76	205.565	207.68	20094304.0
2015-12-16 15:00:00	SPY	ETF	207.69	207.93	207.03	207.9	20276816.0
2015-12-16 15:30:00	SPY	ETF	207.89	208.39	207.81	207.98	34142971.0
2015-12-16 16:00:00	SPY	ETF	207.99	208.23	207.6	207.89	10144658.0
2015-12-16 16:30:00	SPY	ETF	207.89	207.91	207.53	207.53	2132964.0
2015-12-16 17:00:00	SPY	ETF	207.55	207.66	207.54	207.65	268692.0
2015-12-16 17:30:00	SPY	ETF	207.65	207.72	207.62	207.63	198274.0
2015-12-16 18:00:00	SPY	ETF	207.63	207.89	207.52	207.87	214312.0
2015-12-16 18:30:00	SPY	ETF	207.84	207.9	207.81	207.82	81909.0
2015-12-16 19:00:00	SPY	ETF	207.85	207.86	207.71	207.78	66617.0
2015-12-16 19:30:00	SPY	ETF	207.78	207.78	207.57	207.57	50632.0
2015-12-16 04:00:00	QQQ	ETF	112.7	112.84	112.7	112.84	500.0
2015-12-16 05:00:00	QQQ	ETF	112.94	112.94	112.94	112.94	100.0
2015-12-16 05:30:00	QQQ	ETF	113.0	113.26	113.0	113.15	13900.0
2015-12-16 06:00:00	QQQ	ETF	113.11	113.28	113.04	113.22	3770.0
2015-12-16 06:30:00	QQQ	ETF	113.24	113.24	113.07	113.07	2000.0
2015-12-16 07:00:00	QQQ	ETF	113.07	113.08	112.9	112.96	62500.0
2015-12-16 07:30:00	QQQ	ETF	113.0	113.04	112.89	112.94	38612.0
2015-12-16 08:00:00	QQQ	ETF	113.01	113.11	112.9	113.07	22070.0
2015-12-16 08:30:00	QQQ	ETF	113.07	113.12	113.02	113.1	41575.0
2015-12-16 09:00:00	QQQ	ETF	113.09	113.14	113.01	113.09	77196.0
2015-12-16 09:30:00	QQQ	ETF	113.08	113.3	112.73	112.75	2844688.0
2015-12-16 10:00:00	QQQ	ETF	112.75	112.8452	112.42	112.48	2107558.0
2015-12-16 10:30:00	QQQ	ETF	112.47	112.62	112.23	112.549	2863349.0
2015-12-16 11:00:00	QQQ	ETF	112.54	112.62	112.33	112.35	1188418.0
2015-12-16 11:30:00	QQQ	ETF	112.34	112.54	112.33	112.45	1086063.0
2015-12-16 12:00:00	QQQ	ETF	112.43	112.54	112.35	112.45	826020.0
2015-12-16 12:30:00	QQQ	ETF	112.44	112.49	112.26	112.28	1069521.0
2015-12-16 13:00:00	QQQ	ETF	112.29	112.46	112.21	112.43	1838137.0

> showing 50 of 13,488 rows — these rows as CSV

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