PREVIEW / etf_30min / 2019-04-22

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-22.parquet
  size:    495 KB
  rows:    17,433

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-22 04:00:00	SPY	ETF	289.53	289.53	289.41	289.41	1600.0
2019-04-22 04:30:00	SPY	ETF	289.4	289.4	289.33	289.33	948.0
2019-04-22 05:00:00	SPY	ETF	289.34	289.35	289.29	289.34	2700.0
2019-04-22 05:30:00	SPY	ETF	289.32	289.35	289.32	289.35	950.0
2019-04-22 06:00:00	SPY	ETF	289.37	289.54	289.37	289.44	3696.0
2019-04-22 06:30:00	SPY	ETF	289.49	289.54	289.42	289.42	13500.0
2019-04-22 07:00:00	SPY	ETF	289.45	289.49	289.36	289.4	55596.0
2019-04-22 07:30:00	SPY	ETF	289.4	289.49	289.36	289.43	61214.0
2019-04-22 08:00:00	SPY	ETF	289.45	289.71	289.13	289.22	185254.0
2019-04-22 08:30:00	SPY	ETF	289.23	289.27	289.06	289.12	169005.0
2019-04-22 09:00:00	SPY	ETF	289.11	289.3	289.09	289.15	163253.0
2019-04-22 09:30:00	SPY	ETF	289.17	289.9	289.07	289.87	4506971.0
2019-04-22 10:00:00	SPY	ETF	289.875	290.07	289.53	289.8	3916443.0
2019-04-22 10:30:00	SPY	ETF	289.8	290.03	289.59	289.975	3687760.0
2019-04-22 11:00:00	SPY	ETF	289.98	290.1	289.69	290.055	1859456.0
2019-04-22 11:30:00	SPY	ETF	290.055	290.23	289.98	290.08	1641645.0
2019-04-22 12:00:00	SPY	ETF	290.07	290.12	289.91	290.1	1175489.0
2019-04-22 12:30:00	SPY	ETF	290.1	290.14	290.035	290.0899	801598.0
2019-04-22 13:00:00	SPY	ETF	290.085	290.12	289.92	290.05	1101428.0
2019-04-22 13:30:00	SPY	ETF	290.06	290.19	290.0	290.12	1423333.0
2019-04-22 14:00:00	SPY	ETF	290.13	290.18	290.04	290.0973	986305.0
2019-04-22 14:30:00	SPY	ETF	290.1	290.12	289.96	290.05	1197336.0
2019-04-22 15:00:00	SPY	ETF	290.05	290.14	289.92	290.015	3387670.0
2019-04-22 15:30:00	SPY	ETF	290.02	290.435	290.02	290.31	7346261.0
2019-04-22 16:00:00	SPY	ETF	290.3	290.48	290.15	290.4	4091631.0
2019-04-22 16:30:00	SPY	ETF	290.42	290.63	290.42	290.47	904569.0
2019-04-22 17:00:00	SPY	ETF	290.47	290.47	290.32	290.33	78179.0
2019-04-22 17:30:00	SPY	ETF	290.33	290.48	290.33	290.38	34863.0
2019-04-22 18:00:00	SPY	ETF	290.37	290.47	290.27	290.45	139542.0
2019-04-22 18:30:00	SPY	ETF	290.43	290.49	290.43	290.49	5802.0
2019-04-22 19:00:00	SPY	ETF	290.47	290.55	290.47	290.5	3400.0
2019-04-22 19:30:00	SPY	ETF	290.46	290.46	290.38	290.41	12646.0
2019-04-22 04:00:00	QQQ	ETF	186.9	186.9	186.79	186.86	31889.0
2019-04-22 04:30:00	QQQ	ETF	186.88	186.88	186.8	186.8	2070.0
2019-04-22 05:00:00	QQQ	ETF	186.7	186.86	186.7	186.86	564.0
2019-04-22 05:30:00	QQQ	ETF	186.79	186.83	186.79	186.83	1130.0
2019-04-22 06:00:00	QQQ	ETF	186.94	186.97	186.94	186.95	6700.0
2019-04-22 06:30:00	QQQ	ETF	186.98	186.99	186.92	186.95	4685.0
2019-04-22 07:00:00	QQQ	ETF	186.97	186.98	186.81	186.84	15501.0
2019-04-22 07:30:00	QQQ	ETF	186.85	186.9	186.77	186.77	32718.0
2019-04-22 08:00:00	QQQ	ETF	186.93	187.3	186.46	186.5	116766.0
2019-04-22 08:30:00	QQQ	ETF	186.49	186.57	186.41	186.48	65492.0
2019-04-22 09:00:00	QQQ	ETF	186.45	186.66	186.4401	186.55	63858.0
2019-04-22 09:30:00	QQQ	ETF	186.54	187.09	186.43	187.08	2411887.0
2019-04-22 10:00:00	QQQ	ETF	187.08	187.36	187.01	187.26	1459339.0
2019-04-22 10:30:00	QQQ	ETF	187.26	187.54	187.11	187.52	1042931.0
2019-04-22 11:00:00	QQQ	ETF	187.52	187.6669	187.3	187.65	845860.0
2019-04-22 11:30:00	QQQ	ETF	187.66	187.73	187.57	187.58	477499.0
2019-04-22 12:00:00	QQQ	ETF	187.579	187.68	187.5001	187.66	342361.0
2019-04-22 12:30:00	QQQ	ETF	187.64	187.7	187.54	187.57	303635.0

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

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