PREVIEW / etf_30min / 2017-11-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-09.parquet
  size:    458 KB
  rows:    15,791

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
2017-11-09 04:00:00	SPY	ETF	258.85	258.85	258.72	258.73	47298.0
2017-11-09 04:30:00	SPY	ETF	258.76	258.78	258.72	258.78	2700.0
2017-11-09 05:00:00	SPY	ETF	258.79	258.79	258.55	258.55	8720.0
2017-11-09 05:30:00	SPY	ETF	258.58	258.73	258.55	258.73	2600.0
2017-11-09 06:00:00	SPY	ETF	258.65	258.67	258.36	258.36	27918.0
2017-11-09 06:30:00	SPY	ETF	258.34	258.38	258.16	258.34	291512.0
2017-11-09 07:00:00	SPY	ETF	258.34	258.35	257.95	258.2	456548.0
2017-11-09 07:30:00	SPY	ETF	258.2	258.24	257.85	257.92	274148.0
2017-11-09 08:00:00	SPY	ETF	258.15	258.34	257.57	257.71	862191.0
2017-11-09 08:30:00	SPY	ETF	257.71	258.02	257.7	257.86	274919.0
2017-11-09 09:00:00	SPY	ETF	257.87	257.91	257.7	257.73	505518.0
2017-11-09 09:30:00	SPY	ETF	257.73	258.08	257.435	257.75	8809206.0
2017-11-09 10:00:00	SPY	ETF	257.755	258.31	257.745	258.12	5739558.0
2017-11-09 10:30:00	SPY	ETF	258.115	258.39	257.77	258.36	4031420.0
2017-11-09 11:00:00	SPY	ETF	258.365	258.38	257.6301	257.87	6778950.0
2017-11-09 11:30:00	SPY	ETF	257.87	257.91	257.04	257.35	6967951.0
2017-11-09 12:00:00	SPY	ETF	257.355	257.36	256.59	256.64	7861589.0
2017-11-09 12:30:00	SPY	ETF	256.65	257.08	256.36	257.04	8530195.0
2017-11-09 13:00:00	SPY	ETF	257.04	257.485	256.77	257.415	5246556.0
2017-11-09 13:30:00	SPY	ETF	257.41	257.65	257.35	257.54	4733951.0
2017-11-09 14:00:00	SPY	ETF	257.54	257.885	257.53	257.7	8117237.0
2017-11-09 14:30:00	SPY	ETF	257.695	257.86	257.52	257.65	3991459.0
2017-11-09 15:00:00	SPY	ETF	257.65	258.07	257.58	258.025	5406850.0
2017-11-09 15:30:00	SPY	ETF	258.02	258.38	258.02	258.2	10738188.0
2017-11-09 16:00:00	SPY	ETF	258.22	258.44	258.17	258.35	2822896.0
2017-11-09 16:30:00	SPY	ETF	258.35	258.38	257.7309	258.33	247439.0
2017-11-09 17:00:00	SPY	ETF	258.33	258.33	258.17	258.24	375044.0
2017-11-09 17:30:00	SPY	ETF	258.26	258.28	258.17	258.18	378136.0
2017-11-09 18:00:00	SPY	ETF	258.2	258.28	258.18	258.21	157466.0
2017-11-09 18:30:00	SPY	ETF	258.19	258.28	258.08	258.2	124269.0
2017-11-09 19:00:00	SPY	ETF	258.18	258.36	258.17	258.2	39574.0
2017-11-09 19:30:00	SPY	ETF	258.2	258.25	258.11	258.22	33067.0
2017-11-09 04:00:00	QQQ	ETF	154.28	154.3	154.25	154.3	22200.0
2017-11-09 05:00:00	QQQ	ETF	154.27	154.27	154.13	154.13	4100.0
2017-11-09 05:30:00	QQQ	ETF	154.16	154.22	154.16	154.22	14200.0
2017-11-09 06:00:00	QQQ	ETF	154.18	154.18	153.99	153.99	47006.0
2017-11-09 06:30:00	QQQ	ETF	153.97	153.97	153.81	153.94	63497.0
2017-11-09 07:00:00	QQQ	ETF	153.97	153.97	153.59	153.78	129212.0
2017-11-09 07:30:00	QQQ	ETF	153.8	153.8	153.5	153.5	112425.0
2017-11-09 08:00:00	QQQ	ETF	153.91	153.97	153.13	153.25	420722.0
2017-11-09 08:30:00	QQQ	ETF	153.28	154.5	153.22	153.28	298106.0
2017-11-09 09:00:00	QQQ	ETF	153.28	153.35	153.17	153.27	451038.0
2017-11-09 09:30:00	QQQ	ETF	153.26	153.49	152.79	153.12	6269225.0
2017-11-09 10:00:00	QQQ	ETF	153.13	153.77	153.105	153.59	3858128.0
2017-11-09 10:30:00	QQQ	ETF	153.59	153.75	153.22	153.73	1796684.0
2017-11-09 11:00:00	QQQ	ETF	153.73	153.74	153.12	153.29	1466522.0
2017-11-09 11:30:00	QQQ	ETF	153.3	153.33	152.69	152.87	2456663.0
2017-11-09 12:00:00	QQQ	ETF	152.87	152.93	152.38	152.45	3540667.0
2017-11-09 12:30:00	QQQ	ETF	152.45	152.61	152.11	152.56	2768700.0
2017-11-09 13:00:00	QQQ	ETF	152.55	152.95	152.26	152.88	1896320.0

> showing 50 of 15,791 rows — these rows as CSV

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