PREVIEW / etf_30min / 2019-06-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-03.parquet
  size:    513 KB
  rows:    18,176

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-06-03 04:00:00	SPY	ETF	273.65	274.01	273.65	274.01	31308.0
2019-06-03 04:30:00	SPY	ETF	273.92	274.24	273.78	274.24	13728.0
2019-06-03 05:00:00	SPY	ETF	274.27	274.6	274.27	274.55	26932.0
2019-06-03 05:30:00	SPY	ETF	274.56	274.64	274.37	274.62	14922.0
2019-06-03 06:00:00	SPY	ETF	274.64	274.84	274.54	274.54	76526.0
2019-06-03 06:30:00	SPY	ETF	274.54	274.54	274.37	274.42	34067.0
2019-06-03 07:00:00	SPY	ETF	274.47	274.91	274.45	274.9	278667.0
2019-06-03 07:30:00	SPY	ETF	274.9	274.93	274.65	274.66	347597.0
2019-06-03 08:00:00	SPY	ETF	274.7	274.93	273.81	274.65	504835.0
2019-06-03 08:30:00	SPY	ETF	274.67	275.19	274.49	275.19	198540.0
2019-06-03 09:00:00	SPY	ETF	275.18	275.38	275.01	275.33	396444.0
2019-06-03 09:30:00	SPY	ETF	275.31	276.17	274.55	274.6	9505646.0
2019-06-03 10:00:00	SPY	ETF	274.58	276.12	274.0	276.07	7897826.0
2019-06-03 10:30:00	SPY	ETF	276.08	276.5521	275.93	276.32	5570980.0
2019-06-03 11:00:00	SPY	ETF	276.31	276.41	275.55	275.85	4017424.0
2019-06-03 11:30:00	SPY	ETF	275.855	276.03	275.08	275.14	3988802.0
2019-06-03 12:00:00	SPY	ETF	275.13	275.29	273.83	273.92	6106508.0
2019-06-03 12:30:00	SPY	ETF	273.925	274.52	273.74	274.03	4619039.0
2019-06-03 13:00:00	SPY	ETF	274.03	275.86	273.68	274.87	8998873.0
2019-06-03 13:30:00	SPY	ETF	274.85	275.1	273.69	274.92	5939049.0
2019-06-03 14:00:00	SPY	ETF	274.92	275.5	274.7	274.92	3710754.0
2019-06-03 14:30:00	SPY	ETF	274.94	275.21	273.75	274.02	4675443.0
2019-06-03 15:00:00	SPY	ETF	274.02	274.46	273.19	273.59	8704874.0
2019-06-03 15:30:00	SPY	ETF	273.61	274.86	273.09	274.58	12651400.0
2019-06-03 16:00:00	SPY	ETF	274.59	275.23	274.54	275.17	5273177.0
2019-06-03 16:30:00	SPY	ETF	275.17	275.6	274.35	275.53	1238023.0
2019-06-03 17:00:00	SPY	ETF	275.57	275.57	274.57	275.54	291306.0
2019-06-03 17:30:00	SPY	ETF	275.51	275.59	275.23	275.59	17350.0
2019-06-03 18:00:00	SPY	ETF	275.58	275.74	275.49	275.5	75220.0
2019-06-03 18:30:00	SPY	ETF	275.48	275.63	274.57	275.46	29246.0
2019-06-03 19:00:00	SPY	ETF	275.5	275.64	275.38	275.55	42216.0
2019-06-03 19:30:00	SPY	ETF	275.56	275.62	275.22	275.3	61700.0
2019-06-03 04:00:00	QQQ	ETF	172.55	172.72	172.51	172.69	41932.0
2019-06-03 04:30:00	QQQ	ETF	172.69	172.9	172.5	172.8	70664.0
2019-06-03 05:00:00	QQQ	ETF	172.89	173.13	172.84	173.11	31615.0
2019-06-03 05:30:00	QQQ	ETF	173.1	173.17	173.01	173.12	41300.0
2019-06-03 06:00:00	QQQ	ETF	173.1	173.32	173.0	173.0	104210.0
2019-06-03 06:30:00	QQQ	ETF	173.03	173.03	172.88	172.94	69966.0
2019-06-03 07:00:00	QQQ	ETF	172.98	173.26	172.91	173.26	217780.0
2019-06-03 07:30:00	QQQ	ETF	173.25	173.29	173.06	173.12	262190.0
2019-06-03 08:00:00	QQQ	ETF	173.02	173.95	172.6	173.1	99138.0
2019-06-03 08:30:00	QQQ	ETF	173.1	173.5	173.09	173.49	168591.0
2019-06-03 09:00:00	QQQ	ETF	173.48	173.95	173.3	173.53	215777.0
2019-06-03 09:30:00	QQQ	ETF	173.52	173.95	171.97	171.97	7766366.0
2019-06-03 10:00:00	QQQ	ETF	171.97	172.67	171.405	172.66	7136926.0
2019-06-03 10:30:00	QQQ	ETF	172.67	172.93	172.45	172.876	3317287.0
2019-06-03 11:00:00	QQQ	ETF	172.87	173.05	172.5	172.85	2702317.0
2019-06-03 11:30:00	QQQ	ETF	172.855	172.95	172.06	172.15	2357684.0
2019-06-03 12:00:00	QQQ	ETF	172.15	172.27	170.64	170.72	4212611.0
2019-06-03 12:30:00	QQQ	ETF	170.73	171.2125	170.54	170.79	3238070.0

> showing 50 of 18,176 rows — these rows as CSV

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