PREVIEW / etf_30min / 2015-01-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-09.parquet
  size:    381 KB
  rows:    12,754

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-09 04:00:00	SPY	ETF	205.75	205.78	205.75	205.78	500.0
2015-01-09 04:30:00	SPY	ETF	205.73	205.73	205.45	205.48	8484.0
2015-01-09 05:00:00	SPY	ETF	205.48	205.58	205.48	205.53	1300.0
2015-01-09 05:30:00	SPY	ETF	205.55	205.58	205.44	205.46	8687.0
2015-01-09 06:00:00	SPY	ETF	205.58	205.67	205.52	205.64	10300.0
2015-01-09 06:30:00	SPY	ETF	205.61	205.61	205.09	205.15	170254.0
2015-01-09 07:00:00	SPY	ETF	205.2	205.37	205.1	205.17	91994.0
2015-01-09 07:30:00	SPY	ETF	205.17	205.22	205.05	205.1	135347.0
2015-01-09 08:00:00	SPY	ETF	205.4701	205.58	205.01	205.18	424234.0
2015-01-09 08:30:00	SPY	ETF	205.2	206.52	205.2	206.06	3990265.0
2015-01-09 09:00:00	SPY	ETF	206.05	206.4	205.9	206.4	845739.0
2015-01-09 09:30:00	SPY	ETF	206.4	206.42	204.82	205.01	15646769.0
2015-01-09 10:00:00	SPY	ETF	205.02	205.55	204.63	204.71	10702526.0
2015-01-09 10:30:00	SPY	ETF	204.71	204.71	203.97	204.47	16108943.0
2015-01-09 11:00:00	SPY	ETF	204.465	204.47	203.51	203.81	14521737.0
2015-01-09 11:30:00	SPY	ETF	203.8	204.56	203.52	204.5	8800972.0
2015-01-09 12:00:00	SPY	ETF	204.51	204.88	204.32	204.485	8385583.0
2015-01-09 12:30:00	SPY	ETF	204.48	204.64	204.06	204.08	4669672.0
2015-01-09 13:00:00	SPY	ETF	204.08	204.69	203.95	204.35	5342229.0
2015-01-09 13:30:00	SPY	ETF	204.36	204.67	204.17	204.42	9737584.0
2015-01-09 14:00:00	SPY	ETF	204.41	204.45	204.18	204.33	5830156.0
2015-01-09 14:30:00	SPY	ETF	204.33	204.67	204.12	204.51	7032026.0
2015-01-09 15:00:00	SPY	ETF	204.51	205.08	204.46	204.61	9906265.0
2015-01-09 15:30:00	SPY	ETF	204.6	204.77	204.18	204.18	20029790.0
2015-01-09 16:00:00	SPY	ETF	204.18	205.25	203.9	203.97	6683687.0
2015-01-09 16:30:00	SPY	ETF	203.98	204.02	203.86	203.88	4445377.0
2015-01-09 17:00:00	SPY	ETF	203.88	203.88	203.77	203.83	2119660.0
2015-01-09 17:30:00	SPY	ETF	203.83	204.25	203.79	203.84	1243787.0
2015-01-09 18:00:00	SPY	ETF	203.88	203.88	203.82	203.87	3002.0
2015-01-09 18:30:00	SPY	ETF	203.89	203.89	203.82	203.83	10821.0
2015-01-09 19:00:00	SPY	ETF	203.85	203.85	203.84	203.85	3123.0
2015-01-09 19:30:00	SPY	ETF	203.89	203.93	203.83	203.85	14415.0
2015-01-09 05:00:00	QQQ	ETF	103.2	103.2	103.2	103.2	800.0
2015-01-09 05:30:00	QQQ	ETF	103.2	103.24	103.17	103.17	9500.0
2015-01-09 06:00:00	QQQ	ETF	103.22	103.24	103.22	103.24	1300.0
2015-01-09 06:30:00	QQQ	ETF	103.14	103.14	103.05	103.05	7000.0
2015-01-09 07:00:00	QQQ	ETF	103.13	103.18	103.1	103.1	754.0
2015-01-09 07:30:00	QQQ	ETF	103.06	103.07	103.01	103.06	20481.0
2015-01-09 08:00:00	QQQ	ETF	103.04	103.14	102.96	102.96	72987.0
2015-01-09 08:30:00	QQQ	ETF	103.03	103.75	103.03	103.55	727367.0
2015-01-09 09:00:00	QQQ	ETF	103.48	103.63	103.3	103.61	304736.0
2015-01-09 09:30:00	QQQ	ETF	103.61	103.65	103.03	103.16	6610182.0
2015-01-09 10:00:00	QQQ	ETF	103.16	103.4	102.8	102.83	3439621.0
2015-01-09 10:30:00	QQQ	ETF	102.83	102.84	102.41	102.66	3877129.0
2015-01-09 11:00:00	QQQ	ETF	102.66	102.66	102.02	102.26	4396729.0
2015-01-09 11:30:00	QQQ	ETF	102.26	102.72	102.1	102.69	2232161.0
2015-01-09 12:00:00	QQQ	ETF	102.68	103.04	102.64	102.842	2225614.0
2015-01-09 12:30:00	QQQ	ETF	102.83	102.94	102.54	102.5599	1375505.0
2015-01-09 13:00:00	QQQ	ETF	102.56	102.89	102.48	102.72	1691507.0
2015-01-09 13:30:00	QQQ	ETF	102.72	102.89	102.61	102.76	1158482.0

> showing 50 of 12,754 rows — these rows as CSV

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