PREVIEW / etf_30min / 2015-11-18

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-18.parquet
  size:    386 KB
  rows:    12,827

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-11-18 04:00:00	SPY	ETF	205.25	205.25	205.22	205.22	50240.0
2015-11-18 04:30:00	SPY	ETF	205.24	205.33	205.24	205.3	3125.0
2015-11-18 05:00:00	SPY	ETF	205.27	205.27	205.09	205.16	8296.0
2015-11-18 05:30:00	SPY	ETF	205.34	205.34	205.15	205.15	4750.0
2015-11-18 06:00:00	SPY	ETF	205.27	205.66	205.27	205.66	8585.0
2015-11-18 06:30:00	SPY	ETF	205.64	205.9	205.62	205.9	34012.0
2015-11-18 07:00:00	SPY	ETF	205.95	206.1	205.85	205.93	126760.0
2015-11-18 07:30:00	SPY	ETF	205.95	205.95	205.75	205.83	87422.0
2015-11-18 08:00:00	SPY	ETF	205.82	206.06	205.76	206.05	156169.0
2015-11-18 08:30:00	SPY	ETF	206.04	206.37	205.77	206.32	749749.0
2015-11-18 09:00:00	SPY	ETF	206.32	206.33	206.0	206.09	666386.0
2015-11-18 09:30:00	SPY	ETF	206.04	206.77	205.99	206.5	9537700.0
2015-11-18 10:00:00	SPY	ETF	206.49	206.725	206.22	206.37	6352781.0
2015-11-18 10:30:00	SPY	ETF	206.37	206.54	206.13	206.54	4690933.0
2015-11-18 11:00:00	SPY	ETF	206.54	206.84	206.2477	206.78	5543856.0
2015-11-18 11:30:00	SPY	ETF	206.79	207.22	206.76	206.95	6225995.0
2015-11-18 12:00:00	SPY	ETF	206.95	207.19	206.79	207.06	5552205.0
2015-11-18 12:30:00	SPY	ETF	207.07	207.09	206.67	206.93	3270684.0
2015-11-18 13:00:00	SPY	ETF	206.93	207.29	206.905	207.12	3921167.0
2015-11-18 13:30:00	SPY	ETF	207.125	207.19	206.88	206.89	3509473.0
2015-11-18 14:00:00	SPY	ETF	206.91	208.0	206.74	207.535	15432507.0
2015-11-18 14:30:00	SPY	ETF	207.54	208.08	207.26	208.06	6708600.0
2015-11-18 15:00:00	SPY	ETF	208.05	208.29	207.8	208.1789	8780396.0
2015-11-18 15:30:00	SPY	ETF	208.18	208.9	208.13	208.71	23899154.0
2015-11-18 16:00:00	SPY	ETF	208.71	208.82	205.3959	208.6	8463617.0
2015-11-18 16:30:00	SPY	ETF	208.6	208.7041	205.3958	208.56	5609926.0
2015-11-18 17:00:00	SPY	ETF	208.57	208.58	208.53	208.53	56028.0
2015-11-18 17:30:00	SPY	ETF	208.53	208.68	208.51	208.52	46482.0
2015-11-18 18:00:00	SPY	ETF	208.52	208.63	208.49	208.63	38945.0
2015-11-18 18:30:00	SPY	ETF	208.64	208.83	208.64	208.82	69829.0
2015-11-18 19:00:00	SPY	ETF	208.74	208.82	208.69	208.82	4452.0
2015-11-18 19:30:00	SPY	ETF	208.82	209.03	208.79	208.95	81952.0
2015-11-18 06:00:00	QQQ	ETF	111.46	111.65	111.46	111.65	4600.0
2015-11-18 06:30:00	QQQ	ETF	111.63	111.7	111.63	111.7	300.0
2015-11-18 07:00:00	QQQ	ETF	111.76	111.88	111.75	111.84	38348.0
2015-11-18 07:30:00	QQQ	ETF	111.79	111.84	111.79	111.81	1271.0
2015-11-18 08:00:00	QQQ	ETF	111.84	111.9	111.8	111.9	39178.0
2015-11-18 08:30:00	QQQ	ETF	111.92	112.08	111.81	112.03	104083.0
2015-11-18 09:00:00	QQQ	ETF	112.01	112.03	111.93	111.97	211876.0
2015-11-18 09:30:00	QQQ	ETF	111.94	112.31	111.83	112.13	2926473.0
2015-11-18 10:00:00	QQQ	ETF	112.14	112.38	112.13	112.2087	2164929.0
2015-11-18 10:30:00	QQQ	ETF	112.21	112.3	112.07	112.3	1504975.0
2015-11-18 11:00:00	QQQ	ETF	112.3	112.53	112.14	112.47	1948388.0
2015-11-18 11:30:00	QQQ	ETF	112.47	112.69	112.47	112.59	2156973.0
2015-11-18 12:00:00	QQQ	ETF	112.59	112.71	112.5	112.58	1757922.0
2015-11-18 12:30:00	QQQ	ETF	112.595	112.62	112.43	112.53	1013021.0
2015-11-18 13:00:00	QQQ	ETF	112.53	112.79	112.51	112.7138	990818.0
2015-11-18 13:30:00	QQQ	ETF	112.72	112.755	112.59	112.685	935712.0
2015-11-18 14:00:00	QQQ	ETF	112.68	113.25	112.56	112.99	4971591.0
2015-11-18 14:30:00	QQQ	ETF	112.991	113.28	112.82	113.26	1568723.0

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

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