PREVIEW / etf_30min / 2019-06-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-25.parquet
  size:    506 KB
  rows:    17,744

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-25 04:00:00	SPY	ETF	293.22	293.34	293.15	293.3	4684.0
2019-06-25 04:30:00	SPY	ETF	293.4	293.55	293.23	293.23	3584.0
2019-06-25 05:00:00	SPY	ETF	293.2	293.3	293.2	293.28	1300.0
2019-06-25 05:30:00	SPY	ETF	293.41	293.41	293.34	293.34	1721.0
2019-06-25 06:00:00	SPY	ETF	293.33	293.33	293.24	293.3	2102.0
2019-06-25 06:30:00	SPY	ETF	293.28	293.43	293.2	293.39	30368.0
2019-06-25 07:00:00	SPY	ETF	293.39	293.52	293.39	293.5	48090.0
2019-06-25 07:30:00	SPY	ETF	293.47	293.5	293.32	293.48	137579.0
2019-06-25 08:00:00	SPY	ETF	293.49	293.56	292.93	293.4	151673.0
2019-06-25 08:30:00	SPY	ETF	293.38	293.74	293.37	293.69	44297.0
2019-06-25 09:00:00	SPY	ETF	293.69	293.91	293.68	293.68	126481.0
2019-06-25 09:30:00	SPY	ETF	293.7	293.73	292.68	293.0749	5963994.0
2019-06-25 10:00:00	SPY	ETF	293.08	293.16	292.37	292.78	3580283.0
2019-06-25 10:30:00	SPY	ETF	292.78	292.9144	292.22	292.43	3746601.0
2019-06-25 11:00:00	SPY	ETF	292.42	292.83	292.22	292.605	4835286.0
2019-06-25 11:30:00	SPY	ETF	292.61	292.7	292.41	292.55	1341732.0
2019-06-25 12:00:00	SPY	ETF	292.54	292.78	292.38	292.53	3175714.0
2019-06-25 12:30:00	SPY	ETF	292.54	292.59	291.76	291.89	4379549.0
2019-06-25 13:00:00	SPY	ETF	291.9	292.16	291.28	292.08	5435795.0
2019-06-25 13:30:00	SPY	ETF	292.08	292.46	291.84	291.8501	3572293.0
2019-06-25 14:00:00	SPY	ETF	291.85	291.96	291.43	291.47	3619060.0
2019-06-25 14:30:00	SPY	ETF	291.46	291.5	290.72	291.31	6212795.0
2019-06-25 15:00:00	SPY	ETF	291.31	291.555	290.94	291.31	4875976.0
2019-06-25 15:30:00	SPY	ETF	291.3	291.4	290.64	290.79	16812911.0
2019-06-25 16:00:00	SPY	ETF	290.79	291.8424	290.75	290.79	9038007.0
2019-06-25 16:30:00	SPY	ETF	290.79	290.92	290.79	290.87	180216.0
2019-06-25 17:00:00	SPY	ETF	290.9	290.96	290.86	290.86	41529.0
2019-06-25 17:30:00	SPY	ETF	290.85	290.86	290.77	290.81	105922.0
2019-06-25 18:00:00	SPY	ETF	290.83	290.98	290.82	290.98	129435.0
2019-06-25 18:30:00	SPY	ETF	290.98	291.06	290.96	291.06	21685.0
2019-06-25 19:00:00	SPY	ETF	291.07	291.09	290.7	290.71	54296.0
2019-06-25 19:30:00	SPY	ETF	290.71	290.77	290.38	290.62	125287.0
2019-06-25 04:00:00	QQQ	ETF	187.76	187.8	187.71	187.78	16200.0
2019-06-25 04:30:00	QQQ	ETF	187.76	187.91	187.67	187.67	7904.0
2019-06-25 05:00:00	QQQ	ETF	187.72	187.77	187.67	187.67	8100.0
2019-06-25 05:30:00	QQQ	ETF	187.81	187.82	187.73	187.73	3100.0
2019-06-25 06:00:00	QQQ	ETF	187.7	187.8	187.64	187.8	4509.0
2019-06-25 06:30:00	QQQ	ETF	187.75	187.82	187.65	187.81	4949.0
2019-06-25 07:00:00	QQQ	ETF	187.93	187.95	187.84	187.9	37412.0
2019-06-25 07:30:00	QQQ	ETF	187.9	187.96	187.78	187.94	37401.0
2019-06-25 08:00:00	QQQ	ETF	187.88	188.03	187.37	187.9501	43598.0
2019-06-25 08:30:00	QQQ	ETF	187.97	188.1399	187.97	188.1	20745.0
2019-06-25 09:00:00	QQQ	ETF	188.08	188.2	188.01	188.01	47415.0
2019-06-25 09:30:00	QQQ	ETF	188.05	188.14	187.2	187.48	2501407.0
2019-06-25 10:00:00	QQQ	ETF	187.48	187.61	186.8786	187.2	2241848.0
2019-06-25 10:30:00	QQQ	ETF	187.19	187.26	186.37	186.56	2128284.0
2019-06-25 11:00:00	QQQ	ETF	186.58	186.7785	186.4	186.61	920015.0
2019-06-25 11:30:00	QQQ	ETF	186.62	186.7063	186.44	186.56	856010.0
2019-06-25 12:00:00	QQQ	ETF	186.55	186.82	186.51	186.62	688494.0
2019-06-25 12:30:00	QQQ	ETF	186.62	186.67	185.8106	185.91	1548425.0

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

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