PREVIEW / etf_30min / 2017-04-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-19.parquet
  size:    431 KB
  rows:    14,538

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-04-19 04:00:00	SPY	ETF	234.05	234.2	234.05	234.2	850.0
2017-04-19 04:30:00	SPY	ETF	234.25	234.34	234.25	234.34	1400.0
2017-04-19 05:00:00	SPY	ETF	234.33	234.42	234.33	234.42	8952.0
2017-04-19 05:30:00	SPY	ETF	234.49	234.49	234.43	234.43	1619.0
2017-04-19 06:00:00	SPY	ETF	234.48	234.5	234.34	234.34	51701.0
2017-04-19 06:30:00	SPY	ETF	234.37	234.38	234.27	234.35	98355.0
2017-04-19 07:00:00	SPY	ETF	234.37	234.45	234.34	234.34	29803.0
2017-04-19 07:30:00	SPY	ETF	234.37	234.52	234.33	234.5	116773.0
2017-04-19 08:00:00	SPY	ETF	234.5	234.69	234.33	234.6	183335.0
2017-04-19 08:30:00	SPY	ETF	234.61	234.61	234.5	234.51	139077.0
2017-04-19 09:00:00	SPY	ETF	234.5	234.55	234.41	234.5	227297.0
2017-04-19 09:30:00	SPY	ETF	234.52	234.95	234.46	234.89	7300915.0
2017-04-19 10:00:00	SPY	ETF	234.9	234.93	234.61	234.69	3444249.0
2017-04-19 10:30:00	SPY	ETF	234.69	234.729	234.32	234.49	3533962.0
2017-04-19 11:00:00	SPY	ETF	234.48	234.71	234.445	234.69	2726853.0
2017-04-19 11:30:00	SPY	ETF	234.6884	234.7399	234.4	234.4399	2214307.0
2017-04-19 12:00:00	SPY	ETF	234.435	234.46	234.05	234.2468	3148393.0
2017-04-19 12:30:00	SPY	ETF	234.25	234.37	234.21	234.29	1932806.0
2017-04-19 13:00:00	SPY	ETF	234.29	234.3	233.88	234.09	3695146.0
2017-04-19 13:30:00	SPY	ETF	234.1	234.165	233.96	234.0965	1796733.0
2017-04-19 14:00:00	SPY	ETF	234.1	234.18	233.7	233.91	3610267.0
2017-04-19 14:30:00	SPY	ETF	233.92	234.0	233.39	233.5365	4705386.0
2017-04-19 15:00:00	SPY	ETF	233.535	233.74	233.35	233.38	4784443.0
2017-04-19 15:30:00	SPY	ETF	233.385	233.54	233.18	233.47	15296401.0
2017-04-19 16:00:00	SPY	ETF	233.48	233.58	233.34	233.36	6476231.0
2017-04-19 16:30:00	SPY	ETF	233.37	233.39	233.27	233.27	499122.0
2017-04-19 17:00:00	SPY	ETF	233.28	233.44	233.26	233.32	609918.0
2017-04-19 17:30:00	SPY	ETF	233.33	233.44	233.28	233.36	226908.0
2017-04-19 18:00:00	SPY	ETF	233.36	233.57	233.3	233.51	115292.0
2017-04-19 18:30:00	SPY	ETF	233.51	233.64	233.5	233.6	35194.0
2017-04-19 19:00:00	SPY	ETF	233.58	233.63	233.53	233.53	13988.0
2017-04-19 19:30:00	SPY	ETF	233.53	233.57	233.49	233.52	55778.0
2017-04-19 04:00:00	QQQ	ETF	131.49	131.49	131.49	131.49	3000.0
2017-04-19 04:30:00	QQQ	ETF	131.58	131.58	131.55	131.55	2530.0
2017-04-19 05:00:00	QQQ	ETF	131.59	131.59	131.59	131.59	750.0
2017-04-19 05:30:00	QQQ	ETF	131.62	131.73	131.62	131.72	16290.0
2017-04-19 06:00:00	QQQ	ETF	131.74	131.76	131.69	131.69	650.0
2017-04-19 06:30:00	QQQ	ETF	131.66	131.69	131.66	131.67	5400.0
2017-04-19 07:00:00	QQQ	ETF	131.69	131.69	131.66	131.67	13800.0
2017-04-19 07:30:00	QQQ	ETF	131.67	131.75	131.66	131.75	4800.0
2017-04-19 08:00:00	QQQ	ETF	131.68	131.9	131.68	131.88	21564.0
2017-04-19 08:30:00	QQQ	ETF	131.86	131.89	131.84	131.85	79723.0
2017-04-19 09:00:00	QQQ	ETF	131.85	131.87	131.81	131.84	39423.0
2017-04-19 09:30:00	QQQ	ETF	131.85	132.24	131.84	132.19	3366422.0
2017-04-19 10:00:00	QQQ	ETF	132.195	132.22	132.01	132.05	1540912.0
2017-04-19 10:30:00	QQQ	ETF	132.06	132.15	131.98	132.08	918565.0
2017-04-19 11:00:00	QQQ	ETF	132.07	132.29	132.07	132.28	850743.0
2017-04-19 11:30:00	QQQ	ETF	132.271	132.28	132.11	132.12	818652.0
2017-04-19 12:00:00	QQQ	ETF	132.12	132.165	131.93	131.97	940305.0
2017-04-19 12:30:00	QQQ	ETF	131.97	132.05	131.95	131.99	390738.0

> showing 50 of 14,538 rows — these rows as CSV

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