PREVIEW / etf_30min / 2018-09-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-17.parquet
  size:    469 KB
  rows:    16,149

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-17 04:00:00	SPY	ETF	290.5	290.62	290.46	290.62	4041.0
2018-09-17 04:30:00	SPY	ETF	290.81	290.93	290.8	290.8	2270.0
2018-09-17 05:00:00	SPY	ETF	290.93	290.93	290.52	290.52	2110.0
2018-09-17 05:30:00	SPY	ETF	290.57	290.6	290.5	290.55	23638.0
2018-09-17 06:00:00	SPY	ETF	290.53	290.55	290.46	290.53	2400.0
2018-09-17 06:30:00	SPY	ETF	290.55	290.6	290.55	290.56	17720.0
2018-09-17 07:00:00	SPY	ETF	290.58	290.71	290.56	290.67	56277.0
2018-09-17 07:30:00	SPY	ETF	290.74	290.75	290.61	290.7	93451.0
2018-09-17 08:00:00	SPY	ETF	290.6	290.88	290.47	290.65	412284.0
2018-09-17 08:30:00	SPY	ETF	290.67	290.73	290.56	290.72	112265.0
2018-09-17 09:00:00	SPY	ETF	290.72	290.81	290.61	290.81	188298.0
2018-09-17 09:30:00	SPY	ETF	290.82	290.86	290.28	290.48	4495471.0
2018-09-17 10:00:00	SPY	ETF	290.48	290.52	290.18	290.33	4435398.0
2018-09-17 10:30:00	SPY	ETF	290.3385	290.39	289.73	289.83	4495091.0
2018-09-17 11:00:00	SPY	ETF	289.83	290.27	289.8	290.1	3286309.0
2018-09-17 11:30:00	SPY	ETF	290.09	290.27	290.015	290.165	2900401.0
2018-09-17 12:00:00	SPY	ETF	290.17	290.38	290.085	290.265	2493736.0
2018-09-17 12:30:00	SPY	ETF	290.27	290.33	289.9	290.16	2139004.0
2018-09-17 13:00:00	SPY	ETF	290.16	290.25	289.82	289.85	1856975.0
2018-09-17 13:30:00	SPY	ETF	289.84	290.12	289.61	289.96	3032466.0
2018-09-17 14:00:00	SPY	ETF	289.96	290.12	289.865	289.985	3309500.0
2018-09-17 14:30:00	SPY	ETF	289.98	290.05	289.55	289.71	3456231.0
2018-09-17 15:00:00	SPY	ETF	289.7	289.78	289.2	289.35	7383060.0
2018-09-17 15:30:00	SPY	ETF	289.36	289.46	289.03	289.34	14643684.0
2018-09-17 16:00:00	SPY	ETF	289.34	289.59	289.1355	289.41	6607189.0
2018-09-17 16:30:00	SPY	ETF	289.42	289.49	289.29	289.42	55845.0
2018-09-17 17:00:00	SPY	ETF	289.47	289.6	289.41	289.48	1533001.0
2018-09-17 17:30:00	SPY	ETF	289.48	289.48	289.35	289.39	36558.0
2018-09-17 18:00:00	SPY	ETF	289.36	289.42	289.15	289.24	33504.0
2018-09-17 18:30:00	SPY	ETF	289.24	289.24	288.2	288.25	85185.0
2018-09-17 19:00:00	SPY	ETF	288.28	288.6	288.28	288.5	62183.0
2018-09-17 19:30:00	SPY	ETF	288.5	288.5	288.27	288.27	57851.0
2018-09-17 20:00:00	SPY	ETF	288.2	289.34	288.2	289.34	70.0
2018-09-17 04:00:00	QQQ	ETF	183.63	183.92	183.63	183.92	5367.0
2018-09-17 04:30:00	QQQ	ETF	183.99	183.99	183.86	183.86	9100.0
2018-09-17 05:00:00	QQQ	ETF	184.0	184.01	183.88	183.88	926.0
2018-09-17 05:30:00	QQQ	ETF	183.67	183.68	183.65	183.65	5100.0
2018-09-17 06:00:00	QQQ	ETF	183.66	183.66	183.6	183.6	3875.0
2018-09-17 06:30:00	QQQ	ETF	183.59	183.67	183.59	183.63	9010.0
2018-09-17 07:00:00	QQQ	ETF	183.69	183.73	183.65	183.69	19162.0
2018-09-17 07:30:00	QQQ	ETF	183.69	183.69	183.46	183.57	24443.0
2018-09-17 08:00:00	QQQ	ETF	183.7	183.7	183.47	183.47	186090.0
2018-09-17 08:30:00	QQQ	ETF	183.5	183.61	183.43	183.6	86818.0
2018-09-17 09:00:00	QQQ	ETF	183.58	183.66	183.52	183.64	77359.0
2018-09-17 09:30:00	QQQ	ETF	183.64	183.81	182.64	182.95	3727979.0
2018-09-17 10:00:00	QQQ	ETF	182.95	182.97	182.07	182.42	3604166.0
2018-09-17 10:30:00	QQQ	ETF	182.43	182.52	181.78	181.98	2862868.0
2018-09-17 11:00:00	QQQ	ETF	181.9789	182.51	181.93	182.21	2156317.0
2018-09-17 11:30:00	QQQ	ETF	182.19	182.5109	182.17	182.47	1288569.0
2018-09-17 12:00:00	QQQ	ETF	182.47	182.74	182.44	182.61	947208.0

> showing 50 of 16,149 rows — these rows as CSV

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