PREVIEW / etf_30min / 2017-07-31

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-31.parquet
  size:    424 KB
  rows:    14,796

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-07-31 04:00:00	SPY	ETF	247.12	247.25	247.1	247.24	5579.0
2017-07-31 04:30:00	SPY	ETF	247.22	247.22	247.15	247.16	3500.0
2017-07-31 05:00:00	SPY	ETF	247.18	247.32	247.06	247.31	69674.0
2017-07-31 05:30:00	SPY	ETF	247.32	247.32	247.25	247.26	3800.0
2017-07-31 06:00:00	SPY	ETF	247.22	247.22	247.1	247.18	14220.0
2017-07-31 06:30:00	SPY	ETF	247.2	247.2	247.15	247.18	2318.0
2017-07-31 07:00:00	SPY	ETF	247.17	247.3	247.17	247.26	39210.0
2017-07-31 07:30:00	SPY	ETF	247.3	247.33	247.26	247.29	81041.0
2017-07-31 08:00:00	SPY	ETF	247.31	247.36	247.18	247.35	93832.0
2017-07-31 08:30:00	SPY	ETF	247.33	247.48	247.33	247.36	298545.0
2017-07-31 09:00:00	SPY	ETF	247.33	247.46	247.31	247.36	259745.0
2017-07-31 09:30:00	SPY	ETF	247.37	247.48	247.0	247.02	4180793.0
2017-07-31 10:00:00	SPY	ETF	247.02	247.07	246.75	246.8499	3874614.0
2017-07-31 10:30:00	SPY	ETF	246.84	246.845	246.53	246.68	3715499.0
2017-07-31 11:00:00	SPY	ETF	246.68	246.89	246.68	246.87	2149396.0
2017-07-31 11:30:00	SPY	ETF	246.87	247.03	246.86	246.9908	1523259.0
2017-07-31 12:00:00	SPY	ETF	246.995	247.1	246.8	247.055	1409360.0
2017-07-31 12:30:00	SPY	ETF	247.06	247.1	247.0	247.0501	1121873.0
2017-07-31 13:00:00	SPY	ETF	247.06	247.17	246.87	247.03	1869925.0
2017-07-31 13:30:00	SPY	ETF	247.03	247.05	246.88	247.05	955802.0
2017-07-31 14:00:00	SPY	ETF	247.04	247.08	246.93	247.05	3308109.0
2017-07-31 14:30:00	SPY	ETF	247.06	247.07	246.83	246.8665	2709761.0
2017-07-31 15:00:00	SPY	ETF	246.87	247.095	246.82	247.09	2979500.0
2017-07-31 15:30:00	SPY	ETF	247.08	247.24	246.71	246.74	10190072.0
2017-07-31 16:00:00	SPY	ETF	246.78	247.01	246.7161	246.92	20100279.0
2017-07-31 16:30:00	SPY	ETF	246.93	246.97	246.77	246.84	1902164.0
2017-07-31 17:00:00	SPY	ETF	246.81	247.3757	246.81	246.83	143473.0
2017-07-31 17:30:00	SPY	ETF	246.84	246.85	246.77	246.8	242206.0
2017-07-31 18:00:00	SPY	ETF	246.8	246.8	246.62	246.67	85756.0
2017-07-31 18:30:00	SPY	ETF	246.69	246.74	246.69	246.72	11882.0
2017-07-31 19:00:00	SPY	ETF	246.72	246.75	246.72	246.75	4852.0
2017-07-31 19:30:00	SPY	ETF	246.75	246.75	246.71	246.72	10224.0
2017-07-31 04:00:00	QQQ	ETF	144.13	144.25	144.13	144.25	585.0
2017-07-31 04:30:00	QQQ	ETF	144.21	144.21	144.19	144.2	1572.0
2017-07-31 05:00:00	QQQ	ETF	144.13	144.18	143.99	144.18	8050.0
2017-07-31 05:30:00	QQQ	ETF	144.18	144.2	144.18	144.2	3050.0
2017-07-31 06:30:00	QQQ	ETF	144.12	144.17	144.07	144.07	6430.0
2017-07-31 07:00:00	QQQ	ETF	144.14	144.27	144.14	144.25	13214.0
2017-07-31 07:30:00	QQQ	ETF	144.24	144.25	144.17	144.2	28690.0
2017-07-31 08:00:00	QQQ	ETF	144.15	144.25	144.11	144.23	45887.0
2017-07-31 08:30:00	QQQ	ETF	144.26	144.32	144.24	144.24	52478.0
2017-07-31 09:00:00	QQQ	ETF	144.21	144.28	144.17	144.21	231009.0
2017-07-31 09:30:00	QQQ	ETF	144.22	144.43	143.73	143.75	4143960.0
2017-07-31 10:00:00	QQQ	ETF	143.76	143.83	143.26	143.3	3775149.0
2017-07-31 10:30:00	QQQ	ETF	143.3	143.32	142.92	143.18	3507710.0
2017-07-31 11:00:00	QQQ	ETF	143.2	143.41	143.15	143.22	1486472.0
2017-07-31 11:30:00	QQQ	ETF	143.23	143.57	143.21	143.51	1554305.0
2017-07-31 12:00:00	QQQ	ETF	143.51	143.535	143.17	143.5	1924464.0
2017-07-31 12:30:00	QQQ	ETF	143.49	143.545	143.36	143.43	828108.0
2017-07-31 13:00:00	QQQ	ETF	143.44	143.48	143.17	143.28	1158335.0

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

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