PREVIEW / etf_30min / 2016-04-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-11.parquet
  size:    392 KB
  rows:    13,341

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-11 04:00:00	SPY	ETF	205.21	205.6	205.08	205.15	31831.0
2016-04-11 04:30:00	SPY	ETF	205.2	205.37	205.14	205.16	11131.0
2016-04-11 05:00:00	SPY	ETF	205.1	205.15	205.0	205.1	3467.0
2016-04-11 05:30:00	SPY	ETF	205.1	205.25	205.1	205.1	10884.0
2016-04-11 06:00:00	SPY	ETF	205.14	205.2	205.1	205.11	12464.0
2016-04-11 06:30:00	SPY	ETF	205.14	205.45	205.14	205.34	54363.0
2016-04-11 07:00:00	SPY	ETF	205.33	205.38	205.19	205.21	83854.0
2016-04-11 07:30:00	SPY	ETF	205.2	205.42	205.2	205.21	183785.0
2016-04-11 08:00:00	SPY	ETF	205.23	205.37	203.94	205.14	146794.0
2016-04-11 08:30:00	SPY	ETF	205.17	205.48	205.16	205.48	299267.0
2016-04-11 09:00:00	SPY	ETF	205.49	205.57	205.23	205.25	667942.0
2016-04-11 09:30:00	SPY	ETF	205.25	205.75	205.14	205.625	9896118.0
2016-04-11 10:00:00	SPY	ETF	205.63	206.07	205.625	205.755	7190706.0
2016-04-11 10:30:00	SPY	ETF	205.77	205.85	204.97	204.99	6238741.0
2016-04-11 11:00:00	SPY	ETF	205.0	205.25	204.82	205.149	4532862.0
2016-04-11 11:30:00	SPY	ETF	205.14	205.18	204.63	205.02	3741000.0
2016-04-11 12:00:00	SPY	ETF	205.02	205.28	204.87	205.11	3076421.0
2016-04-11 12:30:00	SPY	ETF	205.11	205.4	204.88	205.375	3205942.0
2016-04-11 13:00:00	SPY	ETF	205.36	205.55	205.15	205.18	2430248.0
2016-04-11 13:30:00	SPY	ETF	205.18	205.37	204.94	205.05	3102844.0
2016-04-11 14:00:00	SPY	ETF	205.06	205.27	204.8	204.93	4113997.0
2016-04-11 14:30:00	SPY	ETF	204.92	205.32	204.81	205.2035	5578039.0
2016-04-11 15:00:00	SPY	ETF	205.21	205.24	204.36	204.3895	5255510.0
2016-04-11 15:30:00	SPY	ETF	204.38	204.464	203.91	203.98	13872709.0
2016-04-11 16:00:00	SPY	ETF	203.98	205.6055	203.8	203.9	3153364.0
2016-04-11 16:30:00	SPY	ETF	203.89	205.24	203.7	203.75	434573.0
2016-04-11 17:00:00	SPY	ETF	203.75	203.77	203.72	203.75	626909.0
2016-04-11 17:30:00	SPY	ETF	203.75	203.75	203.68	203.72	20895.0
2016-04-11 18:00:00	SPY	ETF	203.7	203.7	203.43	203.51	1077471.0
2016-04-11 18:30:00	SPY	ETF	203.48	203.55	203.48	203.54	41791.0
2016-04-11 19:00:00	SPY	ETF	203.57	203.61	203.54	203.58	24524.0
2016-04-11 19:30:00	SPY	ETF	203.58	203.71	203.57	203.63	33573.0
2016-04-11 04:00:00	QQQ	ETF	109.51	109.51	109.47	109.47	549.0
2016-04-11 06:00:00	QQQ	ETF	109.39	109.39	109.39	109.39	1000.0
2016-04-11 06:30:00	QQQ	ETF	109.52	109.52	109.48	109.48	9499.0
2016-04-11 07:00:00	QQQ	ETF	109.41	109.41	109.41	109.41	300.0
2016-04-11 07:30:00	QQQ	ETF	109.42	109.54	109.42	109.44	28811.0
2016-04-11 08:00:00	QQQ	ETF	109.42	109.44	109.37	109.37	46695.0
2016-04-11 08:30:00	QQQ	ETF	109.41	109.59	109.38	109.59	34741.0
2016-04-11 09:00:00	QQQ	ETF	109.6	109.63	109.47	109.49	71726.0
2016-04-11 09:30:00	QQQ	ETF	109.48	109.72	109.3	109.67	3157818.0
2016-04-11 10:00:00	QQQ	ETF	109.675	110.02	109.675	109.86	2027910.0
2016-04-11 10:30:00	QQQ	ETF	109.87	109.96	109.42	109.448	1820964.0
2016-04-11 11:00:00	QQQ	ETF	109.44	109.64	109.34	109.56	1533069.0
2016-04-11 11:30:00	QQQ	ETF	109.56	109.58	109.1201	109.42	1050842.0
2016-04-11 12:00:00	QQQ	ETF	109.42	109.59	109.33	109.53	607458.0
2016-04-11 12:30:00	QQQ	ETF	109.53	109.76	109.36	109.735	1008862.0
2016-04-11 13:00:00	QQQ	ETF	109.73	109.82	109.56	109.59	612346.0
2016-04-11 13:30:00	QQQ	ETF	109.59	109.71	109.4	109.47	757401.0
2016-04-11 14:00:00	QQQ	ETF	109.48	109.6	109.27	109.325	1414393.0

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

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