PREVIEW / etf_30min / 2015-09-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-28.parquet
  size:    394 KB
  rows:    13,301

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-09-28 04:00:00	SPY	ETF	193.02	193.28	193.02	193.2	13114.0
2015-09-28 04:30:00	SPY	ETF	192.73	192.76	192.16	192.35	229707.0
2015-09-28 05:00:00	SPY	ETF	192.4	192.45	191.85	191.99	141205.0
2015-09-28 05:30:00	SPY	ETF	192.02	192.02	191.67	191.7	12798.0
2015-09-28 06:00:00	SPY	ETF	191.79	191.99	191.39	191.41	188147.0
2015-09-28 06:30:00	SPY	ETF	191.41	191.45	191.1	191.29	328510.0
2015-09-28 07:00:00	SPY	ETF	191.32	191.85	191.32	191.85	216504.0
2015-09-28 07:30:00	SPY	ETF	191.82	191.89	190.98	191.27	344465.0
2015-09-28 08:00:00	SPY	ETF	191.28	192.85	191.16	191.4	554697.0
2015-09-28 08:30:00	SPY	ETF	191.38	191.89	191.28	191.72	921450.0
2015-09-28 09:00:00	SPY	ETF	191.74	191.99	191.37	191.76	1548985.0
2015-09-28 09:30:00	SPY	ETF	191.78	191.91	190.685	190.69	14704458.0
2015-09-28 10:00:00	SPY	ETF	190.69	190.84	190.01	190.59	14019084.0
2015-09-28 10:30:00	SPY	ETF	190.59	190.65	190.06	190.567	8788737.0
2015-09-28 11:00:00	SPY	ETF	190.553	190.89	189.51	189.64	10384431.0
2015-09-28 11:30:00	SPY	ETF	189.64	189.77	189.39	189.44	7758618.0
2015-09-28 12:00:00	SPY	ETF	189.43	189.5	188.96	189.18	6429018.0
2015-09-28 12:30:00	SPY	ETF	189.18	189.23	188.64	188.67	8189932.0
2015-09-28 13:00:00	SPY	ETF	188.67	189.24	188.54	188.66	8367964.0
2015-09-28 13:30:00	SPY	ETF	188.655	189.11	188.35	188.37	7874860.0
2015-09-28 14:00:00	SPY	ETF	188.36	188.46	187.76	188.28	9802203.0
2015-09-28 14:30:00	SPY	ETF	188.31	188.85	188.0	188.155	10348972.0
2015-09-28 15:00:00	SPY	ETF	188.16	188.23	187.64	187.84	13059858.0
2015-09-28 15:30:00	SPY	ETF	187.82	188.67	187.78	187.93	27712487.0
2015-09-28 16:00:00	SPY	ETF	187.92	188.41	187.84	187.92	5806751.0
2015-09-28 16:30:00	SPY	ETF	187.92	189.2	187.91	188.25	2557048.0
2015-09-28 17:00:00	SPY	ETF	188.27	188.37	187.933	188.34	14157149.0
2015-09-28 17:30:00	SPY	ETF	188.31	188.4	188.01	188.4	301426.0
2015-09-28 18:00:00	SPY	ETF	188.35	188.6	188.29	188.54	63729.0
2015-09-28 18:30:00	SPY	ETF	188.54	188.71	188.41	188.53	40601.0
2015-09-28 19:00:00	SPY	ETF	188.5	188.57	188.48	188.49	7603.0
2015-09-28 19:30:00	SPY	ETF	188.5	188.59	188.44	188.53	51068.0
2015-09-28 04:00:00	QQQ	ETF	103.0	103.0	103.0	103.0	180.0
2015-09-28 04:30:00	QQQ	ETF	102.55	102.62	102.55	102.62	2100.0
2015-09-28 05:00:00	QQQ	ETF	102.4	102.45	102.4	102.45	16000.0
2015-09-28 05:30:00	QQQ	ETF	102.35	102.42	102.31	102.42	600.0
2015-09-28 06:00:00	QQQ	ETF	102.45	102.52	102.2	102.2	2660.0
2015-09-28 06:30:00	QQQ	ETF	102.14	102.22	102.11	102.22	4295.0
2015-09-28 07:00:00	QQQ	ETF	102.29	102.48	102.25	102.48	9221.0
2015-09-28 07:30:00	QQQ	ETF	102.48	102.48	102.06	102.17	52419.0
2015-09-28 08:00:00	QQQ	ETF	102.15	102.41	102.11	102.18	72468.0
2015-09-28 08:30:00	QQQ	ETF	102.29	102.5	102.18	102.41	176043.0
2015-09-28 09:00:00	QQQ	ETF	102.43	102.6	102.29	102.47	149471.0
2015-09-28 09:30:00	QQQ	ETF	102.48	102.55	101.55	101.57	5513487.0
2015-09-28 10:00:00	QQQ	ETF	101.56	101.7	101.15	101.61	3444219.0
2015-09-28 10:30:00	QQQ	ETF	101.6	101.6	101.21	101.57	2346549.0
2015-09-28 11:00:00	QQQ	ETF	101.56	101.78	100.91	101.0	3365734.0
2015-09-28 11:30:00	QQQ	ETF	101.01	101.12	100.805	100.805	1496543.0
2015-09-28 12:00:00	QQQ	ETF	100.8	100.91	100.64	100.82	1813683.0
2015-09-28 12:30:00	QQQ	ETF	100.82	100.87	100.41	100.42	2018233.0

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

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