PREVIEW / etf_30min / 2016-03-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-22.parquet
  size:    392 KB
  rows:    13,216

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-03-22 04:00:00	SPY	ETF	204.0	204.17	203.5	203.5	49762.0
2016-03-22 04:30:00	SPY	ETF	203.52	203.9	203.36	203.87	62783.0
2016-03-22 05:00:00	SPY	ETF	204.0	204.25	203.92	204.07	34981.0
2016-03-22 05:30:00	SPY	ETF	204.02	204.5	204.02	204.26	39911.0
2016-03-22 06:00:00	SPY	ETF	204.24	204.39	203.75	203.8	61432.0
2016-03-22 06:30:00	SPY	ETF	203.87	204.08	203.84	204.0	142006.0
2016-03-22 07:00:00	SPY	ETF	204.02	204.32	204.0	204.26	69508.0
2016-03-22 07:30:00	SPY	ETF	204.18	204.2	203.82	203.91	153180.0
2016-03-22 08:00:00	SPY	ETF	203.93	204.585	203.75	203.96	364264.0
2016-03-22 08:30:00	SPY	ETF	203.96	204.08	203.94	204.01	301531.0
2016-03-22 09:00:00	SPY	ETF	204.01	204.04	203.58	203.75	819761.0
2016-03-22 09:30:00	SPY	ETF	203.76	204.23	203.57	204.18	9432894.0
2016-03-22 10:00:00	SPY	ETF	204.18	204.45	204.05	204.395	5104764.0
2016-03-22 10:30:00	SPY	ETF	204.38	204.69	204.291	204.525	4616231.0
2016-03-22 11:00:00	SPY	ETF	204.53	204.78	204.43	204.66	3892701.0
2016-03-22 11:30:00	SPY	ETF	204.66	204.7	204.28	204.35	4817537.0
2016-03-22 12:00:00	SPY	ETF	204.345	204.85	204.3424	204.8	4124952.0
2016-03-22 12:30:00	SPY	ETF	204.79	205.15	204.68	205.1489	4682218.0
2016-03-22 13:00:00	SPY	ETF	205.14	205.19	205.0	205.145	3176535.0
2016-03-22 13:30:00	SPY	ETF	205.145	205.23	204.93	205.01	4380406.0
2016-03-22 14:00:00	SPY	ETF	205.02	205.18	204.86	205.1044	7006682.0
2016-03-22 14:30:00	SPY	ETF	205.1	205.22	204.73	204.73	6970761.0
2016-03-22 15:00:00	SPY	ETF	204.7201	204.8	204.31	204.53	9730078.0
2016-03-22 15:30:00	SPY	ETF	204.53	204.7	204.42	204.59	12642606.0
2016-03-22 16:00:00	SPY	ETF	204.59	204.75	204.51	204.73	9391204.0
2016-03-22 16:30:00	SPY	ETF	204.74	204.79	204.56	204.79	401439.0
2016-03-22 17:00:00	SPY	ETF	204.78	204.78	204.66	204.73	120610.0
2016-03-22 17:30:00	SPY	ETF	204.73	204.75	204.7	204.74	106254.0
2016-03-22 18:00:00	SPY	ETF	204.74	204.76	204.6	204.64	127514.0
2016-03-22 18:30:00	SPY	ETF	204.63	204.65	204.54	204.57	89032.0
2016-03-22 19:00:00	SPY	ETF	204.56	204.58	204.52	204.53	54182.0
2016-03-22 19:30:00	SPY	ETF	204.53	204.68	204.5	204.66	63761.0
2016-03-22 20:00:00	SPY	ETF	204.5301	204.5301	204.5301	204.5301	450000.0
2016-03-22 04:00:00	QQQ	ETF	107.32	107.32	107.32	107.32	344.0
2016-03-22 04:30:00	QQQ	ETF	107.04	107.19	107.0	107.18	6300.0
2016-03-22 05:00:00	QQQ	ETF	107.35	107.35	107.35	107.35	1000.0
2016-03-22 05:30:00	QQQ	ETF	107.51	107.55	107.48	107.55	2798.0
2016-03-22 06:00:00	QQQ	ETF	107.43	107.43	107.37	107.37	300.0
2016-03-22 06:30:00	QQQ	ETF	107.32	107.33	107.22	107.25	9414.0
2016-03-22 07:00:00	QQQ	ETF	107.38	107.49	107.38	107.45	16672.0
2016-03-22 07:30:00	QQQ	ETF	107.36	107.41	107.22	107.26	16186.0
2016-03-22 08:00:00	QQQ	ETF	107.3	107.37	107.19	107.25	43986.0
2016-03-22 08:30:00	QQQ	ETF	107.25	107.33	107.25	107.3	27996.0
2016-03-22 09:00:00	QQQ	ETF	107.26	107.29	107.1	107.18	57413.0
2016-03-22 09:30:00	QQQ	ETF	107.19	107.77	107.16	107.67	2180556.0
2016-03-22 10:00:00	QQQ	ETF	107.68	107.84	107.6	107.81	1632806.0
2016-03-22 10:30:00	QQQ	ETF	107.81	107.98	107.76	107.8782	906840.0
2016-03-22 11:00:00	QQQ	ETF	107.88	108.06	107.835	107.995	891881.0
2016-03-22 11:30:00	QQQ	ETF	108.0	108.03	107.78	107.81	940544.0
2016-03-22 12:00:00	QQQ	ETF	107.81	108.05	107.7875	108.02	900077.0

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

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