PREVIEW / etf_30min / 2015-02-25

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-25.parquet
  size:    372 KB
  rows:    12,510

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-25 04:00:00	SPY	ETF	211.77	211.77	211.71	211.71	4500.0
2015-02-25 04:30:00	SPY	ETF	211.59	211.64	211.59	211.61	1300.0
2015-02-25 05:00:00	SPY	ETF	211.6	211.71	211.6	211.71	1000.0
2015-02-25 05:30:00	SPY	ETF	211.74	211.74	211.69	211.69	3616.0
2015-02-25 06:00:00	SPY	ETF	211.69	211.69	211.57	211.58	1400.0
2015-02-25 06:30:00	SPY	ETF	211.61	211.67	211.55	211.56	1800.0
2015-02-25 07:00:00	SPY	ETF	211.55	211.62	211.51	211.62	58572.0
2015-02-25 07:30:00	SPY	ETF	211.64	211.71	211.64	211.68	36302.0
2015-02-25 08:00:00	SPY	ETF	211.68	211.71	211.62	211.67	105298.0
2015-02-25 08:30:00	SPY	ETF	211.66	211.69	211.62	211.66	129947.0
2015-02-25 09:00:00	SPY	ETF	211.66	211.7	211.6	211.66	139088.0
2015-02-25 09:30:00	SPY	ETF	211.66	211.78	211.37	211.52	6478051.0
2015-02-25 10:00:00	SPY	ETF	211.5	211.65	211.44	211.51	4387075.0
2015-02-25 10:30:00	SPY	ETF	211.5	211.74	211.41	211.64	3197387.0
2015-02-25 11:00:00	SPY	ETF	211.64	211.79	211.495	211.74	3180312.0
2015-02-25 11:30:00	SPY	ETF	211.73	211.92	211.69	211.78	3315901.0
2015-02-25 12:00:00	SPY	ETF	211.78	211.87	211.77	211.79	2384373.0
2015-02-25 12:30:00	SPY	ETF	211.79	211.95	211.79	211.88	2088732.0
2015-02-25 13:00:00	SPY	ETF	211.88	212.0	211.81	211.993	2311124.0
2015-02-25 13:30:00	SPY	ETF	211.995	212.24	211.99	212.14	3718855.0
2015-02-25 14:00:00	SPY	ETF	212.14	212.17	211.83	211.92	3692255.0
2015-02-25 14:30:00	SPY	ETF	211.91	211.96	211.33	211.5641	7843990.0
2015-02-25 15:00:00	SPY	ETF	211.565	211.58	211.22	211.27	6447055.0
2015-02-25 15:30:00	SPY	ETF	211.27	211.71	211.27	211.61	16819915.0
2015-02-25 16:00:00	SPY	ETF	211.62	211.7	211.49	211.56	2420592.0
2015-02-25 16:30:00	SPY	ETF	211.57	211.8137	211.51	211.8137	1638997.0
2015-02-25 17:00:00	SPY	ETF	211.57	211.59	211.52	211.52	551430.0
2015-02-25 17:30:00	SPY	ETF	211.52	211.54	211.48	211.49	72486.0
2015-02-25 18:00:00	SPY	ETF	211.5	211.53	211.44	211.52	79454.0
2015-02-25 18:30:00	SPY	ETF	211.55	211.57	211.48	211.48	15100.0
2015-02-25 19:00:00	SPY	ETF	211.5	211.53	211.5	211.53	7825.0
2015-02-25 19:30:00	SPY	ETF	211.54	211.59	211.54	211.58	12210.0
2015-02-25 04:00:00	QQQ	ETF	108.45	108.45	108.45	108.45	200.0
2015-02-25 06:00:00	QQQ	ETF	108.42	108.44	108.4	108.44	8450.0
2015-02-25 06:30:00	QQQ	ETF	108.43	108.45	108.42	108.42	3000.0
2015-02-25 07:00:00	QQQ	ETF	108.42	108.45	108.38	108.44	5300.0
2015-02-25 07:30:00	QQQ	ETF	108.45	108.47	108.45	108.47	12843.0
2015-02-25 08:00:00	QQQ	ETF	108.46	108.48	108.44	108.45	31952.0
2015-02-25 08:30:00	QQQ	ETF	108.46	108.46	108.39	108.41	64249.0
2015-02-25 09:00:00	QQQ	ETF	108.41	108.44	108.41	108.43	22892.0
2015-02-25 09:30:00	QQQ	ETF	108.43	108.48	108.3051	108.46	1942260.0
2015-02-25 10:00:00	QQQ	ETF	108.45	108.58	108.43	108.44	997654.0
2015-02-25 10:30:00	QQQ	ETF	108.445	108.64	108.41	108.6199	1223816.0
2015-02-25 11:00:00	QQQ	ETF	108.61	108.675	108.54	108.65	876496.0
2015-02-25 11:30:00	QQQ	ETF	108.65	108.73	108.61	108.615	777661.0
2015-02-25 12:00:00	QQQ	ETF	108.62	108.68	108.6	108.61	536178.0
2015-02-25 12:30:00	QQQ	ETF	108.61	108.79	108.58	108.73	911520.0
2015-02-25 13:00:00	QQQ	ETF	108.735	108.79	108.68	108.79	429963.0
2015-02-25 13:30:00	QQQ	ETF	108.78	108.86	108.77	108.8	1131213.0
2015-02-25 14:00:00	QQQ	ETF	108.79	108.81	108.62	108.68	1116905.0

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

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