PREVIEW / etf_30min / 2016-04-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-07.parquet
  size:    392 KB
  rows:    13,218

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-04-07 04:00:00	SPY	ETF	206.0	206.21	206.0	206.17	18741.0
2016-04-07 04:30:00	SPY	ETF	206.19	206.2	205.94	205.94	14978.0
2016-04-07 05:00:00	SPY	ETF	205.96	205.96	205.52	205.54	37544.0
2016-04-07 05:30:00	SPY	ETF	205.52	205.54	205.24	205.44	210473.0
2016-04-07 06:00:00	SPY	ETF	205.44	205.6	205.3	205.45	54580.0
2016-04-07 06:30:00	SPY	ETF	205.41	205.54	205.34	205.4	31035.0
2016-04-07 07:00:00	SPY	ETF	205.45	205.67	205.45	205.46	223338.0
2016-04-07 07:30:00	SPY	ETF	205.49	205.53	205.21	205.36	145257.0
2016-04-07 08:00:00	SPY	ETF	206.12	206.12	205.26	205.53	320581.0
2016-04-07 08:30:00	SPY	ETF	205.52	205.57	205.33	205.45	399153.0
2016-04-07 09:00:00	SPY	ETF	205.43	205.51	205.08	205.15	821310.0
2016-04-07 09:30:00	SPY	ETF	205.14	205.49	205.02	205.3	9488183.0
2016-04-07 10:00:00	SPY	ETF	205.31	205.56	204.5199	204.54	8359158.0
2016-04-07 10:30:00	SPY	ETF	204.54	204.79	204.44	204.66	7953230.0
2016-04-07 11:00:00	SPY	ETF	204.66	204.675	204.18	204.43	6793341.0
2016-04-07 11:30:00	SPY	ETF	204.42	204.69	204.4	204.51	4820947.0
2016-04-07 12:00:00	SPY	ETF	204.515	204.57	204.07	204.24	5539581.0
2016-04-07 12:30:00	SPY	ETF	204.24	204.5	204.04	204.42	4417031.0
2016-04-07 13:00:00	SPY	ETF	204.43	204.77	204.36	204.52	3391495.0
2016-04-07 13:30:00	SPY	ETF	204.52	204.64	203.76	203.83	5886515.0
2016-04-07 14:00:00	SPY	ETF	203.83	203.83	203.24	203.52	10132938.0
2016-04-07 14:30:00	SPY	ETF	203.53	203.73	203.125	203.17	8238770.0
2016-04-07 15:00:00	SPY	ETF	203.17	203.81	203.09	203.73	9130162.0
2016-04-07 15:30:00	SPY	ETF	203.73	204.07	203.55	203.94	18603883.0
2016-04-07 16:00:00	SPY	ETF	203.94	206.3979	203.7726	203.93	4085322.0
2016-04-07 16:30:00	SPY	ETF	203.93	206.3979	203.88	203.96	718616.0
2016-04-07 17:00:00	SPY	ETF	203.96	203.98	203.87	203.87	342540.0
2016-04-07 17:30:00	SPY	ETF	203.86	203.88	203.84	203.88	176161.0
2016-04-07 18:00:00	SPY	ETF	203.85	203.85	203.58	203.6	759293.0
2016-04-07 18:30:00	SPY	ETF	203.59	203.67	203.56	203.62	138438.0
2016-04-07 19:00:00	SPY	ETF	203.64	203.68	203.57	203.62	161468.0
2016-04-07 19:30:00	SPY	ETF	203.61	203.64	203.43	203.45	353548.0
2016-04-07 04:00:00	QQQ	ETF	110.5	110.5	110.5	110.5	100.0
2016-04-07 04:30:00	QQQ	ETF	110.53	110.53	110.39	110.39	2400.0
2016-04-07 05:00:00	QQQ	ETF	110.33	110.33	110.33	110.33	1400.0
2016-04-07 05:30:00	QQQ	ETF	110.04	110.04	110.04	110.04	264.0
2016-04-07 06:00:00	QQQ	ETF	110.05	110.2	110.05	110.19	30299.0
2016-04-07 06:30:00	QQQ	ETF	110.17	110.19	110.16	110.16	11773.0
2016-04-07 07:00:00	QQQ	ETF	110.24	110.24	110.16	110.17	2479.0
2016-04-07 07:30:00	QQQ	ETF	110.15	110.15	110.01	110.1	16869.0
2016-04-07 08:00:00	QQQ	ETF	110.18	110.26	110.04	110.19	74317.0
2016-04-07 08:30:00	QQQ	ETF	110.19	110.22	110.11	110.17	35641.0
2016-04-07 09:00:00	QQQ	ETF	110.16	110.21	110.01	110.03	46755.0
2016-04-07 09:30:00	QQQ	ETF	110.04	110.225	109.8	109.9401	2782749.0
2016-04-07 10:00:00	QQQ	ETF	109.95	110.155	109.5	109.52	1994048.0
2016-04-07 10:30:00	QQQ	ETF	109.52	109.64	109.34	109.379	2046393.0
2016-04-07 11:00:00	QQQ	ETF	109.371	109.41	109.11	109.32	2057849.0
2016-04-07 11:30:00	QQQ	ETF	109.31	109.53	109.3	109.38	1484105.0
2016-04-07 12:00:00	QQQ	ETF	109.3886	109.44	109.18	109.32	1252264.0
2016-04-07 12:30:00	QQQ	ETF	109.31	109.425	109.15	109.3701	812499.0

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

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