PREVIEW / etf_30min / 2015-12-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-09.parquet
  size:    387 KB
  rows:    13,048

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-09 04:00:00	SPY	ETF	206.89	206.89	206.0	206.11	26487.0
2015-12-09 04:30:00	SPY	ETF	206.19	206.54	206.08	206.45	35156.0
2015-12-09 05:00:00	SPY	ETF	206.43	206.48	206.03	206.23	10091.0
2015-12-09 05:30:00	SPY	ETF	206.25	206.3	206.05	206.05	7417.0
2015-12-09 06:00:00	SPY	ETF	206.15	206.72	206.13	206.7	46116.0
2015-12-09 06:30:00	SPY	ETF	206.68	206.87	206.63	206.78	22515.0
2015-12-09 07:00:00	SPY	ETF	206.71	206.71	206.22	206.33	40949.0
2015-12-09 07:30:00	SPY	ETF	206.33	206.43	206.14	206.29	206601.0
2015-12-09 08:00:00	SPY	ETF	206.29	207.05	206.18	206.45	234246.0
2015-12-09 08:30:00	SPY	ETF	206.48	206.53	206.02	206.06	518498.0
2015-12-09 09:00:00	SPY	ETF	206.09	206.29	205.71	206.22	698652.0
2015-12-09 09:30:00	SPY	ETF	206.19	207.64	206.16	207.3401	13097608.0
2015-12-09 10:00:00	SPY	ETF	207.35	208.23	207.19	207.78	11349628.0
2015-12-09 10:30:00	SPY	ETF	207.78	208.68	207.78	208.15	10584147.0
2015-12-09 11:00:00	SPY	ETF	208.15	208.23	207.245	207.3	8116015.0
2015-12-09 11:30:00	SPY	ETF	207.3	207.47	206.07	206.3	10860615.0
2015-12-09 12:00:00	SPY	ETF	206.33	206.56	205.18	205.32	10276400.0
2015-12-09 12:30:00	SPY	ETF	205.31	205.315	204.32	204.61	16620227.0
2015-12-09 13:00:00	SPY	ETF	204.6	205.11	204.18	204.685	14403377.0
2015-12-09 13:30:00	SPY	ETF	204.7	205.31	204.37	205.0	12373597.0
2015-12-09 14:00:00	SPY	ETF	205.0	205.2	204.68	204.85	6746272.0
2015-12-09 14:30:00	SPY	ETF	204.85	205.16	204.63	204.69	7499981.0
2015-12-09 15:00:00	SPY	ETF	204.68	205.61	204.6	205.4	8772948.0
2015-12-09 15:30:00	SPY	ETF	205.39	205.84	205.1	205.36	14445495.0
2015-12-09 16:00:00	SPY	ETF	205.37	208.26	204.93	205.0	7006235.0
2015-12-09 16:30:00	SPY	ETF	205.0	205.32	205.0	205.3	698349.0
2015-12-09 17:00:00	SPY	ETF	205.28	205.31	205.23	205.23	71707.0
2015-12-09 17:30:00	SPY	ETF	205.25	205.35	205.23	205.29	176566.0
2015-12-09 18:00:00	SPY	ETF	205.36	205.47	205.26	205.35	132407.0
2015-12-09 18:30:00	SPY	ETF	205.36	205.49	205.33	205.47	63970.0
2015-12-09 19:00:00	SPY	ETF	205.49	205.62	205.47	205.59	81414.0
2015-12-09 19:30:00	SPY	ETF	205.6	205.72	205.42	205.42	50702.0
2015-12-09 04:00:00	QQQ	ETF	114.41	114.41	114.01	114.05	20400.0
2015-12-09 06:00:00	QQQ	ETF	114.2	114.2	114.13	114.13	1100.0
2015-12-09 06:30:00	QQQ	ETF	114.51	114.51	114.45	114.45	500.0
2015-12-09 07:00:00	QQQ	ETF	114.29	114.29	114.29	114.29	500.0
2015-12-09 07:30:00	QQQ	ETF	114.18	114.25	114.08	114.18	137227.0
2015-12-09 08:00:00	QQQ	ETF	114.26	114.34	114.15	114.27	90036.0
2015-12-09 08:30:00	QQQ	ETF	114.27	114.32	114.09	114.1	50307.0
2015-12-09 09:00:00	QQQ	ETF	114.12	114.18	113.91	114.11	182527.0
2015-12-09 09:30:00	QQQ	ETF	114.11	114.453	113.82	114.18	4051648.0
2015-12-09 10:00:00	QQQ	ETF	114.17	114.64	114.125	114.35	3616631.0
2015-12-09 10:30:00	QQQ	ETF	114.35	114.76	114.35	114.48	2637029.0
2015-12-09 11:00:00	QQQ	ETF	114.48	114.5	113.97	114.01	2079740.0
2015-12-09 11:30:00	QQQ	ETF	113.99	114.073	113.35	113.46	3252444.0
2015-12-09 12:00:00	QQQ	ETF	113.465	113.61	112.78	112.8088	5124541.0
2015-12-09 12:30:00	QQQ	ETF	112.8	112.8462	112.31	112.43	4646750.0
2015-12-09 13:00:00	QQQ	ETF	112.43	112.74	112.21	112.39	3891294.0
2015-12-09 13:30:00	QQQ	ETF	112.4	112.7626	112.2	112.58	3277708.0
2015-12-09 14:00:00	QQQ	ETF	112.59	112.65	112.27	112.38	2135432.0

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

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