PREVIEW / etf_30min / 2015-01-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-26.parquet
  size:    385 KB
  rows:    12,927

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-26 04:00:00	SPY	ETF	204.23	204.64	203.36	204.38	16359.0
2015-01-26 04:30:00	SPY	ETF	204.33	204.33	204.01	204.21	4500.0
2015-01-26 05:00:00	SPY	ETF	204.3	204.3	204.23	204.23	2800.0
2015-01-26 05:30:00	SPY	ETF	204.0	204.32	203.98	204.15	2000.0
2015-01-26 06:00:00	SPY	ETF	204.18	204.25	204.06	204.06	11119.0
2015-01-26 06:30:00	SPY	ETF	204.08	204.2	204.08	204.16	43800.0
2015-01-26 07:00:00	SPY	ETF	204.27	204.39	204.16	204.23	166482.0
2015-01-26 07:30:00	SPY	ETF	204.25	204.72	204.23	204.65	236723.0
2015-01-26 08:00:00	SPY	ETF	204.0378	204.73	204.0378	204.59	342380.0
2015-01-26 08:30:00	SPY	ETF	204.56	205.07	204.56	204.98	624711.0
2015-01-26 09:00:00	SPY	ETF	204.97	204.98	204.64	204.72	736555.0
2015-01-26 09:30:00	SPY	ETF	204.71	204.76	203.85	204.32	13727446.0
2015-01-26 10:00:00	SPY	ETF	204.33	204.74	204.23	204.56	7694601.0
2015-01-26 10:30:00	SPY	ETF	204.56	205.16	204.38	205.0249	6731738.0
2015-01-26 11:00:00	SPY	ETF	205.03	205.11	204.675	204.84	4812532.0
2015-01-26 11:30:00	SPY	ETF	204.84	205.2	204.63	205.12	4613880.0
2015-01-26 12:00:00	SPY	ETF	205.115	205.3	205.02	205.16	3850550.0
2015-01-26 12:30:00	SPY	ETF	205.16	205.215	204.82	204.99	3417484.0
2015-01-26 13:00:00	SPY	ETF	204.99	205.161	204.84	205.05	2491095.0
2015-01-26 13:30:00	SPY	ETF	205.045	205.56	205.045	205.43	4208319.0
2015-01-26 14:00:00	SPY	ETF	205.435	205.49	205.105	205.265	3779946.0
2015-01-26 14:30:00	SPY	ETF	205.26	205.39	205.03	205.17	3248849.0
2015-01-26 15:00:00	SPY	ETF	205.16	205.28	204.93	205.11	4874097.0
2015-01-26 15:30:00	SPY	ETF	205.11	205.56	205.03	205.46	12005934.0
2015-01-26 16:00:00	SPY	ETF	205.47	205.79	204.6594	205.73	8339741.0
2015-01-26 16:30:00	SPY	ETF	205.73	205.86	205.73	205.83	558753.0
2015-01-26 17:00:00	SPY	ETF	205.82	205.86	205.81	205.81	63410.0
2015-01-26 17:30:00	SPY	ETF	205.81	205.82	205.77	205.77	42529.0
2015-01-26 18:00:00	SPY	ETF	205.78	205.8	205.72	205.75	38659.0
2015-01-26 18:30:00	SPY	ETF	205.76	205.79	205.72	205.77	20495.0
2015-01-26 19:00:00	SPY	ETF	205.76	205.79	205.72	205.75	54894.0
2015-01-26 19:30:00	SPY	ETF	205.73	205.81	205.72	205.81	189940.0
2015-01-26 04:00:00	QQQ	ETF	104.09	104.09	104.09	104.09	806.0
2015-01-26 04:30:00	QQQ	ETF	103.98	103.98	103.94	103.94	4100.0
2015-01-26 05:00:00	QQQ	ETF	103.93	103.93	103.93	103.93	100.0
2015-01-26 06:00:00	QQQ	ETF	103.91	103.93	103.9	103.93	8500.0
2015-01-26 06:30:00	QQQ	ETF	103.91	103.99	103.9	103.96	11200.0
2015-01-26 07:00:00	QQQ	ETF	104.02	104.06	103.99	104.04	3000.0
2015-01-26 07:30:00	QQQ	ETF	104.02	104.23	104.0	104.21	14400.0
2015-01-26 08:00:00	QQQ	ETF	104.18	104.21	104.0	104.17	26845.0
2015-01-26 08:30:00	QQQ	ETF	104.18	104.39	104.17	104.3	209690.0
2015-01-26 09:00:00	QQQ	ETF	104.3	104.31	104.12	104.14	213243.0
2015-01-26 09:30:00	QQQ	ETF	104.13	104.17	103.61	103.84	4162704.0
2015-01-26 10:00:00	QQQ	ETF	103.85	104.01	103.71	103.83	1777367.0
2015-01-26 10:30:00	QQQ	ETF	103.84	104.13	103.75	104.1	1812275.0
2015-01-26 11:00:00	QQQ	ETF	104.1	104.19	103.83	103.93	1140751.0
2015-01-26 11:30:00	QQQ	ETF	103.93	104.05	103.78	104.0	972620.0
2015-01-26 12:00:00	QQQ	ETF	104.01	104.13	103.98	104.0599	669967.0
2015-01-26 12:30:00	QQQ	ETF	104.07	104.1	103.92	104.01	640606.0
2015-01-26 13:00:00	QQQ	ETF	104.01	104.09	103.931	104.03	558909.0

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

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