PREVIEW / etf_30min / 2018-10-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-22.parquet
  size:    481 KB
  rows:    16,727

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-10-22 04:00:00	SPY	ETF	276.76	276.91	276.35	276.35	56364.0
2018-10-22 04:30:00	SPY	ETF	276.49	276.61	276.27	276.41	35405.0
2018-10-22 05:00:00	SPY	ETF	276.45	276.77	276.45	276.6	44254.0
2018-10-22 05:30:00	SPY	ETF	276.6	276.65	276.25	276.3	32648.0
2018-10-22 06:00:00	SPY	ETF	276.3	276.85	276.16	276.85	68850.0
2018-10-22 06:30:00	SPY	ETF	276.81	277.01	276.6	276.97	91100.0
2018-10-22 07:00:00	SPY	ETF	276.93	277.14	276.86	277.07	190914.0
2018-10-22 07:30:00	SPY	ETF	277.06	277.47	277.06	277.18	155617.0
2018-10-22 08:00:00	SPY	ETF	277.21	277.47	276.25	277.25	321393.0
2018-10-22 08:30:00	SPY	ETF	277.23	277.24	276.95	276.99	187973.0
2018-10-22 09:00:00	SPY	ETF	276.97	277.05	276.68	277.0	727625.0
2018-10-22 09:30:00	SPY	ETF	277.0	277.36	275.07	275.36	8714440.0
2018-10-22 10:00:00	SPY	ETF	275.36	275.49	274.41	274.65	8118193.0
2018-10-22 10:30:00	SPY	ETF	274.64	276.78	274.42	276.395	8982093.0
2018-10-22 11:00:00	SPY	ETF	276.38	276.57	275.66	275.98	6024880.0
2018-10-22 11:30:00	SPY	ETF	275.98	276.0998	274.89	275.17	4589268.0
2018-10-22 12:00:00	SPY	ETF	275.18	275.83	274.59	274.97	5070620.0
2018-10-22 12:30:00	SPY	ETF	274.97	275.56	274.74	275.3799	3847899.0
2018-10-22 13:00:00	SPY	ETF	275.3715	277.19	275.15	275.32	2843566.0
2018-10-22 13:30:00	SPY	ETF	275.305	275.89	275.07	275.0838	2786453.0
2018-10-22 14:00:00	SPY	ETF	275.08	275.52	275.01	275.04	2940647.0
2018-10-22 14:30:00	SPY	ETF	275.04	275.8	274.94	275.55	4252791.0
2018-10-22 15:00:00	SPY	ETF	275.55	276.14	275.39	275.78	4510490.0
2018-10-22 15:30:00	SPY	ETF	275.77	276.1485	275.04	275.06	9845063.0
2018-10-22 16:00:00	SPY	ETF	275.06	276.1	274.73	274.91	6510391.0
2018-10-22 16:30:00	SPY	ETF	274.91	275.0	274.87	274.97	253396.0
2018-10-22 17:00:00	SPY	ETF	274.95	275.0	274.89	274.94	35668.0
2018-10-22 17:30:00	SPY	ETF	274.93	275.01	274.86	274.86	162671.0
2018-10-22 18:00:00	SPY	ETF	274.87	275.01	274.75	274.9	57448.0
2018-10-22 18:30:00	SPY	ETF	274.93	275.01	274.91	274.97	17795.0
2018-10-22 19:00:00	SPY	ETF	275.0	275.02	274.6	274.74	27324.0
2018-10-22 19:30:00	SPY	ETF	274.77	274.77	274.45	274.52	27871.0
2018-10-22 04:00:00	QQQ	ETF	173.72	173.89	173.49	173.58	35248.0
2018-10-22 04:30:00	QQQ	ETF	173.58	173.68	173.4	173.45	22835.0
2018-10-22 05:00:00	QQQ	ETF	173.45	173.75	173.45	173.75	6650.0
2018-10-22 05:30:00	QQQ	ETF	173.64	173.67	173.38	173.46	14180.0
2018-10-22 06:00:00	QQQ	ETF	173.48	173.8	173.38	173.8	30530.0
2018-10-22 06:30:00	QQQ	ETF	173.8	173.97	173.7	173.94	28732.0
2018-10-22 07:00:00	QQQ	ETF	173.85	174.12	173.83	174.04	79005.0
2018-10-22 07:30:00	QQQ	ETF	174.04	174.44	174.04	174.27	160859.0
2018-10-22 08:00:00	QQQ	ETF	173.8576	174.4	173.26	174.28	513952.0
2018-10-22 08:30:00	QQQ	ETF	174.28	174.28	174.05	174.07	144286.0
2018-10-22 09:00:00	QQQ	ETF	174.04	174.09	173.77	174.03	145825.0
2018-10-22 09:30:00	QQQ	ETF	174.05	174.58	172.6	172.9	6261755.0
2018-10-22 10:00:00	QQQ	ETF	172.9	173.45	172.59	172.88	4797058.0
2018-10-22 10:30:00	QQQ	ETF	172.87	175.2485	172.68	174.87	6302458.0
2018-10-22 11:00:00	QQQ	ETF	174.87	175.17	174.41	174.67	3559626.0
2018-10-22 11:30:00	QQQ	ETF	174.67	174.74	173.77	174.07	2367830.0
2018-10-22 12:00:00	QQQ	ETF	174.09	174.57	173.49	173.85	2529110.0
2018-10-22 12:30:00	QQQ	ETF	173.85	174.45	173.7801	174.255	2636168.0

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

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