PREVIEW / etf_30min / 2015-02-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-05.parquet
  size:    382 KB
  rows:    12,894

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-02-05 04:00:00	SPY	ETF	203.8	204.12	203.8	204.1	7374.0
2015-02-05 04:30:00	SPY	ETF	204.1	204.65	204.1	204.55	79964.0
2015-02-05 05:00:00	SPY	ETF	204.56	204.79	204.47	204.6	34800.0
2015-02-05 05:30:00	SPY	ETF	204.6	204.6	204.42	204.51	5600.0
2015-02-05 06:00:00	SPY	ETF	204.5	204.52	204.36	204.44	9129.0
2015-02-05 06:30:00	SPY	ETF	204.42	204.53	204.26	204.51	34261.0
2015-02-05 07:00:00	SPY	ETF	204.51	205.07	204.45	204.83	432604.0
2015-02-05 07:30:00	SPY	ETF	204.82	205.08	204.74	204.76	340849.0
2015-02-05 08:00:00	SPY	ETF	204.47	205.05	203.12	204.86	697781.0
2015-02-05 08:30:00	SPY	ETF	204.96	205.22	204.75	204.91	838213.0
2015-02-05 09:00:00	SPY	ETF	204.9	204.99	204.69	204.86	836113.0
2015-02-05 09:30:00	SPY	ETF	204.86	205.69	204.77	205.33	14914726.0
2015-02-05 10:00:00	SPY	ETF	205.34	205.74	205.26	205.58	6537317.0
2015-02-05 10:30:00	SPY	ETF	205.58	205.936	205.44	205.79	6819734.0
2015-02-05 11:00:00	SPY	ETF	205.79	205.88	205.47	205.69	5653532.0
2015-02-05 11:30:00	SPY	ETF	205.7	205.9	205.6	205.765	4402768.0
2015-02-05 12:00:00	SPY	ETF	205.76	205.82	205.44	205.49	2365207.0
2015-02-05 12:30:00	SPY	ETF	205.51	205.71	205.31	205.45	2382789.0
2015-02-05 13:00:00	SPY	ETF	205.45	205.8	205.4	205.75	3263819.0
2015-02-05 13:30:00	SPY	ETF	205.76	205.94	205.69	205.7701	3815188.0
2015-02-05 14:00:00	SPY	ETF	205.77	206.0	205.57	205.75	5918728.0
2015-02-05 14:30:00	SPY	ETF	205.76	205.89	205.54	205.785	4800850.0
2015-02-05 15:00:00	SPY	ETF	205.79	206.14	205.65	206.11	6618218.0
2015-02-05 15:30:00	SPY	ETF	206.12	206.3	205.97	206.18	17459270.0
2015-02-05 16:00:00	SPY	ETF	206.19	206.19	204.0722	204.0722	4106573.0
2015-02-05 16:30:00	SPY	ETF	205.98	206.12	205.98	206.11	828258.0
2015-02-05 17:00:00	SPY	ETF	206.11	206.18	206.02	206.03	101000.0
2015-02-05 17:30:00	SPY	ETF	206.02	206.06	206.0	206.06	29683.0
2015-02-05 18:00:00	SPY	ETF	206.07	206.15	206.05	206.07	62688.0
2015-02-05 18:30:00	SPY	ETF	206.07	206.08	205.97	205.97	45179.0
2015-02-05 19:00:00	SPY	ETF	205.95	205.95	205.86	205.88	55416.0
2015-02-05 19:30:00	SPY	ETF	205.94	205.98	205.92	205.96	64329.0
2015-02-05 04:00:00	QQQ	ETF	102.72	102.8	102.72	102.73	1300.0
2015-02-05 04:30:00	QQQ	ETF	102.87	102.99	102.87	102.99	18986.0
2015-02-05 05:00:00	QQQ	ETF	103.01	103.11	103.0	103.04	5600.0
2015-02-05 05:30:00	QQQ	ETF	102.94	102.94	102.94	102.94	300.0
2015-02-05 06:00:00	QQQ	ETF	102.94	102.94	102.85	102.88	10150.0
2015-02-05 06:30:00	QQQ	ETF	102.9	102.99	102.8	102.99	20400.0
2015-02-05 07:00:00	QQQ	ETF	102.96	103.19	102.96	103.0	49563.0
2015-02-05 07:30:00	QQQ	ETF	103.09	103.2	103.05	103.05	4653.0
2015-02-05 08:00:00	QQQ	ETF	103.05	103.18	103.0	103.14	78298.0
2015-02-05 08:30:00	QQQ	ETF	103.15	103.29	103.07	103.13	108454.0
2015-02-05 09:00:00	QQQ	ETF	103.15	103.17	102.87	103.11	190846.0
2015-02-05 09:30:00	QQQ	ETF	103.13	103.4869	102.87	103.31	3436264.0
2015-02-05 10:00:00	QQQ	ETF	103.315	103.45	103.13	103.37	2329945.0
2015-02-05 10:30:00	QQQ	ETF	103.38	103.57	103.33	103.48	1570281.0
2015-02-05 11:00:00	QQQ	ETF	103.48	103.54	103.34	103.485	930634.0
2015-02-05 11:30:00	QQQ	ETF	103.5	103.56	103.4	103.475	724358.0
2015-02-05 12:00:00	QQQ	ETF	103.48	103.51	103.3	103.325	703176.0
2015-02-05 12:30:00	QQQ	ETF	103.33	103.44	103.2228	103.3	602076.0

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

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