PREVIEW / etf_30min / 2016-05-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-06.parquet
  size:    389 KB
  rows:    13,120

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-05-06 04:00:00	SPY	ETF	204.74	204.97	204.74	204.84	9822.0
2016-05-06 04:30:00	SPY	ETF	204.77	204.99	204.72	204.97	4219.0
2016-05-06 05:00:00	SPY	ETF	204.82	204.82	204.73	204.73	942.0
2016-05-06 05:30:00	SPY	ETF	204.68	204.7	204.59	204.59	11514.0
2016-05-06 06:00:00	SPY	ETF	204.59	204.61	204.43	204.44	10971.0
2016-05-06 06:30:00	SPY	ETF	204.41	204.5	204.3	204.47	40085.0
2016-05-06 07:00:00	SPY	ETF	204.45	204.46	204.35	204.35	63267.0
2016-05-06 07:30:00	SPY	ETF	204.38	204.48	204.26	204.47	339376.0
2016-05-06 08:00:00	SPY	ETF	204.45	204.571	204.3	204.48	824362.0
2016-05-06 08:30:00	SPY	ETF	204.42	204.43	203.6	203.82	2952526.0
2016-05-06 09:00:00	SPY	ETF	203.82	204.305	203.81	204.05	1894971.0
2016-05-06 09:30:00	SPY	ETF	204.06	205.17	204.0	204.64	11655539.0
2016-05-06 10:00:00	SPY	ETF	204.64	205.08	204.28	204.5	6842044.0
2016-05-06 10:30:00	SPY	ETF	204.49	204.64	203.88	204.04	7690979.0
2016-05-06 11:00:00	SPY	ETF	204.04	204.71	204.02	204.64	6096443.0
2016-05-06 11:30:00	SPY	ETF	204.64	204.73	204.31	204.32	3291840.0
2016-05-06 12:00:00	SPY	ETF	204.32	204.52	204.27	204.3362	2292439.0
2016-05-06 12:30:00	SPY	ETF	204.34	204.64	204.22	204.62	2617148.0
2016-05-06 13:00:00	SPY	ETF	204.63	205.08	204.6	204.935	4044957.0
2016-05-06 13:30:00	SPY	ETF	204.93	205.34	204.78	205.34	3225402.0
2016-05-06 14:00:00	SPY	ETF	205.34	205.74	205.28	205.54	5704545.0
2016-05-06 14:30:00	SPY	ETF	205.545	205.77	205.41	205.5	4540675.0
2016-05-06 15:00:00	SPY	ETF	205.5	205.72	205.47	205.6	4410509.0
2016-05-06 15:30:00	SPY	ETF	205.59	205.7201	205.27	205.7	10554352.0
2016-05-06 16:00:00	SPY	ETF	205.71	205.86	204.9538	205.81	6353647.0
2016-05-06 16:30:00	SPY	ETF	205.81	205.94	205.72	205.93	1083504.0
2016-05-06 17:00:00	SPY	ETF	205.93	205.93	205.84	205.84	335783.0
2016-05-06 17:30:00	SPY	ETF	205.83	205.96	205.7	205.94	1165518.0
2016-05-06 18:00:00	SPY	ETF	205.93	205.96	205.81	205.82	73428.0
2016-05-06 18:30:00	SPY	ETF	205.82	205.85	205.82	205.85	10203.0
2016-05-06 19:00:00	SPY	ETF	205.83	205.85	205.83	205.84	3426.0
2016-05-06 19:30:00	SPY	ETF	205.86	205.88	205.83	205.87	19123.0
2016-05-06 04:00:00	QQQ	ETF	104.98	104.98	104.98	104.98	100.0
2016-05-06 05:30:00	QQQ	ETF	104.78	104.9	104.78	104.78	27695.0
2016-05-06 06:30:00	QQQ	ETF	104.73	104.8	104.73	104.75	29592.0
2016-05-06 07:00:00	QQQ	ETF	104.74	104.78	104.7	104.7	20522.0
2016-05-06 07:30:00	QQQ	ETF	104.69	104.85	104.68	104.81	136309.0
2016-05-06 08:00:00	QQQ	ETF	104.78	104.87	104.71	104.84	401209.0
2016-05-06 08:30:00	QQQ	ETF	104.79	104.79	104.31	104.5	219869.0
2016-05-06 09:00:00	QQQ	ETF	104.5	104.68	104.47	104.51	126654.0
2016-05-06 09:30:00	QQQ	ETF	104.51	105.25	104.5	104.81	2913103.0
2016-05-06 10:00:00	QQQ	ETF	104.81	105.07	104.56	104.72	2181130.0
2016-05-06 10:30:00	QQQ	ETF	104.71	104.83	104.4	104.5	1300675.0
2016-05-06 11:00:00	QQQ	ETF	104.51	104.84	104.48	104.82	1310709.0
2016-05-06 11:30:00	QQQ	ETF	104.81	104.82	104.5	104.51	1117420.0
2016-05-06 12:00:00	QQQ	ETF	104.51	104.62	104.43	104.54	921813.0
2016-05-06 12:30:00	QQQ	ETF	104.53	104.78	104.48	104.77	836964.0
2016-05-06 13:00:00	QQQ	ETF	104.77	105.08	104.77	104.99	1344307.0
2016-05-06 13:30:00	QQQ	ETF	105.0	105.28	104.92	105.2701	852652.0
2016-05-06 14:00:00	QQQ	ETF	105.28	105.56	105.24	105.36	2940094.0

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

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