PREVIEW / etf_30min / 2018-12-04

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-04.parquet
  size:    516 KB
  rows:    17,978

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
2018-12-04 04:00:00	SPY	ETF	278.04	278.06	277.67	277.81	10662.0
2018-12-04 04:30:00	SPY	ETF	277.77	277.77	277.51	277.64	17174.0
2018-12-04 05:00:00	SPY	ETF	277.55	278.2	277.48	278.2	19574.0
2018-12-04 05:30:00	SPY	ETF	278.26	278.37	278.15	278.24	17173.0
2018-12-04 06:00:00	SPY	ETF	278.3	278.5	278.24	278.24	30227.0
2018-12-04 06:30:00	SPY	ETF	278.27	278.4	278.16	278.22	38590.0
2018-12-04 07:00:00	SPY	ETF	278.22	278.4	277.9	278.01	195109.0
2018-12-04 07:30:00	SPY	ETF	278.05	278.31	277.95	278.18	112900.0
2018-12-04 08:00:00	SPY	ETF	278.1001	279.3	276.98	278.61	279743.0
2018-12-04 08:30:00	SPY	ETF	278.57	278.86	278.38	278.68	184018.0
2018-12-04 09:00:00	SPY	ETF	278.64	278.69	278.36	278.37	419581.0
2018-12-04 09:30:00	SPY	ETF	278.37	278.85	277.34	277.75	9829618.0
2018-12-04 10:00:00	SPY	ETF	277.76	277.98	277.09	277.57	6479648.0
2018-12-04 10:30:00	SPY	ETF	277.59	277.81	277.17	277.23	4169296.0
2018-12-04 11:00:00	SPY	ETF	277.24	277.6	276.84	277.05	5485959.0
2018-12-04 11:30:00	SPY	ETF	277.05	277.22	276.41	276.45	4359596.0
2018-12-04 12:00:00	SPY	ETF	276.44	276.4471	273.285	273.29	17312754.0
2018-12-04 12:30:00	SPY	ETF	273.295	273.75	272.25	272.99	17101934.0
2018-12-04 13:00:00	SPY	ETF	272.96	273.23	271.12	271.67	10716926.0
2018-12-04 13:30:00	SPY	ETF	271.66	272.55	270.38	272.24	12787843.0
2018-12-04 14:00:00	SPY	ETF	272.24	272.88	271.62	271.87	10252188.0
2018-12-04 14:30:00	SPY	ETF	271.88	273.35	271.88	272.3001	8095252.0
2018-12-04 15:00:00	SPY	ETF	272.31	272.33	270.6	270.75	12153912.0
2018-12-04 15:30:00	SPY	ETF	270.74	271.38	269.9	270.49	31876688.0
2018-12-04 16:00:00	SPY	ETF	270.48	270.67	270.16	270.34	16579269.0
2018-12-04 16:30:00	SPY	ETF	270.34	270.42	269.74	270.35	2746093.0
2018-12-04 17:00:00	SPY	ETF	270.27	279.2317	270.25	270.29	783986.0
2018-12-04 17:30:00	SPY	ETF	270.26	270.29	270.05	270.06	75413.0
2018-12-04 18:00:00	SPY	ETF	270.08	270.8	269.95	270.67	1276773.0
2018-12-04 18:30:00	SPY	ETF	270.66	271.0199	270.25	271.0199	80075.0
2018-12-04 19:00:00	SPY	ETF	271.02	271.51	271.02	271.1	274557.0
2018-12-04 19:30:00	SPY	ETF	271.08	271.18	270.84	271.0	207385.0
2018-12-04 04:00:00	QQQ	ETF	171.06	171.07	170.72	170.97	13771.0
2018-12-04 04:30:00	QQQ	ETF	170.93	170.94	170.59	170.74	10191.0
2018-12-04 05:00:00	QQQ	ETF	170.7	171.13	170.65	171.13	18531.0
2018-12-04 05:30:00	QQQ	ETF	171.22	171.3	171.15	171.15	9342.0
2018-12-04 06:00:00	QQQ	ETF	171.32	171.41	171.22	171.22	10026.0
2018-12-04 06:30:00	QQQ	ETF	171.24	171.28	171.13	171.18	21365.0
2018-12-04 07:00:00	QQQ	ETF	171.17	171.24	170.93	170.98	28221.0
2018-12-04 07:30:00	QQQ	ETF	171.05	171.23	170.95	171.13	18597.0
2018-12-04 08:00:00	QQQ	ETF	171.12	171.55	170.33	171.46	143026.0
2018-12-04 08:30:00	QQQ	ETF	171.48	171.7	171.36	171.58	86026.0
2018-12-04 09:00:00	QQQ	ETF	171.58	171.66	171.37	171.38	135775.0
2018-12-04 09:30:00	QQQ	ETF	171.38	171.8048	170.93	171.33	3943903.0
2018-12-04 10:00:00	QQQ	ETF	171.34	171.91	171.17	171.52	3198105.0
2018-12-04 10:30:00	QQQ	ETF	171.51	171.69	171.22	171.3	2059359.0
2018-12-04 11:00:00	QQQ	ETF	171.29	171.47	170.77	170.8769	2279498.0
2018-12-04 11:30:00	QQQ	ETF	170.88	170.9	170.48	170.5	1649137.0
2018-12-04 12:00:00	QQQ	ETF	170.49	170.49	168.13	168.13	6385877.0
2018-12-04 12:30:00	QQQ	ETF	168.14	168.54	167.3	167.9	5714825.0

> showing 50 of 17,978 rows — these rows as CSV

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