PREVIEW / etf_30min / 2017-05-22

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-22.parquet
  size:    428 KB
  rows:    14,752

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
2017-05-22 04:00:00	SPY	ETF	238.37	238.48	238.32	238.42	9827.0
2017-05-22 04:30:00	SPY	ETF	238.57	238.57	238.47	238.47	7411.0
2017-05-22 05:00:00	SPY	ETF	238.49	238.51	238.37	238.38	10516.0
2017-05-22 05:30:00	SPY	ETF	238.34	238.34	238.17	238.32	14663.0
2017-05-22 06:00:00	SPY	ETF	238.32	238.44	238.3	238.37	26771.0
2017-05-22 06:30:00	SPY	ETF	238.35	238.52	238.26	238.5	58883.0
2017-05-22 07:00:00	SPY	ETF	238.47	238.55	238.45	238.55	99485.0
2017-05-22 07:30:00	SPY	ETF	238.54	238.66	238.5	238.63	113320.0
2017-05-22 08:00:00	SPY	ETF	238.63	238.67	238.5	238.64	177786.0
2017-05-22 08:30:00	SPY	ETF	238.64	238.73	238.56	238.67	158796.0
2017-05-22 09:00:00	SPY	ETF	238.68	238.89	238.3165	238.89	857422.0
2017-05-22 09:30:00	SPY	ETF	238.9	239.36	238.84	239.23	7113989.0
2017-05-22 10:00:00	SPY	ETF	239.24	239.38	239.03	239.18	3943414.0
2017-05-22 10:30:00	SPY	ETF	239.18	239.23	238.82	238.955	3698156.0
2017-05-22 11:00:00	SPY	ETF	238.95	239.205	238.87	239.18	2694959.0
2017-05-22 11:30:00	SPY	ETF	239.17	239.27	239.09	239.265	2731177.0
2017-05-22 12:00:00	SPY	ETF	239.265	239.62	239.235	239.4865	2981461.0
2017-05-22 12:30:00	SPY	ETF	239.4808	239.53	239.38	239.3999	2324463.0
2017-05-22 13:00:00	SPY	ETF	239.3985	239.525	239.38	239.49	1657590.0
2017-05-22 13:30:00	SPY	ETF	239.49	239.54	239.34	239.35	1665905.0
2017-05-22 14:00:00	SPY	ETF	239.35	239.46	239.27	239.4597	2716196.0
2017-05-22 14:30:00	SPY	ETF	239.445	239.54	239.38	239.4362	1433811.0
2017-05-22 15:00:00	SPY	ETF	239.435	239.55	239.41	239.49	2885798.0
2017-05-22 15:30:00	SPY	ETF	239.495	239.71	239.43	239.53	8244250.0
2017-05-22 16:00:00	SPY	ETF	239.52	239.62	239.48	239.58	5374397.0
2017-05-22 16:30:00	SPY	ETF	239.58	239.67	239.52	239.67	1916758.0
2017-05-22 17:00:00	SPY	ETF	239.65	239.67	239.61	239.62	124138.0
2017-05-22 17:30:00	SPY	ETF	239.62	239.63	239.6	239.62	73039.0
2017-05-22 18:00:00	SPY	ETF	239.62	239.73	239.56	239.63	116006.0
2017-05-22 18:30:00	SPY	ETF	239.61	239.64	239.27	239.29	308616.0
2017-05-22 19:00:00	SPY	ETF	239.32	239.32	239.16	239.25	179284.0
2017-05-22 19:30:00	SPY	ETF	239.25	239.27	239.03	239.06	109031.0
2017-05-22 04:00:00	QQQ	ETF	138.0	138.0	137.9	137.95	2351.0
2017-05-22 04:30:00	QQQ	ETF	137.97	138.0	137.96	138.0	800.0
2017-05-22 05:00:00	QQQ	ETF	138.0	138.03	137.85	137.88	1369.0
2017-05-22 05:30:00	QQQ	ETF	137.86	137.86	137.79	137.82	20082.0
2017-05-22 06:00:00	QQQ	ETF	137.94	137.94	137.94	137.94	499.0
2017-05-22 06:30:00	QQQ	ETF	137.87	137.97	137.85	137.97	1568.0
2017-05-22 07:00:00	QQQ	ETF	137.95	137.98	137.95	137.97	3299.0
2017-05-22 07:30:00	QQQ	ETF	137.97	138.03	137.97	137.99	4501.0
2017-05-22 08:00:00	QQQ	ETF	138.03	138.03	137.85	137.88	27658.0
2017-05-22 08:30:00	QQQ	ETF	137.95	138.04	137.92	138.04	21422.0
2017-05-22 09:00:00	QQQ	ETF	138.04	138.15	138.04	138.14	46527.0
2017-05-22 09:30:00	QQQ	ETF	138.14	138.63	138.0967	138.58	2758930.0
2017-05-22 10:00:00	QQQ	ETF	138.575	138.66	138.48	138.61	1943595.0
2017-05-22 10:30:00	QQQ	ETF	138.62	138.67	138.491	138.56	1128095.0
2017-05-22 11:00:00	QQQ	ETF	138.55	138.73	138.515	138.69	1085381.0
2017-05-22 11:30:00	QQQ	ETF	138.69	138.82	138.66	138.8	798376.0
2017-05-22 12:00:00	QQQ	ETF	138.8	138.95	138.7461	138.8863	992644.0
2017-05-22 12:30:00	QQQ	ETF	138.885	138.92	138.84	138.86	738987.0

> showing 50 of 14,752 rows — these rows as CSV

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