PREVIEW / etf_30min / 2016-03-17

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-17.parquet
  size:    406 KB
  rows:    13,639

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-17 04:00:00	SPY	ETF	203.94	204.26	203.93	204.06	9741.0
2016-03-17 04:30:00	SPY	ETF	204.15	204.27	204.06	204.06	14851.0
2016-03-17 05:00:00	SPY	ETF	204.0	204.0	203.55	203.78	15724.0
2016-03-17 05:30:00	SPY	ETF	203.74	203.74	202.89	203.07	45215.0
2016-03-17 06:00:00	SPY	ETF	202.86	203.13	202.56	202.57	58122.0
2016-03-17 06:30:00	SPY	ETF	202.57	202.69	202.17	202.5	112477.0
2016-03-17 07:00:00	SPY	ETF	202.56	202.74	202.41	202.72	139880.0
2016-03-17 07:30:00	SPY	ETF	202.72	202.8	202.42	202.47	271531.0
2016-03-17 08:00:00	SPY	ETF	202.47	203.76	202.3	202.66	952385.0
2016-03-17 08:30:00	SPY	ETF	202.66	203.34	202.65	202.81	519339.0
2016-03-17 09:00:00	SPY	ETF	202.82	203.32	202.74	203.24	719490.0
2016-03-17 09:30:00	SPY	ETF	203.24	203.48	202.79	203.015	7942222.0
2016-03-17 10:00:00	SPY	ETF	203.02	203.3	202.77	203.285	6229822.0
2016-03-17 10:30:00	SPY	ETF	203.28	203.88	203.205	203.84	7632398.0
2016-03-17 11:00:00	SPY	ETF	203.85	204.12	203.705	204.025	10834453.0
2016-03-17 11:30:00	SPY	ETF	204.025	204.09	203.8	204.06	6619800.0
2016-03-17 12:00:00	SPY	ETF	204.07	204.435	203.895	204.43	5211110.0
2016-03-17 12:30:00	SPY	ETF	204.42	204.67	204.4	204.49	9219558.0
2016-03-17 13:00:00	SPY	ETF	204.5	204.6	204.25	204.41	8257616.0
2016-03-17 13:30:00	SPY	ETF	204.41	204.91	204.31	204.9	6103763.0
2016-03-17 14:00:00	SPY	ETF	204.89	205.23	204.77	204.97	11043653.0
2016-03-17 14:30:00	SPY	ETF	204.97	205.01	204.69	204.71	5451579.0
2016-03-17 15:00:00	SPY	ETF	204.71	205.05	204.67	205.0	7306985.0
2016-03-17 15:30:00	SPY	ETF	205.0	205.14	204.61	204.65	19055484.0
2016-03-17 16:00:00	SPY	ETF	204.65	204.86	203.2993	204.65	10335959.0
2016-03-17 16:30:00	SPY	ETF	204.65	204.79	204.6	204.7	323983.0
2016-03-17 17:00:00	SPY	ETF	204.71	204.73	204.64	204.65	1086516.0
2016-03-17 17:30:00	SPY	ETF	204.67	204.75	204.66	204.7	61751.0
2016-03-17 18:00:00	SPY	ETF	204.7	204.78	204.634	204.78	1795473.0
2016-03-17 18:30:00	SPY	ETF	204.78	204.79	204.68	204.78	15190.0
2016-03-17 19:00:00	SPY	ETF	204.78	204.78	204.65	204.71	55951.0
2016-03-17 19:30:00	SPY	ETF	204.75	204.93	204.75	204.77	66293.0
2016-03-17 04:00:00	QQQ	ETF	107.82	107.83	107.82	107.83	200.0
2016-03-17 04:30:00	QQQ	ETF	107.94	107.96	107.86	107.86	2000.0
2016-03-17 05:00:00	QQQ	ETF	107.81	107.81	107.73	107.73	2600.0
2016-03-17 05:30:00	QQQ	ETF	107.59	107.59	107.09	107.09	2600.0
2016-03-17 06:00:00	QQQ	ETF	107.2	107.2	106.98	106.98	13637.0
2016-03-17 06:30:00	QQQ	ETF	106.9	106.94	106.75	106.94	5098.0
2016-03-17 07:00:00	QQQ	ETF	106.9	107.0	106.88	106.96	10765.0
2016-03-17 07:30:00	QQQ	ETF	106.96	107.0	106.81	106.83	45479.0
2016-03-17 08:00:00	QQQ	ETF	106.85	107.02	106.79	106.91	72834.0
2016-03-17 08:30:00	QQQ	ETF	106.99	107.09	106.98	107.01	77722.0
2016-03-17 09:00:00	QQQ	ETF	107.02	107.29	106.99	107.26	117495.0
2016-03-17 09:30:00	QQQ	ETF	107.26	107.54	107.02	107.075	2836895.0
2016-03-17 10:00:00	QQQ	ETF	107.08	107.165	106.87	107.12	1942388.0
2016-03-17 10:30:00	QQQ	ETF	107.12	107.3534	107.05	107.35	1542046.0
2016-03-17 11:00:00	QQQ	ETF	107.34	107.39	107.21	107.27	1400715.0
2016-03-17 11:30:00	QQQ	ETF	107.28	107.32	107.18	107.301	920390.0
2016-03-17 12:00:00	QQQ	ETF	107.31	107.62	107.2	107.6189	1214772.0
2016-03-17 12:30:00	QQQ	ETF	107.61	107.7	107.51	107.5364	1391611.0

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

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