PREVIEW / etf_30min / 2019-04-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-15.parquet
  size:    476 KB
  rows:    16,792

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-04-15 04:00:00	SPY	ETF	290.01	290.11	290.0	290.11	950.0
2019-04-15 05:00:00	SPY	ETF	290.19	290.28	290.18	290.28	2514.0
2019-04-15 05:30:00	SPY	ETF	290.28	290.37	290.28	290.36	2600.0
2019-04-15 06:30:00	SPY	ETF	290.36	290.36	290.26	290.3	1544.0
2019-04-15 07:00:00	SPY	ETF	290.34	290.35	290.24	290.35	6625.0
2019-04-15 07:30:00	SPY	ETF	290.4	290.46	290.25	290.3	58595.0
2019-04-15 08:00:00	SPY	ETF	290.2699	290.4199	290.0	290.16	256322.0
2019-04-15 08:30:00	SPY	ETF	290.23	290.24	290.08	290.18	96386.0
2019-04-15 09:00:00	SPY	ETF	290.21	290.37	290.2	290.26	157959.0
2019-04-15 09:30:00	SPY	ETF	290.24	290.35	289.65	289.81	4192555.0
2019-04-15 10:00:00	SPY	ETF	289.81	289.95	289.52	289.53	5019843.0
2019-04-15 10:30:00	SPY	ETF	289.5215	289.53	289.075	289.39	4747985.0
2019-04-15 11:00:00	SPY	ETF	289.395	289.7	289.29	289.6027	3947343.0
2019-04-15 11:30:00	SPY	ETF	289.61	289.62	289.325	289.405	1667853.0
2019-04-15 12:00:00	SPY	ETF	289.405	289.44	289.14	289.33	1849113.0
2019-04-15 12:30:00	SPY	ETF	289.325	289.495	289.32	289.43	1181767.0
2019-04-15 13:00:00	SPY	ETF	289.435	289.77	289.42	289.76	2454520.0
2019-04-15 13:30:00	SPY	ETF	289.76	289.9	289.74	289.855	2529799.0
2019-04-15 14:00:00	SPY	ETF	289.8583	289.94	289.795	289.825	1808783.0
2019-04-15 14:30:00	SPY	ETF	289.825	289.92	289.6885	289.905	2020388.0
2019-04-15 15:00:00	SPY	ETF	289.9	290.1	289.87	289.99	2295887.0
2019-04-15 15:30:00	SPY	ETF	289.98	290.03	289.73	289.99	6408343.0
2019-04-15 16:00:00	SPY	ETF	289.99	290.05	289.91	290.04	6800359.0
2019-04-15 16:30:00	SPY	ETF	290.02	290.08	289.96	290.04	718835.0
2019-04-15 17:00:00	SPY	ETF	290.05	290.06	290.0	290.01	50964.0
2019-04-15 17:30:00	SPY	ETF	290.01	290.02	289.99	290.01	29226.0
2019-04-15 18:00:00	SPY	ETF	290.01	290.11	290.01	290.1	64374.0
2019-04-15 18:30:00	SPY	ETF	290.08	290.08	290.02	290.07	5602.0
2019-04-15 19:00:00	SPY	ETF	290.04	290.05	290.04	290.04	4227.0
2019-04-15 19:30:00	SPY	ETF	290.03	290.05	290.0	290.0	8939.0
2019-04-15 04:00:00	QQQ	ETF	185.68	185.72	185.64	185.64	17650.0
2019-04-15 04:30:00	QQQ	ETF	185.74	185.74	185.74	185.74	11995.0
2019-04-15 05:00:00	QQQ	ETF	185.77	185.82	185.77	185.82	800.0
2019-04-15 05:30:00	QQQ	ETF	185.86	185.97	185.86	185.97	16595.0
2019-04-15 06:00:00	QQQ	ETF	185.86	185.86	185.86	185.86	500.0
2019-04-15 06:30:00	QQQ	ETF	185.88	185.9	185.79	185.79	4100.0
2019-04-15 07:00:00	QQQ	ETF	185.85	185.85	185.75	185.82	7306.0
2019-04-15 07:30:00	QQQ	ETF	185.86	185.89	185.77	185.83	38540.0
2019-04-15 08:00:00	QQQ	ETF	185.84	185.95	185.76	185.83	78839.0
2019-04-15 08:30:00	QQQ	ETF	185.8	185.85	185.74	185.79	26250.0
2019-04-15 09:00:00	QQQ	ETF	185.78	185.925	185.78	185.82	56868.0
2019-04-15 09:30:00	QQQ	ETF	185.81	186.07	185.6	185.7	2103903.0
2019-04-15 10:00:00	QQQ	ETF	185.7	185.71	184.9951	185.0	1355901.0
2019-04-15 10:30:00	QQQ	ETF	185.0	185.02	184.62	184.99	2068930.0
2019-04-15 11:00:00	QQQ	ETF	184.995	185.35	184.94	185.3	1079065.0
2019-04-15 11:30:00	QQQ	ETF	185.305	185.31	185.05	185.2201	826352.0
2019-04-15 12:00:00	QQQ	ETF	185.22	185.26	184.96	185.16	612225.0
2019-04-15 12:30:00	QQQ	ETF	185.16	185.29	185.13	185.22	411426.0
2019-04-15 13:00:00	QQQ	ETF	185.2192	185.49	185.21	185.43	570032.0
2019-04-15 13:30:00	QQQ	ETF	185.42	185.58	185.4	185.52	612316.0

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

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