PREVIEW / etf_30min / 2015-01-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-20.parquet
  size:    392 KB
  rows:    13,251

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-01-20 04:00:00	SPY	ETF	202.0	202.25	202.0	202.25	1577.0
2015-01-20 04:30:00	SPY	ETF	202.07	202.07	201.99	201.99	950.0
2015-01-20 05:00:00	SPY	ETF	202.26	202.45	202.16	202.35	38012.0
2015-01-20 05:30:00	SPY	ETF	202.3	202.51	202.29	202.49	26225.0
2015-01-20 06:00:00	SPY	ETF	202.42	202.44	202.22	202.35	44485.0
2015-01-20 06:30:00	SPY	ETF	202.32	202.73	202.29	202.7	40240.0
2015-01-20 07:00:00	SPY	ETF	202.7	202.94	202.61	202.92	73188.0
2015-01-20 07:30:00	SPY	ETF	202.89	203.0	202.72	202.85	507926.0
2015-01-20 08:00:00	SPY	ETF	202.86	202.91	201.12	202.79	820525.0
2015-01-20 08:30:00	SPY	ETF	202.78	202.85	201.63	202.62	1049542.0
2015-01-20 09:00:00	SPY	ETF	202.62	202.62	202.15	202.43	1419129.0
2015-01-20 09:30:00	SPY	ETF	202.4	202.72	200.75	201.03	20349222.0
2015-01-20 10:00:00	SPY	ETF	201.04	201.575	200.77	201.45	12022325.0
2015-01-20 10:30:00	SPY	ETF	201.46	201.56	200.53	200.81	9210687.0
2015-01-20 11:00:00	SPY	ETF	200.82	201.12	200.51	200.98	7786296.0
2015-01-20 11:30:00	SPY	ETF	200.97	201.1	200.17	200.475	12442486.0
2015-01-20 12:00:00	SPY	ETF	200.46	200.835	200.3	200.755	4271564.0
2015-01-20 12:30:00	SPY	ETF	200.755	201.065	200.54	200.94	4897219.0
2015-01-20 13:00:00	SPY	ETF	200.93	201.38	200.57	201.24	5806013.0
2015-01-20 13:30:00	SPY	ETF	201.25	201.4299	201.06	201.2	4088305.0
2015-01-20 14:00:00	SPY	ETF	201.195	201.53	201.14	201.31	5966596.0
2015-01-20 14:30:00	SPY	ETF	201.31	202.17	201.31	202.16	7153786.0
2015-01-20 15:00:00	SPY	ETF	202.16	202.35	201.96	202.18	8120207.0
2015-01-20 15:30:00	SPY	ETF	202.19	202.24	201.77	202.04	12200739.0
2015-01-20 16:00:00	SPY	ETF	202.06	202.13	200.721	202.02	4819777.0
2015-01-20 16:30:00	SPY	ETF	202.01	202.08	201.91	201.94	1191375.0
2015-01-20 17:00:00	SPY	ETF	201.94	202.06	201.94	202.06	82464.0
2015-01-20 17:30:00	SPY	ETF	202.07	202.07	201.97	201.99	135867.0
2015-01-20 18:00:00	SPY	ETF	202.0	202.07	201.94	202.02	63838.0
2015-01-20 18:30:00	SPY	ETF	202.0301	202.15	202.03	202.1	16300.0
2015-01-20 19:00:00	SPY	ETF	202.09	202.09	201.95	201.98	23895.0
2015-01-20 19:30:00	SPY	ETF	201.99	202.0	201.91	201.95	13151.0
2015-01-20 04:00:00	QQQ	ETF	101.7	101.7	101.7	101.7	100.0
2015-01-20 04:30:00	QQQ	ETF	101.28	101.28	101.16	101.16	500.0
2015-01-20 05:00:00	QQQ	ETF	101.14	101.35	101.14	101.35	20500.0
2015-01-20 05:30:00	QQQ	ETF	101.38	101.42	101.38	101.42	2500.0
2015-01-20 06:30:00	QQQ	ETF	101.37	101.53	101.37	101.51	28200.0
2015-01-20 07:00:00	QQQ	ETF	101.51	101.65	101.47	101.65	16871.0
2015-01-20 07:30:00	QQQ	ETF	101.61	101.71	101.55	101.62	13623.0
2015-01-20 08:00:00	QQQ	ETF	101.62	101.64	101.54	101.61	50762.0
2015-01-20 08:30:00	QQQ	ETF	101.6	101.6	101.44	101.45	66354.0
2015-01-20 09:00:00	QQQ	ETF	101.46	101.48	101.25	101.43	570885.0
2015-01-20 09:30:00	QQQ	ETF	101.43	101.6458	100.61	100.79	5737488.0
2015-01-20 10:00:00	QQQ	ETF	100.78	101.14	100.66	100.98	3107543.0
2015-01-20 10:30:00	QQQ	ETF	100.99	101.02	100.5	100.64	1979014.0
2015-01-20 11:00:00	QQQ	ETF	100.64	100.875	100.47	100.75	1363161.0
2015-01-20 11:30:00	QQQ	ETF	100.74	100.81	100.29	100.52	1941664.0
2015-01-20 12:00:00	QQQ	ETF	100.51	100.74	100.415	100.69	953302.0
2015-01-20 12:30:00	QQQ	ETF	100.69	100.96	100.55	100.91	1041634.0
2015-01-20 13:00:00	QQQ	ETF	100.9	101.24	100.71	101.15	1424685.0

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

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