PREVIEW / etf_30min / 2015-03-16

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-16.parquet
  size:    378 KB
  rows:    12,721

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-03-16 04:00:00	SPY	ETF	206.22	206.22	205.93	205.93	430.0
2015-03-16 04:30:00	SPY	ETF	206.23	206.45	206.23	206.45	696.0
2015-03-16 05:00:00	SPY	ETF	206.32	206.6	206.29	206.37	28440.0
2015-03-16 05:30:00	SPY	ETF	206.37	206.5	206.37	206.43	3435.0
2015-03-16 06:00:00	SPY	ETF	206.44	206.61	206.34	206.56	14449.0
2015-03-16 06:30:00	SPY	ETF	206.5	206.57	206.39	206.57	9032.0
2015-03-16 07:00:00	SPY	ETF	206.38	206.45	206.23	206.23	76875.0
2015-03-16 07:30:00	SPY	ETF	206.24	206.42	206.21	206.35	133122.0
2015-03-16 08:00:00	SPY	ETF	206.35	206.56	206.19	206.53	186063.0
2015-03-16 08:30:00	SPY	ETF	206.53	206.8	206.5	206.71	350352.0
2015-03-16 09:00:00	SPY	ETF	206.69	206.98	206.67	206.71	724248.0
2015-03-16 09:30:00	SPY	ETF	206.71	207.72	206.68	207.6	15377016.0
2015-03-16 10:00:00	SPY	ETF	207.6	207.945	207.6	207.69	10632442.0
2015-03-16 10:30:00	SPY	ETF	207.69	207.81	207.56	207.77	9313106.0
2015-03-16 11:00:00	SPY	ETF	207.775	208.15	207.735	207.94	9235046.0
2015-03-16 11:30:00	SPY	ETF	207.94	208.219	207.91	208.08	6674467.0
2015-03-16 12:00:00	SPY	ETF	208.075	208.11	207.76	207.87	5886677.0
2015-03-16 12:30:00	SPY	ETF	207.87	208.06	207.82	207.94	5391043.0
2015-03-16 13:00:00	SPY	ETF	207.94	207.97	207.67	207.92	5434795.0
2015-03-16 13:30:00	SPY	ETF	207.93	208.16	207.87	208.055	5091647.0
2015-03-16 14:00:00	SPY	ETF	208.055	208.29	207.94	208.26	7945875.0
2015-03-16 14:30:00	SPY	ETF	208.26	208.52	208.2	208.47	9641882.0
2015-03-16 15:00:00	SPY	ETF	208.48	208.64	208.34	208.47	8477195.0
2015-03-16 15:30:00	SPY	ETF	208.47	208.69	208.37	208.65	19205905.0
2015-03-16 16:00:00	SPY	ETF	208.66	208.66	207.25	208.18	6076154.0
2015-03-16 16:30:00	SPY	ETF	208.17	208.22	208.12	208.15	4802340.0
2015-03-16 17:00:00	SPY	ETF	208.15	208.15	207.93	208.0	181588.0
2015-03-16 17:30:00	SPY	ETF	208.04	208.05	207.95	208.0	148260.0
2015-03-16 18:00:00	SPY	ETF	207.98	207.99	207.81	207.96	220731.0
2015-03-16 18:30:00	SPY	ETF	207.99	207.99	207.92	207.92	14794.0
2015-03-16 19:00:00	SPY	ETF	207.91	207.95	207.89	207.93	61844.0
2015-03-16 19:30:00	SPY	ETF	207.92	208.05	207.9	208.05	124613.0
2015-03-16 06:00:00	QQQ	ETF	105.6	105.68	105.6	105.68	11250.0
2015-03-16 06:30:00	QQQ	ETF	105.61	105.61	105.57	105.57	10000.0
2015-03-16 07:00:00	QQQ	ETF	105.57	105.58	105.53	105.53	38700.0
2015-03-16 07:30:00	QQQ	ETF	105.52	105.58	105.52	105.55	4563.0
2015-03-16 08:00:00	QQQ	ETF	105.53	105.65	105.53	105.65	53730.0
2015-03-16 08:30:00	QQQ	ETF	105.63	105.75	105.62	105.71	160384.0
2015-03-16 09:00:00	QQQ	ETF	105.72	105.85	105.71	105.73	117424.0
2015-03-16 09:30:00	QQQ	ETF	105.73	106.18	105.62	106.0944	5095228.0
2015-03-16 10:00:00	QQQ	ETF	106.0901	106.37	106.0865	106.1901	2322908.0
2015-03-16 10:30:00	QQQ	ETF	106.2	106.33	106.133	106.33	1307924.0
2015-03-16 11:00:00	QQQ	ETF	106.33	106.5	106.31	106.39	2001887.0
2015-03-16 11:30:00	QQQ	ETF	106.4	106.48	106.34	106.41	884753.0
2015-03-16 12:00:00	QQQ	ETF	106.4	106.44	106.2	106.28	1050418.0
2015-03-16 12:30:00	QQQ	ETF	106.28	106.3899	106.25	106.32	470865.0
2015-03-16 13:00:00	QQQ	ETF	106.31	106.31	106.16	106.28	742301.0
2015-03-16 13:30:00	QQQ	ETF	106.28	106.43	106.26	106.41	800125.0
2015-03-16 14:00:00	QQQ	ETF	106.42	106.53	106.36	106.51	1053676.0
2015-03-16 14:30:00	QQQ	ETF	106.52	106.615	106.46	106.56	1113816.0

> showing 50 of 12,721 rows — these rows as CSV

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