PREVIEW / etf_30min / 2018-02-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-02.parquet
  size:    519 KB
  rows:    18,103

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-02-02 04:00:00	SPY	ETF	280.5	280.5	280.02	280.13	46469.0
2018-02-02 04:30:00	SPY	ETF	280.07	280.15	279.65	279.68	50566.0
2018-02-02 05:00:00	SPY	ETF	279.68	279.78	279.17	279.64	150433.0
2018-02-02 05:30:00	SPY	ETF	279.48	279.85	279.48	279.61	53674.0
2018-02-02 06:00:00	SPY	ETF	279.61	280.0	279.57	279.89	62280.0
2018-02-02 06:30:00	SPY	ETF	279.8	279.88	279.55	279.72	100707.0
2018-02-02 07:00:00	SPY	ETF	279.72	280.1	279.68	279.96	530384.0
2018-02-02 07:30:00	SPY	ETF	279.97	280.13	279.85	280.02	366259.0
2018-02-02 08:00:00	SPY	ETF	279.97	281.58	279.68	280.2	240580.0
2018-02-02 08:30:00	SPY	ETF	280.2	280.46	279.42	280.11	1563237.0
2018-02-02 09:00:00	SPY	ETF	280.11	280.2	279.72	280.06	944326.0
2018-02-02 09:30:00	SPY	ETF	280.08	280.23	279.06	279.39	10778651.0
2018-02-02 10:00:00	SPY	ETF	279.3901	279.4	278.38	279.3	12016354.0
2018-02-02 10:30:00	SPY	ETF	279.29	279.64	278.97	279.3	5641378.0
2018-02-02 11:00:00	SPY	ETF	279.3	279.5	278.77	278.88	7081515.0
2018-02-02 11:30:00	SPY	ETF	278.88	280.04	278.24	278.26	6074751.0
2018-02-02 12:00:00	SPY	ETF	278.26	279.14	278.12	279.0905	6909884.0
2018-02-02 12:30:00	SPY	ETF	279.08	279.1	278.48	278.48	3633581.0
2018-02-02 13:00:00	SPY	ETF	278.48	278.52	277.78	278.12	7144187.0
2018-02-02 13:30:00	SPY	ETF	278.11	278.32	277.5	277.78	7105434.0
2018-02-02 14:00:00	SPY	ETF	277.775	277.79	276.5	276.65	12911436.0
2018-02-02 14:30:00	SPY	ETF	276.65	277.28	276.12	276.36	11655846.0
2018-02-02 15:00:00	SPY	ETF	276.35	276.91	275.66	276.44	19927058.0
2018-02-02 15:30:00	SPY	ETF	276.44	276.75	275.41	275.52	32330397.0
2018-02-02 16:00:00	SPY	ETF	275.5	276.0182	275.09	275.33	18414890.0
2018-02-02 16:30:00	SPY	ETF	275.33	278.9346	275.09	275.27	2160100.0
2018-02-02 17:00:00	SPY	ETF	275.25	275.46	275.0	275.02	495601.0
2018-02-02 17:30:00	SPY	ETF	275.1	275.45	274.91	274.95	699998.0
2018-02-02 18:00:00	SPY	ETF	274.95	275.0	274.6	274.8	105288.0
2018-02-02 18:30:00	SPY	ETF	274.77	274.88	274.74	274.85	30338.0
2018-02-02 19:00:00	SPY	ETF	274.85	274.88	274.72	274.8	21377.0
2018-02-02 19:30:00	SPY	ETF	274.8	275.45	274.71	274.79	15517.0
2018-02-02 04:00:00	QQQ	ETF	167.86	167.86	167.24	167.31	34225.0
2018-02-02 04:30:00	QQQ	ETF	167.29	167.46	167.05	167.06	11337.0
2018-02-02 05:00:00	QQQ	ETF	167.11	167.16	166.78	167.05	20745.0
2018-02-02 05:30:00	QQQ	ETF	166.97	167.19	166.97	167.0	16890.0
2018-02-02 06:00:00	QQQ	ETF	166.99	167.09	166.87	166.88	23679.0
2018-02-02 06:30:00	QQQ	ETF	166.82	166.82	166.42	166.58	87543.0
2018-02-02 07:00:00	QQQ	ETF	166.56	167.0	166.54	166.92	199939.0
2018-02-02 07:30:00	QQQ	ETF	166.9	167.39	166.9	167.37	149597.0
2018-02-02 08:00:00	QQQ	ETF	167.39	168.6	166.52	167.21	260231.0
2018-02-02 08:30:00	QQQ	ETF	167.12	167.62	166.75	167.16	682556.0
2018-02-02 09:00:00	QQQ	ETF	167.14	167.36	166.9	167.32	265705.0
2018-02-02 09:30:00	QQQ	ETF	167.34	167.7	166.25	166.59	7099743.0
2018-02-02 10:00:00	QQQ	ETF	166.59	166.59	165.47	166.55	6230760.0
2018-02-02 10:30:00	QQQ	ETF	166.55	166.96	166.29	166.755	2548242.0
2018-02-02 11:00:00	QQQ	ETF	166.75	166.985	166.31	166.44	2057926.0
2018-02-02 11:30:00	QQQ	ETF	166.44	166.56	166.05	166.08	1555796.0
2018-02-02 12:00:00	QQQ	ETF	166.09	166.82	165.87	166.8038	1822512.0
2018-02-02 12:30:00	QQQ	ETF	166.8	166.855	166.4	166.41	1694656.0

> showing 50 of 18,103 rows — these rows as CSV

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