PREVIEW / etf_30min / 2016-04-22

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-22.parquet
  size:    393 KB
  rows:    13,309

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-22 04:00:00	SPY	ETF	208.75	208.89	208.75	208.79	462.0
2016-04-22 04:30:00	SPY	ETF	208.85	208.85	208.49	208.49	1278.0
2016-04-22 05:00:00	SPY	ETF	208.5	208.67	208.5	208.67	500.0
2016-04-22 05:30:00	SPY	ETF	208.77	208.77	208.62	208.62	224.0
2016-04-22 06:00:00	SPY	ETF	208.7	209.07	208.7	209.07	10086.0
2016-04-22 06:30:00	SPY	ETF	209.03	209.17	208.9	209.04	40717.0
2016-04-22 07:00:00	SPY	ETF	209.0	209.18	208.96	208.96	129806.0
2016-04-22 07:30:00	SPY	ETF	208.98	208.99	208.87	208.93	117518.0
2016-04-22 08:00:00	SPY	ETF	208.94	209.3712	208.61	208.75	302549.0
2016-04-22 08:30:00	SPY	ETF	208.79	208.89	208.69	208.74	193714.0
2016-04-22 09:00:00	SPY	ETF	208.73	208.8	208.54	208.55	318999.0
2016-04-22 09:30:00	SPY	ETF	208.55	209.2	208.5	209.13	10030794.0
2016-04-22 10:00:00	SPY	ETF	209.13	209.29	208.55	208.655	6913338.0
2016-04-22 10:30:00	SPY	ETF	208.66	208.85	207.91	208.03	11430433.0
2016-04-22 11:00:00	SPY	ETF	208.04	208.3	207.9993	208.13	5027894.0
2016-04-22 11:30:00	SPY	ETF	208.14	208.5	208.12	208.46	5771136.0
2016-04-22 12:00:00	SPY	ETF	208.47	208.48	208.05	208.08	2925235.0
2016-04-22 12:30:00	SPY	ETF	208.09	208.26	208.01	208.1	2787881.0
2016-04-22 13:00:00	SPY	ETF	208.11	208.37	208.07	208.19	2327730.0
2016-04-22 13:30:00	SPY	ETF	208.18	208.86	208.171	208.68	5100756.0
2016-04-22 14:00:00	SPY	ETF	208.69	209.08	208.61	209.03	5001273.0
2016-04-22 14:30:00	SPY	ETF	209.03	209.08	208.91	209.0	4141205.0
2016-04-22 15:00:00	SPY	ETF	209.01	209.06	208.66	208.91	7636159.0
2016-04-22 15:30:00	SPY	ETF	208.91	209.02	208.71	208.99	13774108.0
2016-04-22 16:00:00	SPY	ETF	209.0	209.02	208.86	208.99	10485421.0
2016-04-22 16:30:00	SPY	ETF	209.0	209.08	208.97	208.98	1680907.0
2016-04-22 17:00:00	SPY	ETF	208.99	209.0	208.94	208.95	38162.0
2016-04-22 17:30:00	SPY	ETF	208.94	209.08	208.94	209.03	21547.0
2016-04-22 18:00:00	SPY	ETF	209.01	209.04	209.01	209.04	10848.0
2016-04-22 18:30:00	SPY	ETF	209.05	209.05	209.0	209.05	3800.0
2016-04-22 19:00:00	SPY	ETF	209.02	209.02	209.02	209.02	210.0
2016-04-22 19:30:00	SPY	ETF	209.04	209.08	208.9554	209.02	1004705.0
2016-04-22 04:00:00	QQQ	ETF	109.5	109.69	109.5	109.69	1246.0
2016-04-22 04:30:00	QQQ	ETF	109.41	109.41	109.4	109.4	1000.0
2016-04-22 05:30:00	QQQ	ETF	109.5	109.5	109.5	109.5	150.0
2016-04-22 06:00:00	QQQ	ETF	109.58	109.7	109.58	109.7	1595.0
2016-04-22 06:30:00	QQQ	ETF	109.72	109.76	109.69	109.69	1120.0
2016-04-22 07:00:00	QQQ	ETF	109.67	109.8	109.65	109.65	13524.0
2016-04-22 07:30:00	QQQ	ETF	109.65	109.67	109.62	109.62	36310.0
2016-04-22 08:00:00	QQQ	ETF	109.65	109.73	109.5	109.54	41864.0
2016-04-22 08:30:00	QQQ	ETF	109.55	109.63	109.5	109.51	34064.0
2016-04-22 09:00:00	QQQ	ETF	109.52	109.52	109.22	109.24	427362.0
2016-04-22 09:30:00	QQQ	ETF	109.21	109.72	109.1	109.4	5257616.0
2016-04-22 10:00:00	QQQ	ETF	109.4	109.475	108.64	108.79	2965932.0
2016-04-22 10:30:00	QQQ	ETF	108.785	108.88	108.12	108.28	3907047.0
2016-04-22 11:00:00	QQQ	ETF	108.29	108.44	108.18	108.28	2529349.0
2016-04-22 11:30:00	QQQ	ETF	108.3	108.57	108.29	108.56	1764543.0
2016-04-22 12:00:00	QQQ	ETF	108.57	108.59	108.28	108.32	1266675.0
2016-04-22 12:30:00	QQQ	ETF	108.33	108.42	108.19	108.31	1153900.0
2016-04-22 13:00:00	QQQ	ETF	108.325	108.52	108.32	108.44	964209.0

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

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