PREVIEW / etf_30min / 2019-05-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-16.parquet
  size:    495 KB
  rows:    17,329

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
2019-05-16 04:00:00	SPY	ETF	284.67	285.04	284.49	285.04	4255.0
2019-05-16 04:30:00	SPY	ETF	284.83	285.25	284.83	285.23	4348.0
2019-05-16 05:00:00	SPY	ETF	285.42	285.42	285.2	285.2	7036.0
2019-05-16 05:30:00	SPY	ETF	285.36	285.63	285.27	285.63	8219.0
2019-05-16 06:00:00	SPY	ETF	285.67	286.4	285.65	286.38	27910.0
2019-05-16 06:30:00	SPY	ETF	286.36	286.5	286.16	286.35	71083.0
2019-05-16 07:00:00	SPY	ETF	286.35	286.58	286.26	286.36	169584.0
2019-05-16 07:30:00	SPY	ETF	286.38	286.47	286.05	286.3	290453.0
2019-05-16 08:00:00	SPY	ETF	286.47	286.53	284.48	286.13	229153.0
2019-05-16 08:30:00	SPY	ETF	286.2	286.48	286.02	286.16	349247.0
2019-05-16 09:00:00	SPY	ETF	286.13	286.14	285.72	285.83	505837.0
2019-05-16 09:30:00	SPY	ETF	285.84	287.76	285.76	287.63	7555853.0
2019-05-16 10:00:00	SPY	ETF	287.63	288.37	287.57	288.35	6083516.0
2019-05-16 10:30:00	SPY	ETF	288.35	288.58	288.12	288.5491	4877604.0
2019-05-16 11:00:00	SPY	ETF	288.545	288.83	288.19	288.58	3825162.0
2019-05-16 11:30:00	SPY	ETF	288.5775	289.04	288.5	288.81	4107553.0
2019-05-16 12:00:00	SPY	ETF	288.81	289.21	288.68	288.85	3360014.0
2019-05-16 12:30:00	SPY	ETF	288.85	288.99	288.41	288.57	3714554.0
2019-05-16 13:00:00	SPY	ETF	288.58	288.78	288.26	288.61	2785217.0
2019-05-16 13:30:00	SPY	ETF	288.6	288.62	287.98	288.13	2668730.0
2019-05-16 14:00:00	SPY	ETF	288.125	288.61	287.88	288.59	3008868.0
2019-05-16 14:30:00	SPY	ETF	288.5925	288.6998	288.04	288.31	2953319.0
2019-05-16 15:00:00	SPY	ETF	288.3	288.3	287.61	287.965	5056808.0
2019-05-16 15:30:00	SPY	ETF	287.96	287.97	287.1	287.63	12835366.0
2019-05-16 16:00:00	SPY	ETF	287.63	287.79	287.55	287.66	8570431.0
2019-05-16 16:30:00	SPY	ETF	287.66	287.84	287.61	287.77	1360908.0
2019-05-16 17:00:00	SPY	ETF	287.8	287.91	287.74	287.82	140284.0
2019-05-16 17:30:00	SPY	ETF	287.86	287.89	287.7	287.82	38666.0
2019-05-16 18:00:00	SPY	ETF	287.81	287.93	287.7	287.82	112319.0
2019-05-16 18:30:00	SPY	ETF	287.82	287.83	287.7	287.83	26534.0
2019-05-16 19:00:00	SPY	ETF	287.84	287.92	287.76	287.76	10766.0
2019-05-16 19:30:00	SPY	ETF	287.85	288.05	287.83	288.02	27733.0
2019-05-16 04:00:00	QQQ	ETF	182.75	182.99	182.5	182.99	20646.0
2019-05-16 04:30:00	QQQ	ETF	182.93	183.2	182.93	183.09	9300.0
2019-05-16 05:00:00	QQQ	ETF	183.2	183.35	183.15	183.17	5200.0
2019-05-16 05:30:00	QQQ	ETF	183.15	183.5	183.15	183.45	10720.0
2019-05-16 06:00:00	QQQ	ETF	183.52	184.11	183.5	184.09	75654.0
2019-05-16 06:30:00	QQQ	ETF	184.11	184.18	183.85	184.01	29741.0
2019-05-16 07:00:00	QQQ	ETF	184.0	184.18	183.95	184.06	54423.0
2019-05-16 07:30:00	QQQ	ETF	184.07	184.1	183.69	183.88	94728.0
2019-05-16 08:00:00	QQQ	ETF	184.1399	184.15	182.2	183.56	250847.0
2019-05-16 08:30:00	QQQ	ETF	183.57	183.8	183.3	183.45	220556.0
2019-05-16 09:00:00	QQQ	ETF	183.43	183.48	182.97	183.12	345598.0
2019-05-16 09:30:00	QQQ	ETF	183.12	184.71	182.95	184.6	4751975.0
2019-05-16 10:00:00	QQQ	ETF	184.61	185.335	184.46	185.335	4232623.0
2019-05-16 10:30:00	QQQ	ETF	185.33	185.7	185.31	185.63	2108416.0
2019-05-16 11:00:00	QQQ	ETF	185.63	185.75	185.29	185.51	1937812.0
2019-05-16 11:30:00	QQQ	ETF	185.5	186.0	185.44	185.86	2022036.0
2019-05-16 12:00:00	QQQ	ETF	185.87	186.07	185.67	185.79	1931906.0
2019-05-16 12:30:00	QQQ	ETF	185.795	185.95	185.38	185.5	1514671.0

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

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