PREVIEW / etf_30min / 2018-09-13

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-13.parquet
  size:    466 KB
  rows:    15,972

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-09-13 04:00:00	SPY	ETF	289.31	289.6	289.31	289.5	10594.0
2018-09-13 04:30:00	SPY	ETF	289.43	289.48	289.38	289.46	4909.0
2018-09-13 05:00:00	SPY	ETF	289.5	289.56	289.43	289.43	7206.0
2018-09-13 05:30:00	SPY	ETF	289.4	289.4	289.27	289.36	9062.0
2018-09-13 06:00:00	SPY	ETF	289.36	289.48	289.36	289.42	14605.0
2018-09-13 06:30:00	SPY	ETF	289.44	289.79	289.42	289.65	18003.0
2018-09-13 07:00:00	SPY	ETF	289.65	289.9	289.62	289.8	79868.0
2018-09-13 07:30:00	SPY	ETF	289.81	289.97	289.81	289.92	30375.0
2018-09-13 08:00:00	SPY	ETF	289.9201	290.04	288.89	289.82	274855.0
2018-09-13 08:30:00	SPY	ETF	290.03	290.32	290.0	290.1	381137.0
2018-09-13 09:00:00	SPY	ETF	290.1	290.35	290.1	290.3	497103.0
2018-09-13 09:30:00	SPY	ETF	290.32	290.93	290.2	290.671	6669499.0
2018-09-13 10:00:00	SPY	ETF	290.675	291.0384	290.27	290.48	6280175.0
2018-09-13 10:30:00	SPY	ETF	290.46	290.63	289.995	290.24	3471990.0
2018-09-13 11:00:00	SPY	ETF	290.24	290.53	290.04	290.18	2946817.0
2018-09-13 11:30:00	SPY	ETF	290.1875	290.78	290.022	290.78	2780067.0
2018-09-13 12:00:00	SPY	ETF	290.7825	290.98	290.62	290.77	2665196.0
2018-09-13 12:30:00	SPY	ETF	290.765	290.875	290.63	290.73	1125045.0
2018-09-13 13:00:00	SPY	ETF	290.7327	290.79	290.51	290.635	1600390.0
2018-09-13 13:30:00	SPY	ETF	290.6385	290.72	290.5	290.56	1678749.0
2018-09-13 14:00:00	SPY	ETF	290.5601	290.8	290.38	290.6	2176849.0
2018-09-13 14:30:00	SPY	ETF	290.6	290.89	290.58	290.88	2174762.0
2018-09-13 15:00:00	SPY	ETF	290.88	290.9	290.5799	290.625	3143377.0
2018-09-13 15:30:00	SPY	ETF	290.62	290.83	290.38	290.82	6544515.0
2018-09-13 16:00:00	SPY	ETF	290.82	290.96	289.22	290.79	5217793.0
2018-09-13 16:30:00	SPY	ETF	290.79	290.89	290.75	290.83	207222.0
2018-09-13 17:00:00	SPY	ETF	290.73	290.82	290.71	290.77	27611.0
2018-09-13 17:30:00	SPY	ETF	290.77	290.82	290.67	290.76	60379.0
2018-09-13 18:00:00	SPY	ETF	290.71	290.86	290.64	290.83	37407.0
2018-09-13 18:30:00	SPY	ETF	290.74	290.84	290.73	290.84	13921.0
2018-09-13 19:00:00	SPY	ETF	290.8	290.8	290.74	290.75	3585.0
2018-09-13 19:30:00	SPY	ETF	290.8	290.89	290.8	290.81	11631.0
2018-09-13 04:00:00	QQQ	ETF	182.68	182.8	182.68	182.79	1540.0
2018-09-13 04:30:00	QQQ	ETF	182.74	182.81	182.74	182.77	3700.0
2018-09-13 05:00:00	QQQ	ETF	182.79	182.92	182.78	182.78	5666.0
2018-09-13 05:30:00	QQQ	ETF	182.75	182.78	182.65	182.74	3999.0
2018-09-13 06:00:00	QQQ	ETF	182.73	182.85	182.73	182.84	15993.0
2018-09-13 06:30:00	QQQ	ETF	182.85	183.15	182.85	183.06	6677.0
2018-09-13 07:00:00	QQQ	ETF	183.14	183.27	183.13	183.15	59485.0
2018-09-13 07:30:00	QQQ	ETF	183.15	183.26	183.15	183.22	52955.0
2018-09-13 08:00:00	QQQ	ETF	183.22	183.35	182.25	183.19	153978.0
2018-09-13 08:30:00	QQQ	ETF	183.28	183.65	182.93	183.43	420664.0
2018-09-13 09:00:00	QQQ	ETF	183.45	183.7	183.45	183.65	176757.0
2018-09-13 09:30:00	QQQ	ETF	183.67	184.8	183.6401	184.23	4493757.0
2018-09-13 10:00:00	QQQ	ETF	184.23	184.71	183.87	184.05	2781636.0
2018-09-13 10:30:00	QQQ	ETF	184.04	184.29	183.68	184.09	1450272.0
2018-09-13 11:00:00	QQQ	ETF	184.08	184.49	183.9	184.36	1595517.0
2018-09-13 11:30:00	QQQ	ETF	184.37	184.75	184.18	184.69	1767273.0
2018-09-13 12:00:00	QQQ	ETF	184.7	184.88	184.52	184.6	1373499.0
2018-09-13 12:30:00	QQQ	ETF	184.605	184.82	184.48	184.56	1271506.0

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

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