PREVIEW / etf_30min / 2019-04-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-16.parquet
  size:    497 KB
  rows:    17,519

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-16 04:00:00	SPY	ETF	290.75	291.0	290.75	290.9	12245.0
2019-04-16 04:30:00	SPY	ETF	290.85	291.09	290.85	291.08	6295.0
2019-04-16 05:00:00	SPY	ETF	291.08	291.08	290.85	290.86	15210.0
2019-04-16 05:30:00	SPY	ETF	290.88	291.0	290.82	290.88	11740.0
2019-04-16 06:00:00	SPY	ETF	290.9	291.02	290.8	290.8	18580.0
2019-04-16 06:30:00	SPY	ETF	290.82	290.91	290.8	290.9	24468.0
2019-04-16 07:00:00	SPY	ETF	290.87	290.98	290.78	290.94	145481.0
2019-04-16 07:30:00	SPY	ETF	290.9	290.97	290.88	290.94	164312.0
2019-04-16 08:00:00	SPY	ETF	290.96	291.07	290.5	291.01	211959.0
2019-04-16 08:30:00	SPY	ETF	291.03	291.03	290.86	290.91	222896.0
2019-04-16 09:00:00	SPY	ETF	290.92	291.03	290.88	290.94	221553.0
2019-04-16 09:30:00	SPY	ETF	290.95	291.01	290.52	290.65	6292157.0
2019-04-16 10:00:00	SPY	ETF	290.655	290.82	290.41	290.57	3423469.0
2019-04-16 10:30:00	SPY	ETF	290.56	290.58	290.19	290.285	2795585.0
2019-04-16 11:00:00	SPY	ETF	290.28	290.56	290.17	290.42	2484818.0
2019-04-16 11:30:00	SPY	ETF	290.42	290.42	290.17	290.29	2299769.0
2019-04-16 12:00:00	SPY	ETF	290.29	290.4985	290.2699	290.3319	1952923.0
2019-04-16 12:30:00	SPY	ETF	290.335	290.51	290.245	290.47	1376315.0
2019-04-16 13:00:00	SPY	ETF	290.475	290.475	290.31	290.32	1368843.0
2019-04-16 13:30:00	SPY	ETF	290.33	290.385	290.11	290.22	1995262.0
2019-04-16 14:00:00	SPY	ETF	290.22	290.305	290.01	290.3	6420946.0
2019-04-16 14:30:00	SPY	ETF	290.31	290.38	290.21	290.35	1651897.0
2019-04-16 15:00:00	SPY	ETF	290.35	290.46	290.23	290.29	2990210.0
2019-04-16 15:30:00	SPY	ETF	290.28	290.28	289.5	290.18	11751876.0
2019-04-16 16:00:00	SPY	ETF	290.19	290.29	289.88	290.21	3517636.0
2019-04-16 16:30:00	SPY	ETF	290.21	290.27	290.07	290.07	145165.0
2019-04-16 17:00:00	SPY	ETF	290.08	290.19	290.0	290.13	75170.0
2019-04-16 17:30:00	SPY	ETF	290.12	290.16	289.97	290.02	40924.0
2019-04-16 18:00:00	SPY	ETF	290.03	290.06	289.91	289.93	16210.0
2019-04-16 18:30:00	SPY	ETF	289.96	290.06	289.89	289.9	15699.0
2019-04-16 19:00:00	SPY	ETF	289.93	290.05	289.91	290.05	8971.0
2019-04-16 19:30:00	SPY	ETF	290.05	290.09	290.0	290.02	6409.0
2019-04-16 04:00:00	QQQ	ETF	186.59	186.62	186.54	186.56	13764.0
2019-04-16 04:30:00	QQQ	ETF	186.59	186.71	186.54	186.71	4710.0
2019-04-16 05:00:00	QQQ	ETF	186.7	186.7	186.55	186.55	8577.0
2019-04-16 05:30:00	QQQ	ETF	186.6	186.66	186.51	186.51	40100.0
2019-04-16 06:00:00	QQQ	ETF	186.66	186.66	186.54	186.54	10340.0
2019-04-16 06:30:00	QQQ	ETF	186.6	186.63	186.56	186.61	13600.0
2019-04-16 07:00:00	QQQ	ETF	186.57	186.63	186.46	186.51	40452.0
2019-04-16 07:30:00	QQQ	ETF	186.47	186.57	186.45	186.55	32386.0
2019-04-16 08:00:00	QQQ	ETF	186.62	186.7	186.15	186.59	88136.0
2019-04-16 08:30:00	QQQ	ETF	186.54	186.56	185.88	186.54	231491.0
2019-04-16 09:00:00	QQQ	ETF	186.53	186.64	186.47	186.49	112963.0
2019-04-16 09:30:00	QQQ	ETF	186.51	186.6	186.3179	186.55	2107208.0
2019-04-16 10:00:00	QQQ	ETF	186.56	186.91	186.55	186.77	2797447.0
2019-04-16 10:30:00	QQQ	ETF	186.77	186.79	186.36	186.55	1515641.0
2019-04-16 11:00:00	QQQ	ETF	186.56	186.8	186.44	186.57	1194005.0
2019-04-16 11:30:00	QQQ	ETF	186.56	186.58	186.35	186.47	894885.0
2019-04-16 12:00:00	QQQ	ETF	186.46	186.59	186.42	186.57	541827.0
2019-04-16 12:30:00	QQQ	ETF	186.5738	186.71	186.46	186.68	623448.0

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

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