PREVIEW / etf_30min / 2016-04-25

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-25.parquet
  size:    386 KB
  rows:    13,080

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
2016-04-25 04:00:00	SPY	ETF	208.15	208.15	207.83	207.98	13103.0
2016-04-25 04:30:00	SPY	ETF	207.91	208.18	207.83	208.15	1750.0
2016-04-25 05:00:00	SPY	ETF	208.05	208.3	208.05	208.28	4658.0
2016-04-25 05:30:00	SPY	ETF	208.29	208.86	208.29	208.86	15060.0
2016-04-25 06:00:00	SPY	ETF	208.89	208.93	208.73	208.87	12330.0
2016-04-25 06:30:00	SPY	ETF	208.8	208.89	208.74	208.81	22526.0
2016-04-25 07:00:00	SPY	ETF	208.78	208.85	208.65	208.82	39135.0
2016-04-25 07:30:00	SPY	ETF	208.8	208.85	208.56	208.63	83968.0
2016-04-25 08:00:00	SPY	ETF	208.68	208.86	208.3	208.41	281131.0
2016-04-25 08:30:00	SPY	ETF	208.4	208.67	208.4	208.46	196872.0
2016-04-25 09:00:00	SPY	ETF	208.52	208.61	208.15	208.25	685520.0
2016-04-25 09:30:00	SPY	ETF	208.26	208.57	207.96	208.13	8250413.0
2016-04-25 10:00:00	SPY	ETF	208.13	208.29	207.66	207.735	5716675.0
2016-04-25 10:30:00	SPY	ETF	207.7375	207.89	207.64	207.7	4398521.0
2016-04-25 11:00:00	SPY	ETF	207.71	208.035	207.54	208.0	4685247.0
2016-04-25 11:30:00	SPY	ETF	208.0	208.03	207.73	207.78	2212598.0
2016-04-25 12:00:00	SPY	ETF	207.79	207.92	207.715	207.91	3049263.0
2016-04-25 12:30:00	SPY	ETF	207.91	208.419	207.8	208.31	3820247.0
2016-04-25 13:00:00	SPY	ETF	208.31	208.49	208.22	208.305	2510165.0
2016-04-25 13:30:00	SPY	ETF	208.3	208.345	208.16	208.23	1611212.0
2016-04-25 14:00:00	SPY	ETF	208.23	208.37	207.9525	208.21	3165313.0
2016-04-25 14:30:00	SPY	ETF	208.21	208.33	208.05	208.26	4164504.0
2016-04-25 15:00:00	SPY	ETF	208.269	208.27	207.96	208.1401	3214546.0
2016-04-25 15:30:00	SPY	ETF	208.15	208.62	208.065	208.61	8067511.0
2016-04-25 16:00:00	SPY	ETF	208.62	208.9549	208.55	208.72	7704388.0
2016-04-25 16:30:00	SPY	ETF	208.73	208.82	208.72	208.81	128987.0
2016-04-25 17:00:00	SPY	ETF	208.79	208.83	208.79	208.81	62006.0
2016-04-25 17:30:00	SPY	ETF	208.8	208.81	208.79	208.79	18209.0
2016-04-25 18:00:00	SPY	ETF	208.79	208.85	208.77	208.79	17103.0
2016-04-25 18:30:00	SPY	ETF	208.79	208.79	208.75	208.75	23661.0
2016-04-25 19:00:00	SPY	ETF	208.74	208.83	208.74	208.8	84521.0
2016-04-25 19:30:00	SPY	ETF	208.77	208.83	208.74	208.75	59588.0
2016-04-25 04:00:00	QQQ	ETF	108.54	108.54	108.27	108.27	650.0
2016-04-25 04:30:00	QQQ	ETF	108.31	108.31	108.31	108.31	200.0
2016-04-25 05:00:00	QQQ	ETF	108.5	108.5	108.5	108.5	100.0
2016-04-25 05:30:00	QQQ	ETF	108.6	108.85	108.6	108.85	399.0
2016-04-25 06:30:00	QQQ	ETF	108.86	108.89	108.86	108.89	600.0
2016-04-25 07:00:00	QQQ	ETF	108.85	108.85	108.76	108.81	26855.0
2016-04-25 07:30:00	QQQ	ETF	108.8	108.83	108.67	108.68	12359.0
2016-04-25 08:00:00	QQQ	ETF	108.77	108.78	108.55	108.61	307468.0
2016-04-25 08:30:00	QQQ	ETF	108.6	108.77	108.59	108.66	43904.0
2016-04-25 09:00:00	QQQ	ETF	108.73	108.75	108.54	108.62	80740.0
2016-04-25 09:30:00	QQQ	ETF	108.62	108.981	108.57	108.7563	2046186.0
2016-04-25 10:00:00	QQQ	ETF	108.75	108.91	108.5	108.55	1291611.0
2016-04-25 10:30:00	QQQ	ETF	108.55	108.749	108.461	108.52	1036992.0
2016-04-25 11:00:00	QQQ	ETF	108.5199	108.71	108.45	108.7	1119765.0
2016-04-25 11:30:00	QQQ	ETF	108.7	108.71	108.47	108.568	448910.0
2016-04-25 12:00:00	QQQ	ETF	108.56	108.69	108.55	108.6768	450695.0
2016-04-25 12:30:00	QQQ	ETF	108.68	108.95	108.62	108.84	833117.0
2016-04-25 13:00:00	QQQ	ETF	108.85	108.95	108.76	108.835	500110.0

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

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